Hi again...
As I get deeper into this, I seem to be finding other odds and ends...
I am trying to execute some SQL under the covers and I'm getting this...
java.sql.SQLException: statement is not executing
at org.sqlite.Stmt.checkOpen(Stmt.java:41)
at org.sqlite.Stmt.setMaxRows(Stmt.java:199)
Any ideas?
--Fitz
Brian Fitzpatrick
Eclipse Data Tools Platform PMC Chair
Eclipse Data Tools Platform Connectivity Team Lead
Staff Software Engineer, Sybase, Inc.
"Brian Fitzpatrick" <[EMAIL PROTECTED]>
Sent by: [email protected]
09/25/2008 03:49 PM
Please respond to
[email protected]
To
[email protected]
cc
Subject
[sqlitejdbc] Re: Support for SQLite using SQLiteJDBC at Eclipse DTP
Hey David!
It's the former actually. Just a zip file with some plug-in metadata and a
the SQLite JDBC files. Nothing fancy. I just think it would be easier for
Eclipse developers to just download that, plop it into their Eclipse
installation, and run with it. It's pretty easy.
I have hit a few odds and ends with the driver actually. Because of the
way we load our model in DTP, I had to dummy up a schema to keep it happy
(which is fine). I also had to work around the lack of foreign key support
in the driver (by basically just ignoring the foreign keys at this point).
But other than that it was very straightforward.
Let me get a bit further with the code and I'll ping you once I have a
version of the wrapper I can send you.
Does that sound like a plan?
Thanks for the quick response!
--Fitz
On Thu, Sep 25, 2008 at 3:44 PM, David Crawshaw <[EMAIL PROTECTED]> wrote:
Hi Brian,
I would be happy to host your DTP SQLite plugin. Does it embed the
driver's jar file, or is it a separate file? If the former, I will add
it to my build process to keep it up to date.
Tell me if you run into any limits with the driver, particularly in
the meta data department. I don't use any tools that ask for
programatic access to the meta data, so I often hear from people that
some important part has been left out that looked both optional and
useless to me.
Cheers,
David
2008/9/26 Fitz <[EMAIL PROTECTED]>:
>
> Hi there...
>
> My name is Brian Fitzpatrick. I'm currently working on the Eclipse
> Data Tools Platform (DTP) project, and we'd like to add support for
> SQLite as one of the supported JDBC databases in DTP.
>
> As a part of that effort, we'd like to recommend use of the SQLiteJDBC
> driver, which has worked out well for us.
>
> Would you be opposed to us doing that? We've had several inquiries
> about adding SQLite support over the last couple of years.
>
> We're also wondering if you'd mind hosting an Eclipse plug-in wrapper
> on the SQLiteJDBC download page that wraps the SQLite JDBC driver jar
> in an Eclipse plug-in. This would allow a developer to just download
> that, drop it into their Eclipse environment, and simplify the process
> a bit.
>
> It wouldn't really involve anything from your side of things beyond
> that (if you don't mind doing that)... We'd be doing the work creating
> the wrapper and hosting the other necessary plug-ins at the Eclipse
> site. The only time we might bug you is for any support questions
> regarding anything that comes up from a development standpoint (custom
> SQL or whatnot). And I already have most of the code already working
> with the your driver now.
>
> If you're interested, I've posted a number of articles on my progress
> integrating with SQLite and DTP at my blog. The last of them is here:
>
http://fitzdtp.blogspot.com/2008/08/creating-sqlite-connection-profile-ui.html
>
> Thanks in advance and look forward to hearing from you!
> --Fitz
>
> Brian Fitzpatrick
> Eclipse Data Tools Platform PMC Chair
> Eclipse Data Tools Platform Connectivity Team Lead
> Staff Software Engineer, Sybase, Inc.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
