java.sql.SQLException: Attempt to define a second primary key: S0011 Attempt to define a second primary key in statement \[CREATE TEXT TABLE S\_DIVISAO(CODIGO VARCHAR(2),DESCRICAO VARCHAR(20), constraint divisao\_pk PRIMARY KEY(codigo))\]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via hsqldb by nvolpini
, 1 year ago
Attempt to define a second primary key: S0011 Attempt to define a second primary key in statement \[CREATE TEXT TABLE S\_DIVISAO(CODIGO VARCHAR(2),DESCRICAO VARCHAR(20), constraint divisao\_pk PRIMARY KEY(codigo))\]
via hsqldb by nobody
, 1 year ago
Unexpected token: 37000 Unexpected token:  in statement \[DROP TABLE news \-- Create Article table CREATE\]
via hsqldb by dmiller_va
, 1 year ago
Unexpected token: 37000 Unexpected token: FOO in statemen t \[CREATE VIEW FOO\_VIEW AS  select foo() foo from dual\]
via hsqldb by nobody
, 1 year ago
InputStream error: S1000 InputStream error in statement \[ SET TABLE EDGES INDEX '1616456 1389512 1971144 6093'\]
via hsqldb by brianfox
, 1 year ago
User not found: S1000 User not found: SA in statement \[CONNECT USER SA PASS WORD ""\]
via hsqldb by celestine_
, 1 year ago
Violation of unique index: Violation of unique index: SYS\_IDX\_88 in statement \[INS NTO PERSON VALUES(406,2,0,'Australia',NULL,NULL,NULL,'Married','1966-02-24','58418932','Dinesh',NULL,NULL ,NULL,'Male','Sachdeva','Mr',NULL,'Applicant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)\]
java.sql.SQLException: Attempt to define a second primary key: S0011 Attempt to define a second primary key in statement \[CREATE TEXT TABLE S\_DIVISAO(CODIGO VARCHAR(2),DESCRICAO VARCHAR(20), constraint divisao\_pk PRIMARY KEY(codigo))\]
at org.hsqldb.Trace.getError(Trace.java:226)
at org.hsqldb.Log.runScript(Log.java:863)
at org.hsqldb.Log.open(Log.java:306)
at org.hsqldb.Database$Logger.openLog(Database.java:2596)
at org.hsqldb.Database.(Database.java:203)
at org.hsqldb.Server.openDB(Server.java:178)
at org.hsqldb.Server.run(Server.java:197)
at org.hsqldb.Server.main(Server.java:147)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago

Know the solutions? Share your knowledge to help other developers to debug faster.