Your database is named sample, not SAMPLE, change
_jdo.setDatabaseName( "sample" );
[EMAIL PROTECTED] a �crit :
>
> Yes, Thank you. That was it. I have another question now...
>
> I modified the example that came with the distribution to reflect my own
> environment, so here is the constructor for my Test.java class. I think
> that I have set everything up correctly:
>
> public Test( PrintWriter writer )
> throws Exception
> {
> // Load the mapping file
> _mapping = new Mapping( getClass().getClassLoader() );
> _mapping.setLogWriter( writer );
> _mapping.loadMapping( getClass().getResource( MappingFile ) );
>
> _jdo = new JDO();
> _jdo.setLogWriter( writer );
> _jdo.setConfiguration( getClass().getResource( DatabaseFile
> ).toString() );
> _jdo.setDatabaseName( "SAMPLE" );
>
> }
>
> However, I get the following error:
>
> [jdoTest] Loading mapping descriptors from
> file:/C:/Eclipse/eclipse/workspace/DataBinding/jdoTest/department.xml
> [jdoTest] SQL for creating jdoTest.generated.Department: INSERT INTO
> department (deptno,deptname,mgrno,admrdept,location) VALUES (?,?,?,?,?)
> [jdoTest] SQL for deleting jdoTest.generated.Department: DELETE FROM
> department WHERE deptno=?
> [jdoTest] SQL for updating jdoTest.generated.Department: UPDATE department
> SET deptname=?,mgrno=?,admrdept=?,location=? WHERE deptno=? AND deptname=?
> AND mgrno=? AND admrdept=? AND location=?
> [jdoTest] SQL for loading jdoTest.generated.Department: SELECT
> department.deptname,department.mgrno,department.admrdept,department.location
>
> FROM department WHERE department.deptno=?
> [jdoTest] org.exolab.castor.jdo.DatabaseNotFoundException: No configuration
> loaded for database SAMPLE -- use the JDO interface to load a configuration
> for this database
> [jdoTest] org.exolab.castor.jdo.DatabaseNotFoundException: No configuration
> loaded for database SAMPLE -- use the JDO interface to load a configuration
> for this database
> [jdoTest] at org.exolab.castor.jdo.engine.DatabaseImpl.<init>(Unknown
> Source)
> [jdoTest] at org.exolab.castor.jdo.JDO.getDatabase(Unknown Source)
> [jdoTest] at jdoTest.Test.run(Test.java:87)
> [jdoTest] at jdoTest.Test.main(Test.java:58)
>
> As you can see, it finds the the department.xml file and creates the SQL,
> but it doesn't seem to recognize the database that I have set up.
>
> Any help would be appreciated.
>
> Thanks,
> Ray
>
>
> Mickael Guessant
> <mickael.guessant@fi To: [EMAIL PROTECTED]
> system.com> cc: (bcc: Ray
>Grieselhuber/Teamwork)
> Subject: Re: [castor-dev] DB2
>Mapping Question
> 07/17/2002 01:10 PM
> Please respond to
> castor-dev
>
>
>
> Maybe with a class-name instead of class in the driver tag ?
>
> The following database.xml file is working fine :
> <!DOCTYPE databases PUBLIC
> "-//EXOLAB/Castor JDO Configuration DTD Version 1.0//EN"
> "http://castor.exolab.org/jdo-conf.dtd";>
> <database name="default" engine="db2" >
> <driver class-name="COM.ibm.db2.jdbc.app.DB2Driver"
> url="jdbc:db2:TEST">
> <param name="user" value="db2admin" />
> <param name="password" value="db2admin" />
> </driver>
> <mapping href="mapping.xml" />
> </database>
>
> [EMAIL PROTECTED] a �crit :
> >
> > I am attempting to set up Castor JDO to connect to a DB2 Database.
> However,
> > I get the following exception:
> >
> > [jdoTest] Loading mapping descriptors from
> > file:/C:/Eclipse/eclipse/workspace/DataBinding/jdoTest/department.xml
> > [jdoTest] org.exolab.castor.jdo.DatabaseNotFoundException: Nested error:
> > java.sql.SQLException: No suitable driver
> > [jdoTest] java.sql.SQLException: No suitable driver
> > [jdoTest] at java.sql.DriverManager.getDriver(Unknown Source)
> > [jdoTest] at
> > org.exolab.castor.jdo.engine.DatabaseRegistry.loadDatabase(Unknown
> Source)
> > [jdoTest] at org.exolab.castor.jdo.JDO.getDatabase(Unknown Source)
> > [jdoTest] at jdoTest.Test.run(Test.java:86)
> > [jdoTest] at jdoTest.Test.main(Test.java:58)
> >
> > I have the DB2 driver loaded in my classpath.
> > Here is my database file:
> >
> > <database name="sample" engine="db2">
> > <driver class="COM.ibm.db2.jdbc.app.DB2Driver" url
> ="jdbc:db2:SAMPLE">
> > <param name="user" value="db2user" />
> > <param name="password" value="db2password" />
> > </driver>
> > <mapping href="department.xml" />
> > </database>
> >
> > Here is my mapping:
> >
> > <!DOCTYPE databases PUBLIC "-//EXOLAB/Castor Mapping DTD Version 1.0//EN"
> > "http://castor.exolab.org/mapping.dtd";>
> > <mapping>
> >
> > <!-- Mapping for Department -->
> > <class name="jdoTest.generated.Department"
> > identity="deptno">
> > <description>Department</description>
> > <map-to table="department" xml="department" />
> > <field name="deptno" type="string" >
> > <sql name="deptno" type="char" dirty="check" />
> > <xml node="text"/>
> > </field>
> > <field name="deptname" type="string">
> > <sql name="deptname" type="varchar" dirty="check" />
> > <xml node="text" />
> > </field>
> > <field name="mgrno" type="string">
> > <sql name="mgrno" type="char" dirty="check" />
> > <xml node="text" />
> > </field>
> > <field name="admrdept" type="string">
> > <sql name="admrdept" type="char" dirty="check" />
> > <xml node="text" />
> > </field>
> > <field name="location" type="string">
> > <sql name="location" type="char" dirty="check" />
> > <xml node="text" />
> > </field>
> > </class>
> >
> > </mapping>
> >
> > Thanks in advance!
> >
> > Best,
> > Ray
> >
> > -----------------------------------------------------------
> > If you wish to unsubscribe from this mailing, send mail to
> > [EMAIL PROTECTED] with a subject of:
> > unsubscribe castor-dev
>
> --
> Mickael Guessant
> Consultant Architecture Distribu�e
> Fi System France - http://www.fisystem.com
> mailto:[EMAIL PROTECTED]
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
--
Mickael Guessant
Consultant Architecture Distribu�e
Fi System France - http://www.fisystem.com
mailto:[EMAIL PROTECTED]
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
