Re: Database persistent storage

Edgar

        Thanks and good to hear from you again.  Ok, I believe that I
can follow this.  A couple of more questions, if I may...

1.  Do I need to create a mysql.ddl file?  If so, where in my directory
structure does that file reside?  Or is it created automatically, or
exist as part of the jackrabbit download?

e.g.

./src/main/java/org/apache/jackrabbit/core/fs/db/derby.ddl
./src/main/java/org/apache/jackrabbit/core/fs/db/postgresql.ddl
./src/main/java/org/apache/jackrabbit/core/fs/db/mssql.ddl
./src/main/java/org/apache/jackrabbit/core/fs/db/mysql.ddl
./src/main/java/org/apache/jackrabbit/core/fs/db/daffodil.ddl
./src/main/java/org/apache/jackrabbit/core/fs/db/default.ddl
./src/main/java/org/apache/jackrabbit/core/state/db/derby.ddl
./src/main/java/org/apache/jackrabbit/core/state/db/postgresql.ddl
./src/main/java/org/apache/jackrabbit/core/state/db/mssql.ddl
./src/main/java/org/apache/jackrabbit/core/state/db/mysql.ddl
./src/main/java/org/apache/jackrabbit/core/state/db/daffodil.ddl
./src/main/java/org/apache/jackrabbit/core/state/db/default.ddl




2.  Will the code in my JackTest.java program

e.g.

      if (!rn.hasNode("testnode"))
      {
        System.out.println("creating testnode");
        Node n=rn.addNode("testnode", "nt:unstructured");
        n.setProperty("testprop", session.getValueFactory().createValue("Hello, 
World."));
        session.save();
      }

for manipulating items be sufficient?  Or do I need to use different
statements?

Thanks again for your time and effort.


On Thu, Dec 15, 2005 at 09:42:28PM -0300, Edgar Poce wrote:
> Hi rick,
> 
>  you can take a look to 
> http://incubator.apache.org/jackrabbit/apidocs/org/apache/jackrabbit/core/state/db/SimpleDbPersistenceManager.html,
>  
> it contains documentation and examples that will help you to configure your 
> jdbc connection.
> 
> br,
> edgar
> 
> milhri@xxxxxxxx wrote:
> >First time mailer...
> >
> >I have successfully downloaded Apache Jackrabbit, and 
> >developed (from a variety of sources) a couple of working 
> >repositories.  Further, I haven't added anything to the standard
> >configuration.  
> >
> >e.g.
> >
> >/home/milhri
> >    JCRTest.java
> >    repotest 
> >    JackTest.java
> >    repotest2
> >
> >/home/milhri/repotest2
> >    jaas.config
> >    repository
> >    repository.xml
> >    versions
> >    workspaces
> >
> >In both cases, I am using local flat files for persistent storage.
> >I need to demo persistent data storage in a database.  
> >
> >Database server        = DB2/6000 8.2.1
> >
> >We currently use this database as persistent storage for a J2EE
> >application.
> >
> >Can someone lend assistance getting a similar example program to 
> >persist data in the database above?  
> >
> >Thanks.
> >
>