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 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?
The code for method in both places, production appears to be right, but one thing is sure that they are not compiled from same source. as method's parameter names are different. Also when I see code generated by dj compiler it has a different method name as getUserLight however earlier method name was getUser
Do you have some other class with same name ?
Either move your running code to production or put some debug statement in the code on which production server is running to ensure that it is using same class.
Joined: Nov 12, 2008
I'm was very tired when put this code...the UserStorage has a many user set and get methods. This is the correct code:
Joined: Nov 12, 2008
This is the prod. server UserStoage.class decompiled code: