Saturday, June 23, 2007

Deployment Seam Application against Oracle 10g database to Jboss 4.0.5
utilizing Seam Plugin for NetBeans 5.5.1 on CentOS 5.0

To tune Jboss 4.0.5 instance as advised in [1] and make it connects to Oracle Server, perform the following steps on the JBoss Application Server:
Download the JDBC driver for Oracle 10g Release 2 located at:
For the Oracle JDBC driver with JDK 1.4 and 1.5, use the ojdbc14.jar file.
Copy the JDBC driver to the JBoss environment by entering the following:
# cp ojdbc14.jar $JBOSS_HOME/server/default/lib
Create a file named $JBOSS_HOME/server/default/deploy/oracle-ds.xml and add the following contents:

<connection-url>jdbc:oracle:thin:@IP_OR_HOSTNAME_OF _ORACLE_DB_ SERVER:1521:ORACLE_SID

Testing the Oracle Database Connectivity
Test the connectivity between JBoss and Oracle by performing the following steps on the JBoss Application Server:
Create a JSP file named $JBOSS_HOME/server/default/deploy/jmx-console.war/oracleTest.jsp and add the following contents:

<%@page contentType="text/html" import="*,java.util.*,org.jboss.jmx.adaptor.model.*,*,java.sql.*,javax.sql.*,javax.naming.*"%>
<title>JBoss->Oracle Test </title>
<link rel="stylesheet" href="style_master.css" type="text/css">
<meta http-equiv="cache-control" content="no-cache">
InitialContext ctx = new InitialContext();
DatabaseMetaData dm = null;
DataSource ds = (DataSource)
Connection conn = null;
Statement stmt = null;
try {
conn = ds.getConnection();
dm =conn.getMetaData();
out.println("Connected to-> database version "+dm.getDatabaseProductVersion());
}catch (Exception sqlex) {

Start JBoss by entering the following:
# $JBOSS_HOME/bin/
Verify that the Oracle test page is displayed by opening a browser and navigating to the following URL:

JDK version has been used 1.5.09. You might experience problems with 1.6.01.

Install Seam Plugin [2] and facelets support for NetBeans 5.5.1.
Register Jboss 4.0.5 instance with NetBeans and proceed following [2]

Unload NetBeans IDE, restart Jboss to make sure application run stable.