sql.processor problem

[Andreas Popper <An...@gmx.de>]

Hi all,

I failed to get the sql processor at work.

---------------xml01.sql--------------

<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet href="sql01.xsl" type="text/xsl"?>

<?cocoon-process type="sql"?>
<?cocoon-process type="xslt"?>

<page>
  <connection-defs>
    <connection name="foo">
	<driver>postgresql.Driver</driver>

<dburl>jdbc:postgresql:/linuxtest.ki.ision.net/pgtest</dburl>
	<username>foo_username</username>
	<password>foo_password</password>
    </connection>
  </connection-defs>

  <query connection="foo">
  select * from persdata
  </query>
  
  <sqlerror message="The database server is on fire"/>
</page>

--------------------------------------------------------

I get this file back nearly unchanged an in the apache error
log several
NullPointerExceptions:

at
org.apache.cocoon.processor.sql.ConnectionDefs.GetConnection(ConnectionDefs.java:179)

at
org.apache.cocoon.processor.sql.SqlProcessor.process(SqlProcessor.java:139)

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:588)

at
org.apache.jserv.JservConnection.processRequest(JservConnection.java:317)

at
org.apache.jserv.JservConnection.run(jservConnection.Java:188)

at
java.lang.Thread.run(Thread.java)



In my jserv.properties I added:

wrapper.classpath=/usr/lib/pgsql/jdbc6.5-1.2.jar,

In my cocoon.properties I commented in the
sql.processor-line,


and a servlet ist getting connection to my PostgreSQL. 


I would be thankfull for any hint.

andreas