Mysql Type is not there

Forum is for miscellaneous user help requests.

Mysql Type is not there

Postby bsurendiran » Mon Oct 10, 2016 12:59 am

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?
bsurendiran
 
Posts: 1
Joined: Mon Oct 10, 2016 12:54 am

Re: Mysql Type is not there

Postby akivela » Mon Oct 10, 2016 10:03 am

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
akivela
Site Admin
 
Posts: 256
Joined: Tue Sep 18, 2007 10:20 am
Location: Helsinki, Finland


Return to How to... and problems

Who is online

Users browsing this forum: No registered users and 0 guests