Re: [JBoss-user] Postgres + JBoss 3.2.1 + CMP

Matthew Hixson Sat, 06 Sep 2003 12:33:35 -0700

Thanks for the reply, Alex. Do these instructions hold true for 3.2.2RC3 as well? I just tried this with that version, but it is still trying to put the primary key into the insert statement. What behavior should I see when the below settings have taken affect? Will JBoss stop trying to execute this statement:

INSERT INTO v_partners (partner_id, name, description, partner_type_id) VALUES (null, 'dfadf', 'adfasdf', null);

and instead do something like this:

INSERT INTO v_partners (name, description, partner_type_id) VALUES ('dfadf', 'adfasdf', null);

Thanks,
   -M@

On Saturday, September 6, 2003, at 02:13 AM, Alexey Loubyansky wrote:

/**
 *
 * @jboss:entity-command name="postgresql-fetch-seq"
 */
public abstract class ChildCMPBean
   implements EntityBean
{
   /**
    * @ejb.pk-field
    * @jboss.persistence auto-increment="true"
    */
   public abstract Integer getId();
Check that 3.2.1 has postgresql-fetch-seq command in standardjbosscmp-jdbc.xml

HTH

alex

Matthew Hixson wrote:
Is anyone on the list currently using JBoss 3.2.1 with CMP and Postgres 7.3.x? I am having a problem where JBoss wants to execute SQL inserts with 'null' as the primary key of the record where I would rather Postgres create the primary key for me. I've seen posts such as this one: http://archives.postgresql.org/pgsql-performance/2003-02/msg00062.php So it sounds to me like people have been doing this since the JBoss 3.0.x days. Any help on getting JBoss to not put the primary key into the SQL statement would be greatly appreciated. Thanks, -M@ ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] Postgres + JBoss 3.2.1 + CMP

Reply via email to