Hi William,
I never run castor with mssql but in the source distribution of castor
you can find the following configuration under src/test/jdo/mssql.xml.
<jdo-conf>
<database name="mssql" engine="sql-server" >
<data-source class-name="com.inet.tds.TdsDataSource">
<param name="user" value="test" />
<param name="password" value="test" />
<param name="serverName" value="localhost" />
<param name="databaseName" value="test" />
<param name="portNumber" value="1433"/>
</data-source>
<mapping href="mapping.xml" />
</database>
<transaction-demarcation mode="local" />
</jdo-conf>
Having said that wwith the jtds driver you have to set
class-name="net.sourceforge.jtds.jdbcx.JtdsDataSource".
Hope that helps.
Ralf
Steer, William schrieb:
> Hello. I'm just getting started with Castor JDO, so please pardon me
> asking what might be an old question. The 'url' attribute in the
> <database> element of the database configuration file is listed in one
> of the examples as:
>
> url="jdbc:oracle:thin:@machine:post:SID"
>
> I'm trying to use the jtds driver from sourceforge for SQL-Server, but
> don't find any examples of what that attribute should look like for that
> database and driver when the database is on a remote machine on the
> network. Can somebody point me toward some documentation or offer an
> example?
>
> Thanks very much for your help.
>
> Bill Steer
>
>
>
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
