package mk.klikniobrok.models;

import javax.persistence.*;
import java.io.Serializable;
import java.sql.Date;
import java.sql.Timestamp;

/**
 * Created by andrejnaumovski on 12/8/16.
 */

@Entity
@Table(name = "user")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name = "TYPE", discriminatorType=DiscriminatorType.STRING)
@DiscriminatorValue("USER")
public class User {
    @Id
    private String username;
    private String password;
    private int enabled;
    @Column(name = "date_created", insertable = false, updatable = false)
    @Basic(optional = false)
    @Temporal(TemporalType.TIMESTAMP)
    private java.util.Date dateCreated;
    @Column(name = "last_used")
    @Temporal(TemporalType.TIMESTAMP)
    private java.util.Date lastUsed;
    @Enumerated
    private Role role;

    public User() {

    }

    public User(
            String username,
            String password,
            int enabled,
            java.util.Date dateCreated,
            java.util.Date lastUsed,
            Role role
    ) {
        this.username = username;
        this.password = password;
        this.enabled = enabled;
        this.dateCreated = dateCreated;
        this.lastUsed = lastUsed;
        this.role = role;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public int isEnabled() {
        return enabled;
    }

    public void setEnabled(int enabled) {
        this.enabled = enabled;
    }

    @Column(name = "date_created")
    public java.util.Date getDateCreated() {
        return dateCreated;
    }

    public void setDateCreated(Timestamp dateCreated) {
        this.dateCreated = dateCreated;
    }

    @Column(name = "last_used")
    public java.util.Date getLastUsed() {
        return lastUsed;
    }

    public void setLastUsed(Timestamp lastUsed) {
        this.lastUsed = lastUsed;
    }

    public Role getRole() {
        return role;
    }

    public void setRole(Role role) {
        this.role = role;
    }
}

package mk.klikniobrok.models;

import javax.persistence.*;

/**
 * Created by andrejnaumovski on 12/8/16.
 */

@Entity
@Table(name = "customer")
@DiscriminatorValue("CUSTOMER")
public class Customer extends User {
    @Column(name = "email")
    private String email;
    @Column(name = "first_name")
    private String firstName;
    @Column(name = "last_name")
    private String lastName;
    @Column(name = "image_url")
    private String imageUrl;

    public Customer() {
        super();
    }

    public Customer(String username,
                    String password,
                    int enabled,
                    java.util.Date dateCreated,
                    java.util.Date lastUsed,
                    Role role,
                    String email,
                    String firstName,
                    String lastName,
                    String imageUrl
    ) {
        super(username, password, enabled, dateCreated, lastUsed, role);
        this.email = email;
        this.firstName = firstName;
        this.lastName = lastName;
        this.imageUrl = imageUrl;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getImageUrl() {
        return imageUrl;
    }

    public void setImageUrl(String imageUrl) {
        this.imageUrl = imageUrl;
    }
}

{
  "timestamp": 1481218619875,
  "status": 500,
  "error": "Internal Server Error",
  "exception": "org.springframework.dao.InvalidDataAccessResourceUsageException",
  "message": "could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet",
  "path": "/customer/"
}