From: brian.fitzpatrick@xxxxxxxxxx
Reply-To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
Subject: Re: [dtp-dev] DTP support for SQLite DB
Date: Wed, 8 Nov 2006 08:21:19 -0800
Ok. Final update and then I'll stop on this topic for now. Using the
driver you mentioned for SQLite yesterday (
http://www.ch-werner.de/javasqlite/ )... I was able to connect to and
browse my SQlite test database just fine. You might want to verify that
everything looks copacetic, but it came back with my table and displayed
its columns.
So let me know how it works for you.
Brian Fitzpatrick
Senior Software Engineer/DTP Committer
Sybase, Inc.
-----dtp-dev-bounces@xxxxxxxxxxx wrote: -----
To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
From: brian.fitzpatrick@xxxxxxxxxx
Sent by: dtp-dev-bounces@xxxxxxxxxxx
Date: 11/08/2006 08:58AM
Subject: Re: [dtp-dev] DTP support for SQLite DB
By the way, we were unable to find the driver you mentioned for SQLite
yesterday ( http://www.ch-werner.de/javasqlite/ ) (seems to be accessible
today). Ended up finding a different one at
http://www.zentus.com/sqlitejdbc/ . At any rate, ended up with the same
issue you found with the first driver. And I was able to connect to a
local SQlite database with one table. Note however that the Generic JDBC
catalog loaders don't seem to get what they need from the SQLlite driver.
It brings up the Schemas folder, but there's nothing beneath it. In order
to read a SQLite db, we may need to come up with a custom catalog loader
like we did for Derby.
--Fitz
Brian Fitzpatrick
Senior Software Engineer/DTP Committer
Sybase, Inc.
-----dtp-dev-bounces@xxxxxxxxxxx wrote: -----
To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
From: brian.fitzpatrick@xxxxxxxxxx
Sent by: dtp-dev-bounces@xxxxxxxxxxx
Date: 11/08/2006 08:40AM
Subject: Re: [dtp-dev] DTP support for SQLite DB
Just delivered the fix last night. Should appear in today's build. The
issue still remains if a driver has been loaded into a classloader. At
this time, there isn't a way to "unload" it if the jars or classname for a
given driver instance have changed. You can change the jars and class name
and try to reconnect to any profile using that driver. If you get an error
saying the class was already loaded in a classloader, you will have to
close and restart Eclipse before the change will be picked up.
Can you give it a shot with today's build when it becomes available?
Brian Fitzpatrick
Senior Software Engineer/DTP Committer
Sybase, Inc.
-----dtp-dev-bounces@xxxxxxxxxxx wrote: -----
To: dtp-dev@xxxxxxxxxxx
From: "Benedetta Turchi" <bturchi@xxxxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx
Date: 11/08/2006 08:02AM
Subject: Re: [dtp-dev] DTP support for SQLite DB
Hi,
since I need to decide if I can use DTP for my next project, can I ask you
when approximately is this defect
( https://bugs.eclipse.org/bugs/show_bug.cgi?id=162625 ) going to be
fixed?
Thank you!
Benedetta
>From: jograham@xxxxxxxxxx
>Reply-To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
>To: DTP development mailing list <dtp-dev@xxxxxxxxxxx>
>Subject: Re: [dtp-dev] DTP support for SQLite DB
>Date: Fri, 3 Nov 2006 16:50:35 -0500
>
>Hi Benedetta,
>
>While DTP doesn't support SQLite specifically at the moment, we do have
>generic JDBC support through our SQL model. If you can get a JDBC
>connection to SQLite, then there's a chance you can use DTP as-is today.
I
>say "a chance" because the generic support makes assumptions about the
>behavior of the JDBC driver, and we do have a bug about using native
code
>( https://bugs.eclipse.org/bugs/show_bug.cgi?id=162625 ).
>
>Also, in the bug mentioned above, a reporter mentions successfully using
>SQLite with DTP. I'll forward this email to him to see if he can help
out.
>
>Regards,
>John Graham
>Eclipse Data Tools Platform PMC Chair
>Staff Software Engineer, Sybase, Inc.
> http://dataplat.blogspot.com/
>
>
>
>
> "Benedetta
> Turchi"
> <bturchi@hotmail.
To
> com> dtp-dev@xxxxxxxxxxx
> Sent by:
cc
> dtp-dev-bounces@e
> clipse.org
Subject
> [dtp-dev] DTP support for SQLite
DB
>
> 11/03/2006 12:52
> PM
>
>
> Please respond to
> DTP development
> mailing list
> <dtp-dev@eclipse.
> org>
>
>
>
>
>
>
>Hi,
>
>my next project is to create a tool to enable a user to create an SQLite
>database file using SQL scripts for schema and data. So I was wondering
if
>I
>could use DTP.
>I know that SQLite DB is not supported by DTP at the moment, so I was
>wondering about the effort of adding this support.
>
>Thank you
>Benedetta
>
>_________________________________________________________________
>Manda messaggi istantanei dal tuo account di Hotmail!
> http://join.msn.com/hotmail/features-std#6
>
>_______________________________________________
>dtp-dev mailing list
>dtp-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/dtp-dev
>
>
>
>_______________________________________________
>dtp-dev mailing list
>dtp-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/dtp-dev
_________________________________________________________________
Aggiungi il modulo Amici al tuo Spaces con un click!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=it-it
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
