Return-Path: <esalon@canuck.com>
Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-dev@xml.apache.org
Received: (qmail 68668 invoked from network); 27 Jun 2000 18:02:03 -0000
Received: from the-gimp.canuck.com (HELO canuck.com) (204.50.15.12)
  by locus.apache.org with SMTP; 27 Jun 2000 18:02:03 -0000
Received: from [195.252.151.40] (a1as05-p40.bln.tli.de [195.252.151.40])
	by canuck.com (8.9.3/8.9.1) with ESMTP id MAA2719576
	for <cocoon-dev@xml.apache.org>; Tue, 27 Jun 2000 12:01:38 -0600 (MDT)
User-Agent: Microsoft Outlook Express Macintosh Edition - 5.01 (1630)
Date: Tue, 27 Jun 2000 20:01:58 +0200
Subject: Re: SQLProcessor and use
From: Mark Washeim <esalon@canuck.com>
To: <cocoon-dev@xml.apache.org>
Message-ID: <B57EB8B6.1A70%esalon@canuck.com>
In-Reply-To: <3958D685.772EA9C3@knosys.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

on 27/6/00 6:29 pm, Jon Lancelle at jkl@knosys.com wrote:

> I get an error code like this. Think it could be my jdbc driver? I don't see
> an
> instance of it in the list.
> 

Looks like an update problem. Make sure  to add:
<sql:update-rows-attribute>result</sql:update-rows-attribute>

to your execute query block. Donald fixed this in CVS . . .


> Error found handling the
> request.
> 
> java.lang.ArrayIndexOutOfBoundsException
> at
> org.apache.xerces.dom.DocumentImpl.isXMLName(DocumentImpl.java:1245)
> at
> org.apache.xerces.dom.DocumentImpl.createAttribute(DocumentImpl.java:322)
> at
> org.apache.xerces.dom.ElementImpl.setAttribute(ElementImpl.java:414)
> at
> org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.processQuery(XSPSQLL
> ibrary.java:147)
> 
> at
> _opt._jakarta_tomcat._webapps._monarch._samples._ovrimossql._taglib.populateDo
> cument(_taglib.java:80)
> 
> at
> org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
> at
> org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:456)
> at org.apache.cocoon.Engine.handle(Engine.java:305)
> at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
> at
> org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpCon
> nectionHandler.java:160)
> 
> at
> org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
> at java.lang.Thread.run(Thread.java:484)
> 
> Giacomo Pati wrote:
> 
>> --- Jon Lancelle <jkl@knosys.com> wrote:
>>> Has anyone been fairly successful using the SQL processor?
>> 
>> Of course, with MySQL and PostgreSQL.
>> 
>>> 
>>> I am trying to use a driver from a company called Ovrimos, but getting
>>> nowhere fast.
>>> 
>>> Do I need to create my own producer? Would it be easier?
>> 
>> If you have a JDBC driver available there is no need to write your own
>> producer.
>> 
>> Giacomo
>> 
>> =====
>> --
>> PWR GmbH, Organisation & Entwicklung      Tel:   +41 (0)1 856 2202
>> Giacomo Pati, CTO/CEO                     Fax:   +41 (0)1 856 2201
>> Hintereichenstrasse 7                     Mailto:Giacomo.Pati@pwr.ch
>> CH-8166 Niederweningen                    Web:   http://www.pwr.ch
>> 
>> __________________________________________________
>> Do You Yahoo!?
>> Get Yahoo! Mail - Free email you can access from anywhere!
>> http://mail.yahoo.com/
> 

-- 
Mark (Poetaster) Washeim

'On the linen wrappings of certain mummified remains
found near the Etrurian coast are invaluable writings
that await translation.

Quem colorem habet sapientia?'

Evan S. Connell