Write Access problem [SOLVED FOR ME, BUG FIX NEEDED]

cindyharper

When I try to Write to an Access .mdb table, I get the message "Attribute Cannot be Set Here".  After lots of trying, I looked at the CMD console for the startup of RapidMiner (this is RM 5.3, Windows 7):

       at com.rapidminer.tools.plugin.PluginClassLoader.loadClass(PluginClassLo
ader.java:102)
       at java.lang.ClassLoader.loadClass(Unknown Source)
       at java.lang.Class.forName0(Native Method)
       at java.lang.Class.forName(Unknown Source)
       at com.rapidminer.operator.OperatorDescription.<init>(OperatorDescriptio
n.java:93)
       at com.rapidminer.tools.OperatorService.parseOperators(OperatorService.j
ava:300)
       at com.rapidminer.tools.OperatorService.parseOperators(OperatorService.j
ava:293)
       at com.rapidminer.tools.OperatorService.parseOperators(OperatorService.j
ava:293)
       at com.rapidminer.tools.OperatorService.parseOperators(OperatorService.j
ava:293)
       at com.rapidminer.tools.OperatorService.parseOperators(OperatorService.j
ava:269)
       at com.rapidminer.tools.OperatorService.registerOperators(OperatorServic
e.java:231)
       at com.rapidminer.tools.plugin.Plugin.registerOperators(Plugin.java:484)

       at com.rapidminer.tools.plugin.Plugin.registerAllPluginOperators(Plugin.
java:808)
       at com.rapidminer.tools.OperatorService.init(OperatorService.java:181)
       at com.rapidminer.RapidMiner.init(RapidMiner.java:559)
       at com.rapidminer.gui.RapidMinerGUI.run(RapidMinerGUI.java:241)
       at com.rapidminer.gui.RapidMinerGUI.launch(RapidMinerGUI.java:560)
       at com.rapidminer.gui.RapidMinerGUI.main(RapidMinerGUI.java:541)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
       at java.lang.reflect.Method.invoke(Unknown Source)
       at com.rapid_i.Launcher.main(Launcher.java:346)

Oct 07, 2013 5:13:21 PM com.rapidminer.tools.OperatorService init
INFO: Number of registered operator classes: 563; number of registered operator
descriptions: 564; number of replacements: 437
Oct 07, 2013 5:13:21 PM com.rapidminer.tools.jdbc.JDBCProperties <init>
WARNING: Missing database driver class name for ODBC Bridge (e.g. Access)
Oct 07, 2013 5:13:21 PM com.rapidminer.tools.jdbc.JDBCProperties registerDrivers

INFO: JDBC driver ca.ingres.jdbc.IngresDriver not found. Probably the driver is
not installed.
[Fatal Error] :1:1: Premature end of file.
Oct 07, 2013 5:13:25 PM com.rapid_i.deployment.update.client.UpdateManager$3 run

INFO: Checking for updates.
Oct 07, 2013 5:13:27 PM com.rapid_i.deployment.update.client.UpdateManager$3 run


Is this my problem?

Cindy Harper
INFO: No updates since 10/3/13 2:40 PM.

cindyharper

OK, I solved my own problem by

1) Googling for this problem and finding this, e.g. http://forums.codeguru.com/showthread.php?42798-JDBC-Attribute-cannot-be-set-problem

2) Setting up Eclipse to change my sourcecode.

3) In com.rapidminer.src.tools.jdbc.DatabaseHandler.java, wherever I found references to "setAutoCommit", I enclosed those statements in try constructs, e.g.:

try {batchSizeInsertStatement.getConnection().setAutoCommit(oldAutoCommitStatus);} catch (SQLException e) {}

It's now working for me on my work Windows 7 computer in 32-bit with Access 2013.  I'm not sure what it'll do to the non-Access connections.

Now to solve the 64-bit driver problem on my Windows 8 machine at home.