<div dir="ltr">Thank you, Daniel, <div><br></div><div>First time, I tried to add _psParameter2Insert right after _psParameterInsert as I emailed to the community (below). </div><div>but, I still have an error message; <span style="color:rgb(80,0,80)">unknown column in 'field...</span><br></div><div><span style="color:rgb(80,0,80)"><br></span></div><div>parameter2 table (_psParameter2Insert) has five fields while parameter table (_psParameterInsert) has three fields. </div><div>once it reaches the fourth field, it has unknown column in field.. error message. </div><div><br></div><div>Now I am trying to implement _regParameter2Real which is the same as _regParameterReal. </div><div>I followed _psParameterInsert for _psParameter2Insert. I also added some code for "_psParameter2Insert" in _createPreparedStatements(). <br></div><div>so once the program calls _regParameterReal, then the program also calls _regParameter2Real . </div><div>This solution seems like partial solution. it only works when regParameter in SQLRecording.java works. the other case, when regParameter in SQLRecording.java calls, it is still the same error (i.e., unknown column error).</div><div><br></div><div>Do you have any thing that I should consider for using multiple PreparedStatements in the same method like below code?<br></div><div><br></div><div>Thank you </div><div><br></div><div>-Donghoon</div><div><br></div><div><br></div><div><span style="color:rgb(80,0,80)"><br></span></div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 12, 2014 at 12:38 PM, Daniel Crawl <span dir="ltr"><<a href="mailto:danielcrawl@gmail.com" target="_blank">danielcrawl@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><br>
Hi Donghoon,<br>
<br>
How did you create _psParameter2Insert? You can look at<br>
_createPreparedStatements() for examples.<br>
<br>
--dan<div><div><br>
<br>
On 11/11/14 7:27 PM, DONGHOON KIM wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div>
Dear Kepler folks,<br>
<br>
I need to add one more table (e.g., parameter2) in Provenance database.<br>
parameter2 table should have parameter information with different<br>
properties. In other words, it includes some other information that<br>
parameter table does not have.<br>
so I am try to use _regparamterReal(Name obj, RegEntity re) because this<br>
method add parameter information into parameter table.<br>
so I tried to add parameter2 table. but I have a error message; unknown<br>
column in 'field list'<br>
My question is how can I insert another table (i.e., parameter2) from<br>
parameter table. I think the problem is that I should switch or initialize<br>
for _psParameter2Insert for "PreparedStatement".<br>
Below is the code in "org.kepler.provenance.sql.<u></u>SQLRecording.java". Also<br>
you can find where the error happens below.<br>
<br>
line number around 1728<br>
<br>
/** Add an entity to the parameter table. */<br>
protected void _regParameterReal(NamedObj parameter, RegEntity re)<br>
throws RecordingException<br>
{<br>
String className = parameter.getClassName();<br>
String valueStr = "none";<br>
<br>
<br>
<br>
<br>
<br>
try //_psParameterInsert<br>
{<br>
synchronized(_<u></u>psParameterInsert)<br>
{<br>
//_debug("going to insert parameter " +<br>
_getNameableFullName(<u></u>parameter) + " with id " + re.getId());<br>
<br>
_psParameterInsert.setInt(1, re.getId());<br>
_psParameterInsert.setString(<u></u>2, className);<br>
<br>
<br>
if(parameter instanceof AbstractSettableAttribute)<br>
{<br>
valueStr = ((AbstractSettableAttribute)<u></u>parameter).<br>
getValueAsString();<br>
}<br>
<br>
// replace null string with empty string.<br>
if(valueStr == null)<br>
{<br>
valueStr = "";<br>
}<br>
<br>
//_debug(_getNameableFullName(<u></u>parameter) + " value length =<br>
" + valueStr.length());<br>
<br>
// XXX need to set truncated bit somewhere<br>
if(valueStr.length() > _maxParameterValueSize)<br>
{<br>
//_debug("TRUNCATING!");<br>
valueStr = valueStr.substring(0,<br>
_maxParameterValueSize);<br>
}<br>
<br>
<br>
<br>
_psParameterInsert.setString(<u></u>3, valueStr);<br>
<br>
_psParameterInsert.<u></u>executeUpdate();<br>
<br>
/*********** added by Donghoon<br>
_psParameter2Insert.setInt(1, re.getId());<br>
_psParameter2Insert.setString(<u></u>2, className);<br>
_psParameter2Insert.setString(<u></u>3, valueStr);<br>
<br>
//==>>>>error message this line ; unknown column in 'field<br>
list' <<<===============<br>
_psParameter2Insert.setString(<u></u>4, valueStr);<br>
<br>
_psParameter2Insert.<u></u>executeUpdate();<br>
<br>
<br>
}<br>
<br>
<br>
<br>
<br></div></div>
______________________________<u></u>_________________<br>
Kepler-dev mailing list<br>
<a href="mailto:Kepler-dev@kepler-project.org" target="_blank">Kepler-dev@kepler-project.org</a><br>
<a href="http://lists.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-dev" target="_blank">http://lists.nceas.ucsb.edu/<u></u>kepler/mailman/listinfo/<u></u>kepler-dev</a><br>
<br>
</blockquote>
<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div>Donghoon Kim<br>Dept of Computer Science<br>North Carolina State University<br><br><br></div>
</div></div>