This content has been marked as final.
Show 5 replies
-
1. Re: No Dialect mapping for JDBC type: -9
lafr Aug 15, 2013 4:15 PM (in response to ejb3workshop)1 of 1 people found this helpfulIf you would have used internet search you would have found this: https://hibernate.atlassian.net/browse/HHH-5869.
You did not say which exact JBoss 7 version you're using. What's the version of hibernate used?
Upgrade your JBoss version or cast the nvarchar to varchar as a temporary workaround.
-
2. Re: No Dialect mapping for JDBC type: -9
ejb3workshop Aug 16, 2013 12:36 AM (in response to lafr)I am using JBoss 7.2. Will try the cast. Thanks for your help.
-
3. Re: No Dialect mapping for JDBC type: -9
ybxiang.china Aug 16, 2013 1:19 AM (in response to ejb3workshop)1 of 1 people found this helpfulLong Long ago, I used MS Driver, it's really VERY BAD! MS refused to fix known bugs.
I turned to jtds and never came back.
-
4. Re: No Dialect mapping for JDBC type: -9
ejb3workshop Aug 16, 2013 3:14 AM (in response to ejb3workshop)Using :
String queryString = "SELECT CAST(PROJECTNAME AS varchar) FROM TH_PROJECTS WHERE PROJECTID = (SELECT PROJECTID FROM JS_BATCHES WHERE BATCHID=?1)";
Resolved the problem.
-
5. Re: No Dialect mapping for JDBC type: -9
ejb3workshop Nov 6, 2013 11:29 PM (in response to ejb3workshop)The following two posts suggest extending the dialect to support the "unsupported" types.