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.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 = 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.TorqueDataSo 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]
