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.TorqueDataS 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.fallbackPr ofile(JetspeedProfilerService.java:502)
at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile (JetspeedProfilerService.java:245)
at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile (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]



Reply via email to