Forums
This topic is locked
MySQL and Coldfusion stored proc error
Posted 14 Mar 2006 08:20:11
1
has voted
14 Mar 2006 08:20:11 Henry Wright posted:
can't return a result set in the given context Why am I receiving this error when running a stored procedure using MySQL and Coldfusion with MySQL JDBC connector. The stored procedure works fine in MySQL command client, but not in Coldfusion MX 7??
Help!!!!
Replies
Replied 14 Mar 2006 11:34:57
14 Mar 2006 11:34:57 Roddy Dairion replied:
Wat procedure are u using?
Replied 15 Mar 2006 01:16:28
15 Mar 2006 01:16:28 Henry Wright replied:
I am using
<cfquery name ="getObjectives datasource = "#Request.MainDSN#">
CALL sp_loadobjectives(variable1, variable2)
</cfquery>
but I think the problem lies with the MySql J connector. I have version 3.0.17 of the jdbc coonector and I don't think this supports stored procedures. When I try and use 3.1.12 JDBC driver I get a connection time out failure.
Aaaaargh!!!
<cfquery name ="getObjectives datasource = "#Request.MainDSN#">
CALL sp_loadobjectives(variable1, variable2)
</cfquery>
but I think the problem lies with the MySql J connector. I have version 3.0.17 of the jdbc coonector and I don't think this supports stored procedures. When I try and use 3.1.12 JDBC driver I get a connection time out failure.
Aaaaargh!!!
Replied 08 Mar 2007 12:31:03
08 Mar 2007 12:31:03 Rajan Kumar replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
can't return a result set in the given context
Why am I receiving this error when running a stored procedure using MySQL and Coldfusion with MySQL JDBC connector. The stored procedure works fine in MySQL command client, but not in Coldfusion MX 7??
Help!!!!
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
can't return a result set in the given context
Why am I receiving this error when running a stored procedure using MySQL and Coldfusion with MySQL JDBC connector. The stored procedure works fine in MySQL command client, but not in Coldfusion MX 7??
Help!!!!
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>