I've also seen this problem, in relation to stored procedures. We found that
in development (hopefully the only location in which you will be getting
errors of this type) ensuring that the Trusted Cache is unchecked.
Additionally for some database errors, we need to uncheck the "Maintain
Database Connections" in the datasource connection set up eliminated all need
to stop/start the service. I still am not sure of the cause, but it works
for us.
"Nelson
Winters" To: CF-Talk <[EMAIL PROTECTED]>
<nwinters@minds cc:
pring.com> Subject: Possible insight into JDBC
probs in CFMX
10/08/2002
03:05 PM
Please respond
to cf-talk
I've seen a lot of posting regarding JDBC instability in CFMX. The issue
I've run across (using CFMX with SQL Server) is where a query passes a blank
where a number is expected. I get the following error:
For example, if #Field2# is an empty string then
<cfquery>
sp_UpdTable '#Field1#', #Field2#, '#Field3#'
</cfquery>
becomes
<cfquery>
sp_UpdTable 'Test1', , 'Test3'
</cfquery>
and ColdFusion throws the following error:
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Syntax error at token , , line 0 offset
31.
Once this occurs, all queries will throw this error until coldfusion is
restarted. I've tested this on several servers with identical results on
each. The only solution I've found so far is to simply make sure that this
doesn't happen. This can be a difficult error to debug since you don't
necessarily know which template actually caused the error in the first
place, and that's the only error that matters... all errors after the first
probably had nothing wrong with them. I usually look in the application.log
file to see where a string of error began popping up.
Hope this is useful to someone.
-Nelson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
