[jira] Resolved: (JCR-794) Creating an oracle connection

["Jukka Zitting (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/JCR-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jukka Zitting resolved JCR-794.
-------------------------------

    Resolution: Invalid
      Assignee: Jukka Zitting

It seems like your database connection parameters are incorrect. I'm resolving this issue as Invalid since it doesn't seem to be a Jackrabbit issue.

Please use the Jackrabbit user mailing list at users@jackrabbit.apache.org for such configuration issues. The issue tracker should be used when you think you've identified an error in the Jackrabbit implementation or if you want to request some improvement or a new feature.

> Creating an oracle connection
> -----------------------------
>
>                 Key: JCR-794
>                 URL: https://issues.apache.org/jira/browse/JCR-794
>             Project: Jackrabbit
>          Issue Type: Wish
>    Affects Versions: 1.2.3
>            Reporter: Borja Parés
>         Assigned To: Jukka Zitting
>
>  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 modify repository.xml to:
> <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>
> but when i try:
> Repository repository = new TransientRepository();
>     		session = repository.login(
>                     new SimpleCredentials(username, password.toCharArray()));
> iit returns this exception:
> Caused by: 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)
> 	... 11 more
> org.apache.jackrabbit.core.config.ConfigurationException: File system initialization failure.: failed to initialize file system: failed to initialize file system
> 	at org.apache.jackrabbit.core.config.FileSystemConfig.init(FileSystemConfig.java:63)
> 	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)
> 	at adap.FirstHop.main(FirstHop.java:37)
> Caused by: org.apache.jackrabbit.core.fs.FileSystemException: failed to initialize file system
> 	at org.apache.jackrabbit.core.fs.db.DbFileSystem.init(DbFileSystem.java:369)
> 	at org.apache.jackrabbit.core.fs.db.OracleFileSystem.init(OracleFileSystem.java:109)
> 	at org.apache.jackrabbit.core.config.FileSystemConfig.init(FileSystemConfig.java:57)
> 	... 9 more
> what is missing?
> thanks

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.