×
The 2025 Client Survey is now open! Responses will be accepted up until 10/31. Please feel free to share this link within your organization and we thank you in advance for your participation!

Uncategorized SQLException for SQL

LabKey Support Forum (Inactive)
Uncategorized SQLException for SQL jeckels  2015-01-13 09:05
Status: Closed
 
Hi Bront,

Is this on a developer machine, or a production/staging/etc server? I'm wondering if the Postgres JDBC driver might be stale. Can you double-check that the copy in $TOMCAT_HOME/lib matches the file size in the distribution (either the .tar.gz or ./external/lib/tomcat/ in SVN)?

Also, can you share the section of labkey.xml in $TOMCAT_HOME/conf/Catalina/localhost for the labkeyDataSource (stripping out server/username/password information, of course). It should be something like this:

    <Resource name="jdbc/labkeyDataSource" auth="Container"
        type="javax.sql.DataSource"
        username="postgres"
        password="XXXXXXXXXXXXXXXXX"
        driverClassName="org.postgresql.Driver"
        url="jdbc:postgresql://localhost:5433/labkey"
        maxActive="20"
        maxIdle="10"
        accessToUnderlyingConnectionAllowed="true"
        validationQuery="SELECT 1"
        />

Thanks,
Josh