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 > > [EMAIL PROTECTED] 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. > > > -- Sincerely, Rick Milheron FLMI,ACS LIDP Consulting, Inc. Phone 630.829.7136 [EMAIL PROTECTED] nihilum in temperantia