I am new to EJB and JBOSS. I am getting problem in configuration in MSSQL Database with JBOSS-3.0.4.I have to use it for BMP Bean. I have done following steps for configuration. 1. delete the hsql*-service.xml file in the C:\jboss\jboss-3.0.4\server\default\deploy directory.
2. copy the mssql-service.xml file from the C:\jboss\jboss-3.0.4\docs\examples\jca directory into C:\jboss\jboss-3.0.4\server\default\deploy
3. change the C:\jboss\jboss-3.0.4\server\default\config a) standardjaws.xml
<attribute name="ManagedConnectionFactoryProperties"> <properties> <config-property name="ConnectionURL" type="java.lang.String">jdbc:microsoft:sqlserver://68.165.1.253:1450;DatabaseName=CABIN</config-property> <config-property name="DriverClass" type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property> <!--set these only if you want only default logins, not through JAAS--> <config-property name="UserName" type="java.lang.String">sa</config-property> <config-property name="Password" type="java.lang.String"></config-property> </properties> </attribute>
and in entity bean i have used following code to access database. DataSource dataSource = (DataSource)initial.lookup("java:comp/env/jdbc/MSSQLDS"); but after that when i am deploying application it gives warning that : No resouce Manager found for java:/MSSQLDS and when i am runing my application it gives me jdbc not bound error. pls help me asap.
Chris Mathews
Ranch Hand
Joined: Jul 18, 2001
Posts: 2712
posted
0
Moving to the JBoss Forum...
ketan modi
Greenhorn
Joined: Aug 13, 2003
Posts: 2
posted
0
At last i have solve my problem. i have changed code in jboss.xml as below. replace <resource-name>java:/MSSQLDS</resource-name> by <jndi-name>java:/MSSQLDS</jndi-name> and now it is working ok.
subject: MSSQL Database configuration with JBOSS-3.0.4