Re: Dynamic query woes.

Here are some juicy details on the remapResults attribute: http://opensource2.atlassian.com/confluence/oss/pages/viewpage.action?pageId=3057 Ted

'total' property on ViewOrder.jsp not displaying

Hello,   I have this code toward the bottom of the ViewOrder.jsp(newOrder.shtml): td> td> td>   The quantit

Insert/update issues

I'm working with Sybase ASE 12 using JConnect 6.0 JDBC driver. The problem that I am having is when I perform an insert or an update into a table that has a trigger, and the trigger calls RaiseError, the error does not get converted into an SQLException.  It appears that this information will be s

Re: 'total' property on ViewOrder.jsp not displaying

Is there a getTotal() method in LineItem.java?  Setting property to "total" implies there should be (JavaBeans 101 - this bean:write tag would never call the calculateTotal method).   Jeff Butler   On 3/24/06, Mike Wilson <[EMAIL PROTECTED]> wrote: Hello,   I have this code toward the bottom of t

Re: Insert/update issues

iBATIS does not support multiple result sets.  There are several open JIRA issues related to stored procedures, and some talk about changing this.  But it's a big job.   If you can't change the way Sybase works in this cse (i.e. raising an actual error rather than sending another result set), then

Re: Insert/update issues

Sybase has an option: You can tell jConnect to ignore the doneinprocs via a connection property "IGNORE_DONE_IN_PROC" = 'true'. This allowed the exception to be raised as listed below. The only issue I have with this is at first glance the exception appears to be related to the SQLMap rather tha

Re: 'total' property on ViewOrder.jsp not displaying

Yes, there is a getTotal() method in LineItem.java. The calculateTotal() method sets its value:   private void calculateTotal() {    if (item != null && item.getListPrice() != null) {  total = item.getListPrice().multiply(new BigDecimal(quantity));    } else {  total = null;    }Jeff Butle

Re: Insert/update issues

Sounds like a "good" solution given the current state of iBATIS.   Jeff Butler  On 3/24/06, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote: Sybase has an option: You can tell jConnect to ignore the doneinprocs via a connectionproperty "IGNORE_DONE_IN_PROC" = 'true'. This allowed the exception to

Re: Sybase JConnect 5.5 & CLOB

  I looked at an Oracle example http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+BLOB+or+CLOB   Looks like it is not supported and does not work if using Jconnect/Sybase   Does anyone have a working example(s) for sybase&Jconnect reading/writing Text datatype field

Re: Sybase JConnect 5.5 & CLOB

I know for a fact that when working with Oracle 9i I ran into problems when trying to use CLOB for storing my XML documents. Because of that I decided to use LONG RAW as the datatype on the table. I would stream the results out of the table into a byte[].  This also allowed me to specify the encod

Re: Sybase JConnect 5.5 & CLOB

Chris,   Based on the Info on jconnect at this link http://www.sybase.com/detail?id=1009774   under  JDBC 2.0 Standard Methods Implementation topic getClob, getBlob etc have not been implemented.   What is the alternate datatype in Sybase 12.0, other than Text datatype that could used to hol

Re: Sybase JConnect 5.5 & CLOB

Looking at the JConnect does: Warning! The TextPointer class has been deprecated; that is, it is no longer recommended and may cease to exist in a future version of jConnect. If your data server is Adaptive Server version 12.5 or later or Adaptive Server Anywhere version 6.0 or later, use the stan

JPetStore - Using billState property in Cart.java

Hello,   Basically, what I need to do is in the Cart.java grab the users' billState value (in Order.java) so I can use it as a qualifier for which tax rate is applied.   I am trying to set the account.billState value in Order.java that I can use in the Cart.java. This is so I can calc differen