datacleaner / DataCleaner

The premier open source Data Quality solution
GNU Lesser General Public License v3.0
595 stars 180 forks source link

Bigquery jdbc driver problem with autocommit #1867

Open juan-borrero opened 4 years ago

juan-borrero commented 4 years ago

Hello, i trying to implement a jdbc connection to bigquery using his jdbc driver by Simba, the problem is this jdbc driver does not allow change the autocommit, look the next image:

image

and the stack trace:

Stack Trace: [Simba]JDBC Driver does not support this optional feature. com.simba.googlebigquery.exceptions.ExceptionConverter.toSQLException(Unknown Source) com.simba.googlebigquery.jdbc.common.SConnection.setAutoCommit(Unknown Source) org.datacleaner.connection.JdbcDatastore.createDatastoreConnection(JdbcDatastore.java:269) org.datacleaner.connection.UsageAwareDatastore.getDatastoreConnection(UsageAwareDatastore.java:117) org.datacleaner.connection.UsageAwareDatastore.openConnection(UsageAwareDatastore.java:128) org.datacleaner.connection.JdbcDatastore.openConnection(JdbcDatastore.java:111) org.datacleaner.connection.JdbcDatastore.openConnection(JdbcDatastore.java:50) org.datacleaner.panels.DatastorePanel$5.actionPerformed(DatastorePanel.java:210) javax.swing.AbstractButton.fireActionPerformed(Unknown Source) javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) javax.swing.DefaultButtonModel.setPressed(Unknown Source) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) java.awt.Component.processMouseEvent(Unknown Source) javax.swing.JComponent.processMouseEvent(Unknown Source) java.awt.Component.processEvent(Unknown Source) java.awt.Container.processEvent(Unknown Source) java.awt.Component.dispatchEventImpl(Unknown Source) java.awt.Container.dispatchEventImpl(Unknown Source) java.awt.Component.dispatchEvent(Unknown Source) java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) java.awt.Container.dispatchEventImpl(Unknown Source) java.awt.Window.dispatchEventImpl(Unknown Source) java.awt.Component.dispatchEvent(Unknown Source) java.awt.EventQueue.dispatchEventImpl(Unknown Source) java.awt.EventQueue.access$500(Unknown Source) java.awt.EventQueue$3.run(Unknown Source) java.awt.EventQueue$3.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue$4.run(Unknown Source) java.awt.EventQueue$4.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue.dispatchEvent(Unknown Source) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source) java.awt.EventDispatchThread.run(Unknown Source

There are a way to disable the autocommit requeriment of datacleaner? or there are another way to do this conecction?

other problem with the ui was that the window for add jars for the driver not have a scroll bar and the bigquery driver needs like 30 jar files, is a problem for small monitors.

Thanks in advise