Return-Path: X-Original-To: apmail-groovy-dev-archive@minotaur.apache.org Delivered-To: apmail-groovy-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2E8E3183DF for ; Sun, 15 Nov 2015 23:41:14 +0000 (UTC) Received: (qmail 26487 invoked by uid 500); 15 Nov 2015 23:41:09 -0000 Delivered-To: apmail-groovy-dev-archive@groovy.apache.org Received: (qmail 26444 invoked by uid 500); 15 Nov 2015 23:41:09 -0000 Mailing-List: contact dev-help@groovy.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@groovy.incubator.apache.org Delivered-To: mailing list dev@groovy.incubator.apache.org Received: (qmail 26434 invoked by uid 99); 15 Nov 2015 23:41:08 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 15 Nov 2015 23:41:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 6423A18098E for ; Sun, 15 Nov 2015 23:41:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.87 X-Spam-Level: ** X-Spam-Status: No, score=2.87 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=yahoo.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id v5NNQhyCP4hY for ; Sun, 15 Nov 2015 23:41:00 +0000 (UTC) Received: from nm12-vm4.bullet.mail.ne1.yahoo.com (nm12-vm4.bullet.mail.ne1.yahoo.com [98.138.91.172]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 12D3543C83 for ; Sun, 15 Nov 2015 23:41:00 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1447630853; bh=PnQfUA0gG9ragaUmiE1lKDNjt+oIx2znATu047KyAdM=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=COBq+HBF5jHs4VQiPGvzEq27537hSrPCvh6E1wXPsydoGxgeFCJKyjn43dNeq2AXtyDaIGQjgllRDJhJGHee0zJjIP50fk0GJmaYS8+NWQmFV1vutoz9V0qN7zUrDxBa21ytutKoDh1BPA18ihWHk3qqowcLi+H4/oKZjDanMoo7g6tmIDgP/qqE4/JtsUdhSWPtqvOcgzN3OJPQfDqEmW+qbhHvDKs2CUMDEB4lcmDKTD0JFneXsjuBU3CdtuBKuOVnss/iF4+lTmo5RvCIg+ms6mzmW9ZUsJrNq+aoFmXXmGKWLDf04ooAva5FCEkXAUJ6SJMIgdfM9xRgAQkYIw== Received: from [98.138.101.131] by nm12.bullet.mail.ne1.yahoo.com with NNFMP; 15 Nov 2015 23:40:53 -0000 Received: from [98.138.88.237] by tm19.bullet.mail.ne1.yahoo.com with NNFMP; 15 Nov 2015 23:40:53 -0000 Received: from [127.0.0.1] by omp1037.mail.ne1.yahoo.com with NNFMP; 15 Nov 2015 23:40:53 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 116058.34320.bm@omp1037.mail.ne1.yahoo.com X-YMail-OSG: CROt3L8VM1kYy_FHSeNQXhoanJjpP9aLGAH3trKxAixqWAd_90BcKhF7Nca3.Ki UQpWd.PEfaM.0vz0BpPtnB7PrDnPL2qEtsZ6KL7e9Q_5NxX6qkzJncHEEDvsaGag70n8UWPk6qRa j5fn5j9QrHDxm24WWebgrhhh.hTJ.DRw2X2liCYvERLfOppVClL5CfYeqv5kx2UWQPDa7LzuHmua HDbnNdg0DaJbHvGhWeM_FrmHEFuGXtCZ8k96CBndQCxGqTNbGB2_AbKRRgaj6f3EIiQPe5b3lfR1 62PJGcWs4EsHCZ9_2EB_AZRSLQ5gaghQAdbKeSvMq.FjWzXDeT_ZqKzdeEYzK60vZVQ9otckHBLl y6eQkII7tE4L24_g1z82nr5UzYFrBhQpE9hCHEYLWq4rPp7hkVhj4nY4ZTPAXMxE_WzpIyFyDClE lGRL5MXTDOrDw8yi8klki1zwbbJzQYTkFv5ZxTtDK1HRTiHoeHBXveQbXbgmvG4.uoqFDtw9yeyk pGlggYzskeCKraWVycU..CBTvgcOHUFKcsQYy7ikt72r4g13tvqXkNQqHhp4OZZFjJUwznOELzYO uqDfZHz4lmcfIIw-- Received: by 98.138.105.205; Sun, 15 Nov 2015 23:40:52 +0000 Date: Sun, 15 Nov 2015 23:40:47 +0000 (UTC) From: Richard Heintze Reply-To: Richard Heintze To: "dev@groovy.incubator.apache.org" Message-ID: <395433859.4286921.1447630847092.JavaMail.yahoo@mail.yahoo.com> Subject: com.microsoft.sqlserver.jdbc.SQLServerDriver with grapes/Maven? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4286920_1698363815.1447630847085" References: <395433859.4286921.1447630847092.JavaMail.yahoo.ref@mail.yahoo.com> ------=_Part_4286920_1698363815.1447630847085 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable After several hours I finally got my groovy sql demo working with the nativ= e Microsoft JDBC driver instead of the jtds driver. What a pain this Micros= oft driver is! Unfortunately, the jtds driver=C2=A0is missing the integrate= d security feature. (Actually, configuring the MS SQL Server ports to accommodate jtds is very = painful too because it takes a lot of google searching to discover the dire= ctions for opening up the correct ports on MS SQL Server to accommodate the= jtds driver but this is a digression). Here is my version of groovy: groovy -v Groovy Version: 2.3.0-beta-2 JVM: 1.8.0_05 Vendor: Oracle Corporation OS: W= indows 8.1 I just discovered=C2=A0http://www.groovy-lang.org/mailing-lists.html#nabble= -td342217 which explains that I have to define JAVA_OPTS with groovy instea= d of using=C2=A0-Djava.library.path=3Dc:\sqljdbc_4.0\enu\auth\x64 directly = on the command line like I can with java and now my groovy demo of jdbc/sql= .newInstance works. (1) Is there a reason I=C2=A0have to define JAVA_OPTS instead of using the = command line like I do with java?=C2=A0(2) Is there a standard in maven for= specifying where to store the JNI DLL associate jar file? Is it supported = with mvn install:intall-file?(3) Is there a feature in grapes (or groovy in= general) that will relieve me of having to specify the path of the DLL in = JAVA_OPTS? It seems logical that mvn install:install-file would copy the=C2= =A0JNI DLL=C2=A0into the repository so=C2=A0grapes would go to maven and di= scover JNI DLL and take the appropriate action of defining JAVA_OPTS for me= .(4) If the answer is no, can I make a request for such a feature? Could th= e groovy developers just decide on a convention for putting the DLLs in wit= h the same directory with=C2=A0jar files=C2=A0in the maven repository? Or w= ould this require a feature request with maven too? ThanksSiegfried ------=_Part_4286920_1698363815.1447630847085 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
After several hours I finally got my= groovy sql demo working with the native Microsoft JDBC driver instead of t= he jtds driver. What a pain this Microsoft driver is! Unfortunately, the jt= ds driver is missing the integrated security feature.
(Actually, configuring the MS SQ= L Server ports to accommodate jtds is very painful too because it takes a l= ot of google searching to discover the directions for opening up the correc= t ports on MS SQL Server to accommodate the jtds driver but this is a digre= ssion).

Here is my version of groovy:

= groovy -v<= br id=3D"yui_3_16_0_1_1447440338081_14445">Groovy Version: 2.3.0-beta-2 JVM= : 1.8.0_05 Vendor: Oracle Corporation OS: Windows 8.1

<= /div>
I just discovered = http://www.groovy-lang.org/mailing-l= ists.html#nabble-td342217 which explains that I have to define JAVA_OPT= S with groovy instead of using -Djava.library.path=3Dc:\sqljdbc_4.0\en= u\auth\x64 directly on the command line like I can with java and now my gro= ovy demo of jdbc/sql.newInstance works.


(1) Is there a reason I have to define JAVA_OPTS instea= d of using the command line like I do with java? 
(2) Is there a standard in maven fo= r specifying where to store the JNI DLL associate jar file? Is it supported= with mvn install:intall-file?
(3) Is there a feature in grapes (or groovy in general) that will reli= eve me of having to specify the path of the DLL in JAVA_OPTS? It seems logi= cal that mvn install:install-file would copy the JNI DLL into the= repository so grapes would go to maven and discover JNI DLL and take = the appropriate action of defining JAVA_OPTS for me.
(4) If the answer is no, can= I make a request for such a feature? Could the groovy developers just deci= de on a convention for putting the DLLs in with the same directory with&nbs= p;jar files in the maven repository? Or would this require a feature r= equest with maven too?

Thanks
Siegfried

















------=_Part_4286920_1698363815.1447630847085--