Re: tutorial - MySQL - NoValidConnectionException: No valid JdbcConnection class available

2003-09-14 Thread John Williams
Flavio wrote:
 dburljdbc:mysql://localhost/cocoon/dburl

This looks wrong. Surely the url for the jdbc db must be
protocol://host:port, eg
dburljdbc:mysql://localhost:3306/dburl

I think 3306 is the port for MySQL. MS SQLServer uses 1433.

John


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Jakarta Tomcat

2003-09-12 Thread John Williams
 from the production server of the same application.  I believe this
will
 require a second instance of Tomcat so I can set different ports for
the
 Test and Prod to talk to Tomcat.  I will also set different listening
ports
 for each instance of Tomcat to listen  (8080,7080).

Would it not be easier to have a single instance of tomcat but with two
context settings in tomcat-path/conf/server.xml, ie one for each .war,
eg

Context path=/test docBase=C:\path-to-test-war
debug=0 privileged=true/

Context path=/actual-production-path-for-url
docBase=C:\path-to-production-war debug=0 privileged=true/


They could then both be accessed using the same port but with a
different url eg

http://some.server.com:8080/test/foo/bar.html - for test
http://some.server.com:8080/actual-production-path-for-url/foo/bar.htm
l - for production

actual-production-path-for-url could be just /

John


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: web.xml listing=false does not work

2003-09-12 Thread John Williams
 But despite this we are still getting directory listing in case the
user
 enters URL with slash at the end.

Are you sure that your sitemap for application does not include
something like:
map:match pattern=
[some instruction to give a directory listing]
/map:match
You can prevent the listing problem by redirecting the request by addng
the follwing to your sitemap for application

map:match pattern=
map:redirect-to
uri=the-page-that-should-be-displayed-when-url-ends-with-slash/
/map:match

If you only have a cocoon level sitemap then include this:
map:match pattern=application
map:redirect-to
uri=application/the-page-that-should-be-displayed-when-url-ends-with-s
lash/
/map:match






-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: tutorial

2003-09-12 Thread John Williams
 i try to run the tutorial and every time i get an exception :

 Original exception :
 org.apache.avalon.excalibur.datasource.NoValidConnectionException:
 No valid JdbcConnection class available at

org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance
 (JdbcConnectionFactory.java:164) at
 org.apache.avalon.excalibur.pool.ResourceLimitingPool..

Have you got the jars containing the jdbc drivers for MySql in the
cocoon-dir/WEB-INF/libs directory?

 to work around the problem i have modified the .xsp file putting
 there inside the jdbc tags (driver, url ...) just before the
 connection in the esql tags ; in this it runs ... so i think

The url, password etc go in cocoon-dir/WEB-INF/cocoon.xconf, eg for
sqlserver:
datasources
!-- other jdbc datasources  --
jdbc logger=core.datasources.personnel name=personnel
pool-controller min=5 max=10 oradb=true/
pool-controller max=10 min=5/
auto-commitfalse/auto-commit
dburljdbc:microsoft:sqlserver://server-name:1433/dburl
usersacopy/user
passwordpassword/password
/jdbc
/datasources




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Form validation multiple rows

2003-09-11 Thread John Williams
Is it possible to validate a number of input fields having the same name and
get back the error linked to the field causing the problem?

I am using 2.0.4 and find that FormValidatorAction will act on a multivalued
field but it only returns a single value for the field.

For example I have a form used to submit a cyclist together with dates and
times of previous races. Say a cyclist has entered in three races previously
and I want to test the date and time values. The following is in the request
as submitted if  he has left the first date and second time out:
cyclist - joe bloggs
date - ,22/03/03,22/06/03 (note value starts with comma)
time - 1h15,,1h25 (note pair of commas)

I want to be able to indicate that the first date and second time have not
been entered - instead of a just showing a problem with date and time as a
whole.

Is there existing functionality to deal with this?

John Williams



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Update a pair of tables having a one-to-many cardinality in a transaction - modular database actions

2003-09-11 Thread John Williams



Say I have a pair of tables - ORDER_HEADER (who 
placed it, delivery date, etc)and ORDER_LINE per item (quantity, price, 
etc) - and I want to update the both based on changes submitted by a user. These 
changes could include:

update to ORDER_HEADER, eg new date
deletion of some ORDER_LINE rows - items not 
available
addition of some ORDER_LINE rows - items newly 
required
update to some existing ORDER_LINE rows 
- new prices

Looking at the functionality available in Modular 
Database Actions I notice that the add, update and delete must becalled 
separately and thus cannot be done as a single transaction (the commit is 
embedded within each action type).

Has anyone got around this?

John Williams


Re: please help me - output format must have a '{http://xml.apache.org/xalan}content-handler' property

2003-09-09 Thread John Williams
 I'm getting the same error all the time. (Error
 compiling sitemap) I've really no idea how to solve the
 problem so that's why I ask for your help.

 My configuration is  Gentoo 1.4, cocoon 2.0.2, apache
 1.3.28, tomcat 4.1.24, jdk 1.4.2, xalan 2.5.1.

 Here are my logs files.

snip from log files
javax.xml.transform.TransformerException:
org.apache.xml.utils.WrappedRuntimeException: The output format must have a
'{http://xml.apache.org/xalan}content-handler' property!
/snip from log files

