Hi
Java Gurus!
Sorry for my bad english!
I use this java code
stmt = connection.prepareStatement("SELECT * FROM USRD WHERE USID=?");
stmt.setInt(1, userId.intValue());
I everywhere (localhost, production server,
test server) use
Tomcat 6 and JDK 6 and Oracle 10g.When Tomcat 6 server start 1 reseived this exception:
2008-11-07 09:41:56,215 [Thread-24] ERROR com.gfth.cemidms.download.server.DownloadLimitReset :: sql exception occured, try rollback
java.sql.SQLException: Hi�nyz� IN vagy OUT param�ter a k�vetkezo indexn�l:: 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1769)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3464)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3514)
at com.gfth.cemidms.storage.UserStorage.getUser(UserStorage.java:719)
at com.gfth.cemidms.storage.DownloadLimitStorage.resetAll(DownloadLimitStorage.java:98)
at com.gfth.cemidms.download.server.DownloadLimitReset.execute(DownloadLimitReset.java:20)
at com.gfth.cemidms.storage.StorageHelper.executeTransaction(StorageHelper.java:102)
at com.gfth.cemidms.storage.StorageHelper.execute(StorageHelper.java:70)
at com.gfth.cemidms.download.server.DownloadLimitReset.run(DownloadLimitReset.java:25)
at com.gfth.cemidms.download.server.DownloadLimitResetScheduler.run(DownloadLimitResetScheduler.java:59)
This error only occured the production server, my pc (localhost) everything is ok. I use ojdbc14_g.jar (1.4.2_08). The test and a production server is x64bit architecture, my pc is only 32bit.
If I use the comment stmt.setInt() line, then i received this exception on localhost too.
I found 2 site the same problem
http://forums.bea.com/thread.jspa?threadID=600015631 http://forums.sun.com/thread.jspa?forumID=48&threadID=720264 I don't understand why occured this error only the production server. The stms is PreparedStatement, and this is fine works other place in my code.Can anybody found this problem?
I found Oracle Drivers:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html I use this driver version: Oracle Database 10g Release 2 (10.2.0.3)
JDBC Drivers
ojdbc14_g.jar (1,938,906 bytes) - same as ojdbc14.jar, except that classes were compiled with "javac -g" and contain some tracing information. I'm use this.
I found the driver last version: Oracle Database 10g Release 2 (10.2.0.4) JDBC Drivers
ojdbc14_g.jar (1,950,033 bytes) - same as ojdbc14.jar, except that classes were compiled with "javac -g" and contain some tracing information.
The "Missing IN or OUT paramteres" exception possibe driver problem?
Many thanks in advance.
George