Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
I've struggled with this for a while, and can't figure it out. I'm sure it's something I'm doing, or not. My problem is this: it's not creating the table to store the information in, and generating a SQLException. I tried changing the HSQLDB version to 1.7.3, to no avail. Below are the appropriate file extracts. Thanks.
Hibernate version: 3.2.5
Mapping documents:
Code:
hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="connection.url">jdbc:hsqldb:hsql://localhost</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<!-- enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Diasbale the second level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2dll.auto">create</property>
<property name="connection.shutdown">true</property>
<mapping resource="events/Event.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Event.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="events.Event" table="EVENTS">
<id name="id" column="EVENT_ID">
<generator class="native" />
</id>
<property name="date" type="timestamp" column="EVENT_DATE" />
<property name="title" />
</class>
</hibernate-mapping>
Code:
package events;
import org.hibernate.Session;
import java.util.Date;
import util.HibernateUtil;
public class EventManager {
public static void main(String [] args) {
EventManager mgr = new EventManager();
if (args[0].equals("store")) {
mgr.createAndStoreEvent("My Event", new Date());
}
HibernateUtil.getSessionFactory().close();
}
private void createAndStoreEvent(String title, Date theDate) {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
Event theEvent = new Event();
theEvent.setTitle(title);
theEvent.setDate(theDate);
session.save(theEvent);
session.getTransaction().commit();
}
}
Name and version of the database you are using: HSQLDB 1.8.0.1
Debug level Hibernate log excerpt:
Quote:
Buildfile: build.xml
clean:
[delete] Deleting directory D:\hibernate\tutorial\bin
[mkdir] Created dir: D:\hibernate\tutorial\bin
copy-resources:
[copy] Copying 3 files to D:\hibernate\tutorial\bin
[copy] Copied 2 empty directories to 1 empty directory under D:\hibernate\tutorial\bin
compile:
[javac] Compiling 3 source files to D:\hibernate\tutorial\bin
run:
[java] 10:13:36,906 INFO Environment:514 - Hibernate 3.2.5
[java] 10:13:36,906 INFO Environment:547 - hibernate.properties not found
[java] 10:13:36,921 INFO Environment:681 - Bytecode provider name : cglib
[java] 10:13:36,921 INFO Environment:598 - using JDK 1.4 java.sql.Timestamp handling
[java] 10:13:36,984 INFO Configuration:1426 - configuring from resource: /hibernate.cfg.xml
[java] 10:13:36,984 INFO Configuration:1403 - Configuration resource: /hibernate.cfg.xml
[java] 10:13:37,031 DEBUG DTDEntityResolver:38 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
[java] 10:13:37,031 DEBUG DTDEntityResolver:40 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
[java] 10:13:37,031 DEBUG DTDEntityResolver:50 - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
[java] 10:13:37,062 DEBUG Configuration:1387 - connection.driver_class=org.hsqldb.jdbcDriver
[java] 10:13:37,062 DEBUG Configuration:1387 - connection.url=jdbc:hsqldb:hsql://localhost
[java] 10:13:37,062 DEBUG Configuration:1387 - connection.username=sa
[java] 10:13:37,078 DEBUG Configuration:1387 - connection.password=
[java] 10:13:37,078 DEBUG Configuration:1387 - connection.pool_size=1
[java] 10:13:37,078 DEBUG Configuration:1387 - dialect=org.hibernate.dialect.HSQLDialect
[java] 10:13:37,078 DEBUG Configuration:1387 - current_session_context_class=thread
[java] 10:13:37,078 DEBUG Configuration:1387 - cache.provider_class=org.hibernate.cache.NoCacheProvider
[java] 10:13:37,078 DEBUG Configuration:1387 - show_sql=true
[java] 10:13:37,078 DEBUG Configuration:1387 - hbm2dll.auto=create
[java] 10:13:37,078 DEBUG Configuration:1387 - connection.shutdown=true
[java] 10:13:37,078 DEBUG Configuration:1586 - null<-org.dom4j.tree.DefaultAttribute@2f1921 [Attribute: name resource value "events/Event.hbm.xml"]
[java] 10:13:37,078 INFO Configuration:553 - Reading mappings from resource : events/Event.hbm.xml
[java] 10:13:37,078 DEBUG DTDEntityResolver:38 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
[java] 10:13:37,078 DEBUG DTDEntityResolver:40 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
[java] 10:13:37,093 DEBUG DTDEntityResolver:50 - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
[java] 10:13:37,171 INFO HbmBinder:300 - Mapping class: events.Event -> EVENTS
[java] 10:13:37,187 DEBUG HbmBinder:1270 - Mapped property: id -> EVENT_ID
[java] 10:13:37,203 DEBUG HbmBinder:1270 - Mapped property: date -> EVENT_DATE
[java] 10:13:37,203 DEBUG HbmBinder:1270 - Mapped property: title -> title
[java] 10:13:37,203 INFO Configuration:1541 - Configured SessionFactory: null
[java] 10:13:37,203 DEBUG Configuration:1542 - properties: {java.vendor=Sun Microsystems Inc., show_sql=true, hibernate.connection.url=jdbc:hsqldb:hsql://localhost, os.name=Windows XP, sun.boot.class.path=C:\j2sdk1.4.2_14\jre\lib\rt.jar;C:\j2sdk1.4.2_14\jre\lib\i18n.jar;C:\j2sdk1.4.2_14\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2_14\jre\lib\jsse.jar;C:\j2sdk1.4.2_14\jre\lib\jce.jar;C:\j2sdk1.4.2_14\jre\lib\charsets.jar;C:\j2sdk1.4.2_14\jre\classes, hibernate.current_session_context_class=thread, sun.java2d.fontpath=, java.vm.specification.vendor=Sun Microsystems Inc., java.runtime.version=1.4.2_14-b05, hibernate.cache.provider_class=org.hibernate.cache.NoCacheProvider, user.name=cj08, connection.driver_class=org.hsqldb.jdbcDriver, hibernate.hbm2dll.auto=create, current_session_context_class=thread, user.language=en, sun.boot.library.path=C:\j2sdk1.4.2_14\jre\bin, dialect=org.hibernate.dialect.HSQLDialect, java.version=1.4.2_14, connection.shutdown=true, user.timezone=America/New_York, hibernate.connection.shutdown=true, sun.arch.data.model=32, java.endorsed.dirs=C:\j2sdk1.4.2_14\jre\lib\endorsed, sun.cpu.isalist=pentium i486 i386, file.encoding.pkg=sun.io, file.separator=\, java.specification.name=Java Platform API Specification, java.class.version=48.0, user.country=US, connection.url=jdbc:hsqldb:hsql://localhost, java.home=C:\j2sdk1.4.2_14\jre, java.vm.info=mixed mode, os.version=5.1, path.separator=;, connection.password=, java.vm.version=1.4.2_14-b05, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, hibernate.connection.password=, user.variant=, java.awt.printerjob=sun.awt.windows.WPrinterJob, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, hibernate.connection.username=sa, user.home=C:\Documents and Settings\cj08, java.specification.vendor=Sun Microsystems Inc., java.library.path=C:\j2sdk1.4.2_14\jre\bin;.;C:\WINDOWS\system32;C:\WINDOWS;D:\oracle\product\10.2.0\client_1\bin;C:\Program Files\MKS\IntegrityClient\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Reflection\;C:\WINDOWS\system32\nls;C:\WINDOWS\system32\nls\ENGLISH;C:\Program Files\MySQL\MySQL Server 5.1\bin;%JAVA_HOME\bin;C:\Program Files\Common Files\GTK\2.0\bin;d:\apache-ant-1.6.5\bin;, java.vendor.url=http://java.sun.com/, hibernate.connection.driver_class=org.hsqldb.jdbcDriver, connection.username=sa, java.vm.vendor=Sun Microsystems Inc., hibernate.dialect=org.hibernate.dialect.HSQLDialect, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=D:\hibernate\tutorial\bin;D:\hibernate\tutorial\lib\ant-1.6.5.jar;D:\hibernate\tutorial\lib\ant-antlr-1.6.5.jar;D:\hibernate\tutorial\lib\ant-junit-1.6.5.jar;D:\hibernate\tutorial\lib\ant-launcher-1.6.5.jar;D:\hibernate\tutorial\lib\asm-attrs.jar;D:\hibernate\tutorial\lib\asm.jar;D:\hibernate\tutorial\lib\cglib-2.1.3.jar;D:\hibernate\tutorial\lib\checkstyle-all.jar;D:\hibernate\tutorial\lib\commons-collections-2.1.1.jar;D:\hibernate\tutorial\lib\commons-logging-1.0.4.jar;D:\hibernate\tutorial\lib\dom4j-1.6.1.jar;D:\hibernate\tutorial\lib\ehcache-1.2.3.jar;D:\hibernate\tutorial\lib\hibernate3.jar;D:\hibernate\tutorial\lib\hsqldb.jar;D:\hibernate\tutorial\lib\jdbc2_0-stdext.jar;D:\hibernate\tutorial\lib\jta.jar;D:\hibernate\tutorial\lib\junit-3.8.1.jar;D:\hibernate\tutorial\lib\log4j-1.2.11.jar;D:\hibernate\tutorial\lib\mysql-connector-java-5.1.5-bin.jar;D:\hibernate\tutorial\lib\servlet.jar;D:\hibernate\tutorial\lib\syndiag2.jar;D:\hibernate\tutorial\lib\versioncheck.jar;D:\hibernate\tutorial\lib\xml-apis.jar, hibernate.bytecode.use_reflection_optimizer=false, hbm2dll.auto=create, java.vm.specification.name=Java Virtual Machine Specification, java.vm.specification.version=1.0, sun.cpu.endian=little, sun.os.patch.level=Service Pack 2, connection.pool_size=1, java.io.tmpdir=C:\DOCUME~1\cj08\LOCALS~1\Temp\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, os.arch=x86, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.ext.dirs=C:\j2sdk1.4.2_14\jre\lib\ext, user.dir=D:\hibernate\tutorial, line.separator=
[java] , java.vm.name=Java HotSpot(TM) Client VM, cache.provider_class=org.hibernate.cache.NoCacheProvider, file.encoding=Cp1252, java.specification.version=1.4, hibernate.show_sql=true, hibernate.connection.pool_size=1}
[java] 10:13:37,203 DEBUG Configuration:1285 - Preparing to build session factory with filters : {}
[java] 10:13:37,203 DEBUG Configuration:1120 - processing extends queue
[java] 10:13:37,203 DEBUG Configuration:1124 - processing collection mappings
[java] 10:13:37,203 DEBUG Configuration:1135 - processing native query and ResultSetMapping mappings
[java] 10:13:37,203 DEBUG Configuration:1143 - processing association property references
[java] 10:13:37,203 DEBUG Configuration:1165 - processing foreign key constraints
[java] 10:13:37,281 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
[java] 10:13:37,281 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
[java] 10:13:37,281 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
[java] 10:13:37,281 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost
[java] 10:13:37,281 INFO DriverManagerConnectionProvider:83 - connection properties: {user=sa, password=, shutdown=true}
[java] 10:13:37,281 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
[java] 10:13:37,281 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
[java] 10:13:37,375 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:hsqldb:hsql://localhost, Isolation Level: 1
[java] 10:13:37,437 INFO SettingsFactory:89 - RDBMS: HSQL Database Engine, version: 1.7.3
[java] 10:13:37,437 INFO SettingsFactory:90 - JDBC driver: HSQL Database Engine Driver, version: 1.7.3
[java] 10:13:37,437 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
[java] 10:13:37,453 INFO Dialect:152 - Using dialect: org.hibernate.dialect.HSQLDialect
[java] 10:13:37,468 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
[java] 10:13:37,468 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[java] 10:13:37,484 INFO SettingsFactory:143 - Automatic flush during beforeCompletion(): disabled
[java] 10:13:37,484 INFO SettingsFactory:147 - Automatic session close at end of transaction: disabled
[java] 10:13:37,484 INFO SettingsFactory:154 - JDBC batch size: 15
[java] 10:13:37,484 INFO SettingsFactory:157 - JDBC batch updates for versioned data: disabled
[java] 10:13:37,484 INFO SettingsFactory:162 - Scrollable result sets: enabled
[java] 10:13:37,484 DEBUG SettingsFactory:166 - Wrap result sets: disabled
[java] 10:13:37,484 INFO SettingsFactory:170 - JDBC3 getGeneratedKeys(): disabled
[java] 10:13:37,484 INFO SettingsFactory:178 - Connection release mode: auto
[java] 10:13:37,484 INFO SettingsFactory:205 - Default batch fetch size: 1
[java] 10:13:37,484 INFO SettingsFactory:209 - Generate SQL with comments: disabled
[java] 10:13:37,484 INFO SettingsFactory:213 - Order SQL updates by primary key: disabled
[java] 10:13:37,484 INFO SettingsFactory:217 - Order SQL inserts for batching: disabled
[java] 10:13:37,484 INFO SettingsFactory:386 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[java] 10:13:37,484 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
[java] 10:13:37,484 INFO SettingsFactory:225 - Query language substitutions: {}
[java] 10:13:37,484 INFO SettingsFactory:230 - JPA-QL strict compliance: disabled
[java] 10:13:37,484 INFO SettingsFactory:235 - Second-level cache: enabled
[java] 10:13:37,484 INFO SettingsFactory:239 - Query cache: disabled
[java] 10:13:37,484 INFO SettingsFactory:373 - Cache provider: org.hibernate.cache.NoCacheProvider
[java] 10:13:37,500 INFO SettingsFactory:254 - Optimize cache for minimal puts: disabled
[java] 10:13:37,500 INFO SettingsFactory:263 - Structured second-level cache entries: disabled
[java] 10:13:37,500 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
[java] 10:13:37,500 INFO SettingsFactory:283 - Echoing all SQL to stdout
[java] 10:13:37,500 INFO SettingsFactory:290 - Statistics: disabled
[java] 10:13:37,500 INFO SettingsFactory:294 - Deleted entity synthetic identifier rollback: disabled
[java] 10:13:37,500 INFO SettingsFactory:309 - Default entity-mode: pojo
[java] 10:13:37,500 INFO SettingsFactory:313 - Named query checking : enabled
[java] 10:13:37,531 INFO SessionFactoryImpl:161 - building session factory
[java] 10:13:37,531 DEBUG SessionFactoryImpl:173 - Session factory constructed with filter configurations : {}
[java] 10:13:37,546 DEBUG SessionFactoryImpl:177 - instantiating session factory with properties: {java.vendor=Sun Microsystems Inc., show_sql=true, hibernate.connection.url=jdbc:hsqldb:hsql://localhost, os.name=Windows XP, sun.boot.class.path=C:\j2sdk1.4.2_14\jre\lib\rt.jar;C:\j2sdk1.4.2_14\jre\lib\i18n.jar;C:\j2sdk1.4.2_14\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2_14\jre\lib\jsse.jar;C:\j2sdk1.4.2_14\jre\lib\jce.jar;C:\j2sdk1.4.2_14\jre\lib\charsets.jar;C:\j2sdk1.4.2_14\jre\classes, hibernate.current_session_context_class=thread, sun.java2d.fontpath=, java.vm.specification.vendor=Sun Microsystems Inc., java.runtime.version=1.4.2_14-b05, hibernate.cache.provider_class=org.hibernate.cache.NoCacheProvider, user.name=cj08, connection.driver_class=org.hsqldb.jdbcDriver, hibernate.hbm2dll.auto=create, current_session_context_class=thread, user.language=en, sun.boot.library.path=C:\j2sdk1.4.2_14\jre\bin, dialect=org.hibernate.dialect.HSQLDialect, java.version=1.4.2_14, user.timezone=America/New_York, connection.shutdown=true, sun.arch.data.model=32, hibernate.connection.shutdown=true, java.endorsed.dirs=C:\j2sdk1.4.2_14\jre\lib\endorsed, sun.cpu.isalist=pentium i486 i386, file.encoding.pkg=sun.io, file.separator=\, java.specification.name=Java Platform API Specification, java.class.version=48.0, user.country=US, connection.url=jdbc:hsqldb:hsql://localhost, java.home=C:\j2sdk1.4.2_14\jre, java.vm.info=mixed mode, os.version=5.1, path.separator=;, connection.password=, java.vm.version=1.4.2_14-b05, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, hibernate.connection.password=, user.variant=, java.awt.printerjob=sun.awt.windows.WPrinterJob, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, hibernate.connection.username=sa, user.home=C:\Documents and Settings\cj08, java.specification.vendor=Sun Microsystems Inc., java.library.path=C:\j2sdk1.4.2_14\jre\bin;.;C:\WINDOWS\system32;C:\WINDOWS;D:\oracle\product\10.2.0\client_1\bin;C:\Program Files\MKS\IntegrityClient\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Reflection\;C:\WINDOWS\system32\nls;C:\WINDOWS\system32\nls\ENGLISH;C:\Program Files\MySQL\MySQL Server 5.1\bin;%JAVA_HOME\bin;C:\Program Files\Common Files\GTK\2.0\bin;d:\apache-ant-1.6.5\bin;, java.vendor.url=http://java.sun.com/, hibernate.connection.driver_class=org.hsqldb.jdbcDriver, connection.username=sa, java.vm.vendor=Sun Microsystems Inc., hibernate.dialect=org.hibernate.dialect.HSQLDialect, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=D:\hibernate\tutorial\bin;D:\hibernate\tutorial\lib\ant-1.6.5.jar;D:\hibernate\tutorial\lib\ant-antlr-1.6.5.jar;D:\hibernate\tutorial\lib\ant-junit-1.6.5.jar;D:\hibernate\tutorial\lib\ant-launcher-1.6.5.jar;D:\hibernate\tutorial\lib\asm-attrs.jar;D:\hibernate\tutorial\lib\asm.jar;D:\hibernate\tutorial\lib\cglib-2.1.3.jar;D:\hibernate\tutorial\lib\checkstyle-all.jar;D:\hibernate\tutorial\lib\commons-collections-2.1.1.jar;D:\hibernate\tutorial\lib\commons-logging-1.0.4.jar;D:\hibernate\tutorial\lib\dom4j-1.6.1.jar;D:\hibernate\tutorial\lib\ehcache-1.2.3.jar;D:\hibernate\tutorial\lib\hibernate3.jar;D:\hibernate\tutorial\lib\hsqldb.jar;D:\hibernate\tutorial\lib\jdbc2_0-stdext.jar;D:\hibernate\tutorial\lib\jta.jar;D:\hibernate\tutorial\lib\junit-3.8.1.jar;D:\hibernate\tutorial\lib\log4j-1.2.11.jar;D:\hibernate\tutorial\lib\mysql-connector-java-5.1.5-bin.jar;D:\hibernate\tutorial\lib\servlet.jar;D:\hibernate\tutorial\lib\syndiag2.jar;D:\hibernate\tutorial\lib\versioncheck.jar;D:\hibernate\tutorial\lib\xml-apis.jar, hibernate.bytecode.use_reflection_optimizer=false, hbm2dll.auto=create, java.vm.specification.name=Java Virtual Machine Specification, java.vm.specification.version=1.0, sun.cpu.endian=little, sun.os.patch.level=Service Pack 2, connection.pool_size=1, java.io.tmpdir=C:\DOCUME~1\cj08\LOCALS~1\Temp\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, os.arch=x86, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.ext.dirs=C:\j2sdk1.4.2_14\jre\lib\ext, user.dir=D:\hibernate\tutorial, line.separator=
[java] , java.vm.name=Java HotSpot(TM) Client VM, cache.provider_class=org.hibernate.cache.NoCacheProvider, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.pool_size=1, hibernate.show_sql=true}
[java] 10:13:37,796 DEBUG AbstractEntityPersister:2738 - Static SQL for entity: events.Event
[java] 10:13:37,796 DEBUG AbstractEntityPersister:2743 - Version select: select EVENT_ID from EVENTS where EVENT_ID =?
[java] 10:13:37,796 DEBUG AbstractEntityPersister:2746 - Snapshot select: select event_.EVENT_ID, event_.EVENT_DATE as EVENT2_0_, event_.title as title0_ from EVENTS event_ where event_.EVENT_ID=?
[java] 10:13:37,796 DEBUG AbstractEntityPersister:2749 - Insert 0: insert into EVENTS (EVENT_DATE, title, EVENT_ID) values (?, ?, ?)
[java] 10:13:37,796 DEBUG AbstractEntityPersister:2750 - Update 0: update EVENTS set EVENT_DATE=?, title=? where EVENT_ID=?
[java] 10:13:37,796 DEBUG AbstractEntityPersister:2751 - Delete 0: delete from EVENTS where EVENT_ID=?
[java] 10:13:37,796 DEBUG AbstractEntityPersister:2755 - Identity insert: insert into EVENTS (EVENT_ID, EVENT_DATE, title) values (null, ?, ?)
[java] 10:13:37,828 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.EVENT_ID as EVENT1_0_0_, event0_.EVENT_DATE as EVENT2_0_0_, event0_.title as title0_0_ from EVENTS event0_ where event0_.EVENT_ID=?
[java] 10:13:37,828 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.EVENT_ID as EVENT1_0_0_, event0_.EVENT_DATE as EVENT2_0_0_, event0_.title as title0_0_ from EVENTS event0_ where event0_.EVENT_ID=?
[java] 10:13:37,828 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.EVENT_ID as EVENT1_0_0_, event0_.EVENT_DATE as EVENT2_0_0_, event0_.title as title0_0_ from EVENTS event0_ where event0_.EVENT_ID=?
[java] 10:13:37,828 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.EVENT_ID as EVENT1_0_0_, event0_.EVENT_DATE as EVENT2_0_0_, event0_.title as title0_0_ from EVENTS event0_ where event0_.EVENT_ID=?
[java] 10:13:37,828 DEBUG EntityLoader:79 - Static select for entity events.Event: select event0_.EVENT_ID as EVENT1_0_0_, event0_.EVENT_DATE as EVENT2_0_0_, event0_.title as title0_0_ from EVENTS event0_ where event0_.EVENT_ID=?
[java] 10:13:37,843 DEBUG EntityLoader:34 - Static select for action ACTION_MERGE on entity events.Event: select event0_.EVENT_ID as EVENT1_0_0_, event0_.EVENT_DATE as EVENT2_0_0_, event0_.title as title0_0_ from EVENTS event0_ where event0_.EVENT_ID=?
[java] 10:13:37,843 DEBUG EntityLoader:34 - Static select for action ACTION_REFRESH on entity events.Event: select event0_.EVENT_ID as EVENT1_0_0_, event0_.EVENT_DATE as EVENT2_0_0_, event0_.title as title0_0_ from EVENTS event0_ where event0_.EVENT_ID=?
[java] 10:13:37,843 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
[java] 10:13:37,843 DEBUG SessionFactoryObjectFactory:76 - registered: 4028d6f3161fd2ce01161fd2d0330000 (unnamed)
[java] 10:13:37,843 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
[java] 10:13:37,843 DEBUG SessionFactoryImpl:308 - instantiated session factory
[java] 10:13:37,843 DEBUG SessionFactoryImpl:392 - Checking 0 named HQL queries
[java] 10:13:37,843 DEBUG SessionFactoryImpl:412 - Checking 0 named SQL queries
[java] 10:13:37,890 DEBUG SessionImpl:220 - opened session at timestamp: 11945348178
[java] 10:13:37,968 DEBUG ThreadLocalSessionContext:290 - allowing method [beginTransaction] in non-transacted context
[java] 10:13:37,968 DEBUG ThreadLocalSessionContext:300 - allowing proxied method [beginTransaction] to proceed to real session
[java] 10:13:37,968 DEBUG JDBCTransaction:54 - begin
[java] 10:13:37,968 DEBUG ConnectionManager:421 - opening JDBC connection
[java] 10:13:37,968 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
[java] 10:13:37,968 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
[java] 10:13:37,968 DEBUG JDBCTransaction:59 - current autocommit status: false
[java] 10:13:37,968 DEBUG JDBCContext:210 - after transaction begin
[java] 10:13:37,968 DEBUG ThreadLocalSessionContext:300 - allowing proxied method [save] to proceed to real session
[java] 10:13:38,000 DEBUG DefaultSaveOrUpdateEventListener:158 - saving transient instance
[java] 10:13:38,000 DEBUG AbstractSaveEventListener:153 - saving [events.Event#<null>]
[java] 10:13:38,000 DEBUG AbstractSaveEventListener:244 - executing insertions
[java] 10:13:38,015 DEBUG AbstractSaveEventListener:297 - executing identity-insert immediately
[java] 10:13:38,015 DEBUG AbstractEntityPersister:2144 - Inserting entity: events.Event (native id)
[java] 10:13:38,015 DEBUG AbstractBatcher:366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[java] 10:13:38,015 DEBUG SQL:401 - insert into EVENTS (EVENT_ID, EVENT_DATE, title) values (null, ?, ?)
[java] Hibernate: insert into EVENTS (EVENT_ID, EVENT_DATE, title) values (null, ?, ?)
[java] 10:13:38,015 DEBUG AbstractBatcher:484 - preparing statement
[java] 10:13:38,031 DEBUG JDBCExceptionReporter:69 - could not insert: [events.Event] [insert into EVENTS (EVENT_ID, EVENT_DATE, title) values (null, ?, ?)]
[java] java.sql.SQLException: Table not found: EVENTS in statement [insert into EVENTS (EVENT_ID, EVENT_DATE, title) values (null, ?, ?)]
[java] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
[java] at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
[java] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
[java] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
[java] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
[java] at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:30)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
[java] at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
[java] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
[java] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
[java] at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
[java] at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
[java] at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
[java] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
[java] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:324)
[java] at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301)
[java] at $Proxy0.save(Unknown Source)
[java] at events.EventManager.createAndStoreEvent(Unknown Source)
[java] at events.EventManager.main(Unknown Source)
[java] 10:13:38,031 WARN JDBCExceptionReporter:77 - SQL Error: -22, SQLState: S0002
[java] 10:13:38,031 ERROR JDBCExceptionReporter:78 - Table not found: EVENTS in statement [insert into EVENTS (EVENT_ID, EVENT_DATE, title) values (null, ?, ?)]
[java] org.hibernate.exception.SQLGrammarException: could not insert: [events.Event]
[java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
[java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
[java] at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:40)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
[java] at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
[java] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
[java] at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
[java] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
[java] at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
[java] at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
[java] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
[java] at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
[java] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
[java] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:324)
[java] at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301)
[java] at $Proxy0.save(Unknown Source)
[java] at events.EventManager.createAndStoreEvent(Unknown Source)
[java] at events.EventManager.main(Unknown Source)
[java] Caused by: java.sql.SQLException: Table not found: EVENTS in statement [insert into EVENTS (EVENT_ID, EVENT_DATE, title) values (null, ?, ?)]
[java] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
[java] at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
[java] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
[java] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
[java] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
[java] at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:30)
[java] ... 23 more
[java] Exception in thread "main"
BUILD SUCCESSFUL
Total time: 3 seconds
[/quote]
Login
FAQ
Search
