This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Not getting connection to Database using JNDI for JBoss 4.2.0

 
Amol Patil
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Shiney Baby"

Please check your private message, for a message from JavaRanch.
 
Jaikiran Pai
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic