RE: xmlforms and Xindice and Mysql

[Sylvain.Thevoz]

Hi,

look at cocoonwiki:
http://wiki.cocoondev.org/Wiki.jsp?page=XMLFormXindice


Sylvain

-Message d'origine-
De: Uwe Knorr [mailto:[EMAIL PROTECTED]
Date: vendredi, 27. juin 2003 10:39
À: [EMAIL PROTECTED]
Objet: xmlforms and Xindice and Mysql


I want to ceate a multi-form-dialog (xmlforms)  which starts with a 
business model which is taken from a Xindice database or mysql database 
and stores the changes or the new data in theses locations. To make my 
work easier I would prefer to start with an example.
Can someone send me such an example.
Best regards
Heiner


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


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

xmlforms and Xindice and Mysql

[Uwe Knorr]

I want to ceate a multi-form-dialog (xmlforms)  which starts with a 
business model which is taken from a Xindice database or mysql database 
and stores the changes or the new data in theses locations. To make my 
work easier I would prefer to start with an example.
Can someone send me such an example.
Best regards
Heiner

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

Re: newby with cocoon esql mysql linux

[ntic]

Hello Geoff,

The problem is the same if i set the user to "root" (but i don't like 
this...).
I didn't test yet a simple jdbc connection...
I will try this.
In fact i thaught that perhaps cocoon rewrite the data concerning the 
db-connection...
thnx
Geoff Howard a écrit :

this sounds like a connection permission on mysql's end.  
what host permission have you granted the user?  Can 
you connect via jdbc from the same machine usinga a 
simple jdbc test case?

The mysql manual covers this config in pretty good detail.

Geoff Howard

 

-Original Message-
From: ntic [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 3:01 PM
To: [EMAIL PROTECTED]
Subject: newby with cocoon esql mysql linux
Hello,
I've got some trouble with my cocoon configuration.
I've got :
mysql ver. 3.23.54
the driver is mysql-connector-java-3.0.8-stable-bin.jar in 
webapps/cocoon/WEB-INF/lib/
cocoon 2.0.4

my sitemap.xmap file contain :

*http://apache.org/cocoon/sitemap/1.0";>
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

*
the web.xml contain :
*
 load-class
 
   org.hsqldb.jdbcDriver
   com.mysql.jdbc.Driver
 
   
*
the cocoon.xconf contain :
*  
   
 
 jdbc:hsqldb:hsql://localhost:9002
 sa
 
   
   
   
   jdbc:mysql://localhost/ma_table_tbl
   username
   password
   
 
*
my xsp file contains :
*
http://apache.org/xsp"; 
xmlns:esql="http://apache.org/cocoon/SQL/v2";>

   
   com.mysql.jdbc.Driver
   jdbc:mysql://localhost/ma_table_tbl
   username
   password
   
   
   SELECT type FROM type_tbl 
   
   
   
   
   
   
   
erreure
   no result
   
   


*
The query works properly when i use it in command-line, the cocoon-xsp 
work properly (i try it with a script of factorial calculus).
The problem is tha there is no connection to my database (the 
long-format log of mysql is not informed of this kind of connection) and 
the WEB-INF/log/error.log says :

*ERROR   (2003-06-17) 19:34.44:382   [core.manager] 
(/cocoon/mount/xsp/form_recherche.xsp) Thread-10/sitemap_xmap: Sitemap
org.apache.cocoon.ProcessingException: Exception in 
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error 
opening connection to dburl: jdbc:mysql://localhost/ma_table_tbl: Server 
configuration denies access to data source
   at 
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP
agesGenerator.java:270)
*

I search the web and the mail archive but i don't find any response.
I search the answer since three days and i become to be a little bit 
upset...
If someone can help me..
thx a lot
Alex

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


   

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


 



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

RE: newby with cocoon esql mysql linux

[Geoff Howard]

this sounds like a connection permission on mysql's end.  
what host permission have you granted the user?  Can 
you connect via jdbc from the same machine usinga a 
simple jdbc test case?

The mysql manual covers this config in pretty good detail.

Geoff Howard

> -Original Message-
> From: ntic [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 17, 2003 3:01 PM
> To: [EMAIL PROTECTED]
> Subject: newby with cocoon esql mysql linux
> 
> 
> Hello,
> I've got some trouble with my cocoon configuration.
> I've got :
> mysql ver. 3.23.54
> the driver is mysql-connector-java-3.0.8-stable-bin.jar in 
> webapps/cocoon/WEB-INF/lib/
> cocoon 2.0.4
> 
> my sitemap.xmap file contain :
> 
> *http://apache.org/cocoon/sitemap/1.0";>
> 
> 
>  src="org.apache.cocoon.generation.ServerPagesGenerator"/>
> 
> 
>  src="org.apache.cocoon.serialization.XMLSerializer"/>
> 
> 
>  src="org.apache.cocoon.matching.WildcardURIMatcher"/>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> *
> the web.xml contain :
> *
>   load-class
>   
> org.hsqldb.jdbcDriver
> com.mysql.jdbc.Driver
>   
> 
> *
> the cocoon.xconf contain :
> *  
> 
>   
>   jdbc:hsqldb:hsql://localhost:9002
>   sa
>   
> 
> 
> 
> jdbc:mysql://localhost/ma_table_tbl
> username
> password
> 
>   
> *
> my xsp file contains :
> *
> http://apache.org/xsp"; 
> xmlns:esql="http://apache.org/cocoon/SQL/v2";>
> 
> 
> com.mysql.jdbc.Driver
> jdbc:mysql://localhost/ma_table_tbl
> username
> password
> 
> 
> SELECT type FROM type_tbl 
> 
> 
> 
>     
> 
> 
> 
> erreure
> no result
> 
> 
> 
> 
> *
> The query works properly when i use it in command-line, the cocoon-xsp 
> work properly (i try it with a script of factorial calculus).
> The problem is tha there is no connection to my database (the 
> long-format log of mysql is not informed of this kind of connection) and 
> the WEB-INF/log/error.log says :
> 
> *ERROR   (2003-06-17) 19:34.44:382   [core.manager] 
> (/cocoon/mount/xsp/form_recherche.xsp) Thread-10/sitemap_xmap: Sitemap
> org.apache.cocoon.ProcessingException: Exception in 
> ServerPagesGenerator.generate(): java.lang.RuntimeException: Error 
> opening connection to dburl: jdbc:mysql://localhost/ma_table_tbl: Server 
> configuration denies access to data source
> at 
> org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP
> agesGenerator.java:270)
> *
> 
> I search the web and the mail archive but i don't find any response.
> I search the answer since three days and i become to be a little bit 
> upset...
> If someone can help me..
> thx a lot
> Alex
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 

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

Re: newby with cocoon esql mysql linux

[ntic]

Hello mat,
thancks for your answers, i try some of this things :
1/
For the driver i use the same :
com.mysql.jdbc.Driver

2/
I change the content of my xsp file according to your remarque
3/
I use J2SDK1.4.1_02
But it still the same : no connection to my database (no trace in my log)...
I think it's perhaps cocoon change the formulation of the connection 
data (b.e: the hostname...)
i don't know...



Mathias Wiegard a écrit :

Try this way:
First, make the following entry under

load-class
 
   ...
   
   com.mysql.jdbc.Driver
  

in WEB-INF/web.xml .
This will load the driver at start into the environment. I don'T know your
proceeding of defining an conneciton in an xsp page...
I use connection-pools:
Under the element  in WEB-INF/cocoon.xconf you can write for
you need:

   
jdbc:mysql://localhost:3306/ma_table_tbl?autoReconnect=true
   user
   password

Now, an example for the xsp could look like this:


http://apache.org/cocoon/SQL/v2";
xmlns:xsp="http://apache.org/xsp";>
   
   Test
   
   
   name-for-the-connection
   
   select * from table
   
   
   
   
   
   
   
   
   
   
   

By the way: had problems with the mysql driver version 3.x under JDK 1.3.x.
The problems vanished after I updated to JDK 1.4.1 that could be another
reason for your problem...
Hope it helps!
Mat
 

Von: ntic <[EMAIL PROTECTED]>
Antworten an: [EMAIL PROTECTED]
Datum: Tue, 17 Jun 2003 21:00:40 +0200
An: [EMAIL PROTECTED]
Betreff: newby with cocoon esql mysql linux
Hello,
I've got some trouble with my cocoon configuration.
I've got :
mysql ver. 3.23.54
the driver is mysql-connector-java-3.0.8-stable-bin.jar in
webapps/cocoon/WEB-INF/lib/
cocoon 2.0.4
my sitemap.xmap file contain :

*http://apache.org/cocoon/sitemap/1.0";>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

*
the web.xml contain :
*
   load-class
   
 org.hsqldb.jdbcDriver
 com.mysql.jdbc.Driver
   
 
*
the cocoon.xconf contain :
*  
 
   
   jdbc:hsqldb:hsql://localhost:9002
   sa
   
 
 
 
 jdbc:mysql://localhost/ma_table_tbl
 username
 password
 

*
my xsp file contains :
*
http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>

 
 com.mysql.jdbc.Driver
 jdbc:mysql://localhost/ma_table_tbl
 username
 password
 
 
 SELECT type FROM type_tbl
 
 
 
 
 
 
 erreure
 no result
 
 


*
The query works properly when i use it in command-line, the cocoon-xsp
work properly (i try it with a script of factorial calculus).
The problem is tha there is no connection to my database (the
long-format log of mysql is not informed of this kind of connection) and
the WEB-INF/log/error.log says :
*ERROR   (2003-06-17) 19:34.44:382   [core.manager]
(/cocoon/mount/xsp/form_recherche.xsp) Thread-10/sitemap_xmap: Sitemap
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
opening connection to dburl: jdbc:mysql://localhost/ma_table_tbl: Server
configuration denies access to data source
 at 
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerato
r.java:270)
*

I search the web and the mail archive but i don't find any response.
I search the answer since three days and i become to be a little bit
upset...
If someone can help me..
thx a lot
Alex
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
   



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


 



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

Re: newby with cocoon esql mysql linux

[Mathias Wiegard]

Try this way:
First, make the following entry under


load-class
  
...


com.mysql.jdbc.Driver
   


in WEB-INF/web.xml .
This will load the driver at start into the environment. I don'T know your
proceeding of defining an conneciton in an xsp page...
I use connection-pools:
Under the element  in WEB-INF/cocoon.xconf you can write for
you need:



jdbc:mysql://localhost:3306/ma_table_tbl?autoReconnect=true
user
password


Now, an example for the xsp could look like this:


http://apache.org/cocoon/SQL/v2";
xmlns:xsp="http://apache.org/xsp";>

Test


name-for-the-connection

select * from table













By the way: had problems with the mysql driver version 3.x under JDK 1.3.x.
The problems vanished after I updated to JDK 1.4.1 that could be another
reason for your problem...

Hope it helps!
Mat


> Von: ntic <[EMAIL PROTECTED]>
> Antworten an: [EMAIL PROTECTED]
> Datum: Tue, 17 Jun 2003 21:00:40 +0200
> An: [EMAIL PROTECTED]
> Betreff: newby with cocoon esql mysql linux
> 
> Hello,
> I've got some trouble with my cocoon configuration.
> I've got :
> mysql ver. 3.23.54
> the driver is mysql-connector-java-3.0.8-stable-bin.jar in
> webapps/cocoon/WEB-INF/lib/
> cocoon 2.0.4
> 
> my sitemap.xmap file contain :
> 
> *http://apache.org/cocoon/sitemap/1.0";>
>   
>   
>src="org.apache.cocoon.generation.ServerPagesGenerator"/>
>   
>   
>src="org.apache.cocoon.serialization.XMLSerializer"/>
>   
>   
>src="org.apache.cocoon.matching.WildcardURIMatcher"/>
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
> 
> *
> the web.xml contain :
> *
> load-class
> 
>   org.hsqldb.jdbcDriver
>   com.mysql.jdbc.Driver
> 
>   
> *
> the cocoon.xconf contain :
> *  
>   
> 
> jdbc:hsqldb:hsql://localhost:9002
> sa
> 
>   
>   
>   
>   jdbc:mysql://localhost/ma_table_tbl
>   username
>   password
>   
> 
> *
> my xsp file contains :
> *
> http://apache.org/xsp";
> xmlns:esql="http://apache.org/cocoon/SQL/v2";>
> 
>   
>   com.mysql.jdbc.Driver
>   jdbc:mysql://localhost/ma_table_tbl
>   username
>   password
>   
>   
>   SELECT type FROM type_tbl
>   
>   
>   
>   
>   
>   
>   erreure
>   no result
>   
>   
> 
> 
> *
> The query works properly when i use it in command-line, the cocoon-xsp
> work properly (i try it with a script of factorial calculus).
> The problem is tha there is no connection to my database (the
> long-format log of mysql is not informed of this kind of connection) and
> the WEB-INF/log/error.log says :
> 
> *ERROR   (2003-06-17) 19:34.44:382   [core.manager]
> (/cocoon/mount/xsp/form_recherche.xsp) Thread-10/sitemap_xmap: Sitemap
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
> opening connection to dburl: jdbc:mysql://localhost/ma_table_tbl: Server
> configuration denies access to data source
>   at 
> org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerato
> r.java:270)
> *
> 
> I search the web and the mail archive but i don't find any response.
> I search the answer since three days and i become to be a little bit
> upset...
> If someone can help me..
> thx a lot
> Alex
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 


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

newby with cocoon esql mysql linux

[ntic]

Hello,
I've got some trouble with my cocoon configuration.
I've got :
mysql ver. 3.23.54
the driver is mysql-connector-java-3.0.8-stable-bin.jar in 
webapps/cocoon/WEB-INF/lib/
cocoon 2.0.4

my sitemap.xmap file contain :

*http://apache.org/cocoon/sitemap/1.0";>
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

*
the web.xml contain :
*
 load-class
 
   org.hsqldb.jdbcDriver
   com.mysql.jdbc.Driver
 
   
*
the cocoon.xconf contain :
*  
   
 
 jdbc:hsqldb:hsql://localhost:9002
 sa
 
   
   
   
   jdbc:mysql://localhost/ma_table_tbl
   username
   password
   
 
*
my xsp file contains :
*
http://apache.org/xsp"; 
xmlns:esql="http://apache.org/cocoon/SQL/v2";>

   
   com.mysql.jdbc.Driver
   jdbc:mysql://localhost/ma_table_tbl
   username
   password
   
   
   SELECT type FROM type_tbl 
   
   
   
   
   
   
   erreure
   no result
   
   


*
The query works properly when i use it in command-line, the cocoon-xsp 
work properly (i try it with a script of factorial calculus).
The problem is tha there is no connection to my database (the 
long-format log of mysql is not informed of this kind of connection) and 
the WEB-INF/log/error.log says :

*ERROR   (2003-06-17) 19:34.44:382   [core.manager] 
(/cocoon/mount/xsp/form_recherche.xsp) Thread-10/sitemap_xmap: Sitemap
org.apache.cocoon.ProcessingException: Exception in 
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error 
opening connection to dburl: jdbc:mysql://localhost/ma_table_tbl: Server 
configuration denies access to data source
   at 
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:270)
*

I search the web and the mail archive but i don't find any response.
I search the answer since three days and i become to be a little bit 
upset...
If someone can help me..
thx a lot
Alex

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

Re: No valid JdbcConnection class available with MySQL

[Geoff Howard]

At 01:39 PM 6/2/2003, you wrote:
On Monday, June 2, 2003, at 07:47  AM, Geoff Howard wrote:

Not even by the name of the jar?  For instance, in 2.0.x for jdk1.4 the 
excalibur datasource
jar is called excalibur-datasource-vm14-20021121.jar.  The vm14 stands 
for "virtual machine version 1.4"  and I think the other is called *vm12*.
You're right. I don't know how I missed that. That's the only one that's 
different though. Does that mean the rest of the libraries are the same? 
It would sure have been a lot easier to swap one .jar file than to 
reinstall Cocoon.
I'm not certain but don't think that it's the only difference.  It should 
be the only different jar in the lib directory - but at various points 
there has been conditional compilation in the cocoon classes 
themselves.  It wasn't always so, and I don't think it's so now (in 2.1 
HEAD).  If you're curious though, I'd love to find out what happens if you 
take that route!

Geoff 

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

Re: No valid JdbcConnection class available with MySQL

[Austin Tashis]

On Monday, June 2, 2003, at 07:47  AM, Geoff Howard wrote:

Not even by the name of the jar?  For instance, in 2.0.x for jdk1.4 
the excalibur datasource
jar is called excalibur-datasource-vm14-20021121.jar.  The vm14 stands 
for "virtual machine version 1.4"  and I think the other is called 
*vm12*.
You're right. I don't know how I missed that. That's the only one 
that's different though. Does that mean the rest of the libraries are 
the same? It would sure have been a lot easier to swap one .jar file 
than to reinstall Cocoon.

Thanks again,
--
Austin
=
"Things that never before had names are now easily described. Makes 
conversation easy!"
--David Byrne, "True Stories"

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

Re: No valid JdbcConnection class available with MySQL

[Geoff Howard]

At 10:53 PM 6/1/2003, you wrote:
On Sunday, June 1, 2003, at 09:19  PM, Geoff Howard wrote:

Are the samples still in tact (I assume they are since this
is binary dist)?  If so, can you confirm that the database
samples (which use hsql) are working, or do you get the
same error?  If so, I'd guess that you may be using a
jdk 1.2/3 version of the excalibur database package.
I don't remember what the error was, but I never did manage to get the 
HSQLDB examples to work before, but I didn't worry too much about it 
because I needed to get JDBC working anyway.

Anyway, I finally got the newer version to install and copied all the 
files I'd changed into it, and now it's WORKING! Both the HSQLDB examples 
and the MySQL example. So it must have been the JDK 1.3 version I'd been 
using. Good call.
For future reference: hsqldb _is_ jdbc.  If it's not working, then other 
databases
probably won't either because of the exact problem you found - the break 
between
jdk1.4 and previous versions that affects the excalibur datasource component.

Do a directory listing of your WEB-INF/lib - any jdk dependant
jars should give some clue as to which version they are.
Now that I've got both versions here, I don't see any way to tell the two 
apart by inspecting the .jar files in WEB-INF/lib. It might be a good idea 
to write up a FAQ and make the two lib versions available for download. It 
would sure be easier to replace the lib directory than try to reinstall 
Cocoon. That was a real pain!
Not even by the name of the jar?  For instance, in 2.0.x for jdk1.4 the 
excalibur datasource
jar is called excalibur-datasource-vm14-20021121.jar.  The vm14 stands for 
"virtual machine version 1.4"  and I think the other is called *vm12*.

Glad things worked out,

Geoff 

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

Re: No valid JdbcConnection class available with MySQL

[Austin Tashis]

On Monday, June 2, 2003, at 05:28  AM, Alexander Czernay wrote:

Is there any trick to un-installing cocoon? I tried removing all its 
folders from Tomcat, but when I put the new cocoon.war file in there 
it didn't do anything. :-/

