jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Klimetschek" <aklim...@day.com>
Subject Re: Error Creating Repository in Oracle on JBoss
Date Tue, 15 Jul 2008 23:39:56 GMT
Hi Phil,

which version of Jackrabbit are you using - or better, how does the
CREATE TABLE statement from the oracle.properties file look like in
your case?

Since you said it does use NUMBER instead of BIGINT I suppose you have
a version in which http://issues.apache.org/jira/browse/JCR-1560 is
fixed already.

Would be helpful if Oracle would indicate which datatype it did not
like. Maybe BLOB is not supported by your Oracle installation (can it
be disabled - no idea...)?

Regards,
Alex

On Tue, Jul 15, 2008 at 9:06 PM, Crowder, Phil
<Phil.Crowder@ahlta.ngc.com> wrote:
> Hello,
>
>
>
> I followed the directions from
> http://wiki.apache.org/jackrabbit/JackrabbitOnJBoss and got Jackrabbit
> running on JBoss with the Darby persistence manager.  When I switch to
> Oracle however I get the following error.  The Oracle.properties file looks
> correct (ie. using Number instead of BigInt).  Also, I was able to run the
> FirstHop example with the OracleBundlePersistenceManager without any errors.
>
>
>
> Any help would be greatly appreciated.
>
>
>
> Thanks,
>
> Phil
>
>
>
>
>
> 14:30:07,935 INFO  [ConnectionRecoveryManager] Driver: Oracle JDBC driver /
> 10.2.0.1.0
>
> 14:30:07,950 ERROR [ConnectionRecoveryManager] could not execute statement,
> reason: ORA-00902: invalid datatype
>
> , state/code: 42000/902
>
> 14:30:07,950 WARN  [DbDataStore] Can not init data store,
> driver=oracle.jdbc.OracleDriver url=jdbc:oracle:thin:@localhost:1521:orcl
> user=JACKRABBIT
>
> java.sql.SQLException: ORA-00902: invalid datatype
>
>
>
>       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:288)
>
>       at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
>
>       at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
>
>       at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)
>
>       at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
>
>       at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
>
>       at
> oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
>
>       at
> org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:365)
>
>       at
> org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:292)
>
>       at
> org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:257)
>
>       at
> org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:237)
>
>       at
> org.apache.jackrabbit.core.data.db.DbDataStore.init(DbDataStore.java:489)
>
>       at
> org.apache.jackrabbit.core.RepositoryImpl.createDataStore(RepositoryImpl.java:655)
>
>       at
> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:270)
>
>       at
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:550)
>
>       at
> org.apache.jackrabbit.jca.JCARepositoryManager$Reference.create(JCARepositoryManager.java:167)
>
>       at
> org.apache.jackrabbit.jca.JCARepositoryManager.createRepository(JCARepositoryManager.java:75)
>
>       at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createRepository(JCAManagedConnectionFactory.java:289)
>
>       at
> org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createConnectionFactory(JCAManagedConnectionFactory.java:124)
>
>       at
> org.jboss.resource.connectionmanager.ConnectionFactoryBindingService.createConnectionFactory(ConnectionFactoryBindingService.java:128)
>
>       at
> org.jboss.resource.connectionmanager.ConnectionFactoryBindingService.startService(ConnectionFactoryBindingService.java:65)
>
>       at
> org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
>
>       at
> org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
>
>       at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
>
>       at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>       at java.lang.reflect.Method.invoke(Method.java:597)
>
>       at
> org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
>
>       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
>
>       at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
>
>       at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
>
>       at
> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
>
>       at $Proxy0.start(Unknown Source)
>
>       at
> org.jboss.system.ServiceController.start(ServiceController.java:417)
>
>       at
> org.jboss.system.ServiceController.start(ServiceController.java:435)
>
>       at
> org.jboss.system.ServiceController.start(ServiceController.java:435)
>
>       at
> org.jboss.system.ServiceController.start(ServiceController.java:435)
>
>       at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
>
>       at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>       at java.lang.reflect.Method.invoke(Method.java:597)
>
>       at
> org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
>
>       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
>
>       at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
>
>       at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
>
>       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
>
>       at $Proxy4.start(Unknown Source)
>
>       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
>
>       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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
>
>       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
>
>       at
> org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
>
>       at
> org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
>
>       at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
>
>       at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
>
>       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
>
>       at $Proxy51.start(Unknown Source)
>
>       at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
>
>       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
>
>       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
>
>       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
>
>       at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
>
>       at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>       at java.lang.reflect.Method.invoke(Method.java:597)
>
>       at
> org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
>
>       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
>
>       at
> org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
>
>       at
> org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
>
>       at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
>
>       at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
>
>       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
>
>       at $Proxy9.deploy(Unknown Source)
>
>       at
> org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
>
>       at
> org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
>
>       at
> org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
>
>       at
> org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
>
>       at
> org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
>
>       at
> org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
>
>       at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
>
>       at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>       at java.lang.reflect.Method.invoke(Method.java:597)
>
>       at
> org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
>
>       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
>
>       at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
>
>       at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
>
>       at
> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
>
>       at $Proxy0.start(Unknown Source)
>
>       at
> org.jboss.system.ServiceController.start(ServiceController.java:417)
>
>       at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
>
>       at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>       at java.lang.reflect.Method.invoke(Method.java:597)
>
>       at
> org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
>
>       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
>
>       at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
>
>       at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
>
>       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
>
>       at $Proxy4.start(Unknown Source)
>
>       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
>
>       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
>
>       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
>
>       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
>
>       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
>
>       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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
>
>       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
>
>       at
> org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
>
>       at
> org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
>
>       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
>
>       at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
>
>       at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
>
>       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
>
>       at $Proxy5.deploy(Unknown Source)
>
>       at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
>
>       at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
>
>       at org.jboss.Main.boot(Main.java:200)
>
>       at org.jboss.Main$1.run(Main.java:508)
>
>       at java.lang.Thread.run(Thread.java:619)
>
> 14:30:08,013 ERROR [RepositoryImpl] failed to start Repository: Can not init
> data store, driver=oracle.jdbc.OracleDriver
> url=jdbc:oracle:thin:@localhost:1521:orcl user=JACKRABBIT: ORA-00902:
> invalid datatype
>
>



-- 
Alexander Klimetschek
alexander.klimetschek@day.com

Mime
View raw message