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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
