[rules-users] drools guvnor 5.1 - oracle database issue (java.sql.SQLException: ORA-22275)

[Sartaj Shaik]

Hi,

I have deployed drools-5.1.1-guvnor.war in jboss-5.1.0.GA application 
server.

Also, I have changed the repository.xml, workspace.xml in default and 
security folders to use oracle database. When I start the server, all the 
tables are getting created in the database application is working fine.

But, when I restart the server, it is not able to start properly and 
everytime I am getting the following error

..
..
..
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
org.apache.jackrabbit.core.util.db.ResultSetWrapper.invoke(ResultSetWrapper.java:66)
        ... 116 more
Caused by: java.sql.SQLException: ORA-22275: invalid LOB locator specified

        at 
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
        at oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:930)
        at oracle.jdbc.driver.T4C8TTILob.getChunkSize(T4C8TTILob.java:329)
        at 
oracle.jdbc.driver.T4CConnection.getChunkSize(T4CConnection.java:2015)
        at oracle.sql.BLOB.getChunkSize(BLOB.java:389)
        at oracle.sql.BLOB.getBufferSize(BLOB.java:410)
        at oracle.sql.BLOB.getBinaryStream(BLOB.java:229)
        at 
oracle.jdbc.driver.BlobAccessor.getBinaryStream(BlobAccessor.java:209)
        at 
oracle.jdbc.driver.OracleResultSetImpl.getBinaryStream(OracleResultSetImpl.java:886)
        at 
org.apache.commons.dbcp.DelegatingResultSet.getBinaryStream(DelegatingResultSet.java:222)
        at 
org.apache.commons.dbcp.DelegatingResultSet.getBinaryStream(DelegatingResultSet.java:222)
        ... 121 more


Any ideas to resolve this issue?
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20110224/a8d34ce8/attachment.html