0001310: create CMP ejb failed with "Missing IN or OUT parameter at index::.." when prepare statement cache size is greater than 0

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001310

[Resin]

major

always

08-21-06 20:21

08-24-06 09:32

Reporter

gzhu

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Status

closed

Product Version

3.0.19

Summary

0001310: create CMP ejb failed with "Missing IN or OUT parameter at index::.." when prepare statement cache size is greater than 0

Description

Repeatedly creating CMP ejb will fail if the <prepare-statement-cache-size..> is greater than 0. This is happening with Oracle thin driver in ojdbc14.jar, connecting to Oracle 10.2.0 server.

Looks like unclean preparedStatement (with bind objects off) were returned from Connection.prepareStatement(sql), which caused the exceptions thrown at executeUpdate(). It only happens when you have a tight loop to get prepareStatement; a couple of seconds of delay would ease this problem.

A couple of days debugging showed that the culprit was not directly from com.caucho.amber.manager.AmberConnection::_prepareStatementMap.

======== stack trace from the attached test case ==============

com.caucho.ejb.CreateExceptionWrapper: java.sql.SQLException: Missing IN or OUT parameter at index:: 3
   at _ejb.TestEjb.TestEjbCMP__EJB$LocalHome.create(TestEjbCMP__EJB.java:324)
   at _jsp._jsp._test._testEJB__jsp._jspService(_testEJB__jsp.java:39)
   at com.caucho.jsp.JavaPage.service(JavaPage.java:60)
   ......

Additional Information

Attached Files

Relationships

Notes
(0001479) ferg 08-24-06 09:32	The prepared statement cache shouldn't be caching prepared statements with a result type.

Issue History
Date Modified	Username	Field	Change
08-21-06 20:21	gzhu	New Issue
08-21-06 20:51	gzhu	Issue Monitored: gzhu
08-24-06 09:32	ferg	Note Added: 0001479
08-24-06 09:32	ferg	Assigned To	=> ferg
08-24-06 09:32	ferg	Status	new => closed
08-24-06 09:32	ferg	Resolution	open => fixed
08-24-06 09:32	ferg	Fixed in Version	=> 3.0.22

Mantis 1.0.0rc3[^]

30 total queries executed.
26 unique queries executed.