Hi,
I'm struggling with MS SQL Server, using Torque (standalone), with the MS
JDBC driver. I've done my due diligence, reading the 2 or 3 threads with
MSSQL tips on the mailing list (and the MS SQL notes on the web site).
Anyone come across the following issue? I can't seem to update a record in
the database without getting an exception from the JDBC driver "Can't start
a cloned connection while in manual transaction mode".
Here's an excerpt from my log, the code that's generating the message, and
the XML schema. I'm a little bit of a novice with MS SQL, so any ideas for
investigation would be appreciated!
WILL
LOG:
03-28 08:48 DEBUG - SELECT tblEmpInfo.INTID, tblEmpInfo.INTSIM_SESSION_ID,
tblEmpInfo.SZUSER_ID, tblEmpInfo.SZLASTNAME_NM, tblEmpInfo.SZFIRSTNAME_NM,
tblEmpInfo.SMINIT_NM, tblEmpInfo.SNICKNAME_NM, tblEmpInfo.SZEMAIL FROM
tblEmpInfo WHERE (tblEmpInfo.SZUSER_ID='t1')
03-28 08:48 DEBUG - Elapsed time=0.031 secs
03-28 08:48 DEBUG - BasePeer.doUpdate: whereClause=INTID=1
03-28 08:48 ERROR - Couldn't save user login information.
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
cloned connection while in manual transaction mode.
CODE:
try {
String testuserid = "t1";
Criteria crit = new Criteria();
crit.add(UserPeer.SZUSER_ID,new StringKey(testuserid ));
Vector UserList = UserPeer.doSelect(crit);
if (UserList.size() == 0) {
log.error("Invalid user id!");
} else {
User TheUser = (User) UserList.get(0);
TheUser.setSimSessionId(RandInt);
TheUser.save();
log.info("Logged user " + userid + " in.");
}
} catch (Exception E) {
log.error("Couldn't save user login information. " + E);
}
SCHEMA XML EXCERPT:
<!-- ===================================================== -->
<table name="tblEmpInfo" javaName="User" idMethod="none" skipSql="true"
description="OM representation of previously created table."
>
<column name="intID" required="true" javaName="Id"
primaryKey="true" type="INTEGER" />
<column name="intSIM_SESSION_ID" javaName="SimSessionId"
required="true" default="-1" type="INTEGER" />
<column name="szUser_ID" javaName="UserId" required="true" size="8"
type="VARCHAR" />
<column name="szLastName_nm" javaName ="LastName" size="255"
default="" required="true" type="VARCHAR"/>
<column name="szFirstName_nm" javaName ="FirstName" size="255"
default="" required="true" type="VARCHAR"/>
<column name="sMInit_nm" javaName ="MInitial" size="255"
default="" required="true" type="VARCHAR"/>
<column name="sNickName_nm" javaName ="NickName" size="255"
default="" required="true" type="VARCHAR"/>
<column name="szEmail" javaName ="Email" size="255"
default="" required="true" type="VARCHAR"/>
</table>
_______________________________________
Forio Business Simulations
Will Glass-Husain
(415) 440-7500 phone
(415) 235-4293 mobile
[EMAIL PROTECTED]
www.forio.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
