Thanks everyone for your replies.
I am still not clear as to why this problem is happening. As you can see
from my mapping file the cache type is set to none. I am assuming that the
query is being done against the database every time. Also, most records
that are created on either server show up on queries from both servers.
Am I correct in assuming that the cache-type=none setting will force castor
to go directly to the database everytime?
Thanks
><!-- Mapping for the LoanApplicationSummary -->
> <class name="com.loanapplication.LoanApplicationSummary"
> identity="applicationId">
>
> <cache-type type="none"/>
> <map-to table="LOAN_APPLICATION"/>
> <field name="applicationId" type="long" >
> <sql name="OID" type="bigint"/>
> </field>
> <field name="status.type" type="string" >
> <sql name="STATUS_CD" type="longvarchar"/>
> </field>
> <field name="alternateDisbursement" type="string" >
> <sql name="ALTRNTE_DSBRSMNT" type="longvarchar"
>dirty="ignore"/>
> </field>
> <field name="complete" type="boolean" >
> <sql name="APP_COMPLETED_IND" type="bit"
dirty="ignore"/>
> </field>
> <field name="statusChangeDate" type="date" >
> <sql name="STATUS_UPDATE_DATE" type="date"
>dirty="ignore"/>
> </field>
> <field name="year" type="string" >
> <sql name="ACADEMIC_YEAR" type="longvarchar" dirty="ignore"/>
> </field>
> <field name="school.name" type="string" >
> <sql name="SCHOOL_CD" type="longvarchar" dirty="ignore"/>
> </field>
> <field name="startDate" type="date" >
> <sql name="APP_START_DATE" type="date" dirty="ignore"/>
> </field>
> <field name="closeDate" type="date" >
> <sql name="DATE_CLOSED" type="date" dirty="ignore"/>
> </field>
> <field name="internalLiabilities"
> type="com.loanapplication.LiabilitySummary"
> collection="arraylist">
>
> <sql many-key="P_LOAN_APPLICATION"/>
> </field>
>
> <!-- Mapping for the Certification -->
> <field name="certification.certifiedDate" type="date">
> <sql name="DATE_CERTIFIED" type="date" dirty="ignore"/>
> </field>
> <field name="certification.certifyingOfficer" type="string">
> <sql name="CERTIFIED_BY" type="longvarchar"
>dirty="ignore"/>
> </field>
>
> <!-- Mapping for the Decision -->
> <field name="decision.status" type="string">
> <sql name="DECISION" type="longvarchar"
dirty="ignore"/>
> </field>
> <field name="decision.lastUpdate" type="date">
> <sql name="DECISION_UPDATE_DT" type="date"
>dirty="ignore"/>
> </field>
> <field name="decision.creditDecision.status" type="string">
> <sql name="CREDIT_DECISION" type="longvarchar"
>dirty="ignore"/>
> </field>
>
> <!-- Mapping for the Student -->
> <field name="student.studentId" type="long">
> <sql name="STUDENT_ID" type="bigint"
>dirty="ignore"/>
> </field>
> <field name="student.name.first" type="string">
> <sql name="STDT_FIRST_NAME" type="longvarchar"
>dirty="ignore"/>
> </field>
> <field name="student.name.upperFirst" type="string">
> <sql name="UPPER_FIRST_NAME" type="longvarchar"
>dirty="ignore"/>
> </field>
> <field name="student.name.middle" type="string">
> <sql name="STDT_MIDDLE_INITIAL"
type="longvarchar"
>dirty="ignore"/>
> </field>
> <field name="student.name.last" type="string">
> <sql name="STDT_LAST_NAME" type="longvarchar"
>dirty="ignore"/>
> </field>
> <field name="student.name.title.type" type="string">
> <sql name="TITLE" type="longvarchar"
>dirty="ignore"/>
> </field>
> <field name="student.name.upperLast" type="string">
> <sql name="UPPER_LAST_NAME" type="longvarchar"
>dirty="ignore"/>
> </field>
> <field name="student.ssn" type="string">
> <sql name="STDT_SSN" type="longvarchar"
>dirty="ignore"/>
> </field>
> </class>
>
> <!-- Mapping for LiabilitySummary -->
> <class name="com.loanapplication.LiabilitySummary"
> identity="id"
> depends="com.loanapplication.LoanApplicationSummary">
>
> <cache-type type="none"/>
> <map-to table="LIABILITY"/>
> <field name="loanApplication"
> type="com.loanapplication.LoanApplicationSummary">
>
> <sql name="P_LOAN_APPLICATION" dirty="ignore" />
> </field>
> <field name="id" type="long">
> <sql name="OID" type="bigint"/>
> </field>
> <field name="type" type="string">
> <sql name="TYPE" type="longvarchar" dirty="ignore" />
> </field>
> <field name="amount" type="integer">
> <sql name="AMT" type="integer" dirty="ignore"/>
> </field>
> </class>
Steve Chernyak
Technical Specialist
Outsourced Solutions Group, AMS
410 897-1622
This email message is intended only for use by the recipient(s) and may
contain confidential and proprietary information of AMS, Inc. Any
unauthorized use, disclosure, or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply email and
destroy all copies of this email message.
|---------+---------------------------->
| | Bruce Snyder |
| | <[EMAIL PROTECTED]>|
| | |
| | 06/06/2003 07:30 |
| | PM |
| | Please respond to|
| | castor-dev |
| | |
|---------+---------------------------->
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: [castor-dev] Missing records from OQLQuery
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
This one time, at band camp, Aditya Akella said:
AA>Hi Steave,
AA>
AA>Here is a link. Check the "TIP:" in that after the 4th point.
AA>
AA>http://www.mail-archive.com/[EMAIL PROTECTED]/msg04437.html
AA>
AA>I don't know how to fix the problem but this might help you and if
AA>you find a wayout please post it on the mailing list.
AA>
AA>Hope the above link helps.
AA>
AA>-- Aditya
AA>
AA>-----Original Message-----
AA>From: Steve Chernyak [mailto:[EMAIL PROTECTED]
AA>Sent: Friday, June 06, 2003 12:10 PM
AA>To: [EMAIL PROTECTED]
AA>Subject: [castor-dev] Missing records from OQLQuery
AA>
AA>
AA>Im having a problem retrieving records from the database using OQLQuery.
AA>I am running an a clustered WebLogic 8.1 environment using 0.9.4.3
version
AA>of castor.
AA>
AA>The problem:
AA>
AA>Executing the same query from different servers in the cluster results
in
AA>different size results being returned. A record is missing on one of the
AA>servers. This problem goes away after the servers are restarted. Also,
this
AA>doesnt happen all the time.
Steve,
Aditya's suggestion to look at Alexey's post to the list is a good
one. In the Tip, Alexey is making light of the fact that Castor has
no distributed caching mechanism. This means that if Object A is
changed on AppServer A, there is no automatic distribution of this
change to AppServers B and C. I plan to remedy this in the JDO
refactoring that is currently being planned.
On a side note, Alexey is correct that the capacity of the count-limited
cache type used to be 30. Just within the last month or so I increased
this default to 100.
Bruce
--
perl -e 'print
unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
