jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Crowder, Phil" <Phil.Crow...@ahlta.ngc.com>
Subject Error Creating Repository in Oracle on JBoss
Date Tue, 15 Jul 2008 19:06:26 GMT
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:11
2)

      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.jav
a:213)

      at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
ent.java:952)

      at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1160)

      at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
dStatement.java:3285)

      at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStateme
nt.java:3390)

      at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryMan
ager.executeStmtInternal(ConnectionRecoveryManager.java:365)

      at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryMan
ager.executeStmtInternal(ConnectionRecoveryManager.java:292)

      at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryMan
ager.executeStmt(ConnectionRecoveryManager.java:257)

      at
org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryMan
ager.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(JCARepos
itoryManager.java:167)

      at
org.apache.jackrabbit.jca.JCARepositoryManager.createRepository(JCARepos
itoryManager.java:75)

      at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createRepository(J
CAManagedConnectionFactory.java:289)

      at
org.apache.jackrabbit.jca.JCAManagedConnectionFactory.createConnectionFa
ctory(JCAManagedConnectionFactory.java:124)

      at
org.jboss.resource.connectionmanager.ConnectionFactoryBindingService.cre
ateConnectionFactory(ConnectionFactoryBindingService.java:128)

      at
org.jboss.resource.connectionmanager.ConnectionFactoryBindingService.sta
rtService(ConnectionFactoryBindingService.java:65)

      at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupp
ort.java:289)

      at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBean
Support.java:245)

      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

      at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.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.jav
a: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(DelegatingMethodAccessor
Impl.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.jav
a: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.jav
a:39)

      at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.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(ModelMBea
nOperationInterceptor.java:142)

      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

      at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav
a: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(DelegatingMethodAccessor
Impl.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(ModelMBea
nOperationInterceptor.java:142)

      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

      at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav
a: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(URLDeploymentSc
anner.java:421)

      at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScan
ner.java:634)

      at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doS
can(AbstractDeploymentScanner.java:263)

      at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(Abst
ractDeploymentScanner.java:336)

      at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupp
ort.java:289)

      at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBean
Support.java:245)

      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

      at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.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.jav
a: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(DelegatingMethodAccessor
Impl.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.jav
a: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.jav
a:39)

      at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.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(ModelMBea
nOperationInterceptor.java:142)

      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

      at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav
a: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

 


Mime
View raw message