FYI, I worked with another app server called Silverstream and encountered the same problem with oracle's long. They also mapped the long type into java.math.BigDecimal. My guess is that is the only way to be generic. Suyoto. Curt Springer <[EMAIL PROTECTED]> wrote: >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]
