[
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