RE: Can't connect to Oracle DB when using rownum in iBatis3

2010-04-14 Thread meindert
You can’t use the ‘’ character, it is seen as a xml opening tag. Use lt; instead Or escape the whole query with !-- -- From: 陈抒 [mailto:csfreeb...@gmail.com] Sent: 14 April 2010 08:02 AM To: user-java@ibatis.apache.org Subject: Can't connect to Oracle DB when using rownum in iBatis3

iBatis mail-archive

2010-02-23 Thread meindert
From: Valentina Fabrizi [mailto:fabrizi_valent...@yahoo.it] Today, I have some troubles with iBatis mail-archive I try to send a reply to user-java@ibatis.apache.org or user-java-i...@ibatis.apache.org but always I received an e-mail from the administrative commands for the user-java

RE: iBatis mail-archive

2010-02-23 Thread meindert
with you! Yesterday I subscribed at first...infact, yesterday I was able to send and read messages This morning I don't able to send you a grateful reply.so I decided to send a direct mail to you! _ Da: meindert meind...@eduflex.com A: Valentina Fabrizi fabrizi_valent

RE: How to map a dynamic condition on Left Outer Join

2010-02-22 Thread meindert
to cut off the first 'AND' to make the where clause correct. Meindert From: Valentina Fabrizi [mailto:fabrizi_valent...@yahoo.it] Sent: 22 February 2010 01:23 PM To: user-java@ibatis.apache.org Subject: How to map a dynamic condition on Left Outer Join Hello and have a nice day! I try

RE: How to map a dynamic condition on Left Outer Join

2010-02-22 Thread meindert
That’s strange, it is just as straightforward as the code shows... What does the query look like in the log file? Must say I’m using dynamic a lot myself.. Sorry Meindert From: Valentina Fabrizi [mailto:fabrizi_valent...@yahoo.it] Sent: 22 February 2010 03:45 PM To: user-java

IBATIS + GWT +Log4j

2010-02-18 Thread meindert
/gwt-hosted-mode-and-log4j/ Kind Regards Meindert Hoving attachment: winmail.dat - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org

RE: IBATIS + GWT +Log4j

2010-02-18 Thread meindert
I found the 'solution' right after posting the question (isn't it always like that J) I had the commons logging jar on my classpath, after removing this jar the logging works as intended. From: meindert [mailto:meind...@eduflex.com] Sent: 18 February 2010 03:30 PM To: user-java

RE: Mapper behaving differently between Eclipse and Maven

2010-02-16 Thread meindert
I didn't read your whole mail and am not using ibatis3 but; select id=selectExpensePeriods resultType=java.util.Date select expense_date, extract(YEAR_MONTH from expense_date) as period from expense group by period; /select How would you expect the period to be passed to the

RE: java.util.UUID to postgres uuid column

2010-02-11 Thread meindert
, can be used on the uniqueidentifier data type. Merge replication and transactional replication with updating subscriptions useuniqueidentifier columns to guarantee that rows are uniquely identified across multiple copies of the table. Regards Meindert Hoving From: Vikram Subbarao

RE: how to concate a string in insert statement using ibatis?

2010-01-28 Thread meindert
Best option is to do it on the java side, otherwise you can use 'abc?orderId?' what will insert (sql inject!) the literal value of orderId in your query -Original Message- From: suprememenu [mailto:shaik...@gmail.com] Sent: 28 January 2010 11:55 AM To: user-java@ibatis.apache.org Subject:

RE: how to write Sql query in system out or to a log using ibatis?

2010-01-28 Thread meindert
That question comes up a lot, you can log the actual query if you switch log4j logging on (see documentation) but a) I wouldn't know a easy way to get the query back to your code b) The query is parameterized, the parameter values are in the log Meaning you can get the query string like select

RE: com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance

2009-12-21 Thread meindert
I can be wrong but isn't sqljdbc.jar for MS sql server? You are using the mysql for the driver class -Original Message- From: nath1 [mailto:vishwanath.manch...@yahoo.co.in] Sent: 21 December 2009 01:46 PM To: user-java@ibatis.apache.org Subject: com.ibatis.sqlmap.client.SqlMapException:

