db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Kromkamp" <r.kromk...@pagelink.nl>
Subject RE: no DataSourceFactory configured
Date Mon, 22 Jan 2007 08:38:51 GMT
Hi Pierre,

Everything seems to be ok! Is the torque.properties in your classpath?

Regards,
Robert

-----Original Message-----
From: Pierre-Alain Branger [mailto:pbranger@ccg.unam.mx] 
Sent: Saturday, January 20, 2007 2:04 AM
To: torque-user@db.apache.org
Subject: no DataSourceFactory configured

Hi everybody,

I follow the tutorial and could generate my mysql database and the corresponding java access
classes. I made a jar and add it to a java project that compiled well. But when I launch my
application I obtain the following message:

java.lang.NullPointerException: There was no DataSourceFactory configured for the connection
BddPortalCCG
        at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:711)
        at org.apache.torque.Torque.getConnection(Torque.java:268)
        at
org.apache.torque.util.Transaction.beginOptional(Transaction.java:80)
        at org.apache.torque.util.Transaction.begin(Transaction.java:62)
        at
mx.unam.ccg.BddPortal.BaseApplication.save(BaseApplication.java:361)
        at
mx.unam.ccg.BddPortal.BaseApplication.save(BaseApplication.java:343)
        at testbddportalccg.Main.main(Main.java:36)

I hope soƱeone could help, me. Here are the different configuring files I
use:

------------- torque.properties ----------------

torque.database.default = BddPortalCCG
torque.database.BddPortalCCG.adapter = mysql

# Using commons-dbcp
torque.dsfactory.BddPortalCCG.factory =
org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.BddPortalCCG.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.BddPortalCCG.connection.url
= jdbc:mysql://localhost:3306/BddPortalCCG
torque.dsfactory.BddPortalCCG.connection.user = torque.dsfactory.BddPortalCCG.connection.password
=


------------- project.properties ---------------- # The name of the project Torque will generate
code for.
torque.project=BddPortalCCG

# The target database platform.
torque.database=mysql

# The target package to put the generated classes in.
torque.targetPackage=mx.unam.ccg.BddPortal

# The JDBC URL that Torque can use to create and # drop databases if instructed to do so.
torque.database.createUrl=jdbc:mysql://localhost/mysql

# The JDBC URL that will be used to create tables in your database.
torque.database.buildUrl=jdbc:mysql://localhost/BddPortalCCG

# The JDBC URL that will be used to access your database.
torque.database.url=jdbc:mysql://localhost/BddPortalCCG

# The JDBC database driver to use when connecting to your database.
torque.database.driver=org.gjt.mm.mysql.Driver

# The administrative username that has sufficient privileges to create # and drop databases
and tables that Torque executes at generation time.
torque.database.user=

# The administrative password for the supplied username.
torque.database.password=

# The hostname or IP address of your database server.
torque.database.host=localhost

# The location of the your *-schema.xml files (see below).
torque.schema.dir=./schema


------------- schema.xml ---------------- <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!DOCTYPE database SYSTEM  "http://db.apache.org/torque/dtd/database_3_1.dtd">

<database
  name="BddPortalCCG">

  <table name="application" description="Book Table">
    <column
      name="idApp"
      required="true"
      primaryKey="true"
      type="INTEGER"
      description="Application Id"/>
    <column
      name="nameApp"
      required="true"
      type="VARCHAR"
      size="255"
      description="Application Name"/>
    <column
      name="pathApp"
      required="true"
      type="VARCHAR"
      size="255"
      description="Application Path"/>
  </table>
</database>

Thanks for your help,

Pierre-Alain Branger
Program of Computational Genomics
Campus Morelos
Tel. +52 777 13 100 24
pbranger@ccg.unam.mx

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message