[opencms-dev] OpenCMS & Oracle8i - SQLException - invalid LOB locator specified

[Nagendra Reddy]

Hi,
I am trying to setup OpenCMS with Oracle 8i.

Import module is failing with following exception

================================
136: at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
135: at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
134: at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
133: at java.lang.reflect.Method.invoke(Method.java:324)
132: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
131: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
130: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
129: at com.opencms.core.CmsShell.commands(CmsShell.java:168)
128: at com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:78)
127: java.lang.NullPointerException
126: 
125: >>> at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
124: >>> at com.opencms.boot.CmsMain
===================================

Then when I try to access index page using url -
http://localhost:7001/opencms/opencms/index.jsp
<http://localhost:7001/opencms/opencms/index.jsp> , the following error is
thrown. 

Can anyone help me in fixing this problem?

========================================
com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error:
Database init failed. 
root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error.
Detailed error: Critical error while loading resourcebroker. 
root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed
error: [com.opencms.file.oraclesql.CmsDbAccess]ORA-22275: invalid LOB
locator specified
. 
root cause was java.sql.SQLException: ORA-22275: invalid LOB locator
specified

	at com.opencms.core.OpenCms.(OpenCms.java:259)
	at
com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:242)
	at
weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run(ServletStubI
mpl.java:1070)
	at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
	at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
	at
weblogic.servlet.internal.ServletStubImpl.createServlet(ServletStubImpl.java
:893)
	at
weblogic.servlet.internal.ServletStubImpl.createInstances(ServletStubImpl.ja
va:842)
	at
weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.jav
a:782)
	at
weblogic.servlet.internal.ServletStubImpl.getServlet(ServletStubImpl.java:50
4)
	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:349)
	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:305)
	at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:6310)
	at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
	at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
	at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3622)
	at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2569)
	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
>-----------
>Root cause:
>com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed
error: Critical error while loading resourcebroker. 
>root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed
error: [com.opencms.file.oraclesql.CmsDbAccess]ORA-22275: invalid LOB
locator specified
>. 
>root cause was java.sql.SQLException: ORA-22275: invalid LOB locator
specified
>	at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
>	at com.opencms.core.OpenCms.(OpenCms.java:255)
>	at
com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:242)
>	at
weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run(ServletStubI
mpl.java:1070)
>	at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
>	at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
>	at
weblogic.servlet.internal.ServletStubImpl.createServlet(ServletStubImpl.java
:893)
>	at
weblogic.servlet.internal.ServletStubImpl.createInstances(ServletStubImpl.ja
va:842)
>	at
weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.jav
a:782)
>	at
weblogic.servlet.internal.ServletStubImpl.getServlet(ServletStubImpl.java:50
4)
>	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:349)
>	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:305)
>	at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:6310)
>	at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
>	at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
>	at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3622)
>	at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2569)
>	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
>	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
>>-----------
>>Root cause:
>>com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.oraclesql.CmsDbAccess]ORA-22275: invalid LOB locator
specified
>>. 
>>root cause was java.sql.SQLException: ORA-22275: invalid LOB locator
specified
>>	at
com.opencms.file.oraclesql.CmsDbAccess.addUser(CmsDbAccess.java:274)
>>	at
com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2784)
>>	at com.opencms.file.genericSql.CmsDbAccess.(CmsDbAccess.java:300)
>>	at com.opencms.file.oraclesql.CmsDbAccess.(CmsDbAccess.java:79)
>>	at
com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroke
r.java:58)
>>	at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:41
82)
>>	at
com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
>>	at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
>>	at com.opencms.core.OpenCms.(OpenCms.java:255)
>>	at
com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:242)
>>	at
weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run(ServletStubI
mpl.java:1070)
>>	at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
>>	at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
>>	at
weblogic.servlet.internal.ServletStubImpl.createServlet(ServletStubImpl.java
:893)
>>	at
weblogic.servlet.internal.ServletStubImpl.createInstances(ServletStubImpl.ja
va:842)
>>	at
weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.jav
a:782)
>>	at
weblogic.servlet.internal.ServletStubImpl.getServlet(ServletStubImpl.java:50
4)
>>	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:349)
>>	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:305)
>>	at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:6310)
>>	at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
>>	at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
>>	at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3622)
>>	at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2569)
>>	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
>>	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
>>>-----------
>>>Root cause:
>>>java.sql.SQLException: ORA-22275: invalid LOB locator specified
>>>	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>>>	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
>>>	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
>>>	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
>>>	at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
>>>	at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132
)
>>>	at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
>>>	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2877)
>>>	at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:608)
>>>	at
com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStatement.j
ava:177)
>>>	at
com.opencms.file.oraclesql.CmsDbAccess.addUser(CmsDbAccess.java:246)
>>>	at
com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2784)
>>>	at com.opencms.file.genericSql.CmsDbAccess.(CmsDbAccess.java:300)
>>>	at com.opencms.file.oraclesql.CmsDbAccess.(CmsDbAccess.java:79)
>>>	at
com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroke
r.java:58)
>>>	at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:41
82)
>>>	at
com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
>>>	at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
>>>	at com.opencms.core.OpenCms.(OpenCms.java:255)
>>>	at
com.opencms.core.OpenCmsHttpServlet.init(OpenCmsHttpServlet.java:242)
>>>	at
weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run(ServletStubI
mpl.java:1070)
>>>	at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
>>>	at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
>>>	at
weblogic.servlet.internal.ServletStubImpl.createServlet(ServletStubImpl.java
:893)
>>>	at
weblogic.servlet.internal.ServletStubImpl.createInstances(ServletStubImpl.ja
va:842)
>>>	at
weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.jav
a:782)
>>>	at
weblogic.servlet.internal.ServletStubImpl.getServlet(ServletStubImpl.java:50
4)
>>>	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:349)
>>>	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:305)
>>>	at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:6310)
>>>	at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubjec
t.java:317)
>>>	at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
>>>	at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3622)
>>>	at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2569)
>>>	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
>>>	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)

Thanks and Regards,
Nagendra Reddy