[jboss-jira] [JBoss JIRA] Closed: (JBESB-281) Fix conosle import.sql script execution for HSQLDB

[Tom Fennelly (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBESB-281?page=all ]

Tom Fennelly closed JBESB-281.
------------------------------

    Resolution: Done

Fixed.

As it turns out, it wasn't actually an issue with the import.sql script.  It was because we had a few byte[] properties on some of the components.  Once I changed them to String and annotated them as @Lob (for Hibernate), all was rosie in the garden.

T.

> Fix conosle import.sql script execution for HSQLDB
> --------------------------------------------------
>
>                 Key: JBESB-281
>                 URL: http://jira.jboss.com/jira/browse/JBESB-281
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Tooling
>    Affects Versions: 4.0 CR1
>            Reporter: Tom Fennelly
>         Assigned To: Tom Fennelly
>             Fix For: 4.0
>
>         Attachments: CONSOLE-import.sql
>
>
> Hibernate/HSQLDB (possibly the Hibernate HSQLDB dialect impl) throws an exception when executing the import.sql script (it's just a seeding script - load of insert statements).  Syas there are characters in the script the it down't like.  Same script runs fine on postgres.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira