[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4817) Using hsqldb, import.sql fails w/ HsqlException: 'unexpected end of statement' if statements span lines.
Chris Bedford (JIRA)
noreply at atlassian.com
Sun Jan 24 01:31:29 EST 2010
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=35319#action_35319 ]
Chris Bedford commented on HHH-4817:
------------------------------------
If anyone is interested I have a work around which is nicer than having all sql statements be on one line.
You can use this workaround if you are using Spring:
Basically you use the springbyexample site's SqlScriptProcessor in your spring bean definition file.
Note that I renamed import.sql to not_named_import.s_q_l so that import.sql would not get picked up.
<bean id="sqlScriptProcessor"
class="org.springbyexample.jdbc.core.SqlScriptProcessor" depends-on="sessionFactory">
<property name="dataSource" ref="dataSource" />
<property name="initOnStartup" value="true" />
<property name="sqlScripts">
<list>
<value>classpath:/not_named_import.s_q_l</value>
</list>
</property>
</bean>
Hope this is useful for others using Spring and Hibernate.
thanks,
Chris
**********
--
Chris Bedford
Founder & Lead Lackey
Build Lackey Labs
http://buildlackey.com
> Using hsqldb, import.sql fails w/ HsqlException: 'unexpected end of statement' if statements span lines.
> --------------------------------------------------------------------------------------------------------
>
> Key: HHH-4817
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4817
> Project: Hibernate Core
> Issue Type: Bug
> Environment: hsqldb - <artifactId>persistence-api</artifactId> <version>1.0</version> <artifactId>hibernate-entitymanager</artifactId> <version>3.2.1.ga</version>
> Reporter: Chris Bedford
> Priority: Minor
> Attachments: jpa-spring-example.tar.gz
>
>
> I have a very easily reproducible case that demonstrates this:
> I have a schema initialization script that i keep in import.sql. When I run the script with the contents
> of import.sql like this, SchemaExport finishes up with no complaint. (note all statements are on one line, with no newlines introduced for readability).
> *** import.sql - each statement on one lines - no spanning lines ****
> drop table UserLastNameHistory if exists;
> create table UserLastNameHistory ( id INTEGER GENERATED BY DEFAULT AS IDENTITY, userid bigint not null, prevLastName varchar(255), newLastName varchar(255), primary key (id) ) ;
> drop table User if exists;
> create table User (id bigint not null, firstName varchar(255), lastName varchar(255), primary key (id)) ;
> create trigger UserLastNameHistoryTrigger after update on User referencing new row as NEWER old row as OLDER FOR EACH ROW insert into UserLastNameHistory ( userid , prevLastName, newLastName) values (id, OLDER.lastName, NEWER.lastName) ;
> *****end: import.sql *************************
> Then when i introduce some newlines for readability I get the stack trace listed in Stack Trace, below.
> SchemaExport fails to complete. Note when i run the exact statements (with newlines) in a sql
> tool like squirrel it all runs fine.
> *** import.sql - same content : newlines introduced for readability ****
> drop table UserLastNameHistory if exists;
> create table UserLastNameHistory (
> id INTEGER GENERATED BY DEFAULT AS IDENTITY, userid bigint not null,
> prevLastName varchar(255), newLastName varchar(255), primary key (id) ) ;
> drop table User if exists;
> create table User (id bigint not null, firstName varchar(255), lastName varchar(255), primary key (id)) ;
> *****end: import.sql *************************
> I have attached a very simple project that reproduces this issue.
> to run it unzip it, go to top level directory and type
> mvn test
> Stack Trace
> p1785 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - schema export unsuccessful
> porg.hibernate.JDBCException: Error during import script execution
> at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:258)
> at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:192)
> at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
> at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:311)
> at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1291)
> at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:713)
> at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
> at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:204)
> at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:242)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429)
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:270)
> at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)
> at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:92)
> at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:77)
> at org.springframework.test.AbstractSingleSpringContextTests.loadContextLocations(AbstractSingleSpringContextTests.java:182)
> at org.springframework.test.AbstractSingleSpringContextTests.loadContext(AbstractSingleSpringContextTests.java:152)
> at org.springframework.test.AbstractSpringContextTests.getContext(AbstractSpringContextTests.java:105)
> at org.springframework.test.AbstractSingleSpringContextTests.setUp(AbstractSingleSpringContextTests.java:83)
> at junit.framework.TestCase.runBare(TestCase.java:125)
> at org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.java:69)
> at junit.framework.TestResult$1.protect(TestResult.java:106)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.framework.TestResult.run(TestResult.java:109)
> at junit.framework.TestCase.run(TestCase.java:118)
> at junit.framework.TestSuite.runTest(TestSuite.java:208)
> at junit.framework.TestSuite.run(TestSuite.java:203)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.maven.surefire.junit.JUnitTestSet.execute(JUnitTestSet.java:213)
> at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
> at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
> at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:338)
> at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:997)
> Caused by: java.sql.SQLException: Unexpected token: in statement [create table UserLastNameHistory (]
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
> at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:254)
> ... 45 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list