JEE DataSource

Submitted by jkoek on Mon, 2009-01-26 03:22.Troubleshooting

Hello,

I hope that I'm in the right area.

Is it possible to use a jee datasource in stead of the jdbc driver which is now used.

I'm using JBoss and want to seperate the database from the search engine.

Greetings,

Jeroen.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Submitted by will on Mon, 2009-01-26 13:19.

A major technical concern is that DBSight spawns out an indexing jobs process, which needs a jdbc connection.

But the JBoss manages the connection pool, and how can the indexing process get a connection from JBOSS then...

Maybe another JNDI way to get the username/password/connection_url?

Submitted by jkoek on Tue, 2009-01-27 00:37.

If you use a application client that connects to the JEE you can use the Datasource pool.
But that is maybe out of your scope.

Or you can try to connect to the jndi of the server as an "old" j2ee 1.4 client and also use the datasource.

Submitted by will on Fri, 2009-02-13 12:08.

I haven't used JBOSS before. Some example setup would be helpful.

There could be many different scenarios, affecting where the jdbc dirver is loaded.

If you have a real testing case, could you please send us a simple example?

Submitted by jkoek on Fri, 2009-02-27 00:33.

This contains an example of a JEE 1.4 client
http://docs.jboss.org/jbossas/getting_started/v4/html/dukesbank.html

Submitted by will on Fri, 2009-02-27 16:12.

Seems not so easy.

The DBSight runs in its standalone java process. It doesn't look easy to get the jdbc connection url, user name, password just via JNDI, maybe because of security concern? I could not find out how to get these info from the example.

Anyway, I think it's much simpler to have a script to set these info. The dbsight configuration file allows you to modify these info.