Looking up datasource defined in Jboss

[jithu.mada]

Hi,

I need to lookup a datasource defined in Jboss from a standalone Java program. Both are running on the same machine. This is the code I am using to lookup,but I a getting NameNotFoundException. Can anyone please tell if there is anything incorrect in the code. The Jboss version is 5.1.0 GA and Java version is 1.6.0 and the OS is AIX 6.1.

Properties properties = new Properties();

properties.setProperty(InitialContext.INITIAL_CONTEXT_FACTORY ,"org.jnp.interfaces.NamingContextFactory");

properties.setProperty(InitialContext.PROVIDER_URL,"jnp://localhost:1099");

InitialContext ic = new InitialContext(properties);

if(ic!=null)

{

DataSource ds = (DataSource)ic.lookup("DB2DS");

con = ds.getConnection();

}

db2-ds.xml file in Jboss

<datasources>

<local-tx-datasource>

<jndi-name>DB2DS</jndi-name>

<use-java-context>true</use-java-context>

<connection-url>jdbc:db2://localhost:30000/sds</connection-url>

<driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>

<user-name></user-name>

<password></password>

<min-pool-size>10</min-pool-size>

<max-pool-size>10</max-pool-size>

<!--

sql to call when connection is created <new-connection-sql>some

arbitrary sql</new-connection-sql>

-->

<!--

sql to call on an existing pooled connection when it is obtained from

pool <check-valid-connection-sql>some arbitrary

sql</check-valid-connection-sql>

-->

<set-tx-query-timeout />

<query-timeout>300</query-timeout>

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->

<metadata>

<type-mapping>DB2</type-mapping>

</metadata>

</local-tx-datasource>

</datasources>

Any replies greatly appreciated.

[jbossq]

You set the use-java-context to true in the db2-ds.xml, so the jndi name of your datasource is java:/DB2DS. Change the lookup parameter to "java:/DB2DS", it will work.

[jithu.mada]

Thanks for your reply. I made the change but I am still getting the same exception.

[jaikiran]

Jithu mada wrote:

Hi,

I need to lookup a datasource defined in Jboss from a standalone Java program.

Since you are looking up from a standlaone program, you won't be able to use the datasource without changing the configuration. See this for details http://community.jboss.org/wiki/HowCanIAccessADataSourceFromAClient. You can then use "DB2DS" as the jndi name for the lookup

[jithu.mada]

Thank you.