odd java.io.FilePermission problem in Tomcat - please help

2005-09-29 Thread LI, Michelle
 Experts there,       I created a web application running in Tomcat, I use ibatis to do database operation, everything works very well on my own machine. After publish to the hosting server, I met a n odd problem, which is reporting a java.io.FilePermission problem, however, none of my code

RE: IBatis doesn't see the changes in the database

2005-09-29 Thread Ann Carpentier
Hi,   I’ve found the solution. I had to play with my dataCache…J   Ann   Van: Ann Carpentier [mailto:[EMAIL PROTECTED] Verzonden: 30 September 2005 07:40 Aan: user-java@ibatis.apache.org Onderwerp: IBatis doesn't see the changes in the database   Hi,     I’m developing

IBatis doesn't see the changes in the database

2005-09-29 Thread Ann Carpentier
Hi,     I’m developing an interface, which access a certain table every 24 hours and checks if the record of the table exists in another linked table. I will illustrate this with an example:   Table1: TB_TAPE (PK_TAPE_ID) Table2: TB_RECORD (FK_TAPE_ID) Table3: TB_READ_HISTORY (FK_TAP

RE: Question about paginated list.

2005-09-29 Thread Steve Biondi
Which DB are you using? For example, in Oracle something like this works: select * from ( select a.*, rownum rnum from ( YOUR_QUERY_GOES_HERE -- including the order by ) a where rownum <= MAX_ROWNUM ) where rnum >= MIN_ROWNUM The nice thing about this technique is you ca

Question about paginated list.

2005-09-29 Thread anton
Hi, Recently im working with paging feature in my web application, and I need to get a ranged results from a query, lets say that my query will get 10.000 records but I want to get only 10 records from it,(eg starting from record 9.980 until record 9.990), I already know iBATIS paginated l

Mapping 3 way join tables

2005-09-29 Thread reubenf
Hello, I have tables A, B and C, which are related via table A_B_C: A: a_id B: b_id C: c_id A_B_C: a_id b_id c_id I have beans representing A, B & C, but I would like to avoid having a bean representing A_B_C. That is, A (the owner) would ideally have instances of B & C, ideally mapped in a h

Re: N+ 1 selects

2005-09-29 Thread John Chien
Jean: Thank you for your response. That's my fault. My intention actually is not tries to do the N+1 selects, but have returned result putting into a bean. This bean will be used as a property of another bean. I do not know if my way of doing it is correct or not. Somehow it does not work F

Re: Passing logged in Username and password to iBATIS

2005-09-29 Thread Vijai Senthil Padmanabhan Kalaiyarasi
Hi Larry,   Thank you so much... It is working fine. Here is my implementation. It may be useful for others.   SQLMapconfig.xml ---                                       And passing the value through property file while buili

Re: Passing logged in Username and password to iBATIS

2005-09-29 Thread Clinton Begin
This mailing list is closed.  please use user-java@ibatis.apache.org ClintonOn 9/28/05, Vijai Senthil Padmanabhan Kalaiyarasi <[EMAIL PROTECTED] > wrote: Hi,       I have included this piece of code before getting the DAO instance from DAOManager.           SqlMapDaoTransaction trans = (S

Re: MS Access selectKey question

2005-09-29 Thread Michael Campbell
On 9/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Thanks for the replies guys. Sorry for the late response.. > The id property doesnt exist in the object im inserting, ... If this is the case, then your sql with " ... values (#id#, ..." won't work since by using "#id#", you're telling i

Re: xml

2005-09-29 Thread Larry Meadors
Well, yes it "sort of" can. It will return one xml DOCUMENT per object - if you want one object as XML, you can easily do that. If you want a list of objects as a single xml document, you have to do that yourself... Larry On 9/29/05, Guido García Bernardo <[EMAIL PROTECTED]> wrote: > yes, it ca

Re: xml

2005-09-29 Thread Guido García Bernardo
yes, it can. please read the manual, page 19 http://prdownloads.sourceforge.net/ibatisdb/iBATIS-SqlMaps-2.pdf?download Carlos de la Flor Egiluz wrote: > I have some sql that returns java obj. > can ibatis return one xml string? > thanks -- Guido García Bernardo - [EMAIL PROTECTED] Tfn. +34 98

xml

2005-09-29 Thread Carlos de la Flor Egiluz
I have some sql that returns java obj. can ibatis return one xml string? thanks