[Geoserver-users] Unable to connect to a Oracle database at JDBC - User group service creation.

GeoServer GeoServer User
1

Hello.

Error:

2013-03-27 15:38:13,705 WARN [geoserver.security] - Connection error
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection.

Stacktrace:
http://pastebin.com/15eMByph

Enviroment:

  • 2.3.0

  • 257c5f6a57df84ecf2aaea392fe8e22dbd70ca09

  • 16-Mar-2013 14:00

  • 9.0 (rev cd6a0ac13e0ccd9ed3df653e1d7ca640a80ed86d)

  • 1.4-SNAPSHOT (rev 8eca04a1cd45233fdb5875b111095660425b5b1b/8eca04a1cd45233fdb5875b111095660425b5b1b)

  • JVM Version Oracle Corporation: 1.7.0_17 (Java HotSpot™ 64-Bit Server VM)

  • Steps:

  • Create new JDBC Service

  • Password encryption strong
    Password police default

  • Driver oracle.jdbc

  • Url:

  • jdbc:oracle:thin:@[HOST][:PORT]:SID

  • Existing user and pass.

  • Test Connection

  • Exception.

  • Since my oracle host is at a different server, I installed SQLDeveloper from oracle to test the connection and everything worked fine there.

  • Am I missing some configuration or is it a bug? Any help is appreciated.

  • Thanks.

2

Seems to be a problem with the Oracle JDBC driver. Which version do you use ?

I tested with

ojdbc14.jar
ojdbc6.jar

···

2013/4/3 Diego Felipe <diegosps@anonymised.com>

Hello.

Error:

2013-03-27 15:38:13,705 WARN [geoserver.security] - Connection error
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection.

Stacktrace:
http://pastebin.com/15eMByph

Enviroment:

  • 2.3.0

  • 257c5f6a57df84ecf2aaea392fe8e22dbd70ca09

  • 16-Mar-2013 14:00

  • 9.0 (rev cd6a0ac13e0ccd9ed3df653e1d7ca640a80ed86d)

  • 1.4-SNAPSHOT (rev 8eca04a1cd45233fdb5875b111095660425b5b1b/8eca04a1cd45233fdb5875b111095660425b5b1b)

  • JVM Version Oracle Corporation: 1.7.0_17 (Java HotSpot™ 64-Bit Server VM)

  • Steps:

  • Create new JDBC Service

  • Password encryption strong
    Password police default

  • Driver oracle.jdbc

  • Url:

  • jdbc:oracle:thin:@[HOST][:PORT]:SID

  • Existing user and pass.

  • Test Connection

  • Exception.

  • Since my oracle host is at a different server, I installed SQLDeveloper from oracle to test the connection and everything worked fine there.

  • Am I missing some configuration or is it a bug? Any help is appreciated.

  • Thanks.

Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html

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

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

3

I have ojdbc14.jar in geoserver lib folder, which came from the geoserver-2.3.0-oracle-plugin.zip

But I also have ojdbc5.jar and ojdbc6.jar in oracle client folder.
Can this cause a conflict?

Do I need to change something at windows PATH variable?

I did two simple tests:
1 - I switched the ojdbc14.jar for ojdbc6.jar, but the same error occurs.
2 - Changed the url to jdbc:oracle:oci:@[HOST][:PORT]:SID and received a java.sql.SQLException: ORA-12541: TNS:não há listener

···

On Thu, Apr 4, 2013 at 2:26 AM, Christian Mueller <christian.mueller@anonymised.com…5445…> wrote:

Seems to be a problem with the Oracle JDBC driver. Which version do you use ?

I tested with

ojdbc14.jar
ojdbc6.jar

2013/4/3 Diego Felipe <diegosps@anonymised.com>

Hello.

Error:

2013-03-27 15:38:13,705 WARN [geoserver.security] - Connection error
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection.

Stacktrace:
http://pastebin.com/15eMByph

Enviroment:

  • 2.3.0

  • 257c5f6a57df84ecf2aaea392fe8e22dbd70ca09

  • 16-Mar-2013 14:00

  • 9.0 (rev cd6a0ac13e0ccd9ed3df653e1d7ca640a80ed86d)

  • 1.4-SNAPSHOT (rev 8eca04a1cd45233fdb5875b111095660425b5b1b/8eca04a1cd45233fdb5875b111095660425b5b1b)

  • JVM Version Oracle Corporation: 1.7.0_17 (Java HotSpot™ 64-Bit Server VM)

  • Steps:

  • Create new JDBC Service

  • Password encryption strong
    Password police default

  • Driver oracle.jdbc

  • Url:

  • jdbc:oracle:thin:@[HOST][:PORT]:SID

  • Existing user and pass.

  • Test Connection

  • Exception.

  • Since my oracle host is at a different server, I installed SQLDeveloper from oracle to test the connection and everything worked fine there.

  • Am I missing some configuration or is it a bug? Any help is appreciated.

  • Thanks.

Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html

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

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

4

“Problem” solved. Was a typo at the host. I must be blind because I checked 10 times before starting this.
Sorry, and thanks for your help Christian.

···

On Thu, Apr 4, 2013 at 2:56 PM, Diego Felipe <diegosps@anonymised.com> wrote:

I have ojdbc14.jar in geoserver lib folder, which came from the geoserver-2.3.0-oracle-plugin.zip

But I also have ojdbc5.jar and ojdbc6.jar in oracle client folder.
Can this cause a conflict?

Do I need to change something at windows PATH variable?

I did two simple tests:
1 - I switched the ojdbc14.jar for ojdbc6.jar, but the same error occurs.
2 - Changed the url to jdbc:oracle:oci:@[HOST][:PORT]:SID and received a java.sql.SQLException: ORA-12541: TNS:não há listener

On Thu, Apr 4, 2013 at 2:26 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Seems to be a problem with the Oracle JDBC driver. Which version do you use ?

I tested with

ojdbc14.jar
ojdbc6.jar

2013/4/3 Diego Felipe <diegosps@anonymised.com>

Hello.

Error:

2013-03-27 15:38:13,705 WARN [geoserver.security] - Connection error
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection.

Stacktrace:
http://pastebin.com/15eMByph

Enviroment:

  • 2.3.0

  • 257c5f6a57df84ecf2aaea392fe8e22dbd70ca09

  • 16-Mar-2013 14:00

  • 9.0 (rev cd6a0ac13e0ccd9ed3df653e1d7ca640a80ed86d)

  • 1.4-SNAPSHOT (rev 8eca04a1cd45233fdb5875b111095660425b5b1b/8eca04a1cd45233fdb5875b111095660425b5b1b)

  • JVM Version Oracle Corporation: 1.7.0_17 (Java HotSpot™ 64-Bit Server VM)

  • Steps:

  • Create new JDBC Service

  • Password encryption strong
    Password police default

  • Driver oracle.jdbc

  • Url:

  • jdbc:oracle:thin:@[HOST][:PORT]:SID

  • Existing user and pass.

  • Test Connection

  • Exception.

  • Since my oracle host is at a different server, I installed SQLDeveloper from oracle to test the connection and everything worked fine there.

  • Am I missing some configuration or is it a bug? Any help is appreciated.

  • Thanks.

Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html

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

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH