You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Jan Willem Penterman <jw...@shapers.nl> on 2002/08/18 21:14:23 UTC

RE: SQLTransformer good, ESQL good!

> This is _really_ strange. 

Erm, _I_ am really strange...
I had my esql:pool tag within the esql:query...
Aargh!

JW
  



---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>


Re: ESQL DTD? (Was: SQLTransformer good, ESQL good!)

Posted by Alan Hodgkinson <al...@softxs.ch>.
Dear Christian,

Thanks for the quick reply :)

> > And worse.. the Dodds IBM Tutorial, 'Cocoon 2: Build database
> > driven sites', presents an example that contains the following:
> >
> >   <esql:connection>
> >     <esql:execute-query>
> >       <esql:pool>...</esql:pool>
> >       <esql:query>...
> >         ...
> >
> 
> *WRONG*
> 
> > In the Cocoon documentation 'How to develop Web Applications', their
> > example contains:
> >
> >   <esql:connection>
> >     <esql:pool>...</esql:pool>
> >     <esql:execute-query>
> >       <esql:query>...
> >         ...
> 
> *CORRECT*
 
> The pool is a property of a connection and stays the same for all
> queries using that connection.
> 
> Could you please point the error out to Dodd?

Done.

> > I'm new to Cocoon and it's frustrating to have to trace down these sorts
> > of errors. RTFM helps, but isn't the complete colution.
> 
> Agreed. We should try to have up to date xsds for the logicsheets.
> I'm guilty myself of not updating the xsd :-( I'll try to get better :-)

By this is assume you mean the file:

  ./build/cocoon/webapp/samples/docs/samples/xsp/esql.xsd

A quick search through the CVS head only turns up a few xsd's, mostly
concered with esql and the sitemap. Does this mean that there aren't any 
xsd's for the other logicsheets? Even out of date ones would be better 
than nothing (hint, hint! :).

Best wishes,

Alan.

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>


Re: ESQL DTD? (Was: SQLTransformer good, ESQL good!)

Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 19.Aug.2002 -- 09:24 AM, Alan Hodgkinson wrote:
> 
> 
> Dear All,
> 
> Christian Haul wrote:
> > 
> > On 18.Aug.2002 -- 09:14 PM, Jan Willem Penterman wrote:
> > > > This is _really_ strange.
> > >
> > > Erm, _I_ am really strange...
> > > I had my esql:pool tag within the esql:query...
> > > Aargh!
> 
> Do you mean the pool was within the 'query' or within the
> 'execute-query'?
> 
> > ..[snip].. Mind you, no-one else spotted it either.
> 
> And worse.. the Dodds IBM Tutorial, 'Cocoon 2: Build database
> driven sites', presents an example that contains the following:
> 
>   <esql:connection>
>     <esql:execute-query>
>       <esql:pool>...</esql:pool>
>       <esql:query>...
>         ...
> 

*WRONG*

> In the Cocoon documentation 'How to develop Web Applications', their
> example contains:
> 
>   <esql:connection>
>     <esql:pool>...</esql:pool>
>     <esql:execute-query>
>       <esql:query>...
>         ...

*CORRECT*

The pool is a property of a connection and stays the same for all
queries using that connection.

Could you please point the error out to Dodd?

> Who's right? Or are they both right? I assume we trust the source.. e.g. 
> the Cocoon doc. But it raises a larger question. Are there DTD's or 
> other 'reference documentation' that we can go to definitively resolve 
> such issues? Is there someplace in the source code that we look (without
> having to reverse engineer half of the Jakarta projects :)?

Yes, there is a .XSD around for esql which is unfortunately out of
sync i.e. does not capture a number of extention to esql. You can find
it next to the esql.xsp sample.

> I'm new to Cocoon and it's frustrating to have to trace down these sorts
> of errors. RTFM helps, but isn't the complete colution. 

Agreed. We should try to have up to date xsds for the logicsheets.
I'm guilty myself of not updating the xsd :-( I'll try to get better :-)

	Chris.
-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>


ESQL DTD? (Was: SQLTransformer good, ESQL good!)

Posted by Alan Hodgkinson <al...@softxs.ch>.

Dear All,

Christian Haul wrote:
> 
> On 18.Aug.2002 -- 09:14 PM, Jan Willem Penterman wrote:
> > > This is _really_ strange.
> >
> > Erm, _I_ am really strange...
> > I had my esql:pool tag within the esql:query...
> > Aargh!

Do you mean the pool was within the 'query' or within the
'execute-query'?

> ..[snip].. Mind you, no-one else spotted it either.

And worse.. the Dodds IBM Tutorial, 'Cocoon 2: Build database
driven sites', presents an example that contains the following:

  <esql:connection>
    <esql:execute-query>
      <esql:pool>...</esql:pool>
      <esql:query>...
        ...

In the Cocoon documentation 'How to develop Web Applications', their
example contains:

  <esql:connection>
    <esql:pool>...</esql:pool>
    <esql:execute-query>
      <esql:query>...
        ...

Who's right? Or are they both right? I assume we trust the source.. e.g. 
the Cocoon doc. But it raises a larger question. Are there DTD's or 
other 'reference documentation' that we can go to definitively resolve 
such issues? Is there someplace in the source code that we look (without
having to reverse engineer half of the Jakarta projects :)?

I'm new to Cocoon and it's frustrating to have to trace down these sorts
of errors. RTFM helps, but isn't the complete colution. 

I suffered from the exact same 'No suitable driver' error when trying 
to access mysql using esql. By making the change described above to the 
esql, I've now been able to advance to the 'next error'. There must be
a more efficient way.

Comments, pointers to documentation, DTD files for esql (or other
namespaced cocoon features) would be appreciated.

Many thanks in advance,

Alan Hodgkinson

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>


Re: SQLTransformer good, ESQL good!

Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 18.Aug.2002 -- 09:14 PM, Jan Willem Penterman wrote:
> > This is _really_ strange. 
> 
> Erm, _I_ am really strange...
> I had my esql:pool tag within the esql:query...
> Aargh!

Glad to hear this is not esql related :-)

Mind you, no-one else spotted it either.

	Chris.
-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>