AW: logging not working using log4j

2009-02-11 Thread Leucht, Axel
Please test with the following entries in your log4j configuration. log4j.logger.com.ibatis=DEBUG log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG log4j.logger.com.ibatis.sqlmap.engine.cache.CacheModel=DEBUG log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientImpl=DEBUG log4j.logger.c

Re: I would like to create a sql map dynamically

2009-02-11 Thread Jiming Liu
$fullsql$ Is this ok for you?

Re: I would like to create a sql map dynamically

2009-02-11 Thread Vorius
You are referring to parameter tags within the sql you write within an XML file used to initiate Ibatis. I am referring to programmatically altering the sql maps (specifically, adding entirely new select statements) once the applciation has already started. Let me bring up an example of log4j. T

Re: I would like to create a sql map dynamically

2009-02-11 Thread Jiming Liu
Using $param$ in sql. You can search document for details On Thu, Feb 12, 2009 at 4:59 AM, Vorius wrote: > > Is it possible to create a sql map dynamically? > > I was reading about a method of creating an xml stream in memory and > passing > that to Ibatis but I was hoping of a way of doing i

Re: position while iterating

2009-02-11 Thread Jeff Butler
There is not a way to determine the position in the list. I would add the alias as an attribute somewhere in the parameter object and calculate it in Java ($attributes[].alias). Jeff Butler On Wed, Feb 11, 2009 at 1:33 PM, Chris O'Connell wrote: > Is there any way to find my position while ite

I would like to create a sql map dynamically

2009-02-11 Thread Vorius
Is it possible to create a sql map dynamically? I was reading about a method of creating an xml stream in memory and passing that to Ibatis but I was hoping of a way of doing it using getters/setters. Is there any new method that may accomplish this? -- View this message in context: http://www

position while iterating

2009-02-11 Thread Chris O'Connell
Is there any way to find my position while iterating through a collection in the sqlMap file. For example, I want to do something like this: ,( SELECT TEMP_PA.PRODUCT_ID FROM PRODUCT_ATTRIBUTES TEMP_PA, ATTRIBUTES

Re: DELETE statement deletes all rows in table

2009-02-11 Thread Larry Meadors
When you say "sql client", are you talking about some native sql client app, or a java-based one that uses the same jdbc driver your app does? Try the statement with straight JDBC - I suspect you'll see the same behaviour. Larry

RE: DELETE statement deletes all rows in table

2009-02-11 Thread Burke.Kevin
Yeah, I figured as much. Did this already and as I mentioned, the output looks correct. We could take the logged statement and dump it into an external sql client, run it against our ASE database and it ran as expected. But when iBatis executed it through the db connection, it wiped the table. The

Re: DELETE statement deletes all rows in table

2009-02-11 Thread Larry Meadors
He meant "java.sql". not "javax.sql". Larry On Wed, Feb 11, 2009 at 9:33 AM, Richard Yee wrote: > Turn on debug logging for javax.Sql > And see what statements are getting prepared. >

Re: DELETE statement deletes all rows in table

2009-02-11 Thread Richard Yee
Turn on debug logging for javax.Sql And see what statements are getting prepared. R Sent from my iPhone On Feb 11, 2009, at 8:24 AM, "Burke.Kevin" wrote: Hi, We have encountered a bizarre scenario while using iBatis 2.3.0.667 on Sybase ASE. We began experiencing our entire table being wi

DELETE statement deletes all rows in table

2009-02-11 Thread Burke.Kevin
Hi, We have encountered a bizarre scenario while using iBatis 2.3.0.667 on Sybase ASE. We began experiencing our entire table being wiped from a delete statement that uses dynamic SQL to build the FROM and WHERE clauses in a sqlmap. We were pretty sure valid parameters were being passed in to th

Re: logging not working using log4j

2009-02-11 Thread Richard Yee
Can you send or paste your log4j prop file. I'll try it with a test app -R Sent from my iPhone On Feb 11, 2009, at 8:10 AM, "Stanley, Eric" wrote: Anyone have any thoughts on this? It's making me crazy. Your help is very much appreciated. -Ryan -Original Message- From: Stanley,

RE: logging not working using log4j

2009-02-11 Thread Young, Alistair
Have you tried trying to force iBATIS to use log4j: LogFactory.selectLog4JLogging(); >From the JavaDoc: "This method will switch the logging implementation to Log4J if Log4J is available on the classpath. This is useful in situations where you want to use Log4J to log iBATIS activity but commons

RE: logging not working using log4j

2009-02-11 Thread Stanley, Eric
Anyone have any thoughts on this? It's making me crazy. Your help is very much appreciated. -Ryan -Original Message- From: Stanley, Eric [mailto:eric.r.stan...@qwest.com] Sent: Monday, February 09, 2009 9:42 AM To: user-java@ibatis.apache.org Subject: RE: logging not working using log4j