[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [dtp-dev] Re: DTP support for SQLite DB
|
Just as an aside, I just tested in a workspace where I have two different SQLite database files. The driver loads successfully the first time for either of my two profiles. And I can connect and disconnect from that one just fine. But I am not allowed to connect to a second database. I am getting an unsatisified link error.
Unable to load sqlite: java.lang.UnsatisfiedLinkError: Native Library C:\Program Files\Java\j2re1.4.2_12\bin\sqlite_jni.dll already loaded in another classloader
I suspect that there are other issues with this JDBC driver. I don't have the same issue with Derby (which also is a little flaky with how they load drivers). We may need to write a custom connection class and custom catalog loader to handle SQLite's unique requirements.
--Fitz
Brian Fitzpatrick
Senior Software Engineer/DTP Committer
Sybase, Inc.
-----dtp-dev-bounces@xxxxxxxxxxx wrote: -----
To: "Benedetta Turchi" <bturchi@xxxxxxxxxxx>
From: brian.fitzpatrick@xxxxxxxxxx
Sent by: dtp-dev-bounces@xxxxxxxxxxx
Date: 11/08/2006 11:50AM
cc: dtp-dev@xxxxxxxxxxx
Subject: [dtp-dev] Re: DTP support for SQLite DB
Hi Benedetta...
--Fitz
Brian Fitzpatrick
Senior Software Engineer/DTP Committer
Sybase, Inc.
-----"Benedetta Turchi" <bturchi@xxxxxxxxxxx> wrote: -----
To: brian.fitzpatrick@xxxxxxxxxx
From: "Benedetta Turchi" <bturchi@xxxxxxxxxxx>
Date: 11/08/2006 11:33AM
Subject: DTP support for SQLite DB
Hi Brian,
did you specify the sqlitejdbc.jar as driver file? Because now I am getting
the error in the attachment.
I simply did the unzip of the new build in the eclipse directory and then
launched eclipse and I changed the spec of the JDBC connection (now the
Driver Class is set properly by the new wizard). Then I created a new
benejdb connection profile.
Thank you
Benedetta
>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
>
>_______________________________________________
>dtp-dev mailing list
>dtp-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/dtp-dev
_________________________________________________________________
Usa il tuo PC come un telefono per chiamare cellulari e telefoni fissi!
http://imagine-msn.com/messenger/launch80/?locale=it-it&TAB=2
[attachment "error.bmp" removed by Brian Fitzpatrick/SYBASE]
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev