java.sql.SQLException: Invalid Oracle URL specified
400313Jul 12 2006 — edited Jul 14 2006I 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...