I have downloaded ICE+Talend+Jasper integrated virtual machine, and after same tryings designed a simple Talend ETL Job. The job contains a tOracleInput as source of data, a tMap component transforming the data and a tInfobrightOutput as data destination.

The tOracleInput and tMap transformation are working fine, as I can see the processed data with a tLogRow component. But when I connect the tMap output to the tInfobrightOutput component the following exception appears:

Exception in componen tInfobrightOutput_1
java.net.ConnectException: Connection refused
  at java.net.PlainSocketImpl.socketConnect(Native Method)
  at .......
  at java.net.Socket.<init>(Socket.java:180)
  at com.infobright.io.ClientProxy<init>(ClientProxy.java:55)
  at com.infobright.ioInfobrightNamedPipeLoader.<init>(InfobrightNamedPipeLoader.java:132)
  at myproject.etl1_0_1.ETL1.tOracleInput_1Process(ETL1.java:1312)
  at myproject.etl1_0_1.ETL1.runJobInTOS(ETL1.java:2031)
  at myproject.etl1_0_1.ETL1.main(ETL1.java:1926)

The tInfobright component settings are:

Property Type: Built-in   ||  Infobright product: Community
Host: 172.xx.xx.xx   ||  Port: 5029   ||  Database: test
Username: ice   ||  Password: infobright
Table: consumos   ||  Action on table: Create table if not exist

Despite the error, the table is created with Infobright engine but no data is loaded (so some connection has been established)

Any ideas?

Thanks

Hi Emanrique,

If this is a local connection, make sure that the hostname specified in the connector dialog matches exactly “localhost” or “127.0.0.1”. You can’t use your server’s hostname here.

If this is a remote connection, you need to start the agent on the remote (Infobright) server.  This is only needed for remote connections.

To start the agent, do “java -jar infobright-core-3.x.jar” on the Infobright server (where x >= 1)

Geoffrey

Thank you

It works!