JDBC and web-apps

HCL Domino Domino Forum
1

Hi,

I am currently working on a web-app that must extract some data for a Domino database. I’m having trouble finding docs on how its done and what driver to use. I’ve done some work on R5 but I believe its a little differnt in R6. Where can I find the driver and some docs on this topic. Thanks!

2

Subject: JDBC and web-apps

I’m in the process of writing an article on how to do exactly what you’ve asked for. I’ll post another note when I know where it will be published.

Scott Lemieux

3

Subject: JDBC and web-apps

Justin,

 Doc from IBM is definitely lacking in the JDBC area.  I rely a lot on my "Notes Domino 6 Programming Bible" but I don't recall if it helped me with our particular JDBC scenario.



 First off, are you sure you need to use JDBC?  We retrieve data from Microsoft SQL Server which we pull into a Notes/Domino app using ODBC and LC LSX (Lotus Connectors LotusScript Extensions).  Search Designer Help on LCConnection.



 We did have one case where I needed to create a Java agent that used JDBC to access SQL Server because I was retrieving a PDF file out of a table column and ODBC can't handle that sort of thing.  



 I have posted numerous times to this forum on how I got JDBC and Domino to work.  Search this forum on my name "Ken A Collins" and either "Java" or "JDBC".  This will give you some hints on how to proceed.

Ken

4

Subject: RE: JDBC and web-apps

Hi,the web-app that I’m creating is completely independent from Lotus. Its running on a different app-server. I only need to access if database repository so I definately need to use JDBC. I will check out your posts Ken. Thanks for the help.

Justin

5

Subject: RE: JDBC and web-apps

Ken,I have traditionally used ODBC but I am not happy with the results. It is very unreliable.

A better source has been Native drivers. However, there isn’t one for MS SQL Server. The closest that you get is OLEDB.

I have not tried it personally, have you by any chance?

Regards

Rolf Pfotenhauer

6

Subject: RE: JDBC and web-apps

Rolf,

We have had great success using ODBC from Domino, but only from a Windows platform. We tried migrating to Linux and found that Linux is lacking in ODBC drivers so we had to put that migration on hold. I have never tried ODBC via @formulas (like how @DbLookup and @DbColumn have ODBC connection capabilities) but it works great via LotusScript code. I haven’t seen any reliability issues.

You are right about needing the right driver (supplied by Microsoft). With ODBC, I had to ensure I had the most current driver installed on my PC. ODBC does have that hassle of requiring configuration on every PC or server that will connect through it.

The company where I am currently consulting used to use OLE, and OLE is supposedly better than ODBC because you can get a connection once, not over and over and also because you don’t have to configure data sources on every computer, but we hit a support issue with a certain Domino upgrade and never looked back.

Ken