Re: Usage of the DbFileSystem with MS-SQL

[Stefan Guggisberg]

On 3/29/07, Martijn Hendriks <[EMAIL PROTECTED]> wrote:

Hi all,

The DbFileSystem Javadoc gives the following sample configuration for
MS-SQL:

 * The following is a fragment from a sample configuration using MSSQL:
 * <pre>
 *   &lt;FileSystem
class="org.apache.jackrabbit.core.fs.db.DbFileSystem"&gt;
 *       &lt;param name="driver"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/&gt;
 *       &lt;param name="url"
value="jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=test;Sele
ctMethod=Cursor;"/&gt;
 *       &lt;param name="schema" value="mssql"/&gt;
 *       &lt;param name="user" value="sa"/&gt;
 *       &lt;param name="password" value=""/&gt;
 *       &lt;param name="schemaObjectPrefix" value="rep_"/&gt;
 *   &lt;/FileSystem&gt;
 * </pre>

This does not work for us; we need to adjust the driver and url to the
following:

        <param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
        <param name="url"
value="jdbc:sqlserver://localhost:1433;DatabaseName=test;" />

The same goes for the persistence manager. We're using Microsoft SQL
Server 2005 JDBC Driver 1.1. Is this just a driver-version issue, or is
there something else?

i guess it's a driver version issue.  the config in the javadoc is the one i
tested the pm with. i used a MSSQLServer 2000 jdbc driver.

cheers
stefan

Regards,

Martijn Hendriks
<GX> creative online development B.V.

t: 024 - 3888 261
f: 024 - 3888 621
e: [EMAIL PROTECTED]

Wijchenseweg 111
6538 SW Nijmegen
http://www.gx.nl/