[ROO-3270] Invalid jdbc driver configurated in project for postgresql Created: 06/Sep/12  Updated: 02/Dec/12  Resolved: 02/Dec/12

Status: Resolved
Project: Spring Roo
Component/s: PERSISTENCE
Affects Version/s: None
Fix Version/s: 1.2.3.RELEASE

Type: Improvement Priority: Major
Reporter: Mario Martínez Sánchez - gvNIX - DISID Assignee: Alan Stewart
Resolution: Complete Votes: 0
Labels: jpa, roo
Remaining Estimate: 1h
Time Spent: Not Specified
Original Estimate: 1h
Environment:

Ubuntu 12.04, JDK 1.6.0_33, Maven 3.0.4



 Description   

Invalid jdbc driver version 9.1-901.jdbc3 configurated for postgresql

project --topLevelPackage org.gvnix.test --projectName test --java 6
persistence setup --provider HIBERNATE --database POSTGRES
...
Updated ROOT/pom.xml [added dependencies postgresql:postgresql:9.1-901.jdbc3, ...]
...

From http://jdbc.postgresql.org/download.html talking about Version 9.1-902:

"This is the current version of the driver. Unless you have unusual requirements (running old applications or JVMs), this is the driver you should be using. It supports Postgresql 7.2 or newer and requires a 1.5 or newer JVM. It contains support for SSL and the javax.sql package. It comes in two flavours, JDBC3 and JDBC4. If you are using the 1.6 or 1.7 JVM, then you should use the JDBC4 version."

Conclusion:

  • Upgrade version to 9.1-902
  • With java 1.5 configure JDBC3 version (9.1-902.jdbc3)
  • With java 1.6 and 1.7 configure JDBC4 version (9.1-902.jdbc4)


 Comments   
Comment by Alan Stewart [ 06/Sep/12 ]

Changing to an improvement. All depenendencies are updated where possible if no issues occur for each Roo release.

Comment by Mario Martínez Sánchez - gvNIX - DISID [ 06/Sep/12 ]

Ok about update version, but, it's using JDBC3 driver with Java 1.6 and 1.7.

Info from postgresql.org: "If you are using the 1.6 or 1.7 JVM, then you should use the JDBC4 version."

Comment by Alan Stewart [ 02/Dec/12 ]

We're not supporting java 5 anymore so I changed the dependency to 9.1-901-1.jdbc4 (9.1-902 is not in the Maven Central yet) in Git ID 9aa6306972e6b8a6c48bddb962643a94e4dac9cd. Tested with petclinic in java 6 and 7.

Generated at Sun Dec 08 06:34:39 UTC 2019 using Jira 7.13.8#713008-sha1:1606a5c1e7006e1ab135aac81f7a9566b2dbc3a6.