aspose file tools*
The moose likes JDBC and the fly likes JBoss throws this exception ORA-01858:a non-numeric character was found where a numeric was expected Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JBoss throws this exception ORA-01858:a non-numeric character was found where a numeric was expected" Watch "JBoss throws this exception ORA-01858:a non-numeric character was found where a numeric was expected" New topic
Author

JBoss throws this exception ORA-01858:a non-numeric character was found where a numeric was expected

Prasan Pai
Greenhorn

Joined: Jun 20, 2008
Posts: 5
When this code is included in a standalone application it gives the desired output . Strange fact is that same code works fine in BEA Weblogic also :-



But, when the same code is executed form the code in JBoss application server, it throws the error mentioned below:-

15:54:08,676 ERROR [STDERR] java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected
15:54:08,676 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
15:54:08,676 ERROR [STDERR] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
15:54:08,676 ERROR [STDERR] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
15:54:08,676 ERROR [STDERR] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
15:54:08,676 ERROR [STDERR] at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)
15:54:08,676 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:497)
15:54:08,676 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.getCursorValue(OracleStatement.java:3684)
15:54:08,676 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.java:5704)
15:54:08,676 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.java:5622)
15:54:08,676 ERROR [STDERR] at oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:739
)
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

If only all application servers were created equal. The dirty little secret of J2EE is that moving code from one app server to another is almost always nearly impossible.

As for your example, my guess is there is a library in your class path on JBoss that is interfering with your expected output. Either that or its using a different database driver somewhere.


My Blog: Down Home Country Coding with Scott Selikoff
Prasan Pai
Greenhorn

Joined: Jun 20, 2008
Posts: 5
The solution to this problem was to replace the Oracle driver with the latest version.
I replaced the ojdbc14.jar in the deploy folder with the latest version and redeployed the application. That solved the problem.
Thanks for your suggestion.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JBoss throws this exception ORA-01858:a non-numeric character was found where a numeric was expected