Has anyone experienced JDBC instability using CFMX? I have an app that runs
fine and then, for no apparent reason (no changes to the CF code, stored
procedure or to any settings on the server), I start getting database errors
and no queries work until I stop and start ColdFusion.
Here's the code where I call the login validation stored procedure:
<cfstoredproc procedure="Util_ValidateLogin" returncode="No"
datasource="#Application.Datasource#" debug="NO" username="sa"
password="awa">
<cfprocparam type="In" dbvarname="@Agency" value="#Form.Agency#"
cfsqltype="CF_SQL_CHAR" maxlength="4" null="no">
<cfprocparam type="In" dbvarname="@Login" value="#Form.Username#"
cfsqltype="CF_SQL_CHAR" maxlength="20" null="no">
<cfprocparam type="In" dbvarname="@Password"
value="#Form.Password#" cfsqltype="CF_SQL_CHAR" maxlength="20"
null="no">
<cfprocresult name="AuthenticateUser" resultset="1">
</cfstoredproc>
I also tried this way with no luck:
<cfquery name="AuthenticateUser" datasource="#Application.Datasource#">
{call Util_ValidateLogin('#Form.Agency#', '#Form.Username#',
'#Form.Password#')}
</cfquery>
Here's the error that shows up in my application.log file:
"Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Syntax
error at token ,, line 0 offset 26.
I'm running CFMX, IIS 5 and SQL 2000 on a Win2000 server.
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
