Re: [Geoserver-users] strange postgres connection error

2014-01-20 Thread Simone Giannecchini
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 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(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.
>
>
> --
> 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@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


[Geoserver-users] strange postgres connection error

2014-01-16 Thread cmaul
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.

--
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users