robinzone

Hi, I've tried to reproduce your situation. I created file with the follow content: 1field1value1<\n> 2field2value2<\n> 3value3 Added tFileInputDelimited and tLogRow and connected them. Also I've added a generic schema with 3 fields - id, field, value - and set it to tFileInputDelimited. In tFileInputDelimited I've changed "Field Separator" to "\t". When I run it, this what i've got. Starting job job_import_tab at 13:25 06/05/2009. 1|field1|value1 2|field2|value2 3||value3 Job job_import_tab ended at 13:25 06/05/2009. [exit code=0] So, seems like it's work for me. I used JasperETL (2.3.2.r12707) Regards

Hi, try to allocate more memory for java for example: JAVA_OPTS=-Xmx768m -Xms768m (it's a system env. var so in windows "set JAVA_OPTS=..." or in linux "export JAVA_OPTS=....") You can try with 256m and up, until it works for you Post Edited by Robert Rogovich at 04/17/09 22:24

In mysql there is "show tables;" to get list of tables, something similar must be in postgres. the next step is "show fields from <TABLE_NAME>" to create tables using these fields and field types from result.

Hi, i've tried to reproduce your situation. /userfiles/1.jpg I get data from xml file <?xml version="1.0" encoding="ISO-8859-15"?> <account> <row> <id>1</id> </row> </account> this id=1 sets into table1_test.id (tinyint) - so it should work Starting job test_job2 at 18:05 05/04/2009. 1 Job test_job2 ended at 18:05 05/04/2009. [exit code=0] Then I try an incorrect data (string value set to tinyint) <?xml version="1.0" encoding="ISO-8859-15"?> <account> <row> <id>test</id> </row> </account> The result is Starting job test_job2 at 19:39 05/04/2009. Exception in component tMysqlOutput_1 java.sql.SQLException: Incorrect integer value: 'test' for column 'id' at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710) at com.mysql.jdbc.Connection.execSQL(Connection.java:2436) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1694) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1608) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1593) at first_java_project.test_job2.test_job2.tFileInputXML_1Process(test_job2.java:409) at first_java_project.test_job2.test_job2.runJobInTOS(test_job2.java:765) at first_java_project.test_job2.test_job2.main(test_job2.java:681) ===========INSERT ERROR========== Job test_job2 ended at 19:39 05/04/2009. [exit code=0] "===========INSERT ERROR==========" it's a die message, so seems like the flow works for me.

it's a talend bug. Fixed in 2.3.3 version.