Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Oracle Database


Code Block
xml
xml

<datasource jta="false" jndi-name=<CRC_DB_LOOKUP datasource value>
	"java:/CRCBootStrapDS"
    pool-name="CRCBootStrapDS" enabled="true" use-ccm="false">
	    <connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection-url>
	    <driver-class>oracle.jdbc.OracleDriver</driver-class>
	    <driver>ojdbc6.jar</driver>
	    <security>
		        <user-name>i2b2hive</user-name>
		        <password>demouser</password>
	    </security>
	    <validation>
		        <validate-on-match>false</validate-on-match>
		        <background-validation>false</background-validation>
	    </validation>
	    <statement>
		        <share-prepared-statements>false</share-prepared-statements>
	    </statement>
</datasource>
<datasource jta="false" jndi-name=<crcdata tables datasource value>
	"java:/<CRC_DB_LOOKUP.C_DB_DATASOURCE value>"
    pool-name="QueryToolDemoDS<CRC_DB_LOOKUP.C_DB_DATASOURCE value>" enabled="true" use-ccm="false">
	    <connection-url>jdbc:oracle:thin:@localhost:1521:XE</connection-url>
	    <driver-class>oracle.jdbc.OracleDriver</driver-class>
	    <driver>ojdbc6.jar</driver>
	    <security>
		        <user-name>i2b2demodata</user-name>
		        <password>demouser</password>
	    </security>
	    <validation>
		        <validate-on-match>false</validate-on-match>
		        <background-validation>false</background-validation>
	    </validation>
	    <statement>
		        <share-prepared-statements>false</share-prepared-statements>
	    </statement>
</datasource>



PostgreSQL Database


Code Block
xml
xml
<datasource jta="false" jndi-name="java:/CRCBootStrapDS"
	pool-name="CRCBootStrapDS" enabled="true" use-ccm="false">
	<connection-url>jdbc:postgresql://localhost:5432/i2b2</connection-url>
	<driver-class>org.postgresql.Driver</driver-class>
	<driver>postgresql-9.2-1002.jdbc4.jar</driver>
	<security>
		<user-name>i2b2hive</user-name>
		<password>demouser</password>
	</security>
	<validation>
		<validate-on-match>false</validate-on-match>
		<background-validation>false</background-validation>
	</validation>
	<statement>
		<share-prepared-statements>false</share-prepared-statements>
	</statement>
</datasource>
<datasource jta="false" jndi-name="java:/QueryToolDemoDS"
	pool-name="QueryToolDemoDS" enabled="true" use-ccm="false">
	<connection-url>jdbc:postgresql://localhost:5432/i2b2</connection-url>
	<driver-class>org.postgresql.Driver</driver-class>
	<driver>postgresql-9.2-1002.jdbc4.jar</driver>
	<security>
		<user-name>i2b2demodata</user-name>
		<password>demouser</password>
	</security>
	<validation>
		<validate-on-match>false</validate-on-match>
		<background-validation>false</background-validation>
	</validation>
	<statement>
		<share-prepared-statements>false</share-prepared-statements>
	</statement>
</datasource>


...