services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService
# Select this service to import from File System to the Database (make sure that DatabasePsmlManagerService is selected above)
services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService
Jason, my MySQL database is ok, and in fact, my Jetspeed is using MySQL database, there are 10 tables in the database,
and all Jetspeed users' information are there too. I registered a new user, and it successfully stored into the database, so I think
that there is no problem with my database and mysql's configuration is ok.
Jason Weiss wrote:
torque.project=dbpsml # ---> Is this ok? torque.targetPackage=org.apache.jetspeed.om.dbpsml # ---> Is this ok?
Those are the defaults and I didn't change these on my Sybase ASA impl, so they should be fine.
Did you remember to comment/uncomment the appropriate importer/exporter lines in WEB-INF/conf/JetspeedResources.properties? There were 2 sets- one for PsmlManager and another for the PSML import and export classes. (Essentially you'll be EXPORTing from Castor and IMPORTing into the Database manager).
Assuming you've got everything on your mySQL config setup to match these parameters, I'm not sure what else to suggest. Anyone else have any ideas?
Jason
-----Original Message----- From: Zufeng Huang [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 11:24 AM To: Jetspeed Developers List Subject: Re: "There was no DataSourceFactory ..." error.
$JS/build/torque/dbpsml.properties:
torque.project=dbpsml # ---> Is this ok? torque.targetPackage=org.apache.jetspeed.om.dbpsml # ---> Is this ok?
torque.database=mysql
torque.databaseUrl = jdbc:mysql://localhost:3306/portal torque.databaseDriver = org.gjt.mm.mysql.Driver torque.databaseUser = root torque.databasePassword = password torque.databaseHost = localhost ...... -------------------------------------------------------------------------- -------
$JS/build/torque/build.properties:
torque.database=mysql torque.database.url = jdbc:mysql://localhost:3306/portal torque.database.driver = org.gjt.mm.mysql.Driver torque.database.user = root torque.database.password = password torque.database.host = localhost ...... -------------------------------------------------------------------------- -
$JS/webapp/WEB-INF/conf/Torque.properties:
torque.database.default=default torque.database.default.adapter=mysql
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSou rceFactory
# 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 = org.gjt.mm.mysql.Driver torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/portal torque.dsfactory.default.connection.user = root torque.dsfactory.default.connection.password = password
Jason Weiss wrote:
I'm not sure which file you missed something, but I encountered the same error porting to Sybase ASA database on Monday of this week. I went through the code from start to finish in my case, and once I got each of these 3 files configured properly, EACH to properly represent
Driver URL User id Password Database name
my import was able to connect successfully and the exact error you are posting went away. (Getting the data in was another story as I encountered some database and primary key issues, and a limitation of ASA's ResultSetMetaData functionality).
I'm not a mySQL user, but perhaps you could post your .properties files here and a mySQL guru could double-check you covered each of the configs properly and identically. I'll try to take a gander myself- a 2nd pair of eyes never hurts, but no promises. I installed mySQL once like 3 years ago :-) and haven't used it since.
Jason
-----Original Message----- From: Zufeng Huang [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 10:43 AM To: [EMAIL PROTECTED] Subject: "There was no DataSourceFactory ..." error.
All,
I am trying to import PSML into MySQL database, but error happens when I run #ant import.
import: [java] ***** PSML Importer ***** [java] Exception in thread "main" java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory configured for the connection default
I configured three configuration files to support MySQL, $JS/build/torque/build.properties $JS/build/torque/dbpsml.properties $JS/webapp/WEB-INF/conf/Torque.properties
especially, "torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDat aSo urceFactory" --Is this right?
and my JDBC driver for MySQL works ok,
Anybody can explain what the "no DataSourceFactory" means? and how to solve this problem.
--------------------------------------------------------------------- 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]
