Need help on calling stored procedure from ibatis

                As I am new to ibatis, I need your help on calling stored
procedure from ibatis.

Here is the code I am trying to call stored procedure, but it is not
working.

Stored procedure as follows:-

getRadiusData( rc  OUT SYS_REFCURSOR,ArgFromDate in varchar2,ArgEndDate in
varchar2,
rptType VARCHAR2,timeRange VARCHAR2, authStatus  VARCHAR2,userName
VARCHAR2,identityGroup VARCHAR2 ,
netwokDeviceGroup  VARCHAR2 ,netwokDevicename  VARCHAR2 ,accessService 
VARCHAR2 ,identityStore  VARCHAR2 ,
acsInstance  VARCHAR2,Failure_Reason  VARCHAR2,Calling_Station_ID 
VARCHAR2,Device_IP_Address  VARCHAR2,
Audit_Session_ID VARCHAR2,ACS_Session_ID VARCHAR2, Acct_Session_ID
VARCHAR2,isMab VARCHAR2,adDomain VARCHAR2,
CTS_Security_Group VARCHAR2,  Show_SGT_Assign VARCHAR2, Show_SGT_Environment
VARCHAR2,ID number ,
isDrillDown number)

XDEQueriesMap.xml file has entry as follows:-

    <procedure id="getRadiusData" parameterClass="java.util.HashMap"
