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