from:"Marty McClelland"

Re: Does anyone remember cocoon 1.8?

2002-06-27 Thread Marty McClelland


I haven't installed 1.8 in a while - and from my memory - this looks like
the kind of error I got when I didn't follow the installation instructions
carefully ( i.e. jars not in the right directory, or not loaded in the
appropriate sequence,  )

Have you searched the archives?

marty
- Original Message -
From: "Paul Gilligan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 11:02 AM
Subject: Does anyone remember cocoon 1.8?


> I have switched to an "out of the box" cocoon 1,8 that coomes with SuSE
8.0
> and I get:
>
> java.lang.RuntimeException: Error loading logicsheet at
> resource://org/apache/cocoon/processor/xsp/library/java/util.xsl due to
> java.lang.Exception: Resource not found or retrieving error.
>
> Now I am sure that this is a std problem and someone can tell me how to
> sort this out without me
> having to dig too deep :)
>
> What I am working on is using the new Oracle 9.2 XML repository and a
> standard cocoon production version (1.8)
> and the JDK 1.3 that comes with it -hence I do not want to have todo too
> much work on the cocoon side.
>
> Then I will be adapting the docbook DTD to work with Oracle and then use
> cocoon to publish.
>
> Now here is the crunch!! I can easily do a little programming to with
> Oracle to make a content management
> frame work :)
>
> Has any one else looked at Oracle 9.2 XML?
>
> Paul
>
>
>
>
>
>
> -
> 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: Help Requested!!!!

2002-04-17 Thread Marty McClelland


I have seen this error when there is an error in the table name.  Check
the spelling of the table name in the database and make sure it matches
the name in the query including upper/lower case. 

marty

> -Original Message-
> From: Muhammad Irfan [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 17, 2002 12:14 PM
> To: [EMAIL PROTECTED]
> Subject: Help Requested
> 
> 
> 
>   Dear All,
> 
> I am trying a simple process to execute the sql query that 
> should give me the output in xml, but It seems to me that I 
> am stuckup with this. Below is the detailed description of 
> what I have done:- I have created a file named sql-test.xml 
> under "test" folder within tomcat/cocoon that just consist of 
> a single query:-   xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
> Hello
> 
> This is SQL Test
> 
> 
>   select * from employee
> 
> 
> 
> 
> 
> I have updated the entries for driver and db within the 
> web.xml and cocoon.xconf file to use with MS Access database. 
> Having done that, I have inserted the following lines within 
> the main sitemap:-  
> 
> 
> 
> 
> 
> 
> 
> 
> I am getting the following errors:-
> 
> " System can't find the specified resource"
> " java.sql.SQLException: [Microsoft][ODBC Microsoft Access 
> Driver]Invalid use of null pointer "
> 
> I will be grateful for your kind help
> 
> Regards
> 
> Irfan.
> 
> 
> 
> 
> 
> 
> _
> Get your FREE download of MSN Explorer at 
> http://explorer.msn.com/intl.asp.
> 
> 
> 
> -
> 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: Esql row-results

2002-04-11 Thread Marty McClelland


from the mysql manual -

The LIMIT clause can be used to constrain the number of rows returned by the
SELECT statement. LIMIT takes one or two numeric arguments. The arguments
must be integer constants. If two arguments are given, the first specifies
the offset of the first row to return, the second specifies the maximum
number of rows to return. The offset of the initial row is 0 (not 1):
mysql> select * from table LIMIT 5,10;  # Retrieve rows 6-15
If one argument is given, it indicates the maximum number of rows to return:
mysql> select * from table LIMIT 5; # Retrieve first 5 rows
In other words, LIMIT n is equivalent to LIMIT 0,n.


marty
- Original Message -
From: "Sharat Koya" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 10:00 PM
Subject: Re: Esql row-results


> unfortunatly not. I am using mysql
> - Original Message -
> From: "Chris Warr" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 12, 2002 3:02 AM
> Subject: RE: Esql row-results
>
>
> > does 'select top 1 ' do what you want.  It just returns one row of
the
> > query results.  Not sure if all dbs support it though.  Very handy
though.
> >
> > Chris.
> >
> > -Original Message-
> > From: Sharat Koya [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, 12 April 2002 11:54
> > To: [EMAIL PROTECTED]
> > Subject: Esql row-results
> >
> >
> > Hi, I have searched through the archives over the past hour and haven't
> > found anything for this problem.
> >
> > What I want to do is execute a esql query that returns the results from
a
> > table but only selects the first row. eg..
> > normal esql namespace excluded...
> >
> > select * from action where due < current_timestamp
> > 
> >  
> >   
> >  
> > 
> > what i want to be able to do is return only one action and ideally the
> first
> > one it comes across. Once it does i can then set about processing the
> action
> > and then delete from the database.
> >
> > any ideas?
> >
> > thanks for any time put in
> >
> > Sharat Koya
> >
> >
> > -
> > 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]>
> >
> >
>
>
> -
> 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: MS Access on Cocoon2???

2002-04-11 Thread Marty McClelland


Last year I used MS Access with Cocoon.  I have since switched to SQL
2000 because MS Access via the odbc bridge does not allow for full use
of the ESQL tags.  For example - it is not possible to use nested
queries with Access.  This is because of the limitations of the odbc
bridge.

marty

> -Original Message-
> From: Sean Malone [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, April 11, 2002 3:55 PM
> To: [EMAIL PROTECTED]
> Subject: RE: MS Access on Cocoon2???
> 
> 
> You should be able to use JDBC:ODBC bridge to connect to the 
> datasource
> 
> -Original Message-
> From: Rajput, Ashish S [mailto:[EMAIL PROTECTED]]
> Sent: 11 April 2002 20:38
> To: '[EMAIL PROTECTED]'
> Subject: MS Access on Cocoon2???
> 
> 
> Hello,
> 
> Is it possible to hook Cocoon upto a test MS Access DB?  I'd 
> like to install MySQL, but downloading that runs me into red 
> tape with my IS Dept.
> 
> I'm running Windows 2000; JDK1.3.1; Tomcat4.0.1; Cocoon2.0
> 
> Thanks,
> Ashish Rajput
> 
> -
> 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]>


-
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: Cocoon 1.8.2

2002-03-29 Thread Marty McClelland




I use C1.8.2 with tomcat 3.2 - i've never been able 
to get C1.8.2 to work with tomcat 4 - marty

  - Original Message - 
  From: 
  Matus Krisztián 
  
  To: [EMAIL PROTECTED] 
  
  Sent: Thursday, March 28, 2002 10:51 
  AM
  Subject: Cocoon 1.8.2
  
  
  *** Sender : Matus Krisztián <[EMAIL PROTECTED]> ***
   
  Hello,I'm in need of your help. 
  My problem with Cocoon is that I can't breath itto life. I've made a build 
  with version 1.8.2 and put the JARs undertomcat4.0.1/lib.I've 
  copied cocoon-1.8.2/samples to tomcat4.0.1/webapps/samples.
  After I've copied cocoon.properties to 
  tomcat4.0.1/webapps/samples and made modifications to 
  tomcat4.0.1/webapps/samples/web.xml:    
  org.apache.cocoon.Cocoon    
  org.apache.cocoon.Cocoon    
      
  properties    
  /cocoon.properties    
      
  org.apache.cocoon.Cocoon    
  *.xmlI'm 
  receiving the following message with URLhttp://localhost.8080/samples/index.xml 
  
   
   Publishing 
  Engine could not be initialized.
   
    
  java.lang.RuntimeException: Error loading logicsheet at 
  resource://org/apache/cocoon/processor/xsp/library/java/util.xsl due to 
  java.lang.Exception: Resource not found or retrieving 
  error.  
  at 
  org.apache.cocoon.processor.xsp.XSPProcessor.init(XSPProcessor.java:302)  
  at 
  org.apache.cocoon.framework.Manager.create(Manager.java:109)  
  at 
  org.apache.cocoon.framework.Router.init(Router.java:80)  
  at 
  org.apache.cocoon.framework.Manager.create(Manager.java:109)  
  at 
  org.apache.cocoon.Engine.(Engine.java:179)  
  at 
  org.apache.cocoon.Engine.getInstance(Engine.java:232)  
  at 
  org.apache.cocoon.Cocoon.init(Cocoon.java:157)  
  at 
  org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:852)  
  at 
  org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:615)  
  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:201)  
  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.StandardContext.invoke(StandardContext.java:2344)  
  at 
  org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)  
  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:462)  
  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:163)  
  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:1011)  
  at 
  org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)  
  at java.lang.Thread.run(Thread.java:484)<[EMAIL PROTECTED]>

