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!
