[Geotools-commits] svn - r38486 - trunk/modules/plugin/jdbc/jdbc-sqlserver

[<svn...@os...>]

Author: aaime
Date: 2012-01-16 07:39:31 -0800 (Mon, 16 Jan 2012)
New Revision: 38486

Modified:
   trunk/modules/plugin/jdbc/jdbc-sqlserver/README.txt
   trunk/modules/plugin/jdbc/jdbc-sqlserver/pom.xml
Log:
[GEOT-4010] Update instructions to install the SQL Server driver on trunk and 2.7.x

Modified: trunk/modules/plugin/jdbc/jdbc-sqlserver/README.txt
===================================================================
--- trunk/modules/plugin/jdbc/jdbc-sqlserver/README.txt	2012-01-15 20:06:03 UTC (rev 38485)
+++ trunk/modules/plugin/jdbc/jdbc-sqlserver/README.txt	2012-01-16 15:39:31 UTC (rev 38486)
@@ -4,13 +4,20 @@
 JDBC Driver
 -----------
 
-To use the sql server datastore the jdbc driver must be downloaded from 
+To use the sql server datastore the jdbc 3.0 driver must be downloaded from 
 Microsoft:
 
-  http://msdn.microsoft.com/en-us/data/aa937724.aspx
+  http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=19847
 
-The current tested driver version is 1.2 (SQL Server 2005). 
+The current tested driver version is 3.0 for SQL Server and SQL Azure. According to Microsoft this
+driver provides access to SQL Azure, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and 
+SQL Server 2000 from any Java application, application server, or Java-enabled applet.
 
+Make sure to unpack the sqljdbc4.jar file, as that's the one providing support for the Java
+version in this series.
+If you are using Java 5 you should downgrade to GeoTools 2.7.x, while Java 7 is, at the time
+of writing, not officially supported   
+
 Maven
 -----
 
@@ -18,10 +25,10 @@
 
   1. install the JDBC driver into the location maven repository:
 
-     mvn install:install-file  -Dfile=<path to sqljdbc.jar>
-         -DartifactId=sqljdbc \ 
+     mvn install:install-file  -Dfile=<path to sqljdbc4.jar>
+         -DartifactId=sqljdbc4 \ 
          -DgroupId=com.microsoft \ 
-         -Dversion=1.2 \
+         -Dversion=3.0 \
          -Dpackaging=jar \ 
          -DgeneratePom=true
 

Modified: trunk/modules/plugin/jdbc/jdbc-sqlserver/pom.xml
===================================================================
--- trunk/modules/plugin/jdbc/jdbc-sqlserver/pom.xml	2012-01-15 20:06:03 UTC (rev 38485)
+++ trunk/modules/plugin/jdbc/jdbc-sqlserver/pom.xml	2012-01-16 15:39:31 UTC (rev 38486)
@@ -63,6 +63,16 @@
         <role>Java Developer</role>
       </roles>
     </developer>
+    <developer>
+      <name>Andrea Aime</name>
+      <id>aaime</id>
+      <email>and...@ge...</email>
+      <organization>GeoSolutions</organization>
+      <roles>
+        <role>Module Maintainer</role>
+        <role>Java Developer</role>
+      </roles>
+    </developer>
   </developers>
 
   <profiles>
@@ -71,7 +81,7 @@
         <dependencies>
           <dependency>
            <groupId>com.microsoft</groupId>
-           <artifactId>sqljdbc</artifactId>
+           <artifactId>sqljdbc4</artifactId>
            <version>${sqlServerDriverVersion}</version>
           </dependency>
         </dependencies>
@@ -79,6 +89,6 @@
   </profiles>
 
   <properties>
-    <sqlServerDriverVersion>4.0</sqlServerDriverVersion>
+    <sqlServerDriverVersion>3.0</sqlServerDriverVersion>
   </properties>
 </project>