For the record, the problem was with the JDBC URL specified in the Castor JDO configuration file that lacked the name of the mySQL database to use (i.e. mydb).
Regards Werner Guttmann John Greene wrote: > Hi Werner, > > Please see lising below: > > Jan 23, 2006 2:21:07 PM org.exolab.castor.jdo.engine.SQLEngine create > INFO: A fatal error occurred while creating/updating project.Student using > SQL: INSERT INTO students (studentid,firstname,lastname,groups) VALUES > (?,?,?,?) > java.sql.SQLException: No database selected > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) > at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067) > at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:683) > at > org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:683) > at org.exolab.castor.persist.LockEngine.create(LockEngine.java:486) > at > org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(Abstrac > tTransactionContext.java:805) > at > org.castor.persist.AbstractTransactionContext.create(AbstractTransactionCont > ext.java:762) > at > org.exolab.castor.jdo.engine.DatabaseImpl.create(DatabaseImpl.java:360) > at project.MyCastor.CreateMedia(MyCastor.java:45) > at project.Main.main(Main.java:27) > > > > > -----Original Message----- > From: Werner Guttmann [mailto:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 02:36 PM > To: [email protected] > Subject: Re: [castor-user] Connection to Database > > > John, > > feel like joining me on IRC (#castor at irc.codehaus.org or > http://irc.codehaus.org) ? > > Werner > > John Greene wrote: > >>Werner, >> >>Here is the complete jdo-config.xml file: >> >><jdo-conf> >><database name="mydb" engine="mysql" > >><driver url="jdbc:mysql://localhost:3306/" >>class-name="com.mysql.jdbc.Driver"> >><param name="user" value="sa" /> >><param name="password" value="password" /> >></driver> >><mapping href="mapping.xml" /> >></database> >><transaction-demarcation mode="local" /> >></jdo-conf> >> >> >>....and my mapping file: >> >><mapping> >><class name="project.Student" identity="studentID"> >><map-to table="students" /> >><field name="studentID" type="int"> >><sql name="studentid" type="integer"/> >></field> >> >><field name="firstName" type="string"> >><sql name="firstname" type="varchar" /> >></field> >> >><field name="lastName" type="string"> >><sql name="lastname" type="varchar" /> >></field> >> >><field name="groups" type="string"> >><sql name="groups" type="varchar" /> >></field> >> >></class> >></mapping> >> >>Thanks >>John >> >> >>-----Original Message----- >>From: Werner Guttmann [mailto:[EMAIL PROTECTED] >>Sent: Monday, January 23, 2006 02:09 PM >>To: [email protected] >>Subject: Re: [castor-user] Connection to Database >> >> >>John, >> >>what does your complete JDO config file look like ? >> >>Regards >>Werner Guttmann >> >>John Greene wrote: >> >> >>>Werner, >>> >>>The database named "john" is a Pointbase database, which is not currently >>>supported by Castor, correct?? >>> >>>The Database named "mydb" is a mySQL database, which Castor does support. >>> >>>As I debug the program the Student class gets created and values are >> >>read; >> >> >>>however the runtime output: >>>SQL: INSERT INTO students (studentid,firstname,lastname,groups) VALUES >>>(?,?,?,?) suggest Castor does not see these values!! >>> >>>Thanks >>>John >>> >>>-----Original Message----- >>>From: Werner Guttmann [mailto:[EMAIL PROTECTED] >>>Sent: Monday, January 23, 2006 01:08 PM >>>To: [email protected] >>>Cc: Werner Guttmann >>>Subject: Re: [castor-user] Connection to Database >>> >>> >>>John, >>> >>>given your JDO config example from further above (read in the original >>>email that started this tread), I do believe that your database is named >>>"john" and not "mydb" ... ;-). >>> >>>Regards >>>Werner Guttmann >>> >>>John Greene wrote: >>> >>> >>> >>>>Okay, I have come a long way and just got one more hurdle to get over: >>>> >>>>This is the error message: >>>> >>>>Jan 23, 2006 12:24:31 PM org.exolab.castor.jdo.engine.SQLEngine create >>>>INFO: A fatal error occurred while creating/updating project.Student > > using > >>>>SQL: INSERT INTO students (studentid,firstname,lastname,groups) VALUES >>>>(?,?,?,?) >>>>java.sql.SQLException: No database selected >>>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) >>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) >>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) >>>> at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) >>>> at >>>> >>> >>> > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) > >>>> at >>>> >>> >>> > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166) > >>>> at >>>> >>> >>> > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082) > >>>> at >>>> >>> >>> > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067) > >>>> at >>> >>>org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:683) >>> >>> >>> >>>> at >>>>org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:683) >>>> at >>> >>>org.exolab.castor.persist.LockEngine.create(LockEngine.java:486) >>> >>> >>> >>>> at >>>> >>> >>> > org.castor.persist.AbstractTransactionContext.walkObjectsToBeCreated(Abstrac > >>>>tTransactionContext.java:805) >>>> at >>>> >>> >>> > org.castor.persist.AbstractTransactionContext.create(AbstractTransactionCont > >>>>ext.java:762) >>>> at >>>>org.exolab.castor.jdo.engine.DatabaseImpl.create(DatabaseImpl.java:360) >>>> at project.MyCastor.CreateMedia(MyCastor.java:45) >>>> at project.Main.main(Main.java:27) >>>>org.exolab.castor.jdo.PersistenceException: Nested error: >>>>java.sql.SQLException: No database selected: No database selected >>>> >>>> >>>>AND THID IS MY CODE IN WHICH THE DATABASE IS >>> >>>SELECTED:...................... >>> >>> >>> >>>> try >>>> { >>>> JDOManager jdo; >>>> JDOManager.loadConfiguration("jdo-config.xml"); >>>> jdo = JDOManager.createInstance("mydb"); >>>> >>>> /** lets do some processiong */ >>>> Database db = jdo.getDatabase(); >>>> >>>> System.out.println( db.isClosed() ); >>>> >>>> db.begin(); >>>> Student student = new Student(100, "John", "Doe", "Group A"); >>>> db.create(student); >>>> db.commit(); >>>> } >>>> catch (Exception e) >>>> { >>>> System.out.println(e); >>>> } >>>> >>>>What could be wrong here? >>>> >>>>Thanks >>>>John >>>> >>>> >>>>-----Original Message----- >>>>From: Werner Guttmann [mailto:[EMAIL PROTECTED] >>>>Sent: Monday, January 23, 2006 08:59 AM >>>>To: [email protected]; [EMAIL PROTECTED] >>>>Subject: RE: [castor-user] Connection to Database >>>> >>>> >>>>John, >>>> >>>>Can I take it that you have read (and understood .. ;-)) >>>>http://castor.codehaus.org/database-conf.html. As outlined there, you'll >>>>need to adopt your JDO config file and add <jdo-conf> and >>>><transaction-demarcation> elements. >>>> >>>>Regards >>>>Werner Guttmann >>>> >>>>wg> -----Original Message----- >>>>wg> From: John Greene [mailto:[EMAIL PROTECTED] >>>>wg> Sent: Monday, January 23, 2006 2:48 PM >>>>wg> To: Castor User >>>>wg> Subject: [castor-user] Connection to Database >>>>wg> >>>>wg> Hi, >>>>wg> >>>>wg> First I am a new user of Castor, and I am trying to get a >>>>wg> connection to either mySQL or Pointbase database (not sure >>>>wg> if the latter is supported). >>>>wg> Anyhow I keep getting the following runtime error message >>>>wg> >>>>wg> >>>>wg> org.exolab.castor.mapping.MappingException: Nested error: >>>>wg> unable to find FieldDescriptor for 'driver' in >>>>wg> ClassDescriptor of jdo-conf >>>>wg> >>>>wg> Database config file is as follows: >>>>wg> >>>>wg> <database name="john" engine="pointbase" > >>>>wg> <driver class-name="com.pointbase.jdbc.jdbcUniversalDriver" >>>>wg> url="jdbc:pointbase://localhost:9092/john" > >>>>wg> <param name="user" value="pbsysadmin"/> >>>>wg> <param name="password" value="pbsysadmin"/> >>>>wg> </driver> >>>>wg> <mapping href="mapping.xml" /mapping> >>>>wg> </database> >>>>wg> >>>>wg> >>>>wg> >>>>wg> Mapping file is below: >>>>wg> >>>>wg> <mapping> >>>>wg> <class name="project.student" identity="studentid"> >>>>wg> <map-to table="students" /> >>>>wg> <field name="studentid" type="integer"> >>>>wg> <sql name="studentid" type="integer"/> >>>>wg> </field> >>>>wg> >>>>wg> <field name="firstname" type="string"> >>>>wg> <sql name="firstname" type="varchar" /> >>>>wg> </field> >>>>wg> >>>>wg> <field name="lastname" type="string"> >>>>wg> <sql name="lastname" type="varchar" /> >>>>wg> </field> >>>>wg> >>>>wg> <field name="group" type="string"> >>>>wg> <sql name="group" type="varchar" /> >>>>wg> </field> >>>>wg> >>>>wg> </class> >>>>wg> </mapping> >>>>wg> >>>>wg> >>>>wg> >>>>wg> ------------------------------------------------- >>>>wg> If you wish to unsubscribe from this list, please send an >>>>wg> empty message to the following address: >>>>wg> >>>>wg> [EMAIL PROTECTED] >>>>wg> ------------------------------------------------- >>>>wg> >>>>wg> >>>> >>>> >>>> >>>>------------------------------------------------- >>>>If you wish to unsubscribe from this list, please >>>>send an empty message to the following address: >>>> >>>>[EMAIL PROTECTED] >>>>------------------------------------------------- >>>> >>>> >>> >>> >>> >>>------------------------------------------------- >>>If you wish to unsubscribe from this list, please >>>send an empty message to the following address: >>> >>>[EMAIL PROTECTED] >>>------------------------------------------------- >>> >>> >>> >>> >>>------------------------------------------------- >>>If you wish to unsubscribe from this list, please >>>send an empty message to the following address: >>> >>>[EMAIL PROTECTED] >>>------------------------------------------------- >>> >>> >> >> >> >>------------------------------------------------- >>If you wish to unsubscribe from this list, please >>send an empty message to the following address: >> >>[EMAIL PROTECTED] >>------------------------------------------------- >> >> >> >> >>------------------------------------------------- >>If you wish to unsubscribe from this list, please >>send an empty message to the following address: >> >>[EMAIL PROTECTED] >>------------------------------------------------- >> >> > > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
