Mantis Bugtracker
  

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID 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[^]
Copyright © 2000 - 2005 Mantis Group
30 total queries executed.
26 unique queries executed.
Powered by Mantis Bugtracker