liquibase.exception.DatabaseException: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.: Caused By: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.: Caused By: Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.

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 Apereo Issues by Dan McCallum, 1 year ago
:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY
via Apereo Issues by Dan McCallum, 1 year ago
:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY
via liquibase.org by Unknown author, 2 years ago
PI_USER_ID = :NEW.USER_ID AND DELEGATE_USER_ID = :NEW.USER_ID;               END IF;             END IF;     END: ERROR: missing ";" at end of SQL statement:       Caused By: Error executing SQL CREATE  TRIGGER IS_PI_AFTER_UPDATE     AFTER UPDATE     ON
via JIRA by Simon Stelling, 1 year ago
java.sql.SQLSyntaxErrorException: column of LOB or ARRAY type cannot be used in operation
via github.com by Unknown author, 1 year ago
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`unifiedpush`.`#sql-1_5`, CONSTRAINT `fk_q1c2n4kjui158w3t1llg99koq` FOREIGN KEY (`variant_id`) REFERENCES `variant` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)
via JIRA by Anna Nicotera, 1 year ago
com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Lit eral replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q1 5.metadata'). ERRORCODE=-4463, SQLSTATE=42601
liquibase.exception.DatabaseException: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.: Caused By: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.: Caused By: Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1075)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1059)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:113)
at liquibase.integration.commandline.Main.doMigration(Main.java:779)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
8 times, 1 year ago
3 times, 6 months ago
72 times, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 6 months ago
22 more bugmates

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