Re: Cache no flushing on execute

2008-11-26 Thread Nathan Maves
Ignore that last post. This project had some really old ibatis jars, silly them, and silly me for not checking sooner On Wed, Nov 26, 2008 at 7:35 PM, Nathan Maves [EMAIL PROTECTED] wrote: Given the following cache model : cacheModel id=ProductsCache type=MEMORY

Re: Nested Dynamic Statements

2008-06-16 Thread Nathan Maves
can you not do statement id=foo resultMap=fooMap select * from mytable dynamic prepend=where open=( close=) isNotEmpty prepend=or property=prop1 field1 = prop1 /isNotEmpty

Re: Nested Dynamic Statements

2008-06-16 Thread Nathan Maves
Ignore that last one responded to fast that will not work On Mon, Jun 16, 2008 at 2:53 PM, Nathan Maves [EMAIL PROTECTED] wrote: can you not do statement id=foo resultMap=fooMap select * from mytable dynamic prepend=where open=( close

Re: Dynamic Java SQL

2008-06-09 Thread Nathan Maves
You cannot quite do what you are trying to do. You need to get the string fully ready to send to the map and then use the $$ life you have in your example. Be very weary about this approach because you might leave yourself open to sql injection On Mon, Jun 9, 2008 at 8:50 AM, [EMAIL PROTECTED]

Re: AutoCommit Defaulted to true/false?

2008-06-09 Thread Nathan Maves
Taken from the Developer Guide located at http://ibatis.apache.org/javadownloads.cgi The transactionManager element also allows an optional attribute commitRequired that can be true or false. Normally iBATIS will not commit transactions unless an insert, update, or delete operation has been

Re: Problem exposing protected setters for iBatis

2008-05-12 Thread Nathan Maves
Can I ask what the point of labeling the property as protected is in your case? On Mon, May 12, 2008 at 8:54 AM, Clinton Begin [EMAIL PROTECTED] wrote: I think I've confirmed this bug visually. It looks like a change went in quite some time ago that stopped this from working. I'll write a

Re: Problem if two properties have same type

2008-05-09 Thread Nathan Maves
As far as I know you can not do this the way you would think. I am sure it could be done with two result maps, one for each arm. Second part is that you will not be able to use .* notation. You will have to alias the column. On Fri, May 9, 2008 at 7:29 AM, steve mcdowell [EMAIL PROTECTED]

Re: list returning empty array

2008-05-06 Thread Nathan Maves
are we to guess at what issue you are having... some of are good, even great, minus larry but none of us are mind readers System.out.println(ibatis5); these types of got here debugging is worthless :) On Mon, May 5, 2008 at 2:35 AM, HelpMePlz [EMAIL PROTECTED] wrote: Hi to All public List

Re: list returning empty array

2008-05-06 Thread Nathan Maves
I an not in the great category yet because I fail at typing.. thank god for IDE's some of us** On Tue, May 6, 2008 at 7:45 PM, Nathan Maves [EMAIL PROTECTED] wrote: are we to guess at what issue you are having... some of are good, even great, minus larry but none of us are mind readers

Re: Simple java.util.Map unmarshalling

2008-04-28 Thread Nathan Maves
Um... What part of the question has to do with ibatis? if you are looking for a simple way to convert xml to java objects then take a look at xstream. Nathan On Mon, Apr 28, 2008 at 4:16 AM, Wolf-Dieter Mische [EMAIL PROTECTED] wrote: Hi, I want to unmarshall a java.util.Map therefore I

Re: how can we send formbean bookid value to update statement

2008-04-28 Thread Nathan Maves
I would start by reading the developers guide. The root of your issue is that you seem to completely confussed about how to use ibatis. You have both #var# and ? in your update sql map. Along with only sending one parameter when you updated is expecting 6. Start from the begin and read the

Re: Connection already closed

2008-04-28 Thread Nathan Maves
logging is always a good start but if you want help from us we need a little more information. post your sqlmaps and you java code executing it. Nathan On Fri, Apr 18, 2008 at 10:43 PM, Reuben Firmin [EMAIL PROTECTED] wrote: I'm using Ibatis 2.3.1. I've recently started getting this error; any

Re: select * causing OutOfMemoryError: Java heap space

2008-03-15 Thread Nathan Maves
this is only my 2 cents but I would throw that class out. Write your own implementation which uses a row handler. This is the type of situation in which a row handler could really help. almost no memory would be used. On Thu, Mar 13, 2008 at 4:57 PM, nch [EMAIL PROTECTED] wrote: Yes, I

