sirmak | 3 Aug 13:32 2009
Picon

ibatis 3.0


Hi,

We want to start our new project with the newest technology, there is no
problem if it's in alpha phase, is there any documentation, guide, article,
etc... for ibatis 3.0 ?

cheers
--

-- 
View this message in context: http://www.nabble.com/ibatis-3.0-tp24789192p24789192.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Clinton Begin | 3 Aug 17:42 2009
Picon

Re: ibatis 3.0

I'll put it all up by the end of the day.  The docs need some
thickening up, but are broadly complete.

Clinton

On 2009-08-03, sirmak <irmakserdar <at> gmail.com> wrote:
>
> Hi,
>
> We want to start our new project with the newest technology, there is no
> problem if it's in alpha phase, is there any documentation, guide, article,
> etc... for ibatis 3.0 ?
>
>
>
> cheers
> --
> View this message in context:
> http://www.nabble.com/ibatis-3.0-tp24789192p24789192.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
> For additional commands, e-mail: user-java-help <at> ibatis.apache.org
>
>

--

-- 
Sent from my mobile device
(Continue reading)

sirmak | 3 Aug 18:49 2009
Picon

Re: ibatis 3.0


Thanks a lot Clinton, you're very kind.

Cheers,
sirmak

Clinton Begin wrote:
> 
> I'll put it all up by the end of the day.  The docs need some
> thickening up, but are broadly complete.
> 
> Clinton
> 
> On 2009-08-03, sirmak <irmakserdar <at> gmail.com> wrote:
>>
>> Hi,
>>
>> We want to start our new project with the newest technology, there is no
>> problem if it's in alpha phase, is there any documentation, guide,
>> article,
>> etc... for ibatis 3.0 ?
>>
>>
>>
>> cheers
>> --
>> View this message in context:
>> http://www.nabble.com/ibatis-3.0-tp24789192p24789192.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
(Continue reading)

Ing. Jan Novotný | 3 Aug 21:50 2009
Picon

Re: ibatis 3.0

I think there are many people starving for release of iBatis 3.0 - including me. Clinton, thanks for your work - we'll be happy to beta test it. iBatis 2.x is very good, but after all these years we all know it could have been even better.

Best regards,
Jan

2009/8/3 sirmak <irmakserdar <at> gmail.com>

Thanks a lot Clinton, you're very kind.

Cheers,
sirmak


Clinton Begin wrote:
>
> I'll put it all up by the end of the day.  The docs need some
> thickening up, but are broadly complete.
>
> Clinton
>
> On 2009-08-03, sirmak <irmakserdar <at> gmail.com> wrote:
>>
>> Hi,
>>
>> We want to start our new project with the newest technology, there is no
>> problem if it's in alpha phase, is there any documentation, guide,
>> article,
>> etc... for ibatis 3.0 ?
>>
>>
>>
>> cheers
>> --
>> View this message in context:
>> http://www.nabble.com/ibatis-3.0-tp24789192p24789192.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
>> For additional commands, e-mail: user-java-help <at> ibatis.apache.org
>>
>>
>
> --
> Sent from my mobile device
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
> For additional commands, e-mail: user-java-help <at> ibatis.apache.org
>
>
>

--
View this message in context: http://www.nabble.com/ibatis-3.0-tp24789192p24794172.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: user-java-help <at> ibatis.apache.org




--
--------------------------------------------------------------
Ing. Jan Novotný
<at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at> <at>
http://blog.novoj.net
Myšlenky dne otce Fura
--------------------------------------------------------------
CuriousMind | 4 Aug 06:48 2009
Picon

PL/SQL package level variables


Hi,

I am having 3 procedures which i want to call using IBatis framework. These
procedure are using package level variables and hence when I try to call
them, it ends up throwing error as the package variable value is not found.
Consider following scenario for more details
Package level variable = varPK
Procedure 1 sets varPK (Package level variable) to "SomeValue"
Procedure 2 tries to check value of varPK and finds that it is empty.

I know this could be resolved by writing wrapper procedure which will call
above listed procedure in sequence but I am looking for better solution. The
problem is that I am migrating existing application to Ibatis framework and
hence it is not possible to find out where such scenarios would come.
The error that I am facing is probably due to for every call to iBatis API
gets different connection object (I am using connection pool and spring
integration with ibatis.). I think this can be resolved only if current
thread will get same connection instance. Is there any way to ensure that
the current thread will always receive same connection instance?
--

-- 
View this message in context: http://www.nabble.com/PL-SQL-package-level-variables-tp24802267p24802267.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Stephen Scheck | 4 Aug 06:54 2009
Picon

Positional Parameters

Can iBATIS support simple positional parameters for inserts? I want to do something like:

<sqlMap namespace="MyObject">
  <insert id="PERSIST">
    INSERT INTO my_table (f1, f2, f3) VALUES (?, ?, ?)
  </insert>
</sqlMap>

executor.startBatch();
for (int objNum = 0; objNum < MAX_OBJ_NUM; objNum++) {
    Object[] args = new Object[] {
        objNum,
        val1,
  & nbsp;     val2
    };

    executor.insert("PERSIST", args);
}

executor.executeBatch();
// etc

