Are you using <insert/ > elements and calling insert() to execute them?
Larry On 4/24/07, Fearghal O Maolcatha <[EMAIL PROTECTED]> wrote:
I tried it with the latest driver from JTDS but still having the same problem. I've included the beginning of my SqlMapConfig.xml file below. Is there anything extra I need to set to get this to work? <settings useStatementNamespaces="true" /> <!-- Configure a built-in transaction manager. If you're using an app server, you probably want to use its transaction manager and a managed datasource --> <transactionManager type="JDBC" commitRequired="false"> <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="net.sourceforge.jtds.jdbc.Driver"/> <property name="JDBC.ConnectionURL" value="jdbc:jtds:sqlserver://localhost:3470/NSD_DB;"/> <property name="JDBC.Username" value="sa"/> <property name="JDBC.Password" value="********"/> </dataSource> </transactionManager> On 24/04/07, Larry Meadors <[EMAIL PROTECTED]> wrote: > Is that the M$ driver? I'd try JTDS and see if it works any better. > > http://jtds.sourceforge.net/ > > Larry > > > On 4/24/07, Fearghal O Maolcatha <[EMAIL PROTECTED]> wrote: > > > > > > Hi, > > > > I'm currently using Abator to generate the model, sql maps and DAOs for my > > SQL Server 2005 Express database. I have a number of tables that have > > autogenerated keys and abator is adding the following xml for each of these > > keys for the inserts in the sql mapping files: > > > > <selectKey keyProperty="<beanId>" resultClass="java.lang.Integer"> > > > > SELECT SCOPE_IDENTITY() > > > > </selectKey> > > > > However when I try to use the autogenerated 'insert()' method of the DAO, it > > does not return the generated key and the java bean passed as argument > > doesn't have it's id property updated. I've verified that a row is being > > inserted in the database the the 'insert()' method of the DAO is called but > > the <selectKey> part of the insert doesn't seem to be working. I had a look > > at previous threads and some had said that they were using the jtds jdbc > > driver so I had swiched to jtds-1.2 (I'm currently using the MS SQL Server > > 2005 JDBC driver, sqljdbc_1.1) but I still encountered the same problem. I > > can get the <selectKey> to work by replacing 'SCOPE_IDENTITY()' with > > '@@IDENTITY AS' but would prefer not to have to alter the generated xml and > > I think it is recommended not to use this as there can be problems if DB > > triggers are in use. > > > > I'm using JDK6, sqljdbc_1.1 as the JDBC driver, Ibatis-2.3.0.677 and SQL > > Server Express 2005. > > > > Any help or suggestions on how to rectify the problem would be appreciated. > > > > Regards, > > > > Fearghal. >
