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]

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to