Hey Brandon,
This e-mail I sent got rejected... sending again. But not sending any
attachments. I am copying the contents of the two txt files into this
e-mail. If there is a better way of sending all this info, please let me
know.
Thanks!
Sam
*********************************
Log of carrier_is_AWSCV2.txt
*********************************
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsActionServlet.class - > doPost
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
org.apache.struts.util.RequestUtils - Get module name for path
/errors.do
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
org.apache.struts.util.RequestUtils - Module name found: default
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
org.apache.struts.action.RequestProcessor - Processing a 'POST' for path
'/errors'
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
org.apache.struts.action.RequestProcessor - Looking for Action instance
for class mimtools.common.MIMToolsDispatchAction
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
org.apache.struts.action.RequestProcessor - Returning existing Action
instance
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - > viewErrorLog
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - > setLocationAndCarrier
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - Database Info 0 : true
true mmspr901
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - Database Info 1 : true
false mmspr951
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - < setLocationAndCarrier
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - > getInterfaceErrorCount
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - > queryInterfaceErrorCount
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - > manageSIDs
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - SID list: [mmspr901]
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - < manageSIDs
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - SID list updated
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - > performMultiplePRVServerQuery
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Parameters: {sidList=[mmspr901],
[EMAIL PROTECTED],
[EMAIL PROTECTED], carrier=AWSCV2,
interfaceType=Provisioning}
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Calling queryForList with statementName:
queryInterfaceErrorCount and parameters: {sidList=[mmspr901],
[EMAIL PROTECTED],
[EMAIL PROTECTED], carrier=AWSCV2,
interfaceType=Provisioning}
2005-06-28 11:40:24,571 [HttpRequestHandler-320] DEBUG
com.ibatis.common.jdbc.SimpleDataSource - Checked out connection 303
from pool.
2005-06-28 11:40:24,651 [HttpRequestHandler-320] DEBUG
java.sql.Connection - {conn-100180} Connection
2005-06-28 11:40:24,651 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100181} PreparedStatement:
select sum(count) as count from ( ( select
count(*) as count from [EMAIL PROTECTED] where
interface_type = ? and carrier_name = ?
) )
2005-06-28 11:40:24,651 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100181} Parameters: [AWSCV2,
Provisioning]
2005-06-28 11:40:24,651 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100181} Types: [java.lang.String,
java.lang.String]
2005-06-28 11:40:25,132 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100182} ResultSet
2005-06-28 11:40:25,132 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100182} Header: [count]
2005-06-28 11:40:25,232 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100182} Result: [0]
2005-06-28 11:40:25,232 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Multiple Query successful. Result list
length: 1
2005-06-28 11:40:25,232 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Commit successful
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
com.ibatis.common.jdbc.SimpleDataSource - Returned connection 303 to
pool.
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - < performMultiplePRVServerQuery
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - < queryInterfaceErrorCount
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - < getInterfaceErrorCount
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - recordCount: 0
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - > getInterfaceErrorLog
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - firstRecord value: 0
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - lastRecord value: 50
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - > queryInterfaceErrorLog
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - > manageSIDs
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - SID list: [mmspr901]
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - < manageSIDs
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - SID list updated
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - > performMultiplePRVServerQuery
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Parameters: {sidList=[mmspr901],
firstRecord=0, [EMAIL PROTECTED],
[EMAIL PROTECTED], carrier=AWSCV2, lastRecord=50,
interfaceType=Provisioning}
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Calling queryForList with statementName:
queryInterfaceErrorLog and parameters: {sidList=[mmspr901],
firstRecord=0, [EMAIL PROTECTED],
[EMAIL PROTECTED], carrier=AWSCV2, lastRecord=50,
interfaceType=Provisioning}
2005-06-28 11:40:25,312 [HttpRequestHandler-320] DEBUG
com.ibatis.common.jdbc.SimpleDataSource - Checked out connection 303
from pool.
2005-06-28 11:40:25,392 [HttpRequestHandler-320] DEBUG
java.sql.Connection - {conn-100183} Connection
2005-06-28 11:40:25,392 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100184} PreparedStatement:
select rn, d.error_id, d.event_timestamp, d.msisdn,
d.carrier_name, d.subscriber_num, d.error_cleared_ind, d.cleared_by,
d.cleared_timestamp, d.locked_ind, d.locked_by,
d.locked_timestamp, d.product_id, d.interface_type, d.major_error_code,
d.major_error_desc, d.minor_error_code, d.minor_error_desc,
d.master_bpid, d.location from ( select rownum as
rn, c.error_id, c.event_timestamp, c.msisdn, c.carrier_name,
c.subscriber_num, c.error_cleared_ind, c.cleared_by,
c.cleared_timestamp, c.locked_ind, c.locked_by,
c.locked_timestamp, c.product_id, c.interface_type, c.major_error_code,
c.major_error_desc, c.minor_error_code, c.minor_error_desc,
c.master_bpid, c.location from ( (
select b.error_id, b.event_timestamp, b.msisdn,
b.carrier_name, b.subscriber_num, b.error_cleared_ind, b.cleared_by,
b.cleared_timestamp, b.locked_ind, b.locked_by,
b.locked_timestamp, b.product_id, b.interface_type, b.major_error_code,
b.major_error_desc, b.minor_error_code, b.minor_error_desc,
b.master_bpid, b.location from (
select * from [EMAIL PROTECTED] where
interface_type = ? and carrier_name
= ? order by event_timestamp DESC
) b ) order by event_timestamp desc ) c
) d where rn > 0 and rn <= 50
2005-06-28 11:40:25,392 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100184} Parameters: [AWSCV2,
Provisioning]
2005-06-28 11:40:25,392 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100184} Types: [java.lang.String,
java.lang.String]
2005-06-28 11:40:25,713 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100185} ResultSet
2005-06-28 11:40:25,713 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Multiple Query successful. Result list
length: 0
2005-06-28 11:40:25,713 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Commit successful
2005-06-28 11:40:25,783 [HttpRequestHandler-320] DEBUG
com.ibatis.common.jdbc.SimpleDataSource - Returned connection 303 to
pool.
2005-06-28 11:40:25,783 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - < performMultiplePRVServerQuery
2005-06-28 11:40:25,783 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - < queryInterfaceErrorLog
2005-06-28 11:40:25,783 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - < getInterfaceErrorLog
2005-06-28 11:40:25,783 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - < viewErrorLog
2005-06-28 11:40:26,013 [HttpRequestHandler-320] DEBUG
org.apache.struts.action.RequestProcessor -
processForwardConfig(ForwardConfig[name=errorLog,path=/errorLog.jsp,redi
rect=false,contextRelative=false])
2005-06-28 11:40:26,494 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsActionServlet.class - < doPost
***************************
Log of carrier_is_All.txt
*****************************
2005-06-28 11:39:37,704 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsActionServlet.class - > doPost
2005-06-28 11:39:37,704 [HttpRequestHandler-320] DEBUG
org.apache.struts.util.RequestUtils - Get module name for path
/errors.do
2005-06-28 11:39:37,704 [HttpRequestHandler-320] DEBUG
org.apache.struts.util.RequestUtils - Module name found: default
2005-06-28 11:39:37,704 [HttpRequestHandler-320] DEBUG
org.apache.struts.action.RequestProcessor - Processing a 'POST' for path
'/errors'
2005-06-28 11:39:37,704 [HttpRequestHandler-320] DEBUG
org.apache.struts.action.RequestProcessor - Looking for Action instance
for class mimtools.common.MIMToolsDispatchAction
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
org.apache.struts.action.RequestProcessor - Returning existing Action
instance
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - > viewErrorLog
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - > setLocationAndCarrier
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - Database Info 0 : true
true mmspr901
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - Database Info 1 : true
false mmspr951
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - < setLocationAndCarrier
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - > getInterfaceErrorCount
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - > queryInterfaceErrorCount
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - > manageSIDs
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - SID list: [mmspr901]
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - < manageSIDs
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - SID list updated
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - > performMultiplePRVServerQuery
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Parameters: {sidList=[mmspr901],
[EMAIL PROTECTED],
[EMAIL PROTECTED], carrier=All,
interfaceType=Provisioning}
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Calling queryForList with statementName:
queryInterfaceErrorCount and parameters: {sidList=[mmspr901],
[EMAIL PROTECTED],
[EMAIL PROTECTED], carrier=All,
interfaceType=Provisioning}
2005-06-28 11:39:37,714 [HttpRequestHandler-320] DEBUG
com.ibatis.common.jdbc.SimpleDataSource - Checked out connection 303
from pool.
2005-06-28 11:39:37,784 [HttpRequestHandler-320] DEBUG
java.sql.Connection - {conn-100174} Connection
2005-06-28 11:39:37,794 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100175} PreparedStatement:
select sum(count) as count from ( ( select
count(*) as count from [EMAIL PROTECTED] where
interface_type = ? ) )
2005-06-28 11:39:37,794 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100175} Parameters: [Provisioning]
2005-06-28 11:39:37,794 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100175} Types: [java.lang.String]
2005-06-28 11:39:38,094 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100176} ResultSet
2005-06-28 11:39:38,094 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100176} Header: [count]
2005-06-28 11:39:38,094 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100176} Result: [7]
2005-06-28 11:39:38,094 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Multiple Query successful. Result list
length: 1
2005-06-28 11:39:38,094 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Commit successful
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
com.ibatis.common.jdbc.SimpleDataSource - Returned connection 303 to
pool.
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - < performMultiplePRVServerQuery
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - < queryInterfaceErrorCount
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - < getInterfaceErrorCount
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - recordCount: 7
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - > getInterfaceErrorLog
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - firstRecord value: 0
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - lastRecord value: 50
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - > queryInterfaceErrorLog
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - > manageSIDs
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - SID list: [mmspr901]
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - < manageSIDs
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - SID list updated
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - > performMultiplePRVServerQuery
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Parameters: {sidList=[mmspr901],
firstRecord=0, [EMAIL PROTECTED],
[EMAIL PROTECTED], carrier=All, lastRecord=50,
interfaceType=Provisioning}
2005-06-28 11:39:38,174 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Calling queryForList with statementName:
queryInterfaceErrorLog and parameters: {sidList=[mmspr901],
firstRecord=0, [EMAIL PROTECTED],
[EMAIL PROTECTED], carrier=All, lastRecord=50,
interfaceType=Provisioning}
2005-06-28 11:39:38,184 [HttpRequestHandler-320] DEBUG
com.ibatis.common.jdbc.SimpleDataSource - Checked out connection 303
from pool.
2005-06-28 11:39:38,264 [HttpRequestHandler-320] DEBUG
java.sql.Connection - {conn-100177} Connection
2005-06-28 11:39:38,284 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100178} PreparedStatement:
select rn, d.error_id, d.event_timestamp, d.msisdn,
d.carrier_name, d.subscriber_num, d.error_cleared_ind, d.cleared_by,
d.cleared_timestamp, d.locked_ind, d.locked_by,
d.locked_timestamp, d.product_id, d.interface_type, d.major_error_code,
d.major_error_desc, d.minor_error_code, d.minor_error_desc,
d.master_bpid, d.location from ( select rownum as
rn, c.error_id, c.event_timestamp, c.msisdn, c.carrier_name,
c.subscriber_num, c.error_cleared_ind, c.cleared_by,
c.cleared_timestamp, c.locked_ind, c.locked_by,
c.locked_timestamp, c.product_id, c.interface_type, c.major_error_code,
c.major_error_desc, c.minor_error_code, c.minor_error_desc,
c.master_bpid, c.location from ( (
select b.error_id, b.event_timestamp, b.msisdn,
b.carrier_name, b.subscriber_num, b.error_cleared_ind, b.cleared_by,
b.cleared_timestamp, b.locked_ind, b.locked_by,
b.locked_timestamp, b.product_id, b.interface_type, b.major_error_code,
b.major_error_desc, b.minor_error_code, b.minor_error_desc,
b.master_bpid, b.location from (
select * from [EMAIL PROTECTED] where
interface_type = ? order by
event_timestamp DESC ) b ) order by
event_timestamp desc ) c ) d where rn > 0 and
rn <= 50
2005-06-28 11:39:38,284 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100178} Parameters: [Provisioning]
2005-06-28 11:39:38,284 [HttpRequestHandler-320] DEBUG
java.sql.PreparedStatement - {pstm-100178} Types: [java.lang.String]
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100179} ResultSet
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100179} Header: [rn, locked_ind, locked_by,
locked_timestamp, error_id, event_timestamp, carrier_name, product_id,
msisdn, major_error_code, minor_error_code, major_error_desc,
minor_error_desc, subscriber_num, error_cleared_ind, cleared_by,
cleared_timestamp, interface_type, master_bpid, location]
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100179} Result: [1, null, null, null, 55707,
06/27/2005 19:08:17 GMT, AWSCV2, 0000, 14253397378, 62000, 62140, Data
Validation Error, PrevMSISDN and MSISDN values cannot be identical -
duplicate msisdn-prevMsisdn, null, null, null, null, Provisioning,
CBPS111989929737100, boboapp01a:10010]
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100179} Result: [2, null, null, null, 55707,
06/27/2005 19:08:17 GMT, AWSCV2, 0026, 14253397378, 62000, 62140, Data
Validation Error, PrevMSISDN and MSISDN values cannot be identical -
duplicate msisdn-prevMsisdn, null, null, null, null, Provisioning,
CBPS111989929737100, boboapp01a:10010]
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100179} Result: [3, null, null, null, 55707,
06/27/2005 19:08:17 GMT, AWSCV2, 0052, 14253397378, 62000, 62140, Data
Validation Error, PrevMSISDN and MSISDN values cannot be identical -
duplicate msisdn-prevMsisdn, null, null, null, null, Provisioning,
CBPS111989929737100, boboapp01a:10010]
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100179} Result: [4, null, null, null, 55707,
06/27/2005 19:08:17 GMT, AWSCV2, 0053, 14253397378, 62000, 62140, Data
Validation Error, PrevMSISDN and MSISDN values cannot be identical -
duplicate msisdn-prevMsisdn, null, null, null, null, Provisioning,
CBPS111989929737100, boboapp01a:10010]
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100179} Result: [5, null, null, null, 55707,
06/27/2005 19:08:17 GMT, AWSCV2, 1001, 14253397378, 62000, 62140, Data
Validation Error, PrevMSISDN and MSISDN values cannot be identical -
duplicate msisdn-prevMsisdn, null, null, null, null, Provisioning,
CBPS111989929737100, boboapp01a:10010]
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100179} Result: [6, null, null, null, 55707,
06/27/2005 19:08:17 GMT, AWSCV2, 1020, 14253397378, 62000, 62140, Data
Validation Error, PrevMSISDN and MSISDN values cannot be identical -
duplicate msisdn-prevMsisdn, null, null, null, null, Provisioning,
CBPS111989929737100, boboapp01a:10010]
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
java.sql.ResultSet - {rset-100179} Result: [7, null, null, null, 55707,
06/27/2005 19:08:17 GMT, AWSCV2, 4400, 14253397378, 62000, 62140, Data
Validation Error, PrevMSISDN and MSISDN values cannot be identical -
duplicate msisdn-prevMsisdn, null, null, null, null, Provisioning,
CBPS111989929737100, boboapp01a:10010]
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Multiple Query successful. Result list
length: 7
2005-06-28 11:39:38,605 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - Commit successful
2005-06-28 11:39:38,685 [HttpRequestHandler-320] DEBUG
com.ibatis.common.jdbc.SimpleDataSource - Returned connection 303 to
pool.
2005-06-28 11:39:38,685 [HttpRequestHandler-320] DEBUG
mimtools.common.BaseDAO.class - < performMultiplePRVServerQuery
2005-06-28 11:39:38,685 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorDAO.class - < queryInterfaceErrorLog
2005-06-28 11:39:38,685 [HttpRequestHandler-320] DEBUG
mimtools.errors.ErrorService.class - < getInterfaceErrorLog
2005-06-28 11:39:38,685 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - errorLog size: 7
2005-06-28 11:39:38,685 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsDispatchAction.class - < viewErrorLog
2005-06-28 11:39:38,685 [HttpRequestHandler-320] DEBUG
org.apache.struts.action.RequestProcessor -
processForwardConfig(ForwardConfig[name=errorLog,path=/errorLog.jsp,redi
rect=false,contextRelative=false])
2005-06-28 11:39:39,136 [HttpRequestHandler-320] DEBUG
mimtools.common.MIMToolsActionServlet.class - < doPost
-----Original Message-----
From: Abeyratne, Sam
Sent: Tuesday, June 28, 2005 11:54 AM
To: 'Brandon Goodin (JIRA)'
Subject: RE: [jira] Commented: (IBATIS-148) Capability to use dynamic
sql within iterates
Hi Brandon,
Sorry for the long delay in getting back to you on this.
I am attaching two logs. The first one is when the 'carrier' parameter
is set to 'All' (carrier is All.txt) and the second is when the
'carrier' parameter is set to 'AWSCV2' (carrier is AWSCV2.txt).
As you can see, although the carrier value gets passed, I end up getting
0 as the result. But, if I run the same query directly on the DB, I get
a result back. You may notice the carrier condition with 'AWSCV2' should
give the same result since all of the records have a carrier-name of
'AWSCV2'
So in this case having 'All', or 'AWSCV2' should result in the same data
set.
The funny thing is that the issue arises only when I have an extra
parameter, in this case, #interfaceType#. I have similar queries which
has the iterate and the dynamic portion, but only has sidList[] and
#carrier#
as parameters in the sqlMap.
I am using oracle.jdbc.driver.OracleDriver
The Oracle version is 9.2.0.4
Thanks for all your help!!!!
Sam
*****************************
My SQLMap looks like this:
*****************************
<cacheModel id="interface_error_log_cache" type="MEMORY">
<flushInterval minutes="1"/>
<flushOnExecute statement="updateErrorLockIndicatorToLock"/>
<flushOnExecute statement="updateErrorLockIndicatorToUnlock"/>
<flushOnExecute statement="updateErrorClearIndicator"/>
<flushOnExecute statement="queryInterfaceErrorLog"/>
<property name="reference-type" value="WEAK"/>
</cacheModel>
<resultMap id="interface_error_log_result"
class="mimtools.errors.ErrorLog">
<result property="rn" column="rn"/>
<result property="locked_ind" column="locked_ind"/>
<result property="locked_by" column="locked_by"/>
<result property="locked_timestamp" column="locked_timestamp"/>
<result property="error_id" column="error_id"/>
<result property="event_timestamp" column="event_timestamp"/>
<result property="carrier_name" column="carrier_name"/>
<result property="product_id" column="product_id"/>
<result property="msisdn" column="msisdn"/>
<result property="major_error_code" column="major_error_code"/>
<result property="minor_error_code" column="minor_error_code"/>
<result property="major_error_desc" column="major_error_desc"/>
<result property="minor_error_desc" column="minor_error_desc"/>
<result property="subscriber_num" column="subscriber_num"/>
<result property="error_cleared_ind" column="error_cleared_ind"/>
<result property="cleared_by" column="cleared_by"/>
<result property="cleared_timestamp" column="cleared_timestamp"/>
<result property="interface_type" column="interface_type"/>
<result property="master_bpid" column="master_bpid"/>
<result property="location" column="location"/>
</resultMap>
<select id="queryInterfaceErrorLog"
parameterClass="java.util.Map" resultMap="interface_error_log_result"
cacheModel="interface_error_log_cache">
select rn, d.error_id, d.event_timestamp, d.msisdn,
d.carrier_name, d.subscriber_num, d.error_cleared_ind,
d.cleared_by, d.cleared_timestamp, d.locked_ind, d.locked_by,
d.locked_timestamp, d.product_id, d.interface_type,
d.major_error_code,
d.major_error_desc, d.minor_error_code, d.minor_error_desc,
d.master_bpid, d.location
from
(
select rownum as rn, c.error_id, c.event_timestamp, c.msisdn,
c.carrier_name, c.subscriber_num, c.error_cleared_ind,
c.cleared_by, c.cleared_timestamp, c.locked_ind, c.locked_by,
c.locked_timestamp, c.product_id, c.interface_type,
c.major_error_code,
c.major_error_desc, c.minor_error_code, c.minor_error_desc,
c.master_bpid, c.location
from
(
<iterate property="sidList" open="(" close=")"
conjunction="UNION ALL">
select b.error_id, b.event_timestamp, b.msisdn,
b.carrier_name, b.subscriber_num, b.error_cleared_ind,
b.cleared_by, b.cleared_timestamp, b.locked_ind, b.locked_by,
b.locked_timestamp, b.product_id, b.interface_type,
b.major_error_code,
b.major_error_desc, b.minor_error_code,
b.minor_error_desc, b.master_bpid, b.location
from
(
select * from [EMAIL PROTECTED]
where interface_type = #interfaceType#
<isNotEqual prepend="and" property="carrier"
compareValue="All">
carrier_name = #carrier#
</isNotEqual>
order by event_timestamp DESC
) b
</iterate>
order by event_timestamp desc
) c
) d
where rn > $firstRecord$
and rn <= $lastRecord$
</select>
*******************************
The java code looks like this:
*******************************
try {
// Since we are querying across multiple datasources, it is
necessary to
// commit. Thus these statements are wrapped in their own try
block
// with a finally to clean up the transaction regardless of its
outcome
try {
logger.debug("Parameters: " + parameters.toString());
//Grab a sqlMap based on the first db sid found
ArrayList sids = (ArrayList) parameters.get("sidList");
if(sids != null) {
prvSQLMap = (SqlMapClient) prvSQLHashtable.get((String)
sids.get(0));
} else {
logger.error("Parameters did not contain a list of
'sidList'!");
throw new MIMToolsException("Statement parameters did not
contain a list of SIDs, check configuration");
} // End if
// Begin performing the Query
prvSQLMap.startTransaction();
logger.debug("Calling queryForList with statementName: " +
statementName + " and parameters: " + parameters.toString());
list = prvSQLMap.queryForList(statementName, parameters);
logger.debug("Multiple Query successful. Result list length: " +
list.size());
prvSQLMap.commitTransaction();
logger.debug("Commit successful");
} catch (SQLException sqlEx) {
throw sqlEx;
} finally {
prvSQLMap.endTransaction();
}
-----Original Message-----
From: Brandon Goodin (JIRA) [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 09, 2005 9:50 PM
To: Abeyratne, Sam
Subject: [jira] Commented: (IBATIS-148) Capability to use dynamic sql
within iterates
[
http://issues.apache.org/jira/browse/IBATIS-148?page=comments#action_123
13215 ]
Brandon Goodin commented on IBATIS-148:
---------------------------------------
I have run a unit test that shows that i'm getting the proper results:
my java code:
public void testIterateNestedListPropertyB() throws SQLException {
Account account = new Account();
account.setId(99);
account.setAccountList(new ArrayList());
account.getAccountList().add(new Account(1));
account.getAccountList().add(new Account(2));
account.getAccountList().add(new Account(3));
List list = sqlMap.queryForList("iterateNestedListPropertyB",
account);
assertAccount1((Account) list.get(0));
assertEquals(3, list.size());
}
my mapped statement code:
<select id="iterateNestedListPropertyB"
parameterClass="testdomain.Account"
resultClass="testdomain.Account">
select
ACC_ID as id,
ACC_FIRST_NAME as firstName,
ACC_LAST_NAME as lastName,
ACC_EMAIL as emailAddress
from ACCOUNT
WHERE ACC_ID IN
<iterate open="(" close=")" conjunction="," property="accountList">
#accountList[].id#
<isNotEqual prepend="," compareProperty="firstName"
compareValue="test">
#id#
</isNotEqual>
</iterate>
</select>
my final sql statement is:
select ACC_ID as id, ACC_FIRST_NAME as
firstName, ACC_LAST_NAME as lastName, ACC_EMAIL as
emailAddress from ACCOUNT WHERE ACC_ID IN ( ?
, ? , ? , ?
, ? , ? )
my passed in parameters are:
[0] = 99
[1] = 1
[2] = 99
[3] = 2
[4] = 99
[5] = 3
Everything appears to be working just fine with my unit test and i am
not getting any complaints about the results. Please post all
information regarding this issue. I need to see your full logs, your
current mapped statement and the java code that calls it. I also need to
know what database and version you are using as well as the driver and
version. Also, please state how the logging results do not agree with
what you expect to see.
Thanks,
Brandon
> Capability to use dynamic sql within iterates
> ---------------------------------------------
>
> Key: IBATIS-148
> URL: http://issues.apache.org/jira/browse/IBATIS-148
> Project: iBatis for Java
> Type: Improvement
> Components: SQL Maps
> Versions: 2.1.0, 2.0.9b
> Reporter: Sam Abeyratne
> Assignee: Brandon Goodin
>
> I am getting the following error when I try to run a simple query that
has a dynamic <isNotEqual> within an iterate tag. Per Brandon, this is
a known issue that needs to be fixed.
> Thanks!
> Sam
> 2005-06-06 17:11:25,284 [HttpRequestHandler-2083] DEBUG xxxDAO.class -
Parameters: {sidList=[abc1, abc2], carrier=ABCDE1, interfaceType=DSP}
> 2005-06-06 17:11:25,284 [HttpRequestHandler-2083] DEBUG xxxDAO.class -
Calling queryForList with statementName: queryInterfaceErrorCount and
parameters: {sidList=[abc1, abc2], carrier= ABCDE1, interfaceType=DSP}
> 2005-06-06 17:11:25,294 [HttpRequestHandler-2083] ERROR
xxxDispatchAction.class - Entered catch block in viewErrorLog: Exception
in queryInterfaceErrorCount: com.ibatis.common.beans.ProbeException:
Error getting ordinal list from JavaBean. Cause
java.lang.NumberFormatException: For input string: "" Caused by:
java.lang.NumberFormatException: For input string: ""
> The sqlmap looks something like:
> <select id="queryInterfaceErrorCount"
parameterClass="java.util.Map" resultMap="interface_error_count_result"
cacheModel="interface_error_count_cache">
> select sum(count) as count
> from
> (
> <iterate property="sidList" open="(" close=")"
conjunction="UNION ALL">
> select count(*) as count
> from [EMAIL PROTECTED]
> where interface_type = #interfaceType#
> <isNotEqual prepend="and" property="carrier"
compareValue="All">
> carrier_name = #carrier#
> </isNotEqual>
> </iterate>
> )
> </select>
>
> Java bean looks like:
> public class InterfaceErrorCount {
> private int count;
> public int getCount() {
> return count;
> }
> public void setCount(int count) {
> this.count = count;
> }
> }
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