Re: Why isn't Cocoon making into the commerical world?

2002-03-29 Thread Marty McClelland


> > What is its direct competition?
Someone in my local java users group recently advocated Struts - another
apache project - over cocoon.  Anyone have any comments?


-
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: Update on my problem

2002-03-28 Thread Marty McClelland


You may want to check the postings from earlier this week (i've already
deleted mine ).  but I'm remembering posts about pooling problems with
jdk1.4.

marty

> -Original Message-
> From: Chris Newland [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, March 28, 2002 1:42 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Update on my problem
> 
> 
> Hi Jeremy,
> 
> Your XSP page looks fine to me and if it is working without 
> pooling then I'm starting to think that a bug may have been 
> introduced into the latest database code.
> 
> My best suggestion would be to download the latest release 
> version of Cocoon
> (2.0.2) and try your XSP page on that. Also, double check 
> your cocoon.xconf and web.xml for typos. Maybe check that 
> MySQL is running and do mysqladmin -version to get the query 
> count to see if any queries are making it to the DB.
> 
> Best Regards,
> 
> Chris
> 
> 
> 
> > -Original Message-
> > From: Jeremy Beeler [mailto:[EMAIL PROTECTED]]
> > Sent: 28 March 2002 18:12
> > To: [EMAIL PROTECTED]
> > Subject: Re: Update on my problem
> >
> >
> > Chris,
> > Thanks again for all the help.
> >
> > trust me, i'm not pushing the envelope by design, it's just 
> these are 
> > the versions that i've gotten the farthest with in terms of getting 
> > things working. i've never had db pooling working, in fact 
> this past 
> > week or so has been my
> > first venture into cocoon for any other use than classroom theory.
> > the exception is generated when i try to run my test.xsp. cocoon
> > loads fine
> > otherwise.
> >
> > here is my code from the test.xsp
> >
> > 
> > http://apache.org/xsp"; 
> > xmlns:esql="http://apache.org/cocoon/SQL/v2";>
> > 
> > A Database Driven XSP Page to Test
> > 
> > 
> > 
> > tester
> >
> > 
> >
> > 
> > select * from operator
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >
> > 
> > 
> > 
> > 
> > 
> >
> > For some reason when using the pool it will throw that 
> exception, but 
> > if i just instantiate a connection in the xsp if generates 
> the desired 
> > output just fine. the only problem is, i really need to use pooling.
> >
> > thanks again.
> >
> > Jeremy
> >
> > - Original Message -
> > From: "Chris Newland" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, March 28, 2002 12:39 PM
> > Subject: RE: Update on my problem
> >
> >
> > > Hi,
> > >
> > > In my root.log file I have
> > >
> > > DEBUG   (2002-03-26) 15:17.37:230   [root] (Unknown-URI)
> > > Unknown-thread/Coco
> > > onServlet: Trying to load class: org.gjt.mm.mysql.Driver
> > >
> > > Thats the only log file reference I get to my DB driver 
> and I have 
> > > no problems with DB pooling.
> > >
> > > I'm using Cocoon 2.0 final, Tomcat 4.0 final, JDK1.3.1_01 but it 
> > > looks
> > like
> > > you're pushing the envelope when it comes to latest versions ;)
> > >
> > > Have you had DB pooling working with earlier versions of Cocoon
> > / Tomcat /
> > > JDK?
> > >
> > > Does your exception occur when Cocoon tries to start, or when
> > the XSP page
> > > is accessed?
> > >
> > > Can you post a snippet of your XSP page?
> > >
> > > Thanks,
> > >
> > > Chris
> > >
> > >
> > > > -Original Message-
> > > > From: Jeremy Beeler [mailto:[EMAIL PROTECTED]]
> > > > Sent: 28 March 2002 17:08
> > > > To: [EMAIL PROTECTED]
> > > > Subject: Re: Update on my problem
> > > >
> > > >
> > > > yes and in my access log it says trying to load and the driver 
> > > > name. i don't know if this means it failed or it loaded ok. is 
> > > > there any way to tell if it
> > > > is loaded ok? and if it is loaded ok does the pool know 
> to use that
> > driver
> > > > by default?
> > > >
> > > > thanks for your help.
> > > >
> > > > Jeremy
> > > >
> > > > - Original Message -
> > > > From: "Chris Newland" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Thursday, March 28, 2002 11:28 AM
> > > > Subject: RE: Update on my problem
> > > >
> > > >
> > > > > Hi Jeremy,
> > > > >
> > > > > Have you added your database driver info to your
> > WEB-INF/web.xml file?
> > > > >
> > > > > -
> > > > > cocoon.xconf:
> > > > > -
> > > > >
> > > > > 
> > > > > 
> > > > >  
> > > > > jdbc:mysql://localhost:3306/tester
> > > > > true
> > > > > login
> > > > > pass
> > > > > 
> > > > > 
> > > > >
> > > > > 
> > > > > WEB-INF/web.xml:
> > > > > 
> > > > >
> > > > > 
> > > > > 
> > > > >   load-class
> > > > >   
> > > > > 
> > > > >
> > > > > 
> > > > > org.gjt.mm.mysql.Driver
> > > > >   
> > > > > 
> > > > >
> > > > >
> > > > > Hope this helps,
> > > > >
> > > > > Regards,
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > > -Original Message-
> > > > > From: Jeremy Beeler [mailto:[EMAIL PROTECTED]]
> > > > > Sent: 28 March 2002 16:14
> > > > > To: [EMAIL PROTECTED]

RE: Cocoon2: couldn't make nested queries work for ESQL in XSP.

2002-03-25 Thread Marty McClelland


I've done a number of nested queries in C1.8.2 and as far as I know the
approach is the same in C2.  Here is an example:


   


   select Distinct Contribute.Centity_id, Contribute.role
FROM Contribute , Collection_resources where
Collection_resources.Collection_id=collectionID and
Collection_resources.rid=Contribute.rid




SQL error - contact the ilumina
administrator








 
 
  
select count(distinct Contribute.rid) from Contribute,
Collection_resources where centity_id= and
Contribute.rid=Collection_resources.rid and
Collection_resources.Collection_id=collectionID


  
  
 

  

  
select first_name, last_name from Centity where
centity_id=

  
  , 
 

  








  

marty

> -Original Message-
> From: Argyn Kuketayev [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, March 25, 2002 10:34 AM
> To: '[EMAIL PROTECTED]'
> Subject: Cocoon2: couldn't make nested queries work for ESQL in XSP.
> 
> 
> I've to make a report on the table M, then for each row I 
> need to show corresponding rows from tables F and C.
> 
> Something like this:
> 
> 
>   
> 1
> 
> 
>   
> f1
>   
>   ...
> 
> 
> 
>   
> c1
>   
>   
> 
>   
> ...
> 
> 
> I tried this :
> 
>   l:parameter type="int"> column="id"/>
> 
> It didn't work with an exception: 
> 
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): java.lang.RuntimeException: 
> Error executing prepared statement: select ... from f where M_ID = ? :
> java.sql.SQLException: ORA-01722: invalid number
> 
> 
> Can somebody give me a WORKING and tested example of nested 
> queries in Cocoon2?
> 
> thanks,
> Argyn
> 
> -
> 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]>

cocoon 2 tutorial

2002-03-14 Thread Marty McClelland


Hello All - 

The latest IBM DeveloperWorks points to a Cocoon 2 tutorial:

http://www-106.ibm.com/developerworks/education/r-xcocoon.html?n-x-3142

-
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: XML for describing databases?

2002-03-14 Thread Marty McClelland


I developed something similar for use with an application.  I got it to
do what I needed - but I also worked with my approach enough to uncover
some pitfalls - so please let me know if you discover an xml schema to
represent a database schema.

I did find some solutions that were built on the assumption of the
database schema using the same structure as the xml schema like
http://www.w3.org/XML/RDB.html

Here are other useful links:
http://www.rpbourret.com/xml/XMLDBLinks.htm
http://www.rpbourret.com/xml/XMLAndDatabases.htm

