Mysql Type is not there

[bsurendiran]

Hi Team,

I am running wandora to extract IMDB files. I am running Ubunto 14 and java 8.

I installed mysql server also.

When I run by follwoing the steps provided by Wandora I dont see Mysql type in New layer please help.

As per this document http://www.wandora.org/wandora/wiki/ind ... _extractor - mysqltest should be there but it is not there.

Do i need to have mysql connector or any specific version of mysql needs to be installed?

[akivela]

Hello bsurendiran

These days Wandora has only Generic database topic map type. Generic database topic map type can be used to connect MySQL database too. Default settings in MySQL generic may be a good starting point. Addition to database user name and password edit the connection string:

Code: Select all

jdbc:mysql://localhost:3306/wandora?useOldAliasMetadataBehavior=true

Googling you'll find many tutorials setting the connection string. For example http://stackoverflow.com/questions/1457716/what-is-the-mysql-jdbc-driver-connection-string . If your database is in the local machine (localhost) and the default port (3306), just replace wandora with the name of your database.

Actual MySQL connector Java library is enclosed in Wandora's distribution package and located in lib/mysql-connector-java-3.1.13-bin.jar. You don't need to install the connector JAR for MySQL.

After writing the IMDB tutorial several years ago, modern computers can have 32 or even 64Gb memories. If you have 64Gb memory in your computer, I would suggest you try to extract the IMDB files into a memory topic map. Just remember to adjust Wandora's startup scripts in the bin folder to give Wandora more memory.

Kind Regards,
Aki