Basis JDBC Driver Issue

dwtaggart

This is probably pretty obscure, but anyway.... I have a need to query a LiveLink site DB, which apparently is in a BASIS DB. I've got a driver and am able to connect and query fine from my db client (DBVisualizer).

My driver is in basisjdbc.jar dated 2006.
Url format is jdbc: opentext:basis://csuser:blabla@123.123.123.123:7600/acbd

However, when creating a new DataSource from Birt, everything looks fine, but when I try to click on "Test Connection", the button gets grayed out after I click it and it changes focus to the "Driver Class" field.

I also tried to create a dataset using the datasource I created, but it fails as soon as I hit next.

The driver is in the proper directory and everything seems in proper order, just looks like Birt and my 3rd party jdbc driver don't get along.

Any ideas?

Thanks,
Don

dwtaggart

Ok, very bizzare. Apparently the jdbc jar file has a dependency on log4j, so I dropped log4j.jar and log4j.properties in the SAME directory as the jdbc jar and it worked.

Go figure.