Issue

• We are getting error Transaction timed out: deadline in the JBoss logs.

org.springframework.transaction.TransactionTimedOutException: Transaction timed out: deadline was Tue Jul 28 17:44:05 ICT 2015
    at org.springframework.transaction.support.ResourceHolderSupport.checkTransactionTimeout(ResourceHolderSupport.java:139)
    at org.springframework.transaction.support.ResourceHolderSupport.getTimeToLiveInMillis(ResourceHolderSupport.java:128)
    at org.springframework.transaction.support.ResourceHolderSupport.getTimeToLiveInSeconds(ResourceHolderSupport.java:112)
    at org.springframework.jdbc.datasource.DataSourceUtils.applyTransactionTimeout(DataSourceUtils.java:226)
    at org.springframework.jdbc.core.JdbcTemplate.applyStatementSettings(JdbcTemplate.java:1049)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:294)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:361)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:365)
....
....

java.sql.SQLException: ORA-01722: invalid number
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
...

• In the application log a connection error is made to the database. The application is slow in navigation and persistent database connection error:

ERROR [stderr] (JBossWeb-threads - 66) Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ERROR [stderr] (JBossWeb-threads - 66) 
[stderr] (JBossWeb-threads - 66)    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
[stderr] (JBossWeb-threads - 66)    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
[stderr] (JBossWeb-threads - 66)    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
....