ok i got it working.. was missing ADDRESS=(PROTOCOL=TCP).. THANKS! -chris
On Feb 8, 11:54 am, chris schiffman <[email protected]> wrote: > Thanks for that link Mats.. however, i'm still missing something.. I > have tried: > > <connectstring></connectstring> > <hoststring>jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON) > (CONNECT_TIMEOUT=5)(ADDRESS_LIST=(ADDRESS=(HOST=PROD)(PORT=1521)) > (ADDRESS=(HOST=DATAG)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL)))</ > hoststring> > > Resulting in: "Could not verify datasource: Io exception: SO > Exception was generated" > > <connectstring>(DESCRIPTION=(FAILOVER=ON)(CONNECT_TIMEOUT=5) > (ADDRESS_LIST=(ADDRESS=(HOST=PROD)(PORT=1521))(ADDRESS=(HOST=DATAG) > (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL)))</connectstring> > <hoststring>jdbc:oracle:thin</hoststring> > > Resulting in: "Could not verify datasource: Invalid Oracle URL > specified" > > I can't seem to figure out the right place to put things.. > -chris -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012
