[Solved] tRunJob tHashInput tHashOutput

[AlessandroCic]

Hi

I would like to use a the data stored in a tHashOutput from a job parent in to a job child.

 

 

How can I do this?

Regards

Alessandro

[Anonymous]

Change your tHash components to be tHSQLDbOutput and tHSQDbInput components (using a "Running Mode" of "HSQLDb in Memory"). These will do what your Hash components will, but will keep the data in a temporary in-memory HyperSQL DB. This will make the data available throughout your jobs (that are currently running) and the DB will disappear when the job finishes running.

You can also use SQL queries with these components, which means you can do a lot more than you can with the tHash components.

Take a look at the documentation here: https://help.talend.com/r/en-US/8.0/hsqldb/thsqldboutput

[AlessandroCic]

Hi rhall

Thanks for the reply, I did not know this component.

Now the job is:

the values ​​of the component tHSQLDbOutput can be as desired, imaginative (I invented DbName, UserName and Password) but then they must be the same in tHSQLDbInput.

 

Thanks and regards

Alessandro

[Anonymous]

Glad it worked for you. These components share all of the qualities of the tHash components......with MANY more. You can update, filter in queries, delete, etc, etc. I much prefer these.

[kakooo16]

hi @Richard Hall​ , i tried your method using a simple test ,

tfixedflowinput -> thsqldboutput with (mode execution as HSQLDb in Memory) -> tlogRow

I got this error ,

Exception in component tHSQLDbOutput_1 (talnb)

java.sql.SQLSyntaxErrorException: precision or scale out of range

at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)

at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)

Learning how to work with this component is intersting

How could i solve this

[Anonymous]

This is because you have not set the length or precision for each column in the your schema going to your tHSQLDBOutput. I briefly talk about this here....

https://community.talend.com/s/feed/0D75b000005yRDCCA2