I think I remember reading on this list that Torque has problems w/ mysql's driver;
try using org.gjt.mm.mysql.Driver instead. i.e.
torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
hth,
stu
>>> [EMAIL PROTECTED] 03/10/03 12:56AM >>>
Hello,
I have read others' problems connecting with mySql and still can't get
past this error:
Horrible Exception: java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
There was no DataSourceFactory configured for the connection sriportaldb
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.initClass(BaseTurbineUserPeer.java:154)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.<clinit>(BaseTurbineUserPeer.java:128)..........
Here is a snippet from my Torque.properties file:
# -------------------------------------------------------------------
# These are your database settings. Look in the
# org.apache.pool.* packages for more information.
#
# The parameters to connect to the default database. You MUST
# configure these properly.
# -------------------------------------------------------------------
torque.database.default=sriportaldb
#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
##
##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.TorqueDataSourceFactory
# 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
torque.dsfactory.default.connection.driver = com.mysql.jdbc.Driver
torque.dsfactory.default.connection.url =
jdbc:mysql://localhost/sriportaldb?user=xxx&password=xxxx
torque.dsfactory.default.connection.user = xxx
torque.dsfactory.default.connection.password =xxxx
#database.adaptor=DBMM
#database.adaptor.DBMM=org.gjt.mm.mysql.Driver
I can connect and see my sriportaldb database through phpMyAdmin and populated it with
populatemysql
(or whatever it is called) I have tried it with the port (3306) in the connection
string and also
without the username/password parameters. I also saw that someone else solved their
problems with the
#database.adaptor=DBMM
#database.adaptor.DBMM=org.gjt.mm.mysql.Driver
settings but that did not seem to help me.
I also opened up port 3306 on my server to see if that could have something to do with
it
but no dice.
Any other settings in any other file that I need?
Thanks for any help,
Casey
---------------------------------------------------------------------
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]