marty

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, March 14, 2002 1:49 PM
> To: [EMAIL PROTECTED]
> Subject: XML for describing databases?
> 
> 
> Hey folks,
> 
>   I need to build a web interface to a whole bunch of 
> databases.  To limit the work I'll have to do, I would like 
> to be able to define each database in a XML file, and have 
> the interface somewhat dynamically generated from those files.
> 
> So, for one database named 'gesupply', part of the file 
> gesupply.xml would look like:
> 
> ---
> 
>   postgresql://localhost/gesupply
>   
>   
>   
>   
>   
>   
>   
>   
>   
> 
> ... etc ...
> 
> 
> ---
> 
> The idea is, the xslt will generate the appropriate file(s) 
> to provide a basic interface to the database.
> 
> My question is: anyone know if a schema/xml-application like 
> this already 
> exists?  Any searches for database+xml come up with dbxml or 
> something related whcih, unless I'm misunderstanding 
> something, isnt of use in this sort of application.
> 
> -Tom  
> 
> -
> 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]>

thanks for sharing your expertise Vadim

2002-03-14 Thread Marty McClelland


Hello Vadim - 

I just want to express my appreciation for your participation on the
Cocoon users list.  

I have a Cocoon 1.8.2 application that I will migrate to Cocoon 2 in a
couple of months.   In the meantime, I am reading the list to get a
heads up on the issues and solutions with C2 ( there is very little
traffic about C1.8 these days ).  So I am learning from your responses
to others questions.

I also want to acknowledge your patience with newbies.  After reading
the list for some months - I find it interesting to see how many of the
questions are repeats.  Yet you continue to point folks in the right
direction - even when answering the same questions for the hundredth
time.

thanks again!
enjoy the day - marty  

-
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: Viewing XSP output with IE5.5

2002-01-28 Thread Marty McClelland


Generate a PI for the root element something like:


type="text/xml"

.
.
.


marty


> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED]] 
> Sent: Sunday, January 27, 2002 7:17 PM
> To: [EMAIL PROTECTED]
> Subject: Viewing XSP output with IE5.5
> 
> 
> I am trying to display the output of the counter.xsp in IE5
> In order to develop step by step, I want to check the output 
> of my xsp file.
> 
> IE5 is able to display an xml file
> Nice : it lets you open and close nodes.
> 
> So after generating my xsp, I serialize it i xml.
> IE5 should display the xml.
> 
> But instead, IE5 displays this :
> 
>  The XML page cannot be displayed   
> 
> 
>  Cannot view XML input using XSL style  
>  sheet. Please correct the error and then   
>  click the Refresh button, or try again 
>  later. 
> 
> 
>  The namespace prefix is not allowed to 
>  start with the reserved string "xml". Line 
>  2, Position 7  
> 
> 
> 
> 
> 
> 
> http://www.w3.org/XML/1998/namespace"; 
> xmlns:xsp ="http://apache.org/xsp";> --^
> 
> With the View Source menu item I get this :
> 
> 
> http://www.w3.org/XML/1998/namespace"; 
> xmlns:xsp ="http://apache.org/xsp";>
>   I have been requested 0 times.
>  
> 
> The problem is that Cocoon adds xmlns:xml 
> ="http://www.w3.org/XML/1998/namespace"; 
> xmlns:xsp="http://apache.org/xsp"; in the page tag. Why does 
> Cocoon add those declarations here ? Is there a way of 
> getting rid of them ?
> 
> Valentin
> 
> 
> I am using Cocoon 2 on Windows 2000.
> 
> The counter.xsp is this :
> 
> 
> 
> http://apache.org/xsp";>
> 
>   
>   static private int counter = 0;
>   private synchronized int count()
>   {
> return counter++;
>   }
>   
> 
>   
>   I have been requested count() times.
>   
> 
> 
> 
> ===
> This email message is for the sole use of the intended 
> recipient(s) and may contain confidential and privileged 
> information. Any unauthorized review, use, disclosure or 
> distribution is prohibited.  If you are not the intended 
> recipient, please contact the sender by reply email and 
> destroy all copies of the original message
> 
> 
> 
> -
> 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: Cocoon 2 with VAJ 4 and WTE

2002-01-25 Thread Marty McClelland


Hello Tom - 

If you get C2 running with VAJ4 and WTE - could you post the process
back to the list?

I use VAJ4 - and it would be great to have C2 integrated withit.

marty

> -Original Message-
> From: Vadim Gritsenko [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, January 24, 2002 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Cocoon 2 with VAJ 4 and WTE
> 
> 
> > From: tom blondeau [mailto:[EMAIL PROTECTED]]
> 
> 
> 
> > but at least Cocoon seems to be running. when i request 
> > http://localhost:8080/cocoon/ the sitemap_xmap.java, 
> > sitemap_xmap.class and a 3rd classfile are
> created
> > but I get an internal server error:
> > "The sitemap handler's sitemap is not available. Please 
> check logs for
> the
> > exact error."
> > 
> > I found some discriptions of these errors in some mailing list
> archives, but
> > no real solution that helped me. i'd really appreciate some help or
> ideas
> > how to fix that...
> 
> I do not not what's new in VAJ4 and websphere, but I recall 
> that when I tried to run Cocoon under VAJ35, there were class 
> loading issues. Try
> this:
> 
> 1. Set classpath for the project to include directory were 
> sitemap class is generated; 2. If this does not help, import 
> sitemap class manually into VAJ, and never modify sitemap 
> source after that - or repeat step 2 ;).
> 
> Vadim
> 
> 
> -
> 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: My Cocoon Tutorial is Online!

2002-01-23 Thread Marty McClelland

Title: Message



Hello Andreas - 

 
I am getting a page not found 
error for your tutorial.  Has the tutorial moved?  I know it was there 
last week - as I looked at the site and found it useful.
 
enjoy the day - 
marty

  
  -Original Message-From: Andreas Hartmann 
  [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 7:17 
  PMTo: [EMAIL PROTECTED]Subject: My Cocoon 
  Tutorial is Online!
  Hi folks,
   
  I'm about to create a website about Cocoon and started today 
  with a little tutorial.
  It is directed to newbies (actually, I'm a newbie too ...) 
  and describes a possibility
  to create a simple hierarchic site with 
  a navigation menu.
   
  The tutorial can be found at
  http://www.cocooncenter.de/cocooncenter/tutorials/navigation/tutorial.html .
   
  I would be very pleased with any comments, also 
  regarding spelling and grammar.
  The site will be extended soon (it even will get a real 
  layout :-) ).
  It will probably contain some more tutorials, tips and 
  a user forum.
   
  If somebody wants to contribute to the site - just contact 
  me!
   
  Greetings,
  Andreas

Re: Evaluating Variable XPATH

2002-01-16 Thread Marty McClelland


I have found the xslt list at:
http://p2p.wrox.com/listindex.asp
useful for help with xsl/xpath questions.

In looking at your problems - I don't see a way to transform it in one step.
I would have to pass it thru the transformer twice.

marty


- Original Message -
From: Joseph Rajkumar <[EMAIL PROTECTED]>
To: cocoon-users <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 11:52 AM
Subject: Evaluating Variable XPATH


> Hi Folks
> I have the latest CVS of Cocoon+Tomcat-4.0.1
> working fine and I am trying to demo this to the
> powers that decide. I have a minor problem and I am
> desperate.
>
> Part of the xml file:-
>
> 
> 
>
> There are lots of ARC elements whose attributes DataEnd
> and ViewEnd contain XPATH to various other attributes contained
> in various other elements in the document.
> I need to get to the contents of the attribute
> contained in the DataEnd and ViewEnd
>
> In the following template:
> 
>How do I print the value contained in the XPATH
>which is contained in the attribute "@DataEnd" or "@ViewEnd"
>What I need to print here is 6 and 6.0 as shown in the above
>example
> 
>
> I have search many many places, but I could not resolve this.
>
> Thanks
> 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: Big problem with IE!

2002-01-14 Thread Marty McClelland


Which version of IE and what is the OS? Are you using Apache or IIS also?

I am running C1.8.2 and tomcat 3.2 on my laptop. IE has been reliable for me
since I did a clean install of Windows 2000.  I did not install MS
Office

marty
- Original Message -
From: TJ Smith <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 14, 2002 10:20 PM
Subject: Re: Big problem with IE!


> Hi Adam
> Thanx for responding...The application works fine on Netscape 6.  Also, I
> didn't mean '5' literally :-)  It's a random-ish number - actually it's
only
> guaranteed to fail (as it did today) during a customer demo!
Unfortunately,
> customers know of no other browser than IE, so
>
> sadly
> TJ
> - Original Message -
> From: "Adam A R" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, January 14, 2002 10:01 PM
> Subject: Re: Big problem with IE!
>
>
> > Hi TJ,
> >
> > Please check the logicsheet which munges the data.
> >
> > If the browser(I think you will encounter the same problem if you were
to
> > use any other browser. Please check and let us know) can display it 5
> times,
> > it means that there is probably no problem with the browser.
> >
> > Sometimes you may keep opening connections to some resource without
> closing
> > them in your pages. It will work for first 'n' number of times. And at
> 'n+1'
> > th time it will fail. There was similar problem of mine.
> >
> > after 19-20 requests the CPU usage would become 100% without page being
> > served and everything in a limbo. It turned out that there was a tweak
> > inserted by another group of ours into Cocoon which %'&$( the caching
and
> > hence the problem.
> >
> > Hope this gives some insight into your problem.
> >
> > cheers adam
> >
> > - Original Message -
> > From: "TJ Smith" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, January 15, 2002 9:23 AM
> > Subject: Big problem with IE!
> >
> >
> > > Hello all
> > > Before I get flamed - let me apologize for probably an inappropriate
> > posting
> > > to the group -but I AM using Cocoon/Tomcat/Servlets/etc. so I'm hoping
> > > someone out there has encountered my problem (and has a FIX) and
> > desperation
> > > has set in so
> > >
> > > Particulars: Tomcat 3.3, Cocoon 1.8.2.  Cocoon used to serve html form
> > pages
> > > for user updating, etc.  When the form is sent to the server
(submitted)
> > it
> > > is sent to a servlet of mine running in Tomcat.  The servlet munges
the
> > data
> > > etc. etc.  The problem is with IE as the client browser.  For 5 out of
6
> > (or
> > > thereabouts) times, accessing the servlet via URL works fine.  The 6th
> > time
> > > I get the infamous "The Page cannot be displayed", Can't find server,
> blah
> > > blah.  I've searched many news groups/microsoft support/etc. without
> > > success.  Has anyone in this group encountered this #^%&#^ problem?
> > >
> > > regards
> > > TJ
> > >
> > >
> > >
> > >
> > > -
> > > 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]>
> >
>
>
>
> -
> 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: HELP: Error opening connection to dburl: jdbc:postgresql://localhost/test