RE: Transactionality using ibatis

2009-12-01 Thread meindert
Meindert -Original Message- From: naveendutt [mailto:naveendutt.v...@gmail.com] Sent: 01 December 2009 11:56 AM To: user-java@ibatis.apache.org Subject: Transactionality using ibatis Hi All, I am using weblogic portal and for database insertion and all, ibatis. i am facing issues in how

RE: Error calling Connection.setAutoCommit:

2009-11-18 Thread meindert
Not sure what the difference is, but I'm using the validationQuery property to check the connection; property name=validationQuery value= select top 1 'niks' from DUAL / The second thing I noticed is that 'select 1 from DUAL' will return all rows in DUAL, shouldn't you use 'select top 1 * from

RE: Error calling Connection.setAutoCommit:

2009-11-18 Thread meindert
DUAL / property name=poolPingEnabled value=true / meindert-3 wrote: Not sure what the difference is, but I'm using the validationQuery property to check the connection; property name=validationQuery value= select top 1 'niks' from DUAL / The second thing I noticed is that 'select 1 from

RE: caching question

2009-10-22 Thread meindert
It's the result you cache not the query. How many different query result would you like to cache -Original Message- From: Odelya YomTov [mailto:ode...@jpost.com] Sent: 22 October 2009 02:29 PM To: user-java@ibatis.apache.org Subject: caching question Hi! I have a global question about

RE: caching question

2009-10-22 Thread meindert
- From: meindert [mailto:meind...@eduflex.com] Sent: Thursday, October 22, 2009 3:01 PM To: user-java@ibatis.apache.org Subject: RE: caching question It's the result you cache not the query. How many different query result would you like to cache -Original Message- From: Odelya YomTov

skip Results, maxResults in statement

2009-10-16 Thread meindert
# AND Row lt;= #paging.endRow# /isNotNull ORDER BY isNull property=paging.sortBy[default sorting column] DESC/isNull isNotNull property=paging.sortBy$paging.sortBy$ $paging.sortorder$/isNotNull Meindert Hoving

RE: can IBATIS handle mysql DATE keyword?

2009-10-14 Thread meindert
Off the top of my head that would be , # and $ -Original Message- From: jrhitokiri [mailto:jrhitok...@gmail.com] Sent: 14 October 2009 01:02 PM To: user-java@ibatis.apache.org Subject: RE: can IBATIS handle mysql DATE keyword? I tried it. It works now. Wow, and I was stumped on that

RE: Database Connection reset on Oracle 10g AS using Oracle 11g database

2009-10-06 Thread meindert
I'm using; bean id=propertyConfigurer class=org.springframework.beans.factory.config.PropertyPlaceholderConfigure r property name=location value=WEB-INF/config.properties / /bean bean id=dataSource class=org.apache.commons.dbcp.BasicDataSource destroy-method=close

Slow parameterised query

2009-09-30 Thread meindert
to fix it? Meindert Hoving attachment: winmail.dat - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org

RE: like issue plz help me

2009-09-23 Thread meindert
Or '%$name$%', but that opens up the vulnerability for sql injection -Original Message- From: Mikel sanchez [mailto:mikel.sanchez...@gmail.com] Sent: 23 September 2009 02:08 PM To: user-java@ibatis.apache.org Subject: Re: like issue plz help me Can you modify name to include %,

RE: Problem with connecting

2009-09-08 Thread meindert
it? -Original Message- From: meindert [mailto:meind...@eduflex.com] Sent: Tuesday, September 08, 2009 2:52 PM To: user-java@ibatis.apache.org Subject: RE: Problem with connecting I would add the validationQuery to the datasource, not sure if it helps in your case though; That would validate old

RE: Dynamic (Evaluated) Prepend

2009-09-04 Thread meindert
I personally never trusted the dynamic prepend, so my solution would be to avoid it; WHERE 1=1 AND dynamic open=( close=) isNotEmpty property=A $logicOperator$ A = #A#/isNotEmpty isNotEmpty property=B $logicOperator$ B = #B#/isNotEmpty /dynamic -Original Message- From: Kunle

