Hi Sandeep,
my suggestion is you try the patch for the MSSQL adapter class that I
described by my message on May 6.
Its intention is simply to account for the extra precision that the DATE
class of the MSSQL DB provides.
I'm not sure if it fixes your problem because I'm not very deep in Torque's
internal issues.
Regards
Arne
Hi all,
I am experiencing inconsistant results with save() method, call to save()
does not save results sometimes.
This failure is inconsistant and has been observed multiple times a day.
Lets say typically of 2000 rows data will be save correctly and
for 1 or 2 or more it might not be saved.
Environment: Web application on TOMCAT,
torque 3.1
database: MSSQL
Table schema is simple, each table/Tables have ID columns as primary keys.
All tables have similiar structure and only problem in in one of tables.
The web application has multiple threads (created by developers) , and all
api's callling Torque save() have been synchronized.
This failure to save occurs inconsistantly in some rows while for most it
works.
Please suggest solution.
thanks in advance
Sandeep
--------------------code snippet
Criteria crit = new Criteria();
crit.add(TransformJobPeer.TRANSFORM_JOB_ID,tji.getTranformJobId().longValue());
List v = TransformJobPeer.doSelect(crit);
Iterator itr = v.iterator();
TransformJob lkup;
BigInteger jobId = tji.getTranformJobId();
Iterator lItr;
TransformJobFilesInterface tjfi;
while(itr.hasNext()){ lkup = (TransformJob)itr.next();
try{ logger.error("TESTING : data from Db ID:" +
tji.getTranformJobId() + ".STATUS:" + tji.getStatus());
lkup.setDateLastUpdated(new Date());
lkup.setStatus(tji.getStatus());
lkup.setIsComplete(true);
logText = lkup.getLogText();
if(null == logText)
logText = tji.getLogText();
else
logText= logText + tji.getLogText();
lkup.setLogText(logText);
lkup.save();
}catch....
----------------------------------------
table schema:
<table name="TRANFORM_JOB"
idMethod="native">
<column name="JOB_ID"
required="true"
primaryKey="true"
type="BIGINT"
identity="true"
autoIncrement="true"
javaType="Object"
description="job table"/>
<column
name="NUM_FILES"
type="INTEGER"
description="number of files"/>
<column
name="NUM_TRIES"
type="INTEGER"
javaName="numberTry"
description="number of tries done"/>
<column
name="isJobComplete"
type="BIT"
javaName="isComplete"
description="isJobComplete"/>
<column
name="BATCH_DATE"
type="CHAR"
size="8"
javaName="batchDate"
description="date in format yyyymmdd"/>
<column
name="DEST_DIR_PATH"
type="VARCHAR"
size="512"
javaName="destDirPath"
description="dest path"/>
<column
name="errorReason"
type="CHAR"
size="25"
javaName="errorReason"
description="errorReason"/>
<column
name="LOG_TEXT"
type="LONGVARCHAR"
javaName="logText"
description="log "/>
<column
name="DATE_FILED"
type="DATE"
javaName="dateFiled"
description="time stamp"/>
<column
name="DATE_RECEIVED"
type="DATE"
javaName="dateReceived"
description="time stamp"/>
<column
name="DATE_CREATED"
type="DATE"
javaName="dateCreated"
description="time stamp"/>
<some foreign key defs>
</table>
**********************************************************************
http://www.pta.de
Mit 941 Erfahrungsberichten aus 35 Jahren erfolgreicher Projektarbeit!
**********************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
