"FileMaker ODBC Memory leakage"

[Coolbdy]

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

[IdealData]

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.

[Coolbdy]

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.

[IdealData]

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.

[Coolbdy]

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.

[IdealData]

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

[Coolbdy]

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.

[IdealData]

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.

[Coolbdy]

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.

[Jonathan Monroe]

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

[Coolbdy]

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.........

[Jonathan Monroe]

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

[Coolbdy]

yes Jonathan

this update really working good from first one.

Thanks for help me on this...................

Have a nice day.