• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
)

 
author
Posts: 4335
39
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic