Re: pdf still has incorrect dtd!

2006-05-04 Thread Sven.Boden
Use http://svn.apache.org/repos/asf/ibatis/trunk/java/docs/iBATIS-SqlMaps-2.pdf for now, the URL on the website still points to the CVS version. Don't make a JIRA for it. Clinton, any chance of changing the URL? Regards, Sven >- Oorspronkelijk bericht - >Van: Ben Munat [mailto:[EMAIL

Transactions using DaoManager

2006-05-04 Thread Rajaram_Viswanathan
Hello, I manage the transactions manually using DaoManager   My code looks like this:   class BaseService{     private static BaseDAO baseDao = null;    static {    //get Base DAO    baseDao = (BaseDAO)DaoConfig.getDaomanager().getDao(BaseDAO.class);    } .. . }       Class MyService 

Re: Cahcing in IBATIS

2006-05-04 Thread Tom . Stroobants
Seems like it had to do some extra reading. The ticket on Jira is indeed closed and it was considered as a bug. http://issues.apache.org/jira/browse/IBATIS-93 "Sven.Boden" <[EMAIL PROTECTED]> 04/05/2006 15:54 To user-java@ibatis.apache.org cc Subject Re: Cahcing in IBATIS

RE: A separate transaction for the logger

2006-05-04 Thread Rajaram_Viswanathan
Hello RS, If you are using Oracle SP to do the logging stuff,the seperate transaction could be achieved by defining that Logging Store procedure as PRAGMA AUTONOMOUS TRANSACTION; This would suspend the main transaction and would only commit the statements within it. http://www.stanford.edu/dep

RE: Capability to use dynamic sql within iterates

2006-05-04 Thread MCCORMICK, Paul
Title: Capability to use dynamic sql within iterates I did some further testing after reading issue 131 http://issues.apache.org/jira/browse/IBATIS-131   I found that  and tags work in this situation but other tags like do not work.  Has anybody got the tag to work in the sistuation below?

Sequence table design issues with iBatis

2006-05-04 Thread David Broderick
I am new to iBatis so my apologies if this information is in the mailing list or documentation somewhere that I missed (or did not understand). I am using iBatis 2.1.7.597, MySQL 4.1.2, MySql-Connector 3.1.12. My problem is that I have a GlobalSequence table (since MySql 4.1.12 does not supp

Capability to use dynamic sql within iterates

2006-05-04 Thread MCCORMICK, Paul
Title: Capability to use dynamic sql within iterates Hello I have read Issue 148 and it looks like I can use dynamic sql within an iterate tag http://issues.apache.org/jira/browse/IBATIS-148 I have a problem when I set the property on a tag to be a value on the iterated object.  See "my

RE: A separate transaction for the logger

2006-05-04 Thread rs
Am actually looking for a solution that does not involve Spring and/or AOP. We've got too many frameworks as it is :) > ...define that the LoggingDao gets a new transaction as opposed to > participating within the current transaction. This would suspend any current > transaction and begin a n

RE: A separate transaction for the logger

2006-05-04 Thread Christopher . Mathrusse
If you were to use the Spring Framework you could write a new Dao, LoggingDao, to handle inserts of your logging statements and define that the LoggingDao gets a new transaction as opposed to participating within the current transaction. This would suspend any current transaction and begin a

pdf still has incorrect dtd!

2006-05-04 Thread Ben Munat
Hey guys, I just noticed that the java sqlMap pdf on the website has still not been updated with the new dtd that's bad. Could we get that fixed soon? Shouldn't take too long right? Should I put in an issue on it? b

A separate transaction for the logger

2006-05-04 Thread rs
Hi, Am using a single static instance of SqlMapClient for all my DAOs. There's a need to save some logging info into the database regardless if the application logic fails or not, i.e. there is a need to start a separte transaction for logger. Illustration: // application logic ... SQL_MAPPE

Re: Just curious - How cloesly do your value objects back the data model?

2006-05-04 Thread Rick Reumann
Nevermind my rambling.. I was just being stupid and overthinking stuff. Company in an Employee makes sense. On 5/4/06, Rick Reumann <[EMAIL PROTECTED]> wrote: On 5/4/06, Eric T. Blue <[EMAIL PROTECTED]> wrote: > Typically, you would/should not expose properties that are used in deriving > a data

Re: Just curious - How cloesly do your value objects back the data model?

2006-05-04 Thread Rick Reumann
On 5/4/06, Eric T. Blue <[EMAIL PROTECTED]> wrote: Typically, you would/should not expose properties that are used in deriving a database relationship. These type of id properties are called surrogate keys and do not have any real business meaning. I'd recommend modeling your objects as Employe

RE: boolean type handler

2006-05-04 Thread Paul Allen
I think that I found the problem. The ProjUser bean had both a java.lang.Boolean getPaid() accessor and boolean isPaid() accessor. I suspect that confused IBATIS, although I can't change the ProjUser bean to confirm it. At 01:37 PM 5/3/2006, Niels Beekman wrote: I think you should remove the jdb

Re: Just curious - How cloesly do your value objects back the data model?

2006-05-04 Thread Eric T. Blue
Typically, you would/should not expose properties that are used in deriving a database relationship.  These type of id properties are called surrogate keys and do not have any real business meaning.  I'd recommend modeling your objects as Employee -> Company, and let SQL do your joins on the id col

Just curious - How cloesly do your value objects back the data model?

2006-05-04 Thread Rick Reumann
I'm often torn when developing web applications how Object Oriented I should build my value objects. For examle... You might have an Employee table... employeeId employeeName companyId //.. Do you guys typically have your Employee value object hold "Integer companyId" or instead populate the co

Re: how to turn of logging when ibatis runs the query

2006-05-04 Thread radha rukmani
Hi   I added this to my config and it works,   log4j.logger.java.sql.ResultSet=OFF log4j.logger.java.sql.Connection=OFF log4j.logger.java.sql.PreparedSatement=OFF log4j.logger.com.ibatis=OFF   Thank you so much for your help   Graeme J Sweeney <[EMAIL PROTECTED]> wrote: On Thu, 4 May 2

Re: how to turn of logging when ibatis runs the query

2006-05-04 Thread radha rukmani
My log4j property file looks like this, it does not have anything related to ibatis.   log4j.appender.A1.layout=org.apache.log4j.PatternLayout log4j.appender.A1.layout.ConversionPattern=%d %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n log4j.appender.A2=org.apache.log4j.RollingFileAppender log4j.appe

Re: how to turn of logging when ibatis runs the query

2006-05-04 Thread Sven Boden
Default it should be off... find the log4j.properties and tweak the following: # Global logging configuration log4j.rootLogger=ERROR, stdout # SqlMap logging configuration... #log4j.logger.com.ibatis=DEBUG #log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG #log4j.logger.com.ibatis.s

Re: how to turn of logging when ibatis runs the query

2006-05-04 Thread Graeme J Sweeney
On Thu, 4 May 2006, radha rukmani wrote: Is there a way to turn of the result set logging I use log 4j and havent written any logging statement for ibatis queries, it comes by itself What about this in your log4j configuration ? log4j.logger.java.sql.ResultSet=OFF -- Graeme -

how to turn of logging when ibatis runs the query

2006-05-04 Thread radha rukmani
Hi   I want to turn of the result set logging when ibatis runs the queries. I need only the sql to be logged. Since mine is a batch process, with huge number of queries, the log file it generates after each process is more than 50. Is there a way to turn of the result set logging I use log 4j and

Re: Cahcing in IBATIS

2006-05-04 Thread Sven.Boden
Hi, For 1) which JIRA... most of the JIRA's on caching have been closed as invalid. iBatis doesn't use object identity in caching and some people assume it does, leading to some unfounded JIRA's 2) does not exist yet, and will probably also not exist in the future. In the version in SVN you c

Cahcing in IBATIS

2006-05-04 Thread Tom . Stroobants
Hi all, I have a question about the caching implementation of IBATIS. 1. In the JIRA I saw that there was a bug concerning the FlushOnExecute statement. Is this solved ? 2. Does there exist a tool to check the status of the caching objects in Ibatis ? Some nice looking webpage tool that would a