Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.7
-
None
-
None
-
OS X, Eclipse, JDK 1.7
Description
When using setObject on PreparedStatement with a BigInteger, MariaDB throws an Exception. See trace below
This is working with MySQL clients
Attach you will find a jUnit test to reproduce the issue.
And a proposed patch for the file MySQLPreparedStatement.java
java.sql.SQLDataException: Incorrect integer value: '\xAC\xED\x00\x05sr\x00\x14java.math.BigInteger\x8C\xFC\x9F\x1F\xA9;\xFB\x1D\x03\x00\x06I\x00\x08bitCountI\x00\x09bitLengthI\x00\' for column 'id' at row 1
|
at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:128)
|
at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
|
at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:264)
|
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:288)
|
at org.mariadb.jdbc.MySQLStatement.executeUpdate(MySQLStatement.java:317)
|
at org.mariadb.jdbc.MySQLPreparedStatement.executeUpdate(MySQLPreparedStatement.java:161)
|
at com.tunz.mysql.BigIntTests.testBigInt(BigIntTests.java:51)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:606)
|
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
|
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
|
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
|
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
|
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
|
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
|
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
|
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:44)
|
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
|
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
|
at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
|
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
|
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
|
at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
|
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
|
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
|
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)
|
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675)
|
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)
|
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)
|
Caused by: org.mariadb.jdbc.internal.common.QueryException: Incorrect integer value: '\xAC\xED\x00\x05sr\x00\x14java.math.BigInteger\x8C\xFC\x9F\x1F\xA9;\xFB\x1D\x03\x00\x06I\x00\x08bitCountI\x00\x09bitLengthI\x00\' for column 'id' at row 1
|
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:942)
|
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:991)
|
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:281)
|
... 27 more
|