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/ ___________________________________________________________________________ ------------------------------------------------------------------------------ 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
