Re: iBATIS 3 for Java Released (BETA 1)

2009-08-13 Thread Fred Janon
t since the answer is so > simple: > > > > For some databases you might also have to use autocommit. > > See the user guide for more. > > Clinton > > > On Thu, Aug 13, 2009 at 8:44 AM, Fred Janon wrote: > >> Is there a way to execute a sql statement other than se

Re: iBATIS 3 for Java Released (BETA 1)

2009-08-13 Thread Fred Janon
might also have to use autocommit. > > See the user guide for more. > > Clinton > > > On Thu, Aug 13, 2009 at 8:44 AM, Fred Janon wrote: > >> Is there a way to execute a sql statement other than select/insert/update, >> like to create or alter a table? I thoug

Re: iBATIS 3 for Java Released (BETA 1)

2009-08-13 Thread Fred Janon
e readable and logically structured and > searchable. If you read it, you'll see that JavaDocs wouldn't offer much > more... > > I had time to write it, so you have time to read it. :-) > > Clinton > > > On Thu, Aug 13, 2009 at 8:42 AM, Fred Janon wrote: > >

Re: iBATIS 3 for Java Released (BETA 1)

2009-08-13 Thread Fred Janon
cluster. You should check network connections between cluster nodes, especially multicast traffic. Fred On Thu, Aug 13, 2009 at 22:44, Fred Janon wrote: > Is there a way to execute a sql statement other than select/insert/update, > like to create or alter a table? I thought there was an elem

Re: iBATIS 3 for Java Released (BETA 1)

2009-08-13 Thread Fred Janon
Is there a way to execute a sql statement other than select/insert/update, like to create or alter a table? I thought there was an element in iBatis before? Thanks Fred > > 2009/8/8 Nathan Maves > >> A month ago iBATIS turned 7 years old, and while we're celebrating a >> l

Re: iBATIS 3 for Java Released (BETA 1)

2009-08-13 Thread Fred Janon
bably add them > when they find some time. > > I would like to get an updated JPetStore example, but I'm out of time right > now. Perhaps before the first GA release. Or... someone from the community > can do it. > > Clinton > > > On Thu, Aug 13, 2009 at 2:39 AM

Re: iBATIS 3 for Java Released (BETA 1)

2009-08-13 Thread Fred Janon
Are there several "docs"? I can see only the "User' Guide" on the main page. No javadoc? I presume the javadoc link on the main page of the web site is still the one for the previous version? Is there any full example, like a java example? I didn't find any in the download (jar or src). Thanks Fr

Re: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-02 Thread Fred Janon
s it can return a XML string > object; > > > > http://www.mail-archive.com/user-java@ibatis.apache.org/msg13636 > > > > > > > > Just a note, the XML returned from ibatis is quite limited, I personally > use > > XStream to serialize java beans to XML (or JSO

Re: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-02 Thread Fred Janon
, or $id$ and $description$ if you want to do a literary > replacement. > > > > > > *From:* Fred Janon [mailto:fja...@gmail.com] > *Sent:* 02 July 2009 05:59 AM > *To:* user-java@ibatis.apache.org > *Subject:* queryForObject/queryForList where is the documentation for the > &quo

queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-01 Thread Fred Janon
Sorry for the basic question: how to write a query with mutiple parameters? I am reading the iBatis in Action book, browsing the distribution, the wiki, the Javadoc and I can't find documentation or examples for the different forms of the parameter for queryForObject or queryForList SqlMapExecutor

Re: iBatis 3 roadmap

2009-02-26 Thread Fred Janon
Is there some documentation for the new Dynamic SQL? Is there an ETA for that specific feature? I would like to use iBatis for a new project but I would rather use iBatis 3 than 2 if Dynamic SQL is not too far away. Thanks Fred 2009/2/9 Clinton Begin > Hi Jan, > > Let me address a few of your

JavaScript + iBATIS

2006-09-24 Thread Fred Janon
Hi Clinton, I am very interested in seeing what you did with JavaScript & iBATIS. I am working on a Javascript framework and iBatis seems an appealing option to do the peristence part of it Fred --- Clinton Begin <[EMAIL PROTECTED]> wrote: > Hi there, > > I don't have any plans. But I just di

