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)(HOST=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
>
--
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
