6.3 Deploying Connect Web in RedHat JBoss 4.2.3

Connect Web requires a J2EE data source to be defined by the JBoss application server. Connect includes template data source files in the import/jboss subdirectory of the Connect install directory. There are three template data source files:

• connect-mssql-ds.xml
• connect-mysql-ds.xml
• connect-oracle-ds.xml

Copy one of these files (depending on whether you want to configure an Oracle, SQL Server, or MySQL data source) to the JBoss deployment directory (typically /opt/jboss-4.2.3.GA/server/default/deploy). Then edit the XML file (connect-mssql-ds.xml or connect-oracle-ds.xml) substituting the following values:

• %DATABASE_SERVER% - with the name or address of the database server
• %DATABASE_NAME% - with the name of the database
• %USER% - user name for logging in to database
• %PASSWORD% - password logging in to database

Do not modify any other part of the data source definition file.

For a SQL Server data source, copy the JDBC Driver jar to the JBoss server directory:

cd import
cp sqljdbc4.jar /opt/jboss-4.2.3.GA/server/default/lib    

For a MySQL data source, copy the JDBC Driver jar to the JBoss server directory:

cd import
cp mysql-connector-java-5.1.13-bin.jar /opt/jboss-4.2.3.GA/server/default/lib    

For an Oracle data source, copy the JDBC Driver jar to the JBoss server directory:

cd import/Oracle11107_jdk6/common
cp ojdbc6.jar /opt/jboss-4.2.3.GA/server/default/lib    
cp orai18n.jar /opt/jboss-4.2.3.GA/server/default/lib    

Modify the properties-service.xml file in the /opt/jboss-4.2.3.GA/server/default/deploy directory:

• Search for the element that starts with <attribute name="properties">
• Uncomment this element if it is commented out
• Add the following line to the text of the element: "jndi.ds.prefix=java:"

The edited element should look like this:

<attribute name="Properties">
     jndi.ds.prefix=java:
</attribute>    

Deploy the connectweb.war file to the JBoss application server by copying it to the JBoss deployment directory:

cp connectweb.war /opt/jboss-4.2.3.GA/server/default/deploy/connectweb.war