Hello Felipe, the generated SQL statement looks ok, isn't it? Frankly, I don't know what causes this error.
You could try 3.2.2. AFAIK, the only difference is generated SQL in 3.2.2 uses SELECT SCOPE_IDENTITY() instead of SELECT @@IDENTITY. I am not sure if it will help. alex Friday, June 27, 2003, 10:32:38 PM, Felipe Oliveira wrote: FO> hi, FO> i am using org.jboss.ejb.plugins.cmp.jdbc.mssql.JDBCMsSQLCreateCommand FO> and i am getting the following error. the pk-field is paymentId that FO> correctly is no being passed on the sql statement. it seems like i am a FO> procedure is trying to be called instead of the raw sql. i am running FO> jboss 3.2.1. FO> 14:56:55,243 DEBUG [JDBCMsSQLCreateCommand] Executing SQL: INSERT INTO FO> Payments FO> (accountType, accountId, amount, paidDate, orderId, commission, FO> transactionFee, FO> processorId) VALUES (?, ?, ?, ?, ?, ?, ?, ?);SELECT @@IDENTITY FO> 14:56:55,286 ERROR [JDBCMsSQLCreateCommand] Could not create entity FO> java.sql.SQLException: Could not find stored procedure 'INSERT'. FO> any ideas? FO> thank you, FO> felipe ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
