A LONG in Oracle is a string, not an Integer. It is for strings that are
too big for VARCHAR2.
Curt Springer <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
> I don't have any directly helpful answer.
>
> I just want to mention that I've been working with jdbc and oracle outside
> ND, and I suspect your problem might be around how ND maps values into the
> underlying SQL objects. I found that when the sql type was
> (java.sql.Types) was whatever mapped to 'long', the actual object was of
> type java.math.BigDecimal, and I had to convert my longs to and from that
> type manually.
>
> If somebody doesn't respond quickly with actual help, or if it doesn't
jump
> out at you, I'd suggest opening a call with ND tech support.
>
> -- Curt Springer, Team ND
>
> At 08:35 AM 12/22/99 -0600, Steven Ford wrote:
> >When I add a LONG field to a dataobject I get an SQLException when I
display
> >the page.
> >
> >general error:
> >HRMS_FSA.doClaimsDetail.32 (java.sql.SQLException caught)
> >
> >vendor error1:
> >HRMS_FSA.doClaimsDetail.0 (null Protocol violation)
> >
> >I got the SQL* and ran it in oracle and it worked fine.
> >
> >After I get this error I must restart the JDBC service or nothing will
work
> >even if I take out the field and recompile. This happens even if I do
not
> >bind the field to a displayfield.
> >
> >Has anyone run itno this? Is there some workaround or am I doing
something
> >wrong?
> >
> >* This is how I got the SQL
> >in the onBeforeExecuteEvent of the dataobject
> > CSpDBSQLRequest dbreq = (CSpDBSQLRequest) event.getDBRequest();
> > String sqltext = dbreq.getSQLProgram();
> > CSpLog.send(this, CSpLog.CRITICAL, sqltext);
> >
> >
> >
> >_________________________________________________________________________
> >
> >For help in using, subscribing, and unsubscribing to the discussion
> >forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
> >
> >For dire need help, email: [EMAIL PROTECTED]
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
