YesNoTypeHandler - create problem in parameterMap

2006-11-17 Thread Tamilselvan Radha Krishnan
Hi, I'm trying to use the YesNoBooleanTypeHandler conversion between java boolean to jdbc CHAR (Y or N) vice versa. I can able to retrieve the boolean values (isDeleted) into my POJO class. But when I do select query using 'isDeleted', then it throws the below exception: Can you help me where I'

read-write cache with external transaction manager

2006-11-17 Thread Bertelsen, Mattias
We're having a problem with read-write non-serializable caching, using an external transaction manager (JTA) and JBoss's local-tx datasource. This refers to iBATIS 2.1.7.597 and the docs that shipped with it. In the pdf Data Mapper Developer Guide, it says that with a read-write cache, caching

Re: Fw: ibatis with Spring performance issue.

2006-11-17 Thread Brandon Goodin
High CPU utilization usually means that something is not setup correctly in your tests. I would echo Chris' sentiment. I'd like to see how you are initializing the spring/ibatis as well as a breakdown of your testing metrics. Brandon On 11/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Pl

Re: StackOverflowError on SqlMapClientBuilder.buildSqlMapClient

2006-11-17 Thread Larry Meadors
I do not see anything in that stack trace that leads me to believe iBATIS is involved in any way. I'd take a closer look at the gnu.xml.pipeline.ValidationConsumer$ChildrenRecognizer stuff, wherever that is coming from. Larry On 11/17/06, Gary Griffin <[EMAIL PROTECTED]> wrote: Hi! I'm new

StackOverflowError on SqlMapClientBuilder.buildSqlMapClient

