RE: Just Another Stored Procedure Question

cause i've been coding ibatis sqlmaps like that for quite some time (i know it's better using namespaces.. but we're a little occupied now to fix it) thank you... and please CMIIW.. yusuf -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Thursday, February 2

RE: Just Another Stored Procedure Question

elect : select EKA.SISTEM_KONTROL_SPAJ.generate_counter(#msco_number:number#, #lca_id:varchar#, #prefix:varchar#, #suffix:varchar#, #length:number) from dual but I'm still curious how to make this work... are there any other suggestions? thanks & best regards, yusuf -Or

Just Another Stored Procedure Question

Hi, Really2 sorry for asking, i know this has been asked before many times, i have browsed through the docs, the faqs page, and the mailing lists, but i can't seem to make this work (oracle): oracle procedure : PROCEDURE generate_counter ( v_result OUT VARCHAR2, v_msc

RE: implicit date issue

Hi, for what it's worth, i looked into my xml and found this select case when to_char(#value#,'dd') to_char(add_months(#value#,1),'dd') then to_date(to_char(#value#,'dd') || '/' || to_char(add_months(#value#,1),'mm/'),'dd/mm/')

RE: iBatis Typehandler problem

Hi! Thank you that solved the problem :) and for another newbie's sake, i've found a second solution, by defining a parameterMap/resultMap for each query that uses the type handler, like : thanks, Yusuf -Origin

iBatis Typehandler problem

on occured, can someone help me? thanks in advance : Exception : org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in org/yusuf/demo/dao/sql/db.xml. --- The error occurred w

MyJavaServer

d the mcs2 to the public)? thanks and please CMIIW, yusuf

RE: Date format conversion to/from db

you could use something like this in displaytag, just look in the docs: yusuf -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 12:39 AM To: user-java@ibatis.apache.org Subject: Re: Date format conversion to/from db Hmm, it&#

RE: got sql exception:

as suggested by the exception (ORA-00600), its an internal oracle error, and not related to ibatis. you can consult this problem in the metalink or oracle support. cmiiw. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 8:49 AM To: user

RE: IBATIS not working

Hello, regarding this problem, I added this in the FAQ : http://opensource.atlassian.com/confluence/oss/display/IBATIS/2006/08/17 /Problems+with+WHERE+clause+involving+CHAR+data+types please, CMIIW yusuf -Original Message- From: Gwyn Evans [mailto:[EMAIL PROTECTED] Sent: Friday, August

query multiple column with Integer resultClass successfully executed

is it made like that? I'm using iBATIS 2.1.7 and Oracle 8i.. thanks.. Yusuf

RE: RE : RE : RE : RE : request using beanExample

i had this kind of problem and solved using right padding with empty space, eg. Select UUID, MOBILE,ORIGINE_UUID,ETAT,LOGIN, ETAT_MODIFIE,TSTMPINSR, TSTMPUPDT from UTILISATEUR where MOBILE = rpad(#value#,12,' ') Regards, Yusuf -Original Message- From: jeremy jardin [mai

RE: sql map via Java API

just my opinion, but what's the point of using iBatis if you wanted to build a statement at runtime? maybe you can just use simple jdbc? yusuf -Original Message- From: Edwin Lukaweski [mailto:[EMAIL PROTECTED] Sent: Friday, June 23, 2006 3:28 AM To: user-java@ibatis.apache.org Su

Reloading sqlmaps

.xml"); sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader); to reinstantiate the new sqlmap, but the sqlmap still referenced to the old one.. thank you, yusuf.

RE: Exception net.sf.cglib.beans.BulkBeanException on resultMap with selects

Hi, I found the solution.. sorry about this, guess I'll have to re-check my "double checking" effort.. its only a class casting issue (i've mapped a String column to an Int) Yusuf. -Original Message- From: Yusuf Sent: Monday, May 15, 2006 9:55 AM To: user-java@ibati

