MSSQL Error "Could not find prepared statement with handle xy."

[Michael Hnat]

Hi,

 

actually we're having a very strange issue and we can't find a solution. I hope someone of you has any idea, hint or workaround.

 

We're caching our SQL Statements with cachedWithin. The Cache is a MemCache, defined in the Lucee WebAdmin.

 

After restarting Lucee everything runs fine. After a few hours suddenly a lot of Errors occur saying: "Could not find prepared statement with handle xy." (where xy is always a different number).

 

This is the connection:

DatabaseName	string Microsoft SQL Server
DatabaseVersion	string 10.00.5520
DriverName	string jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
DriverVersion	string 1.2.8
NativeErrorCode	number 8179

 

 

We already tried switching the Driver, checked the WindowsSystem, etc., etc. Lucee is the latest version from yesterday.

 

Google wasn't helpfull yet. The database itself is running fine, we can't find any problems.

 

Any ideas what could be wrong?

 

Best,

Michi

 

 

Mit herzlichen Grüßen,

Michael Hnat

 

bluegras - Internetlösungen

Kriegerstr. 49

82110 Germering

Tel.: 089 81029340

Fax: 089 81029339

E-Mail: m.h...@bluegras.de

 

[Jeroen Knoef]

Can you test what happens if you don't use cfqueryparam (if you use that)?

[Michael Hnat]

This works.

Because the query isn't put together as prepared statement.

 

We really have no clue why this is happening. We can't see a load problem, since the servers are running fine.

--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/ccd52e85-4696-4d79-9c21-9692b6248fe5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Michael Offner]

we encountered the same problem with a client and we are working on this, atm it looks like it is related to jTDS driver....

Try the MS driver instead ...

Micha

--

You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/070101d0825f%242c10b1e0%24843215a0%24%40bluegras.de.