RE: Query performs differently in SQL Query Analyzer

23, 2005, at 10:53 AM, Barnett, Brian W. wrote: Yes, I did notice that subsequent times the exact same query performed better. The problem is that in our app, a teacher is presented with a list of students in her class. She wants to run a report on each one. Clicking on a student executes

RE: Query performs differently in SQL Query Analyzer [SOLVED]

-Original Message-From: Barnett, Brian W. Sent: Monday, May 23, 2005 2:19 PMTo: 'ibatis-user-java@incubator.apache.org'Subject: RE: Query performs differently in SQL Query Analyzer where and when do you build your SqlMapClient instance? We used JPetStore 4 as a model

RE: global resultMaps ??

that it is declared first in the config file. Also be sure to prefix it with the id of the sql map file. Cheers, Clinton On Tue, 25 Jan 2005 16:03:48 -0600, Barnett, Brian W. [EMAIL PROTECTED] wrote: Is there a way to create a resultMap that can be referenced in separate sql map.xml files, or do

Writing SQL Maps that support both SQL Server and Oracle

We have a web app that runs against SQL Server. All of our SQL maps are SQL Server compliant. We now have to be able to support Oracle as well. (We never thought it would happen... a mistake.) Anyway, we are wondering if anyone has some general guidelines for writing SQL Maps so that they run

SQLServer and Oracle

We have a struts application which accesses a SQL Server database using the iBATIS DAO framework and iBATIS SQLMaps. We now need to also support an Oracle backend. Can someone suggest a good, reliable Oracle driver that we could use? Any tips, pitfalls, articles, etc., that apply when writing

RE: why delete by date not working?

For starters, it looks like you have where twice. -Original Message- From: Philip Chan [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 2:59 PM To: ibatis-user-java@incubator.apache.org Subject: why delete by date not working? Hi I have this delete statement java.util.Date