Integer Column Insert Problem

Note: please leave bug reports and feature requests on GitHub

Integer Column Insert Problem

Postby KiPSOFT » Mon Oct 05, 2015 12:36 pm

Hi;

i have a integer column insert problem in 3.5.1 version. error;

this error occured new record insert.

my operating system ubuntu 15.01.

DBCException: SQL Error [1366] [HY000]: Incorrect integer value: '\xAC\xED\x00\x05sr\x00\x11java.lang.Integer\x12\xE2\xA0\xA4\xF7\x81\x878\x02\x00\x01I\x00\x05valuexr\x00\x10java.lang.Number\x86' for column 'sirket_no' at row 1
java.sql.SQLException: SQLException: Incorrect integer value: '\xAC\xED\x00\x05sr\x00\x11java.lang.Integer\x12\xE2\xA0\xA4\xF7\x81\x878\x02\x00\x01I\x00\x05valuexr\x00\x10java.lang.Number\x86' for column 'sirket_no' at row 1

thanks.
KiPSOFT
 
Posts: 16
Joined: Tue Jul 28, 2015 12:04 am

Re: Integer Column Insert Problem

Postby Serge » Mon Oct 05, 2015 12:41 pm

What database? What driver?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Integer Column Insert Problem

Postby KiPSOFT » Mon Oct 05, 2015 12:42 pm

Mysql - Mysql - Connector - java - 5.1.36

error stack trace;

org.jkiss.dbeaver.model.exec.DBCException: SQL Error [1366] [HY000]: Incorrect integer value: '\xAC\xED\x00\x05sr\x00\x11java.lang.Integer\x12\xE2\xA0\xA4\xF7\x81\x878\x02\x00\x01I\x00\x05valuexr\x00\x10java.lang.Number\x86' for column 'sirket_no' at row 1
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.executeStatement(JDBCPreparedStatementImpl.java:74)
at org.jkiss.dbeaver.model.impl.data.ExecuteBatchImpl.executeStatement(ExecuteBatchImpl.java:217)
at org.jkiss.dbeaver.model.impl.data.ExecuteBatchImpl.execute(ExecuteBatchImpl.java:129)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetPersister$DataUpdaterJob.executeStatements(ResultSetPersister.java:423)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetPersister$DataUpdaterJob.run(ResultSetPersister.java:323)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetPersister.execute(ResultSetPersister.java:201)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetPersister.applyChanges(ResultSetPersister.java:86)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer.applyChanges(ResultSetViewer.java:1744)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer.applyChanges(ResultSetViewer.java:1715)
at org.jkiss.dbeaver.ui.editors.data.DatabaseDataEditor.doSave(DatabaseDataEditor.java:150)
at org.jkiss.dbeaver.ui.editors.entity.EntityEditor.doSave(EntityEditor.java:214)
at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:156)
at org.eclipse.ui.internal.SaveableHelper$5.run(SaveableHelper.java:285)
at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:463)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:371)
at org.eclipse.ui.internal.WorkbenchWindow$14.run(WorkbenchWindow.java:2156)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.ui.internal.WorkbenchWindow.run(WorkbenchWindow.java:2152)
at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:293)
at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:271)
at org.eclipse.ui.internal.SaveableHelper.savePart(SaveableHelper.java:161)
at org.eclipse.ui.internal.WorkbenchPage.saveSaveable(WorkbenchPage.java:3874)
at org.eclipse.ui.internal.WorkbenchPage.saveEditor(WorkbenchPage.java:3888)
at org.eclipse.ui.internal.handlers.SaveHandler.execute(SaveHandler.java:54)
at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:295)
at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)
at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)
at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:252)
at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:234)
at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)
at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:152)
at org.eclipse.core.commands.Command.executeWithChecks(Command.java:493)
at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:486)
at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:210)
at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.executeCommand(KeyBindingDispatcher.java:286)
at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.press(KeyBindingDispatcher.java:507)
at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.processKeyEvent(KeyBindingDispatcher.java:558)
at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.filterKeySequenceBindings(KeyBindingDispatcher.java:378)
at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher.access$0(KeyBindingDispatcher.java:324)
at org.eclipse.e4.ui.bindings.keys.KeyBindingDispatcher$KeyDownFilter.handleEvent(KeyBindingDispatcher.java:86)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.filterEvent(Display.java:1550)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1328)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1353)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1338)
at org.eclipse.swt.widgets.Widget.sendKeyEvent(Widget.java:1365)
at org.eclipse.swt.widgets.Widget.gtk_key_press_event(Widget.java:763)
at org.eclipse.swt.widgets.Control.gtk_key_press_event(Control.java:3317)
at org.eclipse.swt.widgets.Composite.gtk_key_press_event(Composite.java:785)
at org.eclipse.swt.widgets.Widget.windowProc(Widget.java:1980)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:5590)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4717)
at org.eclipse.swt.internal.gtk.OS._gtk_main_do_event(Native Method)
at org.eclipse.swt.internal.gtk.OS.gtk_main_do_event(OS.java:9279)
at org.eclipse.swt.widgets.Display.eventProc(Display.java:1225)
at org.eclipse.swt.internal.gtk.OS._g_main_context_iteration(Native Method)
at org.eclipse.swt.internal.gtk.OS.g_main_context_iteration(OS.java:2425)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3428)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:654)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:598)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
at org.jkiss.dbeaver.core.application.DBeaverApplication.start(DBeaverApplication.java:115)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)
at org.eclipse.equinox.launcher.Main.run(Main.java:1515)
at org.eclipse.equinox.launcher.Main.main(Main.java:1488)
Caused by: java.sql.SQLException: Incorrect integer value: '\xAC\xED\x00\x05sr\x00\x11java.lang.Integer\x12\xE2\xA0\xA4\xF7\x81\x878\x02\x00\x01I\x00\x05valuexr\x00\x10java.lang.Number\x86' for column 'sirket_no' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1193)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.execute(JDBCPreparedStatementImpl.java:127)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.executeStatement(JDBCPreparedStatementImpl.java:71)
... 82 more
KiPSOFT
 
