Sample Data Sources

You can create data sources for Oracle, SQL Server, and PostgreSQL databases. Refer to the sample data sources while configuring TIBCO MDM with JBoss WildFly application server. The sample data sources are available in the standalone.xml file.

Sample data source for the Oracle database

...
...
<datasources>
...
...
   <datasource jndi-name="java:jboss/eCMDataSource" pool-name="MDMDATAsource" jta="true" enabled="true" use-ccm="true">
     <connection-url>jdbc:oracle:thin:@localhost:1521:orcl</connection-url>
     <driver>OracleDriver</driver>
     <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
     		<pool>
       			<min-pool-size>10</min-pool-size>
     					  	<max-pool-size>150</max-pool-size>
     </pool>
     <security>
			       						<user-name>mdmuser</user-name>
			     						  <password>mdmpassword</password>
     </security>
     <validation>
			     						  <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"></valid-connection-checker>
			     						  <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"></stale-connection-checker>
			     						  <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"></exception-sorter>
     </validation>
		     <timeout>
       									<blocking-timeout-millis>72000</blocking-timeout-millis>
		     </timeout>
	   </datasource>
   	<drivers>
		...
		...
       									<driver name="OracleDriver" module="com.oracle.ojdbc6">
       									<driver-class>oracle.jdbc.OracleDriver</driver-class>
		       									</driver>
		...
		...
   	</drivers>
</datasources>
...
...
Note: To establish the connection validator work with JBoss WildFly 10.1.0 and Oracle, you must modify the module.xml file to add com.oracle.ojdbc6 in the dependencies list. The file is located at $JBOSS_HOME\modules\system\layers\base\org\jboss\ironjacamar\jdbcadapters\main.

Sample data source for the SQL Server database

...
...
<datasources>
...
...
   	<datasource jndi-name="java:jboss/eCMDataSource" pool-name="MDMDATAsource" jta="true" enabled="true" use-ccm="true">
		     <connection-url>jdbc:sqlserver://localhost:1433;databaseName=velodb</connection-url>
		     <driver>SQLServerDriver</driver>
     <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
		     <pool>
       			<min-pool-size>10</min-pool-size>
			       <max-pool-size>150</max-pool-size>
     		</pool>
     		<security>
       			<user-name>mdmuser</user-name>
       			<password>mdmpassword</password>
		     		</security>
		     <validation>
       <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>
		     </validation>
		     <timeout>
			       <blocking-timeout-millis>72000</blocking-timeout-millis>
     		</timeout>
	   	</datasource>
		   <drivers>
		...
		...
					       <driver name="SQLServerDriver" module="com.microsoft.sqlserver">						       <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
		       </driver>
		...
		...
	   	</drivers>
</datasources>
...
...

Sample data source for the PostgreSQL database

...
...
<datasources>
...
...
	   <datasource jndi-name="java:jboss/eCMDataSource" pool-name="MDMDATAsource" jta="true" enabled="true" use-ccm="true">
     <connection-url>jdbc:postgresql://localhost:5432/velodb</connection-url>
     		<driver>PostgresqlDriver</driver>		     <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
     		<pool>
			       			<min-pool-size>10</min-pool-size>
       						<max-pool-size>150</max-pool-size>
     		</pool>
     		<security>
       						<user-name>mdmuser</user-name>
       						<password>mdmpassword</password>
     		</security>
     		<validation>
       						<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"></valid-connection-checker>
       						<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"></exception-sorter>
     </validation>
     		<timeout>
			       			<blocking-timeout-millis>72000</blocking-timeout-millis>
     		</timeout>
	   	</datasource>
		   <drivers>
		...
		...
							       <driver name="PostgresqlDriver" module="org.postgresql">
								       <driver-class>org.postgresql.Driver</driver-class>
							       </driver>
		...
		...
	   	</drivers>
</datasources>
...
...