2002-01-14 Thread Marty McClelland


Generally - when I get this error - there is a mismatch between the
configuration of the database and what has been specified when connecting
with the driver.  For example - I forgot to create the username/password -
or the name of the database has a typo - or I forgot to create the sample
database

marty
- Original Message -
From: Ivan Manuel Andrade Muñoz <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 14, 2002 3:52 PM
Subject: HELP: Error opening connection to dburl:
jdbc:postgresql://localhost/test


>
>
>
>
> Hello to all, Happy New Year.
>
> The error is:
>
>

***
> --
-
> Cocoon 1.8.2
> --
-
>
> Error found handling the request.
>
> java.lang.RuntimeException: Error opening connection to dburl:
> jdbc:postgresql://localhost/test
> at
>
_usr._local._jakarta._build._tomcat._webapps._cocoon._samples._sql._esql.pop
ulateDocument(_esql.java:162)
> 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:865)
> 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:81
2)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
> at
>
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.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)
>
> --
-
>
> Warning: this page has been dynamically generated.
>
> Copyright (c) 1999-2001 The Apache XML Project.
> All rights reserved.
> --
--
>


> I have installed:
>
> Red Hat Linux 7.2
> Sun JDK 1.3.1_01
> Apache 1.3.19
> Tomcat 3.2.3
> Cocoon 1.8.2
> Postgresql 7.1.3
> jdbc7.1-1.2
> -
> Note: form postgresql 7.1.3, with the option -- with-java
>
> I have formed my archive:
>
> My file .bash_profile.
> 
> # .bash_profile
>
> # Get the aliases and functions
> if [ -f ~/.bashrc ]; then
>. ~/.bashrc
> fi
>
> # User specific environment and startup programs
>
> JAKARTA_HOME=/usr/local/jakarta
> ANT_HOME=$JAKARTA_HOME/jakarta-ant
>
PATH=$PATH:$HOME/bin:/usr/java/jdk1.3.1_01/bin:$ANT_HOME/bootstrap/bin:/usr/
local/pgsql/bin
> BASH_ENV=$HOME/.bashrc
> USERNAME="root"
> JAVA_HOME=/usr/java/jdk1.3.1_01
> #JAKARTA_HOME=/usr/local/jakarta
> #ANT_HOME=$JAKARTA_HOME/jakarta-ant
> TOMCAT_HOME=$JAKARTA_HOME/build/tomcat
> COCOON_HOME=/usr/local/cocoon1.8.2/
> PG=/usr/local/pgsql
> PGLIB=$PG/lib
> PGDATA=$PG/data
> MANPATH=$MANPATH:$PG/man
> CLASSPATH=/usr/local/jdbc7.1-1.2.jar
> export USERNAME BASH_ENV JAVA_HOME JAKARTA_HOME ANT_HOME TOMCAT_HOME
> COCOON_HOME PATH CLASSPATH
> --
-
>
>
>
>
> _
> MSN Photos es la manera más sencilla de compartir e imprimir sus fotos:
> http://photos.latam.msn.com/Support/WorldWide.aspx
>
>
> -
> 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: Cocoon 1.8.2 on Tomcat w/IIS

2002-01-04 Thread Marty McClelland


We installed tomcat 3.2 with IIS following the instructions on the tomcat
site for IIS.  We installed Cocoon 1.8.2 on tomcat following the
instructions on the cocoon site.

marty
- Original Message -
From: Anthony Diodato <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 04, 2002 8:23 AM
Subject: Cocoon 1.8.2 on Tomcat w/IIS


> Does anyone have good installation instructions to install Cocoon 1.8.2 on
> top of Tomcat using IIS as the webserver.
>
> The instructions on the http://xml.apache.org give instructions, but they
> are (I think) specific to Apache web server.
>
> Thanks in advance.
> Tony
>
> Anthony Diodato
> Webmaster - IT
> Prophet 21, Inc.
> 19 West College Avenue
> Yardley, PA 19067
> 1-800-776-7438, ext. 4600
> Fax: 215-321-8014
> [EMAIL PROTECTED]
> http://www.p21.com/
> Prophet 21 -- Powering the Distribution Industry for the Digital Age
>
> For the latest press releases from Prophet 21 --
> http://www.p21.com/press/press.html
> * 2/12/2001 - Trading Partner Connect Offers Enterprise-to-Enterprise
> (E2E) Commerce
> * 2/9/2001 -- Prophet 21 CommerceCenter 8.0 is Now Available
> * 2/9/2001 -- Prophet 21 Upgrades and Enhances Prophet 21 Acclaim
> For the latest articles on Prophet 21
>
http://www.manufacturing.net/magazine/id/archives/2001/ind010.02/techupdate.
> htm
> http://www.manufacturing.net/magazine/id/develop/techmain01.1.htm
> http://www.manufacturing.net/magazine/id/archives/2000/ind1201/news.htm
>
>
>
>
> Visit our website at http://www.p21.com/visit
> The information in this e-mail is confidential and may contain legally
> privileged information.  It is intended solely for the person or entity to
> which it is addressed.  Access to this e-mail by anyone else is
> unauthorized. If you are not the intended recipient, any disclosure,
> copying, distribution, action taken, or action omitted to be taken in
> reliance on it, is prohibited and may be unlawful.  If you received this
> e-mail in error, please contact the sender and delete the material from
any
> computer.
>
>
>
> -
> 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: HELP PLEASE: Error executing the example esql.xml on cocoon1.8.2

2001-12-19 Thread Marty McClelland

Title: Message



did 
you install the postgres driver on tomcat? marty

  
  -Original Message-From: Ivan Manuel 
  Andrade Muñoz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 
  December 18, 2001 9:59 AMTo: 
  [EMAIL PROTECTED]Subject: HELP PLEASE: Error executing 
  the example esql.xml on cocoon1.8.2 
  
  I have installed: Red Hat 7.2 
  Postgresql 7.1.3. 
  JDK1.3 
  JDBC: /usr/local/jdbc7.1-1.2.jar 
  Cocoon1.8.2 
  Tomcat3.2.3 
  
  Now when I try to access my pages I get the following error message 
  : 
  
  When executing the example esql.xml of the cocoon 1.8.2 that is in 
  /samples/sql/. 
  
  Cocoon 1.8.2 
   

  Error found handling the request. 
  java.lang.RuntimeException: Error loading driver: 
  org.postgresql.Driver 
  at 
  _usr._local._jakarta._build._tomcat._webapps._cocoon._samples._sql._esql.populateDocument(_esql.java:141) 

  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:865) 
  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) 
  
  --- 

  Warning: this page has been dynamically generated. 
  --- 

  
  What he/she would have to make to make work this example? 
  To add or to modify something in tomcat.properties or 
  cocoon.properties or 
  pg_hba.conf? 
  
  From already thank you for their help. 
  Iván Andrade M. 
  Punta Arenas. 
  Chile. 
  
  Con MSN Hotmail súmese al servicio de correo electrónico más grande del mundo. 
  http://www.hotmail.com/ES- 
  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 MYSQL woes

