Hello Jurgen, sorry for my late (I've been off-line since 2 weeks due to adsl problem).
I've never used clean option. What is it? How do I have to use it? Thanks. Cheers On Wed, Jun 10, 2009 at 7:43 AM, Juergen Schwitalla < j.schwita...@science-computing.de> wrote: > 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 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users