I ran into this problem, too. I finally found it was only a 
permissions problem. You should check, if you granted read and execute 
rights on the  war to your tomcat process. Maybe just chown it to the 
tomcat user.
I don't think that was the problem. It eventually did install, and 
while I'm not sure exactly what I did (I was trying a lot of different 
things and suddenly there it was), but it never occurred to me to 
change the owner of the file.
--
Austin
==
I've decided that egg nog is my very favorite kind of nog.

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

Re: No valid JdbcConnection class available with MySQL

[Alexander Czernay]

Is there any trick to un-installing cocoon? I tried removing all its 
folders from Tomcat, but when I put the new cocoon.war file in there it 
didn't do anything. :-/


I ran into this problem, too. I finally found it was only a permissions 
problem. You should check, if you granted read and execute rights on the 
 war to your tomcat process. Maybe just chown it to the tomcat user.

--
_
Alexander Czernay
IT-Consulting & Media Development
fon +49-40-41096742
fax +49-40-41096743
icq 4773650
[EMAIL PROTECTED]
www.czernay.com
_


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

Re: No valid JdbcConnection class available with MySQL

[Austin Tashis]

On Sunday, June 1, 2003, at 09:19  PM, Geoff Howard wrote:

Are the samples still in tact (I assume they are since this
is binary dist)?  If so, can you confirm that the database
samples (which use hsql) are working, or do you get the
same error?  If so, I'd guess that you may be using a
jdk 1.2/3 version of the excalibur database package.
I don't remember what the error was, but I never did manage to get the 
HSQLDB examples to work before, but I didn't worry too much about it 
because I needed to get JDBC working anyway.

Anyway, I finally got the newer version to install and copied all the 
files I'd changed into it, and now it's WORKING! Both the HSQLDB 
examples and the MySQL example. So it must have been the JDK 1.3 
version I'd been using. Good call.

Do a directory listing of your WEB-INF/lib - any jdk dependant
jars should give some clue as to which version they are.
Now that I've got both versions here, I don't see any way to tell the 
two apart by inspecting the .jar files in WEB-INF/lib. It might be a 
good idea to write up a FAQ and make the two lib versions available for 
download. It would sure be easier to replace the lib directory than try 
to reinstall Cocoon. That was a real pain!

Thanks very much for your help, and Scott too. You've been very helpful.
--
Austin
=
"A computer lets you make mistakes faster than any other invention in 
human history, with the possible exception of handguns and tequila."
--D.W. McArthur

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

RE: No valid JdbcConnection class available with MySQL

[Geoff Howard]

Are the samples still in tact (I assume they are since this 
is binary dist)?  If so, can you confirm that the database 
samples (which use hsql) are working, or do you get the 
same error?  If so, I'd guess that you may be using a 
jdk 1.2/3 version of the excalibur database package.  

Do a directory listing of your WEB-INF/lib - any jdk dependant 
jars should give some clue as to which version they are.

Geoff

> -Original Message-
> From: Austin Tashis [mailto:[EMAIL PROTECTED]
> Sent: Sunday, June 01, 2003 8:26 PM
> To: [EMAIL PROTECTED]
> Subject: Re: No valid JdbcConnection class available with MySQL
> 
> 
> On Sunday, June 1, 2003, at 03:14  PM, Geoff Howard wrote:
> 
> > If it's not already, you may want to set error level to info or debug -
> > you may see more information.
> 
> It is, but there are no database related messages
> 
> >> The cocoon error log just contains the same error message that's
> >> displayed in the browser. Tomcat is not having a problem with the
> >> database as other webapps are currently using it with no difficulty.
> >
> > But cocoon could be causing tomcat to log there during its startup.
> > Unless you're trying to use a tomcat-managed database pool --
> > that would be a different set of things to look at.
> 
> I don't see anything unusual in the logs, except that HSQLDB is 
> running. I had assumed it wasn't working because I couldn't connect to 
> it either.
> 
> >>> - the driver not being declared in web.xml
> >>
> >> It is.
> >
> > Can you paste your snippet?
> 
>  
>load-class
>
>  
>  com.mysql.jdbc.Driver
>  
>
>  
> 
> The one that's commented out is for the older driver. I've tried both 
> of them with the newer driver with the same result.
> 
> >>> - using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa
> >>
> >> This is a possibility. I'm pretty sure I downloaded the right one, but
> >> I could be wrong--at least it's something I can double-check.
> >
> > Yes, check.  Which jdk are you using?
> 
> 1.4.1
> 
> > I guess this also means that you're using 2.0.x, since 2.1 doesn't
> > have a binary options (precisely because of problems like this
> > among other reasons)
> 
> Yes, I'm using 2.0.4. If I were using 2.1 I'd probably be asking for 
> help getting it to build. :-/
> 
> >> Is there any trick to un-installing cocoon? I tried removing all its
> >> folders from Tomcat, but when I put the new cocoon.war file in there 
> >> it
> >> didn't do anything. :-/
> >
> > You may need to delete the cocoon stuff out of tomcat's work directory.
> 
> It didn't help.
> --
> Austin
> =
> "A Jedi's strength flows from The Source. But beware of the dark side. 
> COM... DCOM... VB... ActiveX... ADO... ASP... .NET The dark side of 
> The Source are they. Easily they flow, quick to join you in a project. 
> If once you start down the dark path, forever will it dominate your 
> destiny, consume you it will."
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 

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

Re: No valid JdbcConnection class available with MySQL

[Austin Tashis]

On Sunday, June 1, 2003, at 03:14  PM, Geoff Howard wrote:

If it's not already, you may want to set error level to info or debug -
you may see more information.
It is, but there are no database related messages

The cocoon error log just contains the same error message that's
displayed in the browser. Tomcat is not having a problem with the
database as other webapps are currently using it with no difficulty.
But cocoon could be causing tomcat to log there during its startup.
Unless you're trying to use a tomcat-managed database pool --
that would be a different set of things to look at.
I don't see anything unusual in the logs, except that HSQLDB is 
running. I had assumed it wasn't working because I couldn't connect to 
it either.

- the driver not being declared in web.xml
It is.
Can you paste your snippet?

  load-class
  

com.mysql.jdbc.Driver

  

The one that's commented out is for the older driver. I've tried both 
of them with the newer driver with the same result.

- using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa
This is a possibility. I'm pretty sure I downloaded the right one, but
I could be wrong--at least it's something I can double-check.
Yes, check.  Which jdk are you using?
1.4.1

I guess this also means that you're using 2.0.x, since 2.1 doesn't
have a binary options (precisely because of problems like this
among other reasons)
Yes, I'm using 2.0.4. If I were using 2.1 I'd probably be asking for 
help getting it to build. :-/

Is there any trick to un-installing cocoon? I tried removing all its
folders from Tomcat, but when I put the new cocoon.war file in there 
it
didn't do anything. :-/
You may need to delete the cocoon stuff out of tomcat's work directory.
It didn't help.
--
Austin
=
"A Jedi's strength flows from The Source. But beware of the dark side. 
COM... DCOM... VB... ActiveX... ADO... ASP... .NET The dark side of 
The Source are they. Easily they flow, quick to join you in a project. 
If once you start down the dark path, forever will it dominate your 
destiny, consume you it will."

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

Re: No valid JdbcConnection class available with MySQL

[Austin Tashis]

On Sunday, June 1, 2003, at 03:53  PM, Scott McClure wrote:

Is there any trick to un-installing cocoon? I tried removing all its 
folders from Tomcat, but when I put the new cocoon.war file in there 
it didn't do anything. :-/

Try using the web-based manager. First remove it, then delete the dir. 
The manager is at /manager/html.
Okay, I tried removing it:

http://localhost:8080/manager/remove?path=/cocoon
--> OK - Removed application at context path /cocoon
Then I removed the old war file, removed the directories from webapps 
and work, put the new cocoon.war file in the webapps folder, restarted 
Tomcat and requested the application. The request timed out and nothing 
happened in the webapps folder--no new cocoon folder. So I tried to 
install it from the manager:

http://localhost:8080/manager/install?path=/cocoon&war=file:/cocoon.war
--> FAIL - Application already exists at path /cocoon
So I ran the remove command again:

http://localhost:8080/manager/remove?path=/cocoon
--> OK - Removed application at context path /cocoon
Then ran the install command:

http://localhost:8080/manager/install?path=/cocoon&war=file:/cocoon.war
OK - Installed application at context path /cocoon
But nothing seemed to happen in the webapps folder. So I requested it 
again. The request timed out again.
--
Austin
=
I think a good gift for the president would be a chocolate revolver. 
And since he's so busy, you'd probably have to run up to him and hand 
it to him.
-- Jack Handey

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

Re: No valid JdbcConnection class available with MySQL

[Scott McClure]

Is there any trick to un-installing cocoon? I tried removing all its 
folders from Tomcat, but when I put the new cocoon.war file in there it 
didn't do anything. :-/

Try using the web-based manager. First remove it, then delete the dir. 
The manager is at /manager/html.

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

RE: No valid JdbcConnection class available with MySQL

[Geoff Howard]

> > check through the logs in WEB-INF/logs and the tomcat logs as well for
> > errors reported in instantiating the connection at startup.

If it's not already, you may want to set error level to info or debug - 
you may see more information.
 
> The cocoon error log just contains the same error message that's 
> displayed in the browser. Tomcat is not having a problem with the 
> database as other webapps are currently using it with no difficulty.

But cocoon could be causing tomcat to log there during its startup.  
Unless you're trying to use a tomcat-managed database pool -- 
that would be a different set of things to look at.

> > - the driver not being declared in web.xml
> 
> It is.

Can you paste your snippet?

> > - using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa
> 
> This is a possibility. I'm pretty sure I downloaded the right one, but 
> I could be wrong--at least it's something I can double-check.

Yes, check.  Which jdk are you using?  I guess this also means that 
you're using 2.0.x, since 2.1 doesn't have a binary options (precisely 
because of problems like this among other reasons)

> Is there any trick to un-installing cocoon? I tried removing all its 
> folders from Tomcat, but when I put the new cocoon.war file in there it 
> didn't do anything. :-/

You may need to delete the cocoon stuff out of tomcat's work directory.

Geoff

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

Re: No valid JdbcConnection class available with MySQL

[Austin Tashis]

On Sunday, June 1, 2003, at 01:57  PM, Geoff Howard wrote:

check through the logs in WEB-INF/logs and the tomcat logs as well for
errors reported in instantiating the connection at startup.
The cocoon error log just contains the same error message that's 
displayed in the browser. Tomcat is not having a problem with the 
database as other webapps are currently using it with no difficulty.

 Typically this problem has come down to one of the following:
- permissions in mysql (is your user permitted to connect from
localhost/ip?)
Yes, I am using the same username/password as the other webapps, and 
they are working fine. Also, I can change the user info and produce an 
authentication error, so this is clearly a different problem.

- the driver not being declared in web.xml
It is.

- using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa
This is a possibility. I'm pretty sure I downloaded the right one, but 
I could be wrong--at least it's something I can double-check.

Is there any trick to un-installing cocoon? I tried removing all its 
folders from Tomcat, but when I put the new cocoon.war file in there it 
didn't do anything. :-/

- something else that escapes me
Let me know if you recapture it. ;-)

Any of that help?
Possibly. I'll let you know. At any rate, thank you very much for 
replying!
--
Austin

"The goal of Computer Science is to build something that will last at 
least until we've finished building it."
--Unknown

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

RE: No valid JdbcConnection class available with MySQL

[Geoff Howard]

check through the logs in WEB-INF/logs and the tomcat logs as well for
errors reported in instantiating the connection at startup.  Typically
this problem has come down to one of the following:
- permissions in mysql (is your user permitted to connect from
localhost/ip?)
- the driver not being declared in web.xml
- using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa
- something else that escapes me

Any of that help?

Geoff Howard

