WItam mam problem gzdyz nie chcee stworzyc mi schematu bazt w MySQL pod encjami wstawiam rowniez info z consoli przy połączeniu z góry dzieki !
-------------------------------------------------------------------------------------------
package encje;
import java.io.Serializable;
import javax.persistence.*;
@Entity
@Table(name="rola")
public class Rola implements Serializable {
@Id
@GeneratedValue
private int id;
private String login;
private String rola;
public String getRola() {
return rola;
}
public void setRola(String rola) {
this.rola = rola;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getLogin() {
return login;
}
public void setLogin(String login) {
this.login = login;
}
}
-------------------------------------------------------------------------------------------
package encje;
import java.sql.Timestamp;
import java.util.Set;
import javax.persistence.*;
@Entity
@Table(name="temat")
public class Temat {
@Id
@GeneratedValue
private int id;
private Timestamp data;
private String tytul;
@Lob
private String tresc;
@ManyToOne
@JoinColumn(name="uzytkownik")
private Uzytkownik uzytkownik;
@OneToMany(mappedBy="uzytkownik", fetch=FetchType.EAGER)
@OrderBy("data ASC")
private Set<Wpis> wpisy;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public Timestamp getData() {
return data;
}
public void setData(Timestamp data) {
this.data = data;
}
public String getTytul() {
return tytul;
}
public void setTytul(String tytul) {
this.tytul = tytul;
}
public String getTresc() {
return tresc;
}
public void setTresc(String tresc) {
this.tresc = tresc;
}
public Uzytkownik getUzytkownik() {
return uzytkownik;
}
public void setUzytkownik(Uzytkownik uzytkownik) {
this.uzytkownik = uzytkownik;
}
public Set<Wpis> getWpisy() {
return wpisy;
}
public void setWpisy(Set<Wpis> wpisy) {
this.wpisy = wpisy;
}
}
--------------------------------------------------------------------------------------------------
package encje;
import java.sql.Timestamp;
import java.util.Set;
import javax.persistence.*;
@Entity
@Table(name="uzytkownik")
public class Uzytkownik {
@Id
@GeneratedValue
private int id;
private String login;
private String haslo;
private Timestamp data;
@OneToMany(mappedBy="uzytkownik", fetch= FetchType.EAGER)
private Set<Temat> tematy;
@OneToMany(mappedBy="uzytkownik", fetch= FetchType.EAGER)
private Set<Wpis> wpisy;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getLogin() {
return login;
}
public void setLogin(String login) {
this.login = login;
}
public String getHaslo() {
return haslo;
}
public void setHaslo(String haslo) {
this.haslo = haslo;
}
public Timestamp getData() {
return data;
}
public void setData(Timestamp data) {
this.data = data;
}
public Set<Temat> getTematy() {
return tematy;
}
public void setTematy(Set<Temat> tematy) {
this.tematy = tematy;
}
public Set<Wpis> getWpisy() {
return wpisy;
}
public void setWpisy(Set<Wpis> wpisy) {
this.wpisy = wpisy;
}
}
---------------------------------------------------------------------------------------------------------
package encje;
import java.sql.Timestamp;
import javax.persistence.*;
@Entity
@Table(name="wpis")
public class Wpis {
@Id
@GeneratedValue
private int id;
private Timestamp data;
@Lob
private String tresc;
@ManyToOne
@JoinColumn(name="uzytkownik")
private Uzytkownik uzytkownik;
@ManyToOne
@JoinColumn(name="temat")
private Temat temat;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public Timestamp getData() {
return data;
}
public void setData(Timestamp data) {
this.data = data;
}
public String getTresc() {
return tresc;
}
public void setTresc(String tresc) {
this.tresc = tresc;
}
public Uzytkownik getUzytkownik() {
return uzytkownik;
}
public void setUzytkownik(Uzytkownik uzytkownik) {
this.uzytkownik = uzytkownik;
}
public Temat getTemat() {
return temat;
}
public void setTemat(Temat temat) {
this.temat = temat;
}
}
----------------------------- CONSOLA Połączenie------------------------------------------------
lip 15, 2017 10:23:57 AM org.hibernate.ejb.HibernatePersistence logDeprecation
WARN: HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
lip 15, 2017 10:23:57 AM org.hibernate.ejb.HibernatePersistence logDeprecation
WARN: HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
lip 15, 2017 10:23:57 AM org.hibernate.ejb.HibernatePersistence logDeprecation
WARN: HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
lip 15, 2017 10:23:57 AM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
INFO: HHH000204: Processing PersistenceUnitInfo [
name: forum
...]
lip 15, 2017 10:23:57 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.3.5.Final}
lip 15, 2017 10:23:57 AM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
lip 15, 2017 10:23:57 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
lip 15, 2017 10:23:57 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.4.Final}
lip 15, 2017 10:23:57 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH000402: Using Hibernate built-in connection pool (not for production use!)
lip 15, 2017 10:23:57 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000401: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/mojabaza?useSSL=false]
lip 15, 2017 10:23:57 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000046: Connection properties: {user=root, password=****}
lip 15, 2017 10:23:57 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000006: Autocommit mode: false
lip 15, 2017 10:23:57 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
lip 15, 2017 10:23:57 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
lip 15, 2017 10:23:58 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
lip 15, 2017 10:23:58 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000227: Running hbm2ddl schema export
lip 15, 2017 10:23:58 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: alter table wpis drop foreign key FK_1g47b5gtrnhygpwfjkgpwuvyp
lip 15, 2017 10:23:58 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: Can't DROP 'FK_1g47b5gtrnhygpwfjkgpwuvyp'; check that column/key exists
lip 15, 2017 10:24:03 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: alter table wpis add constraint FK_1g47b5gtrnhygpwfjkgpwuvyp foreign key (uzytkownik) references temat (id)
lip 15, 2017 10:24:03 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: Can't write; duplicate key in table '#sql-f28_2a'
lip 15, 2017 10:24:03 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000230: Schema export complete
lip 15, 2017 10:24:03 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop
INFO: HHH000030: Cleaning up connection pool [jdbc:mysql://localhost:3306/mojabaza?useSSL=false]