Re: AW: Enabling iBatis 3 logging

2010-04-14 Thread Martin Ellis
On 14 April 2010 16:22, cowwoc wrote: >    How come I can't get this working with slf4j? Meaning, when I enable > "java.sql" I don't see any SQL statements getting logged. I've never used > log4j with iBatis before so something else must have broken the loggi

Re: AW: Enabling iBatis 3 logging

2010-04-14 Thread cowwoc
How come I can't get this working with slf4j? Meaning, when I enable "java.sql" I don't see any SQL statements getting logged. I've never used log4j with iBatis before so something else must have broken the logging... Can you please point me to the file

Re: AW: Enabling iBatis 3 logging

2010-04-14 Thread Martin Ellis
On 14 April 2010 16:14, cowwoc wrote: > >    Who is actually doing the logging? Is it java.sql or is it the > responsibility of the underlying JDBC driver (varies from vendor to vendor) > to decide whether logging takes place? iBATIS is doing the logging - but with a logger name s

Re: AW: Enabling iBatis 3 logging

2010-04-14 Thread cowwoc
Who is actually doing the logging? Is it java.sql or is it the responsibility of the underlying JDBC driver (varies from vendor to vendor) to decide whether logging takes place? Thanks, Gili On 14/04/2010 1:35 AM, Stephen Friedrich wrote: Using this log4j configuration I am getting all

AW: Enabling iBatis 3 logging

2010-04-13 Thread Stephen Friedrich
Gesendet: Mittwoch, 14. April 2010 01:17 An: user-java@ibatis.apache.org Betreff: Enabling iBatis 3 logging Hi, I'm getting this exception: [snip] operation: setValue org.apache.ibatis.exceptions.IbatisException: ### Error updating database. Cause: org.postgresql.uti

Enabling iBatis 3 logging

2010-04-13 Thread cowwoc
Hi, I'm getting this exception: [snip] operation: setValue org.apache.ibatis.exceptions.IbatisException: ### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "WHERE" Position: 68 [snip] The annoying thing is I can't find

Re: How to do logging in iBatis + Spring

2010-03-07 Thread Nathan Maves
Yes use standard logging or a logging framework like log4j. just set the following You can define them at a more granular level if you want. On Sun, Mar 7, 2010 at 8:13 AM, Bhaarat Sharma wrote: > We use iBatis + Spring and make use of stored procedu

How to do logging in iBatis + Spring

2010-03-07 Thread Bhaarat Sharma
We use iBatis + Spring and make use of stored procedures to fetch information from Oracle DB. To find out what parameters (HashMap) is sent to the stored procedure we have to actually set debug points. We'd like this information to go to a log. Basically print out name of the Stored Proc + all th

Re: Re-2: Logging in iBatis 3

2010-01-13 Thread Clinton Begin
The log level is controlled by the underlying logging system (we support commons-logging, log4j, slf4j and jdk14 logging). In my environment, I have separate log4j props files for my unit tests and my production code. The kinds of errors you're talking about should never make it to produ

Re-2: Logging in iBatis 3

2010-01-13 Thread [e2n] software | Björn Raupach
nsert statement that used to work doesn't work anymore and I have no idea why. What about of having a log a tag within the environment tag? iBatis is already independed of logging frameworks so why not make more use of it? I would like to have a in my developing environment and in my productio

Re: Re-2: Logging in iBatis 3

2010-01-12 Thread Clinton Begin
n Raupach > >> > >> try { > >> // insert, update or delete > >> session.commit(); > >> } catch (IbatisException e) { > >> log.warn(e.getMessage()); > >> } finally { > >> session.close(); > >> } > >> > >> Now

Re: Re-2: Logging in iBatis 3

2010-01-12 Thread Nathan Maves
)); >> } finally { >>  session.close(); >> } >> >> Now I catch a unchecked exception. I don't know. Feels awkward. >> >> >> >> Subject: Re: Logging in iBatis 3 (12-Jan-2010 16:30) >> From:    Clinton Begin >> To:      raup...@e2n.d

Re: Re-2: Logging in iBatis 3

2010-01-12 Thread Clinton Begin
IbatisException e) { > log.warn(e.getMessage()); > } finally { > session.close(); > } > > Now I catch a unchecked exception. I don't know. Feels awkward. > > > > Subject: Re: Logging in iBatis 3 (12-Jan-2010 16:30) > From:Clinton Begin > To: raup...

