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]
