No that shouldn't matter (I'm assuming you are running on mysql 4... :p ) Maybe you have made a mistake in your db configuration... Check webapp/WEB-INF/conf/torque.properties. Here are my settings for mysql:
torque.database.default=default torque.database.default.adapter=mysql ### 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 = Also check your log: webapp/WEB-INF/log/jetspeed.log, but unfortunately the ProfileException doesn't log a lot of detail. I guess it's a bit of trial and error... -Stijn ----- Original Message ----- From: "John & Emer Jennings" <[EMAIL PROTECTED]> To: "Jetspeed Users List" <[EMAIL PROTECTED]> Sent: Friday, June 18, 2004 3:35 AM Subject: Re: Error Migrating from Hypersonic-SQL to MySQL database > Thanks for your fast response Stijn, > > I did populate and the database is all there as per the scripts with 3 > users, jetspeed, tommy and anon, and I can query them via a PHP web > page using the configured account details. > > I did however use the turbine-mysql-4.sql script, would that make any > difference as opposed to the turbine-mysql.sql script? > > Thanks, JJ > > On 18/06/2004, at 11:09 AM, Stijn de Witt wrote: > > > Check if the turbine tables are created. use the commands > > > > use <databasename>; > > show tables; > > > > in mysql. If it does not show a table named turbine user, that > > explains it. > > If that is the case, you need to execute the scripts > > src/sql/external/turbine-mysql.sql and > > src/sql/external/populate-mysql.sql. > > Also, look here: > > http://portals.apache.org/jetspeed-1/database.html > > > > Hope that helps, > > -Stijn > > > > ----- Original Message ----- > > From: "John & Emer Jennings" <[EMAIL PROTECTED]> > > To: "Jetspeed Users List" <[EMAIL PROTECTED]> > > Sent: Friday, June 18, 2004 2:48 AM > > Subject: Error Migrating from Hypersonic-SQL to MySQL database > > > > > >> Hi, > >> > >> Im getting the following error migrating from Hypersonic-SQL to MySQL > >> database > >> > >> org.apache.jetspeed.om.profile.ProfileException: > >> java.lang.NullPointerException > >> > >> I noted some other users with the same problem but I couldn't see any > >> response or suggestions. > >> > >> Re The Mail Archive > >> > >> Same problem at; > >> http://www.mail-archive.com/jetspeed-user%40jakarta.apache.org/ > >> msg12178.html > >> > >> I'm a complete newbe to Jetspeed and mail lists so apologies if I've > >> missed the replies, I'm just looking to use Jetspeed. > >> > >> > >> What am I doing wrong? Would greatly appreciate any help to end > >> sleepless nights. > >> > >> Configuration details below. > >> > >> > >> Cheers, JJ > >> > >> ------------------------------------------ > >> John Jennings > >> > >> [EMAIL PROTECTED] > >> ------------------------------------------ > >> > >> Error migrating from Hypersonic-SQL to MySQL database > >> ********************************************* > >> > >> Using jakarta-tomcat-5.0.25 binary version on a Mac 10.3.4 > >> > >> MySQL version 4.0.18-standard > >> > >> Default install seems to work fine out-of-the-box. > >> > >> ********************************************* > >> Installation - Database Configuration > >> http://portals.apache.org/jetspeed-1/install.html > >> > >> 'modify BOTH the project.properties in the root directory and the > >> webapp/WEB-INF/conf/Torque.properties file...' > >> > >> There was no project.properties, I assume because I'm using a binary > >> install? (Did try using one though but it didn't make any difference > >> and since I'm not using Maven I don't expect it to do anything??.) > >> > >> ********************************************* > >> Mods to Torque.properties > >> > >> #MySQL configured JJ 15/06/2004 > >> torque.database.default=jetspeed > >> ## torque.database.default.adapter=hypersonic > >> torque.database.default.adapter=mysql > >> ### torque.database.default.adapter=oracle > >> ### torque.database.default.adapter=mssql > >> > >> ## > >> ## Using torque's old pool > >> ## > >> #MySQL configured JJ 15/06/2004 - commented out the fields below > >> > >> ## torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver > >> ## torque.dsfactory.default.connection.url = > >> jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed > >> ## torque.dsfactory.default.connection.user = sa > >> ## torque.dsfactory.default.connection.password = > >> > >> torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDat > >> aS > >> ourceFactory > >> # The number of database connections to cache per ConnectionPool > >> instance (specified per database) > >> torque.dsfactory.default.pool.defaultMaxConnections=10 > >> torque.dsfactory.default.pool.maxExpiryTime=3600 > >> torque.dsfactory.default.pool.connectionWaitTimeout=10 > >> > >> ### MySQL > >> #MySQL configured JJ 15/06/2004 - uncommented the fields below > >> > >> 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 = phpuser > >> torque.dsfactory.default.connection.password = phppass > >> > >> ********************************************* > >> Built the jetspeed database in MySQL using the scripts > >> populate-mysql.sql and turbine-mysql-4.sql. > >> > >> Seemed to build and populate correctly. Can connect & query jetspeed > >> database via PHP from web page using above account details. > >> > >> Another Java app running on Tomcat - contineo - connnects to its MySQL > >> database OK using the above parameters. > >> > >> Copying contineo have put mysql-connector-java-3.0.11-stable-bin.jar > >> in > >> directory as per below; > >> > >> /usr/local/jakarta-tomcat-5.0.25/webapps/jetspeed/WEB-INF/lib/mysql- > >> connector-java-3.0.11-stable-bin.jar > >> > >> Made no difference. > >> > >> ********************************************* > >> http://localhost:8080/jetspeed/ > >> > >> Jetspeed opens with the following error; > >> > >> There has been an Error! > >> Reason: > >> org.apache.jetspeed.om.profile.ProfileException: > >> java.lang.NullPointerException > >> > >> Get/Post Data: > >> > >> template = /html/ShowError.vm > >> > >> Stacktrace: > >> > >> org.apache.jetspeed.om.profile.ProfileException: > >> java.lang.NullPointerException > >> at > >> org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallback > >> Pr > >> ofile(JetspeedProfilerService.java:502) > >> at > >> org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfi > >> le > >> (JetspeedProfilerService.java:245) > >> at > >> org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfi > >> le > >> (JetspeedProfilerService.java:528) > >> at > >> org.apache.jetspeed.services.Profiler.getProfile(Profiler.java:87) > >> ... > >> > >> ********************************************* > >> > >> > >> --------------------------------------------------------------------- > >> 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] > > > > > > > --------------------------------------------------------------------- > 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]
