Hi everybody, I follow your suggestions but I still can not execute my program properly. Following, the different things I did:
- I added torque.properties, actually it was not in it: export CLASSPATH=/home/pbranger/BddPortalCCG/src/conf By the way the tutorial don't mention this step. - I also added torque.properties to the default source package in Net beans. - My database is properly started - Connection url, password and username are right in the configuration file. I just borrow user and password in the mail I sent. Thomas, what do you mean by "I am sure whethet mysql accepts connections without specifying a database user (as you did)"? I can connect to mysql by mysql -u user -p but if I don't specify user I obviously can not connect. Thanks again for your help, Pierre > 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" <[EMAIL PROTECTED]> 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 >> [EMAIL PROTECTED] >> >> --------------------------------------------------------------------- >> 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] > > > Pierre-Alain Branger Program of Computational Genomics Campus Morelos Tel. +52 777 13 100 24 [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
