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] -------------------------------------------------
