ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: @@IDENTITY problem with mssql drivers. ( sol. use jtds drivers form sf.net)
Date Sun, 01 Apr 2007 02:58:44 GMT
Wow, another reason to love M$.

Is that with the latest drivers?

Larry


On 3/31/07, pkbhavani <pkbhavani@gmail.com> wrote:
>
> spent lot of time geting @@INDENTITY returned using microsoft jdbc sql server
> driver.  it always return 0.   changed the driver to jtds from sf.net  it
> worked like a charm.
> here is my config.xml defining connection information
> --------------------------------------------------------------------
> <?xml version="1.0" encoding="UTF-8"?>
> <!-- edited with XMLSpy v2006 sp2 U (http://www.altova.com) by Amit Singh
> (Merrill Lynch) -->
> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
> "http://www.springframework.org/dtd/spring-beans.dtd">
> <beans>
>     <bean id="dataSourceMarketIntel"
> class="org.springframework.jdbc.datasource.DriverManagerDataSource">
>                 <property name="driverClassName">
>                         <!--
>                         <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
>                         -->
>                         <value>net.sourceforge.jtds.jdbc.Driver</value>
>                 </property>
>                 <property name="url">
>                 <!--
>                         <value>jdbc:microsoft:sqlserver://host:port;DatabaseName=dbname</value>
>                 -->
>                 <value>jdbc:jtds:sqlserver://host:port/dbname</value>
>                 </property>
>                 <property name="username">
>                         <value>dbuser</value>
>                 </property>
>                 <property name="password">
>                         <value>dbpassword</value>
>                 </property>
>         </bean>
>
>
> </beans>
>
> my sqlmapconfig file is as follows
> --------------------------------------
> <?xml version="1.0" encoding="UTF-8" ?>
> <!DOCTYPE sqlMapConfig
>     PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
>     "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
>
> <sqlMapConfig>
>         <settings cacheModelsEnabled="true"
>                   enhancementEnabled="true"
>                   lazyLoadingEnabled="true"
>                   maxRequests="32"
>                   maxSessions="100"
>                   maxTransactions="100"
>                   useStatementNamespaces="false"/>
>
>         <sqlMap resource="xcite/pst-config.xml"/>
>
> </sqlMapConfig>
>
>
> my pst-config.xml file is as follows
> --------------------------------------
> <?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
> "http://www.ibatis.com/dtd/sql-map-2.dtd">
> <sqlMap namespace="templates">
>
>           <insert id="insertStrips" parameterClass="com.ekt.mktdata.vo.StripData">
>                         insert into TSRSTRIPS ( Stripname, SeriesId, InstrumentId, MonthStart,
> MonthEnd, SpanYear, SpreadYear, SpreadYearCount)
>                                values (#name#, #seriesId#, #instrumentId#, #monthStart#,
> #monthEnd#, #spanYear#, #spreadYear#, #spreadYearCount#)
>                     <selectKey type="post" resultClass="java.lang.Integer">
>                                 SELECT @@IDENTITY AS ID
>                         </selectKey>
>           </insert>
>
> </sqlMap>
>
> ----------------------------------------------
> code to invoke insert is as follows
> ----------------------------------------------
>
> c
> public int insertStrip(StripData strip) {
>         Integer result = (Integer)getSqlMapClientTemplate().insert("insertStrips",
> strip);
>         System.out.println("insertStrip: " + result);
>         return retult.intValue();
>
> }
>
>
>
> --
> View this message in context: http://www.nabble.com/%40%40IDENTITY-problem-with-mssql-drivers.-%28-sol.-use-jtds-drivers-form-sf.net%29-tf3499293.html#a9772816
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

Mime
View raw message