JBoss4 Data Source Configuration (2)

SYSBASE Database Configuration Sybase Adaptive Server Enterprises (ASE) is the Sysbase's database server. ASE can be used on UNIX and Linux platforms. Similarly, we have to drive its database into the classpath, copy it into the / server / default / lib directory, then copy the / DOCS / EXAMPLES / JCA / SYBASE-DS.XML to / Server / Default / Deploy directory . Modify the Sybase-DS.xml file

Set to com.sybase.jdbc2.jdbc.sybdriver

Set to JDBC: Sybase: TDS:

:

/

,among them

The host name, port name, and database name, respectively. Also need to modify Standardjaws.xml or Jaws.xml files

with

element:

Java: / Sybaseds

Sybase

Modify StandardJbossCMP-JDBC.XML or JBossCMP-JDBC.XML files

with

element:

Java: / Sybaseds

Sybase

Finally modify the login-config.xml file to use the SYSBASE database. Setting

element:

"Org.jboss.Resource.security.configuredIndityLoginmodule"

Flag = "Required">

SA

SA

JBoss.jca: service = localtxcm, name = Sybaseds

Modified Sybase-DS.xml, StandardJaws.xml, StandardJbosscmp-JDBC.XML, and you can use Sysbase in JBOSS after you and the login-config.xml file. DB2 Database Configuration IBM's DB2 is a perfect, easy to use the database server, which can be used on Linux, UNIX, and Windows platforms. Use DB2 on JBoss4 as long as you copy db2java.zip to the / Server / Default / Lib directory. Then copy the / DOCS / EXAMPLES / JCA / DB2- DS.XML to / Server / Default / Deploy directory, then modify the element bit com.ibm.db2.jdbc.app.db2driver,

Element is JDBC: DB2: where

Elements represent database service names.

Java: / db2ds

DB2

Here is the corresponding StandardJbosscmp-JDBC.XML (or JBossCMP-JDBC.XML) file:

Java: / db2ds

DB2

Finally, add the following in the Login-Config.xml file:

"Org.jboss.Resource.security.configuredIndityLoginmodule"

Flag = "Required">

Principal> SA

"Username"> SA

"Password">

JBoss.jca: service = localtxcm, name = db2ds

Complete the above configuration You can use the DB2 Informix database to configure IBM on JBOSS for data warehouses, analysis and reporting. Use the Informix database on JBoss4, first copy it to the / server / default / lib directory, then copy / serve / default / deploy In the directory, if you use a transaction (XA) JDBC, copy the /DOCS/examples/jca/informix-xa-ds.xml file. The next step is to modify this informix-ds.xml file, set the element to: com.informix.jdbc.ifxdriver

Element is set to

JDBC: Informix-Sqli: //

:

: InformixServer =

,

among them,

,

,

Represents the database hostname, database port, and database service name, respectively. Then modify the StandardJaws.xml or Jaws.xml file

with

element:

Java: / InformixDs

informixdb

Put the standardjbosscmp-jdbc.xml or jbosscmp-jdbc.xml file

with

The element is set to the following:

Java: / InformixDs

informixdb

Finally, add to the login-config.xml file

element:

"Org.jboss.Resource.security.configuredIndityLoginmodule"

Flag = "Required">

SA

SA

JBoss.jca: service = localtxcm, name = informixds