java - Schema related problems with H2 embedded database -
i building java swing desktop app , have problem database. after made the schema "studenti" , table "studenti.ocjene_studenata" in sql file, when start program, following message. problem? think configured correctly. show message f error,the xml configuration app,sql file , annotations variables. lot!
error: hhh000388: unsuccessful: create table studenti.ocjene_studenata (id integer generated default identity, godina_studiranja integer, ime_studenta varchar(255), baze_podataka integer, matematika integer, napredne_baze_podataka integer, objektno_orijentirano_programiranje_2 integer, objektno_orijentirano_programiranje_1 integer, osnove_programiranja integer, programiranje integer, ocjena_mature integer, prezime_studenta varchar(255), prosjek double, primary key (id)) kol 18, 2014 7:05:47 pm org.hibernate.tool.hbm2ddl.schemaupdate execute error: schema "studenti" not found; sql statement: create table studenti.ocjene_studenata ( id integer generated default identity, godina_studiranja integer, ime_studenta varchar(255), baze_podataka integer, matematika integer, napredne_baze_podataka integer, objektno_orijentirano_programiranje_2 integer, objektno_orijentirano_programiranje_1 integer, osnove_programiranja integer, programiranje integer, ocjena_mature integer, prezime_studenta varchar(255), prosjek double, primary key (id) ) [90079-171] kol 18, 2014 7:05:47 pm org.hibernate.tool.hbm2ddl.schemaupdate execute info: hhh000232: schema update complete kol 18, 2014 7:05:47 pm org.hibernate.engine.jdbc.spi.sqlexceptionhelper logexceptions warn: sql error: 90079, sqlstate: 90079 kol 18, 2014 7:05:47 pm org.hibernate.engine.jdbc.spi.sqlexceptionhelper logexceptions error: schema "studenti" not found; sql statement: insert studenti.ocjene_studenata (id, godina_studiranja, ime_studenta, baze_podataka, matematika, napredne_baze_podataka, objektno_orijentirano_programiranje_2, objektno_orijentirano_programiranje_1, osnove_programiranja, programiranje, ocjena_mature, prezime_studenta, prosjek) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90079-171] exception in thread "awt-eventqueue-0" javax.persistence.persistenceexception: org.hibernate.exception.genericjdbcexception: schema "studenti" not found; sql statement: insert studenti.ocjene_studenata (id, godina_studiranja, ime_studenta, baze_podataka, matematika, napredne_baze_podataka, objektno_orijentirano_programiranje_2, objektno_orijentirano_programiranje_1, osnove_programiranja, programiranje, ocjena_mature, prezime_studenta, prosjek) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90079-171] @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1387) @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1310) @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1316) @ org.hibernate.ejb.abstractentitymanagerimpl.persist(abstractentitymanagerimpl.java:881) @ hr.tvz.programiranje.baza.databaseutils.spremirezultate(databaseutils.java:18) @ hr.tvz.programiranje.java.swing.glavni.glavniokvir$3.actionperformed(glavniokvir.java:177) @ javax.swing.abstractbutton.fireactionperformed(unknown source) @ javax.swing.abstractbutton$handler.actionperformed(unknown source) @ javax.swing.defaultbuttonmodel.fireactionperformed(unknown source) @ javax.swing.defaultbuttonmodel.setpressed(unknown source) @ javax.swing.plaf.basic.basicbuttonlistener.mousereleased(unknown source) @ java.awt.component.processmouseevent(unknown source) @ javax.swing.jcomponent.processmouseevent(unknown source) @ java.awt.component.processevent(unknown source) @ java.awt.container.processevent(unknown source) @ java.awt.component.dispatcheventimpl(unknown source) @ java.awt.container.dispatcheventimpl(unknown source) @ java.awt.component.dispatchevent(unknown source) @ java.awt.lightweightdispatcher.retargetmouseevent(unknown source) @ java.awt.lightweightdispatcher.processmouseevent(unknown source) @ java.awt.lightweightdispatcher.dispatchevent(unknown source) @ java.awt.container.dispatcheventimpl(unknown source) @ java.awt.window.dispatcheventimpl(unknown source) @ java.awt.component.dispatchevent(unknown source) @ java.awt.eventqueue.dispatcheventimpl(unknown source) @ java.awt.eventqueue.access$200(unknown source) @ java.awt.eventqueue$3.run(unknown source) @ java.awt.eventqueue$3.run(unknown source) @ java.security.accesscontroller.doprivileged(native method) @ java.security.protectiondomain$1.dointersectionprivilege(unknown source) @ java.security.protectiondomain$1.dointersectionprivilege(unknown source) @ java.awt.eventqueue$4.run(unknown source) @ java.awt.eventqueue$4.run(unknown source) @ java.security.accesscontroller.doprivileged(native method) @ java.security.protectiondomain$1.dointersectionprivilege(unknown source) @ java.awt.eventqueue.dispatchevent(unknown source) @ java.awt.eventdispatchthread.pumponeeventforfilters(unknown source) @ java.awt.eventdispatchthread.pumpeventsforfilter(unknown source) @ java.awt.eventdispatchthread.pumpeventsforhierarchy(unknown source) @ java.awt.eventdispatchthread.pumpevents(unknown source) @ java.awt.eventdispatchthread.pumpevents(unknown source) @ java.awt.eventdispatchthread.run(unknown source) caused by: org.hibernate.exception.genericjdbcexception: schema "studenti" not found; sql statement: insert studenti.ocjene_studenata (id, godina_studiranja, ime_studenta, baze_podataka, matematika, napredne_baze_podataka, objektno_orijentirano_programiranje_2, objektno_orijentirano_programiranje_1, osnove_programiranja, programiranje, ocjena_mature, prezime_studenta, prosjek) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90079-171] @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:54) @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:125) @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:110) @ org.hibernate.engine.jdbc.internal.proxy.connectionproxyhandler.continueinvocation(connectionproxyhandler.java:146) @ org.hibernate.engine.jdbc.internal.proxy.abstractproxyhandler.invoke(abstractproxyhandler.java:81) @ com.sun.proxy.$proxy9.preparestatement(unknown source) @ org.hibernate.engine.jdbc.internal.statementpreparerimpl$2.doprepare(statementpreparerimpl.java:105) @ org.hibernate.engine.jdbc.internal.statementpreparerimpl$statementpreparationtemplate.preparestatement(statementpreparerimpl.java:166) @ org.hibernate.engine.jdbc.internal.statementpreparerimpl.preparestatement(statementpreparerimpl.java:103) @ org.hibernate.id.identitygenerator$getgeneratedkeysdelegate.prepare(identitygenerator.java:89) @ org.hibernate.id.insert.abstractreturningdelegate.performinsert(abstractreturningdelegate.java:55) @ org.hibernate.persister.entity.abstractentitypersister.insert(abstractentitypersister.java:2936) @ org.hibernate.persister.entity.abstractentitypersister.insert(abstractentitypersister.java:3447) @ org.hibernate.action.internal.entityidentityinsertaction.execute(entityidentityinsertaction.java:81) @ org.hibernate.engine.spi.actionqueue.execute(actionqueue.java:362) @ org.hibernate.engine.spi.actionqueue.addresolvedentityinsertaction(actionqueue.java:203) @ org.hibernate.engine.spi.actionqueue.addinsertaction(actionqueue.java:183) @ org.hibernate.engine.spi.actionqueue.addaction(actionqueue.java:167) @ org.hibernate.event.internal.abstractsaveeventlistener.addinsertaction(abstractsaveeventlistener.java:321) @ org.hibernate.event.internal.abstractsaveeventlistener.performsaveorreplicate(abstractsaveeventlistener.java:286) @ org.hibernate.event.internal.abstractsaveeventlistener.performsave(abstractsaveeventlistener.java:192) @ org.hibernate.event.internal.abstractsaveeventlistener.savewithgeneratedid(abstractsaveeventlistener.java:125) @ org.hibernate.ejb.event.ejb3persisteventlistener.savewithgeneratedid(ejb3persisteventlistener.java:78) @ org.hibernate.event.internal.defaultpersisteventlistener.entityistransient(defaultpersisteventlistener.java:208) @ org.hibernate.event.internal.defaultpersisteventlistener.onpersist(defaultpersisteventlistener.java:151) @ org.hibernate.event.internal.defaultpersisteventlistener.onpersist(defaultpersisteventlistener.java:78) @ org.hibernate.internal.sessionimpl.firepersist(sessionimpl.java:843) @ org.hibernate.internal.sessionimpl.persist(sessionimpl.java:818) @ org.hibernate.internal.sessionimpl.persist(sessionimpl.java:822) @ org.hibernate.ejb.abstractentitymanagerimpl.persist(abstractentitymanagerimpl.java:875) ... 38 more <?xml version="1.0" encoding="utf-8"?> <persistence xmlns="http://java.sun.com/xml/ns/persistence" version="2.0"> <persistence-unit name="hibernatepersistenceunit" transaction-type="resource_local"> <class>hr.tvz.programiranje.java.podaci.podaci</class> <properties> <property name="hibernate.show_sql" value="true"/> <property name="hibernate.format_sql" value="true"/> <property name="hibernate.connection.driver_class" value="org.h2.driver"/> <property name="hibernate.connection.url" value="jdbc:h2:~/uspjehstudenata"/> <property name="hibernate.connection.username" value="sa"/> <property name="hibernate.connection.password" value=""/> <property name="hibernate.dialect" value="org.hibernate.dialect.h2dialect"/> <property name="hibernate.hbm2ddl.auto" value="update"/> </properties> </persistence-unit> </persistence> create schema studenti; create table studenti.ocjene_studenata( id int generated identity, ime_studenta varchar(300) not null, prezime_studenta varchar (300) not null, godina_studiranja int not null, ocjena_mature int not null, prosjek decimal(3,2) not null, matematika int not null, programiranje int not null, objektno_orijentirano_programiranje_1 int not null, objektno_orijentirano_programiranje_2 int not null, osnove_programiranja int not null, baze_podataka int not null, napredne_baze_podataka int not null, primary key(id) ); @entity @table(name="studenti.ocjene_studenata") public class podaci { @id @column(name = "id") @generatedvalue private int id; @column(name = "ime_studenta") private string imestudent; @column(name = "prezime_studenta") private string prezimestudent; @column(name = "godina_studiranja") private int godinastudiranjaint; @column(name = "ocjena_mature") private int ocjenamatureint; @column(name = "prosjek") private double prosjekdbl; @column(name = "matematika") private int ocjmatematika1int; @column(name = "programiranje") private int ocjprogramiranjeint; @column(name = "objektno_orijentirano_programiranje_1") private int ocjoopiint; @column(name = "objektno_orijentirano_programiranje_2") private int ocjoopiiint; @column(name = "osnove_programiranja") private int ocjopint; @column(name = "baze_podataka") private int ocjbpint; @column(name = "napredne_baze_podataka") private int ocjnbpint;
you might want check out:
https://groups.google.com/forum/#!topic/h2-database/3zl1gccdv9m
it's got account of person creating new schema, having errors due case sensitivity in schema name, , resolving them. provides various errors relating schema naming different scenarios.
his final solution @ bottom of thread, thought information in first section might particular case more.
final solution thread:
to else falling in same trap i've fallen (no matter how improbable be) here's small explanation. library used connect databases sending remaining values found in connection-info map jdbc getconnection properties. kept schema name specific statements in "schema" key internal purpose only. on other databases i've tested project with, wasn't problem, h2 coincidentally using same "schema" key connection properties set schema used connection. value wasn't quoted, threw appropriate error. totally confused assumed error coming create table statement sending.
Comments
Post a Comment