[JIRA] Created: (MYO-45) Getting Bit(1) columns type throws an exception

Discussion:

Gilles Rayrat (JIRA)

2008-02-15 14:44:44 UTC

Getting Bit(1) columns type throws an exception
-----------------------------------------------

Key: MYO-45
URL: https://forge.continuent.org/jira/browse/MYO-45
Project: Myosotis
Type: Bug

Components: MySQL protocol
Versions: 0.4.5, 0.5, 0.5.1, 0.6
Reporter: Gilles Rayrat
Assigned to: Gilles Rayrat
Fix For: 0.6.1

The following test case:
CREATE TABLE `ac_user2` (
`USER_ID` bigint(20) NOT NULL,
`IS_PSWD_CASE_SENSITIVE` bit(1) default NULL);
INSERT INTO ac_user2 VALUES (1, 1);
SELECT * FROM ac_user2;

fails because of an exception thrown by sequoia:
org.continuent.sequoia.common.exceptions.NotImplementedException: in getBytes(2), don't know how to convert type java.lang.Boolean into a byte array not implemented

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira

Gilles Rayrat (JIRA)

2008-02-15 14:46:43 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-45?page=comments#action_14264 ]

Gilles Rayrat commented on MYO-45:
----------------------------------

This is somehow due to MySQL connector/j that retrieves bit(1) as Booleans. Then, sequoia can't call getBytes on a boolean.
The workaround is to get the boolean and send a byte 0 or 1 instead

Post by Gilles Rayrat (JIRA)
Getting Bit(1) columns type throws an exception
-----------------------------------------------
Key: MYO-45
URL: https://forge.continuent.org/jira/browse/MYO-45
Project: Myosotis
Type: Bug
Components: MySQL protocol
Versions: 0.4.5, 0.5, 0.5.1, 0.6
Reporter: Gilles Rayrat
Assignee: Gilles Rayrat
Fix For: 0.6.1
CREATE TABLE `ac_user2` (
`USER_ID` bigint(20) NOT NULL,
`IS_PSWD_CASE_SENSITIVE` bit(1) default NULL);
INSERT INTO ac_user2 VALUES (1, 1);
SELECT * FROM ac_user2;
org.continuent.sequoia.common.exceptions.NotImplementedException: in getBytes(2), don't know how to convert type java.lang.Boolean into a byte array not implemented

Gilles Rayrat (JIRA)

2008-02-15 16:50:43 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-45?page=all ]

Gilles Rayrat resolved MYO-45:
------------------------------

Resolution: Fixed

Commited in svn

Gilles Rayrat (JIRA)

2009-08-07 10:55:46 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-45?page=all ]

Gilles Rayrat closed MYO-45:
----------------------------

Post by Gilles Rayrat (JIRA)
Getting Bit(1) columns type throws an exception
-----------------------------------------------
Key: MYO-45
URL: https://forge.continuent.org/jira/browse/MYO-45
Project: Tungsten Connector
Type: Bug
Components: MySQL protocol
Versions: 0.4.5, 0.5, 0.5.1, 0.6
Reporter: Gilles Rayrat
Assignee: Gilles Rayrat
Fix For: 0.6.1
CREATE TABLE `ac_user2` (
`USER_ID` bigint(20) NOT NULL,
`IS_PSWD_CASE_SENSITIVE` bit(1) default NULL);
INSERT INTO ac_user2 VALUES (1, 1);
SELECT * FROM ac_user2;
org.continuent.sequoia.common.exceptions.NotImplementedException: in getBytes(2), don't know how to convert type java.lang.Boolean into a byte array not implemented