You are not logged in.
There is already a bugtracking entry about this issue.
See : http://www.talendforge.org/bugs/view.php?id=7009
same problem with TOS 3.0.4.r22547 and no solution
I have the same pb : colomun nb 0 with a SQLite DB.
Did you find a solution ?
I'm having trouble reading schemas from SQLite. I've search and researched and can't find the solution. It seems other have report similar problems with other databases. These were turned into bugs and fixed in the 2.4 versions.
I'm running TOS 3.0.2. I have an sqlite3 database file that has two tables in it. I created the two tables as follows:
$ sqlite3 workarea.sqlite
SQLite version 3.6.5
Enter ".help" for instructions
sqlite> create table tbl1(one varchar(10), two smallint);
sqlite> insert into tbl1 values('hello!',10);
sqlite> insert into tbl1 values('goodbye', 20);
sqlite> select * from tbl1;
sqlite> CREATE TABLE tbl2 (
...> f1 varchar(30) primary key,
...> f2 text,
...> f3 real
I create a DB connection and that works fine. I select the Retrieve Schema and it finds the two tables. I select both tables, but the column number stays at 0. The Creation status is Success.
I'm using the sqlite nested v037 jar that comes with TOS.
Has anyone been success in using sqlite with TOS 3.0.2? If so, were you able to retrieve the schemas? Any help appreciated.