| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Issues inserting data into BIT column |
« View previous topic :: View next topic » |
| Author |
Message
|
| gs |
 Posted: Thu Jul 03, 2014 2:06 am Post subject: Issues inserting data into BIT column |
 |
|
Master
Joined: 31 May 2007
Posts: 254
Location: Sweden
|
I've got a simple flow inserting data into a MySQL table where one of the columns is of data type BIT.
The very simplified code in a Compute node looks like this:
| Code: |
INSERT INTO Database.table (
column1,
column2
) VALUES (
myref.ns:name,
0,
) |
column2 is of the data type BIT.
I've tried setting FALSE, 0, '0' but they all give an exception from the database saying that "Data too long for column 'column2'".
I also doing a cast using CAST(0 AS BIT) but that gives a BIP2414:
| Quote: |
( MYBROKER.default ) Unsupported datatype ''BIT''.
While preparing an ODBC statement a parameter with data type ''BIT'' was encountered. This data type is not yet supported for ODBC operations.
Ensure that expressions which may return values of data type ''BIT'' are not used as parameters in statements or expressions that access external databases. |
SQL queries using the exact same data works fine and I could try a JDBC based workaround but this simple (?) scenario nags me.
WMB 8.0.0.3, Windows Server 2008, MySQL 5.0
Any ideas? Thanks |
|
| Back to top |
|
 |
| gs |
| Posted: Thu Jul 03, 2014 2:27 am Post subject: |
|
|
Master
Joined: 31 May 2007
Posts: 254
Location: Sweden
|
| Nevermind, it seems that the MySQL BIT data type works in a different way than its MSSQL counterpart. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