2006-11-17 Thread Gary Griffin
Hi! I'm new to iBatis and am trying to implement it in some of my code that's running in a J2EE enivronment on JBoss. Using the following code, I get a StackOverflowError: try { // neither my SqlMapConfig file nor the example one delivered with iBatis seems to work: St

Re: Fw: ibatis with Spring performance issue.

2006-11-17 Thread Chris Lamey
Both the JDBC test driver and the Spring/iBATIS test driver code would be helpful. I'd also be interested to see how you're initializing your Spring context as well. And if you could get the JMeter CPU utilization chart broken down by Class/Method might help too. Cheers, Chris On Fri, 2006-11-1

Re: Fw: ibatis with Spring performance issue.

2006-11-17 Thread Sanjay_Deshpande
Please let me know what kind of information you need that will help you I will be glad to give you the information. I have already provided you our Sqlmap_config file details. We are doing a simple select statement. We are basically simulating the load on WAS 6.1 using JMeter and trying to compar

Re: Ibatis - DB2 Universal Driver problem

2006-11-17 Thread Jeff Butler
What's your iBATIS version? The current version always calls "execute" - not executeQuery or executeUpdate. Also - if the procedure doesn't return a result set, make sure you'r calling it with the iBATIS update or insert API - not queryForObject or queryForList. Jeff Butler On 11/17/06, smit

RE: Ibatis - DB2 Universal Driver problem

2006-11-17 Thread smita_b
no. i am using {call $dbid$.SCSP0006(?,?,?,?,?,?,?,?,?)} Randy Layman wrote: > > > The problem is likely in the > com/aoc/ito/atoms/ibatis/SCSP0006.xml file. From the error message I > would guess you are using a element instead of a > element to call a stored procedure. > >

Re: Missing Type-Conversion with Postgres-Jdbc-Driver 8.1-407

2006-11-17 Thread D. Richter
selectKey has to return the type of the Java-Object-Member, so string is ok (int doesn't work). If I choose the type int for the member id, then it works too, but the String should be converted, because I specified the destination-type as INTEGER. Thank You Dennis Original-Nachricht ---

RE: Ibatis - DB2 Universal Driver problem

2006-11-17 Thread Randy Layman
The problem is likely in the com/aoc/ito/atoms/ibatis/SCSP0006.xml file. From the error message I would guess you are using a element instead of a element to call a stored procedure. Randy -Original Message- From: smita_b [mailto:[EMAIL PROTECTED] Sent: Friday, Nove

RE: How to use DaoManager -- single or more

2006-11-17 Thread Chris Lamey
No, it's threadsafe. One rollback/commit on one thread won't affect something going on in another thread. On Fri, 2006-11-17 at 22:23 +0530, Tamilselvan Radha Krishnan wrote: > Tony, > We have already started the work and currently using the DAOManager per > user. I read that it can be loaded on

Ibatis - DB2 Universal Driver problem

2006-11-17 Thread smita_b
Hi, We are migrating from WAS 5.1 to WAS 6.0 and also changing from DB2 Legacy CLI-based Type 2 JDBC driver to DB2 Universal Driver. Everything works fine with DB2 Legacy CLI-based Type 2 JDBC driver in WAS 6.0 but gives an exception with DB2 Universal Driver as follows. I am assuming something

RE: How to use DaoManager -- single or more

2006-11-17 Thread Tamilselvan Radha Krishnan
Tony, We have already started the work and currently using the DAOManager per user. I read that it can be loaded once while application started and can be used simultaneously. But I'm starting/closing transaction using daoMgr.startTransaction() and daoMgr.endTransaction() to commit or roll back t

Re: IBATIS and mulit-vendor development (Oracle/Derby)

2006-11-17 Thread Slava Imeshev
Guido, Thanks for the tip! Slava --- Guido García Bernardo <[EMAIL PROTECTED]> wrote: > I faced this problem, too, and I finally wrote one sql-map file per > dialect (oracle and mysql in my case). > > In my sql-map-config.xml I put something like: > > > "http://www.ibatis.com/dtd/sql-map-

Re: Missing Type-Conversion with Postgres-Jdbc-Driver 8.1-407

2006-11-17 Thread Brandon Goodin
you selectKey is returning a "string". shouldn't it return an "integer"? Brandon On 11/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, I have the following problem: I have a simple object public class MyObject { private String id = ""; public String getId() { return id; } public

Missing Type-Conversion with Postgres-Jdbc-Driver 8.1-407

2006-11-17 Thread dr-ibatis
Hello, I have the following problem: I have a simple object public class MyObject { private String id = ""; public String getId() { return id; } public void setId(String id) { this.id = id; } } , a database with a table CREATE TABLE myobject(id serial NOT NULL) and a map-file

Re: Fw: ibatis with Spring performance issue.

2006-11-17 Thread Brandon Goodin
The monthly ambiguous performance question. If you are going to make question/statements on performance, please provide better information about how your reached the conclusion that prompted the question. Otherwise your question is akin to asking how big the universe is. Thanks :) Brandon On 11/

Re: How to use DaoManager -- single or more

2006-11-17 Thread Tony Qian
Tamil, If you just started, it's better to integrate iBATIS with Spring DAO. I noticed from mailing list that iBATIS team is going to deprecate the iBATIS DAO. Tony Tamilselvan Radha Krishnan wrote on 11/17/2006, 10:36 AM: > Hi, > We are newly using ibatis framework as DAO layer for our work

How to use DaoManager -- single or more

2006-11-17 Thread Tamilselvan Radha Krishnan
Hi, We are newly using ibatis framework as DAO layer for our work. I understand that DaoManager can be used create DAO references. Also it is used to control the database JDBC transactions as well like Connection in JDBC. My question is should I maintain one DaoManager for all users. Or each u

Fw: ibatis with Spring performance issue.

2006-11-17 Thread Sanjay_Deshpande
Any ideas why the CPU usage is more when using Ibatis vs regular JDBC. Thanks. Regards, Sanjay x7273 - Forwarded by Sanjay Deshpande/IT/Quixtar on 11/17/2006 09:50 AM - Sanjay

RE: select list: expression values !

2006-11-17 Thread c . zecca
"Randy Layman" <[EMAIL PROTECTED]> scritti il 17/11/2006 15:39:24 > > I think your problem might be that your SQL doesn't have a > result column ELEMENTO. I believe you should change your SQL to: > select > TIPO_RIGA_ID, ELEMENTO - 1 AS ELEMENTO, NOME, TIPO_ELEMENTO_ID > from TIPI_DATO_RIGA

Re: IBATIS and mulit-vendor development (Oracle/Derby)

2006-11-17 Thread Guido García Bernardo
I faced this problem, too, and I finally wrote one sql-map file per dialect (oracle and mysql in my case). In my sql-map-config.xml I put something like: "http://www.ibatis.com/dtd/sql-map-config-2.dtd";> ... With a configuration file (ibatis.properties) with an entr

Re: select list: expression values

2006-11-17 Thread Jeff Butler
You might need to do this: select elemento - 1 as elemento, ... sometimes databases rename these calculated columns. If you run the query in the Squirrel SQL client you can see exactly what's happening. Jeff Butler On 11/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi all The foll

RE: select list: expression values

2006-11-17 Thread Randy Layman
I think your problem might be that your SQL doesn't have a result column ELEMENTO. I believe you should change your SQL to: select TIPO_RIGA_ID, ELEMENTO - 1 AS ELEMENTO, NOME, TIPO_ELEMENTO_ID from TIPI_DATO_RIGA where tipo_dato_id = #id:INTEGER# so that the result set contains the correc

select list: expression values

2006-11-17 Thread c . zecca
Hi all The following SQL map and query select TIPO_RIGA_ID, ELEMENTO - 1, NOME, TIPO_ELEMENTO_ID from TIPI_DATO_RIGA where tipo_dato_id = #id:INTEGER# raises t