-
1. Re: DataSource remote "lookup"
jameslivingston May 28, 2014 10:16 PM (in response to julien.topcu)WildFly (and AS7) don't support remote datasource lookup, which I believe is a deliberate decision. If you used it on older versions where it worked, it was incredibly easy to create terrible performance problems, large server-side memory leaks, and more.
What was the use case for having one? The best option is usually to encapsulate the data logic in an EJB which does the DB work server-side, and then call it from the client.
-
2. Re: DataSource remote "lookup"
dmlloyd May 28, 2014 10:27 PM (in response to jameslivingston)James Livingston wrote:
WildFly (and AS7) don't support remote datasource lookup, which I believe is a deliberate decision. If you used it on older versions where it worked, it was incredibly easy to create terrible performance problems, large server-side memory leaks, and more.
This is correct, however I've been wondering whether it might be worthwhile to add this feature back once we finish the JNDI-based invocation API rework (http://lists.jboss.org/pipermail/wildfly-dev/2014-January/001457.html) in an upcoming WildFly release. However instead of simply using RMI or an RMI-like exposure of the Connection or similar, we would employ something like http://vjdbc.sourceforge.net/ which would use a dedicated, optimized network protocol for the purpose. What I'm not certain of is, how widely-used is this feature? How desirable is it? What about other use cases like providing remote access to an embedded database like H2 or Derby? These are questions that would need to be answered before any such feature is re-introduced.
-
3. Re: DataSource remote "lookup"
julien.topcu Jun 2, 2014 9:32 AM (in response to dmlloyd)Thanks every one for your answers, I'll manage it with a different way!