Forums Register Login

No Dialect mapping for JDBC type: 1111

+Pie Number of slices to send: Send
Hi,

I am using DB2 v8 which has a columntype as XML. DDL looks like this:
CREATE TABLE "BLUEISV "."BLIND" (
"LISTING_ID" INTEGER NOT NULL ,
"BLINDTYPE" SMALLINT NOT NULL ,
"XML" XML , ......

In the mapping hbm.xml file I map it like this:
<key-property name="xml" type="java.lang.String" >
<column name="XML" />
</key-property>

and I guess this is the reason of error :
No Dialect mapping for JDBC type: 1111
when I run a select query using :
Session session = new BaseDAO().getSession();
Query query = session.createSQLQuery("select * from blueisv.Blind where listing_id=" + val.getListingId() + " and blindtype=1");

query.list();
but what is the other way I can map "XML" type to a java datatype ?
please help
thanks,
See where your hand is? Not there. It's next to this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 7143 times.
Similar Threads
stuck up in the problem
using multiple datasources in hibernate app
Hibernate insert or select gives "Identifier of an instance altered"
Could not parse mapping document from resource PojoTestTable.hbm.xml
Sybase stored proc error
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 04:08:12.