BasePrepareStatement.setObject() doesn't handle the Character data type, resulting in it falling back to sending the serialized version of the Character object.
This is of course compliant with JDBC, which does not define a mapping for the Character data type; however, since this was present in a previous version of the driver, upgrading broke our application and we had to deploy a workaround.
Attachments
Issue Links
duplicates
CONJ-185MySQLPreparedStatement.setObject cannot handle java.lang.Character type
Ah yes, of course. The previous report was referring to a different signature of setObject().
Do you need a PR?
Riccardo Paolo Bestetti
added a comment - Ah yes, of course. The previous report was referring to a different signature of setObject().
Do you need a PR?
This is slightly different from CONJ-185 where targetSqlType was set to java.sql.Types.CHAR value, but with String object.
setObject(finalint parameterIndex, final Object x, finalint targetSqlType)
Here is handling char / java.lang.Character Object. I don't know if this was supported of not, I've not found any code change that could have refer to this part. In all case, there is no reason not to support char / java.lang.Character parameters.
Diego Dupin
added a comment - This is slightly different from CONJ-185 where targetSqlType was set to java.sql.Types.CHAR value, but with String object.
setObject( final int parameterIndex, final Object x, final int targetSqlType)
Here is handling char / java.lang.Character Object. I don't know if this was supported of not, I've not found any code change that could have refer to this part. In all case, there is no reason not to support char / java.lang.Character parameters.
People
Diego Dupin
Riccardo Paolo Bestetti
Votes:
0Vote for this issue
Watchers:
2Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":778.6000003814697,"ttfb":159.10000038146973,"pageVisibility":"visible","entityId":90694,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"81e8fcfb-c9e1-4fa5-acbb-58ca02bdefba","navigationType":0,"readyForUser":860.8000001907349,"redirectCount":0,"resourceLoadedEnd":692,"resourceLoadedStart":163.80000019073486,"resourceTiming":[{"duration":55.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":163.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":163.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":219.5,"responseStart":0,"secureConnectionStart":0},{"duration":55.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":164.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":164.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":219.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":66.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":164.2000002861023,"connectEnd":164.2000002861023,"connectStart":164.2000002861023,"domainLookupEnd":164.2000002861023,"domainLookupStart":164.2000002861023,"fetchStart":164.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":164.2000002861023,"responseEnd":230.90000009536743,"responseStart":230.90000009536743,"secureConnectionStart":164.2000002861023},{"duration":240.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":169.10000038146973,"connectEnd":169.10000038146973,"connectStart":169.10000038146973,"domainLookupEnd":169.10000038146973,"domainLookupStart":169.10000038146973,"fetchStart":169.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":169.10000038146973,"responseEnd":409.40000009536743,"responseStart":409.40000009536743,"secureConnectionStart":169.10000038146973},{"duration":243.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":169.40000009536743,"connectEnd":169.40000009536743,"connectStart":169.40000009536743,"domainLookupEnd":169.40000009536743,"domainLookupStart":169.40000009536743,"fetchStart":169.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":169.40000009536743,"responseEnd":413.2000002861023,"responseStart":413.2000002861023,"secureConnectionStart":169.40000009536743},{"duration":245.39999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":169.60000038146973,"connectEnd":169.60000038146973,"connectStart":169.60000038146973,"domainLookupEnd":169.60000038146973,"domainLookupStart":169.60000038146973,"fetchStart":169.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":169.60000038146973,"responseEnd":415,"responseStart":415,"secureConnectionStart":169.60000038146973},{"duration":245.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":169.80000019073486,"connectEnd":169.80000019073486,"connectStart":169.80000019073486,"domainLookupEnd":169.80000019073486,"domainLookupStart":169.80000019073486,"fetchStart":169.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":169.80000019073486,"responseEnd":415.40000009536743,"responseStart":415.40000009536743,"secureConnectionStart":169.80000019073486},{"duration":246.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":169.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":416.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":246.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":170.10000038146973,"connectEnd":170.10000038146973,"connectStart":170.10000038146973,"domainLookupEnd":170.10000038146973,"domainLookupStart":170.10000038146973,"fetchStart":170.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":170.10000038146973,"responseEnd":416.80000019073486,"responseStart":416.80000019073486,"secureConnectionStart":170.10000038146973},{"duration":247.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":170.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":417.5,"responseStart":0,"secureConnectionStart":0},{"duration":247,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":170.5,"connectEnd":170.5,"connectStart":170.5,"domainLookupEnd":170.5,"domainLookupStart":170.5,"fetchStart":170.5,"redirectEnd":0,"redirectStart":0,"requestStart":170.5,"responseEnd":417.5,"responseStart":417.5,"secureConnectionStart":170.5},{"duration":305.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":171.30000019073486,"connectEnd":171.30000019073486,"connectStart":171.30000019073486,"domainLookupEnd":171.30000019073486,"domainLookupStart":171.30000019073486,"fetchStart":171.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":171.30000019073486,"responseEnd":476.5,"responseStart":476.5,"secureConnectionStart":171.30000019073486},{"duration":358.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":171.40000009536743,"connectEnd":171.40000009536743,"connectStart":171.40000009536743,"domainLookupEnd":171.40000009536743,"domainLookupStart":171.40000009536743,"fetchStart":171.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":171.40000009536743,"responseEnd":529.6000003814697,"responseStart":529.6000003814697,"secureConnectionStart":171.40000009536743},{"duration":79.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":381.2000002861023,"connectEnd":381.2000002861023,"connectStart":381.2000002861023,"domainLookupEnd":381.2000002861023,"domainLookupStart":381.2000002861023,"fetchStart":381.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":381.2000002861023,"responseEnd":460.6000003814697,"responseStart":460.6000003814697,"secureConnectionStart":381.2000002861023},{"duration":208.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":483.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":483.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":692,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":15,"responseStart":159,"responseEnd":164,"domLoading":162,"domInteractive":914,"domContentLoadedEventStart":915,"domContentLoadedEventEnd":973,"domComplete":1195,"loadEventStart":1195,"loadEventEnd":1195,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":890.2000002861023},{"name":"bigPipe.sidebar-id.end","time":891.1000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":891.2000002861023},{"name":"bigPipe.activity-panel-pipe-id.end","time":892.5},{"name":"activityTabFullyLoaded","time":986.9000000953674}],"measures":[],"correlationId":"ea43451da2f079","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":89,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Ah yes, of course. The previous report was referring to a different signature of setObject().
Do you need a PR?