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

dev google-group-archive
1

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: @Michael_Hnat

2

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

3

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 …

MichaOn Wed, Apr 29, 2015 at 11:30 AM, ‘Michael Hnat’ via Lucee < lucee@googlegroups.com> wrote:

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: @Michael_Hnat

–
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+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/070101d0825f%242c10b1e0%24843215a0%24%40bluegras.de
https://groups.google.com/d/msgid/lucee/070101d0825f%242c10b1e0%24843215a0%24%40bluegras.de?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.