Bill,
pre 0.9.6 the configuration have been:
<database name="mssql" engine="sql-server">
<data-source class-name="com.inet.tds.TdsDataSource">
<params user="test" password="test" server-name="localhost"
database-name="test" port-number="1433"/>
</data-source>
<mapping href="mapping.xml"/>
</database>
Ralf
Werner Guttmann schrieb:
> Bill,
>
> With Castor 0.9.5.4, you will have to use the <params> element instead
> of individual <param> elements as outlined by Ralf below. I think it was
> with release 0.9.6 that we decided to bring the syntax of the <driver>
> and <data-source> elements in line.
>
> I hope this helps.
> Werner
>
>
>>-----Original Message-----
>>From: Steer, William [mailto:[EMAIL PROTECTED]
>>Sent: Montag, 10. Oktober 2005 16:19
>>To: [email protected]
>>Subject: RE: [castor-user] Url attribute in <database> element
>>
>>Thanks, Ralf. I changed my config file as you suggested, but
>>now get the following error:
>>
>>Database error:
>>org.exolab.castor.jdo.DatabaseNotFoundException: Nested
>>error: o
>>rg.xml.sax.SAXException: unable to find FieldDescriptor for
>>'param' in ClassDesc riptor of data-source{file:
>>file:///C:/RWS/Bulk/BulkTest/database-config.xml; li
>>ne: 4; column: 39}
>>
>>I'm using Castor 0.9.5.4.
>>
>>Thanks again.
>>
>>Bill
>>
>>
>>
>>-----Original Message-----
>>From: Ralf Joachim [mailto:[EMAIL PROTECTED]
>>Sent: Monday, October 10, 2005 9:34 AM
>>To: [email protected]
>>Subject: Re: [castor-user] Url attribute in <database> element
>>
>>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]
>>-------------------------------------------------
>>
>>
>>
>>-------------------------------------------------
>>If you wish to unsubscribe from this list, please send an
>>empty message to the following address:
>>
>>[EMAIL PROTECTED]
>>-------------------------------------------------
>>
>>
>>
>
>
> -------------------------------------------------
> If you wish to unsubscribe from this list, please
> send an empty message to the following address:
>
> [EMAIL PROTECTED]
> -------------------------------------------------
--
Syscon Ingenieurbüro für
Meß- und Datentechnik GmbH
Ralf Joachim
Raiffeisenstraße 11
D-72127 Kusterdingen
Germany
Tel. +49 7071 3690 52
Mobil: +49 173 9630135
Fax +49 7071 3690 98
Email: [EMAIL PROTECTED]
Web: www.syscon-world.de
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------