(again) Help for Cocoon 1.8 & MS. Access database!!!

[beichuang <be...@yahoo.com>]

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.

(Succeed!! Thank you all!!) Help for Cocoon 1.8 & MS. Access database!!!

[beichuang <be...@yahoo.com>]

Thank you, Thank you all so much, I have solved the problems.

it seems both of your suggestion are right:
either override a false infoxmix or some not used database adapter name, or
add a new but can only be DBOdbc, even case censitive.

Then I think maybe can even not use turbine, just combine the driver in a
xsp file, isn't it?

As to why I failed last time, just because I didn't change the xsp file, the
DBODBC should be changed to DBOdbc, so it is a shame, :-)

Thank you so much, I didn't expect I can finish it so soon with your help,
anyway, I want to get some detailed documents about esql, but the link on
website cocoon homepage is false. Any other available?

Best Regards


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: (again) Help for Cocoon 1.8 & MS. Access database!!!

[Brian P Millett <bp...@ec-group.com>]

beichuang wrote:

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

This is an error being generated from the servlet that is generated from cocoon.  Check the file at
_D_._Program._Apache._jakarta_tomcat._webapps._cocoon._sql._mytaglib to see what is the problem.
Looks like the SQL could be bad, or the database is generating an error.

What does the xml look like?

What version of Cocoon are you using?  The latest from CVS will give you the newer turbine-pool jar
file

--
Brian Millett
Enterprise Consulting Group   "Shifts in paradigms
(314) 205-9030               often cause nose bleeds."
bpm@ec-group.com                           Greg Glenn