Accessing a database via an API

Classic Servoy
1

Is it possible to use a COM API to query / update a database rather than going directly to the tables?

We have an application that has a COM API that has the business rules / validation etc.

We can use the Query method to read data from the database, the Replace , TableUpdate method to write data back etc.

Is this possible?

Are we able to map the methods and properties directly into Servoy and access them?

Cheers
David

2

Yes, that is possible but you would need java<->com bridge libraries for that.

When you have that the challenge will be:

  1. find the correct com functions to address.

  2. generate a .dll

  3. create a plug-in using the .dll

  4. deploy the dll

  5. will take time.

  6. is an automated process

  7. not much different from creating any other plug-in

  8. is pretty straight forward ( once you know what to do :) ).

Hope this helps

3

You can look for the jacob.jar and jacob.dll, which is an open source solution for connecting Java applications to a Windows COM OLE application.

If you google you will find the site http://danadler.com/jacob/ en other websites on the subject as well.