Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

PaulMandalka
2009-04-23 08:45:28

There is already a bugtracking entry about this issue.
See : http://www.talendforge.org/bugs/view.php?id=7009

user
2009-04-22 14:16:04

same problem with TOS 3.0.4.r22547 and no solution

ojouny
2009-04-20 12:13:34

I have the same pb : colomun nb 0 with a SQLite DB.

Did you find a solution ?

Regards,

toolboy
2009-01-15 18:34:29

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;
hello!|10
goodbye|20
sqlite>
sqlite> CREATE TABLE tbl2 (
   ...>   f1 varchar(30) primary key,
   ...>   f2 text,
   ...>   f3 real
   ...> );
sqlite>


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.

Board footer

Powered by FluxBB