In the news: iBatis use at Javalobby...

2006-08-10 Thread Fred Janon
iBatis is in the news http://www.javalobby.org/nl/archive/jlnews_20060808o.html On Hibernate vs. iBatis (one more time!) Since we built and deployed dzone.com back in June, I’ve had several people IM or email me asking about the infrastructure and why we chose

Re: SQL DELETE

2006-08-07 Thread Fred Janon
That said, is there a way in iBatis to mimic a CASCADE DELETE by executing several SQL statements in an iBatis SQL Map? Like selected the elements in the child table with the FK of the master table and deleting the selected child rows? The documentation says that we can even put several SQL statem

Re-Post:: Same Connection Guaranteed during a Transaction?

2006-07-30 Thread Fred Janon
turns 0. I have 2 mapped statements in my XML maps, one to do the insert and one to do the last_insert_id(). I need to find a way to execute them in the same connection. I tried to include the 2 stements in a transaction but they are still executed in 2 connections. Thanks, Fred --- Fred Jan

Re: Same Connection Guaranteed during a Transaction?

2006-07-24 Thread Fred Janon
I am using iBatis v1 not v2, there is no in V1... Larry Meadors wrote: Why not just use a selectKey element? Larry On 7/24/06, Fred Janon <[EMAIL PROTECTED]> wrote: I am trying to get the last_insert_id() in mySQL after an insert. I read in a forum that during a transaction, th

Same Connection Guaranteed during a Transaction?

2006-07-24 Thread Fred Janon
I am trying to get the last_insert_id() in mySQL after an insert. I read in a forum that during a transaction, the same connection was guaranteed to be used for the duration of the transaction. That's not my experience using Spring and iBatis 1.3.1. Using the code below, I get 2 different conne

Javadocs for iBatis 1.3.1 or 1.x.x?

2006-07-23 Thread Fred Janon
I can't find the javadocs for v1. I got a couple of pdfsbut no javadocs. The javadocs for 2.0 are in the zip file but not in 1.3.1. I looked in the wiki, no trace of them. Do they exist? Thanks Fred begin:vcard fn:fjanon n:Janon;Fred email;internet:[EMAIL PROTECTED] title:Sr S/W Engineer & A

Re: Mapped statement with chained queries ?

2006-07-21 Thread Fred Janon
trips. Whatever you need to specify in #value# of 2nd and 3rd statement is taken from the "column" attribute. In this case jobId for 2nd select and "clientId" for the 3rd select. On 7/21/06, *Fred Janon* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

Re: Mapped statement with chained queries ?

2006-07-21 Thread Fred Janon
" attribute. In this case jobId for 2nd select and "clientId" for the 3rd select. On 7/21/06, *Fred Janon* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Hi, I have 3 tables: Tasks: taskid int PK jobid int FK description String Jobs

Mapped statement with chained queries ?

2006-07-21 Thread Fred Janon
Hi, I have 3 tables: Tasks: taskid int PK jobid int FK description String Jobs: jobid PK clientid int FK Clients: clientid PK clientname String. How can I get the Clients:clientname via the Jobs table starting from a taskid? I know how to do it with 1 level on "indirection" but I don't know

Re: How to use a function on a parameter in an "update" mapped statement?

2006-07-12 Thread Fred Janon
th DB2 on the AS400/iSeries/i5. Check out the last entry on http://opensource.atlassian.com/confluence/oss/display/IBATIS/Environment+Specific+Information Ted On 08/07/06, Fred Janon <[EMAIL PROTECTED]> wrote: Hi, I want to convert a string containing a date in the format dd/month/year into a mySQL date f

How to use a function on a parameter in an "update" mapped statement?

2006-07-08 Thread Fred Janon
Hi, I want to convert a string containing a date in the format dd/month/year into a mySQL date format (/mm/dd) in an update statement. I tried: update jobs set clientid=#clientId#, summary=#summary#, jobduedate=str_to_date(#dueDate#, '%d/%m/%Y') where jobid=#id#