Re: Retrieve the SQL statement being executed

2008-03-08 Thread Nathan Maves
Please take a look at the logging section in one of the following 3 places... The website The developers guide The book Sent from my iPhone On Mar 8, 2008, at 5:55 AM, Ricky Murphy [EMAIL PROTECTED] wrote: Hello: I am using Spring 2 together with iBatis 2.2. I need in my program to

Re: Need Help on Complex WHERE CLAUSE

2008-03-06 Thread Nathan Maves
Tony, This is correct if you are using parameter maps. If you are using inline paramter maps you would still use #rx#. Nathan On Thu, Mar 6, 2008 at 1:48 PM, Angso, Tony [EMAIL PROTECTED] wrote: I found the problem... WHERE RXNUM_TXT = #rx# AND

Re: Need Help in iBatis Configuration

2008-03-05 Thread Nathan Maves
my first guess would be h Oracle! if that one missed you, one might try http://www.google.com/search?q=oracle+driver+for+java On Wed, Mar 5, 2008 at 3:15 PM, Angso, Tony [EMAIL PROTECTED] wrote: Am getting this now Error while loading properties. Cause:

Re: Save Generated WHERE Clause

2008-02-25 Thread Nathan Maves
not to rain on the parade but I think the idea of storing sql would be a bad thing. Just imagine the amount of work in the event of a DB vendor switch ouch I would say think outside the box and find a different solution to storing the save criteria. Even the idea of serializing the Java

Re: Save Generated WHERE Clause

2008-02-25 Thread Nathan Maves
On Mon, Feb 25, 2008 at 11:13 AM, Nathan Maves [EMAIL PROTECTED] wrote: not to rain on the parade but I think the idea of storing sql would be a bad thing. Just imagine the amount of work in the event of a DB vendor switch ouch I would say think outside the box and find a different solution

Re: Save Generated WHERE Clause

2008-02-25 Thread Nathan Maves
, but it's a very good point if I decided to save the actual built SQL statement. -Ryan On Mon, Feb 25, 2008 at 11:13 AM, Nathan Maves [EMAIL PROTECTED] wrote: not to rain on the parade but I think the idea of storing sql would be a bad thing. Just imagine the amount of work in the event

Re: Ibatis caching Empty ResultSet

2008-02-09 Thread Nathan Maves
The real question is why are you not clearing the cache on the insert statement? This would solve your issue and ensure that your cache is always in a clean state. I know you claim that this makes no sense but it does :) As long as you are issues more then one select between inserts which is

Re: Weird IN OUT Param problem.

2008-01-31 Thread Nathan Maves
yeah for future reference all of the types can be found here http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Types.html On Jan 30, 2008 3:01 PM, Sundar Sankaranarayanan [EMAIL PROTECTED] wrote: Perfect. That was it!!! I changed it to float and it worked. Thanks a lot for your help Jeff. I

Re: Exit out of rowHandler

2008-01-30 Thread Nathan Maves
I too have used RH'ers over very large data sets and never saw any memory issues. Be careful when issuing statements like And there is absolutely no doubt that the culprit is ibatis. I can't tell you how many times we have seen claim of ibatis failures only to find our that it was not. Give us

Re: iBATIS QUERRY TAKE LONG TIME AS COMAPARED TO NORMAL JDBC

2008-01-30 Thread Nathan Maves
Yuvraj , The ibatis community would need a while lot more information from you to even start to assess your issue. You gave us nothing to start with so our response will not be much more then that. Nathan On Jan 29, 2008 5:14 AM, Niels Beekman [EMAIL PROTECTED] wrote: Maybe you're typing

Re: Problems with returning a result set.

2008-01-22 Thread Nathan Maves
I am sure this is not part of the problem but you might want to upgrade your dtd's to point to the the new apache url. I would also want to see the api call that you are making to be sure you are not calling update. On Jan 22, 2008 2:37 PM, Randall Svancara [EMAIL PROTECTED] wrote: I have used

Re: Problems with returning a result set.

2008-01-22 Thread Nathan Maves
Just a heads up that you are sending a parameter object and not using it :) Are you positive that you are running the sql in SqlPlus against the same DB. I can't tell you how many times I get a config messed up and run my test against an empty DB. Nathan On Jan 22, 2008 2:37 PM, Randall

