[jboss-jira] [JBoss JIRA] Commented: (JBESB-281) Fix conosle import.sql script execution for HSQLDB
[ 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