Connect DS with JNDI in JBoss AS

[Hari Dhanakoti]

I had been trying to connect databases with JBoss4.2.2 thru JNDI. I had created a new xml file to locate the datasource to connect in the deploy directory. I have a problem of how to locate the JNDI file and how to establish the connection.

Here is my code of MSSQL-DS.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- =========================================================== -->
<!-- -->
<!-- DataDirect Data Sources -->
<!-- -->
<!-- =========================================================== -->
<!--
See the generic_ds.xml file in the doc/examples/jca folder
for examples of properties and other tags you can specify
in data sources
-->
<datasources>
<!-- JBossTest Data Source -->
<local-tx-datasource>
<jndi-name>ds/personDS</jndi-name>
<connection-url>jdbc:datadirect:sqlserver://myserver:1433</connection-url>
<driver-class>com.ddtek.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>123123</password>
<!-- Driver Specific Options -->
<connection-property name="sendStringParametersAsUnicode">false</connection-property>
<!--pooling parameters-->
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
</local-tx-datasource>
</datasources>


Here i try to connect thru JNDI in java code as

public void getConnection(){
InitialContext cxt = InitialContext.lookup("java:/MSSQLDS");
-----
-----
}
I am sure with the first step of the connection establishment but how to establish connection from this piece of code.

[Jeanne Boyarsky]

Wing,
Welcome to JavaRanch!

First you create an empty initial context. JBoss maps this to the JNDI. Then you lookup the datasource. The JNDI name comes from the XML, not the filename. I see a personDS in your example, but not a MSSQLDS one. Then you can get the connection from the datasource.

InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:comp/env/ds/personDS");
Connection conn = ds.getConnection();