Jump to content

"FileMaker ODBC Memory leakage"


Coolbdy
 Share

This topic is 4277 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi everybody,

I m working with FileMaker pro 11,

and i m using FileMaker ODBC API for automation.

i m using FileMaker ODBC 11.00.58.00 driver for this.

When i inserting the records in the filemaker database,

it shows anonymous behaviour,

if i using parametrized query for insertion of data then the size of "fmxdbc_listener.exe" is increasing rapidaly and application get crashed.

elseif i using simple query for insertion of data then my application exe takes 0.1MB memory for every 1000 records insertion, if there are huge of records then it get crashed.

i m using SQLPutData() function for this.

i get frustated with this,

so what should i do now.

regards:

Coolbdy

Link to comment
Share on other sites

There are some other documented instances too

http://forums.filemaker.com/posts/e5ad1e037f

http://forums.filemaker.com/posts/5200b4a528

And I am having the same difficulties.

Link to comment
Share on other sites

Thanks for your reply.

Actually i have lot of problem with this.(for insertion of huge records in database)

and i have need it at any cost.

is there any another solution for this problem?

or by using any plugin(actally i m not sure about this)i can resolve this or not?

if u have anything plz reply me.

and i have a query for u.

i m facing single quote data insertion problem,

when i m inserting data with single quote using insert query then that not occured.

if i using parametrized query then i get memory crash problem.

have u something abt this plz reply me.........

Have a nice day to you.

Link to comment
Share on other sites

MY application is using the Fusion Plugins "Reactor". Here is an error report that it produces

Warning: The following where clause contains parentheses. If these are part of the SQL statement, they will trigger a serious memory leak in FileMaker's SQL engine (parentheses inside string values, or field names are OK).

( "HOLIDAY.MYPAGE"."StagebaseID.Text" = '47' or "HOLIDAY.MYPAGE"."StagebaseID.Text" = '29' )

Seemingly the use of the parenthesis is what sends FMP into a spin.

My SQL knowledge is poor, but I'm trying to work around this.

Link to comment
Share on other sites

Sorry i m not getting you(your last post).

Actually my problem is,

i m using insert query in this way

eg: INSERT INTO tablename VALUES('pan'saddress')

when i excute this query this gives syntax error,

the problem due to single quote between n and s.

if i have bulky text which have various single quote then what should i go for......?

have u info then plz reply.......i m waiting

Thanks to u.

Link to comment
Share on other sites

Sorry i m not getting you(your last post).

Actually my problem is,

i m using insert query in this way

eg: INSERT INTO tablename VALUES('pan'saddress')

when i excute this query this gives syntax error,

the problem due to single quote between n and s.

if i have bulky text which have various single quote then what should i go for......?

have u info then plz reply.......i m waiting

Thanks to u.

I was only explaining that the use of parenthesis () in SQL searches start FMP memory leaking.

Did you try

INSERT INTO tablename VALUES('pan''saddress')

Notice the extra single quote (NOT a double-quote character!!)

(Source: FileMaker Pro > Electronic documentation > fm10_odbc_jdbc_guide_en.pdf > p37)

fm10_odbc_jdbc_guide_en.pdf

Link to comment
Share on other sites

Good morning to u.....

i try that and have that pdf document also.

but i have problem in large text(MB) in which there are various single quotes then how

will i know at which position i add extra quote.

Programically this is possible but it is not more feasible(take more time to scan every character in the String).

if there any another method then pls tell me.

and thanks for your reply.

Link to comment
Share on other sites

Good morning to u.....

i try that and have that pdf document also.

but i have problem in large text(MB) in which there are various single quotes then how

will i know at which position i add extra quote.

Programically this is possible but it is not more feasible(take more time to scan every character in the String).

if there any another method then pls tell me.

and thanks for your reply.

Sorry, this is my limit of SQL knowledge.

Link to comment
Share on other sites

It's ok i am trying this programatically.

but what about first problem(memory leaks in ODBC)

i have send you a message(i think u got that)

i m working on that problem if i do that i'll respond you.

and i m working on SQL functions which are used in the code to insert the data.

Have a nice day to u.

Link to comment
Share on other sites

The recent "11v3" update addresses xDBC memory leaks:

Driver:

http://help.filemaker.com/app/answers/detail/a_id/9363

Server:

http://help.filemaker.com/app/answers/detail/a_id/9283

I believe you will need to install them both (the server and the driver updates). See FileMaker documentation for details.

Jonathan Monroe

Actual Technologies - ODBC for Mac OS X

http://www.actualtech.com

Link to comment
Share on other sites

The recent "11v3" update addresses xDBC memory leaks:

Driver:

http://help.filemaker.com/app/answers/detail/a_id/9363

Server:

http://help.filemaker.com/app/answers/detail/a_id/9283

I believe you will need to install them both (the server and the driver updates). See FileMaker documentation for details.

Jonathan Monroe

Actual Technologies - ODBC for Mac OS X

http://www.actualtech.com

Thanks for reply.

i have installed that (11.03.81.00) and see the result for this,

but my problem is as it is.

When i insert the records using parametrized query.

the size of "fmxbdc_listener.exe" increasing rapidally and get crashed.

is there another method for this?

Have a nice day.........

Link to comment
Share on other sites

i have installed that (11.03.81.00) and see the result for this,

but my problem is as it is.

Did you install the 11.0.3.309 Server update, too (and reboot)?

I believe that both updates are required.

Jonathan Monroe

Actual Technologies - ODBC for Mac OS X

http://www.actualtech.com

Link to comment
Share on other sites

  • 3 weeks later...

This topic is 4277 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.