Re: PosgreSQL and Modular DB Actions.

2002-10-16 Thread Christian Haul

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
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: PosgreSQL and Modular DB Actions.

2002-10-16 Thread Antonio Gallardo Rivera

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: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: PosgreSQL and Modular DB Actions.

2002-10-16 Thread Bobby Mitchell

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: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: PosgreSQL and Modular DB Actions.

2002-10-15 Thread Bobby Mitchell

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: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-- 
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: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: PosgreSQL and Modular DB Actions.

2002-10-15 Thread Antonio Gallardo Rivera

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