Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F95070252
10-write-i2b2-datasources.sh
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Thu, Dec 12, 15:22
Size
10 KB
Mime Type
text/x-shellscript
Expires
Sat, Dec 14, 15:22 (2 d)
Engine
blob
Format
Raw Data
Handle
22927145
Attached To
R4444 MedCo Deployment
10-write-i2b2-datasources.sh
View Options
#!/bin/bash
set
-Eeuo pipefail
cat >
"$JBOSS_WAR_DEPLOYMENTS/pm-ds.xml"
<<EOL
<?xml version="1.0" encoding="UTF-8"?>
<datasources xmlns="http://www.jboss.org/ironjacamar/schema">
<datasource jta="false" jndi-name="java:/PMBootStrapDS"
pool-name="PMBootStrapDS" enabled="true" use-ccm="false">
<connection-url>jdbc:postgresql://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME?currentSchema=i2b2pm</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>$PG_JDBC_JAR</driver>
<security>
<user-name>$I2B2_DB_USER</user-name>
<password>$I2B2_DB_PW</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>
</datasources>
EOL
cat >
"$JBOSS_WAR_DEPLOYMENTS/ont-ds.xml"
<<EOL
<?xml version="1.0" encoding="UTF-8"?>
<datasources xmlns="http://www.jboss.org/ironjacamar/schema">
<datasource jta="false" jndi-name="java:/OntologyBootStrapDS"
pool-name="OntologyBootStrapDS" enabled="true" use-ccm="false">
<connection-url>jdbc:postgresql://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME?currentSchema=i2b2hive</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>$PG_JDBC_JAR</driver>
<security>
<user-name>$I2B2_DB_USER</user-name>
<password>$I2B2_DB_PW</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:/OntologyDemoDS"
pool-name="OntologyDemoDS" enabled="true" use-ccm="false">
<connection-url>jdbc:postgresql://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME?currentSchema=i2b2metadata_i2b2</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>$PG_JDBC_JAR</driver>
<security>
<user-name>$I2B2_DB_USER</user-name>
<password>$I2B2_DB_PW</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>
</datasources>
EOL
cat >
"$JBOSS_WAR_DEPLOYMENTS/crc-ds.xml"
<<EOL
<?xml version="1.0" encoding="UTF-8"?>
<datasources xmlns="http://www.jboss.org/ironjacamar/schema">
<datasource jta="false" jndi-name="java:/CRCBootStrapDS"
pool-name="CRCBootStrapDS" enabled="true" use-ccm="false">
<connection-url>jdbc:postgresql://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME?currentSchema=i2b2hive</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>$PG_JDBC_JAR</driver>
<security>
<user-name>$I2B2_DB_USER</user-name>
<password>$I2B2_DB_PW</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://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME?currentSchema=i2b2demodata_i2b2</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>$PG_JDBC_JAR</driver>
<security>
<user-name>$I2B2_DB_USER</user-name>
<password>$I2B2_DB_PW</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>
</datasources>
EOL
cat >
"$JBOSS_WAR_DEPLOYMENTS/work-ds.xml"
<<EOL
<?xml version="1.0" encoding="UTF-8"?>
<datasources xmlns="http://www.jboss.org/ironjacamar/schema">
<datasource jta="false" jndi-name="java:/WorkplaceBootStrapDS"
pool-name="WorkplaceBootStrapDS" enabled="true" use-ccm="false">
<connection-url>jdbc:postgresql://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME?currentSchema=i2b2hive</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>$PG_JDBC_JAR</driver>
<security>
<user-name>$I2B2_DB_USER</user-name>
<password>$I2B2_DB_PW</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:/WorkplaceDemoDS"
pool-name="WorkplaceDemoDS" enabled="true" use-ccm="false">
<connection-url>jdbc:postgresql://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME?currentSchema=i2b2workdata</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>$PG_JDBC_JAR</driver>
<security>
<user-name>$I2B2_DB_USER</user-name>
<password>$I2B2_DB_PW</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>
</datasources>
EOL
cat >
"$JBOSS_WAR_DEPLOYMENTS/im-ds.xml"
<<EOL
<?xml version="1.0" encoding="UTF-8"?>
<datasources xmlns="http://www.jboss.org/ironjacamar/schema">
<datasource jta="false" jndi-name="java:/IMBootStrapDS"
pool-name="IMBootStrapDS" enabled="true" use-ccm="false">
<connection-url>jdbc:postgresql://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME?currentSchema=i2b2hive</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>$PG_JDBC_JAR</driver>
<security>
<user-name>$I2B2_DB_USER</user-name>
<password>$I2B2_DB_PW</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:/IMDemoDS"
pool-name="IMDemoDS" enabled="true" use-ccm="false">
<connection-url>jdbc:postgresql://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME?currentSchema=i2b2imdata</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<driver>$PG_JDBC_JAR</driver>
<security>
<user-name>$I2B2_DB_USER</user-name>
<password>$I2B2_DB_PW</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>
</datasources>
EOL
#cat > "$I2B2_SRC_DIR/edu.harvard.i2b2.crc/etc/spring/CRCLoaderApplicationContext.xml" <<EOL
#<?xml version="1.0" encoding="UTF-8"?>
#<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
#<beans>
# <bean id="jaxbPackage"
# class="org.springframework.beans.factory.config.ListFactoryBean">
# <property name="sourceList">
# <list>
# <value>edu.harvard.i2b2.crc.loader.datavo.loader.query</value>
# <value>edu.harvard.i2b2.crc.datavo.pdo</value>
# <value>edu.harvard.i2b2.crc.datavo.i2b2message</value>
# <value>edu.harvard.i2b2.crc.datavo.pm</value>
# <value>edu.harvard.i2b2.crc.loader.datavo.fr</value>
# </list>
# </property>
# </bean>
#
# <bean id="appType" class="edu.harvard.i2b2.crc.datavo.i2b2message.ApplicationType">
# <property name="applicationName" value="CRC Cell" />
# <property name="applicationVersion" value="1.7" />
# </bean>
#
#
#
# <bean id="message_header"
# class="edu.harvard.i2b2.crc.datavo.i2b2message.MessageHeaderType">
# <property name="sendingApplication" ref="appType" />
# </bean>
#
# <bean id="CRCBootstrapDS" class="org.apache.commons.dbcp.BasicDataSource"
# destroy-method="close">
# <property name="driverClassName" value="org.postgresql.Driver" />
# <property name="url" value="jdbc:postgresql://$I2B2_DB_HOST:$I2B2_DB_PORT/$I2B2_DB_NAME" />
# <property name="username" value="$I2B2_DB_USER" />
# <property name="password" value="$I2B2_DB_PW" />
# </bean>
#</beans>
#EOL
Event Timeline
Log In to Comment