Re: Re-2: Logging in iBatis 3

2010-01-12 Thread Jeff Butler
eption. I don't know. Feels awkward. > > > > Subject: Re: Logging in iBatis 3 (12-Jan-2010 16:30) > From:Clinton Begin > To: raup...@e2n.de > > > The SqlException is always within the thrown exception as a chained > exception. > > Clinton > >

Re-2: Logging in iBatis 3

2010-01-12 Thread [e2n] software | Björn Raupach
try { // insert, update or delete session.commit(); } catch (IbatisException e) { log.warn(e.getMessage()); } finally { session.close(); } Now I catch a unchecked exception. I don't know. Feels awkward. Subject: Re: Logging in iBatis 3 (12-Jan-2010 16:30) From:Cl

Re: Logging in iBatis 3

2010-01-12 Thread Clinton Begin
The SqlException is always within the thrown exception as a chained exception. Clinton 2010/1/12 [e2n] software | Björn Raupach > Hello, > > short Question: How is logging configured in iBatis 3? > > In iBatis2 we used to caught the SQLException, logged it and threw a >

Logging in iBatis 3

2010-01-12 Thread [e2n] software | Björn Raupach
Hello, short Question: How is logging configured in iBatis 3? In iBatis2 we used to caught the SQLException, logged it and threw a RuntimeException. However in iBatis3 there are no checked execptions anymore. We are using log4j. In log4j.properties we tried: log4j.logger.org.apache.ibatis

Re: logging sql statements

2009-12-14 Thread Clinton Begin
d to refer to the source code to find usages of Loggers. > This log category can be valuable, too: > > > > > -Ursprüngliche Nachricht- > Von: Rick.Wellman [mailto:rick.well...@kiewit.com] > Gesendet: Dienstag, 15. Dezember 2009 00:56 > An: user-java@

AW: logging sql statements

2009-12-14 Thread Stephen Friedrich
56 An: user-java@ibatis.apache.org Betreff: RE: logging sql statements iBatis relies on logging of the underlying JDBC statements which is documented (somewhere). We use the following settings in our log4j.xml file, adjust to your liking: -Ori

RE: logging sql statements

2009-12-14 Thread Rick . Wellman
iBatis relies on logging of the underlying JDBC statements which is documented (somewhere). We use the following settings in our log4j.xml file, adjust to your liking: -Original Message- From: Trenton D. Adams [mailto:tre...@athabascau.ca] Sent

logging sql statements

2009-12-14 Thread Trenton D. Adams
Hi Guys, I've searched the net like crazy, and there doesn't seem to be anything reasonable describing how to have iBatis print out the parsed SQL that is being run, during an error. Is this possible? Currently I tried the following, to no avail... LogFactory.selectLog4JLogging(); log4j.logg

RE: P6Spy for logging SQL with value using iBatis in JDK 1.5

2009-11-17 Thread Dsoares
should set up your own > (real) jdbc driver. I'd recommend either of these to any iBatis or even > Hibernate or straight jdbc users. > > (Comes in especially handy when you're trying to get performance metrics > for certain queries, etc.) > > -----Original Message

RE: logging not working using log4j

2009-02-24 Thread Shannon, Bryan
I'm a little late on this thread, but we had a similar problem. We were bundling our own copies of commons-logging and log4j inside of our .war file, whereas tomcat+jboss already had them... Seems it was a classloader issue. Try removing one or the other, if you have the same configur

RE: logging not working using log4j

2009-02-13 Thread Young, Alistair
I'm working with an OC4J app, and have placed the logging selection call just before the call to build the SqlMapClient (though in this case it is the selectJavaLogging() method which is being invoked). If there's nowhere else obvious, perhaps you could put it in your servlet's

RE: logging not working using log4j

2009-02-12 Thread Stanley, Eric
Richard, My log4j.properties is in the original message below. Lemme know what you get. It seems really simple. -Ryan -Original Message- From: Richard Yee [mailto:r...@cruzio.com] Sent: Wednesday, February 11, 2009 9:17 AM To: user-java@ibatis.apache.org Subject: Re: logging

RE: logging not working using log4j

