RE: ORDER BY on multiple columns

Hi Niels - Thanks very much for pointing out my mistyped. Tuan From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Monday, January 29, 2007 11:03 AM To: user-java@ibatis.apache.org Subject: RE: ORDER BY on multiple columns Use: AND ra.job_number = #

ORDER BY on multiple columns

Hi, It seems that I missed some things very obvious but I couldn't figure out what caused the error. I have a multiple columns in the ORDER BY clause as defined in the query below SELECT td.category AS "category", td.description AS "description",

iBATIS cache flush interval

Hi, I apologize if this question has been asked before. The cacheModel is defined below. If I deploy my app at 8 AM which of the following is true for using iBATIS cache. A1) The cache will be cleared when ServiceRequest.insertReview is executed OR

RE: iBATIS cache configuration issue

Hi, Further investigating the issue I found that I set useStatementNamespaces=true in sql-map-config.xml file and if I removed that setting of not using statement namespaces, the exception didn't occur. But, how do I use iBATIS cache when setting useStatementNamespace to true?

iBATIS cache configuration issue

Hi, I'm encountering a strange problem when configuring cache in iBATIS XML file. When I added statement in cache model and use it in one of statements (see high lighted text), it generated an XML parsing exception during iBATIS initialization and stated that there is no statement name insertCac

RE: Could not initialize DaoConfig when excecuting from a Quartz job

In addition, the data source is defined below   web.xml         EZRA JDBC Connection      jdbc/ezraDS    javax.sql.DataSource    Container    data-sources.xml   http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/data-sources-

Could not initialize DaoConfig when excecuting from a Quartz job

Hi,   I have a simple SQL insert statement that got executed fine if it's called manually within an application. However, when I configured Quartz 1.5.2 to execute that same SQL insert statement, it threw Error parsing XML during web containter startup.   I found a few posted messages relat

ORDER BY clause issue

Hi,   I'm using SQLServer 2000 with MS JDBC driver. THe SQL query statement below executed and returned a correct result if I ran within SQL Server Analyzer. But, when I ran it within my Java app using iBATIS, it complained about ORDER BY on column s.created_dt.   Has any one encountered th

NestedSQLException throws with MSDTC error

Hi,   I'm having a problem (MSDTC) when I execute a query statement below using iBATIS DAO. The same query statement run fine in MS Query Analyzer for the same database user. My database views are the remoted views which granted SELECT permission by the same database user ID.   Do you kno