Re: problem returning primitive types from a query

2008-01-07 Thread Nathan Maves
I agree with Larry on this one. IB already supports autoboxing. The real issue here is why do you have nulls in a column that is represented by a primitive? If the column is null what would you expect your returned value to be as an int/boolean? On a second note Why such a push to use a

Re: Issue: CLOB datatype used with iBATIS

2008-01-04 Thread Nathan Maves
Generally this is most often a driver issue. Unsure that you are infact using the correct jar file for 10g. Nathan On Jan 4, 2008 5:46 AM, BEHL, Manish, IDC [EMAIL PROTECTED] wrote: Hi , I am currently facing an issue with usage of iBATIS(to which i am new to). Hope somone(who might have

Re: MySQL LAST_INSERT_ID selectKey?

2008-01-02 Thread Nathan Maves
This is correct with mysql. You can also specify the selectKey to be a pre or post then the placement of the code is not crucial. Nathan On Jan 2, 2008 3:54 PM, Justin Stanczak [EMAIL PROTECTED] wrote: I'm currently using this to return the inserted objects generated key. These are auto

Re: Batch Inserts and selectKey /

2008-01-02 Thread Nathan Maves
Gregg, The underlyng call is to http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#executeBatch()which as you can see from the javadocs only returns the number of effected rows. I don't know of any way that would allow you to return the ids for each batched insert with the current

Re: Batch Inserts and selectKey /

2008-01-02 Thread Nathan Maves
them for a parent child relationship. Are there any known solutions? So say I batch insert 100 parents. And then I need to batch insert 100 children for each parent. What is the best way to achieve this? Thanks. Gregg On Jan 2, 2008 6:37 PM, Nathan Maves [EMAIL PROTECTED] wrote

Re: hardcoding value in result map

2007-12-31 Thread Nathan Maves
With out really knowing the reasoning I can only guess at what you are trying to get here you could do the following... String value = (String)queryForObject(mapname, some.value); and in your map do select id=mapname resultClass=string select $value$ from dual /select In this example

Re: Inserting / not exist problem with date compare

2007-11-19 Thread Nathan Maves
well a few things catch my eye. use $ for the first parameters in the sql. INSERT INTO MY_TABLE ( COL1, COL2) SELECT $col1$, $col2$ FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM MY_TABLE WHERE COL1 = #col1# AND COL2 = #col2#) and second, if you are using timestamps you might have to specify the

Re: Using # in a schema name?

2007-11-15 Thread Nathan Maves
good question a better one might be how do you find the person that named the schema name that way and terminate their employment :) just a guess but try to use a double hash ## Nathan On Nov 15, 2007 6:55 AM, Ralf Assmann [EMAIL PROTECTED] wrote: Hi there, using iBATIS, we have to

Re: Using # in a schema name?

2007-11-15 Thread Nathan Maves
the string substitute is done before the parameters are set. so when the final string value was parsed there was an extra # in it. hence the need to escape it. On Nov 15, 2007 7:06 AM, Niels Beekman [EMAIL PROTECTED] wrote: That's weird, I would assume iBATIS to just inject the schemaname,

Devner JUG (DJUG) Presentation

