On 2/19/07, Sriram Narayanan <[EMAIL PROTECTED]> wrote:
On 2/19/07, Stefan Guggisberg <[EMAIL PROTECTED]> wrote:
> hi sriram,
>
> On 2/19/07, Sriram Narayanan <[EMAIL PROTECTED]> wrote:
> > Hi all:
> >
> > I'm using JackRabbit 1.2.1 and the Oracle 14 JDBC driver.
> > My Persistence manger is the OracleDBPersistenceManager.
> >
> > My Persistence section in the repository.xml
> >
> > <PersistenceManager
> > class="org.apache.jackrabbit.core.persistence.db.OraclePersistenceManager">
> > <param name="driver"
value="oracle.jdbc.driver.OracleDriver"/>
> > <param name="url"
value="jdbc:oracle:thin:@dbserver:1521:testing"/>
> > <param name="schema" value="oracle"/>
> > <param name="user" value="scott"/>
> > <param name="password" value="tiger"/>
> > <param name="schemaObjectPrefix"
value="${wsp.name}_"/>
> > <param name="externalBLOBs" value="false"/>
> > </PersistenceManager>
> >
> > After I write content to the database, I get the following content
> > using AquaDataStudioto to check "default_node":
> >
> >
> > NODE_ID NODE_DATA
> > ------------------------------------ ------------
> > cafebabe-cafe-babe-cafe-babecafebabe Err
> > deadbeef-cafe-babe-cafe-babecafebabe Err
> > 78b17301-13ec-4e6c-b100-80798a04b29f Err
> > cdbaa443-6d9f-4b7e-a7e7-8e609ffb1edb Err
> > a14e4770-fbc6-4613-9d6d-1bbc60d33f02 Err
> > 6abbb65d-121f-426f-b6e6-684ac1a0332b Err
> > 6c03006e-4995-43f9-a910-b513c58041ba Err
> > 8479d6cb-3348-4a09-8eac-82d9f3005865 Err
> >
> > When I use Derby, I face no such problems.
> >
> > What might be wrong here ?
>
> i guess that there's nothing wrong at all ;-)
> the application you're refering to is just unable to
> display the binary column data (which is not that
> surprising ;)
>
Thanks :)
In which case, my problem may be something else.
What works:
When I use the following JDBC code, I get a connect and a list of the
tables on the Oracle server:
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection connection =
DriverManager.getConnection("jdbc:oracle:thin:@artemis:1521:jrdb","scott","tiger");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select * from
tab");
while(resultSet.next()){
System.out.println(resultSet.getObject(1));
}
connection.close();
What doesn't work:
When I log on using the following, I see from within Eclipse that the
code execution is stuck at repository.login();
what do you mean by stuck at ... is the call blocking, i.e. doesn't return?
in this case we would need a thread dump.
did you check the log file?
TransientRepository repository = new
TransientRepository("repository.xml","temp");
Session session = repository.login();
Node rootNode = session.getRootNode();
Here is my repository.xml
<Repository>
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/repository"/>
</FileSystem>
<Security appName="Jackrabbit">
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
</AccessManager>
<LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<param name="anonymousId" value="anonymous"/>
</LoginModule>
</Security>
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default"/>
<Workspace name="${wsp.name}">
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}"/>
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.db.OraclePersistenceManager">
<param name="driver"
value="oracle.jdbc.driver.OracleDriver"/>
<param name="url"
value="jdbc:oracle:thin:@dbserver:1521:jrdb"/>
<param name="schema" value="oracle"/>
<param name="user" value="scott"/>
<param name="password" value="tiger"/>
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index"/>
</SearchIndex>
</Workspace>
<Versioning rootPath="${rep.home}/version">
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/version" />
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.db.OraclePersistenceManager">
<param name="driver"
value="oracle.jdbc.driver.OracleDriver"/>
<param name="url"
value="jdbc:oracle:thin:@dbserver:1521:jrdb"/>
<param name="schema" value="oracle"/>
<param name="user" value="scott"/>
<param name="password" value="tiger"/>
<param name="schemaObjectPrefix" value="version_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
</Versioning>
<SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${rep.home}/repository/index"/>
</SearchIndex>
</Repository>
-- Sriram
