You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Johannes Hoechstaedter <j....@memocomp.de> on 2008/06/05 18:33:35 UTC
Database connection by cocoon 2.2
Hi,
I do my first experiences in cocoon, and want to create a database
webapplication which connects to a database. I did some first steps to a
database application. Is there a complete how to, to etablish a database
connection (for read and write access) by cocoon 2.2?
What I already did:
* I did all steps for a first cocoon application which are described in
http://cocoon.apache.org/2.2/1159_1_1.html . That works.
* The I added a file databases-driver.properties with the path of the
driver into META_INF/cocoon/properties, as described in the migration
guide (http://cocoon.apache.org/2.2/blocks/databases/1.0/1409_1_1.html).
* The I added the dependency for cocoon-databases-impl into my pom.xml
as described in the documentation about the block
http://cocoon.apache.org/2.2/blocks/databases/1.0/1437_1_1.html .
But I have not managed to etablish a connection.
There are some for me quite understandable descriptions for cocoon 2.1
on http://cocoon.apache.org/2.1/developing/datasources.html . But I
don't know if these are good for 2.2.
Maybe some more informations are necessary: The application should be
run on tomcat, and manage a connection to a mysql or oracle database.
Thank you for every help in advance.
Johannes
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Boris Goldowsky <bg...@cast.org>.
I haven't investigated what the databases block does in 2.2. In Cocoon
2.1, you could use it for simple database queries just by giving it a
JDBC connection; but since it didn't help much with database updating,
we never used it much. I imagine much the same is true in 2.2.
However, I do have something that may be useful to contribute, which is
a working sample application. I will post that in a separate thread.
Bng
On Fri, 2008-06-06 at 10:05 +0200, Johannes Hoechstaedter wrote:
> Good morning Bng,
>
> I know, cocoon is based on spring. But isn't there another possibility
> with cocoon blocks only? There is this database-block. What it is good
> for, when I have to write my own spring application? I want to write as
> less code as possible.
>
> Johannes
>
> > Johannes -- you may want to search for tutorials on using databases with
> > Spring. My understanding is that with Cocoon 2.2 it is best to have
> > Spring configure and manage any database connections. Then you can add
> > Cocoon features (eg, the SQL transformer or whatever) once that is set
> > up.
> >
> > Bng
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Joerg Heinicke <jo...@gmx.de>.
On 23.07.2008 08:00, Derek Hohls wrote:
> Not sure if you are speaking for the dev team here?
No, that was my opinion.
> What exactly does "kind of obsolete" mean - has it
> been deprecated, or is it still a valid component in 2.2?
> Or is there is some other meaning?
I'm not a native English speaker but I think "obsolete" is exactly what
I want to express: It's still there, you are free to use it, but you
don't need to since there are superior ways to do it like the DAO
support provided by Spring. I did not intent any additional meaning than
that (like deprecation).
Joerg
>>>> On 2008/07/19 at 01:08, in message <48...@gmx.de>, Joerg Heinicke <jo...@gmx.de> wrote:
> I agree with Boris. In Cocoon 2.2 the database block is kind of
> obsolete. An application should rather be developed with more standard
> means as provided by Spring. Cocoon was never very good at integrating
> database stuff.
>
> Joerg
>
> On 06.06.2008 10:05, Johannes Hoechstaedter wrote:
>
>> I know, cocoon is based on spring. But isn't there another possibility
>> with cocoon blocks only? There is this database-block. What it is good
>> for, when I have to write my own spring application? I want to write as
>> less code as possible.
>>
>> Johannes
>>
>>> Johannes -- you may want to search for tutorials on using databases with
>>> Spring. My understanding is that with Cocoon 2.2 it is best to have
>>> Spring configure and manage any database connections. Then you can add
>>> Cocoon features (eg, the SQL transformer or whatever) once that is set
>>> up.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Derek Hohls <DH...@csir.co.za>.
Joerg
Not sure if you are speaking for the dev team here?
What exactly does "kind of obsolete" mean - has it
been deprecated, or is it still a valid component in 2.2?
Or is there is some other meaning?
Thanks.
>>> On 2008/07/19 at 01:08, in message <48...@gmx.de>, Joerg Heinicke <jo...@gmx.de> wrote:
I agree with Boris. In Cocoon 2.2 the database block is kind of
obsolete. An application should rather be developed with more standard
means as provided by Spring. Cocoon was never very good at integrating
database stuff.
Joerg
On 06.06.2008 10:05, Johannes Hoechstaedter wrote:
> I know, cocoon is based on spring. But isn't there another possibility
> with cocoon blocks only? There is this database-block. What it is good
> for, when I have to write my own spring application? I want to write as
> less code as possible.
>
> Johannes
>
>> Johannes -- you may want to search for tutorials on using databases with
>> Spring. My understanding is that with Cocoon 2.2 it is best to have
>> Spring configure and manage any database connections. Then you can add
>> Cocoon features (eg, the SQL transformer or whatever) once that is set
>> up.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
--
This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard.
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.
This message has been scanned for viruses and dangerous content by MailScanner,
and is believed to be clean. MailScanner thanks Transtec Computers for their support.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Joerg Heinicke <jo...@gmx.de>.
I agree with Boris. In Cocoon 2.2 the database block is kind of
obsolete. An application should rather be developed with more standard
means as provided by Spring. Cocoon was never very good at integrating
database stuff.
Joerg
On 06.06.2008 10:05, Johannes Hoechstaedter wrote:
> I know, cocoon is based on spring. But isn't there another possibility
> with cocoon blocks only? There is this database-block. What it is good
> for, when I have to write my own spring application? I want to write as
> less code as possible.
>
> Johannes
>
>> Johannes -- you may want to search for tutorials on using databases with
>> Spring. My understanding is that with Cocoon 2.2 it is best to have
>> Spring configure and manage any database connections. Then you can add
>> Cocoon features (eg, the SQL transformer or whatever) once that is set
>> up.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Johannes Hoechstaedter <j....@memocomp.de>.
Good morning Bng,
I know, cocoon is based on spring. But isn't there another possibility
with cocoon blocks only? There is this database-block. What it is good
for, when I have to write my own spring application? I want to write as
less code as possible.
Johannes
> Johannes -- you may want to search for tutorials on using databases with
> Spring. My understanding is that with Cocoon 2.2 it is best to have
> Spring configure and manage any database connections. Then you can add
> Cocoon features (eg, the SQL transformer or whatever) once that is set
> up.
>
> Bng
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Boris Goldowsky <bg...@cast.org>.
You probably already have looked at it, but the documentation on
springframework.org is actually very good (something for Cocoon to
aspire to ;-) -- the section on database access is at
http://static.springframework.org/spring/docs/2.5.x/reference/jdbc.html
You can certainly work with the Spring database API directly and not
involve Hibernate if you so choose. We use Hibernate because we like to
conceptualize a database as holding Java objects, not just tables of
data.
Bng
On Fri, 2008-06-06 at 08:45 +0200, Derek Hohls wrote:
> Bng
>
> It would be very useful if you, or anyone in the community, could identify or
> recommend such tutorials - on a quick search I was not able to find
> anything useful - although:
> http://www.codesuccess.com/tutorials/spring/pagination/
> and
> http://www.netbeans.org/kb/61/web/quickstart-webapps-spring.html
> might be related.
>
> Not sure if there anyway of doing this with Spring alone - does one also
> need Hibernate (more stuff to learn!!)
>
> Derek
>
> >>> On 2008/06/05 at 07:57, in message <12...@ant.moxyledge.org>, Boris Goldowsky <bg...@cast.org> wrote:
> Johannes -- you may want to search for tutorials on using databases with
> Spring. My understanding is that with Cocoon 2.2 it is best to have
> Spring configure and manage any database connections. Then you can add
> Cocoon features (eg, the SQL transformer or whatever) once that is set
> up.
>
> Bng
>
>
>
> On Thu, 2008-06-05 at 18:33 +0200, Johannes Hoechstaedter wrote:
> > Hi,
> >
> > I do my first experiences in cocoon, and want to create a database
> > webapplication which connects to a database. I did some first steps to a
> > database application. Is there a complete how to, to etablish a database
> > connection (for read and write access) by cocoon 2.2?
> >
> > What I already did:
> >
> > * I did all steps for a first cocoon application which are described in
> > http://cocoon.apache.org/2.2/1159_1_1.html . That works.
> > * The I added a file databases-driver.properties with the path of the
> > driver into META_INF/cocoon/properties, as described in the migration
> > guide (http://cocoon.apache.org/2.2/blocks/databases/1.0/1409_1_1.html).
> > * The I added the dependency for cocoon-databases-impl into my pom.xml
> > as described in the documentation about the block
> > http://cocoon.apache.org/2.2/blocks/databases/1.0/1437_1_1.html .
> >
> > But I have not managed to etablish a connection.
> >
> > There are some for me quite understandable descriptions for cocoon 2.1
> > on http://cocoon.apache.org/2.1/developing/datasources.html . But I
> > don't know if these are good for 2.2.
> >
> > Maybe some more informations are necessary: The application should be
> > run on tomcat, and manage a connection to a mysql or oracle database.
> >
> > Thank you for every help in advance.
> > Johannes
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> > For additional commands, e-mail: users-help@cocoon.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Derek Hohls <DH...@csir.co.za>.
Bng
It would be very useful if you, or anyone in the community, could identify or
recommend such tutorials - on a quick search I was not able to find
anything useful - although:
http://www.codesuccess.com/tutorials/spring/pagination/
and
http://www.netbeans.org/kb/61/web/quickstart-webapps-spring.html
might be related.
Not sure if there anyway of doing this with Spring alone - does one also
need Hibernate (more stuff to learn!!)
Derek
>>> On 2008/06/05 at 07:57, in message <12...@ant.moxyledge.org>, Boris Goldowsky <bg...@cast.org> wrote:
Johannes -- you may want to search for tutorials on using databases with
Spring. My understanding is that with Cocoon 2.2 it is best to have
Spring configure and manage any database connections. Then you can add
Cocoon features (eg, the SQL transformer or whatever) once that is set
up.
Bng
On Thu, 2008-06-05 at 18:33 +0200, Johannes Hoechstaedter wrote:
> Hi,
>
> I do my first experiences in cocoon, and want to create a database
> webapplication which connects to a database. I did some first steps to a
> database application. Is there a complete how to, to etablish a database
> connection (for read and write access) by cocoon 2.2?
>
> What I already did:
>
> * I did all steps for a first cocoon application which are described in
> http://cocoon.apache.org/2.2/1159_1_1.html . That works.
> * The I added a file databases-driver.properties with the path of the
> driver into META_INF/cocoon/properties, as described in the migration
> guide (http://cocoon.apache.org/2.2/blocks/databases/1.0/1409_1_1.html).
> * The I added the dependency for cocoon-databases-impl into my pom.xml
> as described in the documentation about the block
> http://cocoon.apache.org/2.2/blocks/databases/1.0/1437_1_1.html .
>
> But I have not managed to etablish a connection.
>
> There are some for me quite understandable descriptions for cocoon 2.1
> on http://cocoon.apache.org/2.1/developing/datasources.html . But I
> don't know if these are good for 2.2.
>
> Maybe some more informations are necessary: The application should be
> run on tomcat, and manage a connection to a mysql or oracle database.
>
> Thank you for every help in advance.
> Johannes
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
--
This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard.
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.
This message has been scanned for viruses and dangerous content by MailScanner,
and is believed to be clean. MailScanner thanks Transtec Computers for their support.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Boris Goldowsky <bg...@cast.org>.
Johannes -- you may want to search for tutorials on using databases with
Spring. My understanding is that with Cocoon 2.2 it is best to have
Spring configure and manage any database connections. Then you can add
Cocoon features (eg, the SQL transformer or whatever) once that is set
up.
Bng
On Thu, 2008-06-05 at 18:33 +0200, Johannes Hoechstaedter wrote:
> Hi,
>
> I do my first experiences in cocoon, and want to create a database
> webapplication which connects to a database. I did some first steps to a
> database application. Is there a complete how to, to etablish a database
> connection (for read and write access) by cocoon 2.2?
>
> What I already did:
>
> * I did all steps for a first cocoon application which are described in
> http://cocoon.apache.org/2.2/1159_1_1.html . That works.
> * The I added a file databases-driver.properties with the path of the
> driver into META_INF/cocoon/properties, as described in the migration
> guide (http://cocoon.apache.org/2.2/blocks/databases/1.0/1409_1_1.html).
> * The I added the dependency for cocoon-databases-impl into my pom.xml
> as described in the documentation about the block
> http://cocoon.apache.org/2.2/blocks/databases/1.0/1437_1_1.html .
>
> But I have not managed to etablish a connection.
>
> There are some for me quite understandable descriptions for cocoon 2.1
> on http://cocoon.apache.org/2.1/developing/datasources.html . But I
> don't know if these are good for 2.2.
>
> Maybe some more informations are necessary: The application should be
> run on tomcat, and manage a connection to a mysql or oracle database.
>
> Thank you for every help in advance.
> Johannes
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by yosauron <yo...@gmail.com>.
ok,
How do I fix this? Deleting and updating any jar?
And one question, when you define the version in a pom file, is not for
choose the correct version of the blocks - jars??
Thank you Joerg for your answer
Joerg Heinicke wrote:
>
> On 23.09.2008 09:12, yosauron wrote:
>
>> Please, Does anybody know where is the error? I have been searching the
>> error
>> for 5-6 days and I don't have any more clues... Can anyone help me?
>
>
>>>> Caused by: java.lang.NoSuchMethodError:
>>>> org.apache.cocoon.transformation.SQLTransformer.getLogger()Lorg/apache/commons/logging/Log;
>>>> at
>>>> org.apache.cocoon.transformation.SQLTransformer.configure(SQLTransformer.java:278)
>>>> at
>>>> org.apache.avalon.framework.container.ContainerUtil.configure(ContainerUtil.java:202)
>
> Hi,
>
> such errors usually result from incompatible jars. It means
> SQLTransformer.configure() is looking for a method getLogger() which it
> doesn't find. It's SQLTransformer's super class AbstractLogEnabled
> providing this method.
>
> Joerg
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/Database-connection-by-cocoon-2.2-tp17674320p19643289.html
Sent from the Cocoon - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by yosauron <yo...@gmail.com>.
Joerg Heinicke wrote:
>
> On 25.09.2008 12:53, yosauron wrote:
>
>>> org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException:
>>> Line 23 in XML document from URL
>>> [jar:file:/home/caribdis/.m2/repository/org/apache/cocoon/cocoon-databases-bridge/1.1.0-SNAPSHOT/cocoon-databases-bridge-1.1.0-SNAPSHOT.jar!/META-INF/cocoon/spring/SpringToAvalonDataSourceBridge.xml]
>>> is invalid; nested exception is org.xml.sax.SAXParseException:
>>> cvc-elt.1:
>>> Cannot find the declaration of element 'beans'.
>>> at
>>> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:359)
>>> at
>>> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303)
>>> at
>>> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:280)
>>> at
>>> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.handleImport(AbstractSettingsElementParser.java:197)
>>> at
>>> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.handleBeanInclude(AbstractSettingsElementParser.java:187)
>>> at
>>> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.parse(AbstractSettingsElementParser.java:145)
>>> ... 59 more
>>> Caused by: org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the
>>> declaration of element 'beans'.
>>> at
>>> org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown
>>> Source)
>>> at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source)
>>> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
>>> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
>>> at
>>> org.apache.xerces.impl.xs.XMLSchemaValidator.handleStartElement(Unknown
>>> Source)
>>> at org.apache.xerces.impl.xs.XMLSchemaValidator.startElement(Unknown
>>> Source)
>>> at
>>> org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown
>>> Source)
>
>> I'm very confused, I don't understand why do I get the second error? Is
>> it a
>> versions dependencies errors? In that case, Which versions do I have to
>> use
>> to fix it? How do I know the versions of the dependencies that do I have
>> to
>> use? Forgive me but I'm very lost.. :'(. I hope that you can help me...
>
> This time it seems there is a problem with Spring jars. I can't help you
> with the dependencies in particular, I just interpret the error messages.
>
> Joerg
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
>
If the problem is with Spring jars, Do you know what I have to do to fix
that error?? ?:|
Thanks ;).
--
View this message in context: http://www.nabble.com/Database-connection-by-cocoon-2.2-tp17674320p19719764.html
Sent from the Cocoon - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Joerg Heinicke <jo...@gmx.de>.
On 25.09.2008 12:53, yosauron wrote:
>> org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException:
>> Line 23 in XML document from URL
>> [jar:file:/home/caribdis/.m2/repository/org/apache/cocoon/cocoon-databases-bridge/1.1.0-SNAPSHOT/cocoon-databases-bridge-1.1.0-SNAPSHOT.jar!/META-INF/cocoon/spring/SpringToAvalonDataSourceBridge.xml]
>> is invalid; nested exception is org.xml.sax.SAXParseException: cvc-elt.1:
>> Cannot find the declaration of element 'beans'.
>> at
>> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:359)
>> at
>> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303)
>> at
>> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:280)
>> at
>> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.handleImport(AbstractSettingsElementParser.java:197)
>> at
>> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.handleBeanInclude(AbstractSettingsElementParser.java:187)
>> at
>> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.parse(AbstractSettingsElementParser.java:145)
>> ... 59 more
>> Caused by: org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the
>> declaration of element 'beans'.
>> at
>> org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown
>> Source)
>> at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source)
>> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
>> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
>> at
>> org.apache.xerces.impl.xs.XMLSchemaValidator.handleStartElement(Unknown
>> Source)
>> at org.apache.xerces.impl.xs.XMLSchemaValidator.startElement(Unknown
>> Source)
>> at
>> org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown
>> Source)
> I'm very confused, I don't understand why do I get the second error? Is it a
> versions dependencies errors? In that case, Which versions do I have to use
> to fix it? How do I know the versions of the dependencies that do I have to
> use? Forgive me but I'm very lost.. :'(. I hope that you can help me...
This time it seems there is a problem with Spring jars. I can't help you
with the dependencies in particular, I just interpret the error messages.
Joerg
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by yosauron <yo...@gmail.com>.
Joerg Heinicke wrote:
>
> On 23.09.2008 09:12, yosauron wrote:
>
>> Please, Does anybody know where is the error? I have been searching the
>> error
>> for 5-6 days and I don't have any more clues... Can anyone help me?
>
>
>>>> Caused by: java.lang.NoSuchMethodError:
>>>> org.apache.cocoon.transformation.SQLTransformer.getLogger()Lorg/apache/commons/logging/Log;
>>>> at
>>>> org.apache.cocoon.transformation.SQLTransformer.configure(SQLTransformer.java:278)
>>>> at
>>>> org.apache.avalon.framework.container.ContainerUtil.configure(ContainerUtil.java:202)
>
> Hi,
>
> such errors usually result from incompatible jars. It means
> SQLTransformer.configure() is looking for a method getLogger() which it
> doesn't find. It's SQLTransformer's super class AbstractLogEnabled
> providing this method.
>
> Joerg
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
>
Hi Joerg,
I don't if this is a problem in dependencies versions or not. The
dependencies on my pom.xml are the following:
> <dependencies>
> <dependency>
> <groupId>org.apache.cocoon</groupId>
> <artifactId>cocoon-core</artifactId>
> <version>2.2.0-RC2</version>
> </dependency>
> <dependency>
> <groupId>org.apache.cocoon</groupId>
> <artifactId>cocoon-servlet-service-components</artifactId>
> <version>1.0.0-RC1</version>
> </dependency>
> <dependency>
> <groupId>org.apache.cocoon</groupId>
> <artifactId>cocoon-template-impl</artifactId>
> <version>1.0.0-RC2</version>
> </dependency>
> <dependency>
> <groupId>org.apache.cocoon</groupId>
> <artifactId>cocoon-flowscript-impl</artifactId>
> <version>1.0.0-RC2</version>
> </dependency>
>
> <dependency>
> <groupId>org.apache.cocoon</groupId>
> <artifactId>cocoon-databases-impl</artifactId>
> <version>1.0.0</version>
> </dependency>
> <!--
> <dependency>
> <groupId>oracle</groupId>
> <artifactId>oracle-jdbc</artifactId>
> <version>10.2.0.1.0</version>
> </dependency>
> -->
>
> <dependency>
> <groupId>ojdbc</groupId>
> <artifactId>ojdbc</artifactId>
> <version>14</version>
> </dependency>
>
> </dependencies>
>
I have tried to change the "cocoon-databases-impl" version from 1.0.0 to
1.1.0-SNAPSHOT. The last one, is the version that I've compiled and
installed when I downloaded the cocoon's trunk (rev. 691183).
The first time that I ran "mvn jetty:run" with the version 1.1.0-SNAPSHOT of
cocoon-databases-impl, it worked like the other version (only downloaded a
new pom and jar files...) but still crashed with the same error when I
requested the URL from the web browser.
The second time (and following) that I ran "mvn jetty:run" with the version
1.1.0-SNAPSHOT of cocoon-databases-impl, I get an error when it try to
Initialize the Spring root WebApplicationContext. The full error is this:
> 2008-09-25 12:07:56.877:/:INFO: Initializing Spring root
> WebApplicationContext
> 2008-09-25 12:11:08.198::WARN: Failed startup of context
> org.mortbay.jetty.webapp.WebAppContext@fae78f{/,/home/caribdis/cocoon/bloqueBD2/target/rcl/webapp}
> java.lang.RuntimeException: Cannot invoke listener
> org.springframework.web.context.ContextLoaderListener@a47cc3
> at
> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingListener.invoke(ReloadingListener.java:190)
> at
> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingListener.contextInitialized(ReloadingListener.java:213)
> at
> org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:530)
> at org.mortbay.jetty.servlet.Context.startContext(Context.java:135)
> at
> org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1218)
> at
> org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:500)
> at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:448)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
> at
> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
> at
> org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:161)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
> at
> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
> at
> org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
> at org.mortbay.jetty.Server.doStart(Server.java:217)
> at
> org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
> at
> org.mortbay.jetty.plugin.Jetty6PluginServer.start(Jetty6PluginServer.java:132)
> at
> org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:345)
> at
> org.mortbay.jetty.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:286)
> at
> org.mortbay.jetty.plugin.AbstractJettyRunMojo.execute(AbstractJettyRunMojo.java:204)
> at org.mortbay.jetty.plugin.Jetty6RunMojo.execute(Jetty6RunMojo.java:183)
> at
> org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:512)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:482)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:291)
> at
> org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)
> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)
> at org.apache.maven.cli.MavenCli.main(MavenCli.java:287)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
> at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
> at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
> at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
> Caused by: org.springframework.beans.factory.BeanDefinitionStoreException:
> Unable to read spring configurations from
> classpath*:META-INF/cocoon/spring; nested exception is
> org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException:
> Line 23 in XML document from URL
> [jar:file:/home/caribdis/.m2/repository/org/apache/cocoon/cocoon-databases-bridge/1.1.0-SNAPSHOT/cocoon-databases-bridge-1.1.0-SNAPSHOT.jar!/META-INF/cocoon/spring/SpringToAvalonDataSourceBridge.xml]
> is invalid; nested exception is org.xml.sax.SAXParseException: cvc-elt.1:
> Cannot find the declaration of element 'beans'.
> at
> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.parse(AbstractSettingsElementParser.java:148)
> at
> org.springframework.beans.factory.xml.NamespaceHandlerSupport.parse(NamespaceHandlerSupport.java:69)
> at
> org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parseCustomElement(BeanDefinitionParserDelegate.java:1114)
> at
> org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parseCustomElement(BeanDefinitionParserDelegate.java:1104)
> at
> org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:133)
> at
> org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:90)
> at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:458)
> at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:353)
> at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303)
> at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:280)
> at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:131)
> at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:147)
> at
> org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:124)
> at
> org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:92)
> at
> org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:101)
> at
> org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:389)
> at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:324)
> at
> org.apache.cocoon.tools.rcl.springreloader.SynchronizedConfigureableWebApplicationContext.refresh(SynchronizedConfigureableWebApplicationContext.java:247)
> at
> org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
> at
> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
> at
> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
> at
> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingListener.invoke(ReloadingListener.java:157)
> ... 38 more
> Caused by:
> org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException:
> Line 23 in XML document from URL
> [jar:file:/home/caribdis/.m2/repository/org/apache/cocoon/cocoon-databases-bridge/1.1.0-SNAPSHOT/cocoon-databases-bridge-1.1.0-SNAPSHOT.jar!/META-INF/cocoon/spring/SpringToAvalonDataSourceBridge.xml]
> is invalid; nested exception is org.xml.sax.SAXParseException: cvc-elt.1:
> Cannot find the declaration of element 'beans'.
> at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:359)
> at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303)
> at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:280)
> at
> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.handleImport(AbstractSettingsElementParser.java:197)
> at
> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.handleBeanInclude(AbstractSettingsElementParser.java:187)
> at
> org.apache.cocoon.spring.configurator.impl.AbstractSettingsElementParser.parse(AbstractSettingsElementParser.java:145)
> ... 59 more
> Caused by: org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the
> declaration of element 'beans'.
> at
> org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown
> Source)
> at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source)
> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
> at
> org.apache.xerces.impl.xs.XMLSchemaValidator.handleStartElement(Unknown
> Source)
> at org.apache.xerces.impl.xs.XMLSchemaValidator.startElement(Unknown
> Source)
> at
> org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown
> Source)
> at
> org.apache.xerces.impl.XMLNSDocumentScannerImpl$NSContentDispatcher.scanRootElementHook(Unknown
> Source)
> at
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown
> Source)
> at
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
> Source)
> at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
> at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
> at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
> at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
> at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
> at
> org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:76)
> at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:351)
> ... 64 more
> 2008-09-25 12:11:08.328::INFO: Started
> SelectChannelConnector@0.0.0.0:8888
> [INFO] Started Jetty Server
>
I'm very confused, I don't understand why do I get the second error? Is it a
versions dependencies errors? In that case, Which versions do I have to use
to fix it? How do I know the versions of the dependencies that do I have to
use? Forgive me but I'm very lost.. :'(. I hope that you can help me...
Thank you for all.
--
View this message in context: http://www.nabble.com/Database-connection-by-cocoon-2.2-tp17674320p19667238.html
Sent from the Cocoon - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Database connection by cocoon 2.2
Posted by Joerg Heinicke <jo...@gmx.de>.
On 23.09.2008 09:12, yosauron wrote:
> Please, Does anybody know where is the error? I have been searching the error
> for 5-6 days and I don't have any more clues... Can anyone help me?
>>> Caused by: java.lang.NoSuchMethodError:
>>> org.apache.cocoon.transformation.SQLTransformer.getLogger()Lorg/apache/commons/logging/Log;
>>> at
>>> org.apache.cocoon.transformation.SQLTransformer.configure(SQLTransformer.java:278)
>>> at
>>> org.apache.avalon.framework.container.ContainerUtil.configure(ContainerUtil.java:202)
Hi,
such errors usually result from incompatible jars. It means
SQLTransformer.configure() is looking for a method getLogger() which it
doesn't find. It's SQLTransformer's super class AbstractLogEnabled
providing this method.
Joerg
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
RE: Database connection by cocoon 2.2
Posted by yosauron <yo...@gmail.com>.
Please, Does anybody know where is the error? I have been searching the error
for 5-6 days and I don't have any more clues... Can anyone help me?
yosauron wrote:
>
> Hi Dom,
>
> I have followed these steps but I get the following error when I request
> the url from the web browser:
>
>
>
>> javax.servlet.ServletException: org.apache.cocoon.ProcessingException:
>> Failed to process pipeline
>> at <map:serialize type="xml"> -
>> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:45:36
>> at <map:transform type="sql"> -
>> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:39:35
>> at <map:generate> -
>> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:38:42
>> at <map:match> -
>> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:37:37
>> at
>> org.apache.cocoon.servlet.RequestProcessor.service(RequestProcessor.java:232)
>> at
>> org.apache.cocoon.sitemap.SitemapServlet.service(SitemapServlet.java:64)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>> at
>> org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:567)
>> at
>> org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:544)
>> at
>> org.apache.cocoon.servletservice.spring.ServletFactoryBean$ServiceInterceptor.invoke(ServletFactoryBean.java:230)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
>> at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
>> at $Proxy5.service(Unknown Source)
>> at
>> org.apache.cocoon.servletservice.DispatcherServlet.service(DispatcherServlet.java:102)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>> at
>> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServlet.service(ReloadingServlet.java:89)
>> at
>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
>> at
>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
>> at
>> org.apache.cocoon.servlet.multipart.MultipartFilter.doFilter(MultipartFilter.java:119)
>> at
>> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServletFilter.doFilter(ReloadingServletFilter.java:50)
>> at
>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
>> at org.apache.cocoon.servlet.DebugFilter.doFilter(DebugFilter.java:169)
>> at
>> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServletFilter.doFilter(ReloadingServletFilter.java:50)
>> at
>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
>> at
>> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingSpringFilter.doFilter(ReloadingSpringFilter.java:69)
>> at
>> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServletFilter.doFilter(ReloadingServletFilter.java:50)
>> at
>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
>> at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
>> at
>> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
>> at
>> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
>> at
>> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
>> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
>> at
>> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211)
>> at
>> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
>> at
>> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
>> at org.mortbay.jetty.Server.handle(Server.java:313)
>> at
>> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
>> at
>> org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:830)
>> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
>> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
>> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
>> at
>> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
>> at
>> org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
>> Caused by: org.apache.cocoon.ProcessingException: Failed to process
>> pipeline
>> at <map:serialize type="xml"> -
>> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:45:36
>> at <map:transform type="sql"> -
>> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:39:35
>> at <map:generate> -
>> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:38:42
>> at <map:match> -
>> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:37:37
>> at
>> org.apache.cocoon.ProcessingException.throwLocated(ProcessingException.java:143)
>> at
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.handleException(AbstractProcessingPipeline.java:921)
>> at
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupPipeline(AbstractProcessingPipeline.java:370)
>> at
>> org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.setupPipeline(AbstractCachingProcessingPipeline.java:727)
>> at
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.preparePipeline(AbstractProcessingPipeline.java:464)
>> at
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:409)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:597)
>> at
>> org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:72)
>> at $Proxy8.process(Unknown Source)
>> at
>> org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:144)
>> at
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:55)
>> at
>> org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNode.java:87)
>> at
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:77)
>> at
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:151)
>> at
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:77)
>> at
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:93)
>> at
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:240)
>> at
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:171)
>> at
>> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:251)
>> at
>> org.apache.cocoon.servlet.RequestProcessor.process(RequestProcessor.java:357)
>> at
>> org.apache.cocoon.servlet.RequestProcessor.service(RequestProcessor.java:171)
>> ... 38 more
>> Caused by: org.springframework.beans.factory.BeanCreationException: Error
>> creating bean with name
>> 'org.apache.cocoon.transformation.Transformer/sqlPooled': Initialization
>> of bean failed; nested exception is java.lang.NoSuchMethodError:
>> org.apache.cocoon.transformation.SQLTransformer.getLogger()Lorg/apache/commons/logging/Log;
>> at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:448)
>> at
>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:270)
>> at
>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
>> at
>> org.apache.cocoon.core.container.spring.avalon.PoolableFactoryBean.getFromPool(PoolableFactoryBean.java:212)
>> at
>> org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:68)
>> at $Proxy9.setup(Unknown Source)
>> at
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupPipeline(AbstractProcessingPipeline.java:354)
>> ... 59 more
>> Caused by: java.lang.NoSuchMethodError:
>> org.apache.cocoon.transformation.SQLTransformer.getLogger()Lorg/apache/commons/logging/Log;
>> at
>> org.apache.cocoon.transformation.SQLTransformer.configure(SQLTransformer.java:278)
>> at
>> org.apache.avalon.framework.container.ContainerUtil.configure(ContainerUtil.java:202)
>> at
>> org.apache.cocoon.core.container.spring.avalon.AvalonBeanPostProcessor.postProcessBeforeInitialization(AvalonBeanPostProcessor.java:235)
>> at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:301)
>> at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1167)
>> at
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
>> ... 65 more
>>
>
>
> Dominic Tootell-2 wrote:
>>
>> Inside your cocoon 2 block:
>>
>>
>> 1) inside
>> src/main/resources/META-INF/cocoon/avalon/custom-sitemap-compents.xconf
>> put:
>>
>> <map:components>
>>
>> .....
>>
>> <map:transformers>
>> <map:transformer logger="sitemap.transformer.sql"
>> name="sql" src="org.apache.cocoon.transformation.SQLTransformer"/>
>>
>> ....
>>
>> </map:transformers>
>> </map:components>
>>
>>
>> 2) in the block pom.xml:
>>
>> <dependency>
>> <groupId>org.apache.cocoon</groupId>
>> <artifactId>cocoon-databases-impl</artifactId>
>> <version>1.0.0</version>
>> </dependency>
>> <dependency>
>> <groupId>oracle</groupId>
>> <artifactId>oracle-jdbc</artifactId>
>> <version>10.2.0.4</version>
>> </dependency>
>>
>
> I have installed oracle XE 10.2.0.1.0, so I put my version instead of
> yours (10.2.0.4). When I build the block, I got an artifact missing error
> (oracle:oracle-jdbc:jar:10.2.0.1.0), so I downloaded from the
> http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
> oracle's web page the
> http://download.oracle.com/otn/utilities_drivers/jdbc/10201/ojdbc14.jar
> ojdbc14.jar driver.
>
> After that, I installed the driver whith:
>
> mvn install:install-file -DgroupId=oracle -DartifactId=oracle-jdbc
> -Dversion=10.2.0.1.0 -Dpackaging -Dfile=ojdbc14.jar
>
>
> Do I load wrong the jdbc driver? Is it the root of my error? Thank you.
>
>
>
>
>
>
>
>> 3) inside src/main/resources/META-INF/cocoon/spring/datasources.xml
>>
>> <beans xmlns="http://www.springframework.org/schema/beans"
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> xsi:schemaLocation="http://www.springframework.org/schema/beans
>> http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
>>
>> <bean
>> name="org.apache.avalon.excalibur.datasource.DataSourceComponent/lastmod
>> "
>> class="org.apache.cocoon.databases.bridge.spring.avalon.SpringToAvalonDa
>> taSourceWrapper">
>> <property name="wrappedBean">
>> <bean
>> class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
>> <property name="driverClassName"
>> value="oracle.jdbc.driver.OracleDriver"/>
>> <property name="url"
>> value="jdbc:oracle:thin:@cmcdev2007:1521:cmccis"/>
>> <property name="username" value="xxxx"/>
>> <property name="password" value="xxxxx"/>
>> </bean>
>> </property>
>> </bean>
>> </beans>
>>
>> 4) inside src/main/resources/COB-INF/sitemap.xmap:
>>
>> <map:match pattern="runsql/*">
>> <map:generate src="sql/sql.xml"/>
>> <map:transform type="sql">
>> <map:parameter
>> name="use-connection" value="lastmod"/>
>> <map:parameter
>> name="show-nr-of-rows" value="true"/>
>> <map:parameter
>> name="clob-encoding" value="UTF-8"/>
>> <map:parameter name="date"
>> value="{1}"/>
>> </map:transform>
>> <map:serialize type="xml"/>
>> </map:match>
>>
>>
>> 5) inside src/main/resources/COB-INF/sql/sql.xml:
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <page>
>> <title>Hello</title>
>> <content>
>> <para>The following concepts were modified since:</para>
>> <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0">
>>
>> <sql:query name="lastmod">
>> SELECT * FROM DALCONCEPT_LASTMOD
>> WHERE LASTMODIFIED >= TO_DATE('<sql:substitute-value
>> sql:name="date"/>','YYYYMMDD')
>> </sql:query>
>> </sql:execute-query>
>> </content>
>> </page>
>>
>>
>> I agree with the others though.... Hibernate + Spring should be used for
>> any production type app, for a quick mock up, the above should work
>> without having to go near Spring + Hibernate.
>>
>> /dom
>>
>>
>
--
View this message in context: http://www.nabble.com/Database-connection-by-cocoon-2.2-tp17674320p19622454.html
Sent from the Cocoon - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
RE: Database connection by cocoon 2.2
Posted by yosauron <yo...@gmail.com>.
Hi Dom,
I have followed these steps but I get the following error when I request the
url from the web browser:
> javax.servlet.ServletException: org.apache.cocoon.ProcessingException:
> Failed to process pipeline
> at <map:serialize type="xml"> -
> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:45:36
> at <map:transform type="sql"> -
> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:39:35
> at <map:generate> -
> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:38:42
> at <map:match> -
> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:37:37
> at
> org.apache.cocoon.servlet.RequestProcessor.service(RequestProcessor.java:232)
> at
> org.apache.cocoon.sitemap.SitemapServlet.service(SitemapServlet.java:64)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at
> org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:567)
> at
> org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:544)
> at
> org.apache.cocoon.servletservice.spring.ServletFactoryBean$ServiceInterceptor.invoke(ServletFactoryBean.java:230)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> at $Proxy5.service(Unknown Source)
> at
> org.apache.cocoon.servletservice.DispatcherServlet.service(DispatcherServlet.java:102)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at
> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServlet.service(ReloadingServlet.java:89)
> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
> at
> org.apache.cocoon.servlet.multipart.MultipartFilter.doFilter(MultipartFilter.java:119)
> at
> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServletFilter.doFilter(ReloadingServletFilter.java:50)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
> at org.apache.cocoon.servlet.DebugFilter.doFilter(DebugFilter.java:169)
> at
> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServletFilter.doFilter(ReloadingServletFilter.java:50)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
> at
> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingSpringFilter.doFilter(ReloadingSpringFilter.java:69)
> at
> org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServletFilter.doFilter(ReloadingServletFilter.java:50)
> at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
> at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
> at
> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
> at
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> at
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
> at
> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211)
> at
> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
> at
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
> at org.mortbay.jetty.Server.handle(Server.java:313)
> at
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
> at
> org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:830)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
> at
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
> at
> org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
> Caused by: org.apache.cocoon.ProcessingException: Failed to process
> pipeline
> at <map:serialize type="xml"> -
> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:45:36
> at <map:transform type="sql"> -
> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:39:35
> at <map:generate> -
> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:38:42
> at <map:match> -
> file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:37:37
> at
> org.apache.cocoon.ProcessingException.throwLocated(ProcessingException.java:143)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.handleException(AbstractProcessingPipeline.java:921)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupPipeline(AbstractProcessingPipeline.java:370)
> at
> org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.setupPipeline(AbstractCachingProcessingPipeline.java:727)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.preparePipeline(AbstractProcessingPipeline.java:464)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:409)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:72)
> at $Proxy8.process(Unknown Source)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:144)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:55)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNode.java:87)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:77)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:151)
> at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:77)
> at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:93)
> at
> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:240)
> at
> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:171)
> at
> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:251)
> at
> org.apache.cocoon.servlet.RequestProcessor.process(RequestProcessor.java:357)
> at
> org.apache.cocoon.servlet.RequestProcessor.service(RequestProcessor.java:171)
> ... 38 more
> Caused by: org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name
> 'org.apache.cocoon.transformation.Transformer/sqlPooled': Initialization
> of bean failed; nested exception is java.lang.NoSuchMethodError:
> org.apache.cocoon.transformation.SQLTransformer.getLogger()Lorg/apache/commons/logging/Log;
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:448)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:270)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
> at
> org.apache.cocoon.core.container.spring.avalon.PoolableFactoryBean.getFromPool(PoolableFactoryBean.java:212)
> at
> org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:68)
> at $Proxy9.setup(Unknown Source)
> at
> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupPipeline(AbstractProcessingPipeline.java:354)
> ... 59 more
> Caused by: java.lang.NoSuchMethodError:
> org.apache.cocoon.transformation.SQLTransformer.getLogger()Lorg/apache/commons/logging/Log;
> at
> org.apache.cocoon.transformation.SQLTransformer.configure(SQLTransformer.java:278)
> at
> org.apache.avalon.framework.container.ContainerUtil.configure(ContainerUtil.java:202)
> at
> org.apache.cocoon.core.container.spring.avalon.AvalonBeanPostProcessor.postProcessBeforeInitialization(AvalonBeanPostProcessor.java:235)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:301)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1167)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
> ... 65 more
>
Dominic Tootell-2 wrote:
>
> Inside your cocoon 2 block:
>
>
> 1) inside
> src/main/resources/META-INF/cocoon/avalon/custom-sitemap-compents.xconf
> put:
>
> <map:components>
>
> .....
>
> <map:transformers>
> <map:transformer logger="sitemap.transformer.sql"
> name="sql" src="org.apache.cocoon.transformation.SQLTransformer"/>
>
> ....
>
> </map:transformers>
> </map:components>
>
>
> 2) in the block pom.xml:
>
> <dependency>
> <groupId>org.apache.cocoon</groupId>
> <artifactId>cocoon-databases-impl</artifactId>
> <version>1.0.0</version>
> </dependency>
> <dependency>
> <groupId>oracle</groupId>
> <artifactId>oracle-jdbc</artifactId>
> <version>10.2.0.4</version>
> </dependency>
>
I have installed oracle XE 10.2.0.1.0, so I put my version instead of yours
(10.2.0.4). When I build the block, I got an artifact missing error
(oracle:oracle-jdbc:jar:10.2.0.1.0), so I downloaded from the
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
oracle's web page the
http://download.oracle.com/otn/utilities_drivers/jdbc/10201/ojdbc14.jar
ojdbc14.jar driver.
After that, I installed the driver whith:
mvn install:install-file -DgroupId=oracle -DartifactId=oracle-jdbc
-Dversion=10.2.0.1.0 -Dpackaging -Dfile=ojdbc14.jar
Do I load wrong the jdbc driver? Is it the root of my error? Thank you.
> 3) inside src/main/resources/META-INF/cocoon/spring/datasources.xml
>
> <beans xmlns="http://www.springframework.org/schema/beans"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://www.springframework.org/schema/beans
> http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
>
> <bean
> name="org.apache.avalon.excalibur.datasource.DataSourceComponent/lastmod
> "
> class="org.apache.cocoon.databases.bridge.spring.avalon.SpringToAvalonDa
> taSourceWrapper">
> <property name="wrappedBean">
> <bean
> class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
> <property name="driverClassName"
> value="oracle.jdbc.driver.OracleDriver"/>
> <property name="url"
> value="jdbc:oracle:thin:@cmcdev2007:1521:cmccis"/>
> <property name="username" value="xxxx"/>
> <property name="password" value="xxxxx"/>
> </bean>
> </property>
> </bean>
> </beans>
>
> 4) inside src/main/resources/COB-INF/sitemap.xmap:
>
> <map:match pattern="runsql/*">
> <map:generate src="sql/sql.xml"/>
> <map:transform type="sql">
> <map:parameter
> name="use-connection" value="lastmod"/>
> <map:parameter
> name="show-nr-of-rows" value="true"/>
> <map:parameter
> name="clob-encoding" value="UTF-8"/>
> <map:parameter name="date"
> value="{1}"/>
> </map:transform>
> <map:serialize type="xml"/>
> </map:match>
>
>
> 5) inside src/main/resources/COB-INF/sql/sql.xml:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <page>
> <title>Hello</title>
> <content>
> <para>The following concepts were modified since:</para>
> <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0">
>
> <sql:query name="lastmod">
> SELECT * FROM DALCONCEPT_LASTMOD
> WHERE LASTMODIFIED >= TO_DATE('<sql:substitute-value
> sql:name="date"/>','YYYYMMDD')
> </sql:query>
> </sql:execute-query>
> </content>
> </page>
>
>
> I agree with the others though.... Hibernate + Spring should be used for
> any production type app, for a quick mock up, the above should work
> without having to go near Spring + Hibernate.
>
> /dom
>
>
--
View this message in context: http://www.nabble.com/Database-connection-by-cocoon-2.2-tp17674320p19535506.html
Sent from the Cocoon - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org