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
