wM 6.5 and Oracle 10g: wM JDBC adapter issue

Hi Guys,

I hope you will be to help me out. Got two issues:

  1. Cannot located the JDBC Adapter User guide. Does any one have one?
  2. We have recently upgraded to Oracle 10g that is running on a cluster with 3 boxes. Now in order make table updates we need to access the three IP address using the same user name/pwd via JDBC Adapter.

How can we enter three IP address into the same JDBC connection? Can this even be done this way?

Adapters > JDBC Adapter > Edit Connection

serverName: , ,

Any help greatly appreciated!

Thanks,
Sebastian

IN IS 6.5, when you create a java service, there is a new field called $connection. The connection you used to create the service is the default connection, you would enter the name of any other connections you want to use when you run the service.

The guide is under the docs folder in the wmJDBC package folder in the opearting system files. Or you could go to the Administrator, select JDBC and then help.

Try the second syntax given below:

Oracle
jdbc:wm:oracle://host_or_IPaddress:port;
SID=database_name

[SIZE=2]
Oracle configured for RAC
jdbc:wm:oracle://main_OracleRAC_server_host:
main_OracleRAC_server_port;
ServiceName=Oracle_service_name;
AlternateServers=(alternate_OracleRAC_server1_host:
alternate_OracleRAC_server1_port,
alternate_OracleRAC_server2_host:
alternate_OracleRAC_server2_port,…
alternate_OracleRAC_servern_host:
alternate_OracleRAC_servern_port)

You may need to request a ‘ServiceName’ to be set-up by the database group - and use that in place of ‘SID’

HTH

[/SIZE]

Hi,

the given URL is only valid for the IS internal functions which are using branded DataDirect-Drivers.

Check with the JDBC Documentatíon available from Oracle’s TechNet for details for JDBC-Adapter.

Maybe you will need to add some additional properties for RAC.

Please check with your Administration for a virtual IP, which automatically resolve to RAC-IPs. So you will only need to connect to the virtual IP, instead of the RAC-IPs.

Regards,
Holger