CODEWITHSUNDEEP
mysqletltalend
Guy Benassa
Guy Benassa

Reputation: 21

extract and load from mysql DB to another

I would like to extract and load data from mysql DB to another mysql DB without shutting down mysql in the process.

Tried to use the open source Talend community edition. Used mysql input component, filled connection details which were tested to work.

Component could not connect to mysql and got the error:

Exception in component tMysqlOutput_1
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver

though I added to eclipse project the jar: mysql-connector-java-5.0.8.jar

Upvotes: 0

Views: 802

Answers (1)

sdragnev
sdragnev

Reputation: 468

The mysql components in talend should absolutely work out of the box without the need to load any additional drivers. I'd say reinstall talend because something else is wrong.

To manually load your mysql connector, you can use the tLibraryLoad component. Choose the jar file from the dropdown in the "Basic Settings". It should be there if it's been included in the project. You can also pick a lib path in the component's advanced settings and add the import line below that.

Again, you certainly shouldn't need to do this for the mysql component. Talend comes with the drivers to connect to all databases that have components. In fact I've copied those drivers to other programs that didn't come with them.

Good luck!

Upvotes: 1

Related Questions