Problems with Writing Data / JDBC Driver (SQLITE) after Updating RM

MPB_

Hello,
after I updated RM to the newest version, I get error messages for the operator Write Database.

More specific, this is what is going on:

However, when testing the connection, I get the information "Connection ok".
Even changing the compatibility does not help.

What can I do about it? I did not change a thing in comparison with yesterday, where everything worked perfectly fine.

MPB_

Edit:

I also tried to use the new connections menu , but have problems with the configuration.

I do not have any information on which port is to set there.

Does anyone know which port should be set for sqlite?

In this tutorial, there is explicitly said to leave it blank, but I am afraid that this is not possible with the new Menu.

https://www.win.tue.nl/~egonzale/2016/10/14/integrating-sqlite-with-rapidminer-7-2/

MPB_

Edit2:

I found out how to configure the connection with the new menu:

Therefore, it is needed to configure the URL manually. The logic is as follows:

Connections --> Setup--> Configure URL manually:

jdbc:sqlite:C:\your_folder_name\your_database_name.sqlite

Nevertheless, it is still not possible to write data into it. Surprisingly, reading data is not a problem

jczogalla

Hi @MPB_ !

This sounds indeed a little bit strange. Can you share your rapidminer.log file? You cna find it in your user home in the .RapidMiner folder.

Which RapidMiner version did you use before? And can you give some information about the data you are trying to write? The error message suggests that there is an issue with the driver not implementing a certain set of functionality. We did touch on how we write date, time and date-time attributes, so this might be the problem.

Cheers

Jan

MPB_

Hi @jczogalla,  thank you for getting back at me so quickly. I will send you my log-files via direct Message. I hope that is ok for you?

I Used the previous actual version. I think it was 9.5?!

Thanks again.

MPB_

Edit:

@jczogalla ,  as far as I can evaluate that, it does not matter what data I try to write.

I tried it with the standard operator Generate Data (ARIMA) without changing the parameters and get the exact same error message

jczogalla

It is a confirmed bug in Studio which will be fixed with the next update.

Find a technical hot fix below. Disclaimer: This is not an officially supported solution!

In the meantime, if anyone else stumbles across this problem, you could modify the SQLite jdbc driver such that the method 
JDBC3Statement#executeUpdate(String, int) calls JDBC3Statement#executeUpdate(String).