Its to do with Xalan version and JDK 1.4. Look at
http://wiki.cocoondev.org/Wiki.jsp?page=EndorsedLibsProblem

John


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Simple form handling

2003-08-22 Thread John Williams
   Does exist some simple way of handling forms in Cocoon? I just want to
   generate form, get input from user, validate and if it's incorrect send
back
   the information why is incorrect.

If all you need is tests on range, not null, matches-regex(pretty useful, eg
test if email address), min length, max length for posted fields with
messages where data fails then try the forms logicsheet at:
http://cocoon.apache.org/2.0/userdocs/xsp/logicsheet-forms.html

Their use is well illustrated in a tutorial which generates forms (also uses
a database)at:
http://cocoon.apache.org/2.0/tutorial/tutorial-develop-webapp.html



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Running the latest CVS snapshot - should it be this hard?

2003-08-16 Thread John Williams
In order to test a recent fix I downloaded a CVS snapshot .
My expectation was that once I had done a build all and copied all the
necessary jars into WEB-INF I could use the configuration in
cocoon-2.0/src/webapp in the snapshot's tar.gz file and be on my way.

Not so! I had to make the modifications detailed below to the cocoon.xconf
and sitemap simply in order to use the snapshot. The sitemap cannot work as
is as it uses components which are not declared. None of this is mentioned
in what looks like the obvious place
(http://cocoon.apache.org/2.0/installing/updating.html). Do I have the wrong
expectation, ie that any CVS snapshot will be internally consistant and will
thus run? or is it more a case of everyone beavering away separately with
their own configurations (sitemap and xconf) which work for their corner of
the functionality and only putting together something which runs as is at
release time?

John Williams


(I have included enough detail to help others use and find)
Changes to cocoon.xconf
=

Input and Output modules where not included resulting in an error such as
the follwing for an absent request input-module:
  Invalid pattern '{request:servletPath}' at file:/  and
  org.apache.avalon.framework.component.ComponentException:
  input-modules: ComponentSelector could not find the component for
hint [request]

I added the following from an older xconf - some may not be used:
input-modules
component-instance
class=org.apache.cocoon.components.modules.input.RequestModule
logger=core.modules.input name=request/
component-instance
class=org.apache.cocoon.components.modules.input.SessionModule
logger=core.modules.input name=session/
component-instance
class=org.apache.cocoon.components.modules.input.RequestParameterModule
logger=core.modules.input name=request-param/
component-instance
class=org.apache.cocoon.components.modules.input.RequestAttributeModule
logger=core.modules.input name=request-attr/
component-instance
class=org.apache.cocoon.components.modules.input.HeaderAttributeModule
logger=core.modules.input name=request-header/
component-instance
class=org.apache.cocoon.components.modules.input.SessionAttributeModule
logger=core.modules.input name=session-attr/
component-instance
class=org.apache.cocoon.components.modules.input.StringConstantModule
logger=core.modules.input name=constant/
component-instance
class=org.apache.cocoon.components.modules.input.RandomNumberModule
logger=core.modules.input name=random/
component-instance
class=org.apache.cocoon.components.modules.input.DigestMetaModule
logger=core.modules.input name=digest/
component-instance
class=org.apache.cocoon.components.modules.input.DateInputModule
logger=core.modules.input name=date/
component-instance
class=org.apache.cocoon.components.modules.input.NullInputModule
logger=core.modules.input name=nullinput/
component-instance
class=org.apache.cocoon.components.modules.input.XMLMetaModule
logger=core.modules.input name=xmlmeta/
component-instance
class=org.apache.cocoon.components.modules.input.MapMetaModule
logger=core.modules.input name=mapmeta/
component-instance
class=org.apache.cocoon.components.modules.input.DefaultsMetaModule
logger=core.modules.input name=defaults
values
skindefaultSkin/skin
base-urlhttp://localhost:8080/larva/base-url
/values
/component-instance
component-instance
class=org.apache.cocoon.components.modules.input.ChainMetaModule
logger=core.modules.input name=chain
   input-module name=request-param/
   input-module name=request-attr/
   input-module name=session-attr/
   input-module name=defaults/
/component-instance
/input-modules

 output-modules
 component-instance
class=org.apache.cocoon.components.modules.output.RequestAttributeOutputMod
ule logger=core.modules.output name=request-attr/
 component-instance
class=org.apache.cocoon.components.modules.output.SessionAttributeOutputMod
ule logger=core.modules.output name=session-attr/
/output-modules

+


A compiler parameter had to be added to the programming-languages
java-language element as follows:

parameter name=compiler
value=org.apache.cocoon.components.language.programming.java.Pizza/
(value could also be com.sun.tools.javac.Main for Javac or some other
for Jikes).

Without the compiler parameter I would get a message:
  org.apache.avalon.framework.component.ComponentException:
  UnnamedSelector: ComponentSelector could not find the component for
hint [serverpages]

Not terribly helpful but inspecting the error log exposed the culprit, ie:

  Could not set up Component for hint [ java]
  org.apache.avalon.framework.parameters.ParameterException: The
parameter 'compiler' does not contain a value



Changes to Sitemap
=
Changes are needed in order to make the sitemap internally consistant, ie
generators, readers