Hello Enrico,
just to be sure: have you used the -clean option when restarting eclipse?
cheers
Jürgen Schwitalla
On Tue, 9 Jun 2009, Enrico Piccinini wrote:
I'm not working with standard java app, I succedded in creating that. But
wasn't what I had to do.
I've to integrate sqlite into an RCP ECLIPSE application. To do that I've to
use one of the standard method of import "external jar" into the application
that is more tricky than simply include jar. One of these methods is to
create a "Plugin from jar" and include in my application the plugin. I leave
this site that explain what I said after:
http://www.vogella.de/articles/RichClientPlatform/article.html#usingexternaljars
.
I hope you'll more ideas.
Enrico
On Tue, Jun 9, 2009 at 12:44 PM, Enrico Piccinini <
enrico.piccin...@gmail.com> wrote:
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
_________________________________________creating IT solutions
Dr. Juergen Schwitalla science + computing ag
scVENUS Software Entwicklung Hagellocher Weg 71-75
phone +49(0)7071 9457-256 72070 Tuebingen, Germany
fax +49(0)7071 9457-222 www.science-computing.de
j.schwita...@science-computing.de
--
Vorstand/Board of Management:
Dr. Bernd Finkbeiner, Dr. Roland Niemeier,
Dr. Arno Steitz, Dr. Ingrid Zech
Vorsitzender des Aufsichtsrats/
Chairman of the Supervisory Board:
Michel Lepert
Sitz/Registered Office: Tuebingen
Registergericht/Registration Court: Stuttgart
Registernummer/Commercial Register No.: HRB 382196
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
