Hi All, Here is my config: * Win 2000 Pro * Tomcat 4.0.3 * Jdk 1.3.1 * SQL Server 8.0 * MySql 3.23.44
I developed a simple form making a DB insertion in SQL Server or MySql. The insertion in the DB is performed but the browser keeps loading and never displays the confirmation page... This is not a JDBC configuration issue, as the entry is actually added into the DB. This is neither a problem with the JDBC driver as I am using 3 different drivers (Microsoft and ThinTDS for SQL Server and MM's for Mysql)... I do not get any specific error in the logs, but regarding XMLDBGenerator and XMLDBDatabaseImpl... Can this be related to my problem? Do you have any idea to help me solving my issue? (Below the code and the logs) Thanx for your help, Jonathan Crenner core.log: --------- DEBUG (2002-03-25) 09:38.40:312 [core] (/cocoon/vsc/) HttpProcessor[8080][4]/DefaultComponentFactory: ComponentFactory creating new instance of org.apache.cocoon.generation.XMLDBGenerator. DEBUG (2002-03-25) 09:38.40:312 [core] (/cocoon/vsc/) HttpProcessor[8080][4]/DefaultComponentFactory: logger attribute is sitemap.generator.xmldb DEBUG (2002-03-25) 09:38.40:328 [core] (/cocoon/vsc/) HttpProcessor[8080][4]/LogKitLogger: org.apache.cocoon.generation.XMLDBGenerator: could not be instantiated. org.apache.cocoon.ProcessingException: Problem setting up the connection: org.dbxml.client.xmldb.DatabaseImpl at org.apache.cocoon.generation.XMLDBGenerator.initialize(XMLDBGenerator.java:135) at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:183) at org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java:82) at org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool.java:126) at org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourceLimitingPool.java:91) at org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.initialize(SoftResourceLimitingPool.java:80) at org.apache.avalon.excalibur.component.PoolableComponentHandler.initialize(PoolableComponentHandler.java:88) at org.apache.avalon.excalibur.component.ExcaliburComponentSelector.addComponent(ExcaliburComponentSelector.java:467) at org.apache.cocoon.sitemap.AbstractSitemap.load_component(AbstractSitemap.java:227) at org.apache.cocoon.www.sitemap_xmap$Configurer.configGenerators(sitemap_xmap.java:595) at org.apache.cocoon.www.sitemap_xmap.configure(sitemap_xmap.java:390) at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:172) at org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:84) at org.apache.cocoon.components.language.generator.GeneratorSelector.addGenerator(GeneratorSelector.java:135) at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.addCompiledComponent(ProgramGeneratorImpl.java:356) at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:187) at org.apache.cocoon.sitemap.Handler.run(Handler.java:228) at java.lang.Thread.run(Thread.java:484) DEBUG (2002-03-25) 09:38.40:328 [core] (/cocoon/vsc/) HttpProcessor[8080][4]/DefaultComponentFactory: ComponentFactory creating new instance of org.apache.cocoon.generation.XMLDBGenerator. DEBUG (2002-03-25) 09:38.40:328 [core] (/cocoon/vsc/) HttpProcessor[8080][4]/DefaultComponentFactory: logger attribute is sitemap.generator.xmldb DEBUG (2002-03-25) 09:38.40:328 [core] (/cocoon/vsc/) HttpProcessor[8080][4]/LogKitLogger: org.apache.cocoon.generation.XMLDBGenerator: could not be instantiated. org.apache.cocoon.ProcessingException: Problem setting up the connection: org.dbxml.client.xmldb.DatabaseImpl at org.apache.cocoon.generation.XMLDBGenerator.initialize(XMLDBGenerator.java:135) at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:183) at org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java:82) at org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool.java:126) at org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourceLimitingPool.java:91) at org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.initialize(SoftResourceLimitingPool.java:80) at org.apache.avalon.excalibur.component.PoolableComponentHandler.initialize(PoolableComponentHandler.java:88) at org.apache.avalon.excalibur.component.ExcaliburComponentSelector.addComponent(ExcaliburComponentSelector.java:467) at org.apache.cocoon.sitemap.AbstractSitemap.load_component(AbstractSitemap.java:227) at org.apache.cocoon.www.sitemap_xmap$Configurer.configGenerators(sitemap_xmap.java:595) at org.apache.cocoon.www.sitemap_xmap.configure(sitemap_xmap.java:390) at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:172) at org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:84) at org.apache.cocoon.components.language.generator.GeneratorSelector.addGenerator(GeneratorSelector.java:135) at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.addCompiledComponent(ProgramGeneratorImpl.java:356) at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:187) at org.apache.cocoon.sitemap.Handler.run(Handler.java:228) at java.lang.Thread.run(Thread.java:484) cocoon.xconf: ------------- <!-- Datasources: --> <datasources> <jdbc name="vsc" logger="core.datasources.vsc"> <dburl>jdbc:mysql://localhost:3306/stat_proto</dburl> </jdbc> </datasources> sitemap.xmap: ------------- <map:actions> <map:action name="dbAdd" logger="sitemap.vsc.action.dbAdd" src="org.apache.cocoon.acting.DatabaseAddAction"/> <map:action name="dbDel" logger="sitemap.vsc.action.dbDel" src="org.apache.cocoon.acting.DatabaseDeleteAction"/> <map:action name="dbUpd" logger="sitemap.vsc.action.dbUpd" src="org.apache.cocoon.acting.DatabaseUpdateAction"/> <map:action name="form" logger="sitemap.vsc.action.form" src="org.apache.cocoon.acting.FormValidatorAction"/> </map:actions> </map:components> <!-- ========================== Action sets ================================ --> <map:action-sets> <map:action-set name="process"> <map:act type="form" action="Create Country"> <map:parameter name="validate-set" value="add"/> <map:act type="dbAdd"/> </map:act> </map:action-set> </map:action-sets> <map:match pattern="add_*.html"> <map:act set="process"> <map:parameter name="descriptor" value="context://vsc/docs/formvalidation/country.xml"/> <map:generate type="serverpages" src="docs/confirm.xsp"/> <map:transform src="stylesheets/vscadmin.xsl"/> <map:serialize/> </map:act> <map:generate src="docs/add_{1}.xsp"/> <map:transform src="stylesheets/vscadmin.xsl"/> <map:serialize/> </map:match> web.xml: -------- <init-param> <param-name>load-class</param-name> <param-value>com.thinweb.thintds.Driver</param-value> </init-param> <init-param> <param-name>load-class</param-name> <param-value>org.gjt.mm.mysql.Driver</param-value> </init-param> add-country.xsp: ---------------- <?xml version="1.0"?> <xsp:page xmlns:xsp="http://apache.org/xsp" xmlns:xsp-formval="http://apache.org/xsp/form-validator/2.0"> <document> <body> <s1 title="Add a country"> <form handler="add_country.html"> <p> Country Code: <text name="COUNTRY_CODE" size="5" required="true"/><br /> <xsp-formval:on-toolarge name="COUNTRY_CODE"> The country code must be less than 5 characters. </xsp-formval:on-toolarge> </p> <p> Country Name: <text name="COUNTRY_NAME" size="50" required="true"/><br /> <xsp-formval:on-toolarge name="COUNTRY_NAME"> The country code must be less than 50 characters. </xsp-formval:on-toolarge> </p> <submit name="Create Country"/> <note> * These fields are required. </note> </form> </s1> </body> </document> </xsp:page> confirm.xsp: ------------ <document> <body> <s1 title="Success..."> The operation you performed on the database succeeded! </s1> </body> </document> country.xml: ------------ <root> <parameter name="COUNTRY_CODE" type="string" min-len="0" max-len="5"/> <parameter name="COUNTRY_NAME" type="string" min-len="0" max-len="50"/> <constraint-set name="update"> <validate name="COUNTRY_NAME"/> <validate name="COUNTRY_CODE"/> </constraint-set> <constraint-set name="add"> <validate name="COUNTRY_NAME"/> </constraint-set> <connection>vsc</connection> <table name="T_COUNTRY"> <keys> <key param="COUNTRY_CODE" dbcol="COUNTRY_CODE" type="string" mode="form"/> </keys> <values> <value param="COUNTRY_NAME" dbcol="COUNTRY_NAME" type="string"/> </values> </table> </root> _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>