[esb-issues] [JBoss JIRA] Commented: (JBESB-1264) Add Datasource support to sql-provider
Tom Cunningham (JIRA)
jira-events at lists.jboss.org
Mon Oct 29 15:26:42 EDT 2007
[ http://jira.jboss.com/jira/browse/JBESB-1264?page=comments#action_12384927 ]
Tom Cunningham commented on JBESB-1264:
---------------------------------------
Datasource support has been added to <sql-provider>. For example, to enable this in the quickstart, you could replace :
<sql-provider name="SQLprovider"
url="jdbc:hsqldb:hsql://localhost:1703"
driver="org.hsqldb.jdbcDriver"
username="sa"
password="">
with
<sql-provider name="SQLprovider"
datasource="java:/QuickstartDB">
The SQL listener will throw exceptions if both a datasource and a url/driver/username/password combination are specified - only one (datasource or url/driver/username/pass) should be stored in the attributes of the sql-provider tag.
Using autoReconnect for datasources seems to be heavily dependent on the options given in the datasource config file - for example, getting this to work under Mysql required the autoReconnect connection property to be set to true and a check-valid-connection-sql string set. See the documentation of the driver you are using for details.
> Add Datasource support to sql-provider
> --------------------------------------
>
> Key: JBESB-1264
> URL: http://jira.jboss.com/jira/browse/JBESB-1264
> Project: JBoss ESB
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Transports
> Affects Versions: 4.2.1 IR2
> Reporter: Tom Cunningham
> Assigned To: Tom Cunningham
> Fix For: 4.2.1
>
>
> Add datasource support to sql-provider.
--
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
More information about the esb-issues
mailing list