ok, now it is here:
# These are the supported jdbc-drivers and their adaptors.
# These properties are used by the DBFactory.
#processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantDB,DBPostgres,DBSybase,DBInformix,DBOdbc
processor.xsp.pool.database.adaptor=DBOdbc
processor.xsp.pool.database.adaptor.DBOdbc=sun.jdbc.odbc.JdbcOdbcDriver
processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver
processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.instantdb.jdbc.idbDriver
processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
processor.xsp.pool.database.adaptor.DBInformix=com.informix.jdbc.IfxDriver
processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver
# ODBC driver added
processor.xsp.pool.database.DBOdbc.url=jdbc:odbc:MyDBTest
processor.xsp.pool.database.DBOdbc.username=dbUser
processor.xsp.pool.database.DBOdbc.password=dbPass
processor.xsp.pool.database.DBOdbc.maxConnections=3
processor.xsp.pool.database.DBOdbc.expiryTime=3600000
But the error message is still the same:
Error found handling the request.
java.lang.NullPointerException
at org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.processQuery(XSPSQLLibrary.java,
Compiled Code)
at org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery(XSPSQLLibrary.java:101)
at _D_._Program._Apache._jakarta_tomcat._webapps._cocoon._sql._mytaglib.populateDocument(_mytaglib.java,
Compiled Code)
at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java, Compiled Code)
at org.apache.cocoon.Engine.handle(Engine.java, Compiled Code)
at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java, Compiled Code)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java, Compiled Code)
at java.lang.Thread.run(Unknown Source)
BTW, any documents about ESQL(the link is false on cocoon website)? and have you anyone run
the jdbc2odbc with Microsoft Access successfully?
Thanks a lot, and thank you for ur last response.
|