Return-Path: Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org Received: (qmail 53563 invoked from network); 29 Mar 2007 17:43:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Mar 2007 17:43:02 -0000 Received: (qmail 22597 invoked by uid 500); 29 Mar 2007 17:43:08 -0000 Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org Received: (qmail 22509 invoked by uid 500); 29 Mar 2007 17:43:08 -0000 Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@jackrabbit.apache.org Delivered-To: mailing list dev@jackrabbit.apache.org Received: (qmail 22500 invoked by uid 99); 29 Mar 2007 17:43:08 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Mar 2007 10:43:08 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of stefan.guggisberg@gmail.com designates 64.233.182.184 as permitted sender) Received: from [64.233.182.184] (HELO nf-out-0910.google.com) (64.233.182.184) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Mar 2007 10:42:59 -0700 Received: by nf-out-0910.google.com with SMTP id x4so277986nfb for ; Thu, 29 Mar 2007 10:42:38 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=DiDgkEa1gDRCwRRy563W+qpRuW6dyiRj60lgwaVaKBb4NVZiK3mhr75hnTclfd7cfqYLKO46kCHxfX75VZaVEekvVzMjyW6apTdRLHak1fHWftqCTOcGwJmvHCMnKAeXxV7t30MQGDWLKZnnowQJUba01axw20k/9HbUYyMFDOA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=HayYIcTyqPGUdA5PE/NNDda62pVzk4SeZrcahF1uvN3E57hs9RbFEriBLwZJh9Uc9oAgjUCv5P/BppheFjZ6VRq9LlHlb8XaPRYB2azULgR+i/floxXRrSE2/c29vnhN/Ke5QsUZ8Hwf2ldLkT1Hwck0JtEkyiH++sMCLNuj3HQ= Received: by 10.82.120.14 with SMTP id s14mr1968235buc.1175190157969; Thu, 29 Mar 2007 10:42:37 -0700 (PDT) Received: by 10.82.153.6 with HTTP; Thu, 29 Mar 2007 10:42:37 -0700 (PDT) Message-ID: <90a8d1c00703291042x53fed42aw67eff47cbe3c73c0@mail.gmail.com> Date: Thu, 29 Mar 2007 19:42:37 +0200 From: "Stefan Guggisberg" To: dev@jackrabbit.apache.org Subject: Re: Usage of the DbFileSystem with MS-SQL In-Reply-To: <34B0CDC6176518459F3A96E8C09196B805963DAD@darth-vader.nijmegen.gx.nl> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <34B0CDC6176518459F3A96E8C09196B805963DAD@darth-vader.nijmegen.gx.nl> X-Virus-Checked: Checked by ClamAV on apache.org On 3/29/07, Martijn Hendriks 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: > * 
>  *   <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>
>  *
> > This does not work for us; we need to adjust the driver and url to the > following: > > value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /> > 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 > 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/ >