About Me

My photo
SomeCodingHero’s secret identity is Laurens van der Starre. He uses this blog to mumble stuff about tech-related subjects he encounters during his professional life. His professional life takes place in The Netherlands, working as a consultant for Oracle Consulting Netherlands.

Wednesday, September 8, 2010

Stating the obvious: ODI JDBC connect strings

I'm probably stating the obvious here, but it caused me a so called 'D'OH! How could I forget'-moment yesterday:

I was creating Data Servers in Oracle Data Integrator and was wondering how fail over should be done. Don't be fooled by Oracle Data Integrator's Oracle JDBC thin driver connect URL example:
Of course you can specify more advanced connect strings like for example jdbc:oracle:thin:@
(DESCRIPTION=
   (ADDRESS_LIST=
     (FAILOVER=on)
     (ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1521))
     (ADDRESS=(PROTOCOL=TCP)(HOST=server2)(PORT=1521))
   )
   (CONNECT_DATA =
     (SERVER=DEDICATED)
     (SERVICE_NAME=a_service)
     (FAILOVER_MODE=
       (TYPE=select)
       (METHOD=basic)
       (RETRIES=20)
       (DELAY=15)
     )
   )
 )

Classic case of RTFM (which -of course- stands for Read The Friendly Manual).

No comments:

Post a Comment