Missing API Doc?

[Joshua McCulloch]

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. 

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

Re: SQLTransformer

[Joshua McCulloch]

jdbc:mysql://localhost/ccc
aaa
bbb


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. 

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

Re: SQLTransformer

[Joshua McCulloch]

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

SQLTransformer

[Joshua McCulloch]

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. 

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

J2EE Datasources

[Joshua McCulloch]

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:



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:


  MysqlDS


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. 

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