Re: Caused by: com.ibatis.sqlmap.client.SqlMapException: Unrecognized parameter mapping field

2005-07-09 Thread Rahul Singh ( Anant )
Nice it looks like a very elegant solution. Why do you have to look at it at such a level? Rahul On 7/9/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > just a thought but I would find and hurt the man who created these > tables... > > > On Jul 5, 2005, at 1:29 PM, Ashish Kulkarni wrote: > > > H

Re: R: [HELP] Whether or not iBatis support SQL Injection?

2005-07-09 Thread Clinton Begin
Hi Nathan, Given: SELECT * FROM ACCOUNT WHERE USERNAME = ? and PASSWORD = ? Consider that without prepared statements it would likely be implemented like this: String username = "cbegin"; String password = "barnacle" String sql = "SELECT * FROM ACCOUNT WHERE USERNAME = '" + username + "' AND PA

Re: R: [HELP] Whether or not iBatis support SQL Injection?

2005-07-09 Thread Nathan Maves
Found the answer in a later posting Guess thats what I get for being a Canuck for a week :) Nathan On Jul 9, 2005, at 9:14 PM, Nathan Maves wrote: I was asked the question "What is SQL injection and how can I avoid it?" I understand it to a point but an example would be great. Natha

Re: Caused by: com.ibatis.sqlmap.client.SqlMapException: Unrecognized parameter mapping field

2005-07-09 Thread Nathan Maves
just a thought but I would find and hurt the man who created these tables... On Jul 5, 2005, at 1:29 PM, Ashish Kulkarni wrote: Hi Thanks, it worked, i am using DB2 on AS400 as database for this query Ashish --- Larry Meadors <[EMAIL PROTECTED]> wrote: Any fields with # in them need to

Re: Countng Rows - UPDATE

2005-07-09 Thread Nathan Maves
My question is why did this work?On Jul 5, 2005, at 9:32 AM, Folashade Adeyosoye wrote:In the JAVA part I switched    count = (Integer) queryForObject("searchCountAvatar", parameterObject); FOR   count = (Integer) getObject("searchCountAvatar", parameterObject);  Thanks all.. From: Clinton

Re: R: [HELP] Whether or not iBatis support SQL Injection?

2005-07-09 Thread Nathan Maves
I was asked the question "What is SQL injection and how can I avoid it?" I understand it to a point but an example would be great. Nathan On Jul 5, 2005, at 7:01 AM, Larry Meadors wrote: Yes, it does pass the SQL directly to the driver, but unless you use the $$ syntax for parameters, you sho

Re: doc for 2.1 version

2005-07-09 Thread Wilberto Montoya
Thank You Clinton, I'm working in PowerDesigner scripts templates for generate Ibatis xml files and java code (done) but and i will  like to know more technical information about Ibatis DAO too. There are another source you will suggest me?   Wilberto. - Original Message - From:

Re: To get the URL out of DataSource

2005-07-09 Thread Clinton Begin
Why not just grab it from the properties file?  Cheers, ClintonOn 7/7/05, Bing Qiao <[EMAIL PROTECTED]> wrote: Dear all,I need to get the URL string to show which environment (dev, test orproduction)  the application is running in.Here is what I did.//

Re: How to set the connection read-only?

2005-07-09 Thread Clinton Begin
Florin, I don't understand why you would do that.  If you have a connection that's read-only, why would you need a transaction at all? (or vice versa) Cheers, Clinton On 7/8/05, Florin Manolache <[EMAIL PROTECTED]> wrote:   Is there a way to set the connection in the read-only state befo

Re: Multiple Database Best Practices

2005-07-09 Thread Clinton Begin
Multiple databases are supported by defining multiple blocks. ClintonOn 7/6/05, Mitchell, Steven C <[EMAIL PROTECTED]> wrote: Answered my own question.  I can pass the name of the various mapping config files I need in a properties file:   properties.setProperty("ibatis.mapping.conf", "

Re: I must restart Tomcat when I modify some SQL Map XML files in SQLMapConfig.xml

2005-07-09 Thread Clinton Begin
That's currently the way it works (and it's preferred by most).  There's already a feature request to support optional runtime reloading. ClintonOn 7/9/05, Sylvain Pelletier <[EMAIL PROTECTED]> wrote: Hi,   First I'm new to the sqlmap's world!   I'm using sqlmap without using the dao manager of i

Re: doc for 2.1 version

2005-07-09 Thread Clinton Begin
Hi Wilberto... Unfortunately the docs haven't been fully updated yet.  However, for now, the wiki and other site resources should be able to help you with whatever you need. Cheers, ClintonOn 7/8/05, Wilberto Montoya <[EMAIL PROTECTED]> wrote: Hi, Im looking for ibatis ver 2.1 docs, in the site

Re: unsubscribing via the mailing list webpage

2005-07-09 Thread dr_nailz
Send an email to [EMAIL PROTECTED] (the from address being the one you wish to unsubscibe). On 7/9/05, John Fereira <[EMAIL PROTECTED]> wrote: > > I was looking on the mailing lists page for iBatis to see if there was a > mechanism for unsubscribing. > > Is there a mailto: address that can be us

I must restart Tomcat when I modify some SQL Map XML files in SQLMapConfig.xml

2005-07-09 Thread Sylvain Pelletier
Hi,   First I'm new to the sqlmap's world!   I'm using sqlmap without using the dao manager of ibastis. I work under myeclipse and when I modify the content of SQL MAP xml files (to add a select statement for example), the changes are not do in real-time. I'm actually restarting tomcat each times

n+1 is triggering multiple queries, 3?

2005-07-09 Thread Kris Rasmussen
I have an n+1 mapping. When I look at mysql health in the administrator it apears that 3 queries are being executed instead of one. The first query gets executed when I retrieve the intial object via queryForObject. The next two queries are being executed when I attempt to access the List which st