ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogish...@tcs.com
Subject Re: Stored procedure:Temporary select/update/insert sqls before actual select query
Date Tue, 23 May 2006 16:23:29 GMT
<P>hi ,</P>
<P>thanks for the reply...</P>
<P>i am using Sybase database but when i execute this with sql-advantage it will return
only one resultset but still i am getting this error.</P>
<P>My question is in the following example, as per Ibatis how many resultsets it is
expecting..?<BR>is it assumes first 2 select sqls returning resultsets..?</P>
<P>//procedure<BR>******************************************************<BR>create
procedure testinsertTrade&nbsp;&nbsp; @id_trd_ver int<BR>&nbsp;as<BR>&nbsp;begin<BR>&nbsp;&nbsp;declare
@id float,@dt_trd int<BR>&nbsp;select @id= max(id_trd)+1 from TEST_TRADE<BR>&nbsp;select
@dt_trd= convert(int, convert(char(12), getdate(), 112))<BR>&nbsp; &nbsp;insert
into TEST_TRADE (id_trd ,id_trd_ver,dt_trd) VALUES(@id,@id_trd_ver ,@dt_trd)<BR>&nbsp;select
* from TEST_TRADE&nbsp; where <A href="mailto:id_trd=@id">id_trd=@id</A><BR>&nbsp;end</P>
<P>******************************************************</P>
<P><BR>thanks in advance</P>
<P>Yogish<BR><BR><BR></P>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 V5DOTBL="true">

<TR vAlign=top>
<TD width="37%" bgColor=#e1e1e1 rowSpan=5><IMG height=1 alt="" src="/icons/ecblank.gif"
width=1 border=0><BR>
<DIV align=center><B><FONT style="FONT-SIZE: 9pt">"Jeff Butler" &lt;jeffgbutler@gmail.com&gt;</FONT></B>

