users@glassfish.java.net

RE: How to support a new Database in Toplink

From: Markus Karg <karg_at_quipsy.de>
Date: Tue, 30 Jun 2009 17:03:11 +0200

Hi,

I have integrated SQL Anywhere into TopLink with the kind help of Oracle's TopLink Team. I think it is best if you write to tom.ware_at_oracle.com to get more details. There are two things you must be aware of: (A) There is no more TopLink but it was replaced by EclipseLink, which now is basing on OSGi; that means, a bit higher complexity in setting up the project. (B) The code has a lot of tweaks and shortcuts, so it is a bit more work than just typing some SQL commands. You should be prepared to spend about one week of work into a good driver, but a first stable driver can be done in one or two days. The actual amount of work is dependend on your personal target: If the driver is just for you, then you can stop after one day, as it will work. But if the driver is intended to get shipped with the EclipseLink box (as mine was), then you have to spend more time to fulfil the rather big test suite. If you like, you can have a look at the SQLAnywherePlatform file found in the EclipseLink source code. It is 99% of what I coded and might be a good starting point, but you should keep in mind that there might be about 1% of other places of EclipseLink itself (outside of your driver) which needs to get tweaked to make your driver run, unfortunately.

You really like to support PervasiveSQL? Wow, didn't think that this product still is alive.

Regards
Markus

> -----Original Message-----
> From: glassfish_at_javadesktop.org [mailto:glassfish_at_javadesktop.org]
> Sent: Dienstag, 30. Juni 2009 16:01
> To: users_at_glassfish.dev.java.net
> Subject: How to support a new Database in Toplink
>
> Hi at all,
>
> can anybody give me a hint, what I have to read to learn, how I can
> extend TopLink in such a way, that it will support a database which is
> not supported out of the box. In my case, I have to integrate support
> vor Pervasive SQL. Thanks in advance.
>
> Markus
> [Message sent by forum member 'atrav99' (atrav99)]
>
> http://forums.java.net/jive/thread.jspa?messageID=353570
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net