OK, so I just figured this one out, the Java exception stack spewed to
the console after "build import" was misleading.

I needed to copy my MySQL JDBC driver jar file into a directory that the
build system knew about.

I'd had it in ..../webapps/WEB-INF/lib where it was dutifully providing
me access to MySQL tables for user access and the coffee database, but
build.xml doesn't list that directory in the it's classpath.

There *is* a property for the hsql.jar which points into that directory.

As a quick hack, I copied the MySQL JDBC JAR file into .../build/lib
and, presto, the import worked successfully (verified by doing a manual
query in MySQL).

FYI

On Wed, 2002-12-04 at 09:53, Eric White wrote:
> sorry, should have given more detail in the original post:
> 
> I'm using the CVS tips from midday on 12/3/02 and I've modified
> torque.properties to include my own torque.properties file as the first
> step, e.g. 
> 
> "include = my-torque.properties"
> 
> and the contents of my-torque.properties are:
> 
> #
> # Changing the default database backend
> #
> 
> ### MySQL
> torque.database.default.adapter=mysql
> torque.dsfactory.default.connection.driver = com.mysql.jdbc.Driver
> torque.dsfactory.default.connection.url =
> jdbc:mysql://localhost:3306/jetspeed
> torque.dsfactory.default.connection.user =  root
> 
> 
> I did *not* comment out all the hypersonic properties in
> torque.properties, assuming (ok.... I assume too much) that since I'd
> included my own properties file at the top of torque.properties anything
> that I'd specified would occlude properties of the same name that
> followed.
> 
> As I modify these properties files I'm trying to find the minimal set of
> changes to produce a customized portal implementation so I don't stomp
> all over my customizations up on each new release (or CVS sync) of
> Jetspeed.
> 
> On Tue, 2002-12-03 at 19:17, David Sean Taylor wrote:
> > 
> > 
> > David Sean Taylor
> > Enterprise Portal Architect
> > Bluesunrise.com
> > [EMAIL PROTECTED]
> > +01 (707) 773 4646
> > 
> > > -----Original Message-----
> > > From: Eric White [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, December 03, 2002 4:11 PM
> > > To: Jetspeed Users List
> > > Subject: trying to import psml to DB from file system
> > >
> > >
> > > subject line says it all.
> > 
> > :-) nice
> > 
> > > I *think* I've followed the instructions at
> > > http://jakarta.apache.org/jetspeed/site/psml_db.html but I'm seeing the
> > > following after doing a "./build.sh import"
> > >
> > > compile:
> > >
> > > import:
> > >      [java] ***** PSML Importer *****
> > >      [java] Exception in thread "main" java.lang.Error: Error in
> > > BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory
> > > configured for the connection default
> > >      [java]       at
> > > org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initCl
> > > ass(BaseTurbineUserPeer.java:146)
> > >      [java]       at
> > > org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clini
> > > t>(BaseTurbineUserPeer.java:125)
> > >      [java]       at
> > > org.apache.jetspeed.services.security.turbine.TurbineUserManagemen
> > > t.getUser(TurbineUserManagement.java:165)
> > >      [java]       at
> > > org.apache.jetspeed.services.JetspeedUserManagement.getUser(Jetspe
> > > edUserManagement.java:98)
> > >      [java]       at
> > > org.apache.jetspeed.services.JetspeedSecurity.getUser(JetspeedSecu
> > > rity.java:265)
> > >      [java]       at
> > > org.apache.jetspeed.services.psmlmanager.PsmlImporter.alreadyImpor
> > > ted(PsmlImporter.java:236)
> > >      [java]       at
> > > org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImpo
> > > rter.java:197)
> > >      [java]       at
> > > org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImp
> > > orter.java:179)
> > >      [java] Java Result: 1
> > >
> > >
> > >
> > > what config item have I missed?
> > 
> > First, what version are you using?
> > 
> > Look at the Torque.properties in webapp/WEB-INF/conf
> > 
> > Make sure all of the Hypersonic lines are commented out, and then:
> > 
> > torque.database.default.adapter=mysql
> > torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
> > torque.dsfactory.default.connection.url =
> > jdbc:mysql://localhost:3306/jetspeed
> > torque.dsfactory.default.connection.user =  root
> > torque.dsfactory.default.connection.password =
> > 
> > 
> > 
> > --
> > To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
> > 
> 
> 
> 
> --
> To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
> 



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to