You are very welcome. Glad we got it to work!
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/09/2006 07:33AM
Subject: Re: DTP support for SQLite DB
Hi Brian,
yes I had included the dll in the /bin directory of my JRE but then probably
I forgot to close eclipse and re-open it. Now it is working fine.
Thank you very much for all your help, and I am happy that DTP can now
support a generic JDBC connection.
Regards
Benedetta
>From: brian.fitzpatrick@xxxxxxxxxx
>To: "Benedetta Turchi" <bturchi@xxxxxxxxxxx>
>Subject: Re: DTP support for SQLite DB
>Date: Thu, 9 Nov 2006 06:00:09 -0800
>
>There's a dll in the zip file along with the jar. That needs to be put in
>your JRE's bin folder. That's the link that isn't being satisfied. See step
>#2 in the Wiki I referenced earlier.
>
>
>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/09/2006 04:56AM
>Subject: Re: DTP support for SQLite DB
>
>Thanks Brian,
>
>I am getting an error now, while trying to Ping the DB from the Connection
>Profile definition wizard.
>In attachment you can see the error.
>Sorry for bothering you again ...
>
>Thank you
>Benedetta
>
> >From: brian.fitzpatrick@xxxxxxxxxx
> >To: "Benedetta Turchi" <bturchi@xxxxxxxxxxx>
> >CC: dtp-dev@xxxxxxxxxxx
> >Subject: Re: DTP support for SQLite DB
> >Date: Wed, 8 Nov 2006 10:50:03 -0800
> >
> >Hi Benedetta... I used the sqlite.jar from the
> >http://www.ch-werner.de/javasqlite/javasqlite-20060714-win32.zip. Not
>sure
> >where the other jar is you mentioned. Check out
> >http://wiki.eclipse.org/index.php/How_Do_I_Connect_to for the steps I
>used
> >to connect.
> >--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]
>
>_________________________________________________________________
>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
>
_________________________________________________________________
Chiama gratis con Windows Live Messenger
http://imagine-msn.com/messenger/launch80/?locale=it-it&TAB=2
