HOw can I get the connection object from JBoss

[mahendra.wadekar]

Hi All
I am using JBoss 4.0.3SP1 with Sybase. I am implementing connection pooling from JBoss for which I have done all the configuration in Jboss configuration files. I am trying to get the connection object from the JBoss using this code

System.setProperty("java.naming.factory.initial","org.jnp.interfaces.NamingContextFactory");
System.setProperty("java.naming.provider.url","jnp://localhost:1099");
System.setProperty("java.naming.factory.url.pkgs","org.jboss.naming:org.jnp.interfaces");
InitialContext ctxt = new InitialContext();
Object obj = ctxt.lookup("java:/SybaseDB");

Now the class of this object (obj) is javax.naming.Reference.

I am not able to get the Connection object from here.
I am on mid of my development so any help on this will be appreciated.
If any one need detail information on my code I can give it.

Thanks in Advance

[weston.price]

http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources

I assume you are attempting to use this DS remotely correct? Please read the link above.

[mahendra.wadekar]

Thanks for the reply.

Both the client and the server is on same VM and database is on remote machine.
I have already gone through that link you provided to me and still I am having the same problem.

[weston.price]

Ok, then I assume you are doing a straight lookup of a DataSource...in a J2EE client, application client, or a Application component. What I don't understand, and what you should kind of question is...why the property stuff?

If you are actually running in a EJB, there should be no need for this right?


You can do

InitialContext initCtx= new InitialContex();

with no worries...right?

If not, then you are probably trying to access a DS outside of the container. Which means you want remote access to a datasource...


So, which is it?

[jaikiran]

Post your datasource configuration file.

[mahendra.wadekar]

HI there,
I have solve that problem because I was trying to get the DataSource object from out side the container in a custom Java File. NOw I got the connection object within the container.
Actually I was integrating connection pooling of JBoss with TopLink and I am still fighting with it because toplink is not able to get that JNDI lookup but I think it is a matter of TopLink not JBoss so I am looking for it in TopLink forum but if you can provide any help to me on it then it will be very helpful to me.

Now I am not having issue with connection pooling of JBoss because I executed a sample query with the connection object and it is working fine.

Thanks to you for your help.