[CONJ-124] BigInteger not supported when setObject is used on PreparedStatements Created: 2014-11-27  Updated: 2014-12-04  Resolved: 2014-12-04

Status: Closed
Project: MariaDB Connector/J
Component/s: None
Affects Version/s: 1.1.7
Fix Version/s: 1.1.8

Type: Bug Priority: Major
Reporter: Gaëtan Denaisse Assignee: Massimo Siani (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

OS X, Eclipse, JDK 1.7

Attachments: Java Source File BigIntTests.java     Java Source File MySQLPreparedStatement_PATCHED.java    

 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



 Comments   
Comment by Gaëtan Denaisse [ 2014-11-27 ]

jUnit test I expect to pass and that is passing with MySQL clients

Comment by Gaëtan Denaisse [ 2014-11-27 ]

Proposed patch in MySQLPreparedStatement.java

/MySQLPreparedStatement.java"
 
1463,1465c1463
 
<         } else if (x instanceof BigInteger) {
 
< 			setBigDecimal(parameterIndex, new BigDecimal((BigInteger) x));
 
< 		}
 
---
 
>         }
 
 

Generated at Thu Feb 08 03:13:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.