RE: = issues

2009-08-27 Thread meindert
Use lt; for the symbol (or put ![CDATA[ . ]] around the query The is seen as start of xml tag -Original Message- From: HelpMePlz [mailto:supriyanaidupell...@gmail.com] Sent: 27 August 2009 10:57 AM To: user-java@ibatis.apache.org Subject: = issues hi to all i want one help

RE: = issues

2009-08-27 Thread meindert
Use lt; for the symbol (or put ![CDATA[ . ]] around the query The is seen as start of xml tag -Original Message- From: HelpMePlz [mailto:supriyanaidupell...@gmail.com] Sent: 27 August 2009 10:57 AM To: user-java@ibatis.apache.org Subject: = issues hi to all i want one help

RE: Retrieve inserted id in mass insert using SqlMapExecutor.

2009-07-09 Thread meindert
(#uploadLogId:INTEGER#, #userid:INTEGER#, #actmonth:INTEGER#, #basemonth:BIT#, #datestamp:TIMESTAMP#, #result:LONGVARCHAR#) selectKey resultClass=java.lang.Integer keyProperty=uploadLogId SELECT @@IDENTITY /selectKey /insert Meindert -Original Message- From: Westhveg

RE: Retrieve inserted id in mass insert using SqlMapExecutor.

2009-07-09 Thread meindert
: RE: Retrieve inserted id in mass insert using SqlMapExecutor. Hello meindert-3, Thanks for your reply. This is correct and in my case is already working. But my problem is when I use batch processes. Remembering the code: public ListT createRecordsMassively(final ListT records

RE: Retrieve inserted id in mass insert using SqlMapExecutor.

2009-07-09 Thread meindert
setUpdateCounts(int[] updateCounts) see: http://ibatis.apache.org/docs/java/dev/com/ibatis/sqlmap/engine/execution/SqlExecutor.html http://ibatis.apache.org/docs/java/dev/com/ibatis/sqlmap/engine/execution/BatchResult.html Thanks, Westhveg meindert-3 wrote: Ok, don't know for sure

RE: queryForObject/queryForList where is the documentation for the Object parameter?

2009-07-02 Thread meindert
You can only have one input Object. For simple parameters I use a Map object; As larry said, the GRD (Get R' Done) approach to do this: MapString, Object param = new HashMapString, Object(); param.put(id, yourInt); param.put(description, yourString); In you sqlmap you can revere to these

RE: queryForObject/queryForList where is the documentation for the Object parameter?

2009-07-02 Thread meindert
personally use XStream to serialize java beans to XML (or JSON) and back to java beans meindert From: Fred Janon [mailto:fja...@gmail.com] Sent: 02 July 2009 09:53 AM To: user-java@ibatis.apache.org Subject: Re: queryForObject/queryForList where is the documentation for the Object parameter

RE: Multiple parameters in sqlmap parameters.

2009-06-03 Thread meindert
Use a map as parameterClass. As larry said, the GRD (Get R' Done) approach to do this: MapString, Object param = new HashMapString, Object(); param.put(id, yourInt); param.put(description, yourString); -Original Message- From: NathanM [mailto:nathan.mel...@infdig.com] Sent: 01 June

RE: Lazy loading when having dynamic table names

2009-05-04 Thread meindert
I don't have the answer, because I haven't had the issue, but would it be possible to use token replacement like clinton described last week? I have no idea of you can replace the tokens runtime for the session though... select id=findOrders parameterClass=org.test.OrderSearchCriteria

RE: need createCriteria help

2009-03-19 Thread meindert
xml. This should make it fairly clear from this what is wrong. Kind Regards Meindert -Original Message- From: TarakBhandary [mailto:reach2ta...@gmail.com] Sent: 19 March 2009 11:10 AM To: user-java@ibatis.apache.org Subject: Re: need createCriteria help Look its not possible to post

RE: need createCriteria help

2009-03-19 Thread meindert
it and report the bug that you discovered in the code generated by ibatus. I love ibatus in the transparent and easy to debug way it creates the queries. Meindert -Original Message- From: TarakBhandary [mailto:reach2ta...@gmail.com] Sent: 19 March 2009 12:18 PM To: user-java

RE: Recursive Select in SqlMap throws java.sql.SQLException: Exhausted Resultset

2009-02-26 Thread meindert
How about using a ‘modified preorder tree traversal algorithm’ (not my definition J) instead of the parented. This link gives you the CRUD queries and explains it quite nicely http://dev.mysql.com/tech-resources/articles/hierarchical-data.html From: Sean Barbridge

RE: help in executing a query

2008-03-10 Thread Meindert
The iterate tag would do that (read the list and put it in your where clause). -Original Message- From: ashishvk [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2008 8:19 AM To: user-java@ibatis.apache.org Subject: help in executing a query which is the best way of executing the

RE: how to close connection iin iBATIS

2008-01-22 Thread Meindert
the database. Is there a way to force/shut down the transaction manager via code? Kind Regards Meindert Hoving _ From: anika agarwal [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 11:06 AM To: user-java@ibatis.apache.org Subject: how to close connection iin iBATIS

RE: how to close connection iin iBATIS

2008-01-22 Thread Meindert
Message From: Meindert [EMAIL PROTECTED] To: user-java@ibatis.apache.org Sent: Tuesday, 22 January, 2008 3:51:22 PM Subject: RE: how to close connection iin iBATIS Hi Anika, I'm having the same issue, am using Derby with IBATIS on my application. Derby only one process to access it. So

RE: On Before Get Connection

2007-12-12 Thread Meindert
That would be the ping query (to test if the connection is alive)? transactionManager type=JDBC dataSource type=SIMPLE property value=${driver} name=JDBC.Driver/ property value=${url} name=JDBC.ConnectionURL/ property value=${username} name=JDBC.Username/ property

RE: Spring, Ibatis, and DBCP commons pooling

2007-09-14 Thread Meindert
commons poling was enabled, and we saw exactly the same problems... it seemed to us that having pool settings here, and in the context.xml for apache, was a mistake... ? Cheers Tracey Annison _ From: Meindert [mailto:[EMAIL PROTECTED] Sent: 13 September 2007 15:06 To: user

RE: Spring, Ibatis, and DBCP commons pooling

2007-09-13 Thread Meindert
I would think you will need to ping the connection before you can use it. transactionManager type=JDBC dataSource type=SIMPLE property value=${driver} name=JDBC.Driver/ property value=${url} name=JDBC.ConnectionURL/ property value=${username} name=JDBC.Username/

RE: how to execute a complete dynamic querry in ibatis(urgent)

2007-09-12 Thread Meindert
Add remapResults=true to your select tag. _ From: Yuvraj Shinde [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 12, 2007 11:14 AM To: user-java@ibatis.apache.org Cc: Yuvraj Shinde Subject: how to execute a complete dynamic querry in ibatis(urgent) Hi all, I am

RE: Fetching ids from oracle and postgresql sequences

2007-08-24 Thread Meindert
I'm keeping all (and only) my 'problem' sql statements in a xml file per database type and call it something like mysql.xml. In database.properties I state what the database type=dbtype=mysql In sql-map-config I link the xml file using the property; sqlMap

RE: Problem with blob

2007-08-14 Thread Meindert
59056 would be created I don't see in your code the place where the IndexOutOfBoundsException would be thrown? Kind Regards Meindert -Original Message- From: Vanessa [mailto:[EMAIL PROTECTED] Sent: 14 August 2007 08:36 AM To: user-java@ibatis.apache.org Subject: Problem with blob Hello

RE: Global Transactions or Ibatis's Automatic transactions

2007-06-29 Thread Meindert
Ibatis DAO has been depreciated.. Use spring instead -Original Message- From: ashok [mailto:[EMAIL PROTECTED] Sent: 29 June 2007 09:53 AM To: ibatis Subject: Global Transactions or Ibatis's Automatic transactions Hi Does the daoManger.startTransaction(); created refers to the Global

RE: How to use system date

2007-06-27 Thread Meindert
As far as I know, not with iBatis, 1) Pass the current System Date as parameter from your Java code 2) Use the native function call for your Database MySql= Now() Derby= CURRENT_TIMESTAMP SqlServer= getDate() 'Select * from test where data = sysdate' This will get you

RE: Transactions with iBatis and Spring

2007-06-11 Thread Meindert
Hi Colin, There is a description for the change from Ibatis DAO on the petstore to the Spring framework including the transaction handling http://opensource.atlassian.com/confluence/oss/display/IBATIS/Converting+iBA TIS+DAO+to+Spring+DAO Kind Regards Meindert -Original Message- From

Cache object reference

2007-06-06 Thread Meindert
the name of the receiver also changes to Alice! Person sender = (Person) queryoutofcache; //Cache miss sender is created Person receiver = (Person) queryoutofcache; ; //Cache hit, receiver is NOT created, it is pointing to the sender object Kind Regards Meindert

RE: Cache object reference

2007-06-06 Thread Meindert
one iBATIS 'session'? (When I start the web application for the first time) Kind Regards Meindert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: 06 June 2007 01:00 PM To: user-java@ibatis.apache.org Subject: Re: Cache object reference

RE: Purpose of sqlClientTemplate

2007-06-06 Thread Meindert
I can be wrong but I thought that if you extends your dao class with SqlMapClientDaoSupport the code to do the Sql query will be; getSqlMapClientTemplate().update, getSqlMapClientTemplate().queryforlist, .. While when you use 'extends SqlMapClientTemplate' the code stays the same as it was in

RE: No Statement...

2007-05-31 Thread Meindert
Let me start by saying that I don't have the book, and I don't understand your question.. Anyway I like the 'feature' of IBATIS that I can map a join query to objects and child objects using 'dot notation' Example; I've got a domain class called Declaration, in it is a other domain class

RE: No operations allowed after connection closed occasionally when using queryForList

2007-05-31 Thread Meindert
I had that problem with 'stale' connections, and added the ping property name=Pool.PingQuery value=SELECT 1/ property name=Pool.PingEnabled value=true / property name=Pool.PingConnectionsOlderThan value=100 / To sqlMapConfig -Original Message- From: James,

RE: Defining Transaction Isolation Using iBATIS

2007-05-24 Thread Meindert
Hi Ralf, Not sure if it will answer your question but the Ibatis ADO framework has been depreciated. We wrote a little piece in the Wiki how to convert jpetstore to the Spring ADO framework, You will set the transaction isolation in the Spring configuration files (or by annotation)

RE: Conditional joins?

2007-05-17 Thread Meindert
JOIN ... /isNotNull Kind Regards Meindert -Original Message- From: Matthias Karlsson [mailto:[EMAIL PROTECTED] Sent: 17 May 2007 04:36 PM To: user-java@ibatis.apache.org Subject: Conditional joins? Hi, I'm currently evaluating frameworks for writing DAO layers for future projects

RE: Store results directly into a single HashMap

2007-05-11 Thread Meindert
You will need a result map (as you do, but just mentioning it because it is required) and queryForMap as Larry said: MapString, String result = (MapString, String) queryForMap(getProperties, null, propName, propValue); resultMap id=getPasswordsMap class=java.util.HashMap result

RE: Abator rootClass question

2007-05-10 Thread Meindert
Not to be nasty but wouldn't it be better to normalize the database and put createBy, createDate, modifiedBy etc in his own table/class? That's what I like about ibatis, I will only fetch this kind of data when I actual going to use it. On 5/9/07, Ashok Madhavan [EMAIL PROTECTED] wrote:

RE: HOW2: Domain Object Searching

2007-05-07 Thread Meindert
Did you have a look a http://ibatis.apache.org/abator.html ? It generates a search object -Original Message- From: Joe Weder [mailto:[EMAIL PROTECTED] Sent: 07 May 2007 03:07 PM To: user-java@ibatis.apache.org Subject: HOW2: Domain Object Searching What does everyone recommend for

RE: converting iBATIS framework DAOs to the Spring Framework

2007-04-16 Thread Meindert
to the spring config file? Sorry about all the questions, but would like to do this simple and right. Kind Regards Meindert _ From: Poitras Christian [mailto:[EMAIL PROTECTED] Sent: 13 April 2007 06:08 PM To: user-java@ibatis.apache.org Subject: RE: converting iBATIS

RE: converting iBATIS framework DAOs to the Spring Framework

2007-04-16 Thread Meindert
'it is the right thing to do', 'easy interchange of implementations') . So (for now) I would say that it is not possible to have a transaction in the business logic (if the business logic doesn't implement a interface). Kind Regards Meindert _ From: Poitras Christian [mailto:[EMAIL

RE: converting iBATIS framework DAOs to the Spring Framework

2007-04-16 Thread Meindert
Ok, have to stay on that track then ;-) After adding the jar from sourceforce (cglib-2.2_beta1.jar) I get the message; org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'accountService' defined in ServletContext resource [/WEB-INF/spring.xml]:

RE: converting iBATIS framework DAOs to the Spring Framework

2007-04-16 Thread Meindert
://www.springframework.org/schema/beans/spring-beans-2.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd; Meindert

RE: converting iBATIS framework DAOs to the Spring Framework

2007-04-13 Thread Meindert
] Subject: Re: converting iBATIS framework DAOs to the Spring Framework I'll add this to the wiki, and clean up anything I see in it that looks odd. Larry On 4/12/07, Meindert [EMAIL PROTECTED] wrote: Hi all. I've documented the process of converting jpetshop5, and would like to know

RE: converting iBATIS framework DAOs to the Spring Framework

2007-04-13 Thread Meindert
) { accountDao.updateAccount(account); } I get org.springframework.aop.framework.AopConfigException: Cannot proxy target class because CGLIB2 is not available. Add CGLIB to the class path or specify proxy interfaces. Kind Regards Meindert -Original Message- From: [EMAIL PROTECTED

converting iBATIS framework DAOs to the Spring Framework

2007-04-12 Thread Meindert
Hi all. I've documented the process of converting jpetshop5, and would like to know if it is right? Also I don't know what to do with the com.ibatis.dao.client.DaoException thrown in SequenceSqlMapDao? I'm going to add the transaction on OrderService now. Steps to convert jpetshop5 to

RE: converting iBATIS framework DAOs to the Spring Framework

2007-04-12 Thread Meindert
;) I was curious why if we are starting with jpetshop5, why not use the hsqldb stuff that is there? Just kept is simple, was only interested into the conversion to spring. Also didn't know where to put it :-) Kind Regards Meindert -Original Message- From: [EMAIL

RE: iBATIS, Spring, and transactions...

2007-04-11 Thread Meindert
WebApplicationContext. * @return Spring's WebApplicationContext. */ public static ApplicationContext getApplicationContext() { return springContext; } } Christian _ From: Meindert [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 April 2007 12:30 To: user-java

RE: Spring-Ibatis configuration problem.

2007-04-10 Thread Meindert
You are pointing to http://www.ibatis.com/dtd/sql-map-2.dtd in your configuration _ From: Loro Diego [mailto:[EMAIL PROTECTED] Sent: 10 April 2007 11:07 AM To: [EMAIL PROTECTED] Cc: user-java@ibatis.apache.org Subject: Spring-Ibatis configuration problem. Hi, In my

RE: iBATIS, Spring, and transactions...

2007-04-10 Thread Meindert
id= theService class=com.service.TheService constructor-arg index=0 ref=theDao/ /bean And code; public TheService (TheDao theDao){ this.theDao = theDao; } Kind Regards Meindert -Original Message- From: Poitras Christian [mailto:[EMAIL PROTECTED

RE: Retrieving wrong result out of the Cache.

2007-03-16 Thread Meindert
and not 3! All other field values are correct. MEINDERT HOVING

RE: Retrieving wrong result out of the Cache.

2007-03-16 Thread Meindert
of the Cache. What version of iBATIS are you using? There was a problem with caching, but it was fixed quite a while ago. Jeff Butler On 3/16/07, Meindert [EMAIL PROTECTED] wrote: Anyone who knows what I'm doing wrong or is encountering the same issue? Hi there, My cache

RE: Retrieving wrong result out of the Cache.

2007-03-16 Thread Meindert
result out of the Cache. What version of iBATIS are you using? There was a problem with caching, but it was fixed quite a while ago. Jeff Butler On 3/16/07, Meindert [EMAIL PROTECTED] wrote: Anyone who knows what I'm doing wrong or is encountering the same issue? Hi there, My

RE: Retrieving wrong result out of the Cache.

2007-03-16 Thread Meindert
? cacheModel id=selectEmpNameCache readOnly=false type=LRU My guess is that between the first fetch and the second, the cached data is altered, and then the altered version is fetched again. Larry On 3/14/07, Meindert [EMAIL PROTECTED] wrote: Hi there, My cache

Retrieving wrong result out of the Cache.

2007-03-14 Thread Meindert
# AND EmplMain.IsActiveEmployee=1 /select Results in fetching Employee out of cache DEBUG [http-8084-Processor22] - Cache 'Employee.selectEmpNameCache': retrieved object '[EMAIL PROTECTED]' The resulting object has as Empid 1 and not 3! All other field values are correct. MEINDERT HOVING

Using com.ibaits.struts to work with files in the web application

2006-04-24 Thread Meindert
. There is no ActionContext.getActionContext().getContext Some help with this would be appreciated MEINDERT HOVING -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.4/319 - Release Date: 19/04/2006

RE: Using com.ibaits.struts to work with files in the web application

2006-04-24 Thread Meindert
for the help MEINDERT HOVING -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.4/319 - Release Date: 19/04/2006

RE: Warnings at queryForList

2006-04-07 Thread Meindert
Am using netBeans 5.0 and removed in 'Additional Compiler Options' the option; -Xlint This field can be found under Project Properties=Build=Compiling MEINDERT -Original Message- From: Enrique Ferreyra [mailto:[EMAIL PROTECTED] Sent: 07 April 2006 01:19 PM To: user-java

RE: Select max(#A#) from (#B#) error

2006-04-04 Thread Meindert
Use SELECT MAX(?index?) FROM (?nom?) If you want to do a replacement Also switch logging on so you can see the created query MEINDERT HOVING -Original Message- From: Stéphane Chapeau [mailto:[EMAIL PROTECTED] Sent: 04 April 2006 09:21 AM To: user-java@ibatis.apache.org Subject

RE: setup help requested

2006-03-17 Thread Meindert
Are you using recent example code to learn it? You are pointing to the wrong URL for the DTD; !DOCTYPE sqlMap PUBLIC -//iBATIS.com//DTD SQL Map 2.0//EN http://www.ibatis.com/dtd/sql-map-2.dtd; MEINDERT -Original Message- From: Beemsterboer Software [mailto:[EMAIL PROTECTED] Sent: 17

RE: Problem in using complex objects in ibatis2.0

2006-03-13 Thread Meindert
, setWHistVO = WHistVO MEINDERT HOVING From: Nikesh, Kishlay [mailto:[EMAIL PROTECTED] Sent: 13 March 2006 11:21 AM To: user-java@ibatis.apache.org Subject: Problem in using complex objects in ibatis2.0 Hi, I am having a java-class(getter/setter) which has a reference of another

nullValue

2006-03-09 Thread Meindert
Hi there, I'm trying to use the NULL replacement while using a map that hasn't got the required parameter; I'm making a service that inserts data based on a XML Document - I won't add the XML element to my input XML If a field value is NULL - I put my XML elements straight into a map, =the

RE: manage transaction

2006-03-08 Thread Meindert
PUBLIC -//iBATIS.com//DTD SQL Map 2.0//EN http://ibatis.apache.org/dtd/sql-map-2.dtd; MEINDERT HOVING -Original Message- From: Cesar Villar [mailto:[EMAIL PROTECTED] Sent: 08 March 2006 11:20 AM To: user-java@ibatis.apache.org Subject: manage transaction Hello everybody!!! I'm begginer

RE: manage transaction

2006-03-08 Thread Meindert
transaction manager. Does that help? Meindert -Original Message- From: Cesar Villar [mailto:[EMAIL PROTECTED] Sent: 08 March 2006 11:59 AM To: user-java@ibatis.apache.org Subject: RE: manage transaction Thanks!! I've changed the reference of ibatis.com to ibatis.apache.org

RE: iBatis Conversion of java Type String to Numeric database field

2006-02-10 Thread Meindert
Hi Ryan, Sorry for replying without answering your question, but it sounds to me that the validation of the text file should be done in your service layer, and that the service layer should populate your data beans what is a reflection of your tables. MEINDERT HOVING

RE: dynamic insert question

2006-02-07 Thread Meindert
He already said that ## didn't work (because it is a select and not a parameter?) MEINDERT HOVING -Original Message- From: Yusuf [mailto:[EMAIL PROTECTED] Sent: 07 February 2006 09:50 AM To: user-java@ibatis.apache.org Subject: RE: dynamic insert question Well I think the solution

RE: how to put parameter in the select item

2006-02-06 Thread Meindert
Its in the documentation under the chapter for Dynamic Mapped Statements; Simple Dynamic SQL Elements IBATIS Datamapper Page 39 (version 2 Jan 25 2005) MEINDERT From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 February 2006 06:22 AM To: user-java@ibatis.apache.org

RE: dynamic insert question

2006-02-06 Thread Meindert
Hi Steven, The $family$ will do a literate replacement, so you would have to add (I think J) = $family$ I would also advice to use the logging functionality to see the SQL statement created, make it much easier to see. MEINDERT From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

RE: the return result of insert, update, and delete in SqlMapClient API

2005-12-13 Thread Meindert
Uhm, insert() does not return an int. According to the Developer Guide (page 43) it does. The javadoc say's that it returns a java.lang.Object containing the primary key, the primary key field is defined with the selectKey tag in the Sql. Meindert Larry On 12/13/05, Leonardo Kenji Shikida

RE: XML document output from ibatis

2005-10-11 Thread Meindert
is set to org.apache.xalan.processor.TransformerFactoryImpl. The solution: remove the file xml-apis.jar from the directory. MEINDERT HOVING From: Samael Cui [mailto:[EMAIL PROTECTED] Sent: 11 October 2005 04:09 AM To: user-java@ibatis.apache.org; Clinton Begin Subject: Re: XML

RE: XML document output from ibatis

2005-10-10 Thread Meindert
I can't find info about the use of a RowHandler in the wikki. Could anybody please post code/example for returning an org.w3c.dom.Document using a RowHandler? -Original Message- From: Ashish Kulkarni [mailto:[EMAIL PROTECTED] Sent: 13 September 2005 06:07 PM To:

RE: help required for insert()

2005-09-09 Thread Meindert
I would think you should add tag selectKey in your insert. Not to sure how this works with a key that isn't a int. -Original Message- From: Karthikeyan Pandurangan [mailto:[EMAIL PROTECTED] Sent: 09 September 2005 05:45 AM To: user-java@ibatis.apache.org; [EMAIL PROTECTED] Subject: Re:

RE: Getting auto-generated keys in mySql

2005-08-18 Thread Meindert
of the newly inserted row. MEINDERT HOVING -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: 17 August 2005 11:46 PM To: user-java@ibatis.apache.org Subject: Re: Getting auto-generated keys in mySql NO! That is really, really not thread safe! Imagine what happens when

RE: Result map problems...

2005-07-12 Thread Meindert
Bit afraid to answer because I'm also quite new to this. It sounds right to me that it can't do the auto-result map to the existing class property if you are not selecting the matching column. MEINDERT HOVING Developer, Pastel Payroll Direct: +27 (21) 680 9015 Main: +27 (21) 680 9000 Fax: +27

RE: No operations allowed after connection closed.

2005-06-29 Thread Meindert
Title: RE: No operations allowed after connection closed. Ok, sorry I didnt look very well. The answer is in the back of the manual: SimpleDataSource Property Name: Pool.PingQuery The ping query will be run against the database to test the connection From: Meindert [mailto