You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by Support <su...@wallabys.biz> on 2006/07/29 15:21:26 UTC

SQL Statement: Console App...works great, Web App...properties not parsed

Have an SQL statement as follows:

        <insert id="InsertCustomer" parameterClass="Customer" 
parameterMap="InsertCustomerParameters">
            INSERT INTO [Customer]
            (
                
FIRST_NAME,LAST_NAME,EMAIL,POSTAL_CODE,GENDER,AGE,RECEIVE_EMAIL,NONCE,
                CREATE_DATE,LAST_MODIFIED
            )
            VALUES
            (
                #FirstName#, #LastName#, #Email#, #PostalCode#, 
#Gender#, #Age#,
                #ReceiveEmail#, #Nonce#, CURRENT_TIMESTAMP, 
CURRENT_TIMESTAMP
            )
            <selectKey resultClass="int" type="post" property="Id" >
                select @@IDENTITY as value
            </selectKey>
        </insert>


When I use this statement in a console app it works great. When I use it 
in a web app, the statement isn't parsing. The following appears in the 
log file:

2006-07-29 08:08:09,057 [3928] DEBUG 
IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - 
Statement Id: [InsertCustomer] PreparedStatement : [INSERT INTO 
[Customer]      (      
FIRST_NAME,LAST_NAME,EMAIL,POSTAL_CODE,GENDER,AGE,RECEIVE_EMAIL,NONCE,      
CREATE_DATE,LAST_MODIFIED     )     VALUES     (      #FirstName#, 
#LastName#, #Email#, #PostalCode#, #Gender#, #Age#,       
#ReceiveEmail#, #Nonce#, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP     )]


So it appears that the properties aren't parsing (i.e., should be 
@param1, etc.).

Have attempted pattern my config as closely as possible to what is found 
in the user docs. Am curious as to why I get different behavior between 
my test console application and my super-duper web application, although 
I am the exact same configuration files and iBatisNet assemblies for both.

Any ideas or pointers as to where I should investigate?

P.S. iBatisNet has restored my faith in open source on .NET; Java had me 
spoiled. Excellent work!

Re: SQL Statement: Console App...works great, Web App...properties not parsed

Posted by Ron Grabowski <ro...@yahoo.com>.
Hrmmm, that's very strange. What version of IBatisNet are you using?
Are you able to make a very small test application and post a .zip of
it somewhere or email it to me directly?

--- Support <su...@wallabys.biz> wrote:

> Have an SQL statement as follows:
> 
>         <insert id="InsertCustomer" parameterClass="Customer" 
> parameterMap="InsertCustomerParameters">
>             INSERT INTO [Customer]
>             (
>                 
>
FIRST_NAME,LAST_NAME,EMAIL,POSTAL_CODE,GENDER,AGE,RECEIVE_EMAIL,NONCE,
>                 CREATE_DATE,LAST_MODIFIED
>             )
>             VALUES
>             (
>                 #FirstName#, #LastName#, #Email#, #PostalCode#, 
> #Gender#, #Age#,
>                 #ReceiveEmail#, #Nonce#, CURRENT_TIMESTAMP, 
> CURRENT_TIMESTAMP
>             )
>             <selectKey resultClass="int" type="post" property="Id" >
>                 select @@IDENTITY as value
>             </selectKey>
>         </insert>
> 
> 
> When I use this statement in a console app it works great. When I use
> it 
> in a web app, the statement isn't parsing. The following appears in
> the 
> log file:
> 
> 2006-07-29 08:08:09,057 [3928] DEBUG 
> IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - 
> Statement Id: [InsertCustomer] PreparedStatement : [INSERT INTO 
> [Customer]      (      
>
FIRST_NAME,LAST_NAME,EMAIL,POSTAL_CODE,GENDER,AGE,RECEIVE_EMAIL,NONCE,
>      
> CREATE_DATE,LAST_MODIFIED     )     VALUES     (      #FirstName#, 
> #LastName#, #Email#, #PostalCode#, #Gender#, #Age#,       
> #ReceiveEmail#, #Nonce#, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP     )]
> 
> 
> So it appears that the properties aren't parsing (i.e., should be 
> @param1, etc.).
> 
> Have attempted pattern my config as closely as possible to what is
> found 
> in the user docs. Am curious as to why I get different behavior
> between 
> my test console application and my super-duper web application,
> although 
> I am the exact same configuration files and iBatisNet assemblies for
> both.
> 
> Any ideas or pointers as to where I should investigate?
> 
> P.S. iBatisNet has restored my faith in open source on .NET; Java had
> me 
> spoiled. Excellent work!
>