SQL query cannot be read.

[Jin Wei Yong]

Hi, 
I am still exploring the use of SQLTranformer. I am
using a book, Cocoon:Building XML Application by
Matthew Langham and Carsten Ziegeler. If you have the
book, you can refer to Chapter 7. The this SQL-related
example does not use XSP at all. The query is written
in the xsl file.

In the example, I use subsitemap, which is the only
difference from Langham's example. 

I write the following in the xsl file:


 http://apache.org.cocoon/SQL/2.0";>
 personnel
 
INSERT INTO DEPARTMENT_TABLE VALUES(18,'jinwei2') 

 
 


however, the SQL statement cannot be executed.

When I check the Cocoon.log file, Langham's example is
as follows:

/JaxpParser: Looking up
org.apache.cocoon.components.resolver.Resolver
/JaxpParser: SAXParserFactory: null
/JaxpParser: DocumentBuilderFactory: null
/JaxpParser: SAXParser: null
/SQLTransformer: PUBLIC ID: null
/SQLTransformer: SYSTEM ID:
file:/C:/jakarta-tomcat-3.3a/webapps/cocoon/sqlexample.xml
/SQLTransformer: RECEIVED CHARACTERS: 
/SQLTransformer: RECEIVED START ELEMENT execute-query
/SQLTransformer: RECEIVED CHARACTERS:  
/SQLTransformer: RECEIVED START ELEMENT use-connection
/SQLTransformer: RECEIVED CHARACTERS: personnel
/SQLTransformer: RECEIVED END ELEMENT
use-connection(http://apache.org/cocoon/SQL/2.0)
/SQLTransformer: SETTING VALUE ELEMENT name
{use-connection} value {personnel}
/SQLTransformer: RECEIVED CHARACTERS: 
/SQLTransformer: RECEIVED START ELEMENT query
/SQLTransformer: RECEIVED CHARACTERS: 
  INSERT INTO DEPARTMENT_TABLE VALUES(19,'jinwei2')
/SQLTransformer: RECEIVED END ELEMENT
query(http://apache.org/cocoon/SQL/2.0)
/SQLTransformer: QUERY IS "
  INSERT INTO DEPARTMENT_TABLE VALUES(19,'jinwei2')
"
/SQLTransformer: RECEIVED CHARACTERS: 
/SQLTransformer: RECEIVED END ELEMENT
execute-query(http://apache.org/cocoon/SQL/2.0)
/SQLTransformer: SQLTransformer executing query nr 0
/SQLTransformer$Query: EXECUTING 
  INSERT INTO DEPARTMENT_TABLE VALUES(19,'jinwei2')
/DefaultPool: Retrieving a
org.apache.avalon.excalibur.datasource.JdbcConnection
from the pool

whereas my log is something like:

JaxpParser: Looking up
org.apache.cocoon.components.resolver.Resolver
/JaxpParser: SAXParserFactory: null
/JaxpParser: DocumentBuilderFactory: null
/JaxpParser: SAXParser: null
/SQLTransformer: RECEIVED CHARACTERS: personnel
/SQLTransformer: RECEIVED CHARACTERS: 
  INSERT INTO DEPARTMENT_TABLE VALUES(19,'jinwei2')
/URLFactoryImpl: Making URL from
file:/C:/jakarta-tomcat-3.3a/webapps/cocoon/boac/stylesheets/../documents/toc.xml
/URLFactoryImpl: Making URL from
file:/C:/jakarta-tomcat-3.3a/webapps/cocoon/boac/stylesheets/../documents/toc.xml
/DefaultComponentFactory: ComponentFactory
decommissioning instance of
org.apache.cocoon.components.parser.JaxpParser.
/DefaultPool: Returning a
org.apache.cocoon.components.sax.XMLByteStreamCompiler
to the pool
/CachingEventPipeline: Recycling of
CachingEventPipeline
/DefaultPool: Returning a
org.apache.cocoon.generation.FileGenerator to the pool

One thing to note is that the start/end elements are
not being read. Have I missed out anything in the
configuration?

Thanks very much.



__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

xmlForm on update

[Hill]

I am trying to use xmlForm on my DB actions (enter, update).
With "enter" I understood, but questions on update:
I have general actions some like DatabaseAddAction, DatabaseUpdateAction and
use these on my actions.
So after retrieve data from DB by ID (use DatabaseSelectAction), what the
next? How to set attributes of Bean?

Thanks a lot,
Hill
Cocoon 2.1 dev, Tomcat 4.0, Java 1.4


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

unable to connect to firebird/mysql using esql

[Nils Le?mann]

hi folks,

i'm totally stuck trying to connect cocoon (2.0.3) to firebird.

org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): 

java.lang.RuntimeException: Could not get the datasource 

org.apache.avalon.excalibur.datasource.NoValidConnectionException: 
No valid JdbcConnection class available

* i'm loading the driver in web.xml, works:

DEBUG   (2002-12-07) 19:43.13:516   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class:
org.firebirdsql.jdbc.FBDriver

* i set up the connection pool in cocoon.xconf:


  
 
jdbc:firebirdsql:localhost/3050:H:\\interbase\\firebird
  sysdba
  masterkey


using the very same settings in a small java programm works.

* i am using the following xsp:

  
mysql

  select * from test
  

  

  

  


after having no success for more than a week i tried mysql and get the
same results - jdbc driver works in "normal" java enviroment, but i get
this "no jdbcConnection" message.

can anyone help me?

thank you,
  nils


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: [ANN] - Tomcat/Cocoon Performance on Production Sites?

[Steven Noels]

Antonio Gallardo wrote:


http://ask.slashdot.org/article.pl?sid=02/12/03/1544224


Most useful snippet:

 Yes, for about a year now (Score:2, Informative)
by arthurs_sidekick (41708) on Tuesday December 03, @02:12PM (#4803696)
(http://www.theonion.com/)

 The site in question gets about 60-65K hits/day running in a 2x1.13GHz 
PIII/1GB RAM running Linux ( 2.4 series) with JDK 1.4 using an Apache 
front-end for SSL. We run Tomcat 4 and Cocoon 2, making judicious use of 
caching (we serve pre-transformed HTML pages generated from Docbook XML 
sources), but every page is dynamically generated. Haven't yet seen 
anything that makes me think we'll need anything beefier in the near future.

... wich average to 0,75 hits/seconds.


--
Steven Noelshttp://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
Read my weblog at  http://radio.weblogs.com/0103539/
stevenn at outerthought.orgstevenn at apache.org


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Portal: types

[Marcel Jurk]

Hi all,

in the documentation of the portal I can find the
following explanation:

---
The type profile describes the possible values the
user can change for his portal view. Using this
flexible approach the portal administrator can decide
which user can choose what. For example, a normal user
might change the layout and content of his portal
view, but a guest might not be allowed to change
anything, whereas the administrator can change
everything. 
---

Now my question. How can I map a type profil to a
special role or user? In the sample portal are only
two type profiles defined, the admintypes.xml and the
types.xml. In the sitemap of the portalconfiguration
these two files are included as parameters:

  
  


I use cocoon2.1 (CVS).

greetings, marcel


__

Gesendet von Yahoo! Mail - http://mail.yahoo.de
Weihnachts-Einkäufe ohne Stress! http://shopping.yahoo.de

-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>