services management postgres config

[Scott Battaglia]

Robert,

Are you including two postgres drivers there?

Also, you appear to have a dependency for Commons DBCP but you're not using
it.

-Scott

On Mon, Mar 17, 2008 at 6:55 PM, Robert Lewis <r.lewis at tamu.edu> wrote:

> Hi,
>
> I am still trying to connect my services management to postgres but
> having problems. Per the post from Li Wei Nan, I switched to using the
> following.
>
> postgresql-8.2-508.jdbc4.jar
> postgresql-8.2.6
> jdk1.6.0
>
> Now when I try to deploy I get lots of exceptions which all point to a
> bad version number on the driver class file, as follows.
>
> Caused by: org.springframework.beans.PropertyBatchUpdateException;
> nested PropertyAccessExceptions (1) are:
> PropertyAccessException 1:
> org.springframework.beans.MethodInvocationException: Property
> 'driverClassName' threw exception; nested exception is
> java.lang.UnsupportedClassVersionError: Bad version number in .class file
>        at
> org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(
> AbstractPropertyAccessor.java:104)
>
>
> I followed the directions in
> http://www.ja-sig.org/wiki/display/CASUM/Configuring
>
> Per Li Wei Nan, in deployerConfigContext.xml I have the following.
>
> <bean id="dataSource"
> class="org.springframework.jdbc.datasource.DriverManagerDataSource"
>                destroy-method="close">
>                <property name="driverClassName">
>                  <value>org.postgresql.Driver</value>
>                </property>
>                <property name="url">
>         <value>jdbc:postgresql://xxxxxxxx.tamu.edu:5432/xxxx</value>
>                </property>
>                <property name="username">
>                        <value>xxxxx</value>
>                </property>
>                <property name="password">
>                        <value>xxxxx</value>
>                </property>
> </bean>
>
> In my pom.xml I have the following related dependencies.
>
>        <dependency>
>                <groupId>javax.sql</groupId>
>                <artifactId>jsql</artifactId>
>                <version>12</version>
>                <type>jar</type>
>        </dependency>
>
>        <dependency>
>            <groupId>commons-dbcp</groupId>
>            <artifactId>commons-dbcp</artifactId>
>            <version>1.2.1</version>
>            <scope>runtime</scope>
>        </dependency>
>
>        <dependency>
>                <groupId>org.postgresql.Driver</groupId>
>                <artifactId>postgresql-jdbc4</artifactId>
>                <version>8.2-508</version>
>                <type>jar</type>
>        </dependency>
>
> Can anyone suggest what change I might try to resolve this problem?
>
> Thanks,
>
> Robert Lewis
> _______________________________________________
> Yale CAS mailing list
> cas at tp.its.yale.edu
> http://tp.its.yale.edu/mailman/listinfo/cas
>



-- 
-Scott Battaglia
PGP Public Key Id: 0x383733AA
LinkedIn: http://www.linkedin.com/in/scottbattaglia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://tp.its.yale.edu/pipermail/cas/attachments/20080318/b758cc72/attachment.html