Hi again David, Building Jetspeed with DB Registry works fine but what I don't get to work is the registry import. When I run maven I get the error
[java] org.apache.jetspeed.om.registry.RegistryException: Exception Fetching Extent for Portlet org.apache.torque.TorqueException: java.sql.SQLException: No suitable driver Not being the maven expert, I assume I have not configured the db settings correct, or in the correct place. Any ideas? Regards Kristofer Eriksson -----Original Message----- From: David Sean Taylor [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 11:52 PM To: Jetspeed Users List Subject: Re: Database registry implementation status On Aug 11, 2004, at 1:24 AM, Kristofer Eriksson wrote: > David, > > Thanks for the quick answer. For me that sounds really interesting so > if I > want to be able to use this, and I "cant" wait for the 1.6 release, > what is > the best to do, try to implement the Hybrid Registry Service alone or > check > out the JS1-6-2004-07-23-spring-start branch and use it? How much > implications would that have any implications on the stability in > general? > Its not a branch, just a tag Not necessary to use that Just go straight to the CVS head for now as that is most stable regarding this feature When you say implement the Hybrid Registry Service, I assume you mean implement the remaining registries (skins, controls, controllers. mediatypes)? > And would it be possible to share with us how to configure the Hybrid > Registry Service? What config files needs to be changed and/or added? > Look at the JetspeedResources.properties Instructions for Building Jetspeed with DB Registry -------------------------------------------------------------------- 1. Checkout from the CVS head 2. Set these properties in your $HOME/build.properties: database = YOUR DATABASE (oracle|mysql) etc Here is for MS SQL for example # MS SQL torque.database.url = jdbc:microsoft:sqlserver://localhost:1433;databaseName=jetspeed torque.database.driver =torque.database.url = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.database.user = jetspeed torque.database.password = ***** org.apache.jetspeed.test.jdbc.j1.drivers.path=${HOME}/bluesunrise/ apache/jdbc/ msbase.jar org.apache.jetspeed.test.jdbc.j1.drivers.path2=${HOME}/bluesunrise/ apache/ jdbc/msutil.jar org.apache.jetspeed.test.jdbc.j1.drivers.path3=${HOME}/bluesunrise/ apache/ jdbc/mssqlserver.jar 3. Update the Torque properties in WEB-INF/conf torque.database.default.adapter=mssql torque.dsfactory.default.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.dsfactory.default.connection.url = jdbc:microsoft:sqlserver://localhost:1433;databaseName=jetspeed torque.dsfactory.default.connection.user = jetspeed torque.dsfactory.default.connection.password = ***** 4. Build Jetspeed maven -Dmaven.test.skip=true clean war 4b. maven torque:sql This will generate the new SQL script: target/classes/sql/registry-schema.sql Run this script using isql.exe or another tool 5. Change over to Registry DB, edit JetspeedResources.properties: # uncomment these lines services.Registry.database.default.Security=DATABASE services.Registry.database.default.Portlet=DATABASE # choose the Hybrid Service # # services.Registry.classname=org.apache.jetspeed.services.registry.Castor RegistryService services.Registry.classname=org.apache.jetspeed.services.registry.Hybrid RegistryService 6. Run the importer maven -o registry-import 7. after successful import, delete the old registry files admin.xreg demo-portlets.xreg email.xreg fusion.xreg portlets.xreg security.xreg wml-examples.xreg 8. Deploy maven deploy --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
