[OutofMemoryError running etl job]

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

[Transfer Entire Database to another Database]

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.

[tMysqlOutput treat a failed INSERT as error?]

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.

 

 

 

[Generate Doc as Html but html page is blank]

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