<P><FONT style="FONT-SIZE: 9pt">05/23/2006 10:10 EST</FONT>
<HR>
<FONT size=-1>Please respond to user-java@ibatis.apache.org</FONT>
<HR>
</DIV></TD>
<TD width="1%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=102
border=0><BR>
<DIV align=right><FONT style="FONT-SIZE: 9pt">To</FONT>&nbsp;&nbsp;</DIV></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR><FONT style="FONT-SIZE: 9pt">user-java@ibatis.apache.org</FONT></TD></TR>
<TR vAlign=top>
<TD width="1%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=102
border=0><BR>
<DIV align=right><FONT style="FONT-SIZE: 9pt">cc</FONT>&nbsp;&nbsp;</DIV></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR></TD></TR>
<TR vAlign=top>
<TD width="1%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=102
border=0><BR>
<DIV align=right><FONT style="FONT-SIZE: 9pt">bcc</FONT>&nbsp;&nbsp;</DIV></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR></TD></TR>
<TR vAlign=top>
<TD width="1%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=102
border=0><BR>
<DIV align=right><FONT style="FONT-SIZE: 9pt">Subject</FONT>&nbsp;&nbsp;</DIV></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR><FONT style="FONT-SIZE: 9pt">Re: Stored procedure:Temporary select/update/insert
sqls before actual select query</FONT></TD></TR>
<TR vAlign=top>
<TD width=0% bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR><FONT size=-1></FONT></TD></TR></TABLE><BR><FONT
style="FONT-SIZE: 12pt">You need to make sure that these "temporary" selects are not returning
results sets because - as you've already read - iBATIS does not support multiple result sets.</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><FONT style="FONT-SIZE: 12pt">The
best way to debug would be&nbsp;to run the SP from something like Squirrel SQL where you
can see the results - and make sure that only one result set is coming back.</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><FONT style="FONT-SIZE: 12pt">If
the DB is SQL Server, then the "temporary" selects can be avoided by doing something like
"select ... into #temp ...".&nbsp; With DB2 you have more explicit control over which
queries generate returned result sets. </FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><FONT
style="FONT-SIZE: 12pt">Jeff Butler</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">&nbsp;</FONT><BR><FONT style="FONT-SIZE: 12pt">On 5/23/06,
</FONT><A href="mailto:yogisha.b@tcs.com"><B><U><FONT style="FONT-SIZE:
12pt" color=#0000ff>yogisha.b@tcs.com</FONT></U></B></A><FONT
style="FONT-SIZE: 12pt"> </FONT><FONT style="FONT-SIZE: 12pt">&lt;</FONT><A
href="mailto:yogisha.b@tcs.com"><U><FONT style="FONT-SIZE: 12pt" color=#0000ff>yogisha.b@tcs.com</FONT></U></A><FONT
style="FONT-SIZE: 12pt">&gt; wrote:</FONT><FONT style="FONT-SIZE: 12pt">Hi
all,</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">I have a problem
in getting the resultsets from procedure:</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">basically a few sqls are run before executing main select sql with in the </FONT><BR><FONT
style="FONT-SIZE: 12pt">procedure.</FONT><BR><FONT style="FONT-SIZE: 12pt">when
i execute&nbsp;&nbsp;i will get uncategorized exception. if i comment first sql</FONT><BR><FONT
style="FONT-SIZE: 12pt">and give hard coded value in second sql it works</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">I suspect it will try to map resultsets of first sql to resultMap
object. </FONT><BR><BR><FONT style="FONT-SIZE: 12pt">And i have read
at this point Ibatis doesnt support multiple resultsets,</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">In my procedure there are lot of temporary select/update/insert
sqls are</FONT><BR><FONT style="FONT-SIZE: 12pt">executed before main sql
will be executed.. in that case</FONT><BR><FONT style="FONT-SIZE: 12pt">how
does IBATIS treat those sql&nbsp;&nbsp;and how do i hide those... and how do i</FONT><BR><FONT
style="FONT-SIZE: 12pt">get resultsets from the last select sql?</FONT><BR><BR><BR><FONT
style="FONT-SIZE: 12pt">Following is the&nbsp;&nbsp;sample code where few temporary
queries are executed</FONT><BR><FONT style="FONT-SIZE: 12pt">before the
main select sql. </FONT><BR><BR><FONT style="FONT-SIZE: 12pt">Pls
help in this regard:</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">Thanks</FONT><BR><FONT
style="FONT-SIZE: 12pt">Yogish</FONT><BR><BR><BR><BR><FONT
style="FONT-SIZE: 12pt">/********** sample code</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">//procedure</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">create procedure testGetList @idParam int</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">as</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">begin</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">/*** lot of temporary select ,update insert will goes here before
executing </FONT><BR><FONT style="FONT-SIZE: 12pt">final select sql../</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">declare @id int</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">select @id=id_trd from tablex where id_trd=@idParam</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">select * from tabley where id=@id</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">end</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">//sql maps</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">&lt;procedure
id="executeInsert" parameterClass=" test.Trade"</FONT><BR><FONT style="FONT-SIZE:
12pt">resultMap="resultAll"&gt;</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
{ call testGetList(#idParam#) }</FONT><BR><FONT style="FONT-SIZE: 12pt">&lt;/procedure&gt;</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; &lt;resultMap id="resultAll"
class="test.Trade"&gt;</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;result column="id_amt" property="id_trd" jdbcType="DOUBLE" /&gt; </FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;result column="id_qnty" property="id_trd_ver"</FONT><BR><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
jdbcType="INTEGER" /&gt;</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/resultMap&gt;</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">//java
call</FONT><BR><FONT style="FONT-SIZE: 12pt">getSqlMapClientTemplate().queryForList("executeInsert"
, trade); </FONT><BR><BR><BR><FONT style="FONT-SIZE: 12pt">exeption.DataBaseException:</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
operation;</FONT><BR><FONT style="FONT-SIZE: 12pt">uncategorized SQLException
for SQL</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">[]; SQL state
[null]; error code [0];</FONT><BR><FONT style="FONT-SIZE: 12pt">--- The
error occurred in ibatis/Trade.xml. </FONT><BR><FONT style="FONT-SIZE: 12pt">---
The error occurred while applying a parameter map.</FONT><BR><FONT style="FONT-SIZE:
12pt">--- Check the executeInsert-InlineParameterMap.</FONT><BR><FONT style="FONT-SIZE:
12pt">--- Check the results (failed to retrieve results).</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Cause: java.lang.NullPointerException; nested exception is
</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.common.jdbc.exception.NestedSQLException:</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred in ibatis/Trade.xml.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred while applying a parameter map.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the executeInsert-InlineParameterMap.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the results (failed to retrieve results). </FONT><BR><FONT
style="FONT-SIZE: 12pt">at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:25)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.runTest(TestCase.java:154)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.runBare(TestCase.java:127)
</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at junit.framework.TestResult$1.protect(TestResult.java:106)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestResult.runProtected(TestResult.java:124)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestResult.run(TestResult.java:109)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.run
(TestCase.java:118)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at junit.framework.TestSuite.runTest(TestSuite.java:208)</FONT><BR><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestSuite.run(TestSuite.java:203)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests
(RemoteTestRunner.java:478)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java
:196)</FONT><BR><FONT style="FONT-SIZE: 12pt">Caused by: org.springframework.jdbc.UncategorizedSQLException:
SqlMapClient</FONT><BR><FONT style="FONT-SIZE: 12pt">operation; uncategorized
SQLException for SQL []; SQL state [null]; error</FONT><BR><FONT style="FONT-SIZE:
12pt">code [0];</FONT><BR><FONT style="FONT-SIZE: 12pt">--- The error
occurred in ibatis/Trade.xml. </FONT><BR><FONT style="FONT-SIZE: 12pt">---
The error occurred while applying a parameter map.</FONT><BR><FONT style="FONT-SIZE:
12pt">--- Check the executeInsert-InlineParameterMap.</FONT><BR><FONT style="FONT-SIZE:
12pt">--- Check the results (failed to retrieve results).</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Cause: java.lang.NullPointerException; nested exception is
</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.common.jdbc.exception.NestedSQLException:</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred in ibatis/Trade.xml.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred while applying a parameter map.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the executeInsert-InlineParameterMap.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the results (failed to retrieve results). </FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Cause: java.lang.NullPointerException</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:96)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate
(SQLErrorCodeSQLExceptionTranslator.java:257)</FONT><BR><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT style="FONT-SIZE:
12pt">org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:168)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult
(SqlMapClientTemplate.java:204)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:243)</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred in ibatis/Trade.xml. </FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred while applying a parameter map.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the executeInsert-InlineParameterMap.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the results (failed to retrieve results).</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Cause: java.lang.NullPointerException</FONT><BR><FONT
style="FONT-SIZE: 12pt">Caused by: java.lang.NullPointerException</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList
(GeneralStatement.java:123)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
SqlMapExecutorDelegate.java:584)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java
:78)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:245)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:165)
</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
... 19 more</FONT><BR><FONT style="FONT-SIZE: 12pt">Caused by: java.lang.NullPointerException</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:355)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure
(SqlExecutor.java:291)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:34)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
(GeneralStatement.java:173)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
... 26 more</FONT><BR><BR><BR><FONT style="FONT-SIZE: 12pt">**********/</FONT><BR><FONT
style="FONT-SIZE: 12pt">=====-----=====-----=====</FONT><BR><FONT style="FONT-SIZE:
12pt">Notice: The information contained in this e-mail</FONT><BR><FONT style="FONT-SIZE:
12pt">message and/or attachments to it may contain</FONT><BR><FONT style="FONT-SIZE:
12pt">confidential or privileged information. If you are </FONT><BR><FONT
style="FONT-SIZE: 12pt">not the intended recipient, any dissemination, use,</FONT><BR><FONT
style="FONT-SIZE: 12pt">review, distribution, printing or copying of the</FONT><BR><FONT
style="FONT-SIZE: 12pt">information contained in this e-mail message</FONT><BR><FONT
style="FONT-SIZE: 12pt">and/or attachments to it are strictly prohibited. If</FONT><BR><FONT
style="FONT-SIZE: 12pt">you have received this communication in error, </FONT><BR><FONT
style="FONT-SIZE: 12pt">please notify us by reply e-mail or telephone and</FONT><BR><FONT
style="FONT-SIZE: 12pt">immediately and permanently delete the message</FONT><BR><FONT
style="FONT-SIZE: 12pt">and any attachments. Thank you</FONT><BR><BR><BR><BR><BR><FONT
style="FONT-SIZE: 1pt" color=#ffffff>ForwardSourceID:NT000021AA </FONT>
Mime
View raw message