db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject Re: no DataSourceFactory configured
Date Mon, 22 Jan 2007 09:07:23 GMT
This usually means that connecting to the database failed. Possible reasons
are
- the database is not started
- the connection url, password or username are wrong in the configuration
file
Loking at your configuration, I am sure whethet mysql accepts connections
without specifying a database user (as you did)

     Thomas

"Pierre-Alain Branger" <pbranger@ccg.unam.mx> schrieb am 20.01.2007
02:04:11:

> 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