You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by "Pares Fuente, Borja" <bp...@indra.es> on 2007/03/15 18:56:55 UTC
Problem connectiing with oracle db
My name is Borja. I'm a Java developer and i'm starting with Jackrabbit.
I have test the examples from the web and know i want to change them. My question is how can i connect with my oracle data base to store, retrieve and delete byte streams. How can i get started with this? or where can i find documentation about make a connection with oracle.
I have tried to chage the repository.xml and now it is like this:
<Repository>
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="schemaObjectPrefix" value="SIMGE_rep_fs"/>
<param name="url" value="jdbc:oracle:thin://@192.168.12.112:1521:simge"/>
</FileSystem>
<Security appName="Jackrabbit">
<!--
access manager:
class: FQN of class implementing the AccessManager interface
-->
<AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager">
<!-- <param name="config" value="${rep.home}/access.xml"/> -->
</AccessManager>
<LoginModule class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<!-- anonymous user name ('anonymous' is the default value) -->
<param name="anonymousId" value="anonymous"/>
<!--
default user name to be used instead of the anonymous user
when no login credentials are provided (unset by default)
-->
<!-- <param name="defaultUserId" value="superuser"/> -->
</LoginModule>
</Security>
<Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default"/>
<Workspace name="${wsp.name}">
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="schemaObjectPrefix" value="SIMGE_wor_fs_${wsp.name}_"/>
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.db.OraclePersistenceManager">
<param name="schemaObjectPrefix" value="SIMGE_wor_pm_${wsp.name}_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
</Workspace>
<Versioning rootPath="${rep.home}/version">
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="schemaObjectPrefix" value="SIMGE_ver_fs_"/>
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.db.OraclePersistenceManager">
<param name="schemaObjectPrefix" value="SIMGE_ver_pm_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
</Versioning>
</Repository>
and then in my code:
Repository repository = new TransientRepository();
session = repository.login(new SimpleCredentials(username, password.toCharArray()));
and have this excpetion:
ERROR - failed to initialize file system
java.sql.SQLException: argumentos no vĂ¡lidos en la llamada
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:944)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:195)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:307)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.apache.jackrabbit.core.fs.db.DbFileSystem.init(DbFileSystem.java:264)
at org.apache.jackrabbit.core.fs.db.OracleFileSystem.init(OracleFileSystem.java:109)
at org.apache.jackrabbit.core.config.FileSystemConfig.init(FileSystemConfig.java:57)
at org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:271)
at org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:141)
at org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:83)
at org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:240)
at org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:261)
at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:329)
at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:359)
at adap.FirstHop.loginJackRabbit(FirstHop.java:55)
what is missing? i think that it don't find the oracle connection or somethig...
Thank you very much!
Borja.