Problem with DatabaseExampleSetWriter

Legacy UserLegacy User Member Posts: 0 Newbie
edited November 2018 in Help
Hi Ingo, Hi All,

I have a problem with the operator DatabaseExampleSetWriter. I tried an experiment where I want to "merge" (neither Join, nor Merge, nor anything else) two examplesets outside RM with raw SQL handling.

For that, I installed mySQL and WampServer on a standalone PC. I have verified access rights on a database I have created, called "travail_rapidminer". With or without password, RM does not seem to access this database properly, as I asked it to overwrite output exampleset onto it.

Here is my XML process code :

http://www.mediafire.com/?dummdgmlnm8

and the error box :

http://www.mediafire.com/?tplmnymxxiy

At last, here are my settings on database side :
http://i33.tinypic.com/t9f5tf.jpg

And here is the dialog box that appears before the error box at running :
http://i37.tinypic.com/10y2gwn.jpg

I precise that passwords are coherent, despite the XML experiment does not seem so on this point. Is it a bug, or did I misuse the operator ?

Cheers,
  Jean-Charles.

Answers

  • IngoRMIngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    Hi Jean-Charles,

    hmm, I must admit that I don't have any clue right now what causes this problem. Did you try if reading from this database works well? The error occurs at a place which actually does not have anything to do which is specific to RM - it directly occurs at the place where the connection is constructed and there is no specific magic done. So I would still assume that there could be an error at the settings. Here is the relevant parts:

                    <operator name="DatabaseExampleSetWriter (3)" class="DatabaseExampleSetWriter">
                        <parameter key="database_url" value="jdbc:mysql://localhost:80/travail_rapidminer"/>
                        <parameter key="overwrite_mode" value="overwrite"/>
                        <parameter key="table_name" value="table_elements"/>
                        <parameter key="username" value="root@localhost"/>
                    </operator>
    Some questions:

    1. did reading from this database works with these settings?
    2. port 80 is rather unusual for a database - the default for mySQL is 3306 if I am not mistaken
    3. the user name root@localhost is also unusual - did you try "root" alone?

    Sorry, I have no other ideas right now.

    Cheers,
    Ingo
  • Legacy UserLegacy User Member Posts: 0 Newbie
    Hi Ingo, Hi All,

    Sorry for the late reply  :P
    I may try with a different port, 3306 instead of 80, you seem to be right...

    Cheers,
      Jean-Charles.
Sign In or Register to comment.