You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by Martijn Hendriks <ma...@gx.nl> on 2007/03/29 14:25:40 UTC
Usage of the DbFileSystem with MS-SQL
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>
* <FileSystem
class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
* <param name="driver"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
* <param name="url"
value="jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=test;Sele
ctMethod=Cursor;"/>
* <param name="schema" value="mssql"/>
* <param name="user" value="sa"/>
* <param name="password" value=""/>
* <param name="schemaObjectPrefix" value="rep_"/>
* </FileSystem>
* </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?
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/
Re: Usage of the DbFileSystem with MS-SQL
Posted by Stefan Guggisberg <st...@gmail.com>.
On 3/29/07, Martijn Hendriks <ma...@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>
> * <FileSystem
> class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
> * <param name="driver"
> value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
> * <param name="url"
> value="jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=test;Sele
> ctMethod=Cursor;"/>
> * <param name="schema" value="mssql"/>
> * <param name="user" value="sa"/>
> * <param name="password" value=""/>
> * <param name="schemaObjectPrefix" value="rep_"/>
> * </FileSystem>
> * </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/
>