How can get the xml-file which cocoon produces...

[Schroeter Christian]

...and what must i do to:
* display it in the browser (eg. MSIE)
* sent it so that the browser would save it as an file
* sent it as an eMail (eg as an attachment)

at the moment i use cocoon 1.8.2 but i think about to change to cocoon2

cu,
Christian

-
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 can get the xml-file which cocoon produces...

[Schroeter Christian]

...and what must i do to:
* display it in the browser (eg. MSIE)
* sent it so that the browser would save it as an file
* sent it as an eMail (eg as an attachment)

at the moment i use cocoon 1.8.2 but i think about to change to cocoon2

cu,
Christian


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

MS SQL Server JDBC and Cocoon Connection Pool

[Schroeter Christian]

Hi,

i think about (..ok...i am forced to think about) to use the 
MS-SQL-Server.
Surprisingly i didnt find any post in this mailinglist which deals with this 
challenge.
So my questions:
How do i connect to this MS-Sql-Server by using JDBC and the Cocoon 
Connection Pool (Cocoon 1.8.2)...ok...

processor.xsp.pool.database.default.driver=???
processor.xsp.pool.database.default.url=???

processor.xsp.pool.database.adaptor.DBMSSqlServer=???


Which port is MSSqlServer using?

In addition it was give this link to me: 
http://www.microsoft.com/sql/downloads/2000/jdbc.asp


Cu,
Christian

-
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 1.8.2 + MySQL + JDBC + Win2000 + Tomcat

[Schroeter Christian]

Hi,

as i read here in the mailling-list and in the internet, there are more 
people who have problems to create an jdbc-connection to MySQL. At the moment 
i also try to establish such a connection.

But it is not working, and i do not know why. Can anybody help?

I am using MySQL (Version 3.23.38), Cocoon 1.8.2, Tomcat 3.2.3, Win2000
I used this jdbc-driver: mm.mysql-2.0.6.1.jar
I copied them into TOMCAT_HOME/lib

My cocoon.property-File has this:

# These are your database settings, look in the
# org.apache.turbine.util.db.pool.* package for more information.
processor.xsp.pool.database.db.driver=org.gjt.mm.mysql.Driver
processor.xsp.pool.database.db.url=jdbc:mysql:\\localhost\db
processor.xsp.pool.database.db.username=lothar
processor.xsp.pool.database.db.password=xxx
processor.xsp.pool.database.db.maxConnections=3
processor.xsp.pool.database.db.expiryTime=360

I try this both xml-Files to access the DB:

*** Without pool-connection:
Source of the page:

...

org.gjt.mm.mysql.Driver
jdbc:mysql://localhost/db
lothar
xxx



I get this errormessage:

java.lang.RuntimeException: Error loading driver: org.gjt.mm.mysql.Driver
at 
_D_._Jakarta._Tomcat._jakarta_tomcat_3_2_3._webapps._cocoon._uebung3._uebung3d_db.populateDocument(_uebung3d_db.java:183)
at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:527)
at org.apache.cocoon.Engine.handle(Engine.java:384)
at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at 
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)


*** With pool-connection

...

db
 
...

java.lang.RuntimeException: Error opening pooled connection: db: 
org.gjt.mm.mysql.Driver
at _D_._Jakarta._Tomcat._jakarta_tomcat_3_2_3._webapps._cocoon._uebung3._ue 
bung3c_db.populateDocument(_uebung3c_db.java:184)
at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:5 
27)
at org.apache.cocoon.Engine.handle(Engine.java:384)
at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at 
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)



cu,
Christian

-
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: SQL-Statment with two (or more) "where" statments

[Schroeter Christian]

Hi Christopher,

now it works...

...after i restarted tomcat and apache and then my server :-] it works...i 
dont know why...

on the same day i got the errormessage that the code cannot be compiled and 
since that errormessage nothing worked anymore...because of this i restarted 
everything...mybe there is a context between both events...???
sorry for the "excitement" i produced with my question...

cu,
christian


