Re: Setting the LIMIT in a MYSQL select statement

A property on your parameter object. Larry On 10/31/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Is $row_number$ a string, or a bean member? > > > Mithra Rajah > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Larry Meadors > Sent: Monday

RE: Setting the LIMIT in a MYSQL select statement

Thanks. It works, if I keep it as a string itself. Mithra Rajah -Original Message- From: Rajah, Mithra Sent: Monday, October 31, 2005 3:05 PM To: user-java@ibatis.apache.org Subject: RE: Setting the LIMIT in a MYSQL select statement Is $row_number$ a string, or a bean member? Mit

RE: Setting the LIMIT in a MYSQL select statement

Is $row_number$ a string, or a bean member? Mithra Rajah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: Monday, October 31, 2005 3:02 PM To: user-java@ibatis.apache.org Subject: Re: Setting the LIMIT in a MYSQL select statement Se

Re: Setting the LIMIT in a MYSQL select statement

Select * from User LIMIT $row_number$, 1; On 10/31/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi, > > Is there any way to dynamically alter the LIMIT clause in Mysql with IBATIS? > > Say for ex, > > Select * from User LIMIT #row_number#, 1; > > To get a particular row from the table. > >

Setting the LIMIT in a MYSQL select statement

Hi, Is there any way to dynamically alter the LIMIT clause in Mysql with IBATIS? Say for ex, Select * from User LIMIT #row_number#, 1; To get a particular row from the table. Thanks, Mithra Rajah

error while using a CTH

Here is the error. com.ibatis.dao.client.DaoException: Error executing query for list. Cause: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in reporting/request/dao/ibatis/mapping/ Requests.xml. --- The error occurred while applying a result map. --- Check the

include and problem

Hi, if I use the block below " SELECT LAST_INSERT_ID() Zsolt

RE: How to set up a select map

Hi Dan, Thanks a lot! Mithra Rajah -Original Message- From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 2:55 PM To: user-java@ibatis.apache.org Subject: Re: How to set up a select map Hi Mithra, 1) Create a result-map from your expec

RE: error inserting null values to database

http://opensource2.atlassian.com/confluence/oss/display/IBATIS/What+caus es+an+Invalid+column+type+error+with+Oracle -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: maandag 31 oktober 2005 17:17 To: user-java@ibatis.apache.org Subject: error inserting null valu

error inserting null values to database

Hi I'm having trouble inserting null values into my database. The table allows nulls but when I supply a parameterMap with null values in it I get the folloing exception: java.sql.SQLException: Invalid column type at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:

How to log batch statements?

Hi, I see the SQL statements in log4j log file but not if I execute batch commands using startBatch and executeBatch. How can I see also those sql commands? Zsolt

Cache issue using discriminator

I'm using a serialized cache with result maps that contain a discriminator. This fails with NotSerializableException unless I set lazyLoadingEnabled="false". Is this expected? What effect does setting lazyLoadingEnabled=false have? Error msg is: com.ibatis.common.exception.NestedRuntimeExcepti