2009-02-12 Thread Stanley, Eric
Young, Alistair [mailto:alistair.yo...@logica.com] Sent: Wednesday, February 11, 2009 9:18 AM To: user-java@ibatis.apache.org Subject: RE: logging not working using log4j Have you tried trying to force iBATIS to use log4j: LogFactory.selectLog4JLogging(); >From the JavaDoc: "This method wi

AW: logging not working using log4j

2009-02-11 Thread Leucht, Axel
gliche Nachricht- >>Von: Stanley, Eric [mailto:eric.r.stan...@qwest.com] >>Gesendet: Mittwoch, 11. Februar 2009 17:11 >>An: user-java@ibatis.apache.org >>Betreff: RE: logging not working using log4j >> >> >>Anyone have any thoughts on this? It's

Re: logging not working using log4j

2009-02-11 Thread Richard Yee
e- 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 Richard, It has always been in WEB-INF/classes, and I am positive its getting loaded properly. Like I mentioned bef

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 acti

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

RE: logging not working using log4j

2009-02-09 Thread Stanley, Eric
as all my selects are being populated properly. What am I missing? -Ryan -Original Message- From: Richard Yee [mailto:r...@cruzio.com] Sent: Sunday, February 08, 2009 5:30 PM To: user-java@ibatis.apache.org Subject: Re: logging not working using log4j Eric, Did you at least see more

Re: logging not working using log4j

2009-02-08 Thread Larry Meadors
This sounds like a class loading thing. Where are all the relevant jars and config files? Larry

Re: logging not working using log4j

2009-02-08 Thread Richard Yee
Eric, Did you at least see more logging messages? If not, this indicates that the log4j.properties file that you are editing is not in the classpath and is not getting read by the application. I'd suggest putting it in the WEB-INF/classes directory of your webapp. Otherwise, you can put

RE: logging not working using log4j

2009-02-08 Thread Stanley, Eric
Richard, I have set it to DEBUG, still nothing. -Ryan -Original Message- From: Richard Yee [mailto:r...@cruzio.com] Sent: Saturday, February 07, 2009 12:14 AM To: user-java@ibatis.apache.org Subject: Re: logging not working using log4j Set the rootlog level to debug. You might

Re: logging not working using log4j

2009-02-06 Thread Richard Yee
ne. My app, struts2 and tomcat are both using it without a problem. The only thing that's not logging is iBATIS. -Ryan -Original Message- From: Richard Yee [mailto:r...@cruzio.com] Sent: Friday, February 06, 2009 7:53 AM To: user-java@ibatis.apache.org Subject: Re: logging not work

RE: logging not working using log4j

2009-02-06 Thread Stanley, Eric
I notied that too in the docs. I guess that leads me to another question. iBATIS does JCL logging by default. I have the commons-logging jar in my tomcat lib dir so tomcat can use it. Should not iBATIS see the JCL that tomcat is using and try and use it? And if the log4j jar is loaded by the same

Re: logging not working using log4j

2009-02-06 Thread Nicholoz Koka Kiknadze
e. My app, struts2 and tomcat > are both using it without a problem. The only thing that's not logging > is iBATIS. > > -Ryan > > -Original Message- > From: Richard Yee [mailto:r...@cruzio.com] > Sent: Friday, February 06, 2009 7:53 AM > To: user-java@iba

RE: logging not working using log4j

2009-02-06 Thread Stanley, Eric
Richard, I know its being read. As I mentioned below, all other components of the app are using it just fine. My app, struts2 and tomcat are both using it without a problem. The only thing that's not logging is iBATIS. -Ryan -Original Message- From: Richard Yee [mai

Re: logging not working using log4j

2009-02-06 Thread Richard Yee
=org.apache.log4j.RollingFileAppender log4j.appender.R.File=log/pt.log log4j.appender.R.MaxFileSize=1MB log4j.appender.R.MaxBackupIndex=5 log4j.appender.R.layout=org.apache.log4j.PatternLayout log4j.appender.R.layout.ConversionPattern=%d [%t] %-5p %C %x - %m%n # SqlMap logging configuration

logging not working using log4j

