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 C:\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 an SQL Server data source, copy the JDBC Driver jar to the JBoss server directory:

cd import
copy sqljdbc4.jar C:\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\SQL2005_jdk\common
copy mysql-connector-java-5.1.13-bin.jar C:\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
copy ojdbc6.jar C:\jboss-4.2.3.GA\server\default\lib    
copy orai18n.jar C:\jboss-4.2.3.GA\server\default\lib    

Modify the properties-service.xml file in the C:\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:

copy connectweb.war C:\jboss-4.2.3.GA\server\default\deploy\connectweb.war