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