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!
>