Could not create Oracle LOB
588534Jul 17 2007 — edited Jul 17 2007I am getting the following error while a saving a Blob field in the database.Iam using websphere as my application server.
org.springframework.dao.DataAccessResourceFailureException: Could not create Oracle LOB; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: OracleLobCreator needs to work on [oracle.jdbc.OracleConnection], not on [class org.apache.commons.dbcp.cpdsadapter.ConnectionImpl] - specify a corresponding NativeJdbcExtractor
org.springframework.dao.InvalidDataAccessApiUsageException: OracleLobCreator needs to work on [oracle.jdbc.OracleConnection], not on [class org.apache.commons.dbcp.cpdsadapter.ConnectionImpl] - specify a corresponding NativeJdbcExtractor
at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.getOracleConnection(OracleLobHandler.java:360)
at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.createLob(OracleLobHandler.java:328)
at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setBlobAsBytes(OracleLobHandler.java:216)
at org.springframework.orm.hibernate.support.BlobByteArrayType.nullSafeSetInternal(BlobByteArrayType.java:98)
at org.springframework.orm.hibernate.support.AbstractLobType.nullSafeSet(AbstractLobType.java:143)
at net.sf.hibernate.type.CustomType.nullSafeSet(CustomType.java:118)
Please help