Hi - 

I had a bit of time again to evaluate v2.4.0 JOOQ for my Oracle database 
project. I've run into an error with the generated code for a user defined 
type. Here is a snippet of my defined type. Notice that it has both a 
variable declared as office_id and an accessor defined as get_office_id. 
The code generator automatically creates to matching Java methods for these 
two pieces as shown below the UDT snippet.

Peter

create or replace

type location_ref_t

is object(

   office_id        varchar2(16),

 

…

 

   /**

    * Returns the office identifer of the instance

    *

    * @return the office identifier of the instance

    */

   member function get_office_id

   return varchar2,

 

...


/**
 * This class is generated by jOOQ
 */
package db.oracle.udt.records;

/**
 * This class is generated by jOOQ.
 */
@javax.annotation.Generated(value    = {"http://www.jooq.org";, "2.4.0"},
                            comments = "This class is generated by jOOQ")
public class LocationRefTRecord extends 
org.jooq.impl.UDTRecordImpl<usace.cwms.db.oracle.udt.records.LocationRefTRecord>
 
{

    private static final long serialVersionUID = -2038921493;


...

    /**
     * The UDT column <code>CWMS_20.LOCATION_REF_T.OFFICE_ID</code>
     */
    public void setOfficeId(java.lang.String value) {
        setValue(usace.cwms.db.oracle.udt.LocationRefT.OFFICE_ID, value);
    }

    /**
     * The UDT column <code>CWMS_20.LOCATION_REF_T.OFFICE_ID</code>
     */
    public java.lang.String getOfficeId() {
        return getValue(usace.cwms.db.oracle.udt.LocationRefT.OFFICE_ID);
    }

    /**
     * Call CWMS_20.LOCATION_REF_T.GET_OFFICE_ID
     *
     * @param self
     * @throws org.jooq.exception.DataAccessException if something went 
wrong executing the query
     */
    public java.lang.String getOfficeId() {
        usace.cwms.db.oracle.udt.location_ref_t.GetOfficeId f = new 
usace.cwms.db.oracle.udt.location_ref_t.GetOfficeId();
        f.setSelf(this);

        f.execute(getConfiguration());
        return f.getReturnValue();
    }

Reply via email to