2001-12-18 Thread Marty McClelland


Take a look at the mm.mysql jar.  The jar I downloaded for mm.mysql had all
the files under another directory - so until I unzipped the files and copied
them into the tomcat classes folder - I got the same error you are
reporting.

marty
- Original Message -
From: Mauricio Souza Lima <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 18, 2001 8:36 AM
Subject: Re: C2 MYSQL woes


> See the logs, they will help you with info about the problem, it still
> cant solve, send the part that the problem happens in the log.
>
>
>
> Sharat Koya wrote:
> >
> > Hi, I have been trying for the past few days to setup MySQL with C2 in
> > order to use ESQL in my application. Unfortunately I can't get past the
> > configuration problems.
> >
> > I have installed MySQL and C2 on my WinXP machine. Do I need to setup a
> > driver for tomcat so that C2 can access MySQL on local host or can I get
> > away with just declaring it in my ESQL code. If I don't need to setup
> > the driver I tried the following code but C2 keeps returning the error
> > Resource Not Found (404).
> > Any help would be much appreciated.
> >
> > Thanks
> > Sharat Koya
> >
> > 
> >
> >  >   language="java"
> >   xmlns:xsp="http://apache.org/xsp";
> >   xmlns:esql="http://apache.org/cocoon/SQL/v2";
> > >
> >
> >   
> >
> >A Database Driven XSP Page
> >
> >
> >
> > 
> >  org.gjt.mm.mysql.Driver
> >
> > jdbc:mysql://localhost:3306/eclipse
> >  
> >  select * from planet_data
> >  
> >  
> >  
> >  
> >  
> >  Record not found
> >  
> >  
> >  Database error: 
> >  
> >  
> >  
> >  
> >
> > 
> >   
> > 
> >
> > -
> > 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]>
>
> --
> Mauricio Souza Lima
> Rational Consulting
> [EMAIL PROTECTED]
> Rua Helena, 140 / cj. 82
> São Paulo - SP - Brazil
> Fone / Direct: +55 11 3842-7138
>
> -
> 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: MS SQL Server JDBC and Cocoon Connection Pool

2001-12-04 Thread Marty McClelland


I am using MS SQL Server with C1.8.2 - but I am not using the connection
pooling feature.  At the Microsoft site - I was able to download the 3 jars
to support jdbc and put them in the tomcat lib.  Microsoft also provided a
fairly lenghty document with examples of the jdbc connection including the
port used.  The format Microsoft used for specifying the database name in
the URL was a little different from what I was familar with - but once I
followed the documentation - everything worked like a charm.

marty
- Original Message -
From: Schroeter Christian <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 04, 2001 12:56 AM
Subject: MS SQL Server JDBC and Cocoon Connection Pool


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




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

2001-11-28 Thread Marty McClelland


I had this problem when I put the mm.mysql jar in the tomcat library 6
months ago.  The problem with the jar I had was in the paths for the
drivers in the jar ( take a look in your jar ).

I worked around the problem by unzipping the files - and copying them so
the path matched.  

marty
> -Original Message-
> From: Schroeter Christian [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, November 28, 2001 11:00 AM
> To: [EMAIL PROTECTED]
> Subject: Cocoon 1.8.2 + MySQL + JDBC + Win2000 + Tomcat
> 
> 
> 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._u
> ebung3._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(XSPProces
> sor.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(ContextM
> anager.java:812)
> at 
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
> at 
> org.apache.tomcat.service.http.HttpConnectionHandler.processCo
> nnection(HttpConnectionHandler.java:213)
> at 
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoin
> t.java:416)
> at 
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPo
> ol.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._u
> ebung3._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(XSPProces
> sor.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(ContextM
> anager.java:812)
> at 
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
> at 
> org.apache.tomcat.service.http.HttpConnectionHandler.processCo
> nnection(HttpConnectionHandler.java:213)
> at 
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoin
> t.java:416)
> at 
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPo
> ol.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]>


-
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: [c1] Using Markup Symbols from a Database Field?

2001-11-28 Thread Marty McClelland


Try using get-xml instead of get-string (ie  ).

marty

> -Original Message-
> From: Derek Hohls [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 26, 2001 4:34 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [c1] Using Markup Symbols from a Database Field?
> 
> 
> Does anyone know how to pass through markup symbols from a a 
> Database Field so that they do not appear in the output 
> [HTML] file as < but rather function as the tags they were 
> intended to be - e.g. so that a database field with:
> 
> my name  your name
> 
> appears as:
> 
> my name
> your name
> 
> PS Am using ESQL tags to do the the database retrieval
> 
> 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]>


-
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: XSP namespace question

2001-11-16 Thread Marty McClelland


I use the stylesheet below to display an xml fragment from the xsp page
result.  It seems to me you could do the same thing - just have
type="text/html"

marty


http://www.w3.org/1999/XSL/Transform";
>





type="text/xml"






> -Original Message-
> From: David Rosenstrauch [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, November 16, 2001 10:41 AM
> To: [EMAIL PROTECTED]
> Subject: Re: XSP namespace question
> 
> 
> Whoops!  Meant to say:
> 
> "Would kinda suck if I ***CAN'T*** remove all the namespace 
> declarations from my HTML."
> 
> It really is making the HTML really long and ugly.
> 
> 
> DR
> 
> 
> At 09:26 AM 11/16/01 -0500, you wrote:
> >Thanks for the tip.
> >
> >I thought I tried this ... but it was really late, so maybe I did 
> >something stupid.
> >
> >On the other hand though:  I thought I saw something in my XSL book 
> >that said that 'exclude-result-prefixes' won't work when 
> you're using 
> >.  Anyone else hear that?
> >
> >Would kinda suck if I can remove all the namespace 
> declarations from my 
> >HTML.  Granted it is just cosmetic, but it's making the HTML really 
> >long and ugly.
> >
> >If anybody knows anything else, please let me know.
> >
> >
> >Thanks,
> >
> >DR
> >
> >
> >At 10:41 AM 11/16/01 +0100, you wrote:
> > >Hi David,
> > >
> > >in XSLT there is an attribute of  called 
> > >'exclude-result-prefixes'. I don't think that this will 
> work already 
> > >on the XSP, but at least in your XSL. Give it a try:
> > >
> > > > >xmlns:xsl="..">
> > >
> > >It's a whitespace-separated list.
> > >
> > >If this doesn't work (because you only copy the node), try 
> > > instead of . It gives the 
> > >same result. With  it's much more 
> difficult.
> > >
> > >But the first hint should already work.
> > >
> > >Joerg
> > >
> > >- Original Message -
> > >From: "David Rosenstrauch" <[EMAIL PROTECTED]>
> > >To: <[EMAIL PROTECTED]>
> > >Sent: Friday, November 16, 2001 9:02 AM
> > >Subject: XSP namespace question
> > >
> > >
> > > > Given an xsp page like this:
> > > >
> > > >
> > > >  > > > xmlns:xsp="http://apache.org/xsp";
> > > > language="java"
> > > >  >
> > > >  
> > > > 
> > > >
> > > >
> > > > Cocoon seems to be giving me output like this:
> > > >
> > > > http://apache.org/xsp"/>
> > > >
> > > >
> > > > Is it necessary though that the namespace declaration 
> get copied 
> > > > to the
> > >output?  It's certainly not necessary any longer once the XSP has 
> > >been run.
> > > >
> > > > Is there a way to turn off the copying of the namespace 
> like this?
> > > >
> > > > This is causing me problems later on.  My XSP page actually 
> > > > contains much
> > >more than this and when I apply a stylesheet (which uses 
> xsl:copy), 
> > >the namespace is getting copied to the HTML output.  I'd like to 
> > >avoid that if possible.
> > > >
> > > > Any ideas?
> > > >
> > > >
> > > > Tnx!
> > > >
> > > > DR
> > >
> > >
> > >
> > 
> >-
> > >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]>
> 
> 
> -
> 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: [C2] using HTML "nowrap" in a

2001-10-26 Thread Marty McClelland


I use
nowrap="nowrap"

