Hi,
Yes thanks for that. You know u can stare at something for hours only to have
someone walk past and go ...there's the problem.
Works fine now :-)
Jeff
On Wed, 23 Jan 2002 23:38, CARDON Denis wrote:
> Hi Jeff,
>
> You've forgotten the column character (":") after the thin keyword in the
> connection url of your database.xml file. Here is the corrected
> database.xml file:
>
> <database name="robin" engine="oracle">
> <driver class-name="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@robin.batcave:1521:robin">
> <param name="user" value="scott"/>
> <param name="password" value="tiger"/>
> </driver>
> <mapping
> href="/home/jhoare/eclipse-ide/SDC/nz/co/softmetaware/persistence/testing.x
>m l"/>
> </database>
>
> -----Original Message-----
> From: Jeff Hoare [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 23, 2002 12:49 PM
> To: [EMAIL PROTECTED]
> Subject: [castor-dev] Trying to connect to Oracle DB
>
>
> Hi,
> I have been trying to get jdo working with oracle 8i. I am able to use the
> jdbc driver to connect to the DB fine (CRUD) using some simple examples and
> the url shown.
> DriverManager.getConnection
> ("jdbc:oracle:thin:@robin.batcave:1521:robin",
> "scott", "tiger");
>
>
> However when I try to use castor I get the error shown below. This seems to
> imply that no driver can be found to service the url specified, even though
> the one shown above works. I have included a copy of my database.xml file.
> Any idea's, or has anyone encountered this before.
>
> java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getDriver(DriverManager.java:249)
> at
> org.exolab.castor.jdo.engine.DatabaseRegistry.loadDatabase(DatabaseRegistry
>. java:280)
> at org.exolab.castor.jdo.JDO.getDatabase(JDO.java:538)
> at nz.co.softmetaware.commerce.bo.Customer.main(Customer.java:82)
>
> =====Database Mapping========
> <!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version
> 1.0//EN" "http://castor.exolab.org/jdo-conf.dtd";>
>
> <database name="robin" engine="oracle">
> <driver class-name="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:[EMAIL PROTECTED]:1521:robin">
> <param name="user" value="scott"/>
> <param name="password" value="tiger"/>
> </driver>
> <mapping
> href="/home/jhoare/eclipse-ide/SDC/nz/co/softmetaware/persistence/testing.x
>m l"/>
> </database>
>
> Regards Jeff
>
> -----------------------------------------------------------
> 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
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
