I'm facing with sql error while trying to run the spring booking
example with the H2 database.
I'm using seam 2.1.1 and jboss 4.3.2.
the given example works with HSQL and I need it to work with H2
database.
When I try to access to the webapp, I'm facing to the errors below:
WARN [JDBCExceptionReporter] SQL Error: 42001, SQLState: 42001
18:57:59,510 ERROR [JDBCExceptionReporter] Syntax error in SQL
statement SET CREATE_BUILD[*] 76;
expected AUTOCOMMIT, MVCC, IGNORECASE, PASSWORD, SALT, MODE,
COMPRESS_LOB, DATABASE, COLLATION,
CLUSTER, DATABASE_EVENT_LISTENER, ALLOW_LITERALS, DEFAULT_TABLE_TYPE,
CREATE, HSQLDB.DEFAULT_TABLE_TYPE,
CACHE_TYPE, FILE_LOCK, STORAGE, DB_CLOSE_ON_EXIT, ACCESS_MODE_LOG,
ASSERT, ACCESS_MODE_DATA, DATABASE_EVENT_LISTENER_OBJECT,
RECOVER, SCHEMA, DATESTYLE, SEARCH_PATH, SCHEMA_SEARCH_PATH, LOGSIZE;
SQL statement:
SET CREATE_BUILD 76 [42001-63]
I have made the necessary change for H2 and I really don't know why
I'm getting this error.
Here is an extract of my config file:
bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="org.h2.Driver"/>
<property name="url" value="jdbc:h2:C:/developpement/H2/db/
formation"/>
<property name="username" value="formation"/>
<property name="password" value="formation"/>
</bean>
<bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="persistenceUnitName"
value="bookingDatabase"/>
<!-- Use alternate location to prevent JBoss AS from
automatically loading persistence units (in-container) -->
<property name="persistenceXmlLocation"
value="classpath:META-INF/persistence-spring.xml"/>
<property name="jpaDialect">
<bean
class="org.springframework.orm.jpa.vendor.HibernateJpaDialect"/>
</property>
<property name="jpaVendorAdapter">
<bean
class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<property name="showSql" value="true"/
>
</bean>
</property>
<property name="jpaProperties">
<map>
<entry key="hibernate.dialect"
value="org.hibernate.dialect.H2Dialect"/>
<entry key="hibernate.format_sql"
value="true"/>
<entry key="hibernate.hbm2ddl.auto"
value="none"/>
</map>
</property>
</bean>
Any help would be appreciated.
Meissa
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
