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.