I have created database successfully with no error and also I added dummy data after creation. Next, I try to get data from database however I have seen an error on console. It tries to create table which was created before.No need to recreate :/ I have searched internet and couldnt find anything related this.
I use MYSQL db, hibernate 4. These 3 classes (Material,MaterialProjectBrief,MaterialProjectImage) dont have any onetomany,manytoone annotations. I have other tables the same structure, they are working well (doing CRUD). I use annotations only I added mapping classed to hibernate.cfg.xml.
(Sorry for writing quickly because I have to leave the office now.
Here is the MaterialProjectImage class.
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
@Entity
public class MaterialProjectImage implements Serializable {
private static final long serialVersionUID = 3886003470849765887L;
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private Integer id;
@Column(name="LINK")
private String link;
@Column(name="TITLE")
private String title;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getLink() {
return link;
}
public void setLink(String link) {
this.link = link;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
}
Here is the log.
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000261: Table found: PORTAL.material
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000037: Columns: [id, aboutus, about, sıtemap, vısıon, worklocatıon, mıssıon, customers, rad, goal]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000108: Foreign keys: []
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000126: Indexes: [prımary]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000261: Table found: PORTAL.materialprojectbrief
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000037: Columns: [id, tıtle, shortbrıef, ıconlınk]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000108: Foreign keys: []
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000126: Indexes: [prımary]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: HHH000262: Table not found: MaterialProjectImage
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000261: Table found: PORTAL.person
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000037: Columns: [id, username, ınfo, ımgpath, name, role, password]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000108: Foreign keys: []
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000126: Indexes: [prımary]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000261: Table found: PORTAL.project
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000037: Columns: [id, faq, tıtle, url, ınstallatıon]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000108: Foreign keys: []
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000126: Indexes: [prımary]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000261: Table found: PORTAL.projectwebview
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000037: Columns: [id, ıntro, ımglınk, project_id, type]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000108: Foreign keys: [fk_9qlhqdt00j5a5hknep10wu44c]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000126: Indexes: [fk_9qlhqdt00j5a5hknep10wu44c, prımary]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000261: Table found: PORTAL.project_document
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000037: Columns: [document_id, project_id]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000108: Foreign keys: [fk_6gwm4ft0jihnaprel3uem1or6, fk_ctnt2crdturw4k3xc5w4r5571]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.TableMetadata
INFO: HHH000126: Indexes: [fk_6gwm4ft0jihnaprel3uem1or6, uk_6gwm4ft0jihnaprel3uem1or6, fk_ctnt2crdturw4k3xc5w4r5571]
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata
INFO: HHH000262: Table not found: MaterialProjectImage
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
ERROR: HHH000388: Unsuccessful: create table MaterialProjectImage (id integer not null auto_increment, LINK varchar(255), TITLE varchar(255), primary key (id))
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
ERROR: Table 'materialprojectimage' already exists
22.Kas.2013 20:17:05 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000232: Schema update complete
