headers
Shudoman | 8 Jun 2012 17:00

Problems using Oracle

I've sucessfully configured mysql for use as dbDatastore, persistence
manager, and file system.  I'm currently trying to do the same for oracle. 
When I start the system it fails with a stack trace.  The jackrabbit user
has full permission on a pristine table space.  I'm able to log with the
user and perform all the normal SQL operations (create, read, update,
delete).

Any assistance will be greatly appreciated.
My configuration is as follows.

Unbuntu Linux
Java version 1.6.0_26
Jackrabbit 2.4.0
Oracle 10g Release 2
ojdbc14.jar

*This is the repository.xml*

*And here is the offending stack trace.*

2012-06-08 10:00:03,598 ERROR
[org.apache.jackrabbit.core.fs.db.DatabaseFileSystem] failed to initialize
file system
java.lang.NullPointerException
	at oracle.jdbc.driver.T4C8Oall.getNumRows(T4C8Oall.java:870)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1117)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1278)
	at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1950)
(Continue reading)

Permalink | Reply |
headers
Shudoman | 11 Jun 2012 17:29

Re: Problems using Oracle

Still trying different configs.  Now I'm getting:

2012-06-11 11:25:28,983 ERROR
[org.apache.jackrabbit.core.util.db.ConnectionHelper] Failed to execute SQL
(stacktrace on DEBUG log level)
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
	at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
	at
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
	at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
	at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
	at
org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:299)
	at
org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:285)
(Continue reading)

Permalink | Reply |

Gmane