You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Antonio Gallardo Rivera <ag...@agsoftware.dnsalias.com> on 2002/10/15 23:34:15 UTC
PosgreSQL and Modular DB Actions.
Hi, I am trying to run the Modular Dabatase Example from the Cocoon site, but
with PostgreSQL 7.2.
I am using Cocoon 2.1 (lastest CVS), Java 1.4.1, Tomcat 4.1.12 on Red Hat
Linux 7.3.
Someone make it work?
I am having problems with:
<table name="groups">
<keys>
<key name="gid" type="int" autoincrement="true">
<mode name="auto" type="autoincr"/>
</key>
</keys>
<values>
<value name="gname" type="string"/>
</values>
</table>
The problem is that always it trought me a exception that tell:
java.sql.SQLException: ERROR: ExecAppend: Fail to add null value in not null
attribute gname
What I am doing wrong?
Antonio Gallardo
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: PosgreSQL and Modular DB Actions.
Posted by Antonio Gallardo Rivera <ag...@agsoftware.dnsalias.com>.
Thanks for the info.
Antonio Gallardo
El Martes, 15 de Octubre de 2002 17:26, Bobby Mitchell escribió:
> Antonio Gallardo Rivera wrote:
> >Hi, I am trying to run the Modular Dabatase Example from the Cocoon site,
> > but with PostgreSQL 7.2.
> >
> >I am using Cocoon 2.1 (lastest CVS), Java 1.4.1, Tomcat 4.1.12 on Red Hat
> >Linux 7.3.
> >
> >Someone make it work?
> >
> >I am having problems with:
> >
> ><table name="groups">
> > <keys>
> > <key name="gid" type="int" autoincrement="true">
> > <mode name="auto" type="autoincr"/>
>
> I got it to work with Sybase. Above, the mode name="auto", by default is
> configured in <cocoon>/WEB_INF/cocoon.xconf as
> org.apache.cocoon.components.modules.database.HsqlIdentityAutoIncrementModu
>le. I had to add a description for the ManualAutoIncrementModule.
>
> > </key>
> > </keys>
> > <values>
> > <value name="gname" type="string"/>
> > </values>
> ></table>
> >
> >The problem is that always it trought me a exception that tell:
> >
> >java.sql.SQLException: ERROR: ExecAppend: Fail to add null value in not
> > null attribute gname
> >
> >What I am doing wrong?
> >
> >Antonio Gallardo
> >
> >---------------------------------------------------------------------
> >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: <co...@xml.apache.org>
> >For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: PosgreSQL and Modular DB Actions.
Posted by Bobby Mitchell <bm...@niac.usra.edu>.
Sure, I can work on that.
Christian Haul wrote:
>On 15.Oct.2002 -- 07:26 PM, Bobby Mitchell wrote:
>
>>Antonio Gallardo Rivera wrote:
>>
>>>Hi, I am trying to run the Modular Dabatase Example from the Cocoon site,
>>>but with PostgreSQL 7.2.
>>>
>>>I am using Cocoon 2.1 (lastest CVS), Java 1.4.1, Tomcat 4.1.12 on Red Hat
>>>Linux 7.3.
>>>
>>>Someone make it work?
>>>
>>>I am having problems with:
>>>
>>><table name="groups">
>>> <keys>
>>> <key name="gid" type="int" autoincrement="true">
>>> <mode name="auto" type="autoincr"/>
>>>
>>I got it to work with Sybase. Above, the mode name="auto", by default is
>>configured in <cocoon>/WEB_INF/cocoon.xconf as
>>org.apache.cocoon.components.modules.database.HsqlIdentityAutoIncrementModule.
>>I had to add a description for the ManualAutoIncrementModule.
>>
>
>Bobby, could you spare the time and try to come up with an
>AutoIncrementModule for Sybase? It should be fairly easy to adopt one
>of the other ones to Sybase. That would be really great!
>
>Coincidently, I have just received such a module for PostgreSQL :-)
>
> Chris.
>
--
Robert J. (Bobby) Mitchell
Systems Administrator
NASA Institute for Advanced Concepts
555A 14th St Atlanta, Ga. 30318
Phone: (404)347-9633 Fax: (404)347-9638
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: PosgreSQL and Modular DB Actions.
Posted by Antonio Gallardo Rivera <ag...@agsoftware.dnsalias.com>.
Can you send me the PostgreSQL module Christian?
Antonio Gallardo
El Miércoles, 16 de Octubre de 2002 01:47, Christian Haul escribió:
> On 15.Oct.2002 -- 07:26 PM, Bobby Mitchell wrote:
> > Antonio Gallardo Rivera wrote:
> > >Hi, I am trying to run the Modular Dabatase Example from the Cocoon
> > > site, but with PostgreSQL 7.2.
> > >
> > >I am using Cocoon 2.1 (lastest CVS), Java 1.4.1, Tomcat 4.1.12 on Red
> > > Hat Linux 7.3.
> > >
> > >Someone make it work?
> > >
> > >I am having problems with:
> > >
> > ><table name="groups">
> > > <keys>
> > > <key name="gid" type="int" autoincrement="true">
> > > <mode name="auto" type="autoincr"/>
> >
> > I got it to work with Sybase. Above, the mode name="auto", by default is
> > configured in <cocoon>/WEB_INF/cocoon.xconf as
> > org.apache.cocoon.components.modules.database.HsqlIdentityAutoIncrementMo
> >dule. I had to add a description for the ManualAutoIncrementModule.
>
> Bobby, could you spare the time and try to come up with an
> AutoIncrementModule for Sybase? It should be fairly easy to adopt one
> of the other ones to Sybase. That would be really great!
>
> Coincidently, I have just received such a module for PostgreSQL :-)
>
> Chris.
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: PosgreSQL and Modular DB Actions.
Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 15.Oct.2002 -- 07:26 PM, Bobby Mitchell wrote:
> Antonio Gallardo Rivera wrote:
>
> >Hi, I am trying to run the Modular Dabatase Example from the Cocoon site,
> >but with PostgreSQL 7.2.
> >
> >I am using Cocoon 2.1 (lastest CVS), Java 1.4.1, Tomcat 4.1.12 on Red Hat
> >Linux 7.3.
> >
> >Someone make it work?
> >
> >I am having problems with:
> >
> ><table name="groups">
> > <keys>
> > <key name="gid" type="int" autoincrement="true">
> > <mode name="auto" type="autoincr"/>
> >
> I got it to work with Sybase. Above, the mode name="auto", by default is
> configured in <cocoon>/WEB_INF/cocoon.xconf as
> org.apache.cocoon.components.modules.database.HsqlIdentityAutoIncrementModule.
> I had to add a description for the ManualAutoIncrementModule.
Bobby, could you spare the time and try to come up with an
AutoIncrementModule for Sybase? It should be fairly easy to adopt one
of the other ones to Sybase. That would be really great!
Coincidently, I have just received such a module for PostgreSQL :-)
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
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. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: PosgreSQL and Modular DB Actions.
Posted by Bobby Mitchell <bm...@niac.usra.edu>.
Antonio Gallardo Rivera wrote:
>Hi, I am trying to run the Modular Dabatase Example from the Cocoon site, but
>with PostgreSQL 7.2.
>
>I am using Cocoon 2.1 (lastest CVS), Java 1.4.1, Tomcat 4.1.12 on Red Hat
>Linux 7.3.
>
>Someone make it work?
>
>I am having problems with:
>
><table name="groups">
> <keys>
> <key name="gid" type="int" autoincrement="true">
> <mode name="auto" type="autoincr"/>
>
I got it to work with Sybase. Above, the mode name="auto", by default is
configured in <cocoon>/WEB_INF/cocoon.xconf as
org.apache.cocoon.components.modules.database.HsqlIdentityAutoIncrementModule.
I had to add a description for the ManualAutoIncrementModule.
>
> </key>
> </keys>
> <values>
> <value name="gname" type="string"/>
> </values>
></table>
>
>The problem is that always it trought me a exception that tell:
>
>java.sql.SQLException: ERROR: ExecAppend: Fail to add null value in not null
>attribute gname
>
>What I am doing wrong?
>
>Antonio Gallardo
>
>---------------------------------------------------------------------
>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: <co...@xml.apache.org>
>For additional commands, e-mail: <co...@xml.apache.org>
>
--
Robert J. (Bobby) Mitchell
Systems Administrator
NASA Institute for Advanced Concepts
555A 14th St Atlanta, Ga. 30318
Phone: (404)347-9633 Fax: (404)347-9638
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>