Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Prasan Pai
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Saloon Keeper
Posts: 4015
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Prasan Pai
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic