I everybody!
Has anyone of you have never exerienced the integration of sqlite jdbc
(zentus v.054) in an application Eclipse RCP (Ganymede)?
I've tried many ways found on internet, but even the classical one
(generating a plugin starting from .jar and including this plugin in my rcp
application) doesen't work.
It always gives me an excption creating the connection
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
Any advice?
Thnx a lot
Enrico
On Tue, Jun 9, 2009 at 12:11 PM, Susan Shippey <theshipp...@blueyonder.co.uk
> wrote:
> Hi,
>
> I get the following error with SQLite 3.6.1
>
> "1st ORDER BY term does not match any column in the result set"
>
> From the following query
> "SELECT id, url, selected, FROM db1.test UNION
> SELECT id, url, selected, FROM db2.test
> ORDER BY name ASC, id DESC LIMIT 100"
>
> However the equivalent with a single DB i.e. without the UNION seems to
> work
> fine.
>
> Is there a general restriction that ORDER BY terms must be in the result
> set? And if so why doesn't it kick in without the UNION?
>
> And is there a performance cost to adding the ORDER term to the result set,
> given that we are ordering by it anyway?
>
> Many thanks,
> Tom
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
