[teiid-issues] [JBoss JIRA] Reopened: (TEIID-412) The Postgres driver postgresql-8.1-404.jdbc3.jar isn't supported due to it's no 1.6 fully compatible

[Greg Haber (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Greg Haber reopened TEIID-412:
------------------------------



We shouldn't be using postgresql-8.1-404.jdbc3.jar under 1.6 in the first place - the instructions at http://jdbc.postgresql.org/download.html#current read:

"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.4 or newer JVM. It contains support for SSL and the javax.sql package. It comes in two flavors, JDBC3 and JDBC4. If you are using the 1.6 JVM, then you should use the JDBC4 version. 

http://jdbc.postgresql.org/download/postgresql-8.3-604.jdbc3.jar
http://jdbc.postgresql.org/download/postgresql-8.3-604.jdbc4.jar"

So we should have Teiid designed for use with the postgresql-8.3-604.jdbc4.jar , not the older jar we are currently using.



> The Postgres driver postgresql-8.1-404.jdbc3.jar isn't supported due to it's no 1.6 fully compatible
> ----------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-412
>                 URL: https://jira.jboss.org/jira/browse/TEIID-412
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 6.0.0
>         Environment: Using Postgres repository
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>             Fix For: 6.0.0
>
>
> The following exception is thrown due to the driver 1.6 incompatibility:
> Caused by: java.lang.AbstractMethodError: org.postgresql.jdbc3.Jdbc3Connection.isValid(I)Z
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.metamatrix.common.jdbc.SimplePooledConnectionSource$ConnectionProxy.invoke(SimplePooledConnectionSource.java:83)
> 	at $Proxy0.isValid(Unknown Source)
> 	at com.metamatrix.common.jdbc.SimplePooledConnectionSource.getConnection(SimplePooledConnectionSource.java:121)
> 	at com.metamatrix.common.connection.jdbc.JDBCMgdResourceConnection.openConnection(JDBCMgdResourceConnection.java:72)
> 	at com.metamatrix.common.connection.ManagedConnection.open(ManagedConnection.java:137)
> 	at com.metamatrix.common.connection.TransactionMgr.getReadTransaction(TransactionMgr.java:73)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira