ansaurus

Question

Eclipse JPA project - defining connection to Oracle RAC

Answer 1

A:

See Oracle's FAQ for syntax of the database connection string.

Eli Acherkan 2010-01-13 14:03:28

It is not the problem of the JDBC syntax (well to some point it is, as Eclipse forces me to stick with the @:: format).As I have said I have a good connection string in a given format and would like to use it with Eclipse DataSource.

Anonymous 2010-01-13 14:08:41

If Eclipse doesn't allow you to edit the Connection URL field, why not specify the SID/Host/Port number/User name/Password fields separately? If I understand correctly, you should be able to extract those parameters from your good connection string.

Eli Acherkan 2010-01-13 19:45:56

No, I cannot, this will not work for RAC (at least in my setup).

Anonymous 2010-01-13 20:26:16

Found a blog comment that suggests the following syntax: `jdbc:oracle:thin:@host1^host2:1521:service_name` (see http://www.jugpadova.it/articles/2007/04/11/jdbc-url-for-oracle-rac).Other than that, I'm out of ideas... Good luck!

Eli Acherkan 2010-01-14 12:53:23

Answered proved to be pretty trivial. I have added the Oracle Thin driver as the 'Other Driver'. After that I was ably to put any connection string I wanted for the connection using this driver.

Anonymous 2010-01-15 07:47:57

ansaurus

tags:

views:

answers:

Eclipse JPA project - defining connection to Oracle RAC

related questions