eclipse-vertx / eclipse-vertx/vertx-sql-client

[MSSQL][DB2] Add support for XML data type

Open
#1,475 1 comment 0 reactions 0 assignees View on GitHub
enhancement module:mssql
Dominant language
Java
Stars
912
Forks
212
Avg merge
17h 30m
Merged PRs (30d)
3

Description

[Based on the documentation](https://vertx.io/docs/vertx-mssql-client/java/#_data_types_supported), [the `xml` data type](https://learn.microsoft.com/en-us/sql/relational-databases/xml/xml-data-type-and-columns-sql-server?view=sql-server-ver16) is not supported in MSSQL.
Example of column definition:
```sql
xmlColumn xml
```

It currently throws (during a select sql query):
```
Caused by: java.lang.UnsupportedOperationException: Unable to decode typeInfo for XML
at io.vertx.mssqlclient.impl.codec.DataType.decodeTypeInfo(DataType.java:1065)
at io.vertx.mssqlclient.impl.codec.MSSQLCommandCodec.handleColumnMetadata(MSSQLCommandCodec.java:120)
at io.vertx.mssqlclient.impl.codec.MSSQLCommandCodec.decode(MSSQLCommandCodec.java:51)
at io.vertx.mssqlclient.impl.codec.TdsMessageDecoder.decodeMessage(TdsMessageDecoder.java:75)
at io.vertx.mssqlclient.impl.codec.TdsMessageDecoder.channelRead(TdsMessageDecoder.java:47)
at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442)
... 20 more
```

I've created this issue for SqlServer but Db2 has the same problem.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.