This approach has worked so far for any standalone html attributes I've
encountered.  So, likewise
noshade="noshade"

marty
- Original Message -
From: Mark S. Kent <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 8:47 AM
Subject: [C2] using HTML "nowrap" in a 


> This is weird.
>
> I just tried putting a "nowrap" param to my  tag in my XSL file like
> this:
>   
>
> to prevent the table cell in HTML from wrapping and got this error on the
> screen:
>   Error creating the resource
> Failed to execute pipeline.
>
> and in the log:
>org.xml.sax.SAXParseException: Attribute name "td" must be followed by
> the '=' character.
>
> I was able to get "around" this by changing my tag to this:
>   
>
> While obviously not valid HTML, the browser still takes it (IE anyway --
> haven't tested with NetScrape)
>
> Comments?
> -Mark
>
>
> -
> 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: Re[2]: [C2] Accessing CLOBs as Documents

2001-10-22 Thread Marty McClelland


> Hmm.. So ar you saying that if my clobs didn't have the " version="1.0" encoding="UTF-8"?>"  then get-xml would work?
Removing the top PI worked for me - and it makes sense after thinking
about it since it is only valid when it is the first line in the
document.  When the get-xml is executed, the result is to add a node to
the current document with the value of get-xml. 

marty 




> 
> When I tried:
>
> It didn't work, but perhaps that is because it is a document.
> Thursday, October 18, 2001, 7:13:50 AM, you wrote:
> 
> MM> I have a similar application - but the clob is an xml 
> fragment ( meaning
> MM> it doesn't have processing instruction tags ).  So I can 
> use get-xml
> MM> instead of the get-ascii you use.  Then I can access data 
> in the xml
> MM> fragment with the XSL stylesheet.
> 
> MM> marty
> 
> >> -Original Message-
> >> From: Russell Castagnaro [mailto:[EMAIL PROTECTED]]
> >> Sent: Thursday, October 18, 2001 12:48 PM
> >> To: [EMAIL PROTECTED]
> >> Subject: [C2] Accessing CLOBs as Documents
> >> 
> >> 
> >> Hello cocoon-users,
> >> 
> >>   I've got a problem.
> >> 
> >>   I have a table that has a few fields and a clob in it.  I want to
> >>   use the esql taglibs or SQLTransfromer to access this as 
> a document.
> >>   The column 'doc_content' is
> >> 
> >>   currently I'm using xml like this:
> >> 
> >> 
> >> 
> >>  >>   language="java"
> >>   xmlns:xsp="http://apache.org/xsp";
> >>   xmlns:esql="http://apache.org/cocoon/SQL/v2";
> >> >
> >> 
> >>   
> >>A Database XML DOC Page
> >>
> >> 
> >> 
> >>  fun
> >>  
> >>Select * from XML_DOC where doc_id in 
> >> (select max(doc_id) from xml_doc) 
> >> 
> >>  
> >> 
> >> 
> >> >> column="doc_content"/>
> >>
> >>  
> >>
> >>  
> >>
> >> 
> >>
> >>   
> >> 
> >> 
> >> 
> >> the 'doc_content' field'  is returned escaped out:
> >> 
> >>   
> >> /templates/seattletimes/  
> >>   
> >>  >> handleError="false">header.jsp  
> >>  >> handleError="true">donation2.jsp  
> >>  >> handleError="false">footer.jsp  
> >>   
> >> error2.jsp  
> >> 
> >> 
> >> 
> >> 
> >> Is there any way to have this content integrated into the document?
> >> 
> >> 
> >> Thanks,
> >> rrc
> >> 
> >> -- 
> >> Best regards,
> >>  Russell  mailto:[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]>
> >> 
> >> 
> 
> MM> 
> -
> MM> Please check that your question has not already been 
> answered in the
> MM> FAQ before posting. 
> 
> MM> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> MM> For additional commands, e-mail: 
> <[EMAIL PROTECTED]>
> 
> 
> 
> 
> -- 
> Best regards,
>  Russellmailto:[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]>
> 
> 

-
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] Accessing CLOBs as Documents

2001-10-18 Thread Marty McClelland


I have a similar application - but the clob is an xml fragment ( meaning
it doesn't have processing instruction tags ).  So I can use get-xml
instead of the get-ascii you use.  Then I can access data in the xml
fragment with the XSL stylesheet.

marty

> -Original Message-
> From: Russell Castagnaro [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 12:48 PM
> To: [EMAIL PROTECTED]
> Subject: [C2] Accessing CLOBs as Documents
> 
> 
> Hello cocoon-users,
> 
>   I've got a problem.
> 
>   I have a table that has a few fields and a clob in it.  I want to
>   use the esql taglibs or SQLTransfromer to access this as a document.
>   The column 'doc_content' is
> 
>   currently I'm using xml like this:
> 
> 
> 
>language="java"
>   xmlns:xsp="http://apache.org/xsp";
>   xmlns:esql="http://apache.org/cocoon/SQL/v2";
> >
> 
>   
>A Database XML DOC Page
>
> 
> 
>  fun
>  
>Select * from XML_DOC where doc_id in 
> (select max(doc_id) from xml_doc) 
> 
>  
> 
> 
> column="doc_content"/>
>
>  
>
>  
>
> 
>
>   
> 
> 
> 
> the 'doc_content' field'  is returned escaped out:
> 
>   
> /templates/seattletimes/  
>   
>  handleError="false">header.jsp  
>  handleError="true">donation2.jsp  
>  handleError="false">footer.jsp  
>   
> error2.jsp  
> 
> 
> 
> 
> Is there any way to have this content integrated into the document?
> 
> 
> Thanks,
> rrc
> 
> -- 
> Best regards,
>  Russell  mailto:[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]>
> 
> 

-
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: Cocoon 1.8.2 and mySQL/ ESQL - hanging?

2001-10-18 Thread Marty McClelland


Hello Derek - 

I had a similar problem once when I moved an application to Linux - and
tried to run it before all the appropriate jars were in place.  Then
after putting the jars in the lib - the app still failed.  I finally
realized the problem was that tomcat had generated code for the xsp
pages the first time I tried to run the app - and did not regenerate
after I added the jars.

The generated code is stored in the repository directory for tomcat.  I
deleted the generated code for the xsp page - then tried to execute it
again - THEN it worked!

I can't tell from your description of the problem if this could be the
cause - but thought I'd pass this along just in case...

marty

> -Original Message-
> From: Derek Hohls [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 2:38 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Cocoon 1.8.2 and mySQL/ ESQL - hanging?
> 
> 
> Lajos 
> 
> Thanks for the suggestions.  In response:
> 
> 1.  Where do I find the  mysql_comp.jar you refer to (I do 
> not have it on my Windows test machine) and a quick scan at 
> the mysql site did not reveal anything either... all I have 
> is the mm.mysql driver (as seen below) which is in the Java lib.
> 
> 2. I cannot run the supplied esql examples as they depend on 
> having the postgresql database installed...
>   org.postgresql.Driver
>   jdbc:postgresql://localhost/test
>   test
>   test
> 
> Thanks
> Derek
> 
> >>> [EMAIL PROTECTED] 17/10/2001 05:11:43 >>>
> Derek:
> 
> I assume that the MySQL jar is in the classpath? Depending on the 
> version of Tomcat you're running, you'll want mysql_comp.jar 
> in either 
> $TOMCAT_HOME/lib or $TOMCAT_HOME/common/lib.
> 
> Another idea is to run one of the supplied esql examples just to make 
> sure that the taglib is working correctly.
> 
> Lajos
> 
> 
> Derek Hohls wrote:
> 
> > I have a Cocoon system which fine on a setup under Win2000 
> as a localhost (Apache/Tomcat); but when I upload it to our 
> UNIX server, also  running Apache/Tomcat (which has just been 
> setup to handle Cocoon - so we are still in 'testing' mode) - 
> the app just hangs...
> > 
> > The XML page is given below (altho' I do not think it is a 
> syntax problem) - the MySQL part works OK if I logon to the 
> server and run tests from the command line interface...  
> Cocoon also handles normal XML pages fine, and the 
> cocoon.properties file include the esql taglib.
> > 
> > Any ideas as to where the 'hangup' might be or what part of 
> the system I should look at it to try and see where it is 
> getting to?  My UNIX knowledge is very very basic (at best).
> > 
> > All help much appreciated!
> > 
> > Derek
> > 
> > *
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >  >   xmlns:xsp="http://www.apache.org/1999/XSP/Core";
> >   xmlns:esql="http://apache.org/cocoon/SQL/v2";
> > xmlns:request="http://www.apache.org/1999/XSP/Request";
> > 
> > 
> > 
> > 
> > 
> >   org.gjt.mm.mysql.Driver
> >   jdbc:mysql://myhost.com/est
> >   est
> >   est
> > 
> >
> > SELECT * FROM computer
> >  
> >   
> > 
> >
> >  
> >   
> >  
> >
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> -
> > 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]>
> 
> 
> 
> -
> 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: session and xsl

2001-10-18 Thread Marty McClelland


I use C1.8.2 and have the following code to access the session:
HttpSession theUserSession = request.getSession(); 
String theLoginName = (String) theUserSession.getAttribute("loginName");


marty 

> -Original Message-
> From: Mark S. Kent [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 16, 2001 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: RE: session and xsl
> 
> 
> This is what I have in C1 in my XSP code:
> 
> 
> EmployeeData employeeData = null;
> try
> {
>   employeeData = (EmployeeData)session.getAttribute( "employee" );
> }
> catch( ClassCastException e ) {}
> 
> Integer empID = null;
> if( employeeData != null )
> {
>   System.out.println( "Data ID: " + 
> employeeData.getEmployee_id() );
>   empID = employeeData.getEmployee_id();
> }
> else
> {
>   System.out.println( "Data ID: none" );
>   empID = new Integer( -1 );
> }
> 
> 
> The line:
> 
>   employeeData = (EmployeeData)session.getAttribute( "employee" );
> 
> is exactly how I do it in my JSP pages.  When I test for "null" on the
> employeeData object, however, it is always "null".  It may be a C1
> limitation.  We are looking at C2 because of the additional features.
> 
> Is there a "request" object for the session variable?  
> Currently I retrieve
> session variables as above and have only done "requests" for form/URL
> variables.
> 
> Mark
> 
> -Original Message-
> From: Christian Haul [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 16, 2001 1:35 PM
> To: [EMAIL PROTECTED]; Mark Kent
> Subject: Re: session and xsl
> 
> 
> On 16.Oct.2001 -- 09:14 AM, Mark S. Kent wrote:
> > I also have an interest on retrieving session values in my 
> XML file to
> help
> > build the XML data.  I thought that XSP would be able to 
> read them as my
> JSP
> > pages do since both run under Tomcat, but am having trouble 
> seeing them
> from
> > the XML document.
> 
> Mark, accessing session attributes from XSP ist piece of cake :-)
> There's a logicsheet aka taglib for it. Otherwise use the request
> object and access the data through ordinary java.
> 
> > Chris, is the solution you mention below only available in C2?
> 
> Which one of the two alternatives? Honestly, I don't know about C1,
> there might be a session taglib but passing parameters from a non
> existant sitemap won't do :-)
> 
> 
> > From: Christian Haul [mailto:[EMAIL PROTECTED]]
> > On 15.Oct.2001 -- 04:35 PM, Mohamed Ramzy wrote:
> > > hi all,
> > > i'm trying to read session variables through .xsl
> > > file, if you have any idea how to do that, please tell
> >
> > No way. At least from a stylesheet. Pass parameters from sitemap
> > instead. For a taglib, just use session taglib within your taglib.
> 
>   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: MySQL Drivers - Cocoon 1.8.2

2001-10-05 Thread Marty McClelland

Try
making the change below to the cocoon properties file ( change DBMySQL to DBMM
). This worked for me.
processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver
here's
how I defined the connection pool:
processor.xsp.pool.database.iluminaPool.driver=org.gjt.mm.mysql.Driverprocessor.xsp.pool.database.iluminaPool.url=jdbc:mysql://localhost/iluminaprocessor.xsp.pool.database.iluminaPool.username=mmartyprocessor.xsp.pool.database.iluminaPool.password=**
marty

-Original Message-From: Colm O'Riordan
[mailto:[EMAIL PROTECTED]]Sent: Friday, October 05, 2001 7:29
PMTo: [EMAIL PROTECTED]Subject: MySQL Drivers
- Cocoon 1.8.2Hi All,
I am using Cocoon, running on Linux with the MySQL database and have set up
my own connection pool in Cocoon.properties.
I point to the MySQL Driver as follows:
processor.xsp.pool.database.power.driver=org.gjt.mm.mysql.Driver
processor.xsp.pool.database.power.url=jdbc:mysql:@localhost:3306?database=power

This driver location I copied from Cocoon's own properties, ie ...
processor.xsp.pool.database.adaptor.DBMySQL=org.gjt.mm.mysql.Driver
I am relatively new to configuring Linux boxes so I may be missing
something blatantly obvious here. It is throwing the following error upon
trying to display an XML with database calls :
Error found handling the request. java.lang.RuntimeException:
Error opening pooled connection: power: Database type org.gjt.mm.mysql.Driver
not implemented.
I had been assuming that if Cocoon references this Driver in its own
properties file under the heading : # These are the supported
jdbc-drivers and their adaptors. then pointing to these drivers in my
own connection pool would be enough.
Is there something else I should be doing ?
Any help hugely appreciated at this stage !
Thanks,
ColmOR.

ide recommendations?

2001-10-02 Thread Marty McClelland


For the past six months I have been using notepad for writing xsp and xsl
pages. This works - but I miss the debugging tools of an ide.

Does anyone have experience with an ide that is useful in debugging xsp/xsl
pages?

marty


-
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: esql nested query not working - 1.8.2

2001-09-19 Thread Marty McClelland


the error message is the same with and without the quotes - for string
parameters or int parameters. i've tried numerous combinations.  if i put in
an explicit value it works - but i can get it to reference a parameter from
the result set from Access.  It will work if the backend is MySQL.

>From the reading I've done today - the MS Access ODBC driver does not
support nested transactions according to the microsoft support site.  So I'm
thinking the problem with the nested query is specific to Access.

marty

- Original Message -
From: Christopher Painter-Wakefield <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 6:57 AM
Subject: Re: esql nested query not working - 1.8.2


>
> do you get a different error message when you leave out the quotes?
>
>
>
>
> Please respond to [EMAIL PROTECTED]
>
> To:   <[EMAIL PROTECTED]>
> cc:
>
> Subject:  Re: esql nested query not working - 1.8.2
>
>
> I've tried it both with and without the single quote and it still doesn't
> work.
>
> Here is another clue - the nested query works if I run it against a MySQL
> database, it just doesn't work against a Access database.
>
> In a couple of months - we'll be converting the access database.  In the
> meantime, is there a solution ( that will work with the access database )?
>
> marty
> - Original Message -
> From: Christopher Painter-Wakefield <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 18, 2001 9:41 AM
> Subject: Re: esql nested query not working - 1.8.2
>
>
>
> Try removing the single quotes around  ="string">
>
> I think by including the single quotes you are making a query that doesn't
> use parameters (your where clause looks like "... Main.rid = '?' ", e.g.,
> the literal string '?').
>
> -Christopher
>
>
>
>
> Please respond to [EMAIL PROTECTED]
>
> To:   <[EMAIL PROTECTED]>
> cc:
>
> Subject:  esql nested query not working - 1.8.2
>
>
>
>
> I would like to execute a nested query. When  I try to reference a
> parameter from the ancestor query I get a  java.lang.RuntimeException:
> Error setting parameter on statement : Select title  from Main where
> Main.rid='?'
>
> I would greatly appreciate any suggestions. I  have tried to emulate the
> example esql - but I can not get it to pick up the  parameter. If I
> hardcode the value - the nested query works.
>
> In searching the list - I found a similar posting in January for this
error
> - but no suggestion/solution was posted.
>
> I am running tomcat/cocoon 1.8.2 on Windows 98 and pointing to an access
> database.
>
> marty
>
>
> I am attaching the related code below:
>
>
> 
>
> 
>
> Select title from Main where Main.rid=' ="string"> ="rid"/>'
>
> 
>
>
>
>
>
> -
> 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: esql nested query not working - 1.8.2

2001-09-18 Thread Marty McClelland


I've tried it both with and without the single quote and it still doesn't
work.

Here is another clue - the nested query works if I run it against a MySQL
database, it just doesn't work against a Access database.

In a couple of months - we'll be converting the access database.  In the
meantime, is there a solution ( that will work with the access database )?

marty
- Original Message -
From: Christopher Painter-Wakefield <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 18, 2001 9:41 AM
Subject: Re: esql nested query not working - 1.8.2



Try removing the single quotes around 

I think by including the single quotes you are making a query that doesn't
use parameters (your where clause looks like "... Main.rid = '?' ", e.g.,
the literal string '?').

-Christopher




Please respond to [EMAIL PROTECTED]

To:   <[EMAIL PROTECTED]>
cc:

Subject:  esql nested query not working - 1.8.2




I would like to execute a nested query. When  I try to reference a
parameter from the ancestor query I get a  java.lang.RuntimeException:
Error setting parameter on statement : Select title  from Main where
Main.rid='?'

I would greatly appreciate any suggestions. I  have tried to emulate the
example esql - but I can not get it to pick up the  parameter. If I
hardcode the value - the nested query works.

In searching the list - I found a similar posting in January for this error
- but no suggestion/solution was posted.

I am running tomcat/cocoon 1.8.2 on Windows 98 and pointing to an access
database.

marty


I am attaching the related code below:






Select title from Main where Main.rid=''






-
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: cocoon 2 tutorial

2001-09-17 Thread Marty McClelland


I have been working with 1.8.2 for about 6 months and I have considered
putting the material into a tutorial.  What suggestions do folks have
for the format for a tutorial?  Is there a suggested journal or magazine
for publication?  or is there a site for tutorials?

marty

-Original Message-
From: Jesper Rasmussen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 11:22 AM
To: [EMAIL PROTECTED]
Subject: cocoon 2 tutorial


Does anyone know if anyone is working on making one or has done one?
I'm thinking about doing one.
Like one of thouse first pick up the spoon, then you ...
I allways find thouse very helpfull get get some hands-on expirence
before
diving in to the theory. And when i started with cocoon i could not find
one, so i had to do it the hard way :)

HOWEVER im a newbie in cocoon, so what i probably would do is write what
i
believe to be the truth, and how i can make it work, and let you COCOON
GURU's out there give me hell with all the mistakes :) and the vola we
have a good tutorial :)

cheers
Jesper
- May the source be with you, Linux -


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

esql nested query not working - 1.8.2

2001-09-17 Thread Marty McClelland





I would like to execute a nested query.  When 
I try to reference a parameter from the ancestor query I get a 
java.lang.RuntimeException: Error setting parameter on statement : Select title 
from Main where Main.rid='?'
I would greatly appreciate any suggestions.  I 
have tried to emulate the example esql - but I can not get it to pick up the 
parameter.  If I hardcode the value - the nested query works.
 
In searching the list - I found a similar posting in January for this error 
- but no suggestion/solution was posted.  
 
I am running tomcat/cocoon 1.8.2 on Windows 98 and pointing to an access 
database.  
 
marty
 
I am attaching the related code below:





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


String table = request.getParameter("table");
String column = request.getParameter("column");
String value = request.getParameter("value");

value
table
column


sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:imsdb

 

Select rid from table 
where column = 
'value' order by rid




sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:imsdb

 


Select title from Main where Main.rid=''













package _C_._tomcat._webapps._ilumina;
import java.io.*;
import java.net.*;
import java.util.*;
import org.w3c.dom.*;
import org.xml.sax.*;
import javax.servlet.*;
import javax.servlet.http.*;
import org.apache.cocoon.parser.*;
import org.apache.cocoon.producer.*;
import org.apache.cocoon.framework.*;
import org.apache.cocoon.processor.xsp.*;
import org.apache.cocoon.processor.xsp.library.*;
/* User Imports */

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.Statement;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.text.SimpleDateFormat;

import java.text.DecimalFormat;

import java.io.StringWriter;

import java.io.PrintWriter;

import org.apache.turbine.services.db.PoolBrokerService;

import org.apache.turbine.util.db.pool.DBConnection;

public class _browseResults extends XSPPage {
/* User Class Declarations */

static PoolBrokerService _esql_pool = PoolBrokerService.getInstance();


class EsqlConnection {

DBConnection db_connection = null;


Connection connection = null;
String dburl = null;
String username = null;
String password = null;
}
class EsqlQuery {
String query;
Statement statement;
PreparedStatement prepared_statement;
ResultSet resultset;
ResultSetMetaData resultset_metadata;
/** the position of the current row in the resultset **/
int position = -1;
int max_rows = -1;
int skip_rows = 0;
boolean results;
}

public void populateDocument(
HttpServletRequest request,
HttpServletResponse response,
Document document
)
throws Exception
{
// Node stack logic variables
Node xspParentNode = null;
Node xspCurrentNode = document;
Stack xspNodeStack = new Stack();



// Make session object readily available
HttpSession session = request.getSession(false);

xspParentNode = xspCurrentNode;
xspNodeStack.push(xspParentNode);
xspCurrentNode =
document.createElement("page");
xspParentNode.appendChild(xspCurrentNode);

Stack _esql_connections = new Stack();
EsqlConnection _esql_connection = null;
Stack _esql_queries = new Stack();
EsqlQuery _esql_query = null;
SQLException _esql_exception = null;
StringWriter _esql_exception_writer = null;

xspCurrentNode.appendChild(
document.createTextNode("\n")
);

String table = request.getParameter("table");
String column = request.getParameter("column");
String value = request.getParameter("value");
 
xspCurrentNode.appendChild(
document.createTextNode("\n\n")
);

xspParentNode = xspCurrentNode;
xspNodeStack.push(xspParentNode);
xspCurrentNode =
document.createElement("browsevalue");
xspParentNode.appendChild(xspCurrentNode);

xspCurrentNode.appendChild(
xspExpr(value, document)
);

((Element) xspCurrentNode).normalize();
xspCurrentNode = (Node) xspNodeStack.pop();

xspCurrentNode.appendChild(
document.createTextNode("\n")
);

xspParentNode = xspCurrentNode;
xspNodeStack.push(xspParentNode);
xspCurrentNode =
document.createElement("browsetable");
xspParentNode.appendChild(xspCurrentNode);

xspCurrentNode.appendChild(
xspExpr(table, document)
);

((Element) xspCurrentNode).normalize();
xspCurrentNode = (Node) xspNodeStack.pop();

xspCurrentNode.appendChild(
document.createTextNode("\n \n")
);

xspParentNode = xspCurrentNode;
xspNodeStack.push(xspParentNode);
xspCurrentNode =
document.createElement("browsecolumn");
xspParentNode.appendChild(xspCurrentNode);

xspCurrentNode.appendChild(
xspExpr(column, document)
);

((Element) xspCurrentNode).normalize();
xspCurrentNode = (Node) xspNodeStack.pop();

xspCurrentNode.appendChild(
document.createTextNode("\n \n \n")
);

if (_esql_connection != null) {
_esql_connections.push(_esql_connection);
}
_esql_connection = new EsqlConnection();
try {

try {
Class.forName(String.valueOf(
"sun.jdbc.odbc.JdbcOdbcDriver"
)).newInstance();
} catch (Exception _esql_exception_N4a96a) {
thr

Re: Does anyone remember cocoon 1.8?

RE: Help Requested!!!!

Re: Esql row-results

RE: MS Access on Cocoon2???

Re: Cocoon 1.8.2

Re: Why isn't Cocoon making into the commerical world?

RE: Update on my problem

RE: Cocoon2: couldn't make nested queries work for ESQL in XSP.

cocoon 2 tutorial

RE: XML for describing databases?

thanks for sharing your expertise Vadim

RE: Viewing XSP output with IE5.5

RE: Cocoon 2 with VAJ 4 and WTE

RE: My Cocoon Tutorial is Online!

Re: Evaluating Variable XPATH

Re: Big problem with IE!

Re: HELP: Error opening connection to dburl: jdbc:postgresql://localhost/test

Re: Cocoon 1.8.2 on Tomcat w/IIS

RE: HELP PLEASE: Error executing the example esql.xml on cocoon1.8.2

Re: C2 MYSQL woes

Re: MS SQL Server JDBC and Cocoon Connection Pool

RE: Cocoon 1.8.2 + MySQL + JDBC + Win2000 + Tomcat

RE: [c1] Using Markup Symbols from a Database Field?

RE: XSP namespace question

Re: [C2] using HTML "nowrap" in a

RE: Re[2]: [C2] Accessing CLOBs as Documents

RE: [C2] Accessing CLOBs as Documents

RE: Cocoon 1.8.2 and mySQL/ ESQL - hanging?

RE: session and xsl

RE: MySQL Drivers - Cocoon 1.8.2

ide recommendations?

Re: esql nested query not working - 1.8.2

Re: esql nested query not working - 1.8.2

RE: cocoon 2 tutorial

esql nested query not working - 1.8.2

35 matches

Site Navigation

Mail list logo

Footer information