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

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 restartingtomcat each times I

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 used to

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: 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

Re: Multiple Database Best Practices

2005-07-09 Thread Clinton Begin
Multiple databases are supported by defining multiple context 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: 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 statebefore

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

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 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 PASSWORD

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: Hi