> -Original Message-
> From: Austin Tashis [mailto:[EMAIL PROTECTED]
> Sent: Sunday, June 01, 2003 9:31 AM
> To: [EMAIL PROTECTED]
> Subject: No valid JdbcConnection class available with MySQL
>
>
> I'm just getting started with Cocoon and trying to get the database
> connectivity part working with MySQL. I set up the database, set up the
> configurations in web.xml and cocoon.conf and installed the MySQL
> driver, but when I try to run it I get the following error:
>
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not
> get the datasource
> org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
> valid JdbcConnection class available
>
> I do have the driver in the WEB-INF/lib folder. I've tried two
> different versions (mm.mysql-2.0.12-bin.jar and
> mysql-connector-java-3.0.6-stable-bin.jar), both of which work with
> other Tomcat webapps on the same machine.
>
> I have also checked to see if there is a JdbcConnection class in the
> classpath, and found it to be in the same jar file as the
> NoValidConnectionException class that is returning the error, so I
> really can't see how the JdbcConnection class could be unavailable.
>
> If I enter the wrong password in the datasource description in
> cocoon.xconf, I get an "Invalid authorization specification" error
> instead. It seems to me that in order to get this type of error, cocoon
> must be talking to the database, but that would be impossible if it had
> no valid JdbcConnection class, right? Or am I misunderstanding how
> these things work?
>
> I'm running this on Mac OS X, 10.2.6, JDK 1.4.1, MySQL 4.0.12, Cocoon
> 2.0.4, Tomcat 4.1.18, Apache 1.3.27.
> --
> Austin
> 
> "Money isn't the most important thing in the world, but it's way ahead
> of whatever's in third."
> --Dick Messenger
>
>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>


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

No valid JdbcConnection class available with MySQL

[Austin Tashis]

I'm just getting started with Cocoon and trying to get the database 
connectivity part working with MySQL. I set up the database, set up the 
configurations in web.xml and cocoon.conf and installed the MySQL 
driver, but when I try to run it I get the following error:

org.apache.cocoon.ProcessingException: Exception in 
ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not 
get the datasource 
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No 
valid JdbcConnection class available

I do have the driver in the WEB-INF/lib folder. I've tried two 
different versions (mm.mysql-2.0.12-bin.jar and 
mysql-connector-java-3.0.6-stable-bin.jar), both of which work with 
other Tomcat webapps on the same machine.

I have also checked to see if there is a JdbcConnection class in the 
classpath, and found it to be in the same jar file as the 
NoValidConnectionException class that is returning the error, so I 
really can't see how the JdbcConnection class could be unavailable.

If I enter the wrong password in the datasource description in 
cocoon.xconf, I get an "Invalid authorization specification" error 
instead. It seems to me that in order to get this type of error, cocoon 
must be talking to the database, but that would be impossible if it had 
no valid JdbcConnection class, right? Or am I misunderstanding how 
these things work?

I'm running this on Mac OS X, 10.2.6, JDK 1.4.1, MySQL 4.0.12, Cocoon 
2.0.4, Tomcat 4.1.18, Apache 1.3.27.
--
Austin

"Money isn't the most important thing in the world, but it's way ahead 
of whatever's in third."
--Dick Messenger

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

mySQL xsp query - working on 2.0.3 NOT on 2.1 last CVS

[Stavros Kounis]

i try to run a simple query using an .xsp file
in last [04.11.2003] cocoon CVS snapshot

and i get the follow error msg

i have check and re-check the code many times and i dont see something
different from some examples

error msg:

org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
query_xsp:
ERROR 1
(org\apache\cocoon\www\file_\C_\Server\xwww\osOthello\scratchpad\actionauth\query_xsp.java):
...



// start error (lines 3-3) "The declared package does not match the
expected package
org.apache.cocoon.www.file_.C_.Server.xwww.osOthello.scratchpad.actionauth"
package
org.apache.cocoon.www.file_.C_.server.xwww.osOthello.scratchpad.actionauth;

// end error

import java.io.File;
import java.io.IOException;
import java.io.StringReader;

...
Line 3, column 0: The declared package does not match the expected package
org.apache.cocoon.www.file_.C_.Server.xwww.osOthello.scratchpad.actionauth


xconf entry in datasources:


false
jdbc:mysql://192.168.0.50:3306/othello
root



web.xml entry in init-param:

org.gjt.mm.mysql.Driver

i have use
jakarta-tomcat-4.1.17
winxp

and i have put  mysql-connector-java-2.0.14-bin.jar

in tomcat's common/lib
and cocoon's /web-inf/lib


the strange thing is that using the same files (subsitemap)
mounted from another cocoon instance
cocoon 2.0.3 on jakarta-tomcat-4.0.6

i get the results (queriy results) without errors


-- stavros


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

Mysql and sql transformer

[Luca Marchetti]

Hi all,
 I've got a problem with mysql (on win or linux) and sql transformer.
I've followed the instruction on the cocoon wiki about how to set-up 
mysql jdbc drivers, I've set up a simple pipeline with a really simple 
query, but the result is always the same:

Failed to obtain connection. Made 5 attempts with 5000ms interval

I'm pretty sure about my pipeline, and I know pretty well the sql 
transformer (massively used with as400).

So... have anyone experienced the same problem?

what about?

Thanks in advice.

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

sitemap authentication - mySQL

[Stavros Kounis]

hi

i try to make from scratch an example of sitemap authentication
but i dont know where is the database the [protected] example use
is there any interface (command line maybe) to this database?

how can i make this example use a table in a mySQL database running in the
same machine ?

stavros



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

Re: MySQL date conversion with modular database action

[Christian Haul]

On 19.Feb.2003 -- 11:45 AM, Andre Taube wrote:
> Still the same:
> 
> DEBUG   (2003-02-19) 12:28.28:239   [sitemap.action.DatabaseUpdateAction]
> (/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
> column pcm_contract.contract_status from request-param using getAttribute
> method
> 

OK, let's look at the samples for the database actions. Let's add a
date column to user:

   alter table add column since date;

(use org.hsqldb.util.DatabaseManager to connect to the server at port
9002 to do this or edit cocoondb.script accordingly)

Change database.xml: (Note: a typo prevented specifying parameter and
format like below. Update the Date*Module.java files from CVS -- don't
update everything yet, Stefano is tweaking the build system and you
might not be able to build a new CVS version right away.)

   
  
 

 
  
  
 
 
 

 
 
   
 user.since
 MM/dd/yy
 
   
 

 

 
   


I have used the @type="all" here, since I alway want to convert dates
here.

Add the following to user-list.xsp:


  


and


  

  


I trust you figure out where to add this ;-)

Please veryfy that this does indeed work for you.

Now, let's look at the other issue: using a different mode for an
operation. Look at the following table-set

   
  
  
   

and compare with the table definition below

   
  
 


   
org.apache.cocoon.components.modules.output.OutputModule:user.uid[0]

 
 

 
  
   

Now, look at sitemap.log (note: default recently switched to log level
ERROR, make sure you have set log level in web.xml and logkeit.xconf
to DEBUG)

 DatabaseAction: modeTypes : {1=attrib, 2=request-attr, 0=autoincr}

this line shows that we are really using "attrib" for others-mode,
"request-attr" for output and "autoincr" for autoincrement columns
(when inserting)

 DatabaseAction: i=0
 DatabaseAction: requested mode was "attrib" returning "attrib"

this shows that we're indeed requesting "attrib" as mode for the first
column (-> user_groups.uid) and that it was found.

 DatabaseAction: i=1
 DatabaseAction: requested mode was "attrib" returning "all"

again, "attrib" was requested but "all" is found (first) thus the mode
with @type="all" is used for column 2 (-> user_groups.gid)

 DatabaseAction: query: INSERT INTO user_groups (uid, gid) VALUES (?, ?)
 DatabaseAction: Trying to set column user_groups.uid from request-attr using 
getAttribute method
 DatabaseAction: Setting column user_groups.uid [0] 6
 DatabaseAction: Trying to set column user_groups.gid from request-param using 
getAttributeValues method
 DatabaseAction: Setting column user_groups.gid [0] 0
 DatabaseAction: > row no. 0
 DatabaseAction: Setting column user_groups.uid[0] to 6
 DatabaseAction: Setting column user_groups.gid[0] to 0
 DefaultComponentFactory: ComponentFactory decommissioning instance of 
org.apache.cocoon.acting.modular.DatabaseAddAction.

HTH

Chris.
-- 
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

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

RE: MySQL date conversion with modular database action

[Andre Taube]

Still the same:

DEBUG   (2003-02-19) 12:28.28:239   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_status from request-param using getAttribute
method


> -Original Message-
> From: Christian Haul [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 19, 2003 11:32 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL date conversion with modular database action
>
>
> Andre Taube wrote:
> > It still does not work.
>
> > 
>  =
>
> > 
>  ===
> This does not match!
>
>   Chris.
>
> --
> C h r i s t i a n   H a u l
> [EMAIL PROTECTED]
>  fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08
>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: MySQL date conversion with modular database action

[Christian Haul]

Andre Taube wrote:

It still does not work.



		

=




===
This does not match!

	Chris.

--
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08


-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

RE: MySQL date conversion with modular database action

[Andre Taube]

   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.job_number from request-param using getAttribute method
DEBUG   (2003-02-19) 11:22.42:566   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.job_number [0] ABC DEF
DEBUG   (2003-02-19) 11:22.42:567   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.misc_code from request-param using getAttribute method
DEBUG   (2003-02-19) 11:22.42:568   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.misc_code [0] 123123
DEBUG   (2003-02-19) 11:22.42:569   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.start_date from request-param using getAttribute method
DEBUG   (2003-02-19) 11:22.42:570   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.start_date [0] 02/03/2003
DEBUG   (2003-02-19) 11:22.42:571   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.end_date from request-param using getAttribute method
DEBUG   (2003-02-19) 11:22.42:572   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.end_date [0] 02/03/2003
DEBUG   (2003-02-19) 11:22.42:573   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_status from request-param using getAttribute
method
DEBUG   (2003-02-19) 11:22.42:574   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_status [0] 0
DEBUG   (2003-02-19) 11:22.42:575   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: > row no. 0
DEBUG   (2003-02-19) 11:22.42:576   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_name[0] to Qwerty 123123
DEBUG   (2003-02-19) 11:22.42:577   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_type[0] to 1
DEBUG   (2003-02-19) 11:22.42:579   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_code[0] to QWERTY 123123
DEBUG   (2003-02-19) 11:22.42:580   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.job_number[0] to ABC DEF
DEBUG   (2003-02-19) 11:22.42:582   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.misc_code[0] to 123123
DEBUG   (2003-02-19) 11:22.42:583   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.start_date[0] to 02/03/2003
DEBUG   (2003-02-19) 11:22.42:585   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Rolling back
transaction. Caused by null
DEBUG   (2003-02-19) 11:22.42:599   [sitemap]
(/pcm/contract_admin.contract.html) Thread-9/DefaultComponentFactory:
ComponentFactory decommissioning instance of
org.apache.cocoon.acting.modular.DatabaseUpdateAction.


Thanks for your help!
Andre

> -Original Message-
> From: Christian Haul [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 18, 2003 9:46 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL date conversion with modular database action
>
>
> Andre Taube wrote:
>
> 
>
>  > Trying to set column pcm_contract.start_date from request-param using
> getAttribute method
>  > Setting column pcm_contract.start_date [0] 2/9/2003
>
> This shows cleanly that you haven't requested the "attribute" mode here.
> Please check your table set!
>
>   Chris.
>
> --
> C h r i s t i a n   H a u l
> [EMAIL PROTECTED]
>  fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08
>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>



-
Please check that your question  has not already been answered in the
FAQ be

Re: MySQL date conversion with modular database action

[Christian Haul]

Andre Taube wrote:



> Trying to set column pcm_contract.start_date from request-param using 
getAttribute method
> Setting column pcm_contract.start_date [0] 2/9/2003

This shows cleanly that you haven't requested the "attribute" mode here. 
Please check your table set!

	Chris.

--
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08


-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

RE: MySQL date conversion with modular database action

[Andre Taube]

-02-18) 09:24.53:866   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Trying to set
column pcm_contract.job_number from request-param using getAttribute method
DEBUG   (2003-02-18) 09:24.53:867   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.job_number [0]
DEBUG   (2003-02-18) 09:24.53:868   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Trying to set
column pcm_contract.misc_code from request-param using getAttribute method
DEBUG   (2003-02-18) 09:24.53:869   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.misc_code [0]
DEBUG   (2003-02-18) 09:24.53:870   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Trying to set
column pcm_contract.start_date from request-param using getAttribute method
DEBUG   (2003-02-18) 09:24.53:871   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.start_date [0] 2/9/2003
DEBUG   (2003-02-18) 09:24.53:872   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Trying to set
column pcm_contract.end_date from request-param using getAttribute method
DEBUG   (2003-02-18) 09:24.53:873   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.end_date [0] 2/9/2003
DEBUG   (2003-02-18) 09:24.53:874   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Trying to set
column pcm_contract.contract_status from request-param using getAttribute
method
DEBUG   (2003-02-18) 09:24.53:875   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.contract_status [0] 1
DEBUG   (2003-02-18) 09:24.53:876   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: > row no.
0
DEBUG   (2003-02-18) 09:24.53:877   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.contract_name[0] to Date Test
DEBUG   (2003-02-18) 09:24.53:919   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.contract_type[0] to 1
DEBUG   (2003-02-18) 09:24.53:922   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.contract_code[0] to TEMP 123
DEBUG   (2003-02-18) 09:24.53:928   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.job_number[0] to
DEBUG   (2003-02-18) 09:24.53:930   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.misc_code[0] to
DEBUG   (2003-02-18) 09:24.53:932   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Setting
column pcm_contract.start_date[0] to 2/9/2003
DEBUG   (2003-02-18) 09:24.53:940   [sitemap.action.DatabaseUpdateAction]
(/pcm1/contract_admin.contract.html) Thread-26/DatabaseAction: Rolling back
transaction. Caused by null
DEBUG   (2003-02-18) 09:24.53:975   [sitemap]
(/pcm1/contract_admin.contract.html) Thread-26/DefaultComponentFactory:
ComponentFactory decommissioning instance of
org.apache.cocoon.acting.modular.DatabaseUpdateAction.


Thanks!!!

> -Original Message-
> From: Christian Haul [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 18, 2003 3:18 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL date conversion with modular database action
>
>
> Andre Taube wrote:
> > Thanks, that's exactly what I need.  However, my date is in MM/dd/
> > format, how could I pass a format string to the
> DateMetaInputModule?  API
> > says: "Configuration options: child element "input-module"
> holds InputModule
> > to obtain the string from, attribute "format" to "input-module"
> that holds a
> > java.text.SimpleDateFormat format string"
> >
> > but the following does not work for me:
> >
> > 
> >
> >
> >   
> >   start_date
>  MM/dd/
> >   
>  
> >
> > 
>
> If this doesn't work, make sure that a) you are running a recent
> snapshot (either branch) and b) include complete file (i.e. table-set)
> and logs showing invokation of your action.
>
>   Chris.
>
> --
> C h r i s t i a n   H a u l
> [EMAIL PROTECTED]
>  

Re: MySQL date conversion with modular database action

[Christian Haul]

Andre Taube wrote:

Thanks, that's exactly what I need.  However, my date is in MM/dd/
format, how could I pass a format string to the DateMetaInputModule?  API
says: "Configuration options: child element "input-module" holds InputModule
to obtain the string from, attribute "format" to "input-module" that holds a
java.text.SimpleDateFormat format string"

but the following does not work for me:


   
   
  
  start_date

MM/dd/

  



   



If this doesn't work, make sure that a) you are running a recent 
snapshot (either branch) and b) include complete file (i.e. table-set) 
and logs showing invokation of your action.

	Chris.

--
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08


-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

RE: MySQL date conversion with modular database action

[Andre Taube]

Thanks, that's exactly what I need.  However, my date is in MM/dd/
format, how could I pass a format string to the DateMetaInputModule?  API
says: "Configuration options: child element "input-module" holds InputModule
to obtain the string from, attribute "format" to "input-module" that holds a
java.text.SimpleDateFormat format string"

but the following does not work for me:


   
   
  
  start_date
  
  
   




> -Original Message-
> From: Christian Haul [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 17, 2003 12:54 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL date conversion with modular database action
>
>
> On 15.Feb.2003 -- 01:44 AM, Andre Taube wrote:
> > Any pointers on how to convert a date before it's inserted into MySQL
> > database while using cocoon's Modular Database Action?
> >
> > I tried
> >
> > 
> >  >
> parameter="org.apache.cocoon.components.modules.input.DateMetaInpu
> tModule:start_date[0]"
> >   type="attrib"/>
> > 
> >
> > It seems this "mode" parameter is being ignored.
>
> Hi. You don't include all involved configuration lines so let's
> analyse only the above mode element:
>
> @name -> use the input module known as "attribute". This used to be
>  the one operating on request attributes. This has been
>renamed to "request-attr" for default configurations.
>  Make sure there is an input modules with short-hand
>"attribute"!
>
> @parameter -> interpretation depends on the input module used. Not all
>  modules accept this parameter. For the request attribute
>module, this is the name of the request attribute to use
>instead of the one actually passed to the getAttribute()
>method. The default name generated by the database
> actions is
>"table.column"
>Make sure that this attribute exists and contains a
>compatible value!
>
> @type -> By placing XML-attributes "others-mode" or
>  "autoincrement-mode" to the  elements inside the
> elements, different modes can be
> selected. This
>mode is only used when the table in the table-set has the
>XML-attribute others-mode="attrib"
>Make sure that this is the case!
>
> But I reckon that you really wanted to write
>
> 
>
>
>   
>   start_date
>   
>   
>
> 
>
> or the like.
>
> BTW if you were using a recent snapshot (of either branch), then you
> might not need to convert a string to a date if it is a valid SQL date
> representation.
>
>   Chris.
> --
> C h r i s t i a n   H a u l
> [EMAIL PROTECTED]
> fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: R: MySQL date conversion with modular database action

[Antonio Gallardo]

Christian Haul dijo:
> On 17.Feb.2003 -- 03:31 PM, Marco Taiuti wrote:
>> I have a DatabaseAction with the followed descriptor
>>
>> 
>> 
>>  line_db
>>  
>>  
>>  
>>  
>>  
>>  
>>   
>>  
>>  
>> 
>>
>> How i can use the DateMetaInputModule or DateInputModule to format
>> date "datpub" to 'dd/MM/'?
>> Thanks,
>
> Short answer: Since you apparently do not use the "modular" database
> actions, you cannot.
>
> Long answer: There are two sets of database actions: one set in
> org.apache.cocoon.acting and another one in
> org.apache.cocoon.acting.modular They are similar to a great deal but
> differ in details. Configuration files from the "original" actions can
> mostly be used with the "modular" ones.
>
> Formating the date is an output issue, which is not handled by the
> actions. At least in case of the modular actions, they return a java
> date object, not a string. Parsing input data is an issue. Of my head I
> believe both Date*Module take a format parameter that is expected to
> conform to the SimpleDateFormat specs. See javadocs for details.

More info at: http://wiki.cocoondev.org/Wiki.jsp?page=DatabaseActions

Antonio Gallardo
>
>   Chris.
> --
> C h r i s t i a n   H a u l
> [EMAIL PROTECTED]
> fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. 
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>




-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

Re: R: MySQL date conversion with modular database action

[Christian Haul]

On 17.Feb.2003 -- 03:31 PM, Marco Taiuti wrote:
> I have a DatabaseAction with the followed descriptor
> 
> 
> 
>   line_db
>   
>   
>   
>   
>   
>   
>   
>   
>   
> 
> 
> How i can use the DateMetaInputModule or DateInputModule to format date
> "datpub" to 'dd/MM/'?
> Thanks,

Short answer: Since you apparently do not use the "modular" database
actions, you cannot.

Long answer: There are two sets of database actions: one set in
org.apache.cocoon.acting and another one in
org.apache.cocoon.acting.modular They are similar to a great deal but
differ in details. Configuration files from the "original" actions
can mostly be used with the "modular" ones.

Formating the date is an output issue, which is not handled by the
actions. At least in case of the modular actions, they return a java
date object, not a string. Parsing input data is an issue. Of my head
I believe both Date*Module take a format parameter that is expected to
conform to the SimpleDateFormat specs. See javadocs for details.

Chris.
-- 
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

R: MySQL date conversion with modular database action

[Marco Taiuti]

I have a DatabaseAction with the followed descriptor



line_db






  




How i can use the DateMetaInputModule or DateInputModule to format date
"datpub" to 'dd/MM/'?
Thanks,
Marco

> -Messaggio originale-
> Da: Christian Haul [mailto:[EMAIL PROTECTED]]
> Inviato: lunedi 17 febbraio 2003 9.54
> A: [EMAIL PROTECTED]
> Oggetto: Re: MySQL date conversion with modular database action
>
>
> On 15.Feb.2003 -- 01:44 AM, Andre Taube wrote:
> > Any pointers on how to convert a date before it's inserted into MySQL
> > database while using cocoon's Modular Database Action?
> >
> > I tried
> >
> > 
> >  >
> parameter="org.apache.cocoon.components.modules.input.DateMetaInpu
> tModule:start_date[0]"
> >   type="attrib"/>
> > 
> >
> > It seems this "mode" parameter is being ignored.
>
> Hi. You don't include all involved configuration lines so let's
> analyse only the above mode element:
>
> @name -> use the input module known as "attribute". This used to be
>  the one operating on request attributes. This has been
>renamed to "request-attr" for default configurations.
>  Make sure there is an input modules with short-hand
>"attribute"!
>
> @parameter -> interpretation depends on the input module used. Not all
>  modules accept this parameter. For the request attribute
>module, this is the name of the request attribute to use
>instead of the one actually passed to the getAttribute()
>method. The default name generated by the database
> actions is
>"table.column"
>Make sure that this attribute exists and contains a
>compatible value!
>
> @type -> By placing XML-attributes "others-mode" or
>  "autoincrement-mode" to the  elements inside the
> elements, different modes can be
> selected. This
>mode is only used when the table in the table-set has the
>XML-attribute others-mode="attrib"
>Make sure that this is the case!
>
> But I reckon that you really wanted to write
>
> 
>
>
>   
>   start_date
>   
>   
>
> 
>
> or the like.
>
> BTW if you were using a recent snapshot (of either branch), then you
> might not need to convert a string to a date if it is a valid SQL date
> representation.
>
>   Chris.
> --
> C h r i s t i a n   H a u l
> [EMAIL PROTECTED]
> fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: MySQL date conversion with modular database action

[Christian Haul]

On 15.Feb.2003 -- 01:44 AM, Andre Taube wrote:
> Any pointers on how to convert a date before it's inserted into MySQL
> database while using cocoon's Modular Database Action?
> 
> I tried
> 
> 
>
>parameter="org.apache.cocoon.components.modules.input.DateMetaInputModule:start_date[0]"
> 
>   type="attrib"/>
> 
> 
> It seems this "mode" parameter is being ignored.

Hi. You don't include all involved configuration lines so let's
analyse only the above mode element:

@name -> use the input module known as "attribute". This used to be
 the one operating on request attributes. This has been
 renamed to "request-attr" for default configurations.
 Make sure there is an input modules with short-hand
 "attribute"!

@parameter -> interpretation depends on the input module used. Not all
 modules accept this parameter. For the request attribute
 module, this is the name of the request attribute to use
 instead of the one actually passed to the getAttribute()
 method. The default name generated by the database actions is
 "table.column"
 Make sure that this attribute exists and contains a
 compatible value!

@type -> By placing XML-attributes "others-mode" or
 "autoincrement-mode" to the  elements inside the
  elements, different modes can be selected. This
 mode is only used when the table in the table-set has the
 XML-attribute others-mode="attrib"
 Make sure that this is the case!

But I reckon that you really wanted to write


   
   
  
  start_date
  
  
   


or the like.

BTW if you were using a recent snapshot (of either branch), then you
might not need to convert a string to a date if it is a valid SQL date
representation. 

Chris.
-- 
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

MySQL date conversion with modular database action

[Andre Taube]

Any pointers on how to convert 
a date before it's inserted into MySQL database while using cocoon's Modular 
Database Action?
 
I tried
 

    
It seems this "mode" parameter 
is being ignored.
 
Any 
suggestions?
 
Thank you!
 

Re: Cocoon and MySQL

[Martin Holz]

"Richard Cunliffe" <[EMAIL PROTECTED]> writes:

> Martin,
> 
> I have made your suggested changes and the web page still comes up
> completely blank. Is there anything else I should be looking at?

Lower log level and look into the logs :-(.
Usually SQLTransformer complains about sql errors.
Change serialize type to xml, if yoz disabled 
the XSLTransformer - maybe there is some 
error message hiding.


Martin

-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

AW: Cocoon and MySQL

[Marco Rolappe]

richard,

once again my advice: take a look at the logs (here access.log):

DEBUG   (2003-02-03) 13:18.51:614   [access]
(/cocoon/soundpool/database.html)
HttpProcessor[8080][4]/AbstractEnvironment: Reset context to
file:/C:/tomcat/webapps/cocoon/
WARN(2003-02-03) 13:18.51:614   [access]
(/cocoon/soundpool/database.html) HttpProcessor[8080][4]/CocoonServlet: The
resource was not found
org.apache.cocoon.ResourceNotFoundException: Resource not found
file:/C:/tomcat/webapps/cocoon/soundpool/database.xml:
java.io.FileNotFoundException:
C:\tomcat\webapps\cocoon\soundpool\database.xml (The system cannot find the
path specified)
at
org.apache.cocoon.components.source.FileSource.getInputStream(FileSource.jav
a:145)
at
org.apache.cocoon.components.source.AbstractStreamSource.getInputSource(Abst
ractStreamSource.java:161)
at
org.apache.cocoon.components.source.AbstractStreamSource.toSAX(AbstractStrea
mSource.java:206)
at
org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:143)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:250)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:395)
...