2009-02-05 Thread Stanley, Eric
=org.apache.log4j.PatternLayout log4j.appender.R.layout.ConversionPattern=%d [%t] %-5p %C %x - %m%n # SqlMap logging configuration... log4j.logger.com.ibatis=DEBUG log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG log4j.logger.com.ibatis.sqlmap.engine.cache.CacheModel=DEBUG

RE: RE: Turning IBatis Logging off (in JBoss Server)

2009-01-09 Thread Poitras Christian
nt such logs, I change the log level to warning (info should be ok) in my own SqlMap implementations. Christian -Original Message- From: Daniel Bick [mailto:werbemai...@gmx.de] Sent: Friday, January 09, 2009 9:36 AM To: user-java@ibatis.apache.org Subject: Re:

Re: RE: Turning IBatis Logging off (in JBoss Server)

2009-01-09 Thread Daniel Bick
> Datum: Fri, 9 Jan 2009 08:51:21 -0500 > Von: Poitras Christian > An: "\'user-j...@ibatis.apache.org\'" > Betreff: RE: Turning IBatis Logging off (in JBoss Server) > Try setting java.sql to ERROR. > > > > > > Christia

RE: Turning IBatis Logging off (in JBoss Server)

2009-01-09 Thread Poitras Christian
Try setting java.sql to ERROR. Christian -Original Message- From: Daniel Bick [mailto:werbemai...@gmx.de] Sent: Friday, January 09, 2009 6:27 AM To: user-java@ibatis.apache.org Subject: Turning IBatis Logging off (in JBoss Server) Hi there! I have a little (or big

Turning IBatis Logging off (in JBoss Server)

2009-01-09 Thread Daniel Bick
Hi there! I have a little (or big?) Problem with my J2EE-Application using IBatis/Spring in an JBoss-Environment (IBatis 2.3.4, Spring 2.5 and JBoss 4.0.3SP1 <- The last one is a must have!). IBatis generates tons of debug-messages every time a SQL-Request is sent to the database (Oracle 10g2)

RE: [OT sort of] If using Tomcat, what would you use to hook into slqlmapclient flushDataCache (and change logging)?

2008-12-27 Thread Chris Lamey
ick [mailto:ric...@gmail.com] Sent: Fri 12/26/2008 3:19 PM To: user-java@ibatis.apache.org Subject: Re: [OT sort of] If using Tomcat, what would you use to hook into slqlmapclient flushDataCache (and change logging)? It's funny that link you posted is the ONLY link anyone ever posts or talks abo

Re: [OT sort of] If using Tomcat, what would you use to hook into slqlmapclient flushDataCache (and change logging)?

2008-12-26 Thread Rick
To: user-java@ibatis.apache.org > Subject: [OT sort of] If using Tomcat, what would you use to hook into > slqlmapclient flushDataCache (and change logging)? > > In this current Tomcat web app I'm going to need a way to A) switch > the logging level of the webapp on the fly (fro

RE: [OT sort of] If using Tomcat, what would you use to hook into slqlmapclient flushDataCache (and change logging)?

2008-12-26 Thread Chris Lamey
you use to hook into slqlmapclient flushDataCache (and change logging)? In this current Tomcat web app I'm going to need a way to A) switch the logging level of the webapp on the fly (from info/warn to maybe debug) and B) a way to manually flush all ibatis caches without restarting the applicati

[OT sort of] If using Tomcat, what would you use to hook into slqlmapclient flushDataCache (and change logging)?

2008-12-26 Thread Rick
In this current Tomcat web app I'm going to need a way to A) switch the logging level of the webapp on the fly (from info/warn to maybe debug) and B) a way to manually flush all ibatis caches without restarting the application. I see a SqlMapClient implementation has a flushDataCache meth

[OT sort of] If using Tomcat, what would you use to hook into slqlmapclient flushDataCache (and change logging)?

2008-12-26 Thread Rick
In this current Tomcat web app I'm going to need a way to A) switch the logging level of the webapp on the fly (from info/warn to maybe debug) and B) a way to manually flush all ibatis caches without restarting the application. I see a SqlMapClient implementation has a flushDataCache meth

Re: JDBC logging - sql query and bind variables sent via JDBC

2008-11-28 Thread Andreas Niemeyer
log level and activation of logging Regards, Andreas Kai Grabfelder schrieb: Hi Anreas, I'm not 100% sure but I don't think that there is a possibility to log this. I think you've already mentioned the two options that currently do exist. Regards Kai --- Original Nachri

Re: JDBC logging - sql query and bind variables sent via JDBC

2008-11-27 Thread Kai Grabfelder
ke to see "merged parameters with statements" in my logs, e.g. >> >> select * from emp where id = '4711' >> >> >> Options would are >> >> 1) an extended log4j configuration >> >> 2) or the usage of tools like P6Spy or

