Can you connect with any other jdbc client?
You may try this:
<Resource name="jdbc/tajfun"
auth="Container"
type="javax.sql.DataSource"
url="jdbc:oracle:thin:@my.oracle.host:1521:myservice"
driverClassName="oracle.jdbc.OracleDriver"
username="myusername"
password="mypassword"
maxActive="20"
maxIdle="3"
maxWait="10000"
poolPreparedStatements="true"
maxOpenPreparedStatements="100"
removeAbandoned="true"
removeAbandonedTimeout="10"
validationQuery="SELECT SYSDATE FROM DUAL"
/>
Or if that fails then try replacing the url part with this:
url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=my.oracle.host)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=myservice)(SERVER=DEDICATED)))"
You will have to replace "my.oracle.host", myservice, myusername and mypassword
with valid values.
Regards,
Miles
Primoz Kogovsek wrote:
> Miles thanks!
>
> But this also did not resolve the problem (i am getting the same error).
>
> I also tried to conect to oracle trough oracle client (OCI) tnsping
> worked but in geoserver i stil dont have any success.
>
> I am starting to think that I might have problem on a oracle side. But
> neither me or our DBA do not now what to do. Any suggestions?
>
> Thanks
> Primoz
>
>
> On Wed, Sep 15, 2010 at 5:53 AM, Miles Jordan
> <[email protected]> wrote:
>
>
> Hi Primoz,
>
> 1. You have "jdbc:oracle:thin:@jdbc:oracle:thin:@" where you should
> have "jdbc:oracle:thin:@"
>
> 2. did you use an appropriate IP address and service name?
>
> 3. The "usual way" that Pedro was talking about is to use the basic
> jdbc connect string for the URL part, such as:
> url="jdbc:oracle:thin:@your.oracle.host:1521:yourservicename"
>
> Did you try that?
>
> Regards,
>
> Miles
>
___________________________________________________________________________
Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not
the
intended recipient, you are notified that use or dissemination of this
communication is
strictly prohibited by Commonwealth law. If you have received this transmission
in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232
3209 and
DELETE the message.
Visit our web site at http://www.antarctica.gov.au/
___________________________________________________________________________
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
