Re: Autocommit not properly handled in Ibatis.

2007-01-23 Thread Cornel Antohi
Hi Clinton and Richard, My mistake ... I better understand the meaning of "iBATIS never uses AutoCommit" now. May I ask you if iBATIS uses commit() or rollback() in case of a single SELECT statement? If not, the spec says: "Otherwise, its SQL statements are grouped into transactions that are

RE: Problem with Mapping Boolean to Bit(MSSql)

2007-01-23 Thread Hofri Yehuda
Good luck with that... -Original Message- From: Martin Ewald [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 5:36 PM To: user-java@ibatis.apache.org Subject: RE: Problem with Mapping Boolean to Bit(MSSql) Unfortunately i must use Java 1.4 :( Cast? i think you misunderstood m

Re: Autocommit not properly handled in Ibatis.

2007-01-23 Thread Koka Kiknadze
iBATIS always commits or rolls back transactions explicitly with commit() and rollback(). Clinton IJust to spare someone's time I'd like to add that it is only true if 1. Threre were some insert/update/delete or procedure calls after startTransaction() OR 2. The forceCommit (commitRequired

Abator tool extension

2007-01-23 Thread Francois LE ROLLAND
Hi, I'm wondering if it could be possible to add the column names as constant in the generated Java Model. I've tried something like that In the class JavaModelGeneratorJava2Impl and it works fine for me : // FLD Field constant; Method method;

Re: Abator tool extension

2007-01-23 Thread Jeff Butler
Hi Francois, This seems like something that is pretty specific to your needs. I think the best way to handle this would be to write a "hook" into Abator to do this. The version of Abator in SVN includes new methods on all generators that allow you to add to the generated classes. For example,

Pass a integer type of array to the stored procedure

2007-01-23 Thread Gaurav Goel
-- Forwarded message -- From: Gaurav Goel <[EMAIL PROTECTED]> Date: Jan 23, 2007 10:58 PM Subject: Pass a integer type of array to the stored procedure To: [EMAIL PROTECTED] Hi, I am new to this technology. I have a requirement wherein i have to pass an integer type of array to th

Re: Pass a integer type of array to the stored procedure

2007-01-23 Thread c . zecca
[...] > I have a requirement wherein i have to > pass an integer type of array to the oracle stored procedure which i > am calling from ibatis. How can this be achieved. Do i need to use > typeHandler for this? Or it can be done without that? > > Please help me. Many thanks in advance. Oracle JDB

Re: Complex properties and substitution strings parameter problem (updated)

2007-01-23 Thread Brandon Goodin
There is no way to pass the properties along from the parameter object to a nested select. Is it a requirement that you pass the schema name in for each select? Or could you simply set the schema name globally using a properties file and property replacement notation ${schema}. If that is not an

Re: Odd behavior with CGLIB (lazy loading problem)

2007-01-23 Thread Paul Benedict
Clinton, I have a working example that I can email to you if you're interested. Can I email it? Here's a clearer explanation of what Niels and I are experiencing: I have two classes: A which holds an instance of B. I have enhanced lazy loading turned on and I query for A with B being lazily

Inline Parameter Mapping - Update Statement

2007-01-23 Thread jaybytez
The documentation shows these advanced properties for inline parameter mapping: #propertyName,javaType=?,jdbcType=?,mode=?,nullValue=?,handler=?,numericScale=?# That is fine for syntax like an insert statement, but for an update statementwhere we need to say columnName = value...how do I do

Re: Inline Parameter Mapping - Update Statement

2007-01-23 Thread jaybytez
I found this example in the .Net documentation: update Accounts set Account_FirstName = #FirstName#, Account_LastName = #LastName#, Account_Email = #EmailAddress,type=string,dbType=Varchar,[EMAIL PROTECTED] where Account_ID = #Id# Thanks, jay -- View this message in context: http://ww

[Table field names VS. Object properties names]

2007-01-23 Thread Carlos Cajina
Hi! I have a question regarding the implementation of the N+1 solution. Couldn't find any reference in the mailing list/docs, so here's the thing: Preconditions: 1. Using iBATIS version 2.3.0.677 2. Applied the N+1 solution to a One-to-Many tables relationship Problem details: 1. table_b refe