Re: [castor-dev] Database connection to sql server 2000?

[Rangan N Chakravarthy]

What u r using is for pooled conn. Try this       <!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version 1.0//EN"                            "http://castor.exolab.org/jdo-conf.dtd"> <database name = "QA1" engine="sql-server">  <driver class-name="com.microsoft.jdbc.sqlserver.SQLServerDriver"             url="jdbc:microsoft:sqlserver://sql_001:1433;SelectMethod=cursor;User=qa;Password=qa;DatabaseName=QA1">         </driver>   <mapping href="e:\java\projects\reconcile\config\ContainerDBmapping.xml" />  </database>       ----- Original Message ----- From: Steve Mayzak To: [EMAIL PROTECTED] Sent: Monday, October 14, 2002 11:25 AM Subject: Re: [castor-dev] Database connection to sql server 2000? Phil,   Do you have the Database drivers in your classpath?  This could cause the error that you are getting.   -----Original Message----- From: Phillip Tricoli [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 8:01 AM To: [EMAIL PROTECTED] Subject: [castor-dev] Database connection to sql server 2000?   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