Saturday, April 19, 2014

How to set up Load Balance Database Connection in Eclipse Datasource

To set up the database connection that is to connect to a Load Balance database.
The steps are slightly different.


Steps:
1. R-click > New, to add a new database connection.
2. Choose database server

3. Choose database driver --> Other Driver

4. Fill in connection details. 
    The jdbc url for load balance Oracle database is like following.
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.5)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.6)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=myServiceName)))

5. Review configuration summary > Finish.


Done!!


LinkWithin

Related Posts Plugin for WordPress, Blogger...