SQL Server with Embedded OC4J

[simhi]

Is it possible to run in embedded OC4J an EJB that activates SQL Server data source?

If not, is there any other way to debug the EJB ?

 

[sem]

Why not? Just use another jdbc driver. Regards, Dima

 

[simhi]

I treid the following:
1. Microsoft SQL Server 2000 Driver for JDBC
2. Add the following line to the file <jdev_install>/jdev/bin/jdev.conf
AddJavaLibPath C:/Program Files/Microsoft SQL Server 2000 Driver for JDBC/lib
3. Create a new library in jdev called &quot;Other JDBC&quot;
4. Create a new SQLServer connection - I also tested the connection and it works fine and connected to the DB.

Based on some other threads I saw, I changed the file:
D:\Jdev9i\jdev\system9.0.3.1035\oc4j-config\data-sources.xml

THe problem is that when I tried to right click on the EJB and debug it, I got a message:

Error initializing data-source 'jdbc/SQLServerCoreDS': DriverManagerDataSource driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' not found


Below is the data-source.xml I am using:

<data-sources>
<data-source
class=&quot;com.evermind.sql.DriverManagerDataSource&quot;
name=&quot;OracleDS&quot;
location=&quot;jdbc/OracleCoreDS&quot;
xa-location=&quot;jdbc/xa/OracleXADS&quot;
ejb-location=&quot;jdbc/OracleDS&quot;
connection-driver=&quot;oracle.jdbc.driver.OracleDriver&quot;
username=&quot;scott&quot;
password=&quot;tiger&quot;
url=&quot;jdbcracle:thinlocalhost:5521racle&quot;
inactivity-timeout=&quot;30&quot;
/>
<data-source
class=&quot;com.evermind.sql.DriverManagerDataSource&quot;
connection-driver=&quot;com.microsoft.jdbc.sqlserver.SQLServerDriver&quot;
ejb-location=&quot;jdbc/SQLServerDS&quot;
inactivity-timeout=&quot;30&quot;
location=&quot;jdbc/SQLServerCoreDS&quot;
name=&quot;jdev-connection:SQLServer&quot;
pooled-location=&quot;jdbc/SQLServerPooledDS&quot;
url=&quot;jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor&quot;
username=&quot;sa&quot;
xa-location=&quot;jdbc/xa/SQLServerXADS&quot;/>

</data-sources>

 

[sem]

Did you try to enclose driver path into double quotes? The problem may be in long path name (blanks). Regards, Dima

 

[simhi]

I added the double quote to the driver path in the
jdev.conf file but it doesn't seems to make a difference.