Exception net.sf.cglib.beans.BulkBeanException on resultMap with selects

is there anyone who knows the solution to this problem? thank you, Yusuf.

RE: iBatis enhancements (Annotations and/or Dynamic beanutils support)

Oh... All this time I thought that was a bug :) Thanks for the correction. Yusuf -Original Message- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 03, 2006 10:52 AM To: user-java@ibatis.apache.org Subject: Re: iBatis enhancements (Annotations and/or Dynamic beanutils

RE: iBatis enhancements (Annotations and/or Dynamic beanutils support)

yes, it can be BigDecimal, String, or Date, and ibatis does the conversion automatically for you (i don't know how, you have to ask the gurus here ^^) there's a list of supported types in the developer's guide pdf page 31 Yusuf -Original Message- From: Brent Ryan [mailto:[

RE: iBatis enhancements (Annotations and/or Dynamic beanutils support)

you put a java.util.Date in a HashMap, then it'll only save the date value, not the time (example: the value "01/01/1981 19:23:12" will be saved as "01/01/1981 00:00:00) yusuf -Original Message- From: Brent Ryan [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 03, 2006 9:39 AM T

RE: Need help with Ibatis Runtime Error

in this statement: select * from system_lookup where TheStatus = 'ACTIVE' and type = #type# you should replace resultClass="selectionResult" to resultMap="selectionResult" -Original Message- From: Naijatek [mailto:[EMAIL PROTECTED] Sent: Friday, April 28, 2006 10:24 AM To

RE: Invalid Column Type issue in confluence

lly thanks for the help :) Yusuf. -Original Message- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Thursday, April 27, 2006 10:01 AM To: user-java@ibatis.apache.org Subject: Re: Invalid Column Type issue in confluence The JDBC type specified in the mapping can only be one of the sta

RE: Invalid Column Type issue in confluence

of column COMM : try { Reader reader = Resources.getResourceAsReader("sql-map-config.xml"); SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); Map map = new HashMap(); map.put("empno", new Integer(1234)); map.put(&quo

RE: pager in ibatis

Hi, I don't know if this is true, but i think i've tried that solution before, and when i see the log generated from the ResultSet, it actually query all the data, and then selecting only the required record to show.. Yusuf. -Original Message- From: [EMAIL PROTECTED] [mai

RE: Invalid Column Type issue in confluence

actually i've been having this problem for quite some time, but i will try to reproduce and post it here again just to make sure its not other column. thanks :) Yusuf. -Original Message- From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 10:24 PM To: user

Invalid Column Type issue in confluence

#sold_date# ) I was wondering if someone actually having the same problem with me, currently i'm using - iBATIS 2.1.5 build 582 - oracle 8.1.7 - oracle10g jdbc thin driver (ojdbc14.jar) - c3p0 0.9.0.2 Thanks :) Yusuf.

RE: pager in ibatis

using the queryForPaginatedList (without caching) will always fetch the entire result and then showing only the selected records, and if the record count is high (like thousands..) then the performance will be bad. cmiiw, Yusuf. -Original Message- From: John Chien [mailto:[EMAIL PROTECTED]

RE: Log 4j prob

maybe it's a class loading issue? i mean if you have commons-logging in your library, you should make sure that log4j gets loaded first cmiiw.. Yusuf S. -Original Message- From: Engel, Gregory A [mailto:[EMAIL PROTECTED] Sent: Thursday, March 09, 2006 1:30 AM To: '

Missing hours/minute/seconds in querying field with DATE type

Is there a solution to this? Thank you, Yusuf.

RE: Cache

Really?? but I have add it under the "Common Problems" category with the entry "How can I enable the caching feature of iBATIS".. this is the direct link: http://opensource2.atlassian.com/confluence/oss/pages/viewpage.action?pa geId=3304 Yusuf. -Original Message

RE: Cache

In my case, i tried to remove the dummy and the caching still worked.. Actually I've never used the wiki before :), but I tried to add in http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Frequentl y+Asked+Questions is it in the correct place? Thanks, Yusuf. -Original Me

RE: Cache

Hi, at last i found the problem... I'm missing this config: but i'm pretty sure the docs said that cacheModels are enabled by default. Anyway.. thanks for the feedback, Yusuf -Original Message----- From: Yusuf Sent: Monday, February 20, 2006 12:01 PM To:

RE: Cache

t know the exact version, but an older one) i successfully used the caching feature.. Thanks, Yusuf. -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 11:07 AM To: user-java@ibatis.apache.org Subject: Re: Cache Yeah...this is almost a bug, but not

Cache

query again to database.. is there something wrong with my config? Thanks, Yusuf S.

RE: Different Number of Columns in resultClass with xml and with HashMap

results to a Map or a class, then the result is correct (10 columns) - if i use resultMap="xml", then the result is only 8 columns (without the 2 which contains another select) have anyone experienced this before? or a bug? Thanks, Yusuf. -Original Message----- From: Y

RE: dynamic insert question

oops I'm sorry, didnt see that.. Yusuf S. -Original Message- From: Meindert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 3:22 PM To: user-java@ibatis.apache.org Subject: RE: dynamic insert question He already said that ## didn't work (because it is a select

RE: dynamic insert question

want the select is like this: select $family$,partnum,parttype,'N' from cto.partinfo where .. And I will input one parameter like '8848' (or others) to family. What's solution for it? Thanks Steven On 2/7/06, Yusuf < [EMAIL PROTECTED] <mailto:[EMAIL PROTE

RE: dynamic insert question

Hi, Does the "PartVO" object have a property named "domain" and it's a list or an array? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 1:33 PM To: user-java@ibatis.apache.org Subject: dynamic insert question Dear all, I want inser

Different Number of Columns in resultClass with xml and with HashMap

27;ve done something wrong? Thank you for your help and regards, Yusuf S.

RE: Dynamic sql statement

id=#id# area in ('SC','EC','CC','NC','NE','SW','NW') And also, for a lot more easier way to debug your sql statements, try using log4j, you can read the guide in iBatis Data

RE: iBatis usage pattern

Hi All, I think I'm starting to understand now, well I guess I'm off to designing a good domain model before trying to do something else :) And for what it's worth, I think iBatis is still the best out there for this kind of tool. Thank You, Yusuf. -Original Message- Fro

RE: iBatis usage pattern

aybe other ibatis' functionalities, but never mess with the domain model. Is it correct? If I'm not wrong, this is also the concept of all those ORM tools like hibernate, jdo, and others? Thanks, Yusuf. -Original Message- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Saturday, J

iBatis usage pattern

p emp; private Bonus bonus; //... getter setter } Thank you, and I'm sorry for a rather long question, but I've been wondering about how do people used to map their results. Yusuf

Ref Cursor Support in iBatis

Hello, I was wondering about the support for ref cursors in ibatis, and i stumbled upon this in the ibatis wiki page (http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Oracle+R EF+CURSOR+Solutions):

RE: [ABATOR] Future Plans

OR LOWER (table_name) = 'v_temp'; RESULTMAP 10 rows selected. SQL> DROP VIEW v_temp; View dropped. SQL> Yusuf. -Original Message- From: Jeff Butler [mailto:[EMAIL PRO

How to not verbosely declare resultmaps?

Dear All, I've been using ibatis for about 1 year now, and i'm very satisfied with it! I wanted to ask if i can do this: SELECT name, age, address, income FROM person but I wanted the default datatype for NAME is String, AGE is Integer, and INCOME is Double, not the default BigDecimal.. witho

RE: [ABATOR] Future Plans

Dear Mr. Jeff Butler, I don't know if this is the correct place to ask or request for additional wishes for Abator, but I was wondering if Abator supports a feature to autogenerate resultmaps for example maybe like this: I have a SELECT statement like this: SELECT a.col_a1, a.col_a2, a.col