Generic SQL Map - sorry if this is a repost !

I created a generic SQL Map like below. I get a SQL stmt from somewhere and trying to use iBatis SQLMap just to execute the SQL. I'll provide the complete select stmt.     $custom_sql$ select> Firs

Common practice to maintain sql maps and properties file

2004-12-06 Thread Nilesh Bhattad

Folks, This is how I keep all the mapping files, SqlMapConfig.xml(each per application) and 1 common SqlMapConfig.properties which has the database connection parameters for all the applications.   src   |   |   |___ XML.app1.ibatis.maps   |                        |   |                    

Qns abt using inside

2005-01-18 Thread Nilesh Bhattad

Hello,   I’m having some trouble while using node inside   Please take a look at below select statement.  

  select ConsultantId, BlackListed, FirstName, LastName, HomeTelephone, Em

RE: Qns abt using inside

docs.. there is another statement that you can use to wrap what you have called:   if you add that instead of your 'where' it will be okay. -Tim   From: Nilesh Bhattad [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 11:02 AM To: ibatis-user-java@incubator.apache.org

change in property value inside

Hello,   Is there a way to change a property value before it is plugged in to the select statement?     select ConsultantId, BlackListed, FirstName, LastName, HomeTelephone, EmailAddress, In

Dynamic insert stmt

2005-01-27 Thread Nilesh Bhattad

Hi there,   I have the below statement defined in a sqlmap. If ‘BlackListed’ is not passed thro the HashMap, and rest of the fields are passed in, one comma is inserted before ‘isMarried’ column and it becomes an invalid sql stmt. I tried surrounding with tag, but that did

Reset sqlmaps

2005-01-27 Thread Nilesh Bhattad

Hi,   Is there a way to reload a modified sqlmap file at runtime? Sorry if this is a repost. I couldn’t find a similar topic in archives.   If I understand it right, every time a change is made in sqlmap file, server need to be restarted in order to take effect of the new changes. Just

RE: Dynamic insert stmt

2005-01-27 Thread Nilesh Bhattad

HERE B = 'BValue' In your situation you should simply add and tags. tags can be used in any kind of statement (even insert). Read the SQLMap guide carefully, it's pretty clear on how dynamic tags and the prepend attribute behave... Cheers, Philippe Nilesh Bhattad wrote: >

problem while inserting a record with MONEY datatype

2005-04-18 Thread Nilesh Bhattad

  insert into testbit(testbit, testmoney) values (#testbit#, #testmoney:NUMERIC#)  insert>     The above iBatis call throws below exception --   DEBUG - {pstm-11} PreparedStatement:    insert into tes

RE: MORE ON IBATIS.COM DOMAIN UPDATE...YEP, IT BROKE

2005-06-06 Thread Nilesh Bhattad

Hi,   --- The DTDs should be resolving from the JAR files by default, so you shouldn't need to do anything.  Unfortunatley some XML parsers don't use entity --- resolvers properly.  Also, your IDE might want to resolve from the network too.  Good IDEs like IntelliJ IDEA use locally mapp

Search the list

Mail list logo