Не удается вставить запись в таблицу
Teams.java
Код:
package activejbdc;
import org.javalite.activejdbc.Model;
import org.javalite.activejdbc.annotations.*;
@Table("team")
public class Teams extends Model {
}
Activejdbc.java
Код:
package activejbdc;
import java.util.Locale;
import org.javalite.activejdbc.Base;
public class Activejbdc {
public static void main(String[] args) {
Locale.setDefault(Locale.ENGLISH);
Base.open("oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@localhost:1521:xe", "system", "student");
Teams.createIt("id_team", "99", "name", "Real", "stadium", "Bernabeu","coach","Petro","year","1900");
System.out.println("team list: " + Teams.findAll());
Base.close();
}
}
Ошибки
Код:
[main] WARN org.javalite.activejdbc.Registry - Failed to retrieve metadata for table: 'people'. Are you sure this table exists? For some databases table names are case sensitive.
Exception in thread "main" org.javalite.activejdbc.DBException: java.sql.SQLIntegrityConstraintViolationException: Invalid argument(s) in call, Query: INSERT INTO team (id_team, year, name, stadium, coach) VALUES (?, ?, ?, ?, ?), params: 99,1900,Real,Bernabeu,Petro
at oracle.jdbc.driver.AutoKeyInfo.getNewSql(AutoKeyInfo.java:189)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6705)
at org.javalite.activejdbc.DB.execInsert(DB.java:533)
at org.javalite.activejdbc.Model.doInsert(Model.java:2160)
at org.javalite.activejdbc.Model.save(Model.java:2067)
at activejbdc.Teams.save(Teams.java)
at org.javalite.activejdbc.Model.saveIt(Model.java:1994)
at activejbdc.Teams.saveIt(Teams.java)
at org.javalite.activejdbc.Model.createIt(Model.java:1684)
at activejbdc.Teams.createIt(Teams.java)
at activejbdc.Activejbdc.main(Activejbdc.java:39)
Caused by: java.sql.SQLIntegrityConstraintViolationException: Invalid argument(s) in call
... 11 more
Caused by: java.sql.SQLException: Invalid argument(s) in call
at oracle.jdbc.driver.AutoKeyInfo.getReturnParamTypeCode(AutoKeyInfo.java:291)
at oracle.jdbc.driver.AutoKeyInfo.getNewSqlByColumnName(AutoKeyInfo.java:209)
at oracle.jdbc.driver.AutoKeyInfo.getNewSql(AutoKeyInfo.java:173)
... 10 more
Java Result: 1
таблица team
ac.JPG