Primary key and sequence

From: Sami Mohammed (SMOHAMME..ndependenthealth.com)
Date: Wed Apr 20 2005 - 11:14:03 EDT

  • Next message: Andrus Adamchik: "Re: org.objectstyle.cayenne.CayenneRuntimeException"

    Hi

    How to get the primary key value, when i am using the cayenne auto generated sequence(PK Generation). in my case tabelKey is the primary key i want that primary key(tableKey). if i use other method instead of auto generator sequenc, below code is working fine, but how to deal with PK Generation, and how can i use db:Table_key in the following code

                           
                                                                   SelectQuery query = new SelectQuery(WebCwTableList.class);
                                    int tableKey= 0;
                                    List resultList = context.performQuery(query);
                                    Iterator it = resultList.iterator();
                                    while(it.hasNext())
                                    {
                                            WebCwTableList table =(WebCwTableList)it.next();
                                            tableKey = table.getCwTableKey().intValue(); ---> here i want the primary key something like "db:Table_key"
                                    
                                            tableDesc =table.getCwTableDesc();
                                    
                                            //TableNameBean is use to display the label and value in the jsp dropdown
                                            checkBoxList.add(new TableNameBean(tableDesc, String.valueOf(tableKey)));
                                            session.setAttribute("checkBoxList", checkBoxList);
                                    }
                            
            

    Thank you for u time

    sami

    CONFIDENTIALITY NOTICE. This e-mail and attachments, if any, may contain confidential information which is privileged and protected from disclosure by Federal and State
    confidentiality laws rules and regulations. This e-mail and attachments, if any, are intended for the designated addressee only. If you are not the designated addressee, you
    are hereby notified that any disclosure, copying, or distribution of this e-mail and its attachments, if any, may be unlawful and may subject you to legal consequences. If you
    have received this e-mail and attachments in error, please contact Independent Health immediately at (716) 631-3001 and delete the e-mail and its attachments from your
    computer. Thank you for your attention



    This archive was generated by hypermail 2.0.0 : Wed Apr 20 2005 - 11:14:20 EDT