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>
<!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.executeQeryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQeryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqMapExecutorDelegate.java:610)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqMapExecutorDelegate.java:584)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSssionImpl.java:101)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClentImpl.java:78)
at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapaoTemplate.java:203)
at com.alcon.ezra.persistence.dao.ServiceRequestDao.getServiceRequests(ServiceRequestDao.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpljava:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesorImpl.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(SrviceRequestDaoService.java:39)
at com.alcon.ezra.action.MyHomeAction.buildListModel(MyHomeAction.java:74)
at com.alcon.ezra.action.MyHomeAction.loadPendingSRList(MyHomeAction.jaa:156)
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(Uknown Source)
at com.cc.framework.adapter.struts.FWTilesRequestProcessor.processActioPerform(Unknown Source)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.jva:236)
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(ServletRequstDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpReqestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequetHandler.java:451)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequstHandler.java:218)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.jva:119)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.jva:112)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerScketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(RelesableResourcePooledExecutor.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(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
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.executeQeryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQeryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqMapExecutorDelegate.java:610)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqMapExecutorDelegate.java:584)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSssionImpl.java:101)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClentImpl.java:78)
at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapaoTemplate.java:203)
at com.alcon.ezra.persistence.dao.ServiceRequestDao.getServiceRequests(ServiceRequestDao.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpljava:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesorImpl.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(SrviceRequestDaoService.java:39)
at com.alcon.ezra.action.MyHomeAction.buildListModel(MyHomeAction.java:74)
at com.alcon.ezra.action.MyHomeAction.loadPendingSRList(MyHomeAction.jaa:156)
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(Uknown Source)
at com.cc.framework.adapter.struts.FWTilesRequestProcessor.processActioPerform(Unknown Source)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.jva:236)
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(ServletRequstDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpReqestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequetHandler.java:451)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequstHandler.java:218)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.jva:119)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.jva:112)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerScketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(RelesableResourcePooledExecutor.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(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(UnknownSource)
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(PreparedStaementBCELProxy.java:333)
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(PreparedStaementBCELProxy.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.