In the real case that I'm trying to implement, my fields come from several sources and I'd
prefer to avoid creating an inner class just to make the data conform to a JavaBean.

Thanks.


CuriousMind | 4 Aug 06:57 2009
Picon

Nested result maps


Hi,

I am having strange problem with resultmap. Consider following scenario
<resultMap id="map1" class="com.mycode.ClassOne">
<result property="prop1" column="dbcol1"/>
<result property="prop2" column="dbcol2"/>
</resultMap>

<resultMap id="map2" class="com.mycode.ClassTwo">
<result property="propForMap" resultMap="map1"/>
</resultMap>

<resultMap id="map3" class="com.mycode.ClassThree">
<result property="someProperty" column="dbcol3"/>
<result property="moreProperty" column="dbcol4"/>
<result property="additionalProp" resultMap="map2"/>
</resultMap>

The last resultMap is mapped with output map of cursor returned by
procedure.
After calling ibatis api to execute procedure, I found that properties for
map3 (someProperty, moreProperty) is initialised but additionalProp is
unitialised. I have checked that all the properties are mapped properly.
To add to surprise, if I change definition of map2 to following it works.
<resultMap id="map2" class="com.mycode.ClassTwo">
<result property="useLessProperty" column="someColumn"/>
<result property="propForMap" resultMap="map1"/>
</resultMap>

If I add one more result tag to map2 it works fine, I couldnt understand why
iBatis is not able to resolve map2 when it has only one nested map.
--

-- 
View this message in context: http://www.nabble.com/Nested-result-maps-tp24802326p24802326.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Nicholoz Koka Kiknadze | 4 Aug 07:29 2009
Picon

Re: PL/SQL package level variables

You are quite right. Your problem is that calls to those two procedures are not in a single transaction. Include them in a single transaction and proc2 will see package level variables set in proc1. Note that executing those procs on a single connection object is not enough (i.e. you need transaction).

hth

On Tue, Aug 4, 2009 at 8:48 AM, CuriousMind <yogeshcjadhav <at> hotmail.com> wrote:

Hi,

I am having 3 procedures which i want to call using IBatis framework. These
procedure are using package level variables and hence when I try to call
them, it ends up throwing error as the package variable value is not found.
Consider following scenario for more details
Package level variable = varPK
Procedure 1 sets varPK (Package level variable) to "SomeValue"
Procedure 2 tries to check value of varPK and finds that it is empty.

I know this could be resolved by writing wrapper procedure which will call
above listed procedure in sequence but I am looking for better solution. The
problem is that I am migrating existing application to Ibatis framework and
hence it is not possible to find out where such scenarios would come.
The error that I am facing is probably due to for every call to iBatis API
gets different connection object (I am using connection pool and spring
integration with ibatis.). I think this can be resolved only if current
thread will get same connection instance. Is there any way to ensure that
the current thread will always receive same connection instance?
--
View this message in context: http://www.nabble.com/PL-SQL-package-level-variables-tp24802267p24802267.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: user-java-help <at> ibatis.apache.org


Sheile | 4 Aug 07:32 2009
Picon

Re: Positional Parameters

Hi.

One of solution is this:

<sqlMap namespace="MyObject">
  <insert id="PERSIST" parameterClass="List">
    INSERT INTO my_table (f1, f2, f3) VALUES
    <iterate open="(" close=")" conjunction=",">
        #[]#
    </iterate>
  </insert>
</sqlMap>

Above solution use java.util.List, I don't know that how to use the Object[].

2009/8/4 Stephen Scheck <steves619 <at> yahoo.com>:
> Can iBATIS support simple positional parameters for inserts? I want to do
> something like:
>
> <sqlMap namespace="MyObject">
>   <insert id="PERSIST">
>     INSERT INTO my_table (f1, f2, f3) VALUES (?, ?, ?)
>   </insert>
> </sqlMap>
>
> executor.startBatch();
> for (int objNum = 0; objNum < MAX_OBJ_NUM; objNum++) {
>     Object[] args = new Object[] {
>         objNum,
>         val1,
>         val2
>     };
>
>     executor.insert("PERSIST", args);
> }
>
> executor.executeBatch();
> // etc
>
> In the real case that I'm trying to implement, my fields come from several
> sources and I'd
> prefer to avoid creating an inner class just to make the data conform to a
> JavaBean.
>
> Thanks.
>
>
>
CuriousMind | 4 Aug 07:44 2009
Picon

Re: PL/SQL package level variables


Hi Nichol,

Thanks for your response. We are already using same transaction while
calling these procedures.
But we are not getting expected results.

Nicholoz Koka Kiknadze wrote:
> 
> You are quite right. Your problem is that calls to those two procedures
> are
> not in a single transaction. Include them in a single transaction and
> proc2
> will see package level variables set in proc1. Note that executing those
> procs on a single connection object is not enough (i.e. you need
> transaction).
> 
> hth
> 
> On Tue, Aug 4, 2009 at 8:48 AM, CuriousMind
> <yogeshcjadhav <at> hotmail.com>wrote:
> 

--

-- 
View this message in context: http://www.nabble.com/PL-SQL-package-level-variables-tp24802267p24802615.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Gmane