terça-feira, 10 de janeiro de 2012

connection string oracle websphere

Problems to connect to Oracle RAC Server via WebSphere Application server.

Classical connection String

 jdbc:oracle:thin:@//ORACLE-SERVER:1521/SERVICE

works fine on Oracle sqldeveloper and Weblogic Application Server.

But, connecting via WebSphere requires a complete string like.

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=off)(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(protocol=tcp)(host=node1)(port=1521))(ADDRESS=(protocol=tcp)(host=node2)(port=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=service)))


Note: Don´t breake this line.

Nenhum comentário:

Postar um comentário