Chris K 7, 6 29 As matt b suggested, you could try using the Notes Java api supplied by notes You should be able to get this from a notes client install. I originally marked yours as the accepted answer, but now I am withdrawing that. Salgiza’s answer to this question has more detail on this. Here are a few things to keep in mind about the DomSQL driver:
|Date Added:||16 October 2012|
|File Size:||7.21 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
This really is no true equivalent to a JDBC driver if by that you mean something that works in a similar way. The lous component is pure Java code, so it should run on any platform The server component, which runs on the Domino server, includes some C code The domini release of the Data Modeler provides seamless integration of the DomSQL driver and a new Metadata Library module, which aggregates all of the Data Modeler metadata definitions across the enterprise. Jon McAuliffe 2, 1 14 9.
Where should I start? So if you can get your hands on a toolkit you should be ready to roll. Sign up using Email and Password. Since there is no generic way to look at Notes data as simple tables you need to configure this export to match the application requirements.
Salgiza’s answer to this question has more detail on this.
JDBC Drivers for Lotus Domino and IMS
Post as a guest Name. If you enable http on the domino server, you can get xml data out of views. Searching Google for “java lotus notes jdbc” yields this note from IBM:.
If you just need to provide external access to a relatively fixed query a web service built into the application is a good way to go. The Java toolkit is the least mature jebc the three and can be used for basic application needs.
JDBC driver for Lotus Notes (JDBC and Relational Databases forum at Coderanch)
Lotus Notes is not a relational database, I do recall from some time ago, they started supporting java instead of lotus script, there is a good chance that they support an external java API. What I need is an equivalent. Here are a few things to keep in mind about the DomSQL driver: A simpler option might be to use http and xml assuming you only want to read data? Sign up or log in Sign up using Google.
Another option is to use the wrapper api Domingo which takes some of the jdvc off notes.
Sign up using Facebook. I noticed on the toolkit page that they support an odbc driver, so you should be able to use the jdbc-odbc bridge. Internally this would use the native notes api java or lotusscript and you’d probably want to get the developer of the database o do that for you.
To directly interact with the data with java you need to use the Notes java api using Notes. This gives you a notes style access udbc the data. If you really need to have free access to the data and want to query it with SQL you will have to export it to an RDBMS through a number of tools and some of these can keep your data in sync.
There are jebc various built in search facilities.
Email Required, but never shown. Searching Google for “java lotus notes jdbc” yields this note from IBM: