Re: Problem in using complex objects in ibatis2.0

Hi Kishlay   It is not the problem with iBatis.  You cannot have the member variable with the second letter Capital.   Instead of wHistVO  try  whistVO.  This will work.   The getter and setter would be getWhistVO and setWhistVO.   Thanks Prashanth."Nikesh, Kishlay" <[EMAIL PROTECTED]> wro

Re: How to clear the Cache when i want to?

Thanks a ton. PrashanthClinton Begin <[EMAIL PROTECTED]> wrote: sqlMapClient.flushDataCache();Cheers,Clinton On 11/16/05, Prashanth Sukumaran <[EMAIL PROTECTED]> wrote:Hi All,   I am using OSCache for caching query results in iBatis.  I have a cachemodel with flushinterval as

How to clear the Cache when i want to?

Hi All,   I am using OSCache for caching query results in iBatis.  I have a cachemodel with flushinterval as 12.  How do i initiate the flush cache myself?   Is there any way i can get the handle to CacheController and call flush on it.   Thanks Prashanth. Yahoo! FareChase - Search multip

iBatis & OSCache flush cache

Hi All,   I have configured OSCache as the cache model for ibatis.  I would like to flush the cache.   I am trying to use the oscache flush JSTL tablib to accomplish this.  Even after i called the i see that that cache is not flushed. I am not able to get it working.  My sql logging shows that

Re: Limiting the number of rows returned by iBatis

Thanks Larry.  You reply was very helpful.Larry Meadors <[EMAIL PROTECTED]> wrote: Yes. Look at the SqlMapClient API.LarryOn 10/11/05, Prashanth Sukumaran <[EMAIL PROTECTED]>wrote:>> Hi All,>> Is there a way to limit the number of rows returned by iBatis.>> I want t

Limiting the number of rows returned by iBatis

search criteria i want to show the top 100 orders along with the search filter.    Case 2) Now the user selects the search criteria and then on all the rows that match the search criteria should be returned.   Thanks in advance.   Prashanth Sukumaran Yahoo! Music Unlimited - Access over 1

Re: AW: ProbeException: Error getting ordinal list from JavaBean

DATA right  Now i understand what the problem was.   Prashanth   "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: Hi Prashanth,   any text within is literal text. An XML parser won't parse any elements the CDATA section might contain.   -Ursprüngliche Nachricht-Von: Pra

Re: ProbeException: Error getting ordinal list from JavaBean

Hi Team,   I had this problem as the Query i wrote was within CDATA.   When i removed the CDATA it works fine.   Why is this a problem?  What kind of logic is there in IBatis to convert a String to Integer when it is in CDATA?   Thanks Prashanth.Prashanth Sukumaran <[EMAIL PROTECTED]> wrote: Hi, I

ProbeException: Error getting ordinal list from JavaBean

Hi, I am getting a ProbeException when using an iterate tag in sql maps over a list of string objects.   Why does this throw an error when the data is a String.  Also why is IBatis trying to convert it to an Integer.    I have another query working the same when the List of String is in a Bean.  Th

Define Constants in SQLMap

a way to define constants for those values so they make more sense.   like      DIST_CHNL_ID = '1010' AND SLS_ORD_TYP_CD = 'Z001'    where   ORDER_TYPE_AIR = 0   Thanks   Prashanth Sukumaran. Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort.

Re: XML document output from ibatis

Hi Ashish,   Cool this is fine.  But the idea of a RowHandler is to have such conversions out of the DAO.  Also it looks clean as if IBatis is returning the Document object.    The work of the DAO layer is to only execute queries and return the data.  You can externalize such transformations into

Re: Vendor specific queries?

, then staticMessages_en.properties (if it's there), then  staticMessages.properties. By the same approach, we can have bar.xml for all generic queries, then bar_ORACLE.xml, bar_DB2.xml. We can use either the file name or name space concept.   On 9/6/05, Prashanth Sukumaran <[EMAIL PROTECTE

Re: Vendor specific queries?

I don't know if this would be a good idea.  Consider your example of Localization resource lookup(not the directory based approach but the file based approach) for example the ApplicaitonResouces.properties in struts, are you saying it is good to have one huge file with sections like INI file for d

Re: cacheModel configuration

Hi Sum, It is the order in which you define the sqlMap files in the sqlmap-config.xml. If you want to reference a statement declared in another sqlMal.xml file put this entry on top of the file that is referencing the statement. Like Assume there is an insert (Transport company) in the

RE: Confused with groupBy

eption. I am sure taking into consideration all the people using iBatis, this constitues to 100 - 1000 hours wasted. Rgds Prashanth Sukumaran. --- Brian Yoffe <[EMAIL PROTECTED]> wrote: > No, actually I don't think it's straightforward at all - let me make my > ex

Re: Strange Problem..

Hi Larry, I have the same thing But my commit work without commitRequired="true". Isn't this default. Has this changed in the newer version of IBatis. Eduardo, I hope you are check the database you are writing to. Rgds Prashanth. --- Larry Meadors <[EMAIL PROTECTED]> wrote: > > > On

Re: where can I find a simple implementation example

Hi I found that very good blog just explaining only IBatis with a simple example. http://www.j2eegeek.com/blog/2005/01/31/ibatis-where-have-you-been-all-my-life/ Rgds Prashanth --- Salim Madjd <[EMAIL PROTECTED]> wrote: > Hi, > I have read a lot of documentations and I still can not put the wh

Re: Error when web application is unused for a long time

Hi, You need to have the PING Query in the sql-map-config.xml. I think that should fix the problem. Rgds Prashanth Sukumaran. --- TNO <[EMAIL PROTECTED]> wrote: > Hello, > > I am working on a web application using Ibatis, Spring and JSP on Jonasz > Server with DB PostGre

RE: How to get table metadata?

Hi, Also be careful not to update or modify any of these hash maps. Rgds Prashanth. --- Prashanth Sukumaran <[EMAIL PROTECTED]> wrote: > Hi Sreenivasulu, > > Can you tell us what you want to do with the column names? > > Also you may t

RE: How to get table metadata?

what you are looking for. You should try the getter methods for the data. All the getters work based on the "ID" (defined in the sqlmap) of the sql you are executing. The developers of IBatis may have a better way. Just see if these can help you. Rgds Prashanth Sukumaran.

RE: Transaction question

er instead of calling the methodA and hence having nested transactions, can't you call methodB instead. Rgds Prashanth Sukumaran. --- "Barnett, Brian W." <[EMAIL PROTECTED]> wrote: > Niels, > Thanks for the info. Maybe I am not totally understanding how your modi

Re: where can I find a simple implementation example

IBatis PetStore. http://ibatis.apache.org/petstore.html --- Salim Madjd <[EMAIL PROTECTED]> wrote: > Hi, > I have read a lot of documentations and I still can not put the whole thing > together, yet. > I just want to see a simple implementation using servlet or jsp directly > without involvin

Re: Lists of like objects as parameters to SqlMaps

Hi Eric, Sometimes it is not good to advice people when you don't know it fully yourself. But this is how i would do. In normal JDBC i would achieve this by batchInsert. Similar is the case with iBatis. When executing in batch mode i do this. try { startTransaction(); start

Re: Message: no WRITABLE property

Hi Paul, make the line to This is ridiculous, I know. I have also wasted so much time on this thing before. But the issue is since it is a privimitive type and if the sql returns a NULL it throws an nullpointer exception. Rgds Prashanth Sukumaran. --- Paul Glezen <[EMAIL PROTEC

Re: I can't see clearly...

want to accomplish this in iBatis you can use $value$. That way it will directly do a String replace. Rgds Prashanth Sukumaran. --- TNO <[EMAIL PROTECTED]> wrote: > Hello, I have a simple problem but we are friday... > > This is a simple statement > > > &g

Re: Passing a list as IN parameter to stored procedure

[EMAIL PROTECTED]> create or replace 2 procedure show_java_calling_plsql 3 as language java 4 name 'ArrayDemo.passArray()'; 5 / Procedure created. [EMAIL PROTECTED]> [EMAIL PROTECTED]> set serveroutput on [EMAIL PROTECTED]> exec show_java_calling_plsql 1 2 3 4 5

Re: How do I do batch processing with IBatis DAO

WOW. Sometimes it is amazing the kind of requirement people have. There is so much to learn and see. Thanks for taking your time replying. Prashanth Sukumaran. --- Hycel Taylor <[EMAIL PROTECTED]> wrote: > I forgot to put the daoManager.commit(), in my example. > &g

Re: Multiple DaoManagers + transactions

the ibatis code you have new JdbcDaoTransaction(dataSource); for a JDBC and similarly for JTA, SQLMap etc. Each of these hold a connection object and hence should not colide with each other. Rgds Prashanth Sukumaran. --- Louis Letourneau <[EMAIL PROTECTED]> wrote: > Hello

Re: How do I do batch processing with IBatis DAO

requirement? Rgds Prashanth Sukumaran. --- Hycel Taylor <[EMAIL PROTECTED]> wrote: > I want to make sure I'm understanding how to use iBatis batching correctly. > > I understand now that SqlMapDaoTemplate, contains the method, > startBatch() and execute batch. My Dao wi

Re: How do I do batch processing with IBatis DAO

base class for every layer i have so i can have the duplicate code there. That is all there is to it. Rgds Prashanth Sukumaran. --- Hycel Taylor <[EMAIL PROTECTED]> wrote: > From what I understand, looking at your source code, it appears that > the batching is handled by, BaseSqlMap

Re: How do I do batch processing with IBatis DAO

nt connections to execute each insert in the batch mode. Hope this helps Prashanth Sukumaran. --- Hycel Taylor <[EMAIL PROTECTED]> wrote: > Hi, > > I apologize, if this is the second time my email appears on the forum. > I didn't see the first one show up after I poste

RE: Complex type as IN parameter

l get some help from here. Rgds Prashanth Sukumaran. --- "Rao, Satish" <[EMAIL PROTECTED]> wrote: > I am using Oracle. Not sure if it allows "LIST" Data Type. > > -Original Message- > From: Prashanth Sukumaran [mailto:[EMAIL PROTECTED] >

Re: Complex type as IN parameter

or this. Can any of the iBatis developers help with this? Thanks Prashanth Sukumaran. --- Koka <[EMAIL PROTECTED]> wrote: > Well, as far as I know in Oracle passing arrays to Prepared/Callable > procedures is posible BUT is part of Oracle extensions, i.e. requires > casts

RE: Complex type as IN parameter

Hi Satish, What Database are you using? Does it allow you to define a DATA TYPE "LIST". Thanks Prashanth Sukumaran. --- "Rao, Satish" <[EMAIL PROTECTED]> wrote: > Hi Prashanth, > > What I want to know is how to pass a list as a IN paramater to s

Re: Complex type as IN parameter

Hi Satish, You must be using a iterator if you are passing a List as a parameter right. Also you have defined TBL_ORD_ID as TEST_TABLE.ORD_ID%TYPE. I have never heard of any database that defines/has a list Data Type. Is there any??? If not then defined the type of ORD_ID. Rgds Prashanth

Re: Logging?

Hi Max, In your previous mail you mentioned that you are seeing other debug statements but you are not seeing only "log4j.logger.com.ibatis.*" and "log4j.logger.java.sql.*" rows seems not to have effect on logging. This means your log4j Properties Configurator

Re: SQLMaps - Sybase and stored procedures

Hi Andrew, The reason may be you have defined to_text as INOUT. In the parameterMAP define to_text as OUT only. Then you don't have to set any value for to_text. Rgds Prashanth. --- Koka <[EMAIL PROTECTED]> wrote: > Did you also put "to_text" into your Map? Say > > HashMap map = new Has

Re: SQLMaps - Sybase and stored procedures

Hi, Sorry for that horrible english. I did not read before i pressed the send button. I meant nobody is looking at the definition of the prodecure in the sqlmaps. Rgds Prashanth. --- Prashanth Sukumaran <[EMAIL PROTECTED]> wrote: > Hi Andrew, > > I am wrong or is everybody

Re: SQLMaps - Sybase and stored procedures

Hi Andrew, I am wrong or is everybody nothing looking at the definition of the procedure. You have not defined the OUT Parameter for this procedure. How are you going to get the result from the procedure. Thanks Prashanth. --- [EMAIL PROTECTED] wrote: > Thanks. > > I have tried both regula

Re:

Hi Eugeny, I placed the list in a map coz., i wanted to pass more parameters. select TBLSHOPS.SHOPID, TBLSHOPS.SHOPNAME from TBLSHOPS, TBLSHOPGROUPS1 where TBLSHOPGROUPS1.

RE: Stored procedure with queryForList skipresults and maxresults

Hi Satish, Larry is correct. Last week was a terrible week for me. The site kept going down due to memory hog. It was fine when there were few visitors. When the users increased all of the 1GB ram allocated was eaten up in 6 mins. The developer was getting all the data first, thus creatin

RE: Stored procedure call throwing UncategorizedSQLException

IN_filter2 IN table.col2%TYPE, > IN_filter3 IN table.col3%TYPE, > OUT_RESULTSET OUT Types.cursor_type) AS > BEGIN. > > Thanks. > > -Original Message- > From: Prashanth Sukumaran [mailto:[EMAIL PROTECTED]

Re: Stored procedure call throwing UncategorizedSQLException

Hi Satish, IBatis is a very simple tool. It is just a wrapper on top of the JDBC. You can call it with any technical name. It lets to do a lot of things, which otherwise you will have to do it yourself. For Example, In the normal JDBC assume you had one Input and one Output. You would do

Re: Customizing Parameter mapping

Hi Srinivas Read the IBatis documentation on SQL Maps and you will find it there. It has exactly what you want. Rgds Prashanth. --- sreenivas <[EMAIL PROTECTED]> wrote: > Hi All, > > I have requirement where a Java Bean has properties of user defined objects. > > Here is an example class c

Re: QueryForObject returns wrong data

Hi Jeff, I don't know how the scale would work. As per jdk 1.4 there are 4 constructors to create BigDecimal. The first two use biginteger, i think this will not be a case at BigInteger would not be mapped to Decimal type field. The other two use double or string. In both cases the value is

Re: QueryForObject returns wrong data

Hi Shilpa, Just in case, have you defined the bean variable as int/integer by mistake. Rgds Prashanth. --- shilpa <[EMAIL PROTECTED]> wrote: > Hi, > > It may sound little strange, but I am getting wrong data back when I call > QueryForObject( ) method and try to get firld of Decimal data

Re: Displaying generated SQL

Hi Satish, I don't know if there is a way in iBatis to do this. But you can use p6spy to monitor the sql generated. It is very simple to setup. Rgds Prashanth. --- "Rao, Satish" <[EMAIL PROTECTED]> wrote: > I am using dynamic SQL and wanted to know if there is a way to print the > generated