resultClass="java.util.HashMap">
          {call getRadiusData(?, #FromDate#, #ToDate#,
#AuthenticationStatus#, #TimeRange#, 'All', #UserName#, 'All', 'All', 'All',
'All', 'All', 'All', #FailureReason#,

What is the JDK version required for iBatis latest

Moving iBatis to the Attic

My feeling is that the iBatis PMC wish to move to the Attic, this
would mean the project becoming read-only.

If anyone of the iBatis committers are -1 to moving it to the Attic,
please speak up on this thread in the next week (i.e. by Friday 28th
May 19:00 PST).

This is the proposed text that would be sent to the board as a
resolution at the next board meeting.

*******************************************************************************
Termination of the iBatis PMC

       WHEREAS, the Board of Directors deems it no longer in the best
       interest of the Foundation to continue the Apache iBatis project
       due to inactivity

       NOW, THEREFORE, BE IT RESOLVED, that the Apache iBatis
       project is hereby terminated; and be it further

       RESOLVED, that the Attic PMC be and hereby is tasked with
       oversight over the software developed by the Apache iBatis
       Project; and be it further

       RESOLVED, that the office of "Vice President, Apache iBatis" is
       hereby terminated; and be it further

       RESOLVED, that the Apache iBatis PMC is hereby terminated.
*******************************************************************************

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: dev-help <at> ibatis.apache.org

[ANNOUNCEMENT] iBATIS Project Team Moving to Google Code

Created: (IBATIS-790) Wiki sign up not working

Wiki sign up not working
------------------------

                 Key: IBATIS-790
                 URL: https://issues.apache.org/jira/browse/IBATIS-790
             Project: iBatis for Java
          Issue Type: Bug
            Reporter: Clemens Fuchslocher

The sign up form doesn't work and the CAPTCHA is broken too.

* http://www.apachebookstore.com/confluence/oss/display/IBATIS/Home
* http://www.apachebookstore.com/confluence/oss/signup.action

License header in source files

Hi Devs,
I just downloaded the iBATIS 3 GA (Candidate) and peeked at the
accompanying sources.  I'm wondering why they're missing the
appropriate license headers[1]?

Thanks,
--tim

[1] - http://www.apache.org/legal/src-headers.html#headers

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: dev-help <at> ibatis.apache.org

[ANNOUNCEMENT] iBATIS Wiki Moved

The iBATIS Wiki has moved.  It was not moved by us, or with our
knowledge, but we apologize for the inconvenience anyway.

The new link is:

 http://www.apachebookstore.com/confluence/oss/display/IBATIS/Home

I will update the links on the website ASAP, but people.apache.org was
also unreachable last night, so I was unable to do so.

I'll respond to this message once the site links are corrected.

Cheers,
Clinton

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: dev-help <at> ibatis.apache.org

Wiki down?

iBatis 3 Java, an annotation for select, with result map in XML

Hi there,

I recently have been upgrading my iBatis 2.x projects to now use iBatis 
3.  I really appreciate the work done to create this new Mapper 
interface. And related I have started to play with having some of the 
simpler queries live as  <at> Select annotations on the mapper interface 
method now instead of in the XML.

I noticed for the  <at> Select annotation, it is possible to have the results 
of the statement mapped to a java bean if I use the  <at> Results annotation.

Would it be possible to create a new annotation (or does one exist 
already and I just have not found it yet),  where I can specify that 
 <at> Select results should be a <resultMap>  that exists in the mapper XML 
file ?

For example,

Consider a "country" table,

[code]
CREATE TABLE COUNTRY
(
    ID bigint PRIMARY KEY NOT NULL,
    CODE varchar(2) NOT NULL,
    ISO_CODE varchar(3) NOT NULL,
    NAME varchar(2147483647),
    COUNTRY_CODE varchar(10),
    ACTIVE boolean DEFAULT TRUE NOT NULL
);
[/code]

And the java Bean,

[code]
public class Country {
   Long    id;
   String  code;         // 2 digit ISO country code
   String  isoCode;      // 3 digit ISO country code
   String  name;         // string name
   String  countryCode;  // the telephone dialing prefix (e.g. +1)
   boolean active = true;

   // and all the get()  set() methods for these bean properties
}
[/code]

And then the mapper interface,

[code]
public interface CountryDAO {

   /**
   * Selects all country entries.
   * Though it appears when we use the annotations, we need to specify 
the results every time ?
   */
    <at> Select( value = { "select * from country where active = true" })
    <at> Results(value = {
        <at> Result(property="id"),
        <at> Result(property="code"),
        <at> Result(property="isoCode", column="iso_code"),
        <at> Result(property="name", column="name"),
        <at> Result(property="countryCode", column="country_code"),
        <at> Result(property="active", column="active")
   })
   List<Country> getAllActive();

   // TODO: all these methods would also be select queries, where I 
would want the same results map as above
   Country getById(Long id);
   Country getByCode(String code);
   Country getByIsoCode(String isoCode);
}
[/code]

Where, instead of the  <at> Results  annotation, which would need to be 
duplicated with its nested  <at> Result annotations on every select method 
that I want to return the same mapping, what I would wish to have would 
be something like a

 <at> ResultMap(value="myMapperID")

annotation, where the myMapperID would be the ID of a <resultMap> I have 
declared in the mapper's xml file that will be included by the 
SqlMapConfig.xml (which I have anyway to bind to this mapper interface, 
and also because I have some more complex queries declared in the xml 
mapper file too).

Where in this example, I already have a

[code]
<mapper namespace="CountryDAO">

<resultMap type="Country" id="countryResult">
<result property="id" column="id"/>
<result property="code" column="code"/>
<result property="isoCode" column="iso_code"/>
<result property="name" column="name"/>
<result property="countryCode" column="country_code"/>
<result property="active" column="active"/>
</resultMap>
[/code]

So this wishful  <at> ResultMap annotation would then make the mapper 
interface look like:

[code]
public interface CountryDAO {

    <at> Select( value = { "select * from country where active = true" })
    <at> ResultMap(value = "countryResult")
   List<Country> getAllActive();

   // and now other things that want to select into this map can do so, 
re-using the single map declaration
   // that is referenced in the xml.

    <at> Select( value = { "select * from country where id = #{id} })
    <at> ResultMap(value = "countryResult")
   Country getById(Long id);

    <at> Select( value = { "select * from country where code = #{code} })
    <at> ResultMap(value = "countryResult")
   Country getByCode(String code);

    <at> Select( value = { "select * from country where isoCode = #{isoCode} })
    <at> ResultMap(value = "countryResult")
   Country getByIsoCode(String isoCode);
}
[/code]

I think having something like this  <at> ResultMap annotation would be a good 
thing to have,  what do you think?

--
Travis

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: dev-help <at> ibatis.apache.org

[VOTE] Use Sonatype Nexus for Maven Releases

Changed Maven Artifact ID and location for iBATIS 3