Posts: 16
Joined: Tue Jul 28, 2015 12:04 am

Re: Integer Column Insert Problem

Postby Serge » Mon Oct 05, 2015 12:45 pm

Can't reproduce.
Is there anything special about column 'sirket_no'? Could you post table DDL?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Integer Column Insert Problem

Postby KiPSOFT » Mon Oct 05, 2015 12:49 pm

Table DDL;

CREATE TABLE `hizmet_tipleri` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`hizmet_tipi` varchar(100) NOT NULL COMMENT 'hizmet tipinin adı bilgisidir.',
`sirket_no` int(11) NOT NULL DEFAULT '1' COMMENT 'sirket tablosu id alanına referedir.',
`sepette_coklu_bulunma` int(11) NOT NULL DEFAULT '0' COMMENT 'eğer 1 ise aynı sepette birden fazla aynı hizmet bulunabilir.',
`hizmet_tablosu` varchar(50) DEFAULT NULL COMMENT 'hizmetin kayıt edildiği tablo bilgisidir.',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='hizmet tiplerinin tutulduğu tablodur. örneğin santral, numara gibi.'
KiPSOFT
 
Posts: 16
Joined: Tue Jul 28, 2015 12:04 am

Re: Integer Column Insert Problem

Postby KiPSOFT » Mon Oct 05, 2015 12:53 pm

i think this problem reason default value, because i'm null this column and insert working. after insert i'm change this column value not problem.
KiPSOFT
 
Posts: 16
Joined: Tue Jul 28, 2015 12:04 am

Re: Integer Column Insert Problem

Postby KiPSOFT » Mon Oct 05, 2015 12:58 pm

i remove deault value this column (sirket_no) but still this error.
KiPSOFT
 
Posts: 16
Joined: Tue Jul 28, 2015 12:04 am

Re: Integer Column Insert Problem

Postby Serge » Mon Oct 05, 2015 1:08 pm

I still can't reproduce this error. Inserts/updates working just fine in my environment. Are you editing a table or result of custom query? (in my environment both ways works fine but it'd be good to know details). Also did you try to restart DBeaver?

Generally it looks like DBeaver incorrectly determined column type. But I can't figure out why.
What icon is to the left of column name - numeric or string or question mark or ..?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Integer Column Insert Problem

Postby KiPSOFT » Mon Oct 05, 2015 1:16 pm

yes restart dbeaver table data editing and resultset data editing same still error. column icon question mark.
KiPSOFT
 
Posts: 16
Joined: Tue Jul 28, 2015 12:04 am

Re: Integer Column Insert Problem

Postby Serge » Mon Oct 05, 2015 1:30 pm

For some reason DBeaver can't determine that column data type. It makes me frustrating..
BTW what is the version number of your MySQL server?
Could you open table editor, swithc to tab "Columns" and make a screenshot?
Thanks.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Next

Return to Support



Who is online

Users browsing this forum: Google [Bot] and 9 guests