Re: JDBC logging - sql query and bind variables sent via JDBC

2008-11-26 Thread Andreas Niemeyer
lect * from emp where id = '4711' Options would are 1) an extended log4j configuration 2) or the usage of tools like P6Spy or JAMon for JDBC proxy logging The P6SPY project seems to be death over years and the jamonapi project doesn't take "log sql with real bind

JDBC logging - sql query and bind variables sent via JDBC

2008-11-23 Thread Andreas Niemeyer
Hi, I've seen some postings around this issue. I would like to see "merged parameters with statements" in my logs, e.g. select * from emp where id = '4711' Options would are 1) an extended log4j configuration 2) or the usage of tools like P6Spy or JAM

RE: P6Spy for logging SQL with value using iBatis in JDK 1.5

2008-10-02 Thread Shannon, Bryan
o get performance metrics for certain queries, etc.) -Original Message- From: mule_user [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 4:24 PM To: user-java@ibatis.apache.org Subject: P6Spy for logging SQL with value using iBatis in JDK 1.5 I have following questions on using P6Spy fo

P6Spy for logging SQL with value using iBatis in JDK 1.5

2008-09-30 Thread mule_user
I have following questions on using P6Spy for logging SQL (along with the values passed in the prepared statement) using iBatis in JDK 1.5. 1. Has anybody used P6Spy in WebSphere 6.1 (JDK 1.5)? 2. Does P6Spy require you to use its own database driver, and replace the standard database driver

Re: Logging Query Execution Time

2008-08-08 Thread Ian Zabel
gt; > On Fri, Aug 8, 2008 at 1:35 PM, Ian Zabel <[EMAIL PROTECTED]> wrote: >> Afternoon, all. >> >> I'd like to easily enable logging of the time it takes to run iBATIS queries. >> >> I found this article which is the basic idea >> http://www.le

Re: Logging Query Execution Time

2008-08-08 Thread Larry Meadors
PROTECTED]> wrote: > Afternoon, all. > > I'd like to easily enable logging of the time it takes to run iBATIS queries. > > I found this article which is the basic idea > http://www.learntechnology.net/content/misc/aop_oldskool.jsp But, it's > written to use the dep

Logging Query Execution Time

2008-08-08 Thread Ian Zabel
Afternoon, all. I'd like to easily enable logging of the time it takes to run iBATIS queries. I found this article which is the basic idea http://www.learntechnology.net/content/misc/aop_oldskool.jsp But, it's written to use the deprecated iBATIS DAO. Is there any built-in way to e

Re: Connection Pool Logging

2008-08-08 Thread Clinton Begin
Then it's completely up to the datasource provider. I think with WebLogic there was a connection pool stats feature, and I'd assume other app servers have something similar. Clinton On Fri, Aug 8, 2008 at 10:32 AM, Michael Schall <[EMAIL PROTECTED]> wrote: > We are using jndi. > > On Fri, Aug 8,

Re: Connection Pool Logging

2008-08-08 Thread Michael Schall
This is our transactionManager node On Fri, Aug 8, 2008 at 11:32 AM, Michael Schall <[EMAIL PROTECTED]>wrote: > We are using jndi. > > > On Fri, Aug 8, 2008 at 11:30 AM, Clinton Begin <[EMAIL PROTECTED]>wrote: > >> If you're using SImpleDataSource, then y

Re: Connection Pool Logging

