• Topic
  • Discussion
    • UdaWikiWeb.JDBCAppServerJbosLinux(Last) -- Owiki? , 2016-08-19 15:00:29 Edit
    [TXT]
    [PLAIN]
    [DOCBOOK]
    owiki 2016-08-19 15:00:29

    Using UDA with JBoss 4.0.3 (Linux)





    Required components

    You will need to download the following components

    Install JDK

    Install the JDK by running the *.bin, which automatically extracts the JDK.

    NOTE: You may need to set the execute permission on the bin file before it can be executed.

    Set Environment Variables

    The following environment variables must be set -- 

      export JAVA_HOME=/usr/java/jre1.5.0_05
  export PATH=$PATH:/usr/java/jdk1.5.0_05/bin


    The simplest way is to add these to your -- ~/.bash_profile= (or similar, depending on $SHELL) to ensure they are set every time you log in.

    NOTE: Paths to your Java installation will most likely differ!

    Install JBoss

    Installing JBoss by running gunzip and tar against the downloaded *.tar.gz file which will extract the archive into the current working directory. 

    gunzip *.tar.gz
tar -xvf *.tar


    The root install directory of JBoss will be known as; $JBOSS_DIST

    Starting JBoss

    Start JBoss using the command -- 

    $JBOSS_DIST/bin/run.sh


    Browse to the following url to verify that JBoss is up and running -- 

    http://tomcat_server:8080


    NOTE: JBoss may take several minutes to start.

    Install OpenLink jar files

    Copy the .jar file chosen for your JDK/JVM/JRE
    into the directory --
    $JBOSS_DIST/server/default/lib

    Stop and restart JBoss with the commands --
    Control-C will stop JBoss
    $JBOSS_DIST/bin/run.sh

    Create the data sources file

    JBoss requires a special file to declare the data sources.

    Create a new file --
    $JBOSS_DIST/server/default/deploy/opltest-ds.xml

    to include the following data sources --

    <?xml version="1.0" encoding="UTF-8"?>

<!--  Datasource config for OpenLink -->

<local-tx-datasource>
  <jndi-name>jdbc/o32opljdbc1</jndi-name>
  <connection-url>jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa</connection-url>
  <driver-class>openlink.jdbc.Driver</driver-class>
  <user-name>sa</user-name>
  <password>sa</password>
</local-tx-datasource>

<local-tx-datasource>
  <jndi-name>jdbc/m32opljdbc1</jndi-name>
  <connection-url>jdbc:openlink://192.168.0.150:5000/SVT=SQLServer 2000/Database=Northwind/options=-H 192.168.0.150/UID=sa/PWD=sa</connection-url>
  <driver-class>openlink.jdbc.Driver</driver-class>
  <user-name>sa</user-name>
  <password>sa</password>
</local-tx-datasource>

<local-tx-datasource>
  <jndi-name>jdbc/o32opljdbc2</jndi-name>
  <connection-url>jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa</connection-url>
  <driver-class>openlink.jdbc2.Driver</driver-class>
  <user-name>sa</user-name>
  <password>sa</password>
</local-tx-datasource>

<local-tx-datasource>
  <jndi-name>jdbc/m32opljdbc2</jndi-name>
  <connection-url>jdbc:openlink://192.168.0.150:5000/SVT=SQLServer 2000/Database=Northwind/options=-H 192.168.0.150/UID=sa/PWD=sa</connection-url>
  <driver-class>openlink.jdbc2.Driver</driver-class>
  <user-name>sa</user-name>
  <password>sa</password>
</local-tx-datasource>

<local-tx-datasource>
  <jndi-name>jdbc/o32opljdbc3</jndi-name>
  <connection-url>jdbc:openlink://192.168.0.150:5000/SVT=Odbc/Database=sqlserver/UID=sa/PWD=sa</connection-url>
  <driver-class>openlink.jdbc3.Driver</driver-class>
  <user-name>sa</user-name>
  <password>sa</password>
</local-tx-datasource>

<local-tx-datasource>
  <jndi-name>jdbc/m32opljdbc3</jndi-name>
  <connection-url>jdbc:openlink://192.168.0.150:5000/SVT=SQLServer 2000/Database=Northwind/options=-H 192.168.0.150/UID=sa/PWD=sa</connection-url>
  <driver-class>openlink.jdbc3.Driver</driver-class>
  <user-name>sa</user-name>
  <password>sa</password>
</local-tx-datasource>

</datasources>


    NOTE: You will need to amend URLs, usernames and passwords as appropriate.

    Prepare the Web Application

    Demonstrating how to build and deploy a Web application from the beginning is beyond the scope of this short tutorial so what follows is a quick method of altering the JDBC URLs and SQL statements in an existing Web application.

    NOTE: Be careful when moving .war files about using Internet Explorer. Sometimes they will be renamed to .zip by Internet Explorer.

    Rename the .war file to .zip

    Rename - opltest.war -to- opltest.zip

    You will then be able to unzip the archive to get at the files inside it. (Some utilities can unzip the .war archive without renaming.)
    unzip opltest.zip

    Edit JDBC URLs

    Edit the driver class and the JDBC connection URL in the file --
    /META-INF/context.xml

    NOTE: Ensure that the edited file is placed back into the archive.
    zip -r ../opltest *

    Edit the SQL statement(s)

    You will need to edit the SQL statement(s) in the following JSP files based on the chosen database determined by the JDBC URL in the file --
    /META-INF/context.xml

    Edit the JSP files -- 

    opljdbc.jsp
opljdbc2.jsp 
opljdbc3.jsp


    There are two main areas of interest --

    1. The <sql:query> tag which select the datasource as defined in - /META-INF/context.xml

      which contains the SQL query itself --

      <sql:query var="resultset" dataSource="jdbc/opljdbc2">
      select SupplierID, CompanyName, ContactName, ContactTitle from Suppliers
      </sql:query>


    2. The one or more ${row.column_name} constructs that output data as per the SQL query

      ${row.SupplierID}
      ${row.CompanyName}


    NOTE: Ensure that the edited file is placed back into the archive.
    zip -r ../opltest *

    Rename the .zip file back to .war

    Rename the file opltest.zip back to opltest.war

    Deploy opltest Web Application

    Deploying on JBoss is simply a case of placing the Web application --
    opltest.war

    into the following directory --
    $JBOSS_DIST/server/default/deploy

    The newly deployed application is now available at the following URL --
    http://jboss_server:8080/opltest

    Referenced by...