Miles tahanks a lot! You made my day!
This worked for me:
<Resource name="jdbc/tajfun"
auth="Container"
type="javax.sql.DataSource"
url="jdbc:oracle:thin:@
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=my.oracle.host)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=myservice)(SERVER=DEDICATED)))"
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"
/>
Regards,
Primoz
On Thu, Sep 16, 2010 at 1:55 AM, Miles Jordan <[email protected]>wrote:
> 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/
> ___________________________________________________________________________
>
--
Primož Kogovšek
Geografske informacijske rešitve
Primož Kogovšek s.p.
Koroška cesta 16
4000 Kranj
------------------------------------------------------------------------------
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
