Re: [NOTICE] Intending to release 2.2.1

2006-11-07 Thread navrsale
Although it seems straightforward and logical decision, I don't think it is a good idea, primarily because of interface immutability principle, which have been proven as beneficial on many large scale projects. Once it is published it is published, that's it (for example, in servlet specs there a

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread Jeff Butler
Take a look in the developer's guide - there's a section on inline paramter syntax.   Jeff Butler   On 11/7/06, navrsale <[EMAIL PROTECTED]> wrote: I changed params to correct order. I tried to use String directly inresultMap but get error: java.lang.RuntimeException: Error occurred.  Cause:com.iba

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread navrsale
I changed params to correct order. I tried to use String directly in resultMap but get error: java.lang.RuntimeException: Error occurred. Cause: com.ibatis.common.xml.Nodele tException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: co

com.microsoft.sqlserver.jdbc.SQLServerException: The request for procedure 'NAME_SPACE_GET' failed because 'NAME_SPACE_GET' is a function object.

2006-11-07 Thread viren1
Hi, I just started using MSSQL 2005 jdbc 1.1 driver and getting a following exception. Till now I was usiing mssql jdbc 2000 drivers everything worked perfect. Here "NAME_SPACE_GET" is user define function. Any kind of help would be appreciated. com.ibatis.dao.client.DaoException: Failed to exe

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread Jeff Butler
It's not just random - the parameters you supply must match what's required by your procedure.  In the example you gave, you had syntax like this:    { ? = call ipgrouper_it2.load_validation.get_post_validation_report( ? )}   This implies that the first parameter (the first question mark) is an OUT

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread navrsale
I investigated further. I tried different combinations, with stored procedure (one IN, one OUT parameter) and stored function (one IN parameter). None of these combinations works. Either I get empty result set, or error complaining about number or type of parameters for stored procedure. It could

Re: resultMap in another file

2006-11-07 Thread Michael Lumley
Hi there,I haven't actually tried it myself, but in the developer guide it says in order to use namespaces, you must enable useStatementNamespaces in the "settings" elements of your SQL Map Xml config file. By default it is disabled. CheersMichaelOn 04/11/06, Landry Soules <[EMAIL PROTECTED]> wrote

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread navrsale
I still get an error but this probably solves part of the problem! This error is probably due to opening cursor over Oracle nested table which is different than ordinary physical table. Not sure. Maybe I have another error in the mapping file? Or maybe ref cursor can be processed in iBatis only

Re: redundancy in resultmap declaration ?

2006-11-07 Thread Landry Soules
Wow, i've been really dumb ! Excuse me, i didn't realize at first that you talked about sql-map-config.xml. It works now. Thanks a lot. Landry Larry Meadors a écrit : Well, you just have to make sure that before you refer to a result map that it is defined. For example, if you have two res

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread Jeff Butler
I think the order of your elements is wrong - the first one should be the OUT parameter, and the second one should be the IN parameter.  Like this:      javaType="java.sql.ResultSet" jdbcType="ORACLECURSOR" mode="OUT" resultMap="report_line_mapping"/> Jeff Butler   On 11/7/06, navrsale <[EMA

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread navrsale
Here is the driver info from the manifest file: Manifest-Version: 1.0 Specification-Title:Oracle JDBC driver classes for use with JDK14 Sealed: true Created-By: 1.4.2_08 (Sun Microsystems Inc.) Implementation-Title: ojdbc14.jar Specification-Vendor: Oracle Corporation Specification-Versi

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread navrsale
This is the full error trace log: * Nested Exception (Underlying Cause) --- com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in mappings/StoredProcedures.xml. --- The error occurred while applying a parameter map. --- Check the Grouper.postLoadValida

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread navrsale
Unfortunatelly I still get the error. I replaced classes12.jar driver with ojdbc14.jar, recompiled, redeployed and again the same error: * Nested Exception (Underlying Cause) --- com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in mappings/StoredProcedures.x

Re: redundancy in resultmap declaration ?

2006-11-07 Thread Larry Meadors
Well, you just have to make sure that before you refer to a result map that it is defined. For example, if you have two result maps "rmCity" and "rmState", and "rmState" uses "rmCity" to build a list of cities per state, then you have to define "rmCity" first. If you define them in two files - li

Re: redundancy in resultmap declaration ?

2006-11-07 Thread Landry Soules
Thank you for the answer Larry, but can you please be more explicit, as i don't know how to achieve this Where to include country.resultmap in my code ? .. select * from country where id = #value# Larry Meadors a écrit : Include the r

Lazily loading user defined types

2006-11-07 Thread Johannes Klose
Hi, i'm trying to do lazy loading on user defined properties, e.q. beans on 1:1 relationships. However, it isn't working as i'm not using cglib. I found a message in another thread in this list, stating that lazy loading would work on user defined properties if they are typed as interfaces. But t

Re: Cached list from queryForList() ...

2006-11-07 Thread Eric Tan
Hi Larry,Doh! Forgot about that feature. Thanks...I think a serializable read/write cache is what I need. A different cache object for each session.A few questions:1. Where are the serialized cached objects physically stored?2. When does the serialized cached object per session get cleaned up? 3. C

Re: 1 TO N UPDATES

2006-11-07 Thread proge . allievi
Ok I supposed it thanks Cordiali saluti/Kind Regards. Alessandro Allievi (Embedded image moved to file: pic16078.gif) www.progesoftware.it Via Mentore Maggini, 48/50 00143 Roma Phone +39 06.5042621 Fax +39 06.5042676 mailto: [EMAIL PROTECTED]

Re: 1 TO N UPDATES

2006-11-07 Thread Larry Meadors
No. You have to do that yourself. Larry On 11/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello everybody. I need help undestanding a thing. I can execute 1 to N select, selecting data from tables from 1-N relation. There is a way to execute an automatic "insert" or "update" in such t

Re: Programmatic sqlMapClient configuration

2006-11-07 Thread Clinton Begin
The cache enabled/disabled flag causes the SqlMapClient to be built differently.  So changing it after the fact won't do anything.Unfortunately programmatically configuring iBATIS at this time is an absolute nightmare.  You'd be better off generating the XML configuration you're interested in and t

Re: Programmatic sqlMapClient configuration

2006-11-07 Thread Guillaume Carré
2006/11/3, Larry Meadors <[EMAIL PROTECTED]>: I do not think that is going to be that simple - iirc, when i last looked at how that works, it happens at load time, not at runtime. Setting the bit to false will not do anything unles you do it before you load the configuration. How could I do tha

Re: [2.2.0] Support for Oracle Ref Cursor

2006-11-07 Thread Clinton Begin
You guys will need to use the Oracle 10g drivers, even if you're using Oracle 9i.  The driver is backward compatible, and is more compliant with the JDBC spec so it works properly (only took them 10 years).  ;-)Cheers, ClintonOn 11/6/06, navrsale <[EMAIL PROTECTED]> wrote: I also tried the other ex

RE: Multiple Records in ActionForm

2006-11-07 Thread Poitras Christian
Look at the iterate tag. -Original Message- From: Mustafa DASGIN [mailto:[EMAIL PROTECTED] Sent: Tuesday, 07 November 2006 05:00 To: user-java@ibatis.apache.org Subject: Multiple Records in ActionForm Hi, I have an actionform like below: public class StudentListForm { private Str

Re: Can I see the actual SQL that ibatis running?

2006-11-07 Thread Carfield Yim
sorry missing this, I just type "ibatis dev guide" at google but haven't really check the links at home page Guillaume Carré wrote: > > 2006/11/7, Carfield Yim <[EMAIL PROTECTED]>: >> >> Where can I find the dev guide for java? I can only find the dev guide >> for >> .NET > > http://ibatis.apa

INSERT UPDATE

2006-11-07 Thread proge . allievi
Hello everybody. There is a way to execute an INSERT UPDATE automatically or I need to execute the control of existence of the element? Cordiali saluti/Kind Regards. Alessandro Allievi (Embedded image moved to file: pic10592.gif) www.progesoftware.it Via Mentore Maggini, 48/50 00143 Roma P

1 TO N UPDATES

2006-11-07 Thread proge . allievi
Hello everybody. I need help undestanding a thing. I can execute 1 to N select, selecting data from tables from 1-N relation. There is a way to execute an automatic "insert" or "update" in such tables? For example: table a IDKEY table b IDKEY ID2 KEY

Multiple Records in ActionForm

2006-11-07 Thread Mustafa DASGIN
Hi, I have an actionform like below: public class StudentListForm { private String [ ] name; private String [ ] number; . } Is there an easy way to insert these attributes at once to the database or i have to insert each entity one by one with converting to StudenForm which has:

Re: Can I see the actual SQL that ibatis running?

2006-11-07 Thread c . zecca
Carfield Yim <[EMAIL PROTECTED]> ha scritto il 07/11/2006 07:41:37 > > Can I see the SQL that ibatis generated and log it before press to database? Section "Logging SqlMap Activity" at page 62 of the Developer guide (iBATIS-SqlMaps-2_en.pdf) gives a first explanation. You can find further refe

Re: Can I see the actual SQL that ibatis running?

2006-11-07 Thread Guillaume Carré
2006/11/7, Carfield Yim <[EMAIL PROTECTED]>: Where can I find the dev guide for java? I can only find the dev guide for .NET http://ibatis.apache.org/javadownloads.html -- Guillaume Carré

Re: Can I see the actual SQL that ibatis running?

2006-11-07 Thread Carfield Yim
Where can I find the dev guide for java? I can only find the dev guide for .NET Koka Kiknadze wrote: > > Look at logging section in dev guide. All you'll have to do is configure > logging level in your log4j.properties. > > > > On 11/7/06, Carfield Yim <[EMAIL PROTECTED]> wrote: >> >> >> Ca