wM 6.5 and Oracle 10g: wM JDBC adapter issue

[smsstar]

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: <ipaddress>, <ipaddress>, <ipaddress>

Any help greatly appreciated!

Thanks,
Sebastian

[jonb]

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.

[jonb]

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.

[bhoj]

Try the second syntax given below:

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

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

[holger]

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