strange problems with JDataStore.

[Hosh Nasi]

My current project requires me to accept a filepath from a user and create a JdataStore database there. Everything is working fine I can create column objects and add them to my StorageDataSet Object and then add those to my Store object.

However one that simply will not work is setting the index/primary key/RowID. for example:

 try {
       table.setAllRowIds(false);
       Column rowid = table.getColumn("tblKey");
       rowid.setRowId(true);
       table.restructure();
       table.close();
      }
 
      /* Unable to close table */
      catch (DataSetException dse) {
        JOptionPane.showMessageDialog(null, dse.toString(),
                                      "Table Close Error",
                                      JOptionPane.ERROR_MESSAGE);
      }
    } // End of finally  

After setting rowID to true I can still commit duplicate records to the table.. Which in my case is very bad, and I really need to replace the currently held record with the new inserted on.. Can anyone point me in the right direction? If you need more info let me know

Thanks!!

[Hosh Nasi]

I got a little farther. I created a Database object and used it to send some SQL commands to the datastore.

However now I am getting errors for having already defined a primary key. How do I make this work?

 //Create  Table
      data.executeStatement("CREATE TABLE TEST" +
                            "(PRIME1 INT(6) CONSTRAINT TEST_PRIME1_pk PRIMARY KEY," +
                            "PRIME2 VARCHAR(3) CONSTRAINT TEST_PRIME2_pk PRIMARY KEY," +
                            "STARTBIT INT(6), SIZE INT(6))");
      

thank you,