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
