[CONJ-645] Column PROCEDURE_TYPE of result set of getProcedures() throws exception - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 2.2.1
Fix Version/s: N/A
Component/s: JDBC 4.2 compatibility
Labels:
- JDBC
- getProcedure
- getShort
- procedure
Environment:
JDBC driver 2.2.1, MariaDB server 10.1.34-MariaDB-0ubuntu0.18.04.1, Ubuntu 18.4

Description

Retrieval of value of column PROCEDURE_TYPE from result set of call to JDBC driver method getProcedures() of DatabaseMetaData throws the following error:

error code = 1264
error message = Out of range value for column 'REMARKS' : value

By the by, the column "PROCEDURE_TYPE" is 8th column in the result set and 7th column is "REMARKS"!

You can reproduce the problem by running attached program as following:

java MdbBugProcResult8thColFails <dbname> <userid> <password>

The user id you pass must have privilege to create procedures in the database.

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

MdbBugProcResult8thColFails.java
2 kB
2018-09-11 11:06

Activity

People

Assignee:: Diego Dupin

Reporter:: Vidyasagar Mundroy

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2018-09-11 11:13

Updated:: 2021-05-17 15:06

Resolved:: 2021-05-17 15:06

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.