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();
}