Restoring the PostgreSQL driver

rachel_lomasky
rachel_lomasky New Altair Community Member
edited November 5 in Community Q&A

Hi,

 

I was messing around with the PostgreSQL drivers on my machine for another program, and I think I broke the RM Postgres driver.  

 

PostgreSQLWhen I try to make a new PostgreSQL connection, I get "No suitable driver found for jdbc:postgresql://localhost:5432.

 

And for existing processes, RapidMiner is not even trying to connect to the database.  I have no problem connecting to it from other tools, but when I try processes that used to work in RM, I instantly get "Database error occurred: The connection attempt failed."  Same thing when I try to do "Manage Database Connections."  I comes up right away, not even trying to connect to anything.

 

I'm on a Mac, RapidMiner version 7.5.3. 

 

How can I fix this?  

 

Thanks,

Rachel

Best Answer

  • rachel_lomasky
    rachel_lomasky New Altair Community Member
    Answer ✓

    RapidMiner really, really doesn't like 

    postgresql-42.1.1.jre6.jar

Answers

  • rachel_lomasky
    rachel_lomasky New Altair Community Member

    I also tried renaming my ~/.RapidMiner directory and installing again, but no luck.

  • rachel_lomasky
    rachel_lomasky New Altair Community Member
    Answer ✓

    RapidMiner really, really doesn't like 

    postgresql-42.1.1.jre6.jar

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    jre6? Is that the old Java 6 version of Postgres? RapidMiner runs on java 8 now, so it's likely there could be some conflicts there. 

  • rachel_lomasky
    rachel_lomasky New Altair Community Member

    Yeah, I had it in my classpath for something else.  When I removed it, everything started working again.