how to add jdbc driver for data base connection (for analysing data)

[michaelhecht]

Hi,

where can I add new drivers for data base connections for analysing data.
This is not described in the current documentation "5.1 Setting up Database Connections".

[Simon Fischer]

Hi,

just place the JDBC JAR in the lib folder. What database system do you want to use?

Best,
Simon

[michaelhecht]

Hmmm ... I did exactly this, i.e. placed the jar file in the lib folder and also restarted RA.
If I then goto "Datenbankverbindungen" --> "Neue Verbindung einrichten" (sorry I've only the german translation)
I get all databases under "Datenbanksystem" that where delivred originally but not the new one (what's not surprising,
since even no classpath adaptation was done, etc.)

So I guess that there is to do a little bit more than just copying the jar file. 

By the way: I want to use IBM Informix.

[michaelhecht]

Meanwhile I tried to follow the instructions under

http://onjava.com/onjava/2004/02/25/jbossjdbc.html

but afterwards the server failed to start, so its obviously not the right way.

(By the way: IBM DB2 is also missing).

[Simon Fischer]

Hi,

the link you post does not seem to be the latest to me :-) Try Section 7.3 on this page:

http://docs.jboss.org/jbossas/jboss4guide/r4/html/ch7.chapt.html

Also, in your JBoss (RA) folder you can find a sample for DB2 under docs/examples/jca.

In RA there is no counterpart for the "Manage Database Drivers" dialog you know from RM. However, you can simply define your data source using the -ds.xml file, assign it a JNDI name and then reference it from your "Read Database" operator via its JNDI name. (Or get an EE if you really need that dialog :-))

Best,
Simon