HI

I am getting the exception while executing the below mentioned query and all the details are given below. plz help me out..

Query:

select * from
(
select distinct pm.process_id, pm.name,pm.description,pv.version_id,pv.version_no
from tbl_process_master pm, tbl_process_version pv,tbl_resource_map rm
where pm.process_id=pv.process_id and pv.VERSION_ID=rm.PROCESS_VERSION_ID and rm.RESOURCE_VERSION_ID=:resourceVersionId
and pm.process_id in
(
select c1.content_id from tbl_content_level_assoc c1 where c1.level_id in
(
:levelIds
)
)
union

select distinct pm.process_id, pm.name,pm.description,pv.version_id,pv.version_no
from tbl_process_master pm, tbl_process_version pv,tbl_resource_map rm
where pm.process_id=pv.process_id
and pv.VERSION_ID=
(
select pv2.version_id from tbl_process_version pv2, tbl_subprocess_version sv,tbl_subprocess_master sm
where sv.subprocess_id=sm.id and sm.parent_process_version_id=pv2.version_id
and sv.version_id=rm.SUBPROCESS_VERSION_ID and rm.RESOURCE_VERSION_ID=:resourceVersionId
)
and pm.process_id in
(
select c1.content_id from tbl_content_level_assoc c1 where c1.level_id in
(
:levelIds
)
)
)as test order by 1

Exception:

org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)
at org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:370)
at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(Cu
stomLoader.java:559)
at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.
performDiscovery(CustomLoader.java:485)
at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoad
er.java:501)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1796)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)

at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:
142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at com.tis.epss.resourcemgmt.dao.ResourceDAOImpl.getAllResourceListInWIP
(ResourceDAOImpl.java:953)
at com.tis.epss.resourcemgmt.bo.ResourceBOImpl.getAllResourceListInWIP(R
esourceBOImpl.java:392)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:335)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
at $Proxy32.getAllResourceListInWIP(Unknown Source)
at com.tis.epss.resourcemgmt.action.ResourceAction.getResourceListing(Re
sourceAction.java:411)
at com.tis.epss.resourcemgmt.action.ResourceAction.getResourceListingFor
Creator(ResourceAction.java:372)
at com.tis.epss.resourcemgmt.action.ResourceAction.getResourceListingPag
e(ResourceAction.java:336)
at sun.reflect.GeneratedMethodAccessor641.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchActio
n.java:276)
at com.tis.epss.common.action.BaseAction.execute(BaseAction.java:85)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:116
4)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:689)
at java.lang.Thread.run(Unknown Source)


Table Structure is:

CREATE TABLE `tbl_process_master` (
`process_id` int(11) NOT NULL auto_increment,
`name` varchar(150) NOT NULL,
`description` varchar(4000) NOT NULL,
`owner_name` varchar(200) default NULL,
`meta_tag` varchar(4000) NOT NULL,
`category_id` int(11) NOT NULL,
`pro_type` char(1) NOT NULL default 'P',
`isdeleted` char(1) NOT NULL default 'N',
`status` varchar(10) default NULL,
`creator_id` int(11) NOT NULL,
`create_date` datetime NOT NULL,
`publisher_id` int(11) default NULL,
`published_date` datetime default NULL,
`modifier_id` int(11) default NULL,
`modification_date` datetime default NULL,
PRIMARY KEY (`process_id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1


i am using org.hibernate.dialect.MySQL5InnoDBDialect dialect, and i have tried all the dialects which supports the Mysql, still i am facing the same problem.. if i remove the description column in the query its working fine.. but i don't know exactly whats the problem in the description column. plz help me out..
[quote][/quote]