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)