Viewing Issue Advanced Details Jump to Notes ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0001022 [Talend Open Studio] Java components feature always 2007-04-25 09:53 2008-03-21 21:24
Reporter mhirt View Status public  
Assigned To mhirt
Priority high Resolution fixed Platform
Status closed   OS
Projection none   OS Version
ETA none Fixed in Version 2.1.0 Product Version
  Target Version Product Build
Summary 0001022: Java tSQLLite Component
Description Develop this new DB Component with all options.
Steps To Reproduce
Additional Information
Tags No tags attached.
generated language
workload (in half days)
Attached Files

- Relationships
parent of 0001067closedrbillerey Perl tSQLite Components 

-  Notes
User avatar (0001774)
yzhang (developer)
2007-05-08 20:16
edited on: 2007-05-08 20:23

the input component had been developed, code committed on trunk [Subversion, tos] r3387

the last two components(tSQLiteOuput, tSQLiteRow) are feedback to cshan.

(0001790)
cshan (reporter)
2007-05-09 23:12

output and row components under this requirement had been committed on trunk [Subversion, tos] r3407
(0001791)
cshan (reporter)
2007-05-09 23:13

output and row components under this requirement had been committed on trunk [Subversion, tos] r3407
User avatar (0002072)
mhirt (administrator)
2007-06-04 15:45

Use JDBC to connect to SQLLite (http://talendforge.org/forum/viewtopic.php?id=721) [^]
(0002201)
cshan (reporter)
2007-06-13 08:13

[Subversion, tos] r3812
Modified tSQLiteInput, tSQLiteOutput and tSQLiteRow components in order to use jdbc to connect SQLite.
User avatar (0002206)
nrousseau (administrator)
2007-06-13 09:34

Note that there is the same problem as the tJavaDb for the property type. (i added the note for cshan only in the tJavaDb)
(0002342)
jgottero (reporter)
2007-06-19 17:11

Tests :
tSQLiteInput - Tested with all TOS types, null and not null
tSQLiteOutput - Tested "insert", "update", "update or insert", "insert or update", "delete" with all TOS types, null and not null

Errors :
tSQLiteInput - Cannot read null values for double and float types
tSQLiteOutput - Wrong date inserted in SQLite (for example, try a tRowGenerator with a single field date, function getCurrentDate, and link it to a tSQLiteOutput. The date I get in SQLite is 30/12/1899)
(0002361)
cshan (reporter)
2007-06-20 12:56

This bug occurs only with nested DB.
reference:http://groups.google.com/group/sqlitejdbc/msg/d0e737c8da486b51 [^]
User avatar (0002363)
mhirt (administrator)
2007-06-20 14:07

We use driver 0.33 from January.
Error has been corrected in March.
Last version 0.34 has been released a few days ago.
Upgrade it AND try it.
(0002405)
cshan (reporter)
2007-06-23 07:35

i change the jdbc driver to the latest version,but the bug remain exists.

- Issue History
Date Modified Username Field Change
2007-04-25 09:53 mhirt New Issue
2007-04-25 09:53 mhirt Status new => feedback from Talend
2007-04-25 09:53 mhirt Assigned To => yzhang
2007-04-25 19:48 yzhang Status feedback from Talend => confirmed
2007-05-07 02:03 yzhang Status confirmed => assigned
2007-05-08 20:16 yzhang Note Added: 0001774
2007-05-08 20:16 yzhang Assigned To yzhang => cshan
2007-05-08 20:16 yzhang Status assigned => feedback from Talend
2007-05-08 20:23 yzhang Note Edited: 0001774
2007-05-09 23:08 cshan Status feedback from Talend => confirmed
2007-05-09 23:08 cshan Status confirmed => assigned
2007-05-09 23:12 cshan Note Added: 0001790
2007-05-09 23:12 cshan Assigned To cshan => mhirt
2007-05-09 23:12 cshan Status assigned => feedback from Talend
2007-05-09 23:13 cshan Note Added: 0001791
2007-05-10 01:23 rbillerey Issue cloned 0001067
2007-05-10 01:23 rbillerey Relationship added parent of 0001067
2007-06-04 15:42 mhirt Assigned To mhirt => cshan
2007-06-04 15:45 mhirt Note Added: 0002072
2007-06-04 15:45 mhirt Priority normal => high
2007-06-06 07:34 cshan Status feedback from Talend => confirmed
2007-06-13 08:12 cshan Status confirmed => assigned
2007-06-13 08:13 cshan Note Added: 0002201
2007-06-13 08:13 cshan Assigned To cshan => nrousseau
2007-06-13 08:13 cshan Status assigned => toVerify
2007-06-13 09:34 nrousseau Note Added: 0002206
2007-06-13 09:34 nrousseau Assigned To nrousseau => mhirt
2007-06-13 12:16 mhirt Status toVerify => feedback from Talend
2007-06-13 12:16 mhirt Assigned To mhirt => jgottero
2007-06-13 12:16 mhirt Status feedback from Talend => toVerify
2007-06-19 17:11 jgottero Note Added: 0002342
2007-06-19 17:12 jgottero Status toVerify => feedback from Talend
2007-06-19 17:12 jgottero Assigned To jgottero => cshan
2007-06-19 17:12 jgottero Status feedback from Talend => assigned
2007-06-20 12:56 cshan Note Added: 0002361
2007-06-20 14:07 mhirt Note Added: 0002363
2007-06-23 07:35 cshan Note Added: 0002405
2007-07-10 01:05 mhirt Status assigned => resolved/needs doc
2007-07-10 01:05 mhirt Fixed in Version => 2.1.0
2007-07-10 01:05 mhirt Resolution open => fixed
2007-07-16 12:39 plegall Status resolved/needs doc => closed
2008-03-21 21:24 mhirt Assigned To cshan => mhirt


Mantis 1.1.6[^]
Copyright © 2000 - 2007 Mantis Group
Powered by Mantis Bugtracker
Copyright © 2006 - 2009 Talend. All rights reserved. Talend Contributor Agreement