Return-Path: Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-dev@xml.apache.org Received: (qmail 50217 invoked from network); 17 Oct 2000 16:00:44 -0000 Received: from smtp3.mail.yahoo.com (HELO smtp1b.mail.yahoo.com) (128.11.68.135) by locus.apache.org with SMTP; 17 Oct 2000 16:00:44 -0000 Received: from miwis.sisu.se (HELO miwis) (192.71.57.141) by smtp.mail.vip.suc.yahoo.com with SMTP; 17 Oct 2000 16:00:40 -0000 X-Apparently-From: Message-ID: <00b501c03853$825b5ac0$8d0aa8c0@framkom.se> From: "beichuang" To: , Cc: References: <003e01c0384b$6f607930$8d0aa8c0@framkom.se> <39EC70A7.D8494CAE@ec-group.com> Subject: (again) Help for Cocoon 1.8 & MS. Access database!!! Date: Tue, 17 Oct 2000 18:01:26 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00B2_01C03864.44A34650" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------=_NextPart_000_00B2_01C03864.44A34650 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=3DDBWeblogic,DBOracle,DBInstantDB,DB= Postgres,DBSybase,DBInformix,DBOdbc processor.xsp.pool.database.adaptor=3DDBOdbc processor.xsp.pool.database.adaptor.DBOdbc=3Dsun.jdbc.odbc.JdbcOdbcDriver= processor.xsp.pool.database.adaptor.DBWeblogic=3Dweblogic.jdbc.pool.Drive= r processor.xsp.pool.database.adaptor.DBOracle=3Doracle.jdbc.driver.OracleD= river processor.xsp.pool.database.adaptor.DBInstantDB=3Dorg.enhydra.instantdb.j= dbc.idbDriver processor.xsp.pool.database.adaptor.DBPostgres=3Dpostgresql.Driver processor.xsp.pool.database.adaptor.DBInformix=3Dcom.informix.jdbc.IfxDri= ver processor.xsp.pool.database.adaptor.DBSybase=3Dcom.sybase.jdbc.SybDriver # ODBC driver added processor.xsp.pool.database.DBOdbc.url=3Djdbc:odbc:MyDBTest processor.xsp.pool.database.DBOdbc.username=3DdbUser processor.xsp.pool.database.DBOdbc.password=3DdbPass processor.xsp.pool.database.DBOdbc.maxConnections=3D3 processor.xsp.pool.database.DBOdbc.expiryTime=3D3600000 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(XS= PSQLLibrary.java, Compiled Code) at = org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery(XS= PSQLLibrary.java:101) at = _D_._Program._Apache._jakarta_tomcat._webapps._cocoon._sql._mytaglib.popu= lateDocument(_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(Ht= tpConnectionHandler.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. ------=_NextPart_000_00B2_01C03864.44A34650 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
ok, now it is here:
 
# These are the supported jdbc-drivers = and their=20 adaptors.
# These properties are used by the=20 DBFactory.
#processor.xsp.pool.database.adaptor=3DDBWeblogic,DBOracle,= DBInstantDB,DBPostgres,DBSybase,DBInformix,DBOdbc
 
processor.xsp.pool.database.adaptor=3DDBOdbc
processor.xsp.po= ol.database.adaptor.DBOdbc=3Dsun.jdbc.odbc.JdbcOdbcDriver
 

processor.xsp.pool.database.adaptor.DBWeblogic=3Dweblogic.jdbc.p= ool.Driver
processor.xsp.pool.database.adaptor.DBOracle=3Doracle.jdbc.= driver.OracleDriver
processor.xsp.pool.database.adaptor.DBInstantDB=3D= org.enhydra.instantdb.jdbc.idbDriver
processor.xsp.pool.database.adapt= or.DBPostgres=3Dpostgresql.Driver
processor.xsp.pool.database.adaptor.= DBInformix=3Dcom.informix.jdbc.IfxDriver
processor.xsp.pool.database.a= daptor.DBSybase=3Dcom.sybase.jdbc.SybDriver
 
# ODBC driver=20 added
processor.xsp.pool.database.DBOdbc.url=3Djdbc:odbc:MyDBTest
p= rocessor.xsp.pool.database.DBOdbc.username=3DdbUser
processor.xsp.pool= .database.DBOdbc.password=3DdbPass
processor.xsp.pool.database.DBOdbc.= maxConnections=3D3
processor.xsp.pool.database.DBOdbc.expiryTime=3D360= 0000
 
But the error message is still the=20 same:

 

Error found handling the = request.

java.lang.NullPointerException
	at =
org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.processQuery(XS=
PSQLLibrary.java, Compiled Code)
	at =
org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery(XS=
PSQLLibrary.java:101)
	at =
_D_._Program._Apache._jakarta_tomcat._webapps._cocoon._sql._mytaglib.popu=
lateDocument(_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(Ht=
tpConnectionHandler.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.
------=_NextPart_000_00B2_01C03864.44A34650-- _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com