> -Ursprungliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]Im
> Auftrag von Richard Cunliffe
> Gesendet: Montag, 3. Februar 2003 15:29
> An: [EMAIL PROTECTED]
> Betreff: RE: Cocoon and MySQL
>
>
> Martin,
>
> I have made your suggested changes and the web page still comes up
> completely blank. Is there anything else I should be looking at?
>
> Thanks,
>
> Richard.
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 03 February 2003 14:02
> To: [EMAIL PROTECTED]
> Subject: Re: Cocoon and MySQL
>
> Hello Richard,
>
>
> "Richard Cunliffe" <[EMAIL PROTECTED]> writes:
>
> > (logs attached)
> >
> > Hi,
> >
> > I have now got cocoon to start, and I have now put my pipeline in, but
> > the page is coming up blank, when viewed through IE6.
> >
> > My pipeline in the sitemap looks like this:
> >
> >
> > 
> >
> > 
> > 
> > 
> > 
> >  > value="soundpool"/>
> > 
> > 
> Do one step after the other -- disable the transformer
> for testing or use labels.
>
> > 
> > 
> > 
> >
> >
> >
> > I am unsure what should go under name="". I have assumed it's the
> local
> > host name given in mysql?
>
> No, it is the name of the connection as defined in your cocoon.xconf.
> My entry looks like this:
>
>   
>
> 
>   
>   true
>   jdbc:postgresql://bog.fiz-chemie.de/slidestore
>   slide
>   geheim
> 
>
>
> So the parameter to the SQL Transformer is:
>   
>   
>   
> Remember to restart your servlet engine after changes to cocoon.xconf.
>
> >
> > My web.xml looks like so:
> Looks okay.
>
> >
> > My database.xml looks like this:
> >
> >
> > 
> > 
> > soundpool
> > the databse
> > http://apache.org/cocoon/SQL/2.0";>
>
> > localhost/soundpool
> You don't need this line.
>
> > 
> > SELECT generalMusicTitle FROM album
> > 
> > 
> > 
>
>
> --
> Martin HolzFIZ CHEMIE Berlin
> <[EMAIL PROTECTED]>
>
>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>
>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

RE: Cocoon and MySQL

[Richard Cunliffe]

Martin,

I have made your suggested changes and the web page still comes up
completely blank. Is there anything else I should be looking at?

Thanks,

Richard.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: 03 February 2003 14:02
To: [EMAIL PROTECTED]
Subject: Re: Cocoon and MySQL

Hello Richard,


"Richard Cunliffe" <[EMAIL PROTECTED]> writes:

> (logs attached)
> 
> Hi,
> 
> I have now got cocoon to start, and I have now put my pipeline in, but
> the page is coming up blank, when viewed through IE6.
> 
> My pipeline in the sitemap looks like this:
> 
> 
> 
> 
> 
> 
>   
>   
>value="soundpool"/>
>   
>   
Do one step after the other -- disable the transformer
for testing or use labels.

>   
> 
> 
> 
> 
> 
> I am unsure what should go under name="". I have assumed it's the
local
> host name given in mysql?

No, it is the name of the connection as defined in your cocoon.xconf.
My entry looks like this:

  
   
 
  
  true
  jdbc:postgresql://bog.fiz-chemie.de/slidestore
  slide
  geheim

   

So the parameter to the SQL Transformer is:
  
  
  
Remember to restart your servlet engine after changes to cocoon.xconf.

> 
> My web.xml looks like so:
Looks okay.

> 
> My database.xml looks like this:
> 
> 
> 
> 
>   soundpool
>   the databse
>   http://apache.org/cocoon/SQL/2.0";>

> localhost/soundpool
You don't need this line.

>   
>   SELECT generalMusicTitle FROM album
>   
>   
> 


--
Martin HolzFIZ CHEMIE Berlin
<[EMAIL PROTECTED]>  



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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




-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: Cocoon and MySQL

[Martin Holz]

Hello Richard,


"Richard Cunliffe" <[EMAIL PROTECTED]> writes:

> (logs attached)
> 
> Hi,
> 
> I have now got cocoon to start, and I have now put my pipeline in, but
> the page is coming up blank, when viewed through IE6.
> 
> My pipeline in the sitemap looks like this:
> 
> 
> 
> 
> 
> 
>   
>   
>value="soundpool"/>
>   
>   
Do one step after the other -- disable the transformer
for testing or use labels.

>   
> 
> 
> 
> 
> 
> I am unsure what should go under name="". I have assumed it's the local
> host name given in mysql?

No, it is the name of the connection as defined in your cocoon.xconf.
My entry looks like this:

  
   
 
  
  true
  jdbc:postgresql://bog.fiz-chemie.de/slidestore
  slide
  geheim

   

So the parameter to the SQL Transformer is:
  
  
  
Remember to restart your servlet engine after changes to cocoon.xconf.

> 
> My web.xml looks like so:
Looks okay.

> 
> My database.xml looks like this:
> 
> 
> 
> 
>   soundpool
>   the databse
>   http://apache.org/cocoon/SQL/2.0";>

> localhost/soundpool
You don't need this line.

>   
>   SELECT generalMusicTitle FROM album
>   
>   
> 


--
Martin HolzFIZ CHEMIE Berlin
<[EMAIL PROTECTED]>  



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

RE: Cocoon and MySQL

[Richard Cunliffe]

(logs attached)

Hi,

I have now got cocoon to start, and I have now put my pipeline in, but
the page is coming up blank, when viewed through IE6.

My pipeline in the sitemap looks like this:

















I am unsure what should go under name="". I have assumed it's the local
host name given in mysql?




My web.xml looks like so:


load-class


com.mysql.jdbc.Driver








My database.xml looks like this:




soundpool
the databse
http://apache.org/cocoon/SQL/2.0";>

localhost/soundpool

SELECT generalMusicTitle FROM album








My databasepc.xsl looks like this:



http://www.w3.org/1999/XSL/Transform";
xmlns:sql="http://apache.org/cocoon/SQL/2.0";>





















I have had a look at the logs and I think that cocoon can not find my
database. I know it does exist under the name of soundpool, and have
double checked this looking in the MySQL Admin, and it is listed under
the database tab. The structure looks like this:

RICHARD (192.168.44.21)
|- mysql
|- soundpool
|- test

Any suggestions,

Thanks,

Richard.





cocoon_logs.zip
Description: Zip compressed data
-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

AW: Cocoon and MySQL

[Marco Rolappe]

hi richard,

first point: don't be afraid to look at the logs yourself ;-) most of the
time they'll reveal what's going wrong. for example in the error.log you
attached:

ERROR   (2003-02-02) 22:45.52:747   [core] (Unknown-URI)
Unknown-thread/Cocoon: Could not configure Cocoon environment
org.xml.sax.SAXParseException: The element type "dburl" must be terminated
by the matching end-tag "".
at
org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(ErrorHand
lerWrapper.java:232)
at
org.apache.xerces.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.ja
va:213)
...

looking at the following:

> The following line I was unsure about:

> jdbc:mysql://192.168.44.21:3306
  ^^^ this one's wrong ;-)

ok, next point:

> I got the localhost address from MySQL Admin - I'm not sure if this is
right? I uncommented these items from the my.ini file.

you can just use 'localhost' (assuming the db is running on the same
machine).

> I am also not sure about .  I have tried researching this
but I'm still unsure.

you can name the datasource as you wish, e.g.:



true
jdbc:mysql://localhost/soundpool 
r_cunliffe 



of course, the data given in this configuration must correspond to your
database configuration. in the dburl you can leave out the port if you're
using the standard.

-Ursprungliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Im Auftrag
von Richard Cunliffe
Gesendet: Sonntag, 2. Februar 2003 23:52
An: [EMAIL PROTECTED]
Betreff: Cocoon and MySQL


(I have attached my cocoon and tomcat logs as Zip files)


Hi,

MS Windows  XP
Apache  2.0.43
Tomcat 4.0.6
Cocoon      2.0.4
JDK   1.3.1_06
MySQL  3.23.55
JDBC 2.0.14


I am trying to connect to a MySQL database and have followed the
instructions provided by Flash Guides and Wiki, but cocoon does not start-up
after I edit the cocoon.xconf. If I comment out the inserted code, and
restart tomcat then cocoon will load.

I have download the JDBC file: mysql-connector-java-2.0.14.jar and have put
it in the following directories:


C:\tomcat\webapps\cocoon\WEB-INF\lib\mysql-connector-java-2.0.14-bin.jar
  C:\tomcat\lib\mysql-connector-java-2.0.14-bin.jar



The relevant part of web.xml looks like this:


 
load-class

  
com.mysql.jdbc.Driver

 org.hsqldb.jdbcDriver









The relevant part of cocoon.xconf looks like so:


  
  

  
  
  
  jdbc:hsqldb:hsql://localhost:9002
  sa
  

  

true
jdbc:mysql://192.168.44.21:3306/soundpool
r_cunliffe

  


  
  



The following line I was unsure about:

jdbc:mysql://192.168.44.21:3306

I got the localhost address from MySQL Admin - I'm not sure if this is
right? I uncommented these items from the my.ini file.

I am also not sure about .  I have tried researching this
but I'm still unsure.



On the Flash Guide it suggested that I should delete the following
directory, which I have done:

C:\tomcat\work\Standalone\localhost\cocoon

But it recreates itself.

What can you suggest? Is there anything on the MySQL side I should be
checking?



Thanks,

Richard.


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Cocoon and MySQL

[Richard Cunliffe]

(I have attached my cocoon and tomcat logs as Zip
files)

 

 

Hi,

 

    MS
Windows  XP

    Apache
 2.0.43

    Tomcat 4.0.6

    Cocoon  2.0.4

    JDK   1.3.1_06

    MySQL  3.23.55

    JDBC 2.0.14

 

 

I am trying to connect to a MySQL database and have
followed the instructions provided by Flash Guides and Wiki, but cocoon does
not start-up after I edit the cocoon.xconf. If I comment out the inserted code,
and restart tomcat then cocoon will load.

 

I have download the JDBC file: mysql-connector-java-2.0.14.jar
and have put it in the following directories:

 

  C:\tomcat\webapps\cocoon\WEB-INF\lib\mysql-connector-java-2.0.14-bin.jar

  C:\tomcat\lib\mysql-connector-java-2.0.14-bin.jar

 

 

 

The relevant part of web.xml looks like this:

 

 

 

    load-class

    

  

    com.mysql.jdbc.Driver

    

   
 org.hsqldb.jdbcDriver

 

   


    

    

 

 

 

 

 

The relevant part of cocoon.xconf looks like so:

 

 

  

  

    

 


 


 


 
jdbc:hsqldb:hsql://localhost:9002

 
sa

 


    

  

    

    true

    jdbc:mysql://192.168.44.21:3306/soundpool

    r_cunliffe

    

  

 

 

  

  

 

 

 

The following line I was unsure about:

 

jdbc:mysql://192.168.44.21:3306

 

I got the localhost address from MySQL Admin –
I’m not sure if this is right? I uncommented these items from the my.ini file.

 

I am also not sure about . 
I have tried researching this but I’m still unsure.

 

 

 

On the Flash Guide it suggested that I should delete
the following directory, which I have done:

 

C:\tomcat\work\Standalone\localhost\cocoon

 

But it recreates itself.

 

What can you suggest? Is there anything on the MySQL
side I should be checking?

 

 

 

Thanks,

 

Richard.

 

 

 








cocoon_logs.zip
Description: Zip compressed data


tomcat_logs.zip
Description: Zip compressed data
-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: processing certain xml ,xsl file with xsp under cocoon and mysql?

[Konstantin Piroumian]

You can use something like this:
   ...
   
  ...

and a pipeline:


   
  


You can also implement cache validity policy in your generator to check if
the XSLT has changed since last request and if not then use the cached
version without need to retrieve it from the DB.

Konstantin

From: "Hubert Holtz" <[EMAIL PROTECTED]>

Hello,

I don't know know how to open new XML files with a certain XSL file with
the help of XSP and my Mysql database in Cocoon.

I have a table called sites with an column for id,lang,XML,XSL, in my xsp-
file I have a string-array called parameters where the 2 parameters of
the typed url (e.g. http://blablabla.com/main.xsp?id=220&lang=eng ) are
saved.
Depending on these two parameters I want to process the certain XML file
with the XSL file which are in my database(as a link of course).

Any idea how to manage this?

I can output the values of the parameters, that's not the problem, but how
do I say Cocoon that it has to process these two files from my database?

Any suggestions or examples or links are welcome.


Thanks.
Homer30


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

processing certain xml ,xsl file with xsp under cocoon and mysql?

[Hubert Holtz]

Hello,

I don't know know how to open new XML files with a certain XSL file with
the help of XSP and my Mysql database in Cocoon.

I have a table called sites with an column for id,lang,XML,XSL, in my xsp-
file I have a string-array called parameters where the 2 parameters of
the typed url (e.g. http://blablabla.com/main.xsp?id=220&lang=eng ) are
saved.
Depending on these two parameters I want to process the certain XML file
with the XSL file which are in my database(as a link of course).

Any idea how to manage this?

I can output the values of the parameters, that's not the problem, but how
do I say Cocoon that it has to process these two files from my database?

Any suggestions or examples or links are welcome.


Thanks.
Homer30


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

processing certain xml ,xsl file with xsp under cocoon and mysql?

[Hubert Holtz]

Hello,

I don't know know how to open new XML files with a certain XSL file with 
the help of XSP and my Mysql database in Cocoon.

I have a table called sites with an column for id,lang,XML,XSL, in my xsp-
file I have a string-array called parameters where the 2 parameters of
the typed url (e.g. http://blablabla.com/main.xsp?id=220&lang=eng ) are 
saved.
Depending on these two parameters I want to process the certain XML file 
with the XSL file which are in my database(as a link of course).

Any idea how to manage this?

I can output the values of the parameters, that's not the problem, but how 
do I say Cocoon that it has to process these two files from my database?

Any suggestions or examples or links are welcome.


Thanks.
Homer30

MYSQL, ESQL and character encoding

[[EMAIL PROTECTED]]

I'm using ESQL to read and write data from a MYSQL database.
Everything works fine, except for one thing.

When I look at the data stored in my database, I see very strange 
characters instead of the ones I expected.
For example, when I fill a field of the db with the string "òàù", this 
is written like "=a?", even if when I red it with ESQL I get back the 
right string.

I think there's something wrong in my cocoon character encondings 
configuration, in fact if I manually try from mysql prompt:
"INSERT INTO table VALUES ('òàù')", the data is properly stored.
 
MYSQL use the default ISO-8859-1 encoding.
I've not changed the default cocoon encodings, except for:
 

  ISO-8859-1
  1024

 
Any suggestion?



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: unable to connect to firebird/mysql using esql

[Gal Nitzan]

Hi,

Following is code excerpt from my own tests and it actually works with
mysql. I will give u the whole story :-) , hope it will help.

---
In web.xml:


  load-class
  
com.mysql.jdbc.Driver
  

end web.xml part



in cocoon.xconf
  
  



true
jdbc:mysql://192.168.1.1/mag
username
password


  
end cocoon.xconf part




in my xsp page

http://apache.org/xsp";
  xmlns:xsp-request="http://apache.org/xsp/request/2.0";
  xmlns:esql="http://apache.org/cocoon/SQL/v2";>



title



  

if ( request.getParameter("doing_post") != null ) {
  
  gedcom
   

insert into employees (first_name, last_name, address, 
city,zip,
home_phone, cell_phone, office_ext, date_started, title, office_id,
remarks, email )values (
(request.getParameter("first_name")),

(request.getParameter("last_name")),

(request.getParameter("address")),

(request.getParameter("city")),

(request.getParameter("zip")),

(request.getParameter("home_phone")),

(request.getParameter("cell_phone")),

(request.getParameter("office_ext")),

(request.getParameter("date_started")),

(request.getParameter("title")),

(request.getParameter("office_id")),

(request.getParameter("remarks")),

(request.getParameter("email")))

An error occurred

   Sorry, no results!

  
  
  
 OK
 
+++
  
} else {

add employee








date started

last name

first name



zip

city

address




office ext

cell phone

home phone




job title

office_id

email




















};
  








end xsp page


Regards,

Gal Nitzan



On Sat, 2002-12-07 at 21:08, Nils Le?mann wrote:
> hi folks,
> 
> i'm totally stuck trying to connect cocoon (2.0.3) to firebird.
> 
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): 
> 
> java.lang.RuntimeException: Could not get the datasource 
> 
> org.apache.avalon.excalibur.datasource.NoValidConnectionException: 
> No valid JdbcConnection class available
> 
> * i'm loading the driver in web.xml, works:
> 
> DEBUG   (2002-12-07) 19:43.13:516   [access] (Unknown-URI)
> Unknown-thread/CocoonServlet: Trying to load class:
> org.firebirdsql.jdbc.FBDriver
> 
> * i set up the connection pool in cocoon.xconf:
> 
> 
>   
>  
> jdbc:firebirdsql:localhost/3050:H:\\interbase\\firebird
>   sysdba
>   masterkey
> 
> 
> using the very same settings in a small java programm works.
> 
> * i am using the following xsp:
> 
>   
> mysql
> 
>   select * from test
>   
> 
>   
> 
>   
> 
>   
> 
> 
> after having no success for more than a week i tried mysql and get the
> same results - jdbc driver works in "normal" java enviroment, but i get
> this "no jdbcConnection" message.
> 
> can anyone help me?
> 
> thank you,
>   nils
> 
> 
> -
>

unable to connect to firebird/mysql using esql

[Nils Le?mann]

hi folks,

i'm totally stuck trying to connect cocoon (2.0.3) to firebird.

org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): 

java.lang.RuntimeException: Could not get the datasource 

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

* i'm loading the driver in web.xml, works:

DEBUG   (2002-12-07) 19:43.13:516   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class:
org.firebirdsql.jdbc.FBDriver

* i set up the connection pool in cocoon.xconf:


  
 
jdbc:firebirdsql:localhost/3050:H:\\interbase\\firebird
  sysdba
  masterkey


using the very same settings in a small java programm works.

* i am using the following xsp:

  
    mysql

  select * from test
  

  

  

  


after having no success for more than a week i tried mysql and get the
same results - jdbc driver works in "normal" java enviroment, but i get
this "no jdbcConnection" message.

can anyone help me?

thank you,
  nils


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections

[Thor Heinrichs-Wolpert]

Torque has some issues surrounding LOBs in Oracle, which have no  
suitable work around for now (not eve a nifty bypass).  Thanks for the  
OJB url!

Thor HW

On Friday, December 6, 2002, at 02:53  AM, Nicola Ken Barozzi wrote:



Antonio Gallardo wrote:

Hi,
I already saw your post on the wiki. :-D
The proposal is nice. Maybe we can make some changes to integrate  
Torque
into Cocoon.
I will start to learn about Torque.
Thanks for your comments.

Look at OJB http://jakarta.apache.org/ojb/index.html

It's deemed to be better than torque by some Turbine developers, and  
has an Avalon component for it (ask on that dev list for it).

Antonio Gallardo.
Alex McLintock dijo:

At 22:42 04/12/02, Gabriele Domenichini wrote:


Are you wondering how to connect Cocoon to your database and you  
have
got  one of theese?:

  * As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
  * BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
* Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
  * PostgreSQL
<http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL> * MsSQL
<http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
  * MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>


Then go to
 
http://outerthought.net/wiki/ 
Wiki.jsp?page=SpecificDatabaseConnection

Thanks to the tribute from people who had your same problem, you can
now  follow instructions on:


Or better still, why not try using Apache Torque which is part of the
Apache Turbine project, and get database independance.
Has anyone tried that yet?

Alex McLintock





--
Nicola Ken Barozzi   [EMAIL PROTECTED]
- verba volant, scripta manent -
   (discussions get forgotten, just code remains)
-


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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





-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections

[Nicola Ken Barozzi]

Antonio Gallardo wrote:

Hi,

I already saw your post on the wiki. :-D

The proposal is nice. Maybe we can make some changes to integrate Torque
into Cocoon.

I will start to learn about Torque.

Thanks for your comments.


Look at OJB http://jakarta.apache.org/ojb/index.html

It's deemed to be better than torque by some Turbine developers, and has 
an Avalon component for it (ask on that dev list for it).

Antonio Gallardo.

Alex McLintock dijo:


At 22:42 04/12/02, Gabriele Domenichini wrote:


Are you wondering how to connect Cocoon to your database and you have
got  one of theese?:

  * As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
  * BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
* Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
  * PostgreSQL
<http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL> * MsSQL
<http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
  * MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>


Then go to
http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection

Thanks to the tribute from people who had your same problem, you can
now  follow instructions on:



Or better still, why not try using Apache Torque which is part of the
Apache Turbine project, and get database independance.
Has anyone tried that yet?

Alex McLintock





--
Nicola Ken Barozzi   [EMAIL PROTECTED]
- verba volant, scripta manent -
   (discussions get forgotten, just code remains)
-


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections

[Antonio Gallardo]

Hi,

I already saw your post on the wiki. :-D

The proposal is nice. Maybe we can make some changes to integrate Torque
into Cocoon.

I will start to learn about Torque.

Thanks for your comments.

Antonio Gallardo.

Alex McLintock dijo:
> At 22:42 04/12/02, Gabriele Domenichini wrote:
>>Are you wondering how to connect Cocoon to your database and you have
>> got  one of theese?:
>>
>>* As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
>>* BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
>> * Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
>>* PostgreSQL
>> <http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL> * MsSQL
>> <http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
>>* MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>
>>
>>
>>  Then go to
>>  http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection
>>
>>Thanks to the tribute from people who had your same problem, you can
>> now  follow instructions on:
>
>
> Or better still, why not try using Apache Torque which is part of the
> Apache Turbine project, and get database independance.
> Has anyone tried that yet?
>
> Alex McLintock
>
>
>
>
> Openweb Analysts Ltd, London.
> Software For Complex Websites http://www.OWAL.co.uk/
> Open Source Software Companies please register here
> http://www.OWAL.co.uk/oss_support/
>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>




-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections

[Alex McLintock]

At 22:42 04/12/02, Gabriele Domenichini wrote:

Are you wondering how to connect Cocoon to your database and you have got 
one of theese?:

   * As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
   * BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
   * Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
   * PostgreSQL <http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL>
   * MsSQL <http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
   * MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>


 Then go to
 http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection

Thanks to the tribute from people who had your same problem, you can now 
follow instructions on:


Or better still, why not try using Apache Torque which is part of the 
Apache Turbine project, and get database independance.
Has anyone tried that yet?

Alex McLintock




Openweb Analysts Ltd, London.
Software For Complex Websites http://www.OWAL.co.uk/
Open Source Software Companies please register here 
http://www.OWAL.co.uk/oss_support/


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections

[Gabriele Domenichini]

Are you wondering how to connect Cocoon to your database and you have 
got one of theese?:

   * As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
   * BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
   * Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
   * PostgreSQL <http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL>
   * MsSQL <http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
   * MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>


 Then go to
 http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection

Thanks to the tribute from people who had your same problem, you can now 
follow instructions on:
- Where to find the right drivers
- Which class to load for connection
- Tips and tricks specific of each database.
Please go there and contribute using the page and writing into it.
Now we can improve the mini-site:
- Restructuring it using the official documentation for the parts that 
are common to all the DBs and Cocoon specific
- Going deeply describing success cases with complicated query or stored 
procedures
- Enlargeing the number of DBs.
- Asking  for inserting the best part of the initiative in the official 
Covcoon documentation

Please support


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: mod-db action yields 'CALL IDENTITY()' MySQL syntax error

[Samuel Bruce]

Thanks very much. It worked like a charm.

This configuration wasn't apparent to me from reading
the documentation. Thanks for making it clear. 

--- Christian Haul
<[EMAIL PROTECTED]> wrote:
> On 24.Oct.2002 -- 09:38 PM, Samuel Bruce wrote:
> > Hello,
> > 
> > I'm using the latest CVS, TC 4.1.12, JDK 1.4.01.
> > 
> > The mod-db action inserts the first row correctly,
> but
> > fails on the second row insert. It seems to also
> fail
> > attempting to rollback.
> > 
> > Anything you can do to help is appreciated.
> 
> > Thread-10/DatabaseAction: Rolling back
> transaction.
> > Caused by Syntax error or access violation: You
> have
> > an error in your SQL syntax near 'CALL IDENTITY()'
> at
> > line 1
> > DEBUG   (2002-10-24) 23:56.37:520  
> > [sitemap.action.mod-db-add] ()
> > Thread-10/DatabaseAction: There was an error
> rolling
> > back the transaction
> > java.sql.SQLException: General error: Warning: 
> Some
> > non-transactional changed tables couldn't be
> rolled
> > back
> > at
> 
> >
>
org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> > at
> 
> So, you are trying to use the autoincrement module
> for HSQLDB with
> MySQL. That just won't work. Please use the MySQL
> one. For this, you
> need to edit the cocoon.xconf and uncomment the
> correct module and
> comment out the hsqldb one. mod-db uses the one with
> shorthand "auto"
> unless instructed otherwise.
> 
>   Chris.
> -- 
> C h r i s t i a n   H a u l
> [EMAIL PROTECTED]
> fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9
> 6856 335A 9E08
> 
> 
>
-
> Please check that your question  has not already
> been answered in the
> FAQ before posting.
> <http://xml.apache.org/cocoon/faq/index.html>
> 
> To unsubscribe, e-mail:
> <[EMAIL PROTECTED]>
> For additional commands, e-mail:  
> <[EMAIL PROTECTED]>
> 


__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: mod-db action yields 'CALL IDENTITY()' MySQL syntax error

[Christian Haul]

On 24.Oct.2002 -- 09:38 PM, Samuel Bruce wrote:
> Hello,
> 
> I'm using the latest CVS, TC 4.1.12, JDK 1.4.01.
> 
> The mod-db action inserts the first row correctly, but
> fails on the second row insert. It seems to also fail
> attempting to rollback.
> 
> Anything you can do to help is appreciated.

> Thread-10/DatabaseAction: Rolling back transaction.
> Caused by Syntax error or access violation: You have
> an error in your SQL syntax near 'CALL IDENTITY()' at
> line 1
> DEBUG   (2002-10-24) 23:56.37:520  
> [sitemap.action.mod-db-add] ()
> Thread-10/DatabaseAction: There was an error rolling
> back the transaction
> java.sql.SQLException: General error: Warning:  Some
> non-transactional changed tables couldn't be rolled
> back
>   at

> org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
>   at

So, you are trying to use the autoincrement module for HSQLDB with
MySQL. That just won't work. Please use the MySQL one. For this, you
need to edit the cocoon.xconf and uncomment the correct module and
comment out the hsqldb one. mod-db uses the one with shorthand "auto"
unless instructed otherwise.

Chris.
-- 
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

mod-db action yields 'CALL IDENTITY()' MySQL syntax error

[Samuel Bruce]

Hello,

I'm using the latest CVS, TC 4.1.12, JDK 1.4.01.

The mod-db action inserts the first row correctly, but
fails on the second row insert. It seems to also fail
attempting to rollback.

Anything you can do to help is appreciated.

Here is a snippet from my sitemap.log:

DEBUG   (2002-10-24) 23:56.37:359  
[sitemap.action.mod-db-add] ()
Thread-10/AbstractComplementaryConfigurableAction:
(Re)Loading context://resources/dbgx.xml
DEBUG   (2002-10-24) 23:56.37:379  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: modeTypes : {2=request-attr,
1=others, 0=autoincr}
DEBUG   (2002-10-24) 23:56.37:379  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: i=0
DEBUG   (2002-10-24) 23:56.37:379  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: requested mode was
"autoincr" returning "autoincr"
DEBUG   (2002-10-24) 23:56.37:379  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: i=1
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: requested mode was "others"
returning "all"
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: i=2
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: requested mode was "others"
returning "all"
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: i=3
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: requested mode was "others"
returning "all"
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: query: INSERT INTO gx (oid,
aid, gid) VALUES (?, ?, ?)
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Trying to set column gx.oid
from request-param using getAttribute method
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Setting column gx.oid [0] 1
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Trying to set column
grpmbrs.abid from request-param using getAttribute
method
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Setting column gx.aid [0] 30
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Trying to set column
grpmbrs.grpid from request-param using
getAttributeValues method
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Setting column gx.gid [0] 1
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Setting column gx.gid [1] 2
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: > row no. 0
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAddAction: Automatically setting key
DEBUG   (2002-10-24) 23:56.37:389  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Setting column gx.oid[0] to
1
DEBUG   (2002-10-24) 23:56.37:409  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Setting column gx.aid[0] to
30
DEBUG   (2002-10-24) 23:56.37:409  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Setting column gx.gxid[0] to
1
DEBUG   (2002-10-24) 23:56.37:509  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: Rolling back transaction.
Caused by Syntax error or access violation: You have
an error in your SQL syntax near 'CALL IDENTITY()' at
line 1
DEBUG   (2002-10-24) 23:56.37:520  
[sitemap.action.mod-db-add] ()
Thread-10/DatabaseAction: There was an error rolling
back the transaction
java.sql.SQLException: General error: Warning:  Some
non-transactional changed tables couldn't be rolled
back
at
org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
at
org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
at
org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
at
org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
at
org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
at
org.gjt.mm.mysql.Connection.rollback(Connection.java:551)
at
org.apache.avalon.excalibur.datasource.Jdbc3Connection.rollback(Jdbc3Connection.java:92)
at
org.apache.cocoon.acting.modular.DatabaseAction.act(DatabaseAction.java:778)
at
org.apache.cocoon.components.treeprocessor.sitemap.ActionSetNode.call(ActionSetNode.java:176)
at
org.apache.cocoon.components.treeprocessor.sitemap.ActSetNode.invoke(ActSetNode.java:111)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:85)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:166)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:109)
at
org.apache.cocoon.components.treeprocessor.sit

Re: XSP, ESQL and MySQL

[Geoff Howard]

Check the logs in WEB-INF/logs to see if your driver
is being loaded.  I'm not sure why, but all current
cocoon documentation does not mention using 
in the cocoon.xconf  declaration.  The
recommended way to make your driver available is to
place it in web.xml under the load-class init-param
like so: 

  load-class
  



org.hsqldb.jdbcDriver
com.mysql.jdbc.Driver

  


I think the latest release of the mysql driver is
still supporting the org.gjt.mm.mysql.Driver but it's
been officially changed to com.mysql.jdbc.Driver now. 


Let me know if that "fixes" it.  Before giving up, you
may want to try stopping tomcat, deleting all of
cocoon's work files (under %CATALINA_HOME%\work) and
then restart tomcat.

Geoff Howard

--- Tom Place <[EMAIL PROTECTED]> wrote:
> Apologies if this is a slightly “lower level”
> problem than normal but I
> think I am going slowly mad.
> 
> I have just started working with cocoon 2 and am
> having some problems
> getting this to connect to mySQL. I have followed
> the tutorials to the
> letter and am getting an
> 
> Exception in ServerPagesGenerator.generate()
> Java.Lang.NullPointerException
> 
> My mySQL database appears to be up and running,
> Cocoon will quite
> happily do it's think with xml, xsl and the basic
> "hello world" xsp
> files. This only occurs when I try and access a db
> with ESQL. 
> 
> (I'm using mySQL 3.23.52, Cocoon 2.03, Tomcat 4.1,
> JDK 1.3.1,
> mySQL-connector-java-2.0.14, all running on win xp)
> 
> My cocoon.xconf contains the following datasources
> entry
> 
> 
>  name="autorevs_store">
>   
>SELECT 1;
>   
>   org.gjt.mm.mysql.Driver
>  
> jdbc:mysql://localhost:3306/autorevs
>   web
>   webpass
> 
> 
> 
> And a fuller stack trace is as follows:
> 
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate():
> java.lang.NullPointerException 
>   at
>
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGe
> nerator.java:212) 
>   at
>
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(Cachi
> ngEventPipeline.java:210) 
>   at
>
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(Cach
> ingStreamPipeline.java:359) 
>   at
>
org.apache.cocoon.www.sitemap_xmap.wildcardMatchN4005A9(sitemap_xmap.jav
> a:9309) 
>   at
>
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:3035)
> 
>   at
>
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2489)
> 
>   at
>
org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
> 
>   at
>
org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
> 
>   at
> org.apache.cocoon.Cocoon.process(Cocoon.java:514) 
>   at
>
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647)
> 
>   at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> 
>   at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:247) 
>   at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:193) 
>   at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:260) 
>   at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643) 
>   at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80) 
>   at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> 
>   at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java:191) 
>   at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643) 
>   at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80) 
>   at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> 
>   at
>
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:239
> 6) 
>   at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :180) 
>   at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643) 
>   at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
> lve.java:170) 
>   at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:641) 
>   at
>
org.apache.catalina.valves.ErrorRep

XSP, ESQL and MySQL

[Tom Place]

Apologies if this is a slightly “lower level” problem than normal but I
think I am going slowly mad.

I have just started working with cocoon 2 and am having some problems
getting this to connect to mySQL. I have followed the tutorials to the
letter and am getting an

Exception in ServerPagesGenerator.generate()
Java.Lang.NullPointerException

My mySQL database appears to be up and running, Cocoon will quite
happily do it's think with xml, xsl and the basic "hello world" xsp
files. This only occurs when I try and access a db with ESQL. 

(I'm using mySQL 3.23.52, Cocoon 2.03, Tomcat 4.1, JDK 1.3.1,
mySQL-connector-java-2.0.14, all running on win xp)

My cocoon.xconf contains the following datasources entry



  
   SELECT 1;
  
  org.gjt.mm.mysql.Driver
  jdbc:mysql://localhost:3306/autorevs
  web
  webpass



And a fuller stack trace is as follows:

org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.NullPointerException 
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGe
nerator.java:212) 
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(Cachi
ngEventPipeline.java:210) 
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(Cach
ingStreamPipeline.java:359) 
at
org.apache.cocoon.www.sitemap_xmap.wildcardMatchN4005A9(sitemap_xmap.jav
a:9309) 
at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:3035) 
at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2489) 
at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) 
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) 
at org.apache.cocoon.Cocoon.process(Cocoon.java:514) 
at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247) 
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193) 
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:260) 
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) 
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) 
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191) 
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) 
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) 
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:239
6) 
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180) 
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) 
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170) 
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641) 
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172) 
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641) 
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) 
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174) 
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643) 
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80) 
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) 
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:40
5) 
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:380) 
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:50
8) 
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:533) 
at java.lang.Thread.run(Thread.java:479)

Any help most appreciated - again apologies if I am being thick!  

Thanks

Tom Place
 



-
Please check that your question  has not alre

RE: mySQL driver ? and performance

[[EMAIL PROTECTED]]

Kounis,

The JDBC driver has been renamed MySQL Connector/J and
can be found at http://www.mysql.com/downloads/api-jdbc.html

The jar file should be placed in the Tomcat/lib directory
if you don't want to fiddle with the classpath.

Conrad

Original Message:
-
From: Cocoon User [EMAIL PROTECTED]
Date: Thu, 26 Sep 2002 10:48:59 +0300 (EEST)
To: [EMAIL PROTECTED]
Subject: mySQL driver ? and performance


1.
where can i find mySQL driver for cocoon ?

2.
i use to get data from mySQL using php
can anyone comment the performance of cocoon retrieving data from mySQL
compiring to php



thnx

Kounis Stavros






-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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




mail2web - Check your email from the web at
http://mail2web.com/ .



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: mySQL driver ? and performance

[Vadim Gritsenko]

Cocoon User wrote:

>1.
>where can i find mySQL driver for cocoon ?
>

JDBC driver for mySQL will do just fine.


>2.
>i use to get data from mySQL using php
>can anyone comment the performance of cocoon retrieving data from mySQL
>compiring to php
>

If no one has comparison on this list, lookup on the web data on 
performance of JDBC driver of mySQL.

Vadim


>thnx
>
>Kounis Stavros
>  
>




-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

mySQL driver ? and performance

[Cocoon User]

1.
where can i find mySQL driver for cocoon ?

2.
i use to get data from mySQL using php
can anyone comment the performance of cocoon retrieving data from mySQL
compiring to php



thnx

Kounis Stavros






-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: mySQL connection pool

[Richard Reyes]

Something like this...

  


  
  jdbc:mysql://localhost/db_xxx
  root
  



  

- Original Message - 
From: "Cocoon User" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 12:41 AM
Subject: mySQL connection pool


> 
> i have an mySQL database: "myDB" with one  table "myTable" running at
> localhost
> 
> can you please give me an example of connection pool syntax for
> cocoon.xconf file ?
> 
> 
> thank
> 
> Kounis Stavros
> 
> 
> 
> 
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
> 
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
> 
> 
> 


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

mySQL connection pool

[Cocoon User]

i have an mySQL database: "myDB" with one  table "myTable" running at
localhost

can you please give me an example of connection pool syntax for
cocoon.xconf file ?


thank

Kounis Stavros




-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: simple connection to MySQL

[Vaskin Kissoyan]

Yes, I've gotten it working fine now, I was plagued by trying to fix 
things in too many places, however, one should note that if you place 
the original zip in the lib directory, there are no errors given, all 
the instructions say to look for an error, the absence of which is 
supposed to indicate that everything is OK.

I guess that's why the guy that wrote it used to put instructs right 
into the filename "unjar-me" Now that its on mysql.com and part of their 
libraries "officially" he's stopped that practice, a shame, but as soon 
as I saw that I had it fixed.

Thanks everyone for the help, I've also proceeded and gotten Cocoon 
talking with Oracle 8.1.7, using the 9iR2 version of the jdbd driver, 
with no issues!

Christopher Watson wrote:
> Vaskin
> 
> I'm guessing (from the class name in your web.xml) you've just downloaded
> the new Connector/J from www.mysql.com ??
> In which case ...
> 
> See my annotations below
> 
> 
>>-Original Message-
>>From: Vaskin Kissoyan [mailto:[EMAIL PROTECTED]]
>>Sent: 06 September 2002 16:22
>>To: [EMAIL PROTECTED]
>>Subject: simple connection to MySQL
>>
>>
>>I've tried to follow the how-to's and tutorials on the net and in the
>>docs. Someone plase let me know what step I'm missing:
>>
>>0)
>>* Built 2.0.3 with all the samples and libs, installed war file under
>>Tomcat 4.04, under JDK 1.4
>>* Built same tables with given sql file in mysql on a default install of
>>3.23.51 on same machine (localhost), database is cocoon
>>
>>
>>1) Dropped the zip file into appropriate place:
>>* tried both as zip and renamed to jar
>>* tried in server\lib and also cocoon\WEB-INF\lib
> 
> 
> The file you need to take out of the zip and put in cocoon\WEB-INF\lib is
> mysql-connector-java-2.0.14-bin.jar
> 
> 
>>2) Added the following to cocoon.xconf inside  under the
>>default built in element 
>> 
>>  
>>  jdbc:mysql://localhost/cocoon
>>  root
>>  
>> 
>>
> 
> Try   jdbc:mysql://localhost:3306/cocoon
> where cocoon is whatever you've called your mysql database
> 3306 is the port number used by mysql, and I don't think the driver defaults
> to use 3306 - you have to tell it
> 
> 
>>4) Added the load-class in cocoon's web.xml as follows
>> 
>>   load-class
>>   
>> 
>>
>> 
>> org.hsqldb.jdbcDriver
>>  com.mysql.jdbc.Driver
> 
> 
> That's right for the new Connector/J
> 
> (The old Mark Matthews JDBC library - from wich Connector/J was derived -
> used a class name org.gjt.mm.mysql.Driver, which is what some other people
> who've replied to you are referring to.)
> 
> 
>> 
>>   
>>     
>>
>>4) Getting the following error:
>>org.apache.cocoon.ProcessingException: Exception in
>>ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not
>>get the datasource java.sql.SQLException: No suitable driver
>>
>>When I try to pull up the ESQL sample
> 
> 
> Have you changed the ESQL sample to use YOUR pool, which, from the above,
> you've called "mypool" ?
> You'll also need to have populated your mysql database, which, from the
> above, you've called cocoon ...
> 
> 
>>Any help would be appreciated.
>>
> 
> 
> I've tried. Hope it works!
> 
> Christopher Watson
> 


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

RE: simple connection to MySQL

[Christopher Watson]

Vaskin

I'm guessing (from the class name in your web.xml) you've just downloaded
the new Connector/J from www.mysql.com ??
In which case ...

See my annotations below

> -Original Message-
> From: Vaskin Kissoyan [mailto:[EMAIL PROTECTED]]
> Sent: 06 September 2002 16:22
> To: [EMAIL PROTECTED]
> Subject: simple connection to MySQL
>
>
> I've tried to follow the how-to's and tutorials on the net and in the
> docs. Someone plase let me know what step I'm missing:
>
> 0)
> * Built 2.0.3 with all the samples and libs, installed war file under
> Tomcat 4.04, under JDK 1.4
> * Built same tables with given sql file in mysql on a default install of
> 3.23.51 on same machine (localhost), database is cocoon
>
>
> 1) Dropped the zip file into appropriate place:
> * tried both as zip and renamed to jar
> * tried in server\lib and also cocoon\WEB-INF\lib

The file you need to take out of the zip and put in cocoon\WEB-INF\lib is
mysql-connector-java-2.0.14-bin.jar

>
> 2) Added the following to cocoon.xconf inside  under the
> default built in element 
>  
>   
>   jdbc:mysql://localhost/cocoon
>   root
>   
>  
>

Try   jdbc:mysql://localhost:3306/cocoon
where cocoon is whatever you've called your mysql database
3306 is the port number used by mysql, and I don't think the driver defaults
to use 3306 - you have to tell it

> 4) Added the load-class in cocoon's web.xml as follows
>  
>load-class
>
>  
>
>  
>  org.hsqldb.jdbcDriver
>   com.mysql.jdbc.Driver

That's right for the new Connector/J

(The old Mark Matthews JDBC library - from wich Connector/J was derived -
used a class name org.gjt.mm.mysql.Driver, which is what some other people
who've replied to you are referring to.)

>
>  
>
>  
>
> 4) Getting the following error:
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not
> get the datasource java.sql.SQLException: No suitable driver
>
> When I try to pull up the ESQL sample

Have you changed the ESQL sample to use YOUR pool, which, from the above,
you've called "mypool" ?
You'll also need to have populated your mysql database, which, from the
above, you've called cocoon ...

>
> Any help would be appreciated.
>

I've tried. Hope it works!

Christopher Watson

>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

RE: simple connection to MySQL

[Christopher Watson]

Vaskin

I'm guessing (from the class name in your web.xml) you've just downloaded
the new Connector/J from www.mysql.com ??
In which case ...

See my annotations below

> -Original Message-
> From: Vaskin Kissoyan [mailto:[EMAIL PROTECTED]]
> Sent: 06 September 2002 16:22
> To: [EMAIL PROTECTED]
> Subject: simple connection to MySQL
>
>
> I've tried to follow the how-to's and tutorials on the net and in the
> docs. Someone plase let me know what step I'm missing:
>
> 0)
> * Built 2.0.3 with all the samples and libs, installed war file under
> Tomcat 4.04, under JDK 1.4
> * Built same tables with given sql file in mysql on a default install of
> 3.23.51 on same machine (localhost), database is cocoon
>
>
> 1) Dropped the zip file into appropriate place:
> * tried both as zip and renamed to jar
> * tried in server\lib and also cocoon\WEB-INF\lib

The file you need to take out of the zip and put in cocoon\WEB-INF\lib is
mysql-connector-java-2.0.14-bin.jar

>
> 2) Added the following to cocoon.xconf inside  under the
> default built in element 
>  
>   
>   jdbc:mysql://localhost/cocoon
>   root
>   
>  
>

Try   jdbc:mysql://localhost:3306/cocoon
where cocoon is whatever you've called your mysql database
3306 is the port number used by mysql, and I don't think the driver defaults
to use 3306 - you have to tell it

> 4) Added the load-class in cocoon's web.xml as follows
>  
>load-class
>
>  
>
>  
>  org.hsqldb.jdbcDriver
>   com.mysql.jdbc.Driver

That's right for the new Connector/J

(The old Mark Matthews JDBC library - from wich Connector/J was derived -
used a class name org.gjt.mm.mysql.Driver, which is what some other people
who've replied to you are referring to.)

>
>  
>
>  
>
> 4) Getting the following error:
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not
> get the datasource java.sql.SQLException: No suitable driver
>
> When I try to pull up the ESQL sample

Have you changed the ESQL sample to use YOUR pool, which, from the above,
you've called "mypool" ?
You'll also need to have populated your mysql database, which, from the
above, you've called cocoon ...

>
> Any help would be appreciated.
>

I've tried. Hope it works!

Christopher Watson

>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: simple connection to MySQL

[Sheraz Khan]

hey dude

u need to place the mysql driver called "mm.mysql-2.0.11-bin.jar" which  
has to then be placed in your applications "WEB-INF/lib/" dir.


Then U have to declare your RDBMS datasource, which u have done, and  
matches with mine..
but i have also added a password.

then...

You need to declare your JDBC driver, for the RDBMS.

this is done in the Load-class  section of the deployment  
discriptor web.xml file
o yeh not that the driver name is not the same as the driver file  
name!

type the following


load-class

org.gjt.mm.mysql.Driver 



hope this helps

got more info at my web site

http://cocoon.sherazkhan.com

take care





On Friday, September 6, 2002, at 06:18 PM, Alan Hodgkinson wrote:

>
> Dear Vaskin
>
>> I've tried to follow the how-to's and tutorials on the net and in the
>> docs.
>
> Yup.. I tried that to and basically, everything went wrong!
>
>> Someone plase let me know what step I'm missing:
>
> There are a few things to check:
>
>> 0)
>> * Built 2.0.3 with all the samples and libs, installed war file under
>> Tomcat 4.04, under JDK 1.4
>> * Built same tables with given sql file in mysql on a default install  
>> of
>> 3.23.51 on same machine (localhost), database is cocoon
>
> Sounds ok.
>
>> 1) Dropped the zip file into appropriate place:
>> * tried both as zip and renamed to jar
>> * tried in server\lib and also cocoon\WEB-INF\lib
>
> Zip of the mysql driver.. sounds suspicious. See check step below.
>
>> 2) Added the following to cocoon.xconf inside  under the
>> default built in element 
>>  
>>   
>>   jdbc:mysql://localhost/cocoon
>>   root
>>   
>>  
>
> You dburl looks suspicious. Mine looked like:
>
>jdbc:mysql://localhost:3306/mydb
>
> Where 3306 is mysql's server port number and 'mydb' is the database
> name.
>
> See below for how to check it.
>
>> 4) Added the load-class in cocoon's web.xml as follows
>>  
>>load-class
>>
>>  
>>
>>  
>>  org.hsqldb.jdbcDriver
>> com.mysql.jdbc.Driver
>>
>>  
>>
>>  
>
> Check the logs to see if the driver even got loaded. The driver
> class name looks suspicious. Mine was:
>
>   org.gjt.mm.mysql.Driver
>
> Look in the logs for 'Could not force-load class' (or just 'mysql').
>
> Did you install the driver jar file in WEB-INF/lib?
>
> I got my driver from:
>
>
> http://prdownloads.sourceforge.net/mmmysql/mm.mysql-2.0.14-you-must- 
> unjar-me.jar
>
> Unjar the file and follow the instructions.
>
>> 4) Getting the following error:
>> org.apache.cocoon.ProcessingException: Exception in
>> ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not
>> get the datasource java.sql.SQLException: No suitable driver
>
> Try to access the database using your dburl and the hsqldb Java GUI.
>
> Try this:
>
>   cd $TOMCATA_HOME/webapps/cocoon
>   java -cp WEB-INF/lib/hsqldb-1.61.jar org.hsqldb.util.DatabaseManager
>
> This starts a GUI based DB management application.
>
> Set the driver type to "HSQL Database Engine Server"
>
> Then set the following:
>
>   Driver:   org.gjt.mm.mysql.Driver
>   URL:  jdbc:mysql://localhost:3306/personnel (or whatever)
>   User: myuser
>   Password: mypassword
>
> If this lets you in, then your URL, user name and password is probably
> ok, and you have to start looking in the cocoon logs.
>
> If this doesn't work then don't waste time with the Coocoon config  
> until
> you can get this step to work. BTW: this is a handy app for looking at
> your DB.
>
> You may also have permissions problems. See: The MySQL documentation:
> Section: '4.2.10 Causes of Access denied Errors'. Basically you may  
> have
> to grant permissions on your database.
>
>> Any help would be appreciated.
>
> Good luck,
>
> Alan Hodgkinson.
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: simple connection to MySQL

[Alan Hodgkinson]

Dear Vaskin 

> I've tried to follow the how-to's and tutorials on the net and in the
> docs. 

Yup.. I tried that to and basically, everything went wrong! 

> Someone plase let me know what step I'm missing:

There are a few things to check:

> 0)
> * Built 2.0.3 with all the samples and libs, installed war file under
> Tomcat 4.04, under JDK 1.4
> * Built same tables with given sql file in mysql on a default install of
> 3.23.51 on same machine (localhost), database is cocoon

Sounds ok.
 
> 1) Dropped the zip file into appropriate place:
> * tried both as zip and renamed to jar
> * tried in server\lib and also cocoon\WEB-INF\lib

Zip of the mysql driver.. sounds suspicious. See check step below.
 
> 2) Added the following to cocoon.xconf inside  under the
> default built in element 
>  
>   
>   jdbc:mysql://localhost/cocoon
>   root
>   
>  

You dburl looks suspicious. Mine looked like:

   jdbc:mysql://localhost:3306/mydb

Where 3306 is mysql's server port number and 'mydb' is the database
name.

See below for how to check it.

> 4) Added the load-class in cocoon's web.xml as follows
>  
>load-class
>
>  
> 
>  
>  org.hsqldb.jdbcDriver
> com.mysql.jdbc.Driver
> 
>  
>
>  

Check the logs to see if the driver even got loaded. The driver
class name looks suspicious. Mine was:

  org.gjt.mm.mysql.Driver

Look in the logs for 'Could not force-load class' (or just 'mysql').

Did you install the driver jar file in WEB-INF/lib?

I got my driver from: 

 
http://prdownloads.sourceforge.net/mmmysql/mm.mysql-2.0.14-you-must-unjar-me.jar

Unjar the file and follow the instructions.

> 4) Getting the following error:
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not
> get the datasource java.sql.SQLException: No suitable driver

Try to access the database using your dburl and the hsqldb Java GUI. 

Try this:

  cd $TOMCATA_HOME/webapps/cocoon
  java -cp WEB-INF/lib/hsqldb-1.61.jar org.hsqldb.util.DatabaseManager

This starts a GUI based DB management application.

Set the driver type to "HSQL Database Engine Server"

Then set the following:

  Driver:   org.gjt.mm.mysql.Driver
  URL:  jdbc:mysql://localhost:3306/personnel (or whatever)
  User: myuser
  Password: mypassword

If this lets you in, then your URL, user name and password is probably 
ok, and you have to start looking in the cocoon logs.

If this doesn't work then don't waste time with the Coocoon config until 
you can get this step to work. BTW: this is a handy app for looking at
your DB.

You may also have permissions problems. See: The MySQL documentation: 
Section: '4.2.10 Causes of Access denied Errors'. Basically you may have
to grant permissions on your database.

> Any help would be appreciated.

Good luck,

Alan Hodgkinson.

-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

simple connection to MySQL

[Vaskin Kissoyan]

I've tried to follow the how-to's and tutorials on the net and in the 
docs. Someone plase let me know what step I'm missing:

0)
* Built 2.0.3 with all the samples and libs, installed war file under 
Tomcat 4.04, under JDK 1.4
* Built same tables with given sql file in mysql on a default install of 
3.23.51 on same machine (localhost), database is cocoon


1) Dropped the zip file into appropriate place:
* tried both as zip and renamed to jar
* tried in server\lib and also cocoon\WEB-INF\lib

2) Added the following to cocoon.xconf inside  under the 
default built in element 
 
  
  jdbc:mysql://localhost/cocoon
  root
  
 

4) Added the load-class in cocoon's web.xml as follows
 
   load-class
   
 

 
 org.hsqldb.jdbcDriver
com.mysql.jdbc.Driver

 
   
 

4) Getting the following error:
org.apache.cocoon.ProcessingException: Exception in 
ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not 
get the datasource java.sql.SQLException: No suitable driver

When I try to pull up the ESQL sample

Any help would be appreciated.



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: could not add record/mysql

[Wolle]

hi!

*Make sure you change the pool name not just in cocoon.xconf but anywhere 
*you actually use the pool, like create-empl.xsp.

this was already done.

 Then bounce your 
*servlet container so Cocoon will reread cocoon.xconf. 

what does that mean? i suggest restarting tomcat.

If you do those 
*things and still have problems, stop Tomcat, delete the work directory 
*for the cocoon webapp, and then restart it.

i tried. after a few hours i finally found the solution. i forgot to
modify the
following line in the sitemap:



after changing everything worked fine.


Thanks a lot for the help!

wolfgang
*
*Regards,
*
*Lajos
*
*
*Wolfgang Weigel wrote:
*
*> hi!
*> 
*> i tried to change the example from
*> http://localhost:8080/cocoon/tutorial/home.html by using a mysql-database.
*> everything works fine if using the name "personnel" for the
*> database-connection in the cocoon.xconf ( logger="core.datasources.mysql" name="personnel">)
*> 
*> as soon as i modify the name-parameter (e.g. mysql) i get the following
*> exception:
*> 
*> Message
*> 
*> Could not add record
*> 
*> 
*> Source
*> 
*> org.apache.cocoon.ProcessingException
*> 
*> 
*> Description
*> 
*> org.apache.cocoon.ProcessingException: Could not add record:
*> org.apache.avalon.framework.component.ComponentException: datasources:
*> ComponentSelector could not find the component for hint: personnel
*> 
*> 
*> Does anybody have a solution?
*> 
*> 
*> bye
*> 
*> wolfgang
*> 
*> 
*> 
*> -
*> Please check that your question  has not already been answered in the
*> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
*> 
*> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
*> For additional commands, e-mail:   <[EMAIL PROTECTED]>
*> 
*> 
*
*
*-- 
*galatea.com
*Cocoon training, consulting & support
*
*
*
*-
*Please check that your question  has not already been answered in the
*FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
*
*To unsubscribe, e-mail: <[EMAIL PROTECTED]>
*For additional commands, e-mail:   <[EMAIL PROTECTED]>
*

Auf bald

Wolfgang Weigel
_
Wolfgang Weigel
Universitaet Wuerzburg
Didaktik Mathematik
Am Hubland
97074 Wuerzburg

[EMAIL PROTECTED]
office: 0931/888-5078
 _  __ __ __
| | /| / /__  / / /__   __    / /  ___ ___   / / / /
| |/ |/ / _ \/ / / -_) | |/|/ / _ `(_-<  / _ \/ -_) __/ -_) /_/_/_/
|__/|__/\___/_/_/\__/  |__,__/\_,_/___/ /_//_/\__/_/  \__/ (_|_|_) 

-


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: could not add record/mysql

[Lajos Moczar]

Wolfgang -

Make sure you change the pool name not just in cocoon.xconf but anywhere 
you actually use the pool, like create-empl.xsp. Then bounce your 
servlet container so Cocoon will reread cocoon.xconf. If you do those 
things and still have problems, stop Tomcat, delete the work directory 
for the cocoon webapp, and then restart it.

Regards,

Lajos


Wolfgang Weigel wrote:

> hi!
> 
> i tried to change the example from
> http://localhost:8080/cocoon/tutorial/home.html by using a mysql-database.
> everything works fine if using the name "personnel" for the
> database-connection in the cocoon.xconf ( logger="core.datasources.mysql" name="personnel">)
> 
> as soon as i modify the name-parameter (e.g. mysql) i get the following
> exception:
> 
> Message
> 
> Could not add record
> 
> 
> Source
> 
> org.apache.cocoon.ProcessingException
> 
> 
> Description
> 
> org.apache.cocoon.ProcessingException: Could not add record:
> org.apache.avalon.framework.component.ComponentException: datasources:
> ComponentSelector could not find the component for hint: personnel
> 
> 
> Does anybody have a solution?
> 
> 
> bye
> 
> wolfgang
> 
> 
> 
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
> 
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
> 
> 


-- 
galatea.com
Cocoon training, consulting & support



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

could not add record/mysql

[Wolfgang Weigel]

hi!

i tried to change the example from
http://localhost:8080/cocoon/tutorial/home.html by using a mysql-database.
everything works fine if using the name "personnel" for the
database-connection in the cocoon.xconf ()

as soon as i modify the name-parameter (e.g. mysql) i get the following
exception:

Message

Could not add record


Source

org.apache.cocoon.ProcessingException


Description

org.apache.cocoon.ProcessingException: Could not add record:
org.apache.avalon.framework.component.ComponentException: datasources:
ComponentSelector could not find the component for hint: personnel


Does anybody have a solution?


bye

wolfgang



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: Installing mysql JDBC Driver

[Jessica Niewint]

At 12.02 29/08/2002 +0100, you wrote:
You were so right !
It was the jar file. Somehow it was damaged or because I copied it from my 
server to my windows desktop ... now I have done every step with unix and 
everything is fine.
So now I got :
jdk 1.4.0
tomcat 4.0.4
cocoon 2.0.3
and the mysql-connector 3.0.0

in my web.xml file I got :

load-class



org.hsqldb.jdbcDriver
com.mysql.jdbc.Driver




for the cocoon.conf:



jdbc:mysql://localhost/test
root



No error message or exception in the log files.
No I have to test everything with a short applications.

Thanks again ! You are so great folks !!! :-D




>Hi Jessica,
>
>Looks OK and you should be able to run the hsqldb driver as well.  I have 
>had no problems with mySQL on 2.0.3 and JDK 1.4 so you could try 
>that.  You could also comment out all the other driver references and the 
>other pools to check there are no conflicts.  I'm not sure that any of 
>this is strictly necessary however.  From the log messages it seems that 
>the classloader is attempting to find the class but cannot.  This would 
>typically be because the package name is incorrect or the class is not 
>there.  The package name for that version of the JAR should be fine.  Have 
>you opened the jar in something like WINRAR or WINZIP?  If not do so to 
>check the file is not corrupt or otherwise wrong.  You should be able to 
>navigate the folder org/gjt/mm/mysql where Driver.class should exist.
>
>HTH a little more.
>
>Jez


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

RE: Installing mysql JDBC Driver

[Gustav Lidén]

Hi,
 
I've 
been following this thread as I am sitting with the exact same problem. However 
I think I just got a bit further by unzipping the jar and putting it in the 
WEB-INF/classes directory. Thanks Jeremy! Tomcat now starts without 
trouble, but I get a Cocoon error page when requesting any html page (also ones 
that don't use mysql as a data source).
 
My 
cocoon.xconf contains:
 
        
    
jdbc:mysql://localhost/web    
guslid    
guslid 

And 
the following works command-line-wise: mysql -uguslid -pguslid 
web
 - so it shouldn't be a privilege 
thing?
 
The 
call stack is below, otherwise I can't see to much useful info in the 
logs.
 
Anyone 
see what's wrong?
 
/Gustav
javax.servlet.ServletException: Servlet.init() for servlet Cocoon2 threw exception
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:946)
	at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:655)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
	at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
	at java.lang.Thread.run(Thread.java:536)


root cause java.lang.ClassFormatError: com/mysql/jdbc/Driver (Illegal constant pool type)
	at java.lang.ClassLoader.defineClass0(Native Method)
	at java.lang.ClassLoader.defineClass(ClassLoader.java:502)
	at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
	at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1643)
	at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:937)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1372)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1254)
	at org.apache.cocoon.util.ClassUtils.loadClass(ClassUtils.java:88)
	at org.apache.cocoon.servlet.CocoonServlet.forceLoad(CocoonServlet.java:842)
	at org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java:1219)
	at org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:435)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:918)
	at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:655)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext(Stand

Re: Installing mysql JDBC Driver

[Jeremy Aston]

 Oh yeah,
I forgot you might want to try extracting the jar into WEB-INF classes to see if that makes a difference.  If that works I don't know what it should be able to get the class from classes and not inside the JAR...
jez
  Jeremy Aston <[EMAIL PROTECTED]> wrote: 

Hi Jessica, 
Looks OK and you should be able to run the hsqldb driver as well.  I have had no problems with mySQL on 2.0.3 and JDK 1.4 so you could try that.  You could also comment out all the other driver references and the other pools to check there are no conflicts.  I'm not sure that any of this is strictly necessary however.  From the log messages it seems that the classloader is attempting to find the class but cannot.  This would typically be because the package name is incorrect or the class is not there.  The package name for that version of the JAR should be fine.  Have you opened the jar in something like WINRAR or WINZIP?  If not do so to check the file is not corrupt or otherwise wrong.  You should be able to navigate the folder org/gjt/mm/mysql where Driver.class should exist.
HTH a little more.
Jez
  Jessica Niewint <[EMAIL PROTECTED]> wrote: 
If there are no config problems then post your web.xml and cocoon.xconf extracts and I'll have a look. the jar should be fine in WEB-INF/lib.I got exactly all this. The only point is that there a still the standard driver in my installation.my web.xmlload-classorg.hsqldb.jdbcDriverorg.gjt.mm.mysql.Drivermy cocoon.xconf:jdbc:hsqldb:hsql://localhost:9002sajdbc:mysql://localhost/testrootCould there be another problem ?At 16.37 28/08/2002 +0100, you wrote:>Hi Jessica,>>You should have something like this in web.xml>> > load-class> > org.gjt.mm.mysql.Driver> > >>and something like this in cocoon.xconf>> > > > jdbc:mysql://127.0.0.1/databasename> root> > > >>If there are no config problems then post your web.xml and cocoon.xconf >extracts and I'll have a look. the jar should be fine in WEB-INF/lib.>>Jez>>>-Please check that your question has not already been answered in theFAQ before posting. To unsubscribe, e-mail: <[EMAIL PROTECTED]>For additional commands, e-mail: <[EMAIL PROTECTED]>



Get a bigger mailbox -- choose a size that fits your needs.Get a bigger mailbox -- choose a size that fits your needs.

Re: Installing mysql JDBC Driver

[Jeremy Aston]

 Hi Jessica,
Looks OK and you should be able to run the hsqldb driver as well.  I have had no problems with mySQL on 2.0.3 and JDK 1.4 so you could try that.  You could also comment out all the other driver references and the other pools to check there are no conflicts.  I'm not sure that any of this is strictly necessary however.  From the log messages it seems that the classloader is attempting to find the class but cannot.  This would typically be because the package name is incorrect or the class is not there.  The package name for that version of the JAR should be fine.  Have you opened the jar in something like WINRAR or WINZIP?  If not do so to check the file is not corrupt or otherwise wrong.  You should be able to navigate the folder org/gjt/mm/mysql where Driver.class should exist.
HTH a little more.
Jez
  Jessica Niewint <[EMAIL PROTECTED]> wrote: 
If there are no config problems then post your web.xml and cocoon.xconf extracts and I'll have a look. the jar should be fine in WEB-INF/lib.I got exactly all this. The only point is that there a still the standard driver in my installation.my web.xmlload-classorg.hsqldb.jdbcDriverorg.gjt.mm.mysql.Drivermy cocoon.xconf:jdbc:hsqldb:hsql://localhost:9002sajdbc:mysql://localhost/testrootCould there be another problem ?At 16.37 28/08/2002 +0100, you wrote:>Hi Jessica,>>You should have something like this in web.xml>> > load-class> > org.gjt.mm.mysql.Driver> > >>and something like this in cocoon.xconf>> > > > jdbc:mysql://127.0.0.1/databasename> root> > > >>If there are no config problems then post your web.xml and cocoon.xconf >extracts and I'll have a look. the jar should be fine in WEB-INF/lib.>>Jez>>>-Please check that your question has not already been answered in theFAQ before posting. To unsubscribe, e-mail: <[EMAIL PROTECTED]>For additional commands, e-mail: <[EMAIL PROTECTED]>Get a bigger mailbox -- choose a size that fits your needs.

RE: Installing mysql JDBC Driver

[Jan Willem Penterman]

Took a closer look on my config, I also have
com.mysql.jdbc.Driver in my xconf mysql part. I'm not
sure if this could make a difference. Back when I was having problems
setting mysql up on a JDK1.3.1 box, someone pointed me to the fact that
I'd better use the latest versions possible of required software. Doing
so actually solved my mysterious driver problems. Maybe it's worth the
effort to try upgrading to JDK1.4...

JW

> -Original Message-
> From: Jessica Niewint [mailto:[EMAIL PROTECTED]] 
> Sent: donderdag 29 augustus 2002 10:12
> To: [EMAIL PROTECTED]
> Subject: Re: Installing mysql JDBC Driver
> 
> 
> 
> If there are no config problems then post your web.xml and 
> cocoon.xconf 
> extracts and I'll have a look.  the jar should be fine in 
> WEB-INF/lib. I got exactly all this. The only point is that 
> there a still the standard 
> driver in my installation.
> 
> my web.xml
>
>load-class
>
>  
> 
>  
>  org.hsqldb.jdbcDriver
> 
>  
>  org.gjt.mm.mysql.Driver
>
>  
> 
> 
> 
> my cocoon.xconf:
> 
>  
>
>
>
>jdbc:hsqldb:hsql://localhost:9002
>sa
>
>  
> 
> 
> 
>
>jdbc:mysql://localhost/test
>root
>
>  
> 
>
> 
> 
>   Could there be another problem ?
> 
> 
> At 16.37 28/08/2002 +0100, you wrote:
> 
> >Hi Jessica,
> >
> >You should have something like this in web.xml
> >
> > 
> >   load-class
> >   
> >   org.gjt.mm.mysql.Driver
> >   
> > 
> >
> >and something like this in cocoon.xconf
> >
> >   
> > 
> >   
> >   jdbc:mysql://127.0.0.1/databasename
> >   root
> >   
> > 
> >   
> >
> >If there are no config problems then post your web.xml and 
> cocoon.xconf
> >extracts and I'll have a look.  the jar should be fine in 
> WEB-INF/lib.
> >
> >Jez
> >
> >
> >
> 
> 
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
> 
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
> 
> 


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: Installing mysql JDBC Driver

[Jessica Niewint]

If there are no config problems then post your web.xml and cocoon.xconf 
extracts and I'll have a look.  the jar should be fine in WEB-INF/lib.
I got exactly all this. The only point is that there a still the standard 
driver in my installation.

my web.xml
   
   load-class
   
 

 
 org.hsqldb.jdbcDriver

 
 org.gjt.mm.mysql.Driver
   
 



my cocoon.xconf:

 
   
   
   
   jdbc:hsqldb:hsql://localhost:9002
   sa
   
 



   
   jdbc:mysql://localhost/test
   root
   
 

   


  Could there be another problem ?


At 16.37 28/08/2002 +0100, you wrote:

>Hi Jessica,
>
>You should have something like this in web.xml
>
> 
>   load-class
>   
>   org.gjt.mm.mysql.Driver
>   
> 
>
>and something like this in cocoon.xconf
>
>   
> 
>   
>   jdbc:mysql://127.0.0.1/databasename
>   root
>   
> 
>   
>
>If there are no config problems then post your web.xml and cocoon.xconf 
>extracts and I'll have a look.  the jar should be fine in WEB-INF/lib.
>
>Jez
>
>
>


-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

RE: Installing mysql JDBC Driver

[Jessica Niewint]

At 18.51 28/08/2002 +0200, you wrote:
>I just dropped it into the lib folder. My setup in web.xml and
>cocoon.xconf are like Jermey Aston desribed in his reply (only
>difference are the classnames for connector/j).

OK I dropped the mysql-connector-java-3.0.0-beta-bin.jar file ( I did not 
rename it) into my cocoon/WEB-INF/lib folder and add the classname 
com.mysql.jdbc.Driver to the web.xml  file. Cocoon starts up, but in the 
access.log I got a java exeption ...

>Try dropping it $CATALINA_HOME/common/lib, that seems to work for some
>setups.
No if a drop the mysql-connector-java-3.0.0-beta-bin.jar file here tomcat 
will not start.

Is there something else that could be wrong ? May be a Java classpath ? The 
configuration of tomcat ( even if all the examples/applications of tomcat 
worked fine) ?
Cocoon (here also no problems with the standard installation and given 
examples ).

May be some conflict with other drivers. P.ex. I got the jdbc interbase 
driver in my classpath ... 


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: Installing mysql JDBC Driver

[Andre Thenot]

You can also put it in $JAVA_HOME/lib/ext (or 
$JAVA_HOME/jre/lib/ext depending on your setup). That way, it's 
accessible  from anywhere on your system which is a 
feature or a bug

On Wednesday, August 28, 2002, at 12:51 , Jan Willem Penterman wrote:

> I just dropped it into the lib folder. My setup in web.xml and
> cocoon.xconf are like Jermey Aston desribed in his reply (only
> difference are the classnames for connector/j).
> Try dropping it $CATALINA_HOME/common/lib, that seems to work for some
> setups.


-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

RE: Installing mysql JDBC Driver

[Jan Willem Penterman]

I just dropped it into the lib folder. My setup in web.xml and
cocoon.xconf are like Jermey Aston desribed in his reply (only
difference are the classnames for connector/j).
Try dropping it $CATALINA_HOME/common/lib, that seems to work for some
setups.

JW

> -Original Message-
> From: Jessica Niewint [mailto:[EMAIL PROTECTED]] 
> Sent: woensdag 28 augustus 2002 18:30
> To: [EMAIL PROTECTED]
> Subject: RE: Installing mysql JDBC Driver
> 
> 
> At 18.02 28/08/2002 +0200, you wrote:
> >Does the driver show up in the Classpath in core.log? (Do a 
> search on 
> >"Classpath =" in core.log and see if the driver is listed 
> over there).
> >
> >I also had a lot of trouble with getting mysql to work. Using JDK1.4 
> >and Connector/J 3.0 beta now (that's the successor to 
> mm.mysql, they're 
> >essentially the same). No problems anymore..
> >
> >JW
> 
> But how did you installed the driver ? With an extra- 
> classpath ? Or did 
> you drop the mysql-connector-java-3.0.0-beta-bin.jar file 
> into the lib 
> folder of cocoon ?
> 
> 
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
> 
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
> 
> 


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

RE: Installing mysql JDBC Driver

[Jessica Niewint]

At 18.02 28/08/2002 +0200, you wrote:
>Does the driver show up in the Classpath in core.log? (Do a search on
>"Classpath =" in core.log and see if the driver is listed over there).
>
>I also had a lot of trouble with getting mysql to work. Using JDK1.4 and
>Connector/J 3.0 beta now (that's the successor to mm.mysql, they're
>essentially the same). No problems anymore..
>
>JW

But how did you installed the driver ? With an extra- classpath ? Or did 
you drop the mysql-connector-java-3.0.0-beta-bin.jar file into the lib 
folder of cocoon ?


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

RE: Installing mysql JDBC Driver

[Jan Willem Penterman]

Does the driver show up in the Classpath in core.log? (Do a search on
"Classpath =" in core.log and see if the driver is listed over there). 

I also had a lot of trouble with getting mysql to work. Using JDK1.4 and
Connector/J 3.0 beta now (that's the successor to mm.mysql, they're
essentially the same). No problems anymore..

JW 

> -Original Message-
> From: Jessica Niewint [mailto:[EMAIL PROTECTED]] 
> Sent: woensdag 28 augustus 2002 16:47
> To: [EMAIL PROTECTED]
> Subject: Installing mysql JDBC Driver
> 
> 
> My configuration:
> tomcat 4.0.4, cocoon 2.0.3, java jdk1.2.2
> 
> In copied the mm.mysql-2.0.4-bin.jar file into the lib folder of 
> cocoon/WEB-INF. I loaded the driver in the web.xml file. When 
> I check now 
> the installation in the access.log file I got the following message:
> DEBUG   (2002-08-28) 16:35.15:025   [access] (Unknown-URI) 
> Unknown-thread/CocoonServlet: Trying to load class: 
> org.gjt.mm.mysql.Driver
> INFO(2002-08-28) 16:35.15:088   [access] (Unknown-URI) 
> Unknown-thread/CocoonServlet: Reloading from: 
> jndi:/localhost/cocoon/WEB-INF/cocoon.xconf
> 
> if I try to configure my connection pool in cocoon.xconf : I got the 
> following exeption:
> 
> DEBUG   (2002-08-09) 17:42.10:231   [access] (Unknown-URI) 
> Unknown-thread/CocoonServlet: Trying to load class: 
> org.gjt.mm.mysql.Driver
> WARN(2002-08-09) 17:42.10:287   [access] (Unknown-URI) 
> Unknown-thread/CocoonServlet: Could not force-load class: 
> org.gjt.mm.mysql.Driver
> java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
>   at 
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappC
> lassLoader.java:1406)
>   at 
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappC
> lassLoader.java:1254)
>   at 
> org.apache.cocoon.util.ClassUtils.loadClass(ClassUtils.java:88)
>   at 
> org.apache.cocoon.servlet.CocoonServlet.forceLoad(CocoonServle
> t.java:842)
>   at 
> org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonSer
> vlet.java:1219)
>   at 
> org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:435)
>   at 
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardW
> rapper.java:918)
>   at 
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.
> java:810)
>   at 
> org.apache.catalina.core.StandardContext.loadOnStartup(Standar
> dContext.java:3279)
>   at 
> org.apache.catalina.core.StandardContext.start(StandardContext
> .java:3421)
>   at 
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.
> java:785)
>   at 
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:478)
>   at 
> org.apache.catalina.core.StandardHost.install(StandardHost.java:738)
>   at 
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:324)
>   at 
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:389)
>   at 
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConf
> ig.java:232)
>   at 
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(L
> ifecycleSupport.java:155)
>   at 
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131)
>   at 
> org.apache.catalina.core.StandardHost.start(StandardHost.java:638)
>   at 
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
>   at 
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
>   at 
> org.apache.catalina.core.StandardService.start(StandardService
> .java:388)
>   at 
> org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
>   at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
>   at 
> org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
>   at 
> org.apache.catalina.startup.Catalina.process(Catalina.java:179)
>   at java.lang.reflect.Method.invoke(Native Method)
>   at 
> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
> INFO(2002-08-09) 17:42.10:432   [access] (Unknown-URI) 
> Unknown-thread/CocoonServlet: Reloading from: 
> jndi:/localhost/cocoon/WEB-INF/cocoon.xconf
> 
> I really have no clue. Why is it impossible to define a 
> connection pool for 
> mysql ? Do I have to change the name of the 
> mm.mysql-2.0.4-bin.jar file ? 
> What can I do to make everything work ?
> Thanks in advance, Jessi
> 
> 
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
> 
> To unsubscribe, e-mail: &l

Re: Installing mysql JDBC Driver

[Jeremy Aston]

 Hi Jessica,
You should have something like this in web.xml
      load-class    org.gjt.mm.mysql.Driver      
and something like this in cocoon.xconf
          jdbc:mysql://127.0.0.1/databasename  root        
If there are no config problems then post your web.xml and cocoon.xconf extracts and I'll have a look.  the jar should be fine in WEB-INF/lib.
Jez
 
 
  Jessica Niewint <[EMAIL PROTECTED]> wrote: 
My configuration:tomcat 4.0.4, cocoon 2.0.3, java jdk1.2.2In copied the mm.mysql-2.0.4-bin.jar file into the lib folder of cocoon/WEB-INF. I loaded the driver in the web.xml file. When I check now the installation in the access.log file I got the following message:DEBUG (2002-08-28) 16:35.15:025 [access] (Unknown-URI) Unknown-thread/CocoonServlet: Trying to load class: org.gjt.mm.mysql.DriverINFO (2002-08-28) 16:35.15:088 [access] (Unknown-URI) Unknown-thread/CocoonServlet: Reloading from: jndi:/localhost/cocoon/WEB-INF/cocoon.xconfif I try to configure my connection pool in cocoon.xconf : I got the following exeption:DEBUG (2002-08-09) 17:42.10:231 [access] (Unknown-URI) Unknown-thread/CocoonServlet: Trying to load class: org.gjt.mm.mysql.DriverWARN (2002-08-09) 17:42.10:287 [access] (Unknown-URI) Unknown-thread/CocoonServlet: Could not force-load class: org.gjt.mm.mysql.Driverjava.lang.ClassNotFoundException: org.gjt.mm.mysql.Driverat org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1406)at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1254)at org.apache.cocoon.util.ClassUtils.loadClass(ClassUtils.java:88)at org.apache.cocoon.servlet.CocoonServlet.forceLoad(CocoonServlet.java:842)at org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java:1219)at org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:435)at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:918)at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:810)at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3279)at org.apache.catalina.core.StandardContext.start(StandardContext.java:3421)at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:785)at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:478)at org.apache.catalina.core.StandardHost.install(StandardHost.java:738)at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:324)at org.apache.catalina.startup.HostConfig.start(HostConfig.java:389)at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:232)at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:155)at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131)at org.apache.catalina.core.StandardHost.start(StandardHost.java:638)at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)at org.apache.catalina.core.StandardService.start(StandardService.java:388)at org.apache.catalina.core.StandardServer.start(StandardServer.java:506)at org.apache.catalina.startup.Catalina.start(Catalina.java:781)at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)at org.apache.catalina.startup.Catalina.process(Catalina.java:179)at java.lang.reflect.Method.invoke(Native Method)at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)INFO (2002-08-09) 17:42.10:432 [access] (Unknown-URI) Unknown-thread/CocoonServlet: Reloading from: jndi:/localhost/cocoon/WEB-INF/cocoon.xconfI really have no clue. Why is it impossible to define a connection pool for mysql ? Do I have to change the name of the mm.mysql-2.0.4-bin.jar file ? What can I do to make everything work ?Thanks in advance, Jessi-Please check that your question has not already been answered in theFAQ before posting. To unsubscribe, e-mail: <[EMAIL PROTECTED]>For additional commands, e-mail: <[EMAIL PROTECTED]>
jez

[EMAIL PROTECTED]
+44 (0)7768 277092
+44 (0)1903 715458
ICQ 67849002
Get a bigger mailbox -- choose a size that fits your needs.http://uk.docs.yahoo.com/mail_storage.html

Installing mysql JDBC Driver

[Jessica Niewint]

My configuration:
tomcat 4.0.4, cocoon 2.0.3, java jdk1.2.2

In copied the mm.mysql-2.0.4-bin.jar file into the lib folder of 
cocoon/WEB-INF. I loaded the driver in the web.xml file. When I check now 
the installation in the access.log file I got the following message:
DEBUG   (2002-08-28) 16:35.15:025   [access] (Unknown-URI) 
Unknown-thread/CocoonServlet: Trying to load class: org.gjt.mm.mysql.Driver
INFO(2002-08-28) 16:35.15:088   [access] (Unknown-URI) 
Unknown-thread/CocoonServlet: Reloading from: 
jndi:/localhost/cocoon/WEB-INF/cocoon.xconf

if I try to configure my connection pool in cocoon.xconf : I got the 
following exeption:

DEBUG   (2002-08-09) 17:42.10:231   [access] (Unknown-URI) 
Unknown-thread/CocoonServlet: Trying to load class: org.gjt.mm.mysql.Driver
WARN(2002-08-09) 17:42.10:287   [access] (Unknown-URI) 
Unknown-thread/CocoonServlet: Could not force-load class: 
org.gjt.mm.mysql.Driver
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at 
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1406)
at 
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1254)
at org.apache.cocoon.util.ClassUtils.loadClass(ClassUtils.java:88)
at org.apache.cocoon.servlet.CocoonServlet.forceLoad(CocoonServlet.java:842)
at 
org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java:1219)
at org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:435)
at 
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:918)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:810)
at 
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3279)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3421)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:785)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:478)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:738)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:324)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:389)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:232)
at 
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:155)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1131)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:638)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
at org.apache.catalina.core.StandardService.start(StandardService.java:388)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
INFO(2002-08-09) 17:42.10:432   [access] (Unknown-URI) 
Unknown-thread/CocoonServlet: Reloading from: 
jndi:/localhost/cocoon/WEB-INF/cocoon.xconf

I really have no clue. Why is it impossible to define a connection pool for 
mysql ? Do I have to change the name of the mm.mysql-2.0.4-bin.jar file ? 
What can I do to make everything work ?
Thanks in advance, Jessi


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: Error "no connections in the pool" with mySQL? [Solved]

[Derek Hohls]

Thanks!

Tried this - and  it worked.

(ie. the names of the classes ARE case-sensitive!)


>>> [EMAIL PROTECTED] 16/08/2002 02:12:20 >>>
-->org.gjt.mm.mySQL.Driver

I define mine as org.gjt.mm.mysql.Driver instead...




__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com 

-
Please check that your question  has not already been answered in the
FAQ before posting. 

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


-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

j2sdk1.3.1_04 also bad for MySQL?

[Jan Willem Penterman]

Still struggling with the problems regarding MySQL...instead of using
ESQL I tried SQLTransformer this time. Gives me the WARNING j2sdk1.4
users have been complaining about:  

WARN(2002-08-17) 18:09.10:463   [core.manager]
(/cocoon/mysqltest/results.xml) 
HttpProcessor[8080][0]/ResourceLimitingJdbcDataSource: Could not return
Connection
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
valid JdbcConnection class available

Does this imply that j2sdk1.3.1_04 is as bad for use with Cocoon2 as
j2sdk1.4?

Second, with ESQL I keep getting "No suitable driver" error. Would the
above WARNING mean that I actually do have a valid driver but my
connection URL is just wrong? Yeah well I'm pretty sure my URL is oke,
since I use the same URL in non-cocoon tomcat servlets... 

JW



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

RE: [repost] MySQL no suitable driver

[Jan Willem Penterman]

I upgraded to the com.mysql.jdbc.Driver, same error. The settings you
described are like I already had. 

> Try jdk1.4.1 and the cvs HEAD of Cocoon.  If your going to be 
> on the edge, then being one or two versions back can be 
> rougher than being where the developers are;  the developers 
> are more likely to address any problems you discover if your 
> working with the cvs HEAD.

I thougtht it was better to user j2sdk1.3 when using database
connections with cocoon2?

JW


> -Original Message-
> From: Roger I Martin PhD [mailto:[EMAIL PROTECTED]] 
> Sent: vrijdag 16 augustus 2002 21:30
> To: [EMAIL PROTECTED]
> Subject: Re: [repost] MySQL no suitable driver
> 
> 
> Look at http://xml.apache.org/cocoon/developing/datasources.html
> 
> It's good if the pool is initialized long before your xsp's need it.
> 
> In your web.xml file. The you need the following snippet with :
> 
> ...
> 
>   load-class
>   
> 
>com.mysql.jdbc.Driver
> 
> 
> postgresql.Driver
> 
> 
> oracle.jdbc.driver.OracleDriver
> 
>   
> 
> ...
> with the MySQL driver added.  Then in your cocoon.xconf you need:
> 
> ...
> 
> 
> com.mysql.jdbc.Driver
>  
> 
> jdbc:mysql://localhost:3306/test
> root
> 5h4p3r5
> 
> 
> ...
> 
> Then in one of your xsp's
> ...
> 
>   MY_POOL
>   
> select * from 
> MY_DATABASE_TABLE
> 
>   
>   
>   
> 
>   
> 
> ...
> 
 



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

RE: [repost] MySQL no suitable driver

[Jan Willem Penterman]

I unjarred the bin jar, then jarred them back together with the -0
option and got jar about twice as big. put it in /WEB-INF/lib and
restarted tomcat. still the same error...

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: vrijdag 16 augustus 2002 19:07
To: [EMAIL PROTECTED]
Subject: Re: [repost] MySQL no suitable driver


I had the exact same problem...

which was solved by uploading an *uncompressed* mysql driver .jar to
WEB-INf/lib (yes yes, it seems like a a lot of voodoo nonsense...)

good luck 



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: [repost] MySQL no suitable driver

[Roger I Martin PhD]

Look at http://xml.apache.org/cocoon/developing/datasources.html

It's good if the pool is initialized long before your xsp's need it.

In your web.xml file. The you need the following snippet with :

...

  load-class
  

   com.mysql.jdbc.Driver


postgresql.Driver


oracle.jdbc.driver.OracleDriver

  

...
with the MySQL driver added.  Then in your cocoon.xconf you need:

...


com.mysql.jdbc.Driver


jdbc:mysql://localhost:3306/test
root
5h4p3r5


...

Then in one of your xsp's
...

  MY_POOL
  
select * from MY_DATABASE_TABLE

  
  
  

  

...

I'm using mysql-connector-java-3.0.0-beta-bin.jar. It does not appear to be
compressed.  I have found that if you want to apply a bleeding edge
technology such as Cocoon it's good if you have the audacity to go all of
the way and use the latest of every part until you get a fairly stable
environment, protect it by backing up and be willing to try the latest again
and again.  If the latest fails then go back to your backup if your at the
stage you have one but try again within a few weeks.  This actually
minimizes your time of looking at what you think your doing wrong but
aren't.

Try jdk1.4.1 and the cvs HEAD of Cocoon.  If your going to be on the edge,
then being one or two versions back can be rougher than being where the
developers are;  the developers are more likely to address any problems you
discover if your working with the cvs HEAD.

--Roger


- Original Message -
From: "Jan Willem Penterman" <[EMAIL PROTECTED]>
To: "'Cocoon'" <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 10:38 AM
Subject: [repost] MySQL no suitable driver


> [repost] still stuck on this [/repost]
>
> I'm quite new to Cocoon but want to set up a MySQL connection using
> ESQL. I followed the directives on
> http://www.cocooncenter.de/cc/documents/resources/db-app/index.html and
> altered the settings for MySQL like I see them everwhere in the mail
> archives. So I have an XSP page generated from a subsitemap of the
> default cocoon app:
>
> 
>  language="java"
> xmlns:xsp="http://apache.org/xsp";
> xmlns:esql="http://apache.org/cocoon/SQL/v2";>
> 
> 
> 
> 
> 
>
> 
>
> org.gjt.mm.mysql.Driver
>
> jdbc:mysql://localhost:3306/test
> root
> 5h4p3r5
>
> ...
>
> 
>
> 
> 
> 
>
> As you can see it doesn't work both pooling and non-pooling. This is the
> error:
>
> error.log:
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
> opening connection to dburl: : No suitable driver
>
> Traces I find of the driver:
>
> access.log:
> DEBUG   (2002-08-15) 02:32.20:253   [access] (Unknown-URI)
> Unknown-thread/CocoonServlet: Trying to load class:
> org.gjt.mm.mysql.Driver
>
> core.log:
> DEBUG   (2002-08-15) 02:54.03:637   [core] (Unknown-URI)
> Unknown-thread/Cocoon: Classpath =
> ;D:\apache-tomcat-4.0.4\webapps\cocoon\WEB-INF\lib\mm.mysql
> -2.0.14-bin.jar;;
>
> I can however make a jdbc:mysql connection with a regular servlet. So
> nothing wrong with that.
>
> My system:
>
> Windows XP
> j2sdk1.3.1_4
> tomcat 4.0.4
> cocoon 2.0.3
> MySQL 3.23.49-nt
> mm.mysql-2.0.14
>
> JW
>
>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: [repost] MySQL no suitable driver

[MTiffany71]

I had the exact same problem...

which was solved by uploading an *uncompressed* mysql driver .jar to WEB-INf/lib (yes yes, it seems like a a lot of voodoo nonsense...)

good luck

[repost] MySQL no suitable driver

[Jan Willem Penterman]

[repost] still stuck on this [/repost]

I'm quite new to Cocoon but want to set up a MySQL connection using
ESQL. I followed the directives on
http://www.cocooncenter.de/cc/documents/resources/db-app/index.html and
altered the settings for MySQL like I see them everwhere in the mail
archives. So I have an XSP page generated from a subsitemap of the
default cocoon app:


http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>








org.gjt.mm.mysql.Driver

jdbc:mysql://localhost:3306/test
root
5h4p3r5

... 







As you can see it doesn't work both pooling and non-pooling. This is the
error:

error.log:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
opening connection to dburl: : No suitable driver

Traces I find of the driver:

access.log:
DEBUG   (2002-08-15) 02:32.20:253   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class:
org.gjt.mm.mysql.Driver

core.log:
DEBUG   (2002-08-15) 02:54.03:637   [core] (Unknown-URI)
Unknown-thread/Cocoon: Classpath =
;D:\apache-tomcat-4.0.4\webapps\cocoon\WEB-INF\lib\mm.mysql
-2.0.14-bin.jar;;

I can however make a jdbc:mysql connection with a regular servlet. So
nothing wrong with that.

My system:

Windows XP
j2sdk1.3.1_4
tomcat 4.0.4
cocoon 2.0.3
MySQL 3.23.49-nt
mm.mysql-2.0.14

JW



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: Error "no connections in the pool" with mySQL?

[Derek Hohls]

Mike

I have the original version 2.0 (I dont think it had any numbers...)
and the machine is running JDK 1.31 - this is vitually the same setup
on the all the machines running here and v. similar to the clients

I agree that if I had JDK 1.4  I would need a Cocoon upgrade.

Derek

>>> [EMAIL PROTECTED] 16/08/2002 02:31:39 >>>
Hi

Which version of Cocoon are you using?
You only mentioned "Cocoon 2.0" which isn t enought.

Cocoon 2.0.2 has a problem with the connection pooling caused by the
JDBC
update in JDK 1.4.0.
I had a similar problem - a update to cocoon 2.0.3 solved my problem.

greetings
mike
- Original Message -
From: "Derek Hohls" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 2:24 PM
Subject: Re: Error "no connections in the pool" with mySQL?


> Thanks for the suggestion - I see it was it was all lowercase
> on my machine too - however, when I changed it to 'mySQL'
> here, and restarted Tomcat, I did not get any errors on my
> machine - in other words, the case doesnt not affect the
> problem happening on the client machine.
>
> so I dont think this is the cause (unfortunately).
>
> >>> [EMAIL PROTECTED] 16/08/2002 02:12:20 >>>
> -->org.gjt.mm.mySQL.Driver
>
> I define mine as org.gjt.mm.mysql.Driver instead...
>
>
>
>
> __
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com 
>
>
-
> Please check that your question  has not already been answered in
the
> FAQ before posting.
<http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail:
<[EMAIL PROTECTED]>
> For additional commands, e-mail:  
<[EMAIL PROTECTED]>
>
>
>
-
> Please check that your question  has not already been answered in
the
> FAQ before posting.
<http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail:
<[EMAIL PROTECTED]>
> For additional commands, e-mail:  
<[EMAIL PROTECTED]>
>
>


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: Error "no connections in the pool" with mySQL?

[Michael Mangeng]

Hi

Which version of Cocoon are you using?
You only mentioned "Cocoon 2.0" which isn´t enought.

Cocoon 2.0.2 has a problem with the connection pooling caused by the JDBC
update in JDK 1.4.0.
I had a similar problem - a update to cocoon 2.0.3 solved my problem.

greetings
mike
- Original Message -
From: "Derek Hohls" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 2:24 PM
Subject: Re: Error "no connections in the pool" with mySQL?


> Thanks for the suggestion - I see it was it was all lowercase
> on my machine too - however, when I changed it to 'mySQL'
> here, and restarted Tomcat, I did not get any errors on my
> machine - in other words, the case doesnt not affect the
> problem happening on the client machine.
>
> so I dont think this is the cause (unfortunately).
>
> >>> [EMAIL PROTECTED] 16/08/2002 02:12:20 >>>
> -->org.gjt.mm.mySQL.Driver
>
> I define mine as org.gjt.mm.mysql.Driver instead...
>
>
>
>
> __
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>
>
>


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: Error "no connections in the pool" with mySQL?

[Derek Hohls]

Thanks for the suggestion - I see it was it was all lowercase
on my machine too - however, when I changed it to 'mySQL'
here, and restarted Tomcat, I did not get any errors on my
machine - in other words, the case doesnt not affect the 
problem happening on the client machine.

so I dont think this is the cause (unfortunately).

>>> [EMAIL PROTECTED] 16/08/2002 02:12:20 >>>
-->org.gjt.mm.mySQL.Driver

I define mine as org.gjt.mm.mysql.Driver instead...




__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com 

-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

Re: Error "no connections in the pool" with mySQL?

[Kenny Chow]

-->org.gjt.mm.mySQL.Driver

I define mine as org.gjt.mm.mysql.Driver instead...




__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

-
Please check that your question  has not already been answered in the
FAQ before posting. 

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

Error "no connections in the pool" with mySQL?

[Derek Hohls]

I have an old problem on a new machine ;-(

The new machine, where I have just done a 'clean' installation
of an app that runs without any problems on my machine (and
on the local Unix box) has the following config:
- Windows2000
- IIS
- Tomcat 4.0.01
- Cocoon 2.0
- mySQL 3.23.xx

Cocoon itself runs fine, as do the test hssql database samples,
as does the non-database part of the app.

The problems arises when I try to connect to the mySQL database
and get a:
org.apache.cocoon.ProcessingException: 
 Exception in ServerPagesGenerator.generate(): 
 java.lang.RuntimeException: 
 Could not get the datasource java.sql.SQLException: 
 There are no connections in the pool, check your settings.

A search through the mail archives shows that this is *usually* a 
problem with the web.xml file.  Here are my various DB-related entries
in the web.xml and cocoon.xconf files:


  load-class
  


org.hsqldb.jdbcDriver

org.gjt.mm.mySQL.Driver
  


   

  
  true
  jdbc:mysql://nn.nn.nn.nn/indicators 
  username
  pword
 


I think the problem *might* be with the [hostname] in the 
setting, 
as Tomcat does not run off the localhost [there is *no* localhost on 
this machine] but off nn.nn.nn.nn:8080.
I  have tried various combinations of  settings eg.:

jdbc:mysql://nn.nn.nn.nn/
jdbc:mysql://nn.nn.nn.nn:3306/
jdbc:mysql://localhost/
jdbc:mysql://localhost:3306/

PLEASE - I really need to get this app working at the client asap, 
(yesterday,, possible ;-) and did not anticipate these "basic" problems

- I am sure I am missing something simple here and would appreciate 
any insight.

Thanks
Derek
 

-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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

MySQL - No suitable driver

[Jan Willem Penterman]

I'm quite new to Cocoon but want to set up a MySQL connection using
ESQL. I followed the directives on
http://www.cocooncenter.de/cc/documents/resources/db-app/index.html and
altered the settings for MySQL like I see them everwhere in the mail
archives. So I have an XSP page generated from a subsitemap of the
default cocoon app:


http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>








org.gjt.mm.mysql.Driver

jdbc:mysql://localhost:3306/test
root
5h4p3r5

... 







As you can see it doesn't work both pooling and non-pooling. This is the
error:

error.log:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
opening connection to dburl: : No suitable driver

Traces I find of the driver:

access.log:
DEBUG   (2002-08-15) 02:32.20:253   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class:
org.gjt.mm.mysql.Driver

core.log:
DEBUG   (2002-08-15) 02:54.03:637   [core] (Unknown-URI)
Unknown-thread/Cocoon: Classpath =
;D:\apache-tomcat-4.0.4\webapps\cocoon\WEB-INF\lib\mm.mysql
-2.0.14-bin.jar;;

I can however make a jdbc:mysql connection with a regular servlet. So
nothing wrong with that.

My system:

Windows XP
j2sdk1.3.1_4
tomcat 4.0.4
cocoon 2.0.3
MySQL 3.23.49-nt
mm.mysql-2.0.14






-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

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