[Geoserver-users] strange postgres connection error

GeoServer GeoServer User
1

Hello List,

why is that?

Caused by: java.lang.RuntimeException: Unable to obtain connection: Cannot
create JDBC driver of class 'org.postgresql.Driver' for connect URL
'jdbc:postgresql://localhost:5432/postgres'
  at
org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1679)

Postgres/PostGis is running, I can see tables with a SQL client (Squirrel to
be precise) with exactly the same parameters or connection string. I found
in the geoserver lib an ancient 8.4 jdbc3 driver, which I exchanged to a
postgresql-9.3-1100.jdbc3.jar, which is the DB version and restarted, but no
effect.

Geoserver is 2.4.1, Win7, Tomcat 7.0.39
JVM: Java HotSpot(TM) Client VM (24.45-b08, mixed mode)
Java: version 1.7.0_45, vendor Oracle Corporation

Bit puzzled.

Christian

-----
____________________________

Dr Christian Maul
Project Manager

Information Services Branch
Department Environment and Primary Industries
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/strange-postgres-connection-error-tp5098530.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

2

Ciao Christian,
I would suggest the following:

  • make sure there is no duplicate driver around (check the WEB-INF/lib and tomcat lib dirs)
  • stop tomcat
  • clean work
  • clean temp
  • restart and check
···

Regards,
Simone Giannecchini

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

Ing. Simone Giannecchini
@simogeo
Founder/Director

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

On Fri, Jan 17, 2014 at 6:41 AM, cmaul <Christian.Maul@anonymised.com> wrote:

Hello List,

why is that?

Caused by: java.lang.RuntimeException: Unable to obtain connection: Cannot
create JDBC driver of class ‘org.postgresql.Driver’ for connect URL
‘jdbc:postgresql://localhost:5432/postgres’
at
org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1679)

Postgres/PostGis is running, I can see tables with a SQL client (Squirrel to
be precise) with exactly the same parameters or connection string. I found
in the geoserver lib an ancient 8.4 jdbc3 driver, which I exchanged to a
postgresql-9.3-1100.jdbc3.jar, which is the DB version and restarted, but no
effect.

Geoserver is 2.4.1, Win7, Tomcat 7.0.39
JVM: Java HotSpot™ Client VM (24.45-b08, mixed mode)
Java: version 1.7.0_45, vendor Oracle Corporation

Bit puzzled.

Christian

Dr Christian Maul
Project Manager

Information Services Branch
Department Environment and Primary Industries
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002

Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813

View this message in context: http://osgeo-org.1560.x6.nabble.com/strange-postgres-connection-error-tp5098530.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users