Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Unknown column 'employee0_2_.employee_id' in 'field list'
- Что не так с полями или колонками ? Что не хватает ?
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'employee0_2_.employee_id' in 'field list'
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
- at com.mysql.jdbc.Util.getInstance(Util.java:381)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
- at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
- at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)
- @Entity
- @Table (name = "employee")
- @Inheritance(strategy = InheritanceType.JOINED)
- public class Employee{
- public Employee(int id, String name, double salary, String specialization) {
- this.employee_id = id;
- this.name = name;
- this.salary = salary;
- this.specialization = specialization;
- }
- @Override
- public String toString() {
- return "Employee{" +
- "id=" + employee_id +
- ", name='" + name + ''' +
- ", salary=" + salary +
- ", deg='" + specialization + ''' +
- '}';
- }
- public int getId() {
- return employee_id;
- }
- public void setId(int id) {
- this.employee_id = id;
- }
- public String getName() {
- return name;
- }
- public void setName(String name) {
- this.name = name;
- }
- public double getSalary() {
- return salary;
- }
- public void setSalary(double salary) {
- this.salary = salary;
- }
- public String getSpecialization() {
- return specialization;
- }
- public void setSpecialization(String specialization) {
- this.specialization = specialization;
- }
- @Id
- @Column(name = "employee_id")
- private int employee_id;
- @Column(name = "name")
- private String name;
- @Column(name = "salary")
- private double salary;
- @Column (name = "specialization")
- private String specialization;
- public Employee(){}
- @Table(name = "department")
- @Entity
- @Inheritance(strategy = InheritanceType.JOINED)
- public class Department extends Managers{
- public String getName() {
- return name;
- }
- public void setName(String name) {
- this.name = name;
- }
- public Department(String name) {
- this.name = name;
- }
- public Managers getManager() {
- return manager;
- }
- public void setManager(Managers manager) {
- this.manager = manager;
- }
- @OneToOne
- @JoinColumn(name = "department_id" , referencedColumnName = "manager_id", insertable = false, updatable = false)
- private Managers manager;
- @Column(name = "name")
- private String name;
- public int getDepartment_id() {
- return department_id;
- }
- public void setDepartment_id(int department_id) {
- this.department_id = department_id;
- }
- @GeneratedValue(strategy = GenerationType.AUTO)
- @Column(name = "department_id")
- private int department_id;
- public Department(){}
- }
- @Table(name = "managers")
- @Entity
- public class Managers extends Employee{
- @OneToOne
- @JoinColumn(name = "manager_id", referencedColumnName = "employee_id" , insertable = false, updatable = false)
- private Employee employee;
- public String getName() {
- return name;
- }
- public void setName(String name) {
- this.name = name;
- }
- public String getLastname() {
- return lastname;
- }
- public void setLastname(String lastname) {
- this.lastname = lastname;
- }
- public Managers(String name, String lastname) {
- this.name = name;
- this.lastname = lastname;
- }
- public Managers(){}
- @Column(name = "name")
- private String name;
- @Column(name = "lastname")
- private String lastname;
- public int getManager_id() {
- return manager_id;
- }
- public void setManager_id(int manager_id) {
- this.manager_id = manager_id;
- }
- @GeneratedValue(strategy = GenerationType.AUTO)
- @Column(name = "manager_id")
- private int manager_id;
- }
- CREATE TABLE Employee(employee_id INTEGER PRIMARY KEY NULL , name VARCHAR(50) UNIQUE NULL , salary VARCHAR(50) null , specialization VARCHAR(50) NULL);
- CREATE TABLE Managers(name VARCHAR(50) NULL UNIQUE , lastname VARCHAR(50) NULL UNIQUE , manager_id INTEGER NULL PRIMARY KEY AUTO_INCREMENT, FOREIGN KEY (manager_id) REFERENCES Employee(employee_id) );
- CREATE TABLE Department (department_id INTEGER PRIMARY KEY AUTO_INCREMENT ,name VARCHAR(50) UNIQUE NULL , FOREIGN KEY (department_id) REFERENCES Managers(manager_id));
- public class ApplTest {
- public static void main(String[] args) {
- System.out.println("In the main");
- EntityManagerFactory emfactory = Persistence.createEntityManagerFactory("EmployeesTesting");
- EntityManager entityManager = emfactory.createEntityManager();
- Employee employee = new Employee(1000,"Maks",3500,"Programmer");
- Managers manager = new Managers("maks","Burkov");
- Department department = new Department("Programmers");
- if(entityManager.contains(employee)){
- System.out.println("In the contains , the object has persistence state! ");
- entityManager.getTransaction().begin();
- entityManager.persist(employee);
- entityManager.persist(manager);
- entityManager.persist(department);
- entityManager.getTransaction().commit();
- entityManager.close();
- emfactory.close();
- System.out.println("Data Inserted!");
- }
- else if (!(entityManager.contains(employee))){
- System.out.println("In the not contains, the object is detached! ");
- entityManager.getTransaction().begin();
- entityManager.merge(employee);
- entityManager.merge(manager);
- entityManager.merge(department);
- entityManager.getTransaction().commit();
- entityManager.close();
- emfactory.close();
- System.out.println("Data Inserted!");
- }
- System.out.println("Get out from main");
- }
- }
- <?xml version="1.0" encoding="UTF-8"?>
- <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
- http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
- <persistence-unit name="EmployeesTesting" transaction-type="RESOURCE_LOCAL">
- <provider>org.hibernate.ejb.HibernatePersistence</provider>
- <class>employee.Employee</class>
- <class>department.Department</class>
- <class>managers.Managers</class>
- <properties>
- <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/employees"/>
- <property name="javax.persistence.jdbc.user" value="root"/>
- <property name="javax.persistence.jdbc.password" value="maks19880"/>
- <property name="javax.persistence.jdbc.Driver" value="com.mysql.jdbc.Driver"/>
- </properties>
- </persistence-unit>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement