Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQLServerException: Data type LONGNVARCHAR not supported in Table-Valued Parameter #210

Closed
rabbit-mom opened this issue Mar 21, 2017 · 3 comments
Closed

SQLServerException: Data type LONGNVARCHAR not supported in Table-Valued Parameter #210

rabbit-mom opened this issue Mar 21, 2017 · 3 comments
Milestone
6.1.7

Comments

@rabbit-mom
Copy link

hi,I met a problem when I use jdbc 6.1.4.jre7-preview version.A field in a table is "xml" type,I looked up some information on the Internet, the "xml" type is corresponding with "LONGNVARCHAR",but I use "LONGNVARCHAR" or "LONGVARCHAR" is both not feasible
@Suraiya-Hameed
Copy link
Contributor

@rabbit-mom Thanks for raising this issue! We will add a fix to support xml, along with support for ntext, text, and image. In the meanwhile, you can use VARCHAR or NVARCHAR as the JDBC type to pass xml.

@Suraiya-Hameed Suraiya-Hameed added the Enhancement An enhancement to the driver. Lower priority than bugs. label Mar 22, 2017
@v-nisidh v-nisidh added this to the 6.1.7 milestone Mar 27, 2017
@Suraiya-Hameed Suraiya-Hameed mentioned this issue Apr 21, 2017
Merged
@AfsanehR-zz AfsanehR-zz added PR Under Review and removed Enhancement An enhancement to the driver. Lower priority than bugs. labels Apr 21, 2017
@AfsanehR-zz
Copy link
Contributor

AfsanehR-zz commented Apr 21, 2017 •
edited
Loading

@rabbit-mom Could you please test Pr #259? That should fix the issue. Thank you.

@AfsanehR-zz
Copy link
Contributor

closing this issue as solved by pr #259. Please feel free to reopen this if you face any issue. Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
6.1.7
Development

No branches or pull requests
5 participants
@ajlam @AfsanehR-zz @Suraiya-Hameed @v-nisidh @rabbit-mom