dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Thanks Lars,

After changing to JDK7, things worked alright.

Regards,
Jason




On Mon, Jan 13, 2014 at 11:00 AM, Lars Helge Øverland
<larshelge@xxxxxxxxx>wrote:

> Hi Jason,
>
> yes you are right and we should have informed better about this. Postgres
> jdbc drivers now comes in two versions. jdbc4 is intended for jvm 1.6,
> while jdbc41 is intended for jvm 1.7 and 1.8.
>
> http://jdbc.postgresql.org/download.html
>
> So if you are still using jvm 1.6 you can
>
> - download the jdbc93-1100 jar from the above link and replace the
> postgresql-9.3-1100-jdbc41.jar driver jar inside the DHIS WAR file
> (WEB-INF/lib), or
>
> - if you build yourself you can apply this patch to the root pom.xml
>
>   <dependency>
>          <groupId>org.postgresql</groupId>
>          <artifactId>postgresql</artifactId>
> -        <version>9.3-1100-jdbc41</version>
> +        <version>9.3-1100-jdbc4</version>
>   </dependency>
>
>
> - or upgrade to jvm 1.7 which is recommended anyway (I know there might be
> reasons not to do it).
>
>
> Lars
>
>
>
>
>
>
> On Mon, Jan 13, 2014 at 8:17 AM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> Grabbed a copy of the latest 2.14 stable from the downloads.
>>
>> Running Postgresql 9.3 on Linux and got this error. This would seem to
>> imply looking here<http://stackoverflow.com/questions/16019586/unsupported-major-minor-version-51-0-unable-to-load-class-org-postgresql-driver> we
>> need JDK 7 now?
>>
>> Regards,
>> Jason
>>
>>
>>
>> Jan 13, 2014 2:12:06 AM org.apache.catalina.startup.HostConfig deployWAR
>> INFO: Deploying web application archive /home/dhis/tomcat/webapps/dhis.war
>> * INFO  2014-01-13 02:12:15,252 System property dhis2.home not set
>> (DefaultLocationManager.java [pool-2-thread-1])
>> * INFO  2014-01-13 02:12:15,256 Environment variable DHIS2_HOME points to
>> /home/dhis/dhis_home (DefaultLocationManager.java [pool-2-thread-1])
>> * INFO  2014-01-13 02:12:17,527 Hibernate configuration loaded, using
>> dialect: org.hibernate.dialect.PostgreSQLDialect
>> (DefaultHibernateConfigurationProvider.java [pool-2-thread-1])
>> Exception in thread
>> "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1"
>> java.lang.UnsupportedClassVersionError: org/postgresql/Driver : Unsupported
>> major.minor version 51.0 (unable to load class org.postgresql.Driver)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2840)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1160)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1668)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1546)
>>         at java.lang.Class.forName0(Native Method)
>>         at java.lang.Class.forName(Class.java:190)
>>         at
>> com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
>>         at
>> com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)
>>         at
>> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
>>         at
>> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
>>         at
>> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
>>         at
>> com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
>>         at
>> com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
>>         at
>> com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
>>         at
>> com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
>> Exception in thread
>> "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2"
>> java.lang.UnsupportedClassVersionError: org/postgresql/Driver : Unsupported
>> major.minor version 51.0 (unable to load class org.postgresql.Driver)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2840)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1160)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1668)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1546)
>>         at java.lang.Class.forName0(Native Method)
>>         at java.lang.Class.forName(Class.java:190)
>>         at
>> com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
>>         at
>> com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)
>>         at
>> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
>>         at
>> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
>>         at
>> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
>>         at
>> com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
>>         at
>> com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
>>         at
>> com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
>>         at
>> com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
>> Exception in thread
>> "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0"
>> java.lang.UnsupportedClassVersionError: org/postgresql/Driver : Unsupported
>> major.minor version 51.0 (unable to load class org.postgresql.Driver)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2840)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1160)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1668)
>>         at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1546)
>>         at java.lang.Class.forName0(Native Method)
>>         at java.lang.Class.forName(Class.java:190)
>>         at
>> com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
>>         at
>> com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)
>>         at
>> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
>>         at
>> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
>>         at
>> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
>>         at
>> com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
>>         at
>> com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
>>         at
>> com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
>>         at
>> com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>