RE: URGENT ::: Caused by: java.lang.NoSuchMethodError: oracle.sql.STRUCT.toClass(Ljava/lang/Class;Ljava/util/Map;)Ljava/lang/Object;

2006-07-13 Thread MCCORMICK, Paul
Hi Chaithanya, Is you second name really ibatis? From: chaithanya ibatis [mailto:[EMAIL PROTECTED] Sent: Friday, 14 July 2006 2:29 PMTo: user-java@ibatis.apache.orgSubject: URGENT ::: Caused by: java.lang.NoSuchMethodError: oracle.sql.STRUCT.toClass(Ljava/lang/Class;Ljava/util/Map;)Ljava/

URGENT ::: Caused by: java.lang.NoSuchMethodError: oracle.sql.STRUCT.toClass(Ljava/lang/Class;Ljava/util/Map;)Ljava/lang/Object;

2006-07-13 Thread chaithanya ibatis
Hi,I'm getting this error:using userdefined type in procedure.  in that type, the datatypes are  number(12,2), varchar2, number. In the dto ,i declared BigDecimal for number(12,2),when i read  using readBigDecimal . will this creates this problem or any thing else. pls give me solution. i have used

Re: inserting null

2006-07-13 Thread Larry Meadors
That is the default behavior. Larry On 7/13/06, Ben Munat <[EMAIL PROTECTED]> wrote: I see in the user's manual how one can tell ibatis to interpret a given property value as meaning it should insert null into the column... like an int value of - means insert null. What I don't see, how

inserting null

2006-07-13 Thread Ben Munat
I see in the user's manual how one can tell ibatis to interpret a given property value as meaning it should insert null into the column... like an int value of - means insert null. What I don't see, however, is how to tell ibatis that a null value for a property means insert a null. So, for

Strange problem reloading SQLMaps

2006-07-13 Thread Kevin Schraith
Hello, We're using iBATIS SQLMap with the DAO wrapping functionality, and we have run into a new problem with one of our sqlMap XML files not reloading correctly. After copying a new set of XML files to our Weblogic 9.1 server, we hit a JSP file that triggers the following code: Reader reader =

Re: Multiple ResultSet

2006-07-13 Thread Clinton Begin
I'd love for you to give it a shot. I think that's the biggest feature delaying 2.2.0 (by choice I suppose). So as soon as it's done, the other things are minor and we can ship it! Let me know if you run into a snag. Thanks Jeff, Clinton On 7/13/06, Jeff Butler <[EMAIL PROTECTED]> wrote:

Re: Multiple ResultSet

2006-07-13 Thread Jeff Butler
Makes sense - I hadn't thought about the multiple selects thing.  Makes it easier too.   I can redo the comma delimited list thing - pretty easy I think.   Jeff  On 7/13/06, Clinton Begin <[EMAIL PROTECTED]> wrote: Brandon and I were looking at this, and we figure that it should be possible to imp

Re: Multiple ResultSet

2006-07-13 Thread Clinton Begin
Brandon and I were looking at this, and we figure that it should be possible to implement it for both procedures and regular statements (some DBs support multiple selects in a single statement).  We shouldn't need a new method on the pulbic interface, as queryForList() should cover it (a list of "w

Re: Multiple ResultSet

2006-07-13 Thread Jeff Butler
I'll take a look at this if you still want help.   Here's what I would do:   - Change it so the you could specify a comma delimited list in the resultClass or resultMap on the declaration - Add a new method to SqlMapExecuter called executeProcedure that returns a list (takes id and optionally a pa

Re: result map property as hashmap

2006-07-13 Thread Bing Lu
also I'm trying to do just one query in DAO I have queryForMap("getNames", null,"role","name"); and the xml is select ROLE, NAME FROM TABLE1 WHERE SEQNO=34567 but in my resultclass I'm getting null, if I run the query on the database itse

Re: result map property as hashmap

2006-07-13 Thread Bing Lu
so what does column="EMP_ID" do in here, does it pass onto the next query as parameter? --- Debasish Dutta Roy <[EMAIL PROTECTED]> wrote: > Yes you can do that. > In your first resultmap, you are going to provide > the > > --- First resultmap --- > select="getEmployeeDetails"/> > > The select

Re: result map property as hashmap

2006-07-13 Thread Debasish Dutta Roy
Yes you can do that.In your first resultmap, you are going to provide the --- First resultmap --- The select id "getEmployeeDetails" has a corresponding resultClass is a HashMap.So this way you will only call one query the first one and one of the result will be a hash map. On 7/13/06, Bing Lu <[EM

Accessing Oracle column with data type TIMESTAMP WITH LOCAL TIME ZONE not possible

2006-07-13 Thread Florian Heinisch
Dear iBATIS Community, I am using iBATIS 2.1.7.597 with Oracle Database 10g Express Edition Release 10.2.0.1.0. I have got a table which has a column of the data type TIMESTAMP WITH LOCAL TIME ZONE. According to Oracle, one must invoke setSessionTimeZone(java.lang.String regionName) on oracle.jdb

result map property as hashmap

2006-07-13 Thread Bing Lu
Hi, I have a resultmap that's matching to a class, one of the result property is going to be a hashmap populated from the database using another query, I'm so sure about how to write this out in the xml file. Can anyone help me out here? thanks a bunch

Re: Abator vs. iBATIS....Brandon and Larry were right....doh.

2006-07-13 Thread Clinton Begin
>> Wow - your first e-mail about this in 6 months since Abator came out.  It's the first of a very specific kind: 1) personal and 2) confused about abator.  >> That doesn't sounds like an epidemic of confusion to me. Are you suggestiong we wait until it is?  Abator has been successful and that's a

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

2006-07-13 Thread jeremy jardin
Yes, it works !   I’ve had needed tag in my xml file using rpad like this:         MOBILE = rpad(#MOBILE#,12,' ')   isPropertyAvailable> Now, it’s ok.   Thx a lot.     -Message d'origine- De :

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

2006-07-13 Thread Jeff Butler
Yes - this is the correct way to do it.  Set the value for the MOBILE field, as well as the indicator for the field.   Jeremy - it looks, from your previous posts, that the SQL statement is being generated correctly.  Can you run the generated SQL statement (from the logs) in an SQL client to verif

RE: URGENT Cause: java.sql.SQLException: invalid name pattern: LXDV.T_FIN_DETAILS_TYPE

2006-07-13 Thread Poitras Christian
Can you post your sqlmap file?   If your type is userdefine, then you should (maybe must) define a TypeHandler for your type. Do you use one?   Chris From: chaithanya ibatis [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 July 2006 08:01To: user-java@ibatis.apache.orgSubject: URGENT Cause: ja

Re: Abator vs. iBATIS....Brandon and Larry were right....doh.

2006-07-13 Thread Jeff Butler
Wow - your first e-mail about this in 6 months since Abator came out.  That doesn't sounds like an epidemic of confusion to me.   But you have as much access to the web site as I do.  If you've got a clarifying statement you want to add somewhere, then feel free.   Jeff Butler  On 7/13/06, Clinton

Cause: java.sql.SQLException: invalid name pattern: LXDV.T_FIN_DETAILS_TYPE; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException :

2006-07-13 Thread chaithanya ibatis
HI,    when i use a Type (userdefined) in oracle as OUT parmaters in procedure. i have got this problem. can any one tell me what is the exact cause for these.i have these type defined outside the package. and procedure is also in outside package. what is the reason for this error..and how can

URGENT Cause: java.sql.SQLException: invalid name pattern: LXDV.T_FIN_DETAILS_TYPE

2006-07-13 Thread chaithanya ibatis
HI,    when i use a Type (userdefined) in oracle as OUT parmaters in procedure. i have got this problem. can any one tell me what is the exact cause for these.i have these type defined outside the package. and procedure is also in outside package. what is the reason for this error..and how can

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

2006-07-13 Thread Graeme J Sweeney
On Thu, 13 Jul 2006, jeremy jardin wrote: So I want to launch a request with a where clause on "MOBILE" property. When I look on the XML file, I just can't see that : Sould I had the property ?? Pour votre Anglais: add not had From your abator generated classes you should have a UTILISA

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

2006-07-13 Thread jeremy jardin
I think that I'am understanding the matter with my request. I precise one more time that my xml and dao files have been generated using Abator. So I want to launch a request with a where clause on "MOBILE" property. When I look on the XML file, I just can't see that : CL