Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: Invalid Oracle URL specified

400313Jul 12 2006 — edited Jul 14 2006
I can connect to a sql server database directly using the datadirect jdbc drivers using the following:

Class.forName("com.oracle.ias.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:oracle:sqlserver://minneapolis25:1433;User=xxxx;Password=xxxxx");

When I try to make it a datasource in 10g and use it, I get the java.sql.SQLException: Invalid Oracle URL specified error message when using the following code:

Context initContext = new InitialContext();
ds = (DataSource)initContext.lookup("jdbc/MINNEAPOLIS25DS");
conn = ds.getConnection();

The datasource definition is as follows:

<data-source name="jdev-connection-legacy-MINNEAPOLIS25" class="com.evermind.sql.DriverManagerDataSource" location="jdbc/MINNEAPOLIS25CoreDS" xa-location="jdbc/xa/MINNEAPOLIS25XADS" ejb-location="jdbc/MINNEAPOLIS25DS" pooled-location="jdbc/MINNEAPOLIS25PooledDS" connection-driver="com.oracle.ias.jdbc.sqlserver.SQLServerDriver" username="xxxxx" password="->DataBase_User_6E2ZRu5kxcOH7MypES5_QezkQiu0YFyy" url="jdbc:oracle:sqlserver://minneapolis25:1433" inactivity-timeout="30"/>

Any insight would be greatly appreciated...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2006
Added on Jul 12 2006
6 comments
1,120 views