6.2 Deploying Connect Web in Oracle WebLogic 10 R3

Install Software License Key

The brickstlicense.jar file must be stored in the war file:

unzip connectweb.war WEB-INF/lib/brickstlicense.jar
cp import/brickstlicense.jar WEB-INF/lib
zip connectweb.war WEB-INF/lib/brickstlicense.jar

Define Data Source

For a SQL Server data source, WebLogic needs to have the drivers installed before the data source is created. Copy the JDBC Driver jar to the WebLogic server directory:

cd import/SQL2005_jdk/common
cp sqljdbc4.jar /opt/bea/wlserver_10.3/server/lib

cd import\SQL2005_jdk\common
copy sqljdbc4.jar C:\jboss-4.2.3.GA\server\default\lib

Then edit the WebLogic startup script /opt/bea/wlserver_10.3/common/bin/commEnv.sh C:\bea\wlserver_10.3\common\bin\commEnv.cmd to add the SQL Server jar file to the WebLogic class path.

Add this line after the definition of WEBLOGIC_CLASSPATH to append the SQL Server jar file:

WEBLOGIC_CLASSPATH="${WEBLOGIC_CLASSPATH}${CLASSPATHSEP}${WL_HOME}/server/lib/sqljdbc4.jar"

set WEBLOGIC_CLASSPATH=%WEBLOGIC_CLASSPATH%;%WL_HOME%\server\lib\sqljdbc4.jar

Then save the file and restart the WebLogic Server Domain.

For an Oracle data source, WebLogic already includes the Oracle JDBC Driver jars.

The Connect Web application requires a J2EE data source to be defined in the WebLogic console. Go to Services > JDBC > Data Sources, click new, and follow the wizard to create a data source with this jndi name : jdbc/BRICK_STREET_SOFTWARE_CONNECT_DS.

For an Oracle data source, the Database Type should be "Oracle" and the Database Driver should be "Oracle's Driver (Thin) Versions: 9.0.1,9.2.0,10,11". For an SQL Server data source, the Database Type should be "MS SQL Server" and the Database Driver should be "Microsoft's MS SQL Server Driver(Type 4) Versions:2005". In the "Transaction Options" screen, uncheck "Supports Global Transactions". In the "Connection Options" screen, specify the server name, database name, user name, and password as appropriate. In the "Test Database Connection" screen, click the "Test Configuration" button to verify that the classpath and other settings are correct. In the final screen, select the deployment targets for the new data source and click Finish.

Deploy connectweb.war to the WebLogic Server

Deploy the connectweb.war file to the WebLogic application server. If the WebLogic server is listening on port 7001 (the default), start Connect by opening http://localhost:7001/connectweb/surveySuccess.jsp in a browser.