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