There is no mssql command in 3.2.0;
In 3.2.1 I can see
org.jboss.ejb.plugins.cmp.jdbc.mssql.JDBCMsSQLCreateCommand.java but it is not in standardjbosscmp-jdbc.xml. Here are the comments for it:
/**
* JDBCMsSQLCreateCommand executes an <code>INSERT INTO</code> SQL statement
* using the Microsoft SQL Server <code>SELECT @@IDENTITY</code> method to fetch
* the database-generated of the primary key.
* <p>
* Based on the Microsoft Knowledge Base article
* <a href="http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b313130">313130</a>.
* </p>
*
* @author <a href="mailto:[EMAIL PROTECTED]">David Green</a>
I believe you can use it declaring entity-command.
In 3.2.2, it turned into
org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCSQLServerCreateCommand
and appeared in standardjbosscmp-jdbc.xml as
<!-- retrieves generated key of the record inserted into SQLServer db -->
<entity-command name="mssql-fetch-key"
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCSQLServerCreateCommand"> <!-- uncomment for versions prior to SQL Server 2000 <attribute name="pk-sql">SELECT @@IDENTITY</attribute> --> </entity-command>
Ramrakhiani, Vikas wrote:
I could not find mssql-fetch-key in standardjbosscmp-jdbc.xml.
thanks, vikas.
------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user