Re: updating using SQL ansi & udfs
On Mon, 1 Sep 2003, Roland Carlsson wrote: > Why should you use sql when OJB handles the situation without any problem? > http://db.apache.org/ojb/tutorial1.html scroll down to "Updating Objects". > > From: "Jason Pyeron" <[EMAIL PROTECTED]> > Sent: Sunday, August 31, 2003 10:31 PM > > > UPDATE table_name SET date_col=NOW() WHERE id=###; > > > > How should this be done under OJB? my question was how can I use UDF's and other functions which the results are not able to be generated by the VM or any code running on it. IE: obj.setName("bob smith"); obj.setSpecialField(new SQLInline("MyUDF()")); does anyone even know how to do this through update-able result-sets? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron http://www.pyerotechnics.com - - Partner & Sr. Manager Pyerotechnics Development, Inc. - - 500 West University Parkway #1S - - +1 (410) 808-6646 Baltimore, Maryland 21210-3253 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: updating using SQL ansi & udfs
Why should you use sql when OJB handles the situation without any problem? http://db.apache.org/ojb/tutorial1.html scroll down to "Updating Objects". Regards Roland Carlsson - Original Message - From: "Jason Pyeron" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Sunday, August 31, 2003 10:31 PM Subject: updating using SQL ansi & udfs > To the list: > > If I could do a SQL update of the like: > > UPDATE table_name SET date_col=NOW() WHERE id=###; > > How should this be done under OJB? > > > Sincerely, > > Jason Pyeron > > -- > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > - - > - Jason Pyeron http://www.pyerotechnics.com - > - Partner & Sr. Manager Pyerotechnics Development, Inc. - > - 500 West University Parkway #1S - > - +1 (410) 808-6646 Baltimore, Maryland 21210-3253 - > - - > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > This message is for the designated recipient only and may contain > privileged, proprietary, or otherwise private information. If you > have received it in error, purge the message from your system and > notify the sender immediately. Any other use of the email by you > is prohibited. > > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]