ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Tuan....@AlconLabs.com>
Subject NestedSQLException throws with MSDTC error
Date Wed, 26 Jul 2006 14:01:16 GMT
Hi,
 
I'm having a problem (MSDTC) when I execute a query statement below
using iBATIS DAO. The same query statement run fine in MS Query Analyzer
for the same database user. My database views are the remoted views
which granted SELECT permission by the same database user ID.
 
Do you know what I'm missing?
 
Thanks,
Tuan
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="ServiceRequest">
    <typeAlias alias="srObject"
type="com.alcon.ezra.vo.ServiceRequestVo" />
    
    <!-- ######################################### -->
    <!--  Service Request Data                     -->
    <!-- ######################################### -->     
    <resultMap id="srResult" class="com.alcon.ezra.vo.ServiceRequestVo">
        <result column="srvc_request_num" property="serviceRequestId" />
        <result column="first_name" property="firstName" />
        <result column="last_name" property="lastName" />
    </resultMap>
    
    <select id="getAllPendingSRs" resultClass="srObject"> 
       SELECT   s.srvc_request_num AS serviceRequestId,
                s.created_dt AS createdDate,
                s.closed_dt AS closedDate,
                s.summary AS summary,
                s.description AS description,
                s.status AS status,
                s.serial_num AS serialNumber,
                s.complaint_num AS complaintNumber,
                r.name AS serviceRegion
       FROM     sr_srvc_request_v s,
                sr_srvc_region_v r
       WHERE    s.srvc_request_num NOT IN (SELECT
distinct(rev.srvc_request_num) FROM ra_review_t rev)
       AND      s.srvc_region_id = r.srvc_region_id    
    </select>       
</sqlMap>
 
 
Caused by:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
com/alcon/ezra/persistence/sql/service-request.xml.
--- The error occurred while applying a parameter map.
--- Check the ServiceRequest.getAllPendingSRs-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: MSDTC on
server 'USRV526\EZRADEV' is unavailable.
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: MSDTC on
server 'USRV526\EZRADEV' is unavailable.
        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQeryW
ithCallback(GeneralStatement.java:185)
        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQeryF
orList(GeneralStatement.java:123)
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqMapE
xecutorDelegate.java:610)
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqMapE
xecutorDelegate.java:584)
        at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSssio
nImpl.java:101)
        at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClentI
mpl.java:78)
        at
com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapaoTe
mplate.java:203)
        at
com.alcon.ezra.persistence.dao.ServiceRequestDao.getServiceRequests(Serv
iceRequestDao.java:55)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpljava
:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesorI
mpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
        at $Proxy5.getServiceRequests(Unknown Source)
        at
com.alcon.ezra.service.ServiceRequestDaoService.getServiceRequests(Srvic
eRequestDaoService.java:39)
        at
com.alcon.ezra.action.MyHomeAction.buildListModel(MyHomeAction.java:74)
        at
com.alcon.ezra.action.MyHomeAction.loadPendingSRList(MyHomeAction.jaa:15
6)
        at
com.alcon.ezra.action.MyHomeAction.doExecute(MyHomeAction.java:77)
        at com.cc.framework.adapter.struts.ActionUtil.execute(Unknown
Source)
        at com.cc.framework.adapter.struts.FWAction.execute(Unknown
Source)
        at com.cc.framework.adapter.struts.FWAction.execute(Unknown
Source)
        at
com.cc.framework.adapter.struts.RequestProcessorUtil.processAction(Uknow
n Source)
        at
com.cc.framework.adapter.struts.FWTilesRequestProcessor.processActioPerf
orm(Unknown Source)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.jva:2
36)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:116)
        at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
        at
com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequstDi
spatcher.java:719)
        at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(Servle
tRequestDispatcher.java:376)
        at
com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpReqestH
andler.java:870)
        at
com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequetHan
dler.java:451)
        at
com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequstHa
ndler.java:218)
        at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.jva:1
19)
        at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.jva:1
12)
        at
oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerScket
ReadHandler.java:260)
        at
com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(Relesabl
eResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: MSDTC on
server 'USRV526\EZRADEV' is unavailable.
        at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseErro(Unk
nown Source)
        at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown
Source)
        at
com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(UnknownSourc
e)
        at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecute(Unknown
Source)
        at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknwn
Source)
        at
oracle.oc4j.sql.proxy.PreparedStatementBCELProxy.execute(PreparedStaemen
tBCELProxy.java:333)


This e-mail (including any attachments) is confidential and may be legally privileged. If
you are not an intended recipient or an authorized representative of an intended recipient,
you are prohibited from using, copying or distributing the information in this e-mail or its
attachments. If you have received this e-mail in error, please notify the sender immediately
by return e-mail and delete all copies of this message and any attachments.
Thank you.

Mime
View raw message