APAR status
Closed as program error.
Error description
Customer is using MYSQL JDBC driver and is getting error
java.lang.sqlexception parameter with index 1 is not set.
He applied fix pack 2 to WebSphere Application server V5 and
this JDBC driver no longer works. This had worked at base level
and the error points to 1 more parameter than passed to the
JDBC driver.
Local fix
A workaround for this problem is to disable Prepared Statement
Caching, although this workaround does have performance
implications.
Problem summary
****************************************************************
* USERS AFFECTED: Users running WebSphere Application Server *
* 5.0.2 and prior to a MySQL database with *
* Prepared Statement Caching enabled on their *
* J2C-style DataSource. *
****************************************************************
* PROBLEM DESCRIPTION: When attempting to execute a Prepared *
* Statement from the Prepared Statement *
* Cache, the application receives an *
* SQLException with a message stating, *
* "Parameter with index X is not set" *
* where X is a number one higher than *
* the number of parameters in the *
* Prepared Statement. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
Because of the way the Prepared Statement Cache is tracking
parameters, the MySQL database (and possibly others) would
encounter a counting error where the parameter count is one
higher than it should be when the statement is put back in
the Prepared Statement Cache. This would result in the
listed exception the next time the statement was used.
A workaround for this problem is to disable Prepared Statement
Caching, although this workaround does have performance
implications.
Problem conclusion
The parameter tracking information was removed, allowing the
Prepared Statements to execute correctly in the cache.
Temporary fix Comments
APAR information |
APAR number |
PQ80774 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
00W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2003-11-11 |
Closed date |
2003-12-17 |
Last modified date |
2004-08-20 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PQ91121
Modules/Macros
Publications Referenced
Applicable component levels |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
|