Running the following code with MySQL 3.23-MAX:
HashMap coverage_map = new HashMap();
try {
Criteria allPersons = new Criteria();
GregorianCalendar gc = new GregorianCalendar();
gc.set(gc.DATE, 1);
gc.add(gc.MONTH, 1);
gc.set(gc.HOUR_OF_DAY, 0);
gc.set(gc.MINUTE, 0);
gc.set(gc.SECOND, 0);
allPersons.add(PersonCoverageXrefPeer.COVERAGE_PAID_THROUGH, gc.getTime(),
Criteria.LESS_THAN);
// Only renew charges for accounts after 6/1/02
gc.set(gc.DATE, 1);
gc.set(gc.MONTH, gc.JUNE);
gc.set(gc.YEAR, 2002);
allPersons.add(PersonCoverageXrefPeer.EFFECTIVE_DATE, gc.getTime(),
Criteria.GREATER_EQUAL);
Iterator coverages = PersonCoverageXrefPeer.doSelect(allPersons).iterator();
I see the following log on the XP box
C:\benefit\torque>java com.benefit.creditcard.ProcessMonthlyCharges
0 [main] DEBUG org.apache.torque.adapter.DBFactory - Using
org.apache.torque
.adapter.DBMM
160 [Thread-1] INFO org.apache.torque.oid.IDBroker - IDBroker thread was
star
ted.
400 [main] DEBUG org.apache.torque.util.BasePeer - SELECT
PERSON_COVERAGE_XREF.PERSON_ID, PERSON_COVERAGE_XREF.COVERAGE_ID,
PERSON_COVERAGE_XREF.EFFECTIVE_DATE, PERSON_COVERAGE_XREF.EXPIRATION_DATE,
PERSON_COVERAGE_XREF.PREMIUM_AMOUNT,
PERSON_COVERAGE_XREF.COVERAGE_PAID_THROUGH FROM PERSON_COVERAGE_XREF WHERE
(PERSON
_COVERAGE_XREF.EFFECTIVE_DATE>='20020601000000') AND
(PERSON_COVERAGE_XREF.COVERAGE_PAID_THROUGH<'20020701000000')
420 [main] DEBUG org.apache.torque.util.BasePeer - Elapsed time=20 ms
480 [main] DEBUG org.apache.torque.util.BasePeer - SELECT
PERSON.PERSON_ID, PERSON.PERSON_PASSWORD, PERSON.ADDRESS_ID,
PERSON.PERSON_SSN, PERSON.PERSON_FIRST_NAME, PERSON.PERSON_MIDDLE_NAME,
PERSON.PERSON_LAST_NAME, PERSON.PERSON_DATE_OF_BIRTH, PERSON.PERSON_GENDER,
PERSON.PERSON_EMPLOYER, PERSON.EMPLOYER_ADDRESS, PERSON.PERSON_TITLE,
PERSON.PERSON_MARITAL_STATUS, PERSON.DEPENDENT_OF,
PERSON.DEPENDENT_RELATIONSHIP, PERSON.PERSON_EMAIL_ADDRESS FROM PERSON
WHERE (PERSON.PERSON_ID=105)
And the following log under Linux (same WAR file, same data in the database):
[jturner@secure jturner]$
/usr/java/jdk1.3.1_01/bin/java com.benefit.creditcard.ProcessMonthlyCharges
0 [main] DEBUG org.apache.torque.adapter.DBFactory - Using
org.apache.torque.adapter.DBMM
113 [Thread-1] INFO org.apache.torque.oid.IDBroker - IDBroker thread was
started.
241 [main] WARN org.apache.torque.oid.IDBroker - IDBroker is being used
with db 'benefit', which does not support transactions. IDBroker attempts
to use transactions to limit the possibility of duplicate key
generation. Without transactions, duplicate key generation is possible if
multiple JVMs are used or other means are used to write to the database.
292 [main] DEBUG org.apache.torque.util.BasePeer - SELECT
PERSON_COVERAGE_XREF.PERSON_ID, PERSON_COVERAGE_XREF.COVERAGE_ID,
PERSON_COVERAGE_XREF.EFFECTIVE_DATE, PERSON_COVERAGE_XREF.EXPIRATION_DATE,
PERSON_COVERAGE_XREF.PREMIUM_AMOUNT,
PERSON_COVERAGE_XREF.COVERAGE_PAID_THROUGH FROM PERSON_COVERAGE_XREF WHERE
(PERSON_COVERAGE_XREF.EFFECTIVE_DATE>='20020601000000') AND
(PERSON_COVERAGE_XREF.COVERAGE_PAID_THROUGH<'20020701000000')
309 [main] DEBUG org.apache.torque.util.BasePeer - Elapsed time=15 ms
java.lang.ArrayIndexOutOfBoundsException
at org.gjt.mm.mysql.ResultSet.getDouble(ResultSet.java)
at org.gjt.mm.mysql.ResultSet.getDouble(ResultSet.java)
at com.workingdogs.village.Value.<init>(Unknown Source)
at com.workingdogs.village.Record.createValues(Unknown Source)
at com.workingdogs.village.Record.<init>(Unknown Source)
at com.workingdogs.village.DataSet.fetchRecords(Unknown Source)
at com.workingdogs.village.DataSet.fetchRecords(Unknown Source)
at com.workingdogs.village.DataSet.fetchRecords(Unknown Source)
at
org.apache.torque.util.BasePeer.getSelectResults(BasePeer.java:1631)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1529)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1481)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1433)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1363)
at
com.benefit.torque.BasePersonCoverageXrefPeer.doSelectVillageRecords(BasePersonCoverageXrefPeer.java:315)
at
com.benefit.torque.BasePersonCoverageXrefPeer.doSelectVillageRecords(BasePersonCoverageXrefPeer.java:285)
at
com.benefit.torque.BasePersonCoverageXrefPeer.doSelect(BasePersonCoverageXrefPeer.java:263)
at
com.benefit.creditcard.ProcessMonthlyCharges.processMonthlyCharges(ProcessMonthlyCharges.java:58)
at
com.benefit.creditcard.ProcessMonthlyCharges.main(ProcessMonthlyCharges.java:216)
rethrown as org.apache.torque.TorqueException
at
org.apache.torque.util.BasePeer.getSelectResults(BasePeer.java:1652)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1529)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1481)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1433)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1363)
at
com.benefit.torque.BasePersonCoverageXrefPeer.doSelectVillageRecords(BasePersonCoverageXrefPeer.java:315)
at
com.benefit.torque.BasePersonCoverageXrefPeer.doSelectVillageRecords(BasePersonCoverageXrefPeer.java:285)
at
com.benefit.torque.BasePersonCoverageXrefPeer.doSelect(BasePersonCoverageXrefPeer.java:263)
at
com.benefit.creditcard.ProcessMonthlyCharges.processMonthlyCharges(ProcessMonthlyCharges.java:58)
at
com.benefit.creditcard.ProcessMonthlyCharges.main(ProcessMonthlyCharges.java:216)
rethrown as org.apache.torque.TorqueException
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1534)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1481)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1433)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1363)
at
com.benefit.torque.BasePersonCoverageXrefPeer.doSelectVillageRecords(BasePersonCoverageXrefPeer.java:315)
at
com.benefit.torque.BasePersonCoverageXrefPeer.doSelectVillageRecords(BasePersonCoverageXrefPeer.java:285)
at
com.benefit.torque.BasePersonCoverageXrefPeer.doSelect(BasePersonCoverageXrefPeer.java:263)
at
com.benefit.creditcard.ProcessMonthlyCharges.processMonthlyCharges(ProcessMonthlyCharges.java:58)
at
com.benefit.creditcard.ProcessMonthlyCharges.main(ProcessMonthlyCharges.java:216)
Any ideas? I'm stuck.
James
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
