How can we make Mysql connection

sankardunga

• February 15, 2011 00:00

• Answered

Follow

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.<init>(MysqlDataWriter.java:1130)
at org.jetel.component.MysqlDataWriter.createConsumers(MysqlDataWriter.java:726)

• 

  avackova

  • February 15, 2011 09:17

  0

  Comment actions Permalink

  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.
• 

  sankardunga

  • February 15, 2011 11:03

  0

  Comment actions Permalink

  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.<init>(Unknown Source)
  at java.lang.ProcessImpl.start(Unknown Source)
  ... 8 more
• 

  avackova

  • February 15, 2011 11:13

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.