NetBeans Forums
| View previous topic :: View next topic |
| Author |
Message |
josuatree
Joined: 14 Dec 2009
Posts: 1
|
 Posted: Mon Dec 14, 2009 11:26 pm Post subject: Netbeans and SQLite database |
 |
|
Hello,
In NetBeans 6.7, I want to automaticly create entity beans based on a SQLite database (last version and jdbc driver). I have always the message "No primary key" on all tables and cannot make this. I have try to create indexes after the creation of table, but it is always the same ! Any suggestion?
Here is my sql code :
| Code: | DROP TABLE IF EXISTS t_etudiant;
CREATE TABLE t_etudiant (
pk_etudiant INT,
id VARCHAR(10),
nom VARCHAR(40),
prenom VARCHAR(40),
date_naissance DATE,
fk_sexe INT,
fk_langue INT,
np_loc VARCHAR(40)
);
CREATE INDEX t_etudiant.indexpk ON (pk_etudiant)
CREATE INDEX t_etudiant.indexnom ON (nom)
|
Remark : the same code is ok with an MySQL database.
Thanks |
|
| Back to top |
|
 |
koshimae
Joined: 13 Dec 2010
Posts: 2
|
| Posted: Tue Dec 14, 2010 3:02 am Post subject: |
|
|
i have the same problem. Did you already fix this? How?
Thank you |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
