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

You can’t use the ‘<’ character, it is seen as a xml opening tag. Use < 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 Hello:

RE: iBatis mail-archive

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 A: Valentina Fabrizi Cc: user-java@ibatis.apach

iBatis mail-archive

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: How to map a dynamic condition on Left Outer Join

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 a lot myself.. Sorry Meindert From: Valentina Fabrizi [mailto:fabrizi_valent...@yahoo.it] Sent: 22 February 2010 03:45 PM To: user-java

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

27; 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 to use iBatis

RE: IBATIS + GWT +Log4j

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 P

IBATIS + GWT +Log4j

/wordpress/186/gwt-hosted-mode-and-log4j/ Kind Regards Meindert Hoving <> - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org

RE: Mapper behaving differently between Eclipse and Maven

I didn't read your whole mail and am not using ibatis3 but; select expense_date, extract(YEAR_MONTH from expense_date) as period from expense group by period; How would you expect the period to be passed to the java.util.Date class? From: J S [mailto:sharpfel...@yahoo.ca]

RE: java.util.UUID to postgres uuid column

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 [mailto:vikra...@directi.

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

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 se

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

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: com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance

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

ec have been given 30 minutes time to complete (batch process stored procedures) I don't know the list of required JARs from the top of my head, but you will be able to find that on the spring help files. Kind Regards Meindert -Original Message- From: naveendutt [mailto:naveendutt

RE: Error calling Connection.setAutoCommit:

; -Original Message- From: Ron H [mailto:be.spec...@gmail.com] Sent: 18 November 2009 01:24 PM To: user-java@ibatis.apache.org Subject: RE: Error calling Connection.setAutoCommit: thanks do you use it instead of: meindert-3 wrote: > > Not sure what the differe

RE: Error calling Connection.setAutoCommit:

Not sure what the difference is, but I'm using the validationQuery property to check the connection; 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 DUAL' -Original Message- From: Ron H [mailto:be.spec...@gmail.

RE: caching question

- From: meindert [mailto:meind...@eduflex.com] Sent: Thursday, October 22, 2009 3:23 PM To: user-java@ibatis.apache.org Subject: RE: caching question >Do you mean that actually it invokes the database when I execute the query? No, only the first time, the next time you ask the same query w

RE: caching question

Message- 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:

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 [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

skip Results, maxResults in statement

] DESC $sortBy$ $sortorder$) as Row, [The normal query] WHERE Row >= #paging.startRow# AND Row <= #paging.endRow# ORDER BY [default sorting column] DESC $paging.sortBy$ $paging.sortorder$ Me

RE: can IBATIS handle mysql "DATE" keyword?

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

I'm using; Hope it helps From: Jasmin Mehta [mailto:jasmin_me...@nexweb.org] Sent: 06 October 2009

Slow parameterised query

alercode Anybody noticing this same issue and know a way to fix it? Meindert Hoving <> - 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

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 %, inst

RE: Problem with connecting

you add 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 va

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 connections before using them. Here is my datasource setup;

RE: Dynamic (Evaluated) Prepend

I personally never trusted the dynamic prepend, so my solution would be to avoid it; WHERE 1=1 AND $logicOperator$ A = #A# $logicOperator$ B = #B# -Original Message- From: Kunle Gbadamosi [mailto:kgbadam...@gmail.com] Sent: 04 September 2009 12:35 AM To: user-java@ibatis.apache.

RE: <= issues

Use < for the < symbol (or put 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 in my requirement in

RE: <= issues

Use < for the < symbol (or put 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 in my requirement in

RE: Retrieve inserted id in mass insert using SqlMapExecutor.

unts(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, b

RE: Retrieve inserted id in mass insert using SqlMapExecutor.

rg Subject: 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 List createRecordsMassively(final Li

RE: Retrieve inserted id in mass insert using SqlMapExecutor.

d_log (id, userid, actmonth, basemonth, datestamp, result) values (#uploadLogId:INTEGER#, #userid:INTEGER#, #actmonth:INTEGER#, #basemonth:BIT#, #datestamp:TIMESTAMP#, #result:LONGVARCHAR#) SELECT @@IDENTITY Meindert -Original Message- From: Westhveg [mailto:west

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

uite limited, I 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 &q

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

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: Map param = new HashMap(); param.put("id", yourInt); param.put("description", yourString); In you sqlmap you can revere to these parameters like #id# and

RE: Multiple parameters in sqlmap parameters.

Use a map as parameterClass. As larry said, the GRD (Get R' Done) approach to do this: Map param = new HashMap(); param.put("id", yourInt); param.put("description", yourString); -Original Message- From: NathanM [mailto:nathan.mel...@infdig.com] Sent: 01 June 2009 11:45 PM To: user-java

RE: Lazy loading when having dynamic table names

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... ORDER_${company} where ORNO = $id$ -Original Message- From: grat

RE: need createCriteria help

; Debug 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:

RE: need createCriteria help

have any other way to fetch the conditional records. meindert-3 wrote: > > Hi tarak, > > It's probably the quickest to debug yourself; > - What is wrong in the result set? > - Did you get log4j working, and do you see the generated query? > ==> What is wrong with the gene

RE: need createCriteria help

y map in your 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

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

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 [mailto:sean.barbri...@g

RE: help in executing a query

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 foll

RE: how to close connection iin iBATIS

nnection doesnt work.we have tried this at our end. - Original 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 wi

RE: how to close connection iin iBATIS

pdates 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

RE: On Before Get Connection

That would be the ping query (to test if the connection is alive)? -Original Message- From: Denis Karpov [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 12, 2007 12:01 PM To: user-java

RE: Spring, Ibatis, and DBCP commons pooling

we had it set up like this, with settings that we thought > were a hangover from before the apace 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... ? > > Chee

RE: Spring, Ibatis, and DBCP commons pooling

I would think you will need to ping the connection before you can use it. _ From: Tracey Annison [mailto:[EMAIL PROTECTED] Sent: Thursday, September 13, 2007 3:58 PM To: user-java@ibat

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

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 exec

RE: Fetching ids from oracle and postgresql sequences

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; -Original Message- From: Clinton Begi

RE: Problem with blob

on is thrown: (com.stud.bean.studregBean.StudentHtml(studregBean.java:87) Kind Regards Meindert -Original Message- From: Tom Schindl [mailto:[EMAIL PROTECTED] Sent: 14 August 2007 09:10 AM To: user-java@ibatis.apache.org Subject: Re: Problem with blob Vanessa schrieb: > Hi Meindert >

RE: Problem with blob

h the size 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 w

RE: IBATIS map and Cache

nd the object in the cache. Did you check in your logging to see the cache hit or miss? Kind Regards Meindert _ From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: 04 July 2007 10:19 AM To: user-java@ibatis.apache.org Subject: RE: IBATIS map and Cache Did you enable t

RE: Global Transactions or Ibatis's Automatic transactions

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 tr

RE: How to use system date

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 t

RE: Transactions with iBatis and Spring

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

RE: Purpose of sqlClientTemplate

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 jpet

RE: Cache object reference

will only be cached for the current iBATIS 'session' I'm running iBATIS in a web application, isn't there only one iBATIS 'session'? (When I start the web application for the first time) Kind Regards Meindert -Original Message- From: [EMAIL PROTECTED] [m

Cache object reference

e 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: "No operations allowed after connection closed" occasionally when using queryForList

I had that problem with 'stale' connections, and added the ping To sqlMapConfig -Original Message- From: James, Steven [mailto:[EMAIL PROTECTED] Sent: 31 May 2007 05:03 PM To: user-java@ibatis.apache.org Subject: RE: "No operations allowed after connection clos

RE: No Statement...

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 w

RE: Defining Transaction Isolation Using iBATIS

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) ht

RE: Conditional joins?

I'm doing it by checking the Foreign Key value and the use of If I don't want to join I set the Foreign Key value to null And in the statement SELECT {Fields from the joined table} FROM maintable JOIN ... Kind Regards Meindert -Original Message- From

RE: Store results directly into a single HashMap

You will need a result map (as you do, but just mentioning it because it is required) and queryForMap as Larry said: Map result = (Map) queryForMap("getProperties", null, "propName", "propValue"); SELECT PropName, PropValue FROM Properties -Original M

RE: Abator rootClass question

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

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 obje

RE: JPETSTORE 5 LINUX

Well, not on Linux and not "tag element cannot be null", but I did notice that one of the queries wasn't working; I think it was getItem And the reason was 'select ITEMID' while there are two ITEMID's changed it to I.ITEMID Sorry for half a answer _ From: Nuno Rodrigues [mailto:[E

RE: converting iBATIS framework DAOs to the Spring Framework

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 _ From: Tom Duffey [mailto:[EMAIL PROTECTED] Sent: 16 April

RE: converting iBATIS framework DAOs to the Spring Framework

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]: Initializatio

RE: converting iBATIS framework DAOs to the Spring Framework

ction management where it belongs, IMO. Larry On 4/16/07, Meindert <[EMAIL PROTECTED]> wrote: > Had a closer look at it and the logical reason the proxy could not be > generated is the fact the service classes (in JPetstore) don't use an > interface. > > I would like to

RE: converting iBATIS framework DAOs to the Spring Framework

s like '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 _ Fro

RE: converting iBATIS framework DAOs to the Spring Framework

got to add something 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: R

RE: converting iBATIS framework DAOs to the Spring Framework

(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] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: 12 Ap

RE: converting iBATIS framework DAOs to the Spring Framework

x27;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 if it is right?

RE: converting iBATIS framework DAOs to the Spring Framework

lso remove import com.ibatis.dao.client.DaoManager;) >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 -Origin

converting iBATIS framework DAOs to the Spring Framework

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 iba

RE: iBATIS, Spring, and transactions...

. _ From: Meindert [mailto:[EMAIL PROTECTED] Sent: 11 April 2007 11:00 AM To: user-java@ibatis.apache.org Subject: RE: iBATIS, Spring, and transactions... Hi Christian, Thanks for your extensive answer, unfortunately I don't seem to be clever enough to understand it.. I've never w

RE: Return as XML

Yes; And you probably want to have control on the rows returned so you might need to add a rowhandler Call to query RowHandler rowHandler=new xmlRowHandler("mailQueue"); queryWithRowHandler("messageQueue", myParam, rowHandler); // go through the list Document doc = ((xmlRowHandler) row

RE: iBATIS, Spring, and transactions...

Hi Tom, Thanks for your reply, but I don't understand how this will get the spring managed service class into my struts created presentation bean. I think that Cristian's answer might be easier? Kind Regards Meindert _ From: Tom Duffey [mailto:[EMAIL PROTECTED]

RE: iBATIS, Spring, and transactions...

atic ApplicationContext getApplicationContext() { return springContext; } } Christian _ From: Meindert [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 April 2007 12:30 To: user-java@ibatis.apache.org Subject: RE: iBATIS, Spring, and transactions... I'm busy converting a

RE: iBATIS, Spring, and transactions...

g in spring.xml; And code; public TheService (TheDao theDao){ this.theDao = theDao; } Kind Regards Meindert -Original Message- From: Poitras Christian [mailto:[EMAIL PROTECTED] Sent: 10 April 2007 04:25 PM To: user-java@ibatis.apache.org; [EMAIL PROTECT

RE: Spring-Ibatis configuration problem.

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 proje

RE: iBATIS, Spring, and transactions...

Hi All, Does anybody have an answer on the question posted below? I want to switch of from IBATIS DAO to spring because IBATIS DAO is depreciated. I can convert most of the code quite simply, but what must I do with my transactions? Kind Regards Meindert -Original Message- From: [EMAIL

RE: iBatis - SQL IN keyword

What do you see in your log file? -Original Message- From: PraDz [mailto:[EMAIL PROTECTED] Sent: 04 April 2007 10:47 AM To: user-java@ibatis.apache.org Subject: iBatis - SQL IN keyword My application needs an output which will use the Keyword IN This is how i have used in xml query

RE: Configurable static parameters in SQL

Not to sure why it doesn't work in your code, I have the following in my database.config #nowfunction=Now() And nowfunction=getDate() Now() to be used if database is MySql and getDate() if database is Sql Server And have no issues using ${nowfunction} in my queries UPDATE Profile SET Modi

RE: converting complex object to xml data file

Have you thought about using xstream ? import com.thoughtworks.xstream.XStream; import org.dom4j; XStream xstream = new XStream(); xstream.alias("parent", Parent.class); xstream.alias("childeren", List.class); xstream.alias("child", Child.class); org.dom

RE: Retrieving wrong result out of the Cache.

ors Sent: 16 March 2007 01:23 PM To: user-java@ibatis.apache.org Subject: Re: Retrieving wrong result out of the Cache. Can you try changing your cache model definition to include and try it again? My guess is that between the first fetch and the second, the cached data is altered, and th

RE: Retrieving wrong result out of the Cache.

2007 11:34 AM To: user-java@ibatis.apache.org Subject: Re: Retrieving wrong 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: Anyon

RE: Retrieving wrong result out of the Cache.

esult 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?

RE: Retrieving wrong result out of the Cache.

7;: retrieved object '[EMAIL PROTECTED]' The resulting object has as Empid 1 and not 3! All other field values are correct. MEINDERT HOVING

Retrieving wrong result out of the Cache.

1 and not 3! All other field values are correct. MEINDERT HOVING

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

(); Thanks 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

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

ad. 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: Warnings at queryForList

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

RE: There is no WRITEABLE property called 'UserId' in AppUser

The property is called 'userId' MEINDERT -Original Message- From: Somasundaram Pitchaiah [mailto:[EMAIL PROTECTED] Sent: 06 April 2006 10:53 AM To: user-java@ibatis.apache.org Cc: [EMAIL PROTECTED] Subject: There is no WRITEABLE property called 'UserId' in AppUser

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

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

Are you using recent example code to learn it? You are pointing to the wrong URL for the DTD; http://www.ibatis.com/dtd/sql-map-2.dtd";> MEINDERT -Original Message- From: Beemsterboer Software [mailto:[EMAIL PROTECTED] Sent: 17 March 2006 01:12 AM To: user-java@ibatis.apache.org

RE: Problem in using complex objects in ibatis2.0

= DOB getWistVO, 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 ref

nullValue

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 nul

RE: Log 4j prob

I had a similar problem when the log4j jar was in the tomcat common lib (but then it was complaining about a other class logger) So would also think it got something to do with the place of your log4j jar/class path MEINDERT HOVING -Original Message- From: Richard Yee [mailto:[EMAIL

RE: manage transaction

In your config; Jeff Butler wrote on Tuesday; If you use an EXTERNAL transaction manager, then iBATIS does not do commits or rollbacks - even if you call the methods, they do nothing at all - because you've declared you are using an external transaction manager. Does that help? Mei

RE: manage transaction

You have a reference to ibatis.com; http://www.ibatis.com/dtd/dao-2.dtd";> This must be; http://ibatis.apache.org/dtd/dao-2.dtd";> And for the sql maps http://ibatis.apache.org/dtd/sql-map-2.dtd";> MEINDERT HOVING -Original Message- From: Cesar Villar [mailto:[EM

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

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

  1   2   >