-
1. Re: Error Connecting to Datasource - Wildfly
wdfink Jun 4, 2014 8:08 AM (in response to gantony)Could you show a bit more information?
Also you might use a Java tool like SQuirreL that you are able to test the connection with the same JDBC driver from the same machine
-
2. Re: Error Connecting to Datasource - Wildfly
gantony Jun 4, 2014 8:30 AM (in response to wdfink)Hi Fink,
Thanks for your quick response. I have tested connection in Wildfly Data source Administration and the connection was successful. Below is what I use to connect to the data source.
Properties p = new Properties();
p.put(Context.INITIAL_CONTEXT_FACTORY,"org.jnp.interfaces.NamingContextFactory");
p.put(Context.URL_PKG_PREFIXES, "jboss.naming:org.jnp.interfaces");
p.put(Context.PROVIDER_URL, "jnp://localhost:1099");
InitialContext ic = new InitialContext(p);
DataSource ds=(DataSource)ic.lookup("java:jboss/TestDatasource");
Connection con=ds.getConnection();
And this is the error I get.
javax.naming.CommunicationException: Receive timed out [Root exception is java.net.SocketTimeoutException: Receive timed out]
Please advise.
Thanks,
Antony
-
3. Re: Error Connecting to Datasource - Wildfly
jaikiran Jun 5, 2014 1:58 AM (in response to gantony)Are you trying to lookup the datasource from a remote client (like standalone application)? If yes, then it's not supported. Furthermore, the jnp: JNDI provider URL too is no longer supported in AS7/EAP6 or WildFly.
-
4. Re: Error Connecting to Datasource - Wildfly
gantony Jun 5, 2014 2:12 AM (in response to jaikiran)Hi Jaikiran, Thanks for your reply.
I have an ejb deployed in the server in which I have to use Data base connection. And my code to connect to Data source is inside a jar file that is available in the server as well. I have a standalone code to connect to EJB and I am able to connect to the EJB. But when I call the function to connect to Data source I get the error I specified earlier.
Please advise.
Antony.
-
5. Re: Re: Error Connecting to Datasource - Wildfly
jaikiran Jun 5, 2014 2:26 AM (in response to gantony)If your code which is trying to lookup the datasource is within the same server as the datasource, then all you need to do is:
DataSource ds=(DataSource) InitialContext.doLookup("java:jboss/TestDatasource"); Connection con=ds.getConnection(); ....
You should get rid of the other lines from the code you posted.