2008-08-08 Thread Michael Schall
We are using jndi. On Fri, Aug 8, 2008 at 11:30 AM, Clinton Begin <[EMAIL PROTECTED]>wrote: > If you're using SImpleDataSource, then yes. You can cast the > datasource into a simpledatasource and you'll find a method called > getStatus() > > public String getStatus() { >StringBuffer buffer =

Re: Connection Pool Logging

2008-08-08 Thread Clinton Begin
If you're using SImpleDataSource, then yes. You can cast the datasource into a simpledatasource and you'll find a method called getStatus() public String getStatus() { StringBuffer buffer = new StringBuffer(); buffer.append("\n

Connection Pool Logging

2008-08-08 Thread Michael Schall
Is there a way to know when a connection is retrieved from the pool and returned to the pool and how long the request for a connection takes? I have looked at the ConnectionLogProxy, but I assume this is too late in the game. We already have the connection at that point? The problem I'm tring to

Re: iBATIS logging

2008-04-21 Thread Filipe David Manana
Now it works great :) Thanks a lot On Mon, Apr 21, 2008 at 5:51 PM, Jeff Butler <[EMAIL PROTECTED]> wrote: > Commons logging (JCL) is insidious and is almost always in the classpath > (WebSphere, Tomcat, etc. always have JCL in the classpath). Try this line > of code to forc

Re: iBATIS logging

2008-04-21 Thread Jeff Butler
Commons logging (JCL) is insidious and is almost always in the classpath (WebSphere, Tomcat, etc. always have JCL in the classpath). Try this line of code to force iBATIS to use log4j: com.ibatis.common.logging.LogFactory.selectLog4JLogging(); You should execute this at application startup

iBATIS logging

2008-04-21 Thread Filipe David Manana
empty. I have been googling and some people say to remove commons-logging from the classpath. I don't it in my classpath, although the problem persists. Any suggestion? Am I doing something wrong? cheers -- Filipe David Manana, [EMAIL PROTECTED] "The cruellest lies are often told in silence."

Re: Logging Problem with IBATIS

2007-12-20 Thread Jeff Butler
Look here: http://www.mail-archive.com/user-java@ibatis.apache.org/msg06898.html You'll get a different class depending on whether logging is enabled or not. You will need to use introspection to determine if you are getting the proxy class, and then pulled the proxied resultSet out if yo

Logging Problem with IBATIS

2007-12-20 Thread Chetan Nayak
I used to use IBATIS logging to print out my log statements ,after a while i stareted using Oracle Xml Type Handler ,This is a custom type handler writtent to manage XMLType datatype ,when i do this my logging fails so does my query . The error i get is ,The result returned is not a valid

Java logging API and ibatis

2007-12-04 Thread Ashish Kulkarni
Hi How can i use java logging API to control logging of ibatis, for example if i have log4j, i put all the logging information in log4j.xml and from there i can control what logs i want from ibatis, for example i have added following lines in log4j.xml So waht would i do if i am using

Re: Logging oddity

2007-11-13 Thread Gwyn Evans
Ah, thanks... I've added a page to that effect below the "Not Yet Documented" page on the Wiki. /Gwyn On 13/11/2007, Jeff Butler <[EMAIL PROTECTED]> wrote: > This is related to a structural defect in the way iBATIS does logging. > iBATIS does logging through dynam

Re: Logging oddity

2007-11-13 Thread Jeff Butler
This is related to a structural defect in the way iBATIS does logging. iBATIS does logging through dynamic proxies for all the JDBC objects - and these objects are only proxied if the Connection object itself is proxied. The Connection object is proxied only if debugging is enabled for it. So

Logging oddity

2007-11-13 Thread Gwyn Evans
Hi - wonder if anyone can explain this... I'm testing with ibatis & am finding that if I have java.sql.Connection = Info java.sql.PreparedStatement = Debug java.sql.ResultSet = Debug then I don't get *any* ibatis logging, but if I change just the java.sql.Connection value to Deb

strange output from result set logging

2007-09-14 Thread Albert N Hinrichs
Sorry if this hits twice, I'm new to the list. IBatis seems to be working fine, but, when showing logging output, we get strange outputs on result sets. For every column that has a typehandler, we get multiple instances (apparently) in the header and values in the log. For instance:

Re: Ibatis and JakartaCommonsLoggingImpl logging question

2007-08-24 Thread Jeff Butler
It depends on what else is using it. I think upgrading iBATIS would be safer. Jeff Butler On 8/24/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > > Hi > What is the effect of removing commons-logging from classpath? > > On 8/24/07, Jeff Butler <[EMAIL PROTECTED] >

Re: Ibatis and JakartaCommonsLoggingImpl logging question

2007-08-24 Thread Ashish Kulkarni
Hi What is the effect of removing commons-logging from classpath? On 8/24/07, Jeff Butler <[EMAIL PROTECTED]> wrote: > > You need to configure JCL. This could be as simple as following the > instructions found here: > > http://commons.apache.org/logging/ > > Or,

Re: Ibatis and JakartaCommonsLoggingImpl logging question

2007-08-24 Thread Jeff Butler
You need to configure JCL. This could be as simple as following the instructions found here: http://commons.apache.org/logging/ Or, depending on your operating environment, you may need to do some other work. For example, WebSphere supplies it's own implementation of JCL that mu

Re: Ibatis and JakartaCommonsLoggingImpl logging question

2007-08-24 Thread Ashish Kulkarni
Hi I am using ibatis 2.1.5 , and setting log file is only for 2.2 and above. so i cannot use it, but there are no ibatis debug logs, but logs from JakartaCommonsLoggingImpl Is there some thing i need to add to log file to contral logging by this class Ashish On 8/23/07, Jeff Butler <[EM

Re: Ibatis and JakartaCommonsLoggingImpl logging question

2007-08-23 Thread Jeff Butler
Jakarta Commons Logging (JCL) must be in your classpath somewhere. By default, iBATIS will use JCL if it finds it. If you want to force Log4j, then you'll need to tell iBATIS to use Log4j even if it finds JCL. This is documented on page 62 of the developer's guide. Jeff Butler

Ibatis and JakartaCommonsLoggingImpl logging question

2007-08-23 Thread Ashish Kulkarni
Hi I am using log4j for logging and added the following XML elements in my configuration file, but i still get the log file as below, how do i supress these logs from coming in stdout file 2007-08-23 16:50:12,935 DEBUG [http-4080-Processor25] jakarta.JakartaCommonsLoggingImpl

RE: Logging SQL statements

2007-03-23 Thread James, Steven
Why not just put a dynamic proxy in front of your service layer and log them there. -Original Message- From: Murtaza Goga [mailto:[EMAIL PROTECTED] Sent: Freitag, 23. März 2007 13:04 To: user-java@ibatis.apache.org Subject: RE: Logging SQL statements It would. You could extend the

RE: Logging SQL statements

2007-03-23 Thread Murtaza Goga
It would. You could extend the FileAppender in Log4J and filter out the selects. Not as elegant but it would work. -Original Message- From: K1RUHA [mailto:[EMAIL PROTECTED] Sent: Friday, March 23, 2007 7:37 AM To: user-java@ibatis.apache.org Subject: RE: Logging SQL statements But

RE: Logging SQL statements

2007-03-23 Thread K1RUHA
vity from iBatis into a separate file. The category I believe is > "java.sql." > > > > > > From: K1RUHA [mailto:[EMAIL PROTECTED] > Sent: Friday, March 23, 2007 6:59 AM > To: user-java@ibatis.apache.org > Subject: Logg

RE: Logging SQL statements

2007-03-23 Thread Murtaza Goga
user-java@ibatis.apache.org Subject: Logging SQL statements Hello. I'd like to use iBATIS in our project, but I have one requierent, that I don't know if it supports. I need to log SQL statements that modify database (UPDATE and DELETE) into separate file. So I need some approach to get these s

RE: Logging SQL statements

2007-03-23 Thread K1RUHA
2007 12:09 > To: user-java@ibatis.apache.org > Subject: RE: Logging SQL statements > > > > Hi There Kiryl, > > > > I'd suggest looking at http://sourceforge.net/projects/p6spy/ which can be > used in conjunction with Ibatis to provide this functionality

RE: Logging SQL statements

2007-03-23 Thread James, Steven
Does your database not provide an audit facility? From: Damien McCarthy [mailto:[EMAIL PROTECTED] Sent: Freitag, 23. März 2007 12:09 To: user-java@ibatis.apache.org Subject: RE: Logging SQL statements Hi There Kiryl, I'd suggest looking at

RE: Logging SQL statements

2007-03-23 Thread Damien McCarthy
-java@ibatis.apache.org Subject: Logging SQL statements Hello. I'd like to use iBATIS in our project, but I have one requierent, that I don't know if it supports. I need to log SQL statements that modify database (UPDATE and DELETE) into separate file. So I need some approach to get thes

Logging SQL statements

2007-03-23 Thread K1RUHA
if iBATIS can do this? Thanx, Kiryl -- View this message in context: http://www.nabble.com/Logging-SQL-statements-tf3453072.html#a9632495 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Logging problem

2007-02-20 Thread Koka Kiknadze
I'm debugging multithreaded application for connection leaks and found that iBatis logging is not quite helpful. E.g. I have output like: 2007-02-20 17:15:17,406 DEBUG [com.ibatis.common.jdbc.SimpleDataSource] - Created connection 30426707. 2007-02-20 17:15:17,406 DEBUG [java.sql.Conne

RE: Enabling Logging

2006-06-20 Thread Tarek Nabil
y, June 20, 2006 12:09 PMTo: user-java@ibatis.apache.orgSubject: RE: Enabling Logging I don’t know if you have found a solution for your problem, but we had the same problem in our company …   We use RESIN for our local development and it seems we had to run the application on port 8080 t

RE: Enabling Logging

2006-06-20 Thread Tom Stroobants
I don’t know if you have found a solution for your problem, but we had the same problem in our company …   We use RESIN for our local development and it seems we had to run the application on port 8080 to get the logging … It wouldn’t work on any other port …   No need to blaim iBATIS

Re: Enabling Logging

2006-06-12 Thread Brandon Goodin
Not completely. iBATIS is not in the business of being a logging abstraction tool. All it is going to look for is the particular logging system someone wants to use. If commons-logging is in the classpath then the assumption is being made that a) it is being used to delegate to another logging

RE: Enabling Logging

2006-06-12 Thread Tarek Nabil
But Jeff, isn't that how commons logging is used? If you have commons logging, you will probably also have log4j or some other implementation. Log4j/JDK 1.4 logging will be responsible for configuration and actually doing the logging, commons logging is just a layer above that. From:

Re: Enabling Logging

2006-06-11 Thread Ben Munat
To answer Nathan: I'm not looking for any specific ibatis logging... Tarek was commenting that he couldn't get any ibatis debug statements... I just thought it was strange that I'd never seen anything either. To answer Jeff: I've done all my projects on tomcat (except on

Re: Enabling Logging

2006-06-11 Thread Jeff Butler
Most of my projects are WebSphere projects.  I can see iBATIS logging statements in the WebSphere logs - but WebSphere uses it's own internal logging implementation to hook into commons logging.  So I wrote this FAQ about how to see logging statements in WebSphere because it's not as sim

Re: Enabling Logging

2006-06-11 Thread Nathan Maves
What kind of logging are you looking for from the com.ibatis.* package? Nathan On Jun 11, 2006, at 2:43 PM, Ben Munat wrote: Well, I don't know about Tarek, but I've always used commons- logging with log4j underneath... so both are on my classpath. I've used ibatis on sever

Re: Enabling Logging

2006-06-11 Thread Ben Munat
Well, I don't know about Tarek, but I've always used commons-logging with log4j underneath... so both are on my classpath. I've used ibatis on several projects now, and thinking back, I don't recall ever seeing ibatis log statements, though I always put com.ibatis an

Re: Enabling Logging

2006-06-11 Thread Jeff Butler
It's also good to remember that iBATIS will use commons logging if it finds it in the classpath (for example, WebSphere has commons logging on the application server classpath QED iBATIS allways uses commons logging on WebSphere).   The search order for log implementations is:   1. co

Re: Enabling Logging

2006-06-11 Thread Brandon Goodin
We pulled out commons logging because we wanted zero dependencies and it was such an insignificant amount of code. It seemed silly to create dependencies for such a small amount of code. We are not going to add commons logging. But, we will fix our logging if it is not functioning :) If this is a

Re: Enabling Logging

2006-06-11 Thread Ben Munat
Yeah it's a strange name/location but it should work... and Tarek claims to be getting other log output to that file... and Tarek's question made me realize that I've never actually been getting com.ibatis logging in my log files. So, I think there's a legitimate question

Re: Enabling Logging

2006-06-11 Thread Graeme J Sweeney
On Sun, 11 Jun 2006, Tarek Nabil wrote: log4j.appender.RollingFile.File=c:/customs.log c:\customs.log ? -- Graeme -

  1   2   >