Not getting connection to Database using JNDI for JBoss 4.2.0

[Amol Patil]

Hi All,
I'm not able to get connection to PostgreSQL using JNDI.
I'm using JBoss 4.2.0. Can Anybody please tell which setting I need to do in JBoss?

[Jaikiran Pai]

How have you setup your datasource? What exception are you seeing if any? And please post the code where you are doing the lookup.

[Shiney Thomas]

Originally posted by Jaikiran Pai:
How have you setup your datasource? What exception are you seeing if any? And please post the code where you are doing the lookup.

Data Source is set up in properties.xml of Jboss (path is \jboss-4.2.0\server\default\deploy\container.war\manifest)
the code in properties.xml is
<?xml version="1.0" encoding="UTF-8"?>
<config>
<iface>
.............. some other code
<xmlpath>:/jboss-4.2.0/server/default/deploy/container.war/manifest</xmlpath>
<ds-datasource>java:/PostgresDS</ds-datasource>
<dc-datasource>java:/PostgresDS</dc-datasource>
<du-datasource>java:/PostgresDS</du-datasource>
</iface>
</config>

and the code in JAVA for lookup is .........(This is called to authenticate the Login/Password)

InitialContext ctx = new InitialContext();
AuthenticateUser_Home authenticateuser_home = (AuthenticateUser_Home)ctx.lookup("DSP1-aaa/AuthenticateUser");
AuthenticateUser authenticateuser = authenticateuser_home.create();

[Jaikiran Pai]

"Shiney Baby"

Please check your private message, for a message from JavaRanch.

[Jaikiran Pai]

You will have to provide us more details. When you say, you are not able to connect to the database, what exactly are you seeing? Any exceptions? Also, the xml file that you posted is not the datasource file. The datasource file will be present in the deploy folder and its name will end with -ds.xml. Can you post the contents of that file?