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

cindyharper
cindyharper New Altair Community Member
edited November 2024 in Community Q&A
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.
Tagged:

Answers

  • cindyharper
    cindyharper New Altair Community Member
    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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.