Am Freitag, 26. Oktober 2001 16:49 schrieben Sie:
> Christian,
>
> I can't see anything wrong, but you've not shown us all your code.  Also,
> we have no way of verifying that your column and table names match your
> database.  One reason it is hard to debug ESQL is because all exceptions
> get trapped and turned into generic exceptions, so you don't know what
> actual issue the JDBC driver or database is complaining about.  You should
> first ensure your queries work outside Cocoon (e.g., type them into a query
> tool and see if they blow up).  You can also try building up from simple
> queries that work, adding to them in small increments, e.g., one WHERE
> condition at a time and so forth.  That should help you find what bit is
> causing the trouble.
>
> If you want to see what JDBC is really complaining about, you'll have to
> hack the esql.xsl logicsheet to re-throw the JDBC exceptions instead of
> substituting generic exceptions.
>
> -Christopher
>
>
>
>
> Please respond to [EMAIL PROTECTED]
>
> To:   [EMAIL PROTECTED]
> cc:
>
> Subject:  SQL-Statment with two (or more) "where" statments
>
>
> Hi,
>
> i use cocoon1.8.2. Now i have a little problem:
>
> i want to query my db like this:
>
> 
> ...
>  
>  ...
>SELECT
>a.name
> FROM
>a, b
> WHERE
>   b.fk2 = a.pk
>   AND
> b.fk1 = 
>  
>  ...
>  
> 
>
> But i get the errormessage:
>
> Error executed prepared statement: SELECT a.name FROM a, b WHERE b.fk2 =
> a.pk
> AND b.fk1 = ?
>
> When i only use one where statment it works, but with 2 it wount
>
> What must i change ?
>
>
> cu
> Christian
>
>
>
>
>
> -
> 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]>

SQL-Statment with two (or more) "where" statments

[Schroeter Christian]

Hi,

i use cocoon1.8.2. Now i have a little problem:

i want to query my db like this:


...

...
  SELECT
   a.name
FROM
   a, b
WHERE
b.fk2 = a.pk
AND 
b.fk1 =  
 
...



But i get the errormessage:

Error executed prepared statement: SELECT a.name FROM a, b WHERE b.fk2 = a.pk 
AND b.fk1 = ?

When i only use one where statment it works, but with 2 it wount

What must i change ?


cu
Christian

-
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: date-format in cocoon 1.8.2

[Schroeter Christian]

Now if the value in the db is null then i get an error-message.

Without the format - attribute i wouldnt get it.

What must i change, and how?

cu,
Christian

Am Dienstag, 23. Oktober 2001 19:01 schrieben Sie:
> Specify the format attribute using a Java SimpleDateFormat string.  For
> instance,
> 
>
> -Christopher
>
>
>
>
> Please respond to [EMAIL PROTECTED]
>
> To:   [EMAIL PROTECTED]
> cc:
>
> Subject:  date-format in cocoon 1.8.2
>
>
> Hi,
>
> what must i do to change the format of the date i get with
> 
>
> i am using cocoon1.8.2
>
> cu,
> christian
>
>
>
>
>
> -
> 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]>

date-format in cocoon 1.8.2

[Schroeter Christian]

Hi,

what must i do to change the format of the date i get with 

i am using cocoon1.8.2

cu,
christian

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

html out of a db (Cocoon 1.8.1, Tomcat, Postgresql)

[Schroeter Christian]

Hi,

i want to read out of my database the content of my html-pages.

unfortunatly every < and > are replaced by < anf >

So the browser is printing the html code and not interpreting it.

Can anybody help me?
What must i change?

cu,
christian schroeter 


My sourcecode:

XML-File




http://www.apache.org/1999/XSP/Core";
   xmlns:esql="http://apache.org/cocoon/SQL/v2";
   xmlns:request="http://www.apache.org/1999/XSP/Request";>



   drm
  
 
select * from html
 
 

  
  

 
 

   selectHTML
   
  
   

 
  
  
...



XSL-File:


http://www.w3.org/1999/XSL/Transform";
   xmlns:util="http:://www.apache.org/1999/XSP/Util"
   xmlns:xsp="http://www.apache.org/1999/XSP/Core"; version="1.0">
   






   

<

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

esql, cocoon 1.8.2

[Schroeter Christian]

Hi,

which esql-tag must i use to get the number of the results a sql-statment 
returns?

cu,
christian

-
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 1.8.2, esql, html

[Schroeter Christian]

Hi,

my html-pages are stored in the database (postgres).
Now i want to read them out by e.g. ...select html from page where 
pageno=20..

in the xsl-page i wrote 

Urtunfortunately the result is not html because the <, > etc. are replaced.

What must i do so that the result is displayed and interpreted by the browser 
as it would be html?

cu
christian

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