xsp sql java.sql.SQLException: General error

[Frederic Alluin <fr...@webmedia.es>]

I just reboot my apache server and now i've another error message!!! :
an idea ???
Thanks
Fred
            java.sql.SQLException: General error
                     at
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6060)
                     at
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
                     at
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2458)
                     at
sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:320)
                     at
sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:163)
                     at
java.sql.DriverManager.getConnection(DriverManager.java:517)
                     at
java.sql.DriverManager.getConnection(DriverManager.java:177)
                     at
org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.processQuery(XSPSQLLibrary.java:98)

                     at
_D_._WebApps._columbia._htdocs._sql_xsp_essai.populateDocument(_sql_xsp_essai.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: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:484)

Frederic Alluin wrote:

> Hi,
> I try to use recently (yesterday) the xsp-sql solution, i read the sql
> taglib, the archives, etc..
> And I made a very simple xsp such like that :
>
> <?xml version="1.0"?>
> <?cocoon-process type="xsp"?>
> <xsp:page language="java" xmlns:sql="http://www.apache.org/1999/SQL"
> xmlns:xsp="http://www.apache.org/1999/XSP/Core">
>  <page title="SQL Search Results">
>   <sql:execute-query>
>    <sql:driver>sun.jdbc.odbc.JdbcOdbcDriver</sql:driver>
>    <sql:dburl>jdbc:odbc:columbia</sql:dburl>
>    <sql:username></sql:username>
>    <sql:password></sql:password>
>    <sql:doc-element>DOC</sql:doc-element>
>    <sql:row-element>ROW</sql:row-element>
>    <sql:tag-case>lower</sql:tag-case>
>    <sql:null-indicator>yes</sql:null-indicator>
>    <sql:id-attribute>id</sql:id-attribute>
>    <sql:id-attribute-column>Id</sql:id-attribute-column>
>    <sql:count-attribute>count</sql:count-attribute>
>    <sql:query>select * from Auxiliar</sql:query>
>   </sql:execute-query>
>  </page>
> </xsp:page>
>
> I think the result could be something like :
> <page title="SQL Search Results">
> <DOC count="16"><ROW id="0"><xxxxxx null="yes">
> ....
> </page>
>
> But i can modify what i want i've always the same message:
> Error found handling the request.
>
>                    java.lang.NullPointerException
>                            at
> org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:373)
>
>                            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:484)
>
> I tested directly my db connexion and it runs ... so it's a cocoon
> misconfiguration pb ??? Or anything else ??
>
> If anybody can help me pleazzzzzz ;-)
>
> Fred
> A frenchy in Spain
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org