The problem lies in the line: url="jdbc:oracle:thin:@host:1521:database?user=username">
as seen in somewhere in the JDO docs. This causes: ORA-17068: Invalid argument(s) in call ----- Original Message ----- From: "Bruce Snyder" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 7:38 PM Subject: Re: [castor-dev] jdo example fails with Oracle > This one time, at band camp, Julian L�ffelhardt said: > > JL >Hi, > JL > > JL >I once had a similar problem with Castor.The example databse.xml for use > JL >with Oracle is (was?) broken. > JL > > JL >I changed the file to supply username/password in the connect string and it > JL >worked for me. > JL > > JL ><!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version > JL >1.0// > JL > "http://castor.exolab.org/jdo-conf.dtd"> > JL ><database name="test" engine="oracle" > > JL > <driver class-name="oracle.jdbc.driver.OracleDriver" > JL > url="jdbc:oracle:thin:user/password@hostname:port:database"> > JL > </driver> > JL > <mapping href="mapping.xml" /> > JL ></database> > JL > > > I've always been able to define the database descriptor like so: > > (using the thin driver) > <database name="test" engine="oracle"> > <driver class-name="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@<MACHINE>:<PORT>:<SID>" > > <param name="user" value="<USER>" /> > <param name="password" value="<PASSWORD>" /> > </driver> > <mapping href="mapping.xml" /> > </database> > > (using the oci driver) > <database name="test" engine="oracle"> > <driver class-name="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:oci8:@<MACHINE>:<PORT>:<SID>" > > <param name="user" value="<USER>" /> > <param name="password" value="<PASSWORD>" /> > </driver> > <mapping href="mapping.xml" /> > </database> > > For use with a DataSource, I've always resorted to using a tool > that will pool the JDBC Connections like PoolMan. > -- > > perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' > > ----------------------------------------------------------- > 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
