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

[jarkko Lietolahti (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBESB-281?page=comments#action_12350653 ] 
            
jarkko Lietolahti commented on JBESB-281:
-----------------------------------------

The offending (or one of them) SQL clause is the last one:

--########################################################################
--#  Templating cdu-creators.
--########################################################################
insert into transformationresource (id, name, path, selector, useragent) values (1, '* XSLT Content Delivery Unit Creator (This resource is targeted at all Message Exchanges and is required for interpreting "xsl" resource types)', 'org.milyn.templating.xslt.XslContentDeliveryUnitCreator', 'cdu-creator', '*');
insert into transformationresourceparameter (id, name, value, transresource_id) values (1, 'restype', 'xsl', 1);


id=varchar
name=varchar
value=varbinary
type=varchar
transresource_id=varchar

so something wrong with varbinary accepting 'xsl' as it's value.

> 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
>
>
> 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