derby数据库:
?<jdbc:derby-data-source name="jdbcDataSource2" url="jdbc:derby:muleEmbeddedDB"/>
db2数据库:
??? <jdbc:db2-data-source name="db2ds" url="jdbc:db2:muleDatabase" database="mule" user="admin" password="secret"/>
MSSQL数据库:
??? <!-- this data source has both url and host configured, can only be one of both -->
??? <jdbc:mssql-data-source name="mysqlDs" url="jdbc:sqlserver://localhost/mule"
???????????????????????????? host="localhost" user="scott" password="tiger"/>
MySQL数据库:
??? <!-- this data source has both url and database configured, can only be one of both -->
??? <jdbc:mysql-data-source name="mysqlDs" url="jdbc:mysql://localhost/mule" database="mule"
??????? user="mysql" password="secret"/>
<!-- specify custom attributes of StandardDataSource --> <jdbc:oracle-data-source name="custom-ds-properties" user="scott" password="tiger" transactionIsolation="SERIALIZABLE" loginTimeout="42"/> <!-- Oracle --> <!-- using the default URL --> <jdbc:oracle-data-source name="default-oracle" user="scott" password="tiger"/> <!-- using a custom URL --> <jdbc:oracle-data-source name="custom-url-oracle" url="jdbc:oracle:thin:@some-other-host:1522:mule" user="scott" password="tiger"/> <!-- specify custom parts of the URL --> <jdbc:oracle-data-source name="custom-host-oracle" host="some-other-host" user="scott" password="tiger"/> <jdbc:oracle-data-source name="custom-port-oracle" port="1522" user="scott" password="tiger"/> <jdbc:oracle-data-source name="custom-instance-oracle" instance="mule" user="scott" password="tiger"/> <!-- MySQL --> <!-- using the default url --> <jdbc:mysql-data-source name="default-mysql" database="mule" user="mysql" password="secret"/> <!-- using a custom URL --> <jdbc:mysql-data-source name="custom-url-mysql" url="jdbc:mysql://mule-db-host:3306/mule" user="mysql" password="secret"/> <!-- custom parts of the msyql url --> <jdbc:mysql-data-source name="custom-host-mysql" host="some-other-host" database="mule" user="mysql" password="secret"/> <jdbc:mysql-data-source name="custom-port-mysql" port="4242" user="mysql" database="mule" password="secret"/> <!-- PostgreSQL --> <!-- using the default url --> <jdbc:postgresql-data-source name="default-postgresql" database="mule" user="postgres" password="secret"/> <!-- using a custom URL --> <jdbc:postgresql-data-source name="custom-url-postgresql" url="jdbc:postgresql://mule-db-host:5432/mule" user="postgres" password="secret"/> <!-- custom parts of the postgresql url --> <jdbc:postgresql-data-source name="custom-host-postgresql" host="some-other-host" database="mule" user="postgres" password="secret"/> <jdbc:postgresql-data-source name="custom-port-postgresql" port="5433" database="mule" user="postgres" password="secret"/> <!-- Derby --> <!-- using the default URL --> <jdbc:derby-data-source name="default-derby" database="mule"/> <!-- using a custom URL --> <jdbc:derby-data-source name="custom-url-derby" url="jdbc:derby:muleEmbedded"/> <!-- create the database --> <jdbc:derby-data-source name="create-database-derby" database="mule" create="true"/>
?