cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tobias SCHOESSLER <tobias.schoess...@unodc.org>
Subject Re: how to get update/insert SQL without committing to db
Date Thu, 21 Feb 2008 15:49:14 GMT

<br><font size=2 face="sans-serif">Hi Andrus, I did in fact forget about
that. </font>
<br>
<br><font size=2 face="sans-serif">I was looking for an easy way to recreate
parts of the object network to transfer between stages of our application.
E.g. create SQL for a data set to insert it in the development db for testing.
&nbsp;</font>
<br>
<br><font size=2 face="sans-serif">Tobias<br>
</font>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>Andrus Adamchik &lt;andrus@objectstyle.org&gt;</b>
</font>
<p><font size=1 face="sans-serif">Thursday, 21 February 2008 14:38</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
user@cayenne.apache.org</font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">user@cayenne.apache.org</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">Re: how to get update/insert SQL without
committing to db</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><tt><font size=2>Hi Tobias,<br>
<br>
Could you elaborate a bit on how are you going to use this SQL? SQL &nbsp;<br>
generated by Cayenne is in a PreparedStatement format, so it will not &nbsp;<br>
be usable for say manual execution from a SQL client.<br>
<br>
Andrus<br>
<br>
<br>
<br>
On Feb 21, 2008, at 2:55 PM, Tobias SCHOESSLER wrote:<br>
&gt; Hi,<br>
&gt;<br>
&gt; is there a way to get the update/insert SQL statements ( e.g. as a
&nbsp;<br>
&gt; String ) that cayenne would execute with a commit, &nbsp;without actually
&nbsp;<br>
&gt; committing to the db?<br>
&gt;<br>
&gt; thank you<br>
&gt;<br>
&gt; Tobias<br>
<br>
</font></tt>
<br>

Mime
View raw message