Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #3544: SQLException from JDBC driver

BUG #3544: SQLException from JDBC driver

From
"Scott Harper"
Date:
The following bug has been logged online:

Bug reference:      3544
Logged by:          Scott Harper
Email address:      scott@mycellularsessions.com
PostgreSQL version: 8.1.9
Operating system:   Debian Linux (2.6.18-4-486)
Description:        SQLException from JDBC driver
Details:

I have installed PostgreSQL 8.1 via the Debian package manager (APT) --
installed the package postgresql-8.1.

We are running Sun Java 5, Apache 2, and Tomcat 5.5.

From the discussion at http://jdbc.postgresql.org/download.html, I have
determined that I should be using the 8.1-410 JDBC 3 driver.

I downloaded the driver, and it is bundled into my servlet's war file in
WEB-INF/lib.

When the servlet makes the DriverManager.getConnection() call, the following
exception is thrown:

org.postgresql.util.PSQLException: Something unusual has occured to cause
the driver to fail. Please report this exception.

I wasn't sure to whom I should report the exception, so I started here.  :)

I should point out that I have successfully run the same servlet, with the
same JDBC driver, on an equivalent installation on Mac OS X.

Any ideas?  Is there anything special I need to know about running JDBC on a
Debian Linux platform?

Thanks,
Scott

Re: BUG #3544: SQLException from JDBC driver

From
Heikki Linnakangas
Date:
Scott Harper wrote:
> When the servlet makes the DriverManager.getConnection() call, the following
> exception is thrown:
>
> org.postgresql.util.PSQLException: Something unusual has occured to cause
> the driver to fail. Please report this exception.

Can you get the full stack trace?

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

Re: BUG #3544: SQLException from JDBC driver

From
Kris Jurka
Date:
On Thu, 16 Aug 2007, Scott Harper wrote:

> The following bug has been logged online:
>
> Bug reference:      3544
> PostgreSQL version: 8.1.9
> Operating system:   Debian Linux (2.6.18-4-486)
> Description:        SQLException from JDBC driver
> Details:
>
> I have installed PostgreSQL 8.1 via the Debian package manager (APT) --
> installed the package postgresql-8.1.
>
> We are running Sun Java 5, Apache 2, and Tomcat 5.5.
>
>> From the discussion at http://jdbc.postgresql.org/download.html, I have
> determined that I should be using the 8.1-410 JDBC 3 driver.
>
> I downloaded the driver, and it is bundled into my servlet's war file in
> WEB-INF/lib.
>
> When the servlet makes the DriverManager.getConnection() call, the following
> exception is thrown:
>
> org.postgresql.util.PSQLException: Something unusual has occured to cause
> the driver to fail. Please report this exception.
>

This exception is most likely caused by a permission denied error because
you are running the tomcat server with a security policy.  The driver
should be placed in $CATALINA_HOME/common/lib instead of a war file.

Kris Jurka