Patrick, Can you give us some more specifics about what difficulties you saw with the MS Driver?
Thanks - Margaret -----Original Message----- From: Patrick van Kann [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 10:20 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] Database connection to sql server 2000? Hello Phil, You need to use the DataSource class. <database name="mssql" engine="sql-server" > <data-source class-name="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"> <params user="secret" password="squirrel" server-name="COOKIEUA" database-name="ctf" port-number="1433"/> </data-source> <mapping href="mapping.xml" /> </database> However, my tests with the MS JDBC driver revealed that it was not compatible with many JDO features. The only JDBC driver I have successfully used in the Castor Testing Framework for JDO is the Opta 2000 driver by http://www.inetsoftware.de/ Hope this helps Patrick Phillip Tricoli wrote: > I am new to castor and am trying to connect to an sql server 2000 > database. The database.xml file is configured as follows. > > <!DOCTYPE databases (View Source for full doctype...)> > > <database name="MYDB" engine="sql-server"> > > <driver driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" > > url="jdbc:microsoft:sqlserver://128.1.1.10:1433"> > > <param name="user" value="sa" /> > > <param name="password" value="" /> > > > > </driver> > > <mapping href="mapping.xml" /> > > </database> > > > > > > The error that is generated is listed below > > > > java.lang.NoClassDefFoundError: javax/sql/DataSource > > at org.exolab.castor.jdo.JDO.getDatabase(JDO.java:555) > > at > com.veridian.Castor.CastorInterface.OpenDatabase(CastorInterface.java:93) > > at > com.veridian.Castor.CastorIncident.XMLToDatabase(CastorIncident.java:92) > > at > com.veridian.Castor.CastorInterfaceTester.main(CastorInterfaceTester.java:27 ) > > Exception in thread "main" > > > > Thanks in > Advance, > > > Phil > > > ----------------------------------------------------------- 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
