Yes, It made no difference.
Remember that it DOES work for me on my development machine. Just not against my production table. I am using the same jar's and the same code just changing the DB url.
NOT WORKING
SQL> desc rv_report_hierarchy;
Name Null? Type
----------------------------------------- -------- ----------------------------
REPORT_ID NOT NULL NUMBER(12)
PARENT_ID NUMBER(12)
REPORT_NAME NOT NULL VARCHAR2(100)
FREQUENCY_ID NUMBER(1)
DESCRIPTION VARCHAR2(1000)
REPORT_TYPE NOT NULL NUMBER(2)
ARCHIVE_IND NOT NULL NUMBER(1)
BRIO_JOB_ID NUMBER(6)
POSTED_DATE DATE
HIERARCHY_CODE VARCHAR2(25)
REPORT BLOB
INFOPARTNER_IND NUMBER(1)
CATEGORY VARCHAR2(30)
LAST_UPDATE_DATE DATE
WORKING
SQL> desc rv_report_hierarchy;
Name Null? Type
----------------------------------------- -------- ----------------------------
REPORT_ID NOT NULL NUMBER(12)
PARENT_ID NUMBER(12)
REPORT_NAME NOT NULL VARCHAR2(100)
FREQUENCY_ID NUMBER(1)
DESCRIPTION VARCHAR2(1000)
REPORT_TYPE NOT NULL NUMBER(2)
ARCHIVE_IND NOT NULL NUMBER(1)
INFOPARTNER_IND NUMBER(1)
BRIO_JOB_ID NUMBER(12)
POSTED_DATE DATE
LAST_UPDATE_DATE DATE
HIERARCHY_CODE VARCHAR2(25)
REPORT BLOB
CATEGORY VARCHAR2(100)
On Jan 20, 2005, at 2:35 PM, Clinton Begin wrote:
Did you try putting the cth reference where I suggested?
Clinton
On Thu, 20 Jan 2005 14:33:44 -0700, Nathan Maves <[EMAIL PROTECTED]> wrote:here is my latest getter in the CTH
public Object getResult(ResultGetter getter) throws SQLException {
if (getter.wasNull())
return null;
int value = getter.getInt();
Frequency frequency = Frequency.get(value);
return frequency;
}
when I run the query from sqlplus I get a 1 for the frequency_id field.
but in the code above I get a value of 0 from the getter object.
Nathan
On Jan 20, 2005, at 2:16 PM, Nathan Maves wrote:
I tried that just now and not change.
On Jan 20, 2005, at 2:01 PM, Clinton Begin wrote:
<result column="frequency_id" property="frequency" typeHandler="reporting.viewer.dao.ibatis.FrequencyTypeHandler"/>
