I solved my second problem. My beanshell shim was creating an ArrayList, but it should have been a regular Array. The insert worked nicely once I changed to an Array.
That doesn't address problem 1, but does make fixing it less pressing. > Anyway, once I found this problem, I rewrote my workflow, adding a bean shell > to create an ArrayList of the various values to pass to the params port of > the SQLUpdate. Actually, it gets a list of lists, as the whole thing is > iterated, but the status suggests that the SQLUpdate will also be iterated, > so I think it's okay. But this also doesn't work, throwing a > java.lang.ArrayStoreException on the first pass for some reason that I can't > figure out. Again, there's no error visible in Taverna, but there is a > backtrace in the system log--see attachment 2. Kevin Crowston Syracuse University Phone: +1 (315) 464-0272 School of Information Studies Fax: +1 (866) 265-7407 348 Hinds Hall Web: http://crowston.syr.edu/ Syracuse, NY 13244-4100 USA ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ taverna-users mailing list [email protected] [email protected] Web site: http://www.taverna.org.uk Mailing lists: http://www.taverna.org.uk/taverna-mailing-lists/
