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
>
>
> Primoz Kogovsek wrote:
> > Pedro thanks for your reply!
> >
> > In context.xml ([tomcat]/conf/context.xml) i put:
> >
> > <Resource name="jdbc/tajfun" auth="Container"
> > type="oracle.jdbc.pool.OracleDataSource"
> > description="Oracle database"
> > factory="oracle.jdbc.pool.OracleDataSourceFactory"
> > driverClassName="oracle.jdbc.driver.OracleDriver"
> > maxWait="100" maxActive="25" maxIdle="4"
> > url="jdbc:oracle:thin:@jdbc:oracle:thin:@(DESCRIPTION=(load_balance=on
> > )(ADDRESS=(PROTOCOL=TCP)(HOST=IP)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(H
> > OST=IP)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service name)))"
> > user="xxxxxx" password="xxxxxx" /> the i modified
> > geoservers web.xml with this:
> >
> > <resource-env-ref>
> > <description>
> > Oracle database
> > </description>
> > <resource-env-ref-name>jdbc/tajfun</resource-env-ref-name>
> > <resource-env-ref-type>
> > oracle.jdbc.pool.OracleDataSource
> > </resource-env-ref-type>
> > <res-auth>
> > Container
> > </res-auth>
> > </resource-env-ref>
> > I restarted tomcat and when tried to add new data store Oracle NG
> > (JNDI) i got the error message:
> >
> > Error creating data store, check the parameters. Error message: Unable
> > to obtain connection: Io exception: NL Exception was generated
> >
> > any ideas!
> >
> > thanks
> > Primoz Kogovsek
> >
> >
> > On Mon, Sep 13, 2010 at 4:45 PM, Pedro Mendes <[email protected]> wrote:
> >
> >
> >
> > Hi Primoz,
> >
> > Using GS 2.0.2 you can try setting up a JNDI connection pool. In
> the
> > context.xml file on your GS webapp or Tomcat put something like
> >
> > <Resource name="jdbc/SomeName4Datastore" auth="Container"
> > type="oracle.jdbc.pool.OracleDataSource"
> >
> > factory="oracle.jdbc.pool.OracleDataSourceFactory"
> >
> > driverClassName="oracle.jdbc.driver.OracleDriver"
> > maxWait="100" maxActive="25" maxIdle="4"
> >
> > url="jdbc:oracle:thin:@jdbc:oracle:thin:@(DESCRIPTION
> > =(load_balance=on)(ADDRESS = (PROTOCOL = TCP)(HOST =
> > 10.192.60.167)(PORT =
> > 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = <IP_ADDRESS>)(PORT =
> > 1521))(CONNECT_DATA =(SERVICE_NAME = <SID>)))"
> > user="username" password=" password " />
> >
> > I'm not sure, but I think the URL parameter must be defined like
> above
> > when connecting to an Oracle 11g database. But you can try out the
> > usual way.
> >
> > Setting this up you'll be using a connection pool created by the
> tomcat
> > instance instead of the normal pool available by gs/geotools
> > implementation.
> >
> > Hope this will help you.
> >
> > Cheers,
> > Pedro Mendes
> >
> > -- View this message in context:
> http://old.nabble.com/connection-
> > to-oracle-11g-RAC-tp29698712p29699077.html Sent from the GeoServer -
> > User mailing list archive at Nabble.com.
> >
> >
> > ----------------------------------------------------------------
> > -------------- 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
> >
> >
> >
> >
> >
>
>
>
> 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
