File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes strange problems with JDataStore. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "strange problems with JDataStore." Watch "strange problems with JDataStore." New topic

strange problems with JDataStore.

Hosh Nasi
Ranch Hand

Joined: Sep 10, 2004
Posts: 44
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:

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

Hosh Nasi
Ranch Hand

Joined: Sep 10, 2004
Posts: 44
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?

thank you,
I agree. Here's the link:
subject: strange problems with JDataStore.
It's not a secret anymore!