Thursday, March 15, 2012

DEFAULT keyword cannot be used as column has no DEFAULT


 java.sql.SQLSyntaxErrorException: DEFAULT keyword cannot be used as column has no DEFAULT
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:524)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.prepare(IdentityGenerator.java:90)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:54)
... 16 more

Reason:

Table has column more than the properties of persistent object.

Solution:

Remove the column  from the table or add appropriate properties in the persistent class.

1 comment:

  1. Thanks for this article. It's just what I was searching for. I am always interested in this subject.

    PIC Scheme

    ReplyDelete