2007-11-12 Thread Nathan Maves
Turns out I will be giving a hour long chat about iBatis this Wednesday at the Denver Java Users Group. (http://www.denverjug.org/index.jsp) This will be an introduction into iBatis but for anyone who has just started to use this framework you might find it interesting. Nathan Maves Frontier

Re: AW: unexpected ExceptionInInitializerError

2007-11-08 Thread Nathan Maves
hmmm please ensure that you have the following !DOCTYPE sqlMapConfig PUBLIC -//iBATIS.com//DTD SQL Map Config 2.0//EN http://ibatis.apache.org/dtd/sql-map-config-2.dtd; What larry is trying to find out is what xml parser is tomcat using but in reality almost any recent version of tomcat

Re: Re: problem with flushInterval in cacheModel

2007-11-07 Thread Nathan Maves
Yeah I was just looking into this. You might also want to force the constants to be long's as well. if (hours != null) t += (long)Integer.parseInt(hours) * 60l * 60l * 1000l; On Nov 7, 2007 3:35 AM, Niels Beekman [EMAIL PROTECTED] wrote: This is a bug. The problem is that the flush interval

Re: Oracle date type mapping issue

2007-11-07 Thread Nathan Maves
type to set your jdbc type to TIMESTAMP On Nov 7, 2007 8:58 AM, Thorsten Elfert [EMAIL PROTECTED] wrote: Hi, I use Oracle 9i, JDK 5 and the latest iBatis Release. Whenever I read a date object out of oracle and map it into a java.util.Date attribute the time gets truncated. I tried already

Re: problem with flushInterval in cacheModel

2007-11-06 Thread Nathan Maves
To your point of the exception that you get when you set the interval to 720 hours, can you post the exception? As far as the code goes public void setFlushInterval(int hours, int minutes, int seconds, int milliseconds) { errorContext.setMoreInfo(Check the cache model flush interval.);

Re: Problem with insertKey

2007-11-01 Thread Nathan Maves
on a side note make sure that you are calling the insert method on the sqlmapclient and not update or execute. Nathan On Nov 1, 2007 9:48 PM, Odelya Glick [EMAIL PROTECTED] wrote: Well, I changed it, but it always puts value 0. The sequence is declared like this: CREATE SEQUENCE

Re: Error setting property in case of a null value - How to map correctly ?

2007-11-01 Thread Nathan Maves
Not sure if this will correct your issue but you should only use a resultMap OR a resultClass not both. Nathan On Nov 1, 2007 10:11 AM, Thorsten Elfert [EMAIL PROTECTED] wrote: Hi, I am new on iBatis and I try to map an Oracle 9i based result and get the following error: Caused by:

Re: Caching problem using IBATIS

2007-11-01 Thread Nathan Maves
Two things. First, Ensure that your global cache setting is enabled in your config class. Second, Modifying the database behind the scene will not produce good results. The cache in your JVM will have no clue that the data was changed and you will always get the cached results. Nathan On

Re: How to achieve Dynamic SQL query in delete statement

2007-10-16 Thread Nathan Maves
Not sure how you are going to avoid writing 10 different sql statements and now you have some sql based in two different places (.java and .xml). I think you are over thinking this and would have already been done if you just placed the 10 delete statements in your sqlmap files :) of course

Re: How to achieve Dynamic SQL query in delete statement

2007-10-16 Thread Nathan Maves
and whereClause vars. Nathan Maves wrote: Not sure how you are going to avoid writing 10 different sql statements and now you have some sql based in two different places (.java and .xml). I think you are over thinking this and would have already been done if you just placed the 10

Re: mapping column with array

2007-09-13 Thread Nathan Maves
What is does the database look like? What are the column types? On 9/13/07, jaggernat [EMAIL PROTECTED] wrote: hi guys I am using DAO in my backend with IBATIS I have a java value-object in which i have defined something like public String id = null; public

Re: mapping column with array

2007-09-13 Thread Nathan Maves
so why are you using an array in your pojo I would just use a Float with that column def On 9/13/07, jaggernat [EMAIL PROTECTED] wrote: hi, I am using Db2 version 7.x ID_NO is defined as CHAR(10) and PRICE is defined as Decimal(3,4) thanks, J nmaves wrote: What is does the

Re: iBatis Select Query

2007-09-05 Thread Nathan Maves
I can only assume that you are talking about the queryForObject method. Which will return a null if a row is not returned. What is the issue that you are running into? Nathan On 9/4/07, prvijay [EMAIL PROTECTED] wrote: Hi, i a m using iBatis for executing a select query, it works fine

Re: Complex dynamic-SQL problems

2007-09-05 Thread Nathan Maves
To address the insert issue... Only specific drivers can handle this type of multiple statements. I would say a best practice would be to use your DAO layer to iterate over your set and do the batch inserts there. The batch might even be faster. Nathan On 9/5/07, Jonathan Alvarsson [EMAIL

Re: select key and insert with failure

2007-09-03 Thread Nathan Maves
Well I am not sure why you would care but I would suggest that when the insert fails, which should produce an exception, that you catch that and then set the id field back to null. Nathan On 9/3/07, Lott, Neil [EMAIL PROTECTED] wrote: Hello, If I have a selectKey pre within an insert

Re: Making use of statementCachingEnabled

2007-08-17 Thread Nathan Maves
I think it depends on what type of statement Executing Statement is. If it is an insert/update/delete then no. If it is a select statement and it is calling the same statement with the same parameters you will see a difference in the logs. Since you stated that you are doing a batch I would

Re: Multiple inserts in table with same sequence id

2007-07-18 Thread Nathan Maves
Simple use the return value from your insert. Nathan On 7/18/07, felix thomas [EMAIL PROTECTED] wrote: Hi, I have to insert in 1 Parent table and 4 child tables . I have written sqlMap which inserts in the parent table as below. insert id=insertCustomField

Re: Help needed to retrieve result class has ArrayList in its attributes.

2007-07-17 Thread Nathan Maves
I think you are looking for the complex properties functionality on page 36 of the developers manual. Nathan On 7/17/07, Jane Phillips [EMAIL PROTECTED] wrote: Hello, I need help to retrieve a query which one ID(product) assoicated many other info(client names etc). The lay out as

Re: New [EMAIL PROTECTED]

2007-07-05 Thread Nathan Maves
If you dont mind once the site/app is done, could use them on the Powered By page? Nathan On 7/5/07, Clinton Begin [EMAIL PROTECTED] wrote: Cool! Thanks for letting us know. Cheers, Clinton On 7/4/07, VRL Swamy Vadali [EMAIL PROTECTED] wrote: Friends, I am responsible for building

Re: Help with HashMap

2007-07-02 Thread Nathan Maves
Apology accepted. First off lets take a trip down the old API. from http://java.sun.com/j2se/1.5.0/docs/api/java/util/HashMap.html This class makes no guarantees as to the order of the map; in particular, it does not guarantee that the order will remain constant over time. Second, you can

Re: Minimum active connections in simple datasource

2007-06-18 Thread Nathan Maves
The DB connection pool you are using is designed to be SIMPLE as the name implies. If you need something a little more robust I would suggest using DBCP from Apache. Very easy to configure and it will have all the options you need. Nathan On 6/18/07, Gaurav Goel [EMAIL PROTECTED] wrote:

Re: New to iBatis

2007-06-15 Thread Nathan Maves
You could even go so far as to say... List names = new ArrayList(); names.add(moive one); names.add(movie two); Map params = new HashMap(); params.put(startDate, startDate); params.put(endDate,endDate); params.put(movieNames, names); SELECT movie_name FROM movies WHERE release_date between

Re: New to iBatis

2007-06-14 Thread Nathan Maves
If you are looking for more documentation pick up the iBATIS in Action book by manning. I highly recommend it. Nathan On 6/14/07, Brandon Goodin [EMAIL PROTECTED] wrote: Shameless plug: http://www.manning.com/begin/ Apart from that I would recommend you read the SQL Devleoper docs:

Re: checking for Database changes

2007-06-04 Thread Nathan Maves
Hmmm... My first thought is to let the database do this for you. I would use a trigger on the tables that you are watching. At that point you can trigger events as they come in. With out a little more background on the problem statement I am not sure how much help we can give. Nathan On

Re: executing batch file

2007-05-31 Thread Nathan Maves
Not quite sure what you are asking? Do you have an external file with statements in it that need to be executed? Or are you asking if ibatis can do batch inserts/updates ? Nathan On 5/30/07, Zsolt Koppany [EMAIL PROTECTED] wrote: Hi, what ist he best way to execute a batch file? Does ibatis

Re: Please help me.

2007-05-31 Thread Nathan Maves
Pretty simple actually, you can pass a string (non binding) variable into a sqlmap example sqlmap .. select * from $schema$.person where id = #id# /sqlmap Note the use of $$ and ##. The $$ uses a string substitution and not a jdbc parameter. On 5/31/07, Davy Pulinckx [EMAIL

Re: java.sql.SQLException : Column 'xxxxx' not found

2007-05-29 Thread Nathan Maves
at first guess I would suggest that you might have to enable the remapResults attribute. Please post your sqlmap and any resultmaps that you use for this query. On 5/29/07, rhastakid [EMAIL PROTECTED] wrote: Hi people. I'm new to Ibatis. we're using Ibatis without the use of Spring. so we

Re: Desktop apps with iBatis

2007-05-21 Thread Nathan Maves
Like any other application if you create it well the migration will be easy. ibatis should be hidden below your service layer in what most call the DAO layer. both apps should only contact this service layer. the front end could be anything. On 5/21/07, Caio Zanchetti [EMAIL PROTECTED]

Re: Sybase *BLOB and iBatis

2007-04-23 Thread Nathan Maves
Steven, Can you post some of your code here? How about and exception stack strace? We really need a bit more information before we can guess at what the issue might be. Nathan On 4/23/07, Steven G. Sajous [EMAIL PROTECTED] wrote: Has the issue with Sybase BLOBs and iBatis been resolved. I

Re: problem with simple result ... select=../

2007-04-23 Thread Nathan Maves
you might want to post your spring config file where you configure your datasource and sqlmap clients. Here is what I use. bean id=propertyConfigurer class= org.springframework.beans.factory.config.PropertyPlaceholderConfigurer property name=location

Re: Group By and a Union, possible collision.

2007-04-10 Thread Nathan Maves
I would assume that it will not handle it in the way you would like. How could it expect to know the difference. They in-fact have the same id I could be wrong, so don't take my word for it. Nathan On 4/10/07, Tom Henricksen [EMAIL PROTECTED] wrote: We are using a groupBy in our query for

Re: insert sql and function calls.

2007-04-06 Thread Nathan Maves
I can not think of a way to use the SelectKey tage to accomplish this task. You might have to pull them before the insert is called. Just set them on your user POJO and send it your your insert. Should be good to go then. Nahtan On 4/5/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello

Re: TypeHandler question

2007-03-31 Thread Nathan Maves
if the types matched. On 30/03/07, Nathan Maves [EMAIL PROTECTED] wrote: Can you post the result map of where you specify to use this type handler. Nathan On 3/29/07, Mikael Andersson [EMAIL PROTECTED] wrote: Hi, I wonder how typehandlers are resolved. Currently I am defining a couple

Re: iBATIS in Action errata

2007-03-19 Thread Nathan Maves
I found a real gem and let Brandon know. I will submit it if we find out how. On 3/18/07, Larry Meadors [EMAIL PROTECTED] wrote: Heh, I was reading over it this weekend, and saw a good one on pages 149-150. It just sort of stops in the middle of a sentence and resumes on the next page with

Re: Potential Bug - Recursive Queries?

2007-03-12 Thread Nathan Maves
Craig actually works with me and I have seen this issue first hand. Any one else tried to do this? On 3/8/07, Craig Swift [EMAIL PROTECTED] wrote: Hello, I wanted to report a potential bug in the latest release of IBATIS. This issue only appeared after performing a recent upgrade to the

Re: number of Initial connections

2007-02-26 Thread Nathan Maves
Tom, I tend to use the DBCP from apache over the SIMPLE one that we have included in IBATIS. It does add one more jar to the pile but oh well :) Here is a page that defines all of the parameters and what they do. http://jakarta.apache.org/commons/dbcp/configuration.html Here is the main DBCP

Re: Ibatis and tomcat problem

2007-02-16 Thread Nathan Maves
The only thing I can think of is that your Tomcat instance is using a different driver then your stand alone application. What are you using for datasource management? What database? What driver? Nathan On 2/15/07, Abhishek P Singh [EMAIL PROTECTED] wrote: hi All, i m facing a very strange

Re: how to create

2007-02-14 Thread Nathan Maves
Why do you want to remove that line. It should not be causing you any issues when parsing the xml file that is generated. Nathan On 2/14/07, disalle [EMAIL PROTECTED] wrote: Hi all, I have a simple table (for example PERSON) and I would like to create an xml file containing all table rows,

Re: how to create

2007-02-14 Thread Nathan Maves
implemented. -- *From:* Nathan Maves [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, February 14, 2007 2:20 PM *To:* user-java@ibatis.apache.org *Subject:* Re: how to create Why do you want to remove that line. It should not be causing you any issues when parsing

Re: resultMap problems with property mappings

2007-02-14 Thread Nathan Maves
Why are you not specifying the column name or index? On 2/12/07, Jonathan Chase [EMAIL PROTECTED] wrote: I kind of figured out the problem and a solution. I had an abstract class (AbstractEntity) that my entity (Foo) extended. A simplified version of the classes looks like: public abstract

Re: cannot write to property without a setter

2007-02-06 Thread Nathan Maves
I have never tried to do what you say in Spring. In fact I have never tried it at all :) My personal opinion is that you should never try and inject into private properties. Follow the bean specs and all will be well. Nathan On 2/6/07, Reuben Firmin [EMAIL PROTECTED] wrote: Let's say I

iBATIS in Action

2007-02-05 Thread Nathan Maves
high for the rest of us and I can only hope to give back a portion of what they have already given. Sincerely, Nathan Maves

Re: Calling a single-param SP

2007-01-26 Thread Nathan Maves
looks correct to me. give it a go On 1/26/07, Brandon Goodin [EMAIL PROTECTED] wrote: did you try it? On 1/25/07, Dave Rodenbaugh [EMAIL PROTECTED] wrote: Hi everyone, New question If I have a stored proc that takes a single parameter...is this the right way to call it in the SQL

implicit date issue

2007-01-21 Thread Nathan Maves
The following query does not work with Oracle 9i. select id=queryForCaseIds resultClass=string parameterClass= java.util.Date select distinct case_id from ( select case_id from case_history where last_update_date = #value# union select case_id from task_history where

Re: [VOTE] Promote iBatis for Java 2.3.0 to General Availability

2007-01-16 Thread Nathan Maves
+1 YEAH! On 1/8/07, Jan Vissers [EMAIL PROTECTED] wrote: +1 Clinton Begin wrote: +1 Yee haw! On 1/8/07, *Brandon Goodin* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: +1 On 1/8/07, *Jeff Butler* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi All,

Re: resultClass for BLOB field

2006-12-18 Thread Nathan Maves
Just a thought but you might want to think about never decrypting a password. I would just compare the two encrypted version. Just one extra safety step :) On 12/18/06, Clinton Begin [EMAIL PROTECTED] wrote: Sorry Karen, I messed up in my explanation. I didn't fully read your SQL or your

Re: ibatis v hibernate

2006-12-18 Thread Nathan Maves
These are all great success stories. Coming from someone who has never tried Hibernate I love reading these. What are some thought about putting together a page about IBATIS vs ORM (Hibernate)? Nathan On 12/17/06, Hariharan, Vadivelu (IE10) [EMAIL PROTECTED] wrote: Here are my cents on

Re: ibatis v hibernate

2006-12-18 Thread Nathan Maves
On 12/18/06, Nathan Maves [EMAIL PROTECTED] wrote: These are all great success stories. Coming from someone who has never tried Hibernate I love reading these. What are some thought about putting together a page about IBATIS vs ORM (Hibernate)? Nathan

Re: Is there any way to know the exact SQL statement passed from IBATIS to Database

2006-12-13 Thread Nathan Maves
Have you looked at enabling logging? If so what are you not seeing? On 12/13/06, John Chien [EMAIL PROTECTED] wrote: Dear Sir: How can I find the exact SQL statement I passed from IBATIS to database ? Is there anyway to find out ? Thanks, John Chien

Re: Is there any way to know the exact SQL statement passed from IBATIS to Database

2006-12-13 Thread Nathan Maves
this topic is covered on the wiki On 12/13/06, Tony Qian [EMAIL PROTECTED] wrote: add following in your log4j.xml !-- Loggers for iBATIS -- logger name=com.ibatis additivity=false level value=debug/ appender-ref ref=iBATISAppender/ /logger !-- Loggers

Re: How to insert a entire table read from access to oracle using ibatis?

2006-12-11 Thread Nathan Maves
I agree with Larry. Leave ibatis out. I have done it two ways in the past. The first is to export the table as a csv and then use Oracle's Sqlldr to load the values into the new table. The second is as Larry stated. select 'insert into TableA (col1,col2,col3) values

Re: Performance with iBatis/DAO/Spring

2006-11-26 Thread Nathan Maves
Is there also a reason why you are using a batch? Are you executing multiple inserts? Nathan On 11/24/06, Harish Ram [EMAIL PROTECTED] wrote: Hi Let me first apologize for bringing this up again. Unfortunately, I had to since I did not see any answers to this thread. And the project is on

Re: Passing ArrayList of Object for insert

2006-11-21 Thread Nathan Maves
Even better would be to iterate as Brandon stated but use the batch functionality of ibatis. This will dramatically increase your performance. Nathan On 11/21/06, Brandon Goodin [EMAIL PROTECTED] wrote: If you database supports multiple inserts in a single jdbc call. But I don't know which

Re: fetch first rows only

2006-11-02 Thread Nathan Maves
try $rows$On 11/2/06, Michael Zatko [EMAIL PROTECTED] wrote: Hi, I am having an issue substituting a variable in to a fetch first 10 rows only clause. The following is my sqlmap: select id =getTopRegisteredItems resultClass=com.boscovs.greports.models.TopRegisteredResult parameterClass

Re: how to deal with one-to-many relationship?

2006-10-27 Thread Nathan Maves
First off as a new user please take some time to read through the Developers Guide that can be found on the main page. Second what you are doing is the classic problem of 1:M. Your current code also has the N+1 problem. You will query once for you main select and N number of times for each row the

Re: how to deal with one-to-many relationship?

2006-10-27 Thread Nathan Maves
You are correct. You can not achieve this though the xml configuration. On 10/27/06, Koka Kiknadze [EMAIL PROTECTED] wrote:Nathan, I think the problem here is not the N+1 one. The Order object has a list of OrderLineItem objects. But one may want each instance of OrderLineItem to hold

Re: Singleton DAO and mutilple threads

2006-10-25 Thread Nathan Maves
One small addition to Larry's example. Just make sure that you use a private constructor to ensure that only one instance is ever created. BTW I second him to the point of using spring.Nathan On 10/25/06, Tony Qian [EMAIL PROTECTED] wrote: Larry,Thanks for prompt response and suggestions.TonyLarry

Re: Why can't I get to the download software pages?

2006-10-24 Thread Nathan Maves
not sure but I believe that the apache servers went off line for a bit. Apparently they are still having issues. On 10/24/06, Barnett, Brian W. [EMAIL PROTECTED] wrote: Couldn't get to them all day yesterday and still can't today. I click on iBATIS Java 2.2.0 w/Binaries, Source and

Re: Deprecating the DAO framework?

2006-10-23 Thread Nathan Maves
+1 as wellOn 10/23/06, Jeff Butler [EMAIL PROTECTED] wrote: +1 I also think Spring DAOs are a better option these days. iBATIS DAO was cool before Spring, Pico, etc. but it is looking a little dated. I see no reason to make it more functional when there are great alternatives. Jeff Butler On

Re: Deprecating PaginatedList interfaces and SqlMapClient method

2006-10-23 Thread Nathan Maves
+1On 10/23/06, Jeff Butler [EMAIL PROTECTED] wrote: +1 Most users don't understand what this is really doing. Jeff Butler On 10/23/06, Clinton Begin [EMAIL PROTECTED] wrote: Hi all,I'd like to suggest that we deprecate the PaginatedList interface, all implementations of it, and the

Re: BLOB

2006-10-23 Thread Nathan Maves
Make sure you are on the latest Oracle 10 drivers.On 10/21/06, Sameeh Harfoush [EMAIL PROTECTED] wrote:I had the same problem using ibatis on Spring frameworkcheck your Oracle driver. On 10/20/06, John Chien [EMAIL PROTECTED] wrote:Dear Sir:I defined a Oracle taleINSP_RULE with following

Re: iBatis, updates

2006-10-10 Thread Nathan Maves
Please post questions like these to the community email list.On 10/10/06, Nathan Maves [EMAIL PROTECTED] wrote:Begin forwarded message: From: Pecelis, Sergio [EMAIL PROTECTED] Date: October 10, 2006 1:11:40 PM MDT To: [EMAIL PROTECTED] Subject: iBatis, updates Hi, i saw your how_to in http

Multiple results maps

2006-10-05 Thread Nathan Maves
Here is the setuptwo tables invoice and userThe invoice table has two columns, one for the sales person and one for the customer. These map to their respective ids in the user table. To avoid the 2N+1 problem I join the tables. resultMap id=invoiceResult class=invoice ... result

Re: Scanning byte array

2006-09-29 Thread Nathan Maves
When you say scan are you looking for some specific bytes? If not just use a buffered reader to read and display the data. On 9/29/06, soussou97 [EMAIL PROTECTED] wrote: Hi; I have a method which return a byte array from a BLOB (Oracle) : public static byte[] getBLOB(int id, Connection

Re: iBATIS - Multiple where clause

2006-09-27 Thread Nathan Maves
como? how about some English please :) On 9/27/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: meador??? que forro. quien te crees que sos?? o anda a la lista de soporte aqui solo advanced programeitors. q boludo Ing. Gerardo Senilo 2006/9/27, Larry Meadors [EMAIL PROTECTED]:

Re: CRUD

2006-09-23 Thread Nathan Maves
There are a few things to consider with this request. I would say that 95% of the time your java properties will not match your db column names. You java object might also span multilple tables as well. I think you are asking a bit too much here. You might want to check out the tools section

<    1   2   3   4   >