[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [dtp-dev] Cannot access SQLite tables
|
Interesting...
Well, using the latest code (from 1.8.1), I'm able to connect to an empty SQLite database.
And I'm able to connect to your database as well and can drill into your two tables in there.
Can you try updating to DTP 1.7.2, which is the latest and greatest in the 1.7.x stream?
--Fitz
_______________________________
Brian Fitzpatrick (aka "Fitz")
Senior Software Engineer, SOA-P
JBoss by Red Hat
----- Original Message -----
From: "Janosch Peters" <jp@xxxxxxxxxxxxxx>
To: "DTP development mailing list" <dtp-dev@xxxxxxxxxxx>
Sent: Thursday, August 12, 2010 8:01:15 AM GMT -07:00 US/Canada Mountain
Subject: Re: [dtp-dev] Cannot access SQLite tables
Am 12.08.2010 15:30, schrieb Brian Fitzpatrick:
Hi Janosch,
What version of Eclipse and DTP are you using? The version is 1.7.0.v200906050400. I just installed it yesterday.
We added SQLite support (via a new connection profile and driver template) back in DTP 1.7 (Eclipse 3.5) I believe. If you're using the Generic JDBC profile, it won't work because of the unique requirements of SQLite DBs. As I said, I tried both approaches. I also tried the SQLite JDBC driver (v 3.6.22). I think the tables cannot be edited because the data types of the columns are not recognized. The error message of one of the exception tells me that the " statement is not executing". I uploaded the sqlite file, if you'd like to test this in your environment: http://home.in.tum.de/~petersj/recognosco.db
cheers,
Janosch
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev
