Re: C1: ESQL: Pooling with mySQL?

[Sébastien Lefebvre]

You need to add a line in your cocoon.properties file. Check this and 
compare with your cocoon.properties file


# These are the supported jdbc-drivers and their adaptors.
# These properties are used by the DBFactory.
processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantDB,DBPostgres,DBSybase,DBInformix,DBMM
processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver
processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.instantdb.jdbc.idbDriver
processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
processor.xsp.pool.database.adaptor.DBInformix=com.informix.jdbc.IfxDriver
processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver
processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver

> When I try to use connection pooling rather than "in page" logic, I 
> get an error.
>
>  
>
> I had:
>
>   org.gjt.mm.mysql.Driver
>   DBName
>   DBUser
>   DBPass
>
> which worked fine...
>
>  
>
> and now have changed to:
>
>  
>
> mydb
>
>  
>
> where mydb is specified in the cocoon.properties file as:
>
>  
>
> processor.xsp.pool.database.mydb.driver=org.gjt.mm.mysql.Driver
> processor.xsp.pool.database.mydb.url=jdbc:mysql:localhost/mydb
> processor.xsp.pool.database.mydb.username=user
> processor.xsp.pool.database.mydb.password=pass
> processor.xsp.pool.database.mydb.maxConnections=10
> processor.xsp.pool.database.mydb.expiryTime=360
>
>  
>
> The error I get is :
>
>  
>
> java.lang.RuntimeException:
>
> Error opening pooled connection: mydb:
>
> Database type org.gjt.mm.mysql.Driver not implemented.
>
> What do I need to do??
>
>  
>
> Thanks
>
> Derek
>




-
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: C2: ESQL how to encode NOW() function

[Sébastien Lefebvre]

My XSP pages work fine with the following stynax (I also use MySQL)

INSERT INTO TOTO VALUES ('','Hello',now())
You don't need the  tag

Sébastien

>Hi All,
>
>Can somebody tell me the correct way to encode the names of SQL functions in
>queries?
>
>I'm trying to set a DATETIME column to the current time by passing the
>function NOW() but the value is always ends up set to null.
>
>I've tried:
>
>NOW()
>"NOW()"
>"NOW()"
>
>The insert statement works fine when I use the MySQL client.
>
>Any ideas?
>
>--
>



-
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: How to use Jfor with Cocoon 1.8.2 ?

[Sébastien Lefebvre]

Bertrand,

Reading the README file, I thought it was much more complicated than it is.
I'll keep you informed of my experience when I'll use more complicated 
features of jfor (images, tables ...)
I had no problem installing jfor on my system (I ran the minimum fo file 
successfully).
FYI, I use Apache 1.3.19 on linux RH7, Tomcat 3.2.2, Cocoon 1.8.2

Sébastien



>Bonjour Sébastien,
>
>>I'd like to use jfor in order to produce RTF file format.
>>
>
>Actually jfor is independent of FOP, and has to be configured as a separate 
>processor for Cocoon (1.x only, there is no jfor adaptor for Cocoon 2 yet).
>
>There are (sparse) instructions on how to configure jfor with Cocoon 1.x in 
>the README.TXT file that comes with the jfor source distribution, along with 
>FO files in the "samples" directory, that will help you to test jfor.
>
>If you configure jfor as indicated in the README, you will have to use the 
>following processing instruction to generate RTF:
>
> 
>
>Please let me know how this works for you, your feedback will help improve 
>jfor's documentation.
>




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

How to use Jfor with Cocoon 1.8.2 ?

[Sébastien Lefebvre]

Hi,
I'd like to use jfor in order to produce RTF file format.
The last version of jfor runs on FOP 0.19.
Cocoon 1.8.2 comes with Fop 0.15

FOP 0.19 also runs with newer version of Xerces and Xalan.

What do I have to do in order to upgrade the FO processing part of 
Cocoon 1.8.2?

Thanks

Sébastien




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

FOP Upgrade with cocoon

[Sébastien Lefebvre]

Hi,

I use FOP 0.15 coming with cocoon 1.8.2
I want to upgrade to 0.19

I plan to simply put the FOP 0.19 jar into $TOMCAT_HOME/lib and restart 
tomcat.
What kind of problem can occur ?

Thanks a lot for your help

Sébastien



-
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: Problem getting xml from DB

[Sébastien Lefebvre]

Oups !!!
I had a template name because of the need of a  and I 
didn't see it !
Thanks again

Sébastien

>hi Sébastien,
>
>>
>>Hello 
>>
>
>u should use match not name
>
>hope it helps,
>hubert
>
>
>
>---
>Ausgehende Mail ist zertifiziert virenfrei.
>Uberpruft durch AVG Antivirus System (http://www.grisoft.com/de).
>Version: 6.0.265 / Virendatenbank: 137 - Erstellungsdatum: 2001-07-18
>
>
>-
>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]>

Problem getting xml from DB

[Sébastien Lefebvre]

Hi,


I try to get xml from my DB (MySQL), here is my piece of code :

SELECT piano from TFiche where 
IdFiche=









node  is a child of   so I have /page/sebas

here is the piece of xml in my DB :

#B1DFB0#A4D1FF


When I try to apply a template in my XSL stylesheet, it does not apply 
the template but, instead, write the values of  and 










Hello 


Does you have any idea (I'm sure you have ;-) ) ?
What does the "root" argument of esql:get-xml mean ?

Thanks a lot

Sébastien



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

Cocoon + MySQL-Max transaction

[Sébastien Lefebvre]

Hi,

I'd like to use cocoon (1.8.2) with MySQL Max transaction .
What is the best strategy to adopt in order to make it work correctly ?
(e.g. How to set autocommit=0, begin work, commit,  inside one set 
of  tags ?)
Thanks a lot in advance

Cheers,

Sébastien




-
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: Cocoon2: ant problem

[Sébastien Lefebvre]

I had the same problem yesterday
Cocoon 2.02B, Tomcat 3.2.2, Apache 1.3.19 on RH7
Any help is welcome !
Sébastien

>Hi All,
>
>I experience a somewhat perculiar problem when I try to install cocoon2
>on a Redhat Linux box. If I run build.sh, I get the following
>
>
>Apache Cocoon 2 Build System
>
>./build.sh: /usr/local/xml-cocoon2/bin/ant: No such file or directory
>
>But, the /usr/local/xml-cocoon2/bin/ant certainly exists and also has
>the right permissions:
>
>ls -l bin/ant gives:
>
>-rwxr--r--1 root sys  2936 Jul 23 12:25 bin/ant
>
>I remember that somebody else on this list had a similar problem, but I
>could not find that message in the archive. So, I hope that one of you
>can help me out. 
>
>I have installed Cocoon2 earlier on Slackware with no problems at all,
>so the aforementioned problem may be a Redhat thing. Tomcat and Java run
>without any problem, Java is jdk1.3.1. Suspecting that it may be a bash
>problem, I have made a build script based upon tcsh, but the result is
>exactly the same.
>
>Thanks,
>




-
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: build.sh in cocoon2.0b2

[Sébastien Lefebvre]

Just have a look at the INSTALL file coming with the distribution.

Sebastien

>Hi Developers
>
>I am unable to use "build.sh" distributed with Cocoon2.0B2.
>The "build.sh" distributed in Cocoon2.0B1, kindly revert "build.sh"
>to the Cocoon2.0B1 version, or somebody kindly let me know
>how to use the "build.sh" in the Cocoon2.0B2 distribution.
>
>   I am trying this on Linux (Mandrake-8.0).
>
>Regards
>Joseph Rajkumar
>
>
>
>-
>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: Replacing \n with -> cocoon pb ?

[Sébastien Lefebvre]

I use MySQL and it does have a replace function.
But, as I want to be independant from the target platform, I prefer  to 
do it in the XSL stylesheet so, when I do FO transformation, I don't 
have to change my XSP.
Thanks again for your solution
Sébastien

>What about doing the replacements in your SELECT statement to create
>well-formed XML, then using the  to retrieve it?  In
>Oracle, it would look like:
>
>SELECT '' || REPLACE(mytextfield, CHR(10), '') || '
>FROM 
>
>I would guess most RDBMS have a similar capability.
>
>-Christopher
>


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

Replacing \n with -> cocoon pb ?

[Sébastien Lefebvre]

Hi folks !

I have text in a database with \n characters in it.
I want to produce HTML and keep LF in my presentation.
So I have to convert \n to 

I can't replace with < and > characters because they can be confusing 
for the parser , am I right ?
In order to see if my template is ok, I tried it but I have a 
StackOverFlowError ! (replacing \n with BR )
Any help is appreciated

Thanks

Sébastien






Here is what I did :




















Then, I call it like that :
 











-
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: Quotes in query

[Sébastien Lefebvre]

Sylvain ,

Thank you  for your prompt answer.
As far as I'm new to Cocoon, could you send me a piece of code ?
It will help me very much.

Thanks again

Sébastien

>
>Sébastien Lefebvre wrote:
>
>>Hi all,
>>
>>I have a form where I can type text.
>>The form is submited  with post method to a xsp page.
>>This texte can of course have quotes in it. ex:  I'd like this to work
>>How to insert it in MySQL ?
>>Do I have to write XSP logic in order to replace ' by \'?
>>Or is there any other solution ?
>>(I'd like to make the operation server side so javascript's regexp is
>>not an issue for me).
>>
>>Thanks in advance
>>Sébastien
>>
>Use a PreparedStatement to insert your String, the JDBC driver will take
>care of this if needed. This will also increase the portability of your
>code, since escaping syntax varies between databases.
>




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

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

Quotes in query

[Sébastien Lefebvre]

Hi all,

I have a form where I can type text.
The form is submited  with post method to a xsp page.
This texte can of course have quotes in it. ex:  I'd like this to work
How to insert it in MySQL ?
Do I have to write XSP logic in order to replace ' by \'?
Or is there any other solution ?
(I'd like to make the operation server side so javascript's regexp is 
not an issue for me).

Thanks in advance
Sébastien





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