Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (herse.apache.org: local policy)
In-Reply-To: <33094.132.248.34.251.1169255051.squirrel@uxmal.cifn.unam.mx>
Subject: Re: no DataSourceFactory configured
To: "Apache Torque Users List" <torque-user@db.apache.org>
Message-ID: 
 <OF01AA774D.0FD5402F-ONC125726B.0031916F-C125726B.00321D8C@seitenbau.net>
From: Thomas Fischer <fischer@seitenbau.net>
Date: Mon, 22 Jan 2007 10:07:23 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable

This usually means that connecting to the database failed. Possible rea=
sons
are
- the database is not started
- the connection url, password or username are wrong in the configurati=
on
file
Loking at your configuration, I am sure whethet mysql accepts connectio=
ns
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 config=
ured
> for the connection BddPortalCCG
>         at
> org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:71=
1)
>         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=F1eone could help, me. Here are the different configuring f=
iles I
> use:
>
> ------------- torque.properties ----------------
>
> torque.database.default =3D BddPortalCCG
> torque.database.BddPortalCCG.adapter =3D mysql
>
> # Using commons-dbcp
> torque.dsfactory.BddPortalCCG.factory =3D
> org.apache.torque.dsfactory.SharedPoolDataSourceFactory
> torque.dsfactory.BddPortalCCG.connection.driver =3D org.gjt.mm.mysql.=
Driver
> torque.dsfactory.BddPortalCCG.connection.url =3D
> jdbc:mysql://localhost:3306/BddPortalCCG
> torque.dsfactory.BddPortalCCG.connection.user =3D
> torque.dsfactory.BddPortalCCG.connection.password =3D
>
>
> ------------- project.properties ----------------
> # The name of the project Torque will generate code for.
> torque.project=3DBddPortalCCG
>
> # The target database platform.
> torque.database=3Dmysql
>
> # The target package to put the generated classes in.
> torque.targetPackage=3Dmx.unam.ccg.BddPortal
>
> # The JDBC URL that Torque can use to create and
> # drop databases if instructed to do so.
> torque.database.createUrl=3Djdbc:mysql://localhost/mysql
>
> # The JDBC URL that will be used to create tables in your database.
> torque.database.buildUrl=3Djdbc:mysql://localhost/BddPortalCCG
>
> # The JDBC URL that will be used to access your database.
> torque.database.url=3Djdbc:mysql://localhost/BddPortalCCG
>
> # The JDBC database driver to use when connecting to your database.
> torque.database.driver=3Dorg.gjt.mm.mysql.Driver
>
> # The administrative username that has sufficient privileges to creat=
e
> # and drop databases and tables that Torque executes at generation ti=
me.
> torque.database.user=3D
>
> # The administrative password for the supplied username.
> torque.database.password=3D
>
> # The hostname or IP address of your database server.
> torque.database.host=3Dlocalhost
>
> # The location of the your *-schema.xml files (see below).
> torque.schema.dir=3D./schema
>
>
> ------------- schema.xml ----------------
> <?xml version=3D"1.0" encoding=3D"ISO-8859-1" standalone=3D"no"?>
> <!DOCTYPE database SYSTEM
>  "http://db.apache.org/torque/dtd/database_3_1.dtd">
>
> <database
>   name=3D"BddPortalCCG">
>
>   <table name=3D"application" description=3D"Book Table">
>     <column
>       name=3D"idApp"
>       required=3D"true"
>       primaryKey=3D"true"
>       type=3D"INTEGER"
>       description=3D"Application Id"/>
>     <column
>       name=3D"nameApp"
>       required=3D"true"
>       type=3D"VARCHAR"
>       size=3D"255"
>       description=3D"Application Name"/>
>     <column
>       name=3D"pathApp"
>       required=3D"true"
>       type=3D"VARCHAR"
>       size=3D"255"
>       description=3D"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