CF MX6.1 Pro and Informix 7.31

[ywc]

I am trying to configure the IBM Informix JDBC driver so we don't have to use
the ODBC connection between Windows 2000 box and the Informix database resides
in a Sun box which hangs from time to time.

[url]http://www.macromedia.com/support/coldfusion/ts/documents/config_ibm_informix.ht[/url]
m

I have the datasource connection works fine. ColdFusion application runs OK
with regular select queries. But when I tried to write to a temp table in
database, I got "Method Can be called only once" error. I have not test update
and delete yet.

The driver version I am using is "3.00JC2" which is the most current. There
was a post dated April 2004 specify a different version of driver that can fix
the problem. I have tried, but same error without luck.

[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&thread[/url]
id=780851&highlight_key=y&keyword1=Method%20can%20 be%20called%20only%20once

Does anyone out there experiences the same problem before and know how to fix
it? Does this a driver problem?

Many thanks in advance for any response.


yc

[jumajii]

Can you post the code?

Marco

[ywc]

I found that this problem happens whenever I have a query that write data to a
temp tables in the database. Sometimes, we need to store user input in a temp
table, after we process the data, we then drop the table.
For pages that involve static tables, they work just fine.
Sorry I can't post the code here.
Thanks.

Wendy

[jumajii]

Ok Wendy,
first you needed of create the temporary table.
You can perform this in two ways:
with the :"select .... into temp" statement
or
with the explicit: "create temp table".
For you necessary i think that the second is the right way.
You can test this code:

<cfquery name="firststep" datasource="#Application.youDsn#">
create temp table tmpTest (userid char(30))
</cfquery>

<cfif isDefined("Form.userid") and Form.userid NEQ "">

<cfquery name="secondstep" datasource="#Application.youDsn#">
insert into tmpTest values('#Form.userid#')
</cfquery>

<cfquery name="outTest" datasource="#Application.youDsn#">
select * from tmpTest
</cfquery>
<cfdump var="#outTest#">
</cfif>

<cfform name="testTemp" action="">
<cfinput type="text" name="userid">
<input type="submit" name="submit" value="Insert">
</cfform>

Excuse me for my english
Regards

Marco

[ywc]

Yes, I did create the temp table first.
Basically, I run a query to get data I need, loop throught the result, and
enbed the insert statement within the loop.
Everything wroks fine with the ODBC connection, but got strange error with the
JDBC connection. I believe this is a problem with the Informix JDBC driver.
Many thanks to your reply.

ywc

[jumajii]

Look this (informix section):


[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.1a3c2[/url]
ad0&extid=1a3c2ad0&dialogID=14443437&iterationID=1 &sessionID=4830a2fa005259285a7
9&stateID=0+0+14447948&mode=simple

Marco

[Diacritical]

To make this error go away with IBM's drivers, you need JDBC 2.21.JC5X2 or later.

-- DCP

[ywc]

DCP,

I have tried version 3.00.JC2 as well as version 2.21.JC5. The problem never
goes away. (not sure what is JC5X2, here is the site that I had found for all
JDBC drivers
[url]http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc[/url], if
this is not the correct site, please let me know)
If I don't involve temp table, everything is working just fine. As soon as I
touch temp table, I was errored out with 'method can be called only once'
message.
Many thanks for the reply.

yc