Missing API Doc?
http://xml.apache.org/cocoon/apidocs/org/apache/cocoon/transformation/AbstractSAXTransformer.html gives a 404 error. __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQLTransformer
The queries are definitely not taking 130ms outside of cocoon. What do you mean by turning off debugging? I've changed the logging status to ERROR, and saw some improvement. What did you turn off, and how did you do so? Thanks! :) - Josh --- Tom Klaasen [EMAIL PROTECTED] wrote: Hi Joshua, Did you perform the same test outside of cocoon? You should check how long it actually takes for MySql to answer your query. If this is much faster than those 130 ms, there might be a problem. Also note that turning of debugging in Cocoon has given me a 10 times speedup once. Maybe you don't consider 13ms for 2 queries so slow ;-) Please keep us posted on your findings, tomK Joshua McCulloch wrote: Hello, I've been looking at page generating times with the profiler. I am finding that SQLTransoformer is taking a huge amount of time to do what I consider simple queries. For example, a page that has two minor queries takes about 130ms to complete. Combined there are about 20 rows being returned. Would you expect lower times? Running: Cocoon 2.0.2 Orion Server 1.5.4 Jdk 1.3.1 Mysql 3.23.49 MM jdbc drivers __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQLTransformer
jdbc name=myhms-datasource logger=core.datasources.myhms-datasource pool-controller min=5 max=10/ dburljdbc:mysql://localhost/ccc/dburl useraaa/user passwordbbb/password /jdbc According to the datasource configuration in cocoon.xconf, it should be pooling. The logs (core.log) seem to say its pooling: ApplicationServerThread/LogKitLogger: Got a org.apache.avalon.excalibur.datasource.JdbcConnection from the pool. ApplicationServerThread/LogKitLogger: Put a org.apache.avalon.excalibur.datasource.JdbcConnection back into the pool. Are there any other ways to determine if pooling is truly being used? I guess I could look around in MySQL, I'm sure it keeps logs of connections somewhere.. Thanks, Josh --- Bruno Dumon [EMAIL PROTECTED] wrote: Are you sure you are using connection pooling? If not, then the above times seem reasonable. -- Bruno Dumon http://outerthought.org/ Outerthought - Open Source, Java XML Competence Support Center [EMAIL PROTECTED] __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
J2EE Datasources
Hello, I'd like to know if anyone is using J2EE defined datasources in Cocoon? I'm trying unsucessfully to connect to a MySQL database using the Orion J2EE server. I've defined a datasource in Orion: data-source name=Mysql class=com.evermind.sql.DriverManagerDataSource schema=database-schemas/mysql.xml location=jdbc/MysqlDS xa-location=jdbc/xa/MysqlXADS ejb-location=jdbc/MysqlDS connection-driver=org.gjt.mm.mysql.Driver username=root password= url=jdbc:mysql://localhost/myhms inactivity-timeout=30 / I can get a javax.sql.DataSource using the following code from within a custom class called by a custom Transformer: DataSource ds = (DataSource) new InitialContext().lookup(jdbc/MysqlDS); I then defined this datasource in cocoon.xconf: j2ee name=myhms-datasource dbnameMysqlDS/dbname /j2ee When Cocoon starts, this occurs in the error.log: ERROR (2002-06-27) 11:58.24:441 [core.datasources.myhms-datasource] (Unknown-URI) Unknown-thread/LogKitLogger: Problem with JNDI lookup of datasource javax.naming.NameNotFoundException: jdbc/MysqlDS not found in Cocoon2 Demo at com.evermind._lj.lookup(.:49) at com.evermind._bm._es(.:121) at com.evermind._bm.lookup(.:63) at javax.naming.InitialContext.lookup(InitialContext.java:345) at org.apache.avalon.excalibur.datasource.J2eeDataSource.configure(J2eeDataSource.java:63) at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:172) at org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:84) at org.apache.avalon.excalibur.component.ExcaliburComponentSelector.addComponent(ExcaliburComponentSelector.java:467) at org.apache.avalon.excalibur.component.ExcaliburComponentSelector.configure(ExcaliburComponentSelector.java:354) at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:172) at org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:84) at org.apache.avalon.excalibur.component.ExcaliburComponentManager.initialize(ExcaliburComponentManager.java:167) at org.apache.cocoon.Cocoon.initialize(Cocoon.java:269) at org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java:1212) at org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:407) I haven't worked with JNDI before. What am I missing? I looked at J2eeDataSource.java and found it was calling InitialContext.lookup( java:comp/env/jdbc/ + MysqlDS) I tried changing the datasource location attribute to java:comp/env/jdbc/MysqlDS which didn't do anything, not that I was really expecting it to... __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]