-
1. Re: Don?t understand the following LocalTxConnectionManager
tony1929 Mar 4, 2003 8:28 AM (in response to tony1929)As well as adding mssql-ds.xml should I also use the mssql-service.xml file.
So far as I have already written I have just deployed the modified mssql-ds.xml file and the mssqlserver.jar.
I have no idea what else I should do to get the datasource set up.
Cheers For any help Tony -
2. Re: Don?t understand the following LocalTxConnectionManager
tony1929 Mar 4, 2003 12:34 PM (in response to tony1929)I have a feeling that the warning may just be a red herring.
When I try to run the application I get the following error :
java.rmi.RemoteException: Unable to get shortcut DAO: Unable to get data source: Unable to get datasource for <jdbc/webconnect>: javax.naming.NameNotFoundException: jdbc not bound.
So I do have a datasource problem.
This is my datasource file mssql-ds.xml
<local-tx-datasource>
<jndi-name>jdbc/webconnect</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://stl00895:1433;DatabaseName=webconnect</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name></user-name>
</local-tx-datasource>
Do I need to add anything to my jboss.xml
<?xml version="1.0" encoding="UTF-8" ?>
-
- <enterprise-beans>
-
<ejb-name>ShortcutManager</ejb-name>
<jndi-name>ejb/com/smartstream/webconnect/business/ejb/ShortcutManagerHome</jndi-name>
-
<ejb-name>DashboardManager</ejb-name>
<jndi-name>ejb/com/smartstream/webconnect/business/ejb/DashboardManagerHome</jndi-name>
-
<ejb-name>Control</ejb-name>
<jndi-name>ejb/com/smartstream/webconnect/business/ejb/ControlLocalHome</jndi-name>
-
<ejb-name>Schema</ejb-name>
<jndi-name>ejb/com/smartstream/webconnect/business/ejb/SchemaLocalHome</jndi-name>
-
<ejb-name>Item</ejb-name>
<jndi-name>ejb/com/smartstream/webconnect/business/ejb/ItemLocalHome</jndi-name>
</enterprise-beans>
Thanks for any help Tony -
3. Re: Don?t understand the following LocalTxConnectionManager
davidjencks Mar 6, 2003 9:17 AM (in response to tony1929)The warning is a red herring and can be ignored. You should only use the *-ds.xml files, not the *-service.xml files (at least if you want to remain sane:-)
Check in jndiview in the jmx console to see exactly what the datasource is getting bound under. Perhaps you are looking up jdbc/webconnect rather than java:/jdbc/webconnect? Datasources are only available in the jvm in which they are deployed.