🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Problem with DatabaseExampleSetWriter

Legacy UserUser: "Legacy User"
Legacy User
New Altair Community Member
Updated by Jocelyn
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.

Find more posts tagged with

AI Studio
Sort by:
1 - 2 of 21
    IngoRMUser: "IngoRM"
    IngoRM
    New Altair Community Member
    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 UserUser: "Legacy User"
    Legacy User
    New Altair Community Member
    OP
    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.
Quick Links