NullPointerException in OracleLobHandler
Basically, I have 2 servers, one that host the database and the datasource. The other host all the applications and stuffs.
One of my application requires to make use of xmltype in oracle, which is why I'm using a OracleLobHandler. Read the link below for more info.
http://forum.springframework.org/showthread.php?t=29875
The issue here is when my app server retrieve the datasource and tries to do it stuff, it encountered this error below.
Code:
Exception in thread "main" org.springframework.dao.DataAccessResourceFailureException:
Could not create Oracle LOB;
nested exception is org.springframework.dao.InvalidDataAccessApiUsageException:
Couldn't initialize OracleLobHandler because Oracle driver classes are not available. Note that OracleLobHandler requires Oracle JDBC driver 9i or higher!; nested exception is java.lang.NullPointerException
Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: Couldn't initialize OracleLobHandler because Oracle driver classes are not available. Note that OracleLobHandler requires Oracle JDBC driver 9i or higher!; nested exception is java.lang.NullPointerException
Caused by: java.lang.NullPointerException
at org.springframework.jdbc.support.lob.OracleLobHandler.initOracleDriverClasses(OracleLobHandler.java:150)
at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.createLob(OracleLobHandler.java:339)
at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setClobAsString(OracleLobHandler.java:265)
at org.springframework.jdbc.core.support.SqlLobValue.setTypeValue(SqlLobValue.java:190)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:167)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:94)
at org.springframework.jdbc.core.ArgTypePreparedStatementSetter.setValues(ArgTypePreparedStatementSetter.java:68)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:742)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:537)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:738)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:796)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:800)
However, if i put my application/modules onto my datasource/database server, it work perfectly.
Does anyone have encountered it or have any idea on how to work about it???