Skip navigation
dcoli
dcoli Calculating status...
Currently Being Moderated

Could not find prepared statement with handle 1.

Aug 2, 2012 9:05 AM

Tags: #cfquery #prepared #cfqueryparam

[Macromedia][SQLServer JDBC Driver][SQLServer]Could not find prepared statement with handle 1.

 

I'm getting this error message in what appear to be random ways. The first time I look at a page I might not get it, but the second time I might. I discovered that removing a cfqueryparam tag worked, but that is not really a safe solution. I checked that the cf_sql_type matched the database field, and in one case changed a cf_sql_varchar to a cf_sql_char so it would match a SQL Server nchar(10) field. But still these errors. Any ideas? I've not had any luck Googling this.

 

I should add that I'm running Coldfusion 9 as a Tomcat webapp on a Linux server. The database is SQL Server 2005, I think.

1590 Views   7 Replies   Latest reply: cbestal, Oct 8, 2012 6:43 AM
 
Replies
  • Dan Bracuk
    Currently Being Moderated
    1. Dan Bracuk,
    Aug 2, 2012 9:09 AM   in reply to dcoli
    Report

    hard to say without looking at your code.  However, since you mentioned cfqueryparam, maybe you are sending an empty string without specifying null="true" or something like that.

     
    |
    Mark as:
  • dcoli
    Currently Being Moderated
    2. dcoli,
    Aug 2, 2012 9:14 AM   in reply to Dan Bracuk
    Report

    It's possible there's something in my logic that is doing that ... but it was happening to one query that was referring to a value set at the top of the file (via cfqueryparam) and when I removed that cfqueryparam it started to happen to a different query. And, I should add, the queries in question were working fine for years before on a coldfusion MX server. This is a new page in the app, but the queries are all being included from old working template files.

     
    |
    Mark as:
  • dcoli
    Currently Being Moderated
    3. dcoli,
    Aug 2, 2012 9:17 AM   in reply to dcoli
    Report

    Here's the one that is breaking now:

    <cfquery name="CheckCredentials" datasource="#application.crossreg_dsn#">

                                            SELECT [name_first]+' '+[name_last] as name

                                                        ,p.[uni]

                                                        ,p.email

                                                        ,p.role_id

                                                         ,r.role_name

                                                      ,p.external_program_id

                                              FROM [CrossReg].[dbo].[People] p

                                               INNER JOIN dbo.Roles r on r.role_id = p.role_id

                                              WHERE uni = <cfqueryparam cfsqltype="cf_sql_char" value="#Session.username#">

    </cfquery>

     

    Session.username is being returned from a CAS authentication system. I've never had troubles with it before.

     
    |
    Mark as:
  • dcoli
    Currently Being Moderated
    4. dcoli,
    Aug 2, 2012 9:53 AM   in reply to dcoli
    Report

    Restarting tomcat seemed to clear it up. Still, if anyone knows what that error message means ...

     
    |
    Mark as:
  • dcoli
    Currently Being Moderated
    5. dcoli,
    Aug 10, 2012 2:12 PM   in reply to dcoli
    Report

    It's happening again. And again, restarting tomcat fixed it.

     
    |
    Mark as:
  • ElLocoGatoCF
    Currently Being Moderated
    6. ElLocoGatoCF,
    Sep 14, 2012 6:40 AM   in reply to dcoli
    Report

    Just to let you know that you are not crazy, I have had the same issue in CF9 (standard Windows install) with SQL Server 2005.  I also have not found a solution, and in all cases I have had to remove the <cfqueryparam> tag.  Restarting CF (or, alternately, restarting SQL Server) solves the problem temporarily, but after a few days it always comes back.

     

    If you come across a solution, please update this post!

     
    |
    Mark as:
  • cbestal
    Currently Being Moderated
    7. cbestal,
    Oct 8, 2012 6:43 AM   in reply to ElLocoGatoCF
    Report

    I had the same problem due to a query that errored then all subsequent queries would error as well with this error message

     

    I found this blog post regarding this issue:

     

    http://www.sstwebworks.com/entry.cfm?entry_id=AAF6E42A-F14A-4716-88B98 BD231596CA6

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points