we try to configurate Eventsubsystem.
we have following installation:
Teamsite 6.5
OpenDeploy 6.0.1
on Solaris
in iweventsubd.log the following lines appear:
iweventsubd: ---------- STARTING: Thu Apr 14 12:25:55 MEST 2005
EVENTSUBD_HOME is set to /tui/iw/iw-home/eventsubsystem
OpenJMS 0.7.6.1
The OpenJMS Group. (C) 1999-2004. All rights reserved.
http://openjms.sourceforge.netorg.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: Schema needs to be converted from version=V0.6.1 to version=V0.7.6
Back up your database, and run 'dbtool -migrate'to convert the schema
at org.exolab.jms.persistence.RDBMSAdapter.<init>(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.<init>(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.instance(Unknown Source)
at org.exolab.jms.server.JmsServer.registerServices(Unknown Source)
at org.exolab.jms.server.JmsServer.init(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)
Question:
if we run 'dbtool -migrate' to convert the schema - What is this tool doing?? Which schema is meant? What permissions are necessary?
_____________
on page:
http://openjms.sourceforge.net/config/jdbc.htmlwe found the description:
Creating the OpenJMS tables
The 'dbtool application' may be used to create, drop, and recreate the OpenJMS database tables.
To create the tables on Windows, open up a command prompt and type:
cd %OPENJMS_HOME%\bin
dbtool.bat -create -config %OPENJMS_HOME%\config\openjms.xml
On Unix:
cd $OPENJMS_HOME/bin
dbtool.sh -create -config $OPENJMS_HOME/config/openjms.xml
---------------------------------------------
--> What if dbtool doesn't work?
---------------------------------------------
The dbtool application may not support all available JDBC drivers, due to buggy JDBC implementations. In this case, the tables must be manually created. The OpenJMS distribution ships with SQL scripts for most popular databases. These scripts are located in the $OPENJMS_HOME/config/db directory and are named in the form of create_db.sql (e.g create_oracle.sql, create_mysql.sql)
_____________
we do not understand the following:
the log-entry says:
'Schema needs to be converted from version=V0.6.1 to version=V0.7.6'
but
some time ago we already run create_sybase.sql
after that we did a new installation of Teamsite 6.5 but kept OpenDeploy installation and now have problems to configurate EventSubsystem.
_____________
we will run create_sybase.sql again
and will see whether it helps...
_____________
problem solved:
we run create_sybase.sql again
and configurated eventSubsystem according to description in ts.650.admin.unix.pdf
now dd works.
Edited by h_b on 04/14/05 08:14 AM (server time).
