jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Guggisberg" <stefan.guggisb...@gmail.com>
Subject Re: Usage of the DbFileSystem with MS-SQL
Date Thu, 29 Mar 2007 17:42:37 GMT
On 3/29/07, Martijn Hendriks <martijnh@gx.nl> 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: martijnh@gx.nl
>
> Wijchenseweg 111
> 6538 SW Nijmegen
> http://www.gx.nl/
>

Mime
View raw message