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

2003-04-12 Thread Stavros Kounis


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

and i get the follow error msg

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

error msg:

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



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

// end error

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

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


xconf entry in datasources:
jdbc name=othello
pool-controller max=10 min=5/
auto-commitfalse/auto-commit
dburljdbc:mysql://192.168.0.50:3306/othello/dburl
userroot/user
/jdbc


web.xml entry in init-param:
!--
java.sql.DriverManager --
org.gjt.mm.mysql.Driver

i have use
jakarta-tomcat-4.1.17
winxp

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

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


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

i get the results (queriy results) without errors


-- stavros


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



Re: XMLForm Question

2003-04-12 Thread Antonio Gallardo
I think the problem can be related with the improper shutdown of the
current CVS 2.1 with Tomcat. Try to kill the process after the shutdown.

Antonio Gallardo.

JD Daniels dijo:
 Yes, I guess I should have mentioned that I did in fact delete my tomcat
 work directory, shutdown and startup. It did not make a difference...
 hence my frustration :)

 I know that when I get this crap figured out, I will never hack php
 again :D The trick is getting it figured heh heh.

 JD
   - Original Message -
   From: David Kavanagh
   To: [EMAIL PROTECTED]
   Sent: Saturday, April 12, 2003 9:05 AM
   Subject: Re: XMLForm Question


   I think you just need to restart the container (in your case, tomcat).
 In theory, Tomcat use an adaptive classloader that you can configure
 (in server.xml) to reload classes when they change. I was able to use
 this feature when my web app was simple. Once I started having more
 statefull information in memory, I really needed to restart the whole
 app (and tomcat) when I changed my code.  BTW, If you were to use
 JBoss/Jetty, you should be able to take advantage of the JBoss
 hot-deploy feature. The idea being if you touch the web.xml under
 cocoon, jboss should redeploy the app, and pick up your code change.
 At this point, JBoss exits when I try this. I'm sure I'm doing
 something wrong.

   David

   JD Daniels wrote:

 Thanks for the answer Sylvain

 That was what I had thought... after I restarted my machine, it all
 started working.




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



Dynamic link generation in XSP...???

2003-04-12 Thread Gautam Ganguly
hi there,
   How do i generate a dynamic link like this in my xsp page:based on a
column value(=id) returned from a database .Here edit-item.html is the
sitemap match pattern which will be called when someone clicks on the
link and the corresponding itemid will get passed to it as a request
parameter.

 http://10.1.2.3/cocoon/testapp/admin/edit-item.html?itemid=1234

esql:connection
esql:poolprodora/esql:pool
esql:execute-query
  esql:query 
   SELECT id,name from item_list   
  /esql:query
  pItems List/p
esql:results
  table
thItem Id/th
thItem Name/th
 esql:row-results
 tr
tdesql:get-string column=id//td
!-- this is where i want to use the linkhref=edit-tem.html?itemid=
--
tdesql:get-string column=name//td
/tr
   /esql:row-results

hope someone would have already got something like this working.The
samples that came with cocoon have submit buttons next to them..which is
not what i want..any suggestions or help would be appreciated.

thanks
gautam


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