ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gwyn Evans <gwyn.ev...@gmail.com>
Subject Re: insert always returning null (urgent )
Date Sat, 22 Sep 2007 09:54:38 GMT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title></title>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
body {
  margin: 5px 5px 5px 5px;
  background-color: #ffffff;
}
/* ========== Text Styles ========== */
hr { color: #000000}
body, table /* Normal text */
{
 font-size: 9pt;
 font-family: 'Verdana';
 font-style: normal;
 font-weight: normal;
 color: #000000;
 text-decoration: none;
}
span.rvts1 /* Heading */
{
 font-size: 10pt;
 font-family: 'Arial';
 font-weight: bold;
 color: #0000ff;
}
span.rvts2 /* Subheading */
{
 font-size: 10pt;
 font-family: 'Arial';
 font-weight: bold;
 color: #000080;
}
span.rvts3 /* Keywords */
{
 font-size: 10pt;
 font-family: 'Arial';
 font-style: italic;
 color: #800000;
}
a.rvts4, span.rvts4 /* Jump 1 */
{
 font-size: 10pt;
 font-family: 'Arial';
 color: #008000;
 text-decoration: underline;
}
a.rvts5, span.rvts5 /* Jump 2 */
{
 font-size: 10pt;
 font-family: 'Arial';
 color: #008000;
 text-decoration: underline;
}
a.rvts6, span.rvts6
{
 color: #0000ff;
 text-decoration: underline;
}
span.rvts7
{
 font-size: 11pt;
 font-family: 'tahoma';
 font-weight: bold;
 color: #ffffff;
 background-color: #0000ff;
}
span.rvts8
{
 font-family: 'arial';
 color: #000080;
}
span.rvts9
{
 font-family: 'tahoma';
 font-weight: bold;
}
span.rvts10
{
 font-family: 'tahoma';
}
span.rvts11
{
 font-size: 12pt;
 font-family: 'times new roman';
}
a.rvts12, span.rvts12
{
 font-size: 12pt;
 font-family: 'times new roman';
 color: #0000ff;
 text-decoration: underline;
}
span.rvts13
{
 font-size: 12pt;
 font-family: 'times new roman';
 font-weight: bold;
}
/* ========== Para Styles ========== */
p,ul,ol /* Paragraph Style */
{
 text-align: left;
 text-indent: 0px;
 padding: 0px 0px 0px 0px;
 margin: 0px 0px 0px 0px;
}
.rvps1 /* Centered */
{
 text-align: center;
}
--></style>
</head>
<body>

<p>What Brandon was saying was that the information you need is in the manual, so read
it rather than posting.</p>
<p><br></p>
<p>/Gwyn</p>
<p><br></p>
<p>On Saturday, September 22, 2007, 6:28:44 AM, Yuvraj &lt;<a class=rvts6 href="mailto:Yuvraj.Shinde@sos.sungard.com">Yuvraj.Shinde@sos.sungard.com</a>&gt;
wrote:</p>
<p><br></p>
<div><a name=""address"/"></a>
<table border=0 cellpadding=1 cellspacing=2>
<tr valign=top>
<td width=12 style="background-color: #0000ff;">
<p><span class=rvts7>&gt;</span></p>
</td>
<td width=634 style="background-color: #ffffff;">
<p><span class=rvts8>Hi Brandon,</span></p>
<p><span class=rvts8>&nbsp;</span></p>
<p><span class=rvts8>&nbsp;Thanks for your kind reply. I don&#8217;t need
any training , if you need please contact me.</span></p>
<p><span class=rvts8>&nbsp;</span></p>
<p><span class=rvts8>Thanks</span></p>
<p><span class=rvts8>yuvrajs</span></p>
<p><span class=rvts8>&nbsp;</span></p>
<hr noshade size=2>
<p><span class=rvts9>From:</span><span class=rvts10>&nbsp;Brandon
Goodin [mailto:brandon.goodin@gmail.com]&nbsp;</span></p>
<p><span class=rvts9>Sent:</span><span class=rvts10>&nbsp;Friday,
September 21, 2007 11:15 PM</span></p>
<p><span class=rvts9>To:</span><span class=rvts10>&nbsp;user-java@ibatis.apache.org</span></p>
<p><span class=rvts9>Subject:</span><span class=rvts10>&nbsp;Re:
insert always returning null (urgent )</span></p>
<p><span class=rvts11>&nbsp;</span></p>
<p><span class=rvts11>Yuvraj,&nbsp;</span></p>
<p><br></p>
<p><span class=rvts11>I'd be happy to train you one on one on how to use iBATIS.
Feel free to contact me and i can provide you my billable rate. However, your best bet is
to read the manual first. It is located at &nbsp;</span><a class=rvts12 href="http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf">http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf</a><span
class=rvts11>. If you have questions after you read it. Please feel free to post here and
ask.</span></p>
<p><br></p>
<p><span class=rvts11>Thanks,</span></p>
<p><span class=rvts11>Brandon Goodin</span></p>
<p><span class=rvts11>On 9/21/07,&nbsp;</span><span class=rvts13>Yuvraj
Shinde</span><span class=rvts11>&nbsp;&lt;</span><a class=rvts12
href="mailto:Yuvraj.Shinde@sos.sungard.com">Yuvraj.Shinde@sos.sungard.com</a><span
class=rvts11>&gt; wrote:</span></p>
<p><span class=rvts11>How to use a selectKey In insert ?</span></p>
<p><br></p>
<p><span class=rvts11>-----Original Message-----</span></p>
<p><span class=rvts11>From:&nbsp;</span><a class=rvts12 href="mailto:larry.meadors@gmail.com">larry.meadors@gmail.com</a><span
class=rvts11>&nbsp;[mailto:</span><a class=rvts12 href="mailto:larry.meadors@gmail.com">larry.meadors@gmail.com</a><span
class=rvts11>&nbsp;] On Behalf</span></p>
<p><span class=rvts11>Of Larry Meadors</span></p>
<p><span class=rvts11>Sent: Friday, September 21, 2007 9:36 PM</span></p>
<p><span class=rvts11>To:&nbsp;</span><a class=rvts12 href="mailto:user-java@ibatis.apache.org">user-java@ibatis.apache.org</a></p>
<p><span class=rvts11>Subject: Re: insert always returning null (urgent )</span></p>
<p><br></p>
<p><span class=rvts11>The insert method does not return the inserted object, it
returns the</span></p>
<p><span class=rvts11>result of your selectKey element.</span></p>
<p><br></p>
<p><span class=rvts11>If you don't use a selectKey element, insert will return
null.</span></p>
<p><br></p>
<p><span class=rvts11>Larry</span></p>
<p><br></p>
<p><br></p>
<p><span class=rvts11>On 9/21/07, Yuvraj Shinde &lt;&nbsp;</span><a
class=rvts12 href="mailto:Yuvraj.Shinde@sos.sungard.com">Yuvraj.Shinde@sos.sungard.com</a><span
class=rvts11>&gt; wrote:</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; Hi all</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp;I am using insert query. it is always
returning a null value. how to&nbsp;</span></p>
<p><span class=rvts11>get</span></p>
<p><span class=rvts11>&gt; the value of inserted object?</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp;Following is mine insert statement</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &lt;insert id="LIMNAME_INSERT"</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>parameterClass=" com.sungard.energy.zainet.shared.business.domain.Limname</span></p>
<p><span class=rvts11>DTO"</span></p>
<p><span class=rvts11>&gt; &gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; insert into LIMNAME (AUDIT_ACTIVE,
AUDIT_AGEN, AUDIT_AOP0,</span></p>
<p><span class=rvts11>AUDIT_ADATE0,</span></p>
<p><span class=rvts11>&gt; AUDIT_ATIME0,</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; &nbsp; AUDIT_AOP1, AUDIT_ADATE1,
AUDIT_ATIME1, AUDIT_ALF, AUDIT_AOHM,&nbsp;</span></p>
<p><span class=rvts11>&gt; AUDIT_ROHM, AUDIT_REFRESH,</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; &nbsp; AUDIT_ZKEY, AUDIT_XKEY,
AUDIT_UTIL1, AUDIT_UTIL2, LIMNAME_NAME,</span></p>
<p><span class=rvts11>&gt; LIMNAME_DSC, LIMNAME_FILTER,</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; &nbsp; LIMNAME_FILTERA,
LIMNAME_FILTERB, LIMNAME_FILTERC,&nbsp;</span></p>
<p><span class=rvts11>LIMNAME_RUNVIEW)</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; values (#active:DECIMAL#,
#agen:DECIMAL#, #aop0:CHAR#,</span></p>
<p><span class=rvts11>&gt; #adate0:TIMESTAMP#,</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; &nbsp; #atime0:DECIMAL#,
#aop1:CHAR#, #adate1:TIMESTAMP#,</span></p>
<p><span class=rvts11>#atime1:DECIMAL#,</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; &nbsp; #alf:TIMESTAMP#,
#aohm:TIMESTAMP#, #rohm:TIMESTAMP#,</span></p>
<p><span class=rvts11>&gt; #refresh:DECIMAL#,</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; &nbsp; #zkey:DECIMAL#,
#xkey:DECIMAL#, #util1:DECIMAL#,</span></p>
<p><span class=rvts11>#util2:DECIMAL#,</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; &nbsp; #limnameName:VARCHAR#,
#limnameDsc:VARCHAR#,&nbsp;</span></p>
<p><span class=rvts11>#limnameFilter:VARCHAR#,</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; &nbsp; #limnameFiltera:VARCHAR#,
#limnameFilterb:VARCHAR#,</span></p>
<p><span class=rvts11>&gt; #limnameFilterc:VARCHAR#,</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &nbsp; &nbsp; #limnameRunview:CHAR#)</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp; &lt;/insert&gt;</span></p>
<p><span class=rvts11>&gt;&nbsp;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp;Regards</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; &nbsp;Yuvraj</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt; Yuvraj Shinde * Senior Software Engineer - &nbsp;Zainet*
&nbsp;SunGard *</span></p>
<p><span class=rvts11>Offshore</span></p>
<p><span class=rvts11>&gt; Services * Pride Portal,CTS No 103A/5A/1A/1B Bhamburda,Senapati
Bapat&nbsp;</span></p>
<p><span class=rvts11>Road,</span></p>
<p><span class=rvts11>&gt; shivajinagar,Pune 411016 Tel Direct +91 20 66248045
* Main +91 20</span></p>
<p><span class=rvts11>66248000 *</span></p>
<p><span class=rvts11>&gt; Fax +91 20 &nbsp;25606222&nbsp;</span><a
class=rvts12 href="mailto:Yuvraj.Shinde@sos.sungard.com">yuvraj.shinde@sos.sungard.com</a><span
class=rvts11>&nbsp;*&nbsp;</span><a class=rvts12 href="http://www.sungard.com">www.sungard.com</a></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><span class=rvts11>&gt;</span></p>
<p><br></p>
<p><span class=rvts11>&nbsp;</span></p>
</td>
</tr>
</table>
</div>
<p><br></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p>/Gwyn</p>

</body></html>


Mime
View raw message