Hi Nathan,
If it is working on development and not working on Prod, then it must be a
deployment issue.
It is possible that you have not deployed all the files. You may be looking at
the wrong thing or
the wrong version of your code.
Usually in an enterprise the developers have full access to the development and
we make the
usually ftp some files instead of a full deployment and when it is deployed in
prod we always
follow the correct practices.
Do look if you are missing something. Try doing a full install. May be it
will fix the issue.
If you have already done this, then :-(.
Thanks
Prashanth.
--- Nathan Maves <[EMAIL PROTECTED]> wrote:
> 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"/>
> >>>
> >>
> >>
>
>
__________________________________
Do you Yahoo!?
All your favorites on one personal page � Try My Yahoo!
http://my.yahoo.com
