jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Borja Parés (JIRA) <j...@apache.org>
Subject [jira] Updated: (JCR-794) Creating an oracle connection
Date Thu, 15 Mar 2007 17:12:09 GMT

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

Borja Parés updated JCR-794:
----------------------------

    Description: 
 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

  was:
 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.



> Creating an oracle connection
> -----------------------------
>
>                 Key: JCR-794
>                 URL: https://issues.apache.org/jira/browse/JCR-794
>             Project: Jackrabbit
>          Issue Type: Task
>    Affects Versions: 1.2.3
>            Reporter: Borja Parés
>
>  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.


Mime
View raw message