How can we make Mysql connection

CloverDX Platform
1

Heloo sir,
I am trying to load data into mysql database in the fo;;owing process

universaldatawriter---->simplecopy----->mysqldatawriter.

When i am trying to validate the connection, it is showing “communication link failed”.
How can we make connection to mysql database incloverETL, here which driver has to use.

i am getting following error while executing the graph.

INFO [main] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriver@102799c]:jndi[null]:url[jdbc:mysql://hostname:3306/etlproject]:user[root] … OK
INFO [main] - [Clover] Initializing phase: 0
ERROR [main] - Error during graph initialization !
Element [1297752681500:SimpleLoad]-Phase 0 can’t be initilized.
at org.jetel.graph.TransformationGraph.init(TransformationGraph.java:453)
at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer.java:176)
at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer.java:147)
at org.jetel.main.runGraph.runGraph(runGraph.java:364)
at org.jetel.main.runGraph.main(runGraph.java:328)
Caused by: MYSQL_DATA_WRITER0 …FAILED !
Reason: Error during initialization of MysqlPortDataConsumer.
at org.jetel.graph.Phase.init(Phase.java:168)
at org.jetel.graph.TransformationGraph.init(TransformationGraph.java:451)
… 4 more
Caused by: Element [MYSQL_DATA_WRITER0:MysqlDataWriter]-Error during initialization of MysqlPortDataConsumer.
at org.jetel.component.MysqlDataWriter.createConsumers(MysqlDataWriter.java:729)
at org.jetel.component.BulkLoader.init(BulkLoader.java:169)
at org.jetel.graph.Phase.init(Phase.java:163)
… 5 more
Caused by: First field of “SimpleLoad” has different type from integer.
at org.jetel.component.MysqlDataWriter$MysqlPortDataConsumer.checkErrPortMetadata(MysqlDataWriter.java:1226)
at org.jetel.component.MysqlDataWriter$MysqlPortDataConsumer.(MysqlDataWriter.java:1130)
at org.jetel.component.MysqlDataWriter.createConsumers(MysqlDataWriter.java:726)

2

Your error metadata does not satisfy the required structure (see Error Metadata for MySQLDataWriter).
BTW: if you use MySQLDataWriter for inserting the data into database, you don’t need a db connection in your graph. Database connection is used, when inserting data to database with DBOutputTable.

3

Yah, i tried in that way,
now the connection validation is correct.
here what is “path to mysql utility”

when i am executing i am getting following error…

Node MYSQL_DATA_WRITER0 finished with status: ERROR caused by: Cannot run program “./conn/sqlcon.cfg”: CreateProcess error=193, %1 is not a valid Win32 application
ERROR [WatchDog] - Node MYSQL_DATA_WRITER0 error details:
java.io.IOException: Cannot run program “./conn/sqlcon.cfg”: CreateProcess error=193, %1 is not a valid Win32 application
at java.lang.ProcessBuilder.start(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at org.jetel.component.BulkLoader.createProcBox(BulkLoader.java:368)
at org.jetel.component.BulkLoader.createProcBox(BulkLoader.java:385)
at org.jetel.component.MysqlDataWriter.execute(MysqlDataWriter.java:499)
at org.jetel.graph.Node.run(Node.java:425)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException: CreateProcess error=193, %1 is not a valid Win32 application
at java.lang.ProcessImpl.create(Native Method)
at java.lang.ProcessImpl.(Unknown Source)
at java.lang.ProcessImpl.start(Unknown Source)
… 8 more

4

To run the MySQLDataWriter writer component, the mysql client must be installed on the same machine as the graph is running on and mysql command line tool (mysql or mysql.exe) must be available. If you want to connect through jdbc, use DBOutputTable component.