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

[Diego F. <die...@gm...>]

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 <
chr...@os...> 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 <die...@gm...>
>
>> 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:
>>
>>    - Version2.3.0
>>    - Git Revision257c5f6a57df84ecf2aaea392fe8e22dbd70ca09
>>    - Build Date16-Mar-2013 14:00
>>    - GeoTools Version9.0 (rev cd6a0ac13e0ccd9ed3df653e1d7ca640a80ed86d)
>>    - GeoWebCache Version1.4-SNAPSHOT (rev
>>    8eca04a1cd45233fdb5875b111095660425b5b1b/8eca04a1cd45233fdb5875b111095660425b5b1b
>>    )
>>    -
>>    -  JVM Version Oracle Corporation: 1.7.0_17 (Java HotSpot(TM) 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
>> Geo...@li...
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>>
>
>
> --
> DI Christian Mueller MSc (GIS), MSc (IT-Security)
> OSS Open Source Solutions GmbH
>
>