RE: Problem with raw type.

Sara, If you are getting this in eclipse, please click on the yellow warning icon on the left. You should be auto suggested on what to do. It would prompt you to add or add @SuppressWarning("unchecked"). Like I said earlier, this has nothing to do with Ibatis. Warm Regards, Sundar Sanka

RE: Problem with raw type.

List is raw type exception occurs when u declare List l = new ArrayList() and not List l = new ArrayList(); This has got nothing to do with Ibatis. Warm Regards, Sundar Sankarnarayanan Software Engineer @University of Phoenix -Original Message- From: Irwin, Constance [mailto:[EMAI

RE: iBatis-362 - Caching broken for stored procs

I have observed that batch execution of stored procs pretty much takes the same amount of time as executing the procedure in a loop. Warm Regards, Sundar Sankarnarayanan Software Engineer @University of Phoenix From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT

RE: Re: Question about queryForList and Oracle ref cursors

Jesse, I don't think the query for list makes much of an impact in calling stored procedures. U will have to do a inputMap.get("resultParameter) to get the output. The surprising thing is the map is loaded, if you call queryForList or update or any of the methods. I really dont think you

RE: Need Help on Complex WHERE CLAUSE

If the obvious fact of table not existing was not missed then I am guessing it could be that the username with whom u r trying to connect to from the application, doesn't have access to these tables/schema and u can probably query these tables with your development login access . My 2 cents!!! -S

RE: iBATIS Batching with Spring DAO

Did u check Spring-reference.pdf. The batching of Ibatis has been explained in page 296. public class SqlMapAccountDao extends SqlMapClientDaoSupport implements AccountDao { public void insertAccount(Account account) throws DataAccessException { getSqlMapClientTemplate().execute(new SqlMapClie

RE: problem parsing sqlMaps

Hi, Did you add the sqlMapClient as a reference in you Spring application context? I guess that is what is missing. If you are using Older version of Spring then you should use something like this and use the "sqlMapClient" as a reference property. If you are using

RE: iBATIS no longer allows me to set java.sql.Timestamp property

I am right using java.sql.Date for a Date mapping and it works fine for me.. Did u try and restart the servers after you had committed the change to the database (Just a wild guess to the problem) Regards Sundar From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent

RE: Weird IN OUT Param problem.

See java.sql.Types for valid jdbcTypes. You're also asking for an automatic down cast. This may or may not work, depending on the database. Jeff Butler On Jan 30, 2008 3:44 PM, Sundar Sankaranarayanan <[EMAIL PROTECTED]> wrote: Thanks for the immediate response Jeff.

RE: Weird IN OUT Param problem.

On Jan 30, 2008 3:37 PM, Sundar Sankaranarayanan <[EMAIL PROTECTED]> wrote: Hi All, I have a stored procedure, which is something like this. call example(?,?,?,?,?,?) The first four params are IN params and the last 2 are out params. If

Weird IN OUT Param problem.

Hi All, I have a stored procedure, which is something like this. call example(?,?,?,?,?,?) The first four params are IN params and the last 2 are out params. If I set the mode="OUT" or set the mode as "INOUT" in the sql-map xml file I get a --- Cause: java.sql.SQLExceptio

RE: how to create custom TypeHandlerCallback to trim stringwhitespace

Hi, I had posted a way to insert a string array into oracle table. I am not sure if that is gonna help you, but somehow feel you could use the approach. public void setParameter(ParameterSetter setter, Object parameter) throws SQLException { if (parameter instanceof ArrayList) { ArrayList arr = (

RE: How to configure Multiple datasource in SqlMapConfig.xml

, January 17, 2008 1:57 PM To: user-java@ibatis.apache.org Subject: RE: How to configure Multiple datasource in SqlMapConfig.xml I did not understand when you said handle transactions through XA. Can you pl be more descriptive? Thanks "Sundar Sankaranarayanan" <[EMAIL PROTECTED]>

RE: How to configure Multiple datasource in SqlMapConfig.xml

Hi Jasmin, You might wanna have 2 different sql map files and handle transactions through XA. Regards -S From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 1:49 PM To: user-java@ibatis.apache.org Subject: How to

Execute a stored procedure as a batch.

Hi, I am using Spring with Ibatis. I have a stored procedure that inserts a row into the table. I want to call this procedure multiple times(as a batch). Please suggest which method do I use to call the procedure. Do I use the getSqlMapClient().queryForList since I am calling a stored proc

Call stored procedure with reference to a table as the input param.

Hi, I have a stored procedure that takes the input parameter as a reference to a table. it uses this to insert.update some values in the table. declare tbl_instance temp_table; -- Cant give the actual name of the table. begin -- Call the procedure insertStorecProc(tbl_instance => tbl_ins