下面的配置适用于webloic 6.x/7.x/8.x的config.xml文件
cloudscape configuration
for further information on cloudscape, including how to get an evaluation version and how to buy the software.
name="cloudscape" password="password"
properties="user=user;dbserver=localhost" targets="myserver"
testtablename="sql select 1"
url="jdbc:cloudscape:database;create=true"/>
db2 configuration
in weblogic type 4 jdbc drivers.
name="-db2-xa" password="password"
properties="user=user;portnumber=port;databasename=database;servername=hostname;batchperformanceworkaround=true"
targets="myserver"
testtablename="sql select count(*) from sysibm.systables"
url="jdbc:bea:db2://hostname:port"/>
db2 configuration - non-xa
see above.
name="-db2" password="password"
properties="user=user;portnumber=port;databasename=database;servername=hostname;batchperformanceworkaround=true"
targets="myserver"
testtablename="sql select count(*) from sysibm.systables"
url="jdbc:bea:db2://hostname:port"/>
db2 configuration - datadirect xa
see for more information on getting an evaluation copy of this driver or purchasing the software. the associated jar files are db2.jar, base.jar, and util.jar.
name="dd-db2-xa" password="password"
properties="user=user;portnumber=port;databasename=database;servername=hostname;batchperformanceworkaround=true"
targets="myserver"
testtablename="sql select count(*) from sysibm.systables"
url="jdbc:datadirect:db2://hostname:port"/>
db2 configuration - datadirect non-xa
see above.
name="dd-db2" password="password"
properties="user=user;portnumber=port;databasename=database;servername=hostname;batchperformanceworkaround=true"
targets="myserver"
testtablename="sql select count(*) from sysibm.systables"
url="jdbc:datadirect:db2://hostname:port"/>
db2 configuration - ibm xa
see for further information on db2, including how to get a free client sdk and how to buy the software.
the software is by default installed in c:/program files/ibm on windows. the jar files are sqllib/java/db2java.zip and sqllib/java/db2jcc.jar. the path to sqllib/bin must be added to the path.
the database must be configured on the client side using the db2 command line processor. for example,
run ibm db2 -> command line tools -> command line processor
db2 => catalog tcpip node nodename remote hostname server port
db2 => catalog database database as alias at node nodename
see the following weblogic server documents for more information:
name="ibm-db2-xa" password="password"
properties="user=user;databasename=database" targets="myserver"
testtablename="sql select count(*) from sysibm.systables"
url="jdbc:db2:database"/>
db2 configuration - ibm non-xa
see above.
name="ibm-db2" password="password"
properties="user=user;databasename=database" targets="myserver"
testtablename="sql select count(*) from sysibm.systables"
url="jdbc:db2:database"/>
informix configuration
in weblogic type 4 jdbc drivers.
drivername="weblogic.jdbcx.informix.informixdatasource"
name="-informix-xa" password="password"
properties="informixserver=ifxserver;user=user;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from systables"
url="jdbc:bea:informix://hostname:port;informixserver=ifxserver;databasename=database"/>
informix configuration - non-xa
see above.
drivername="weblogic.jdbc.informix.informixdriver"
name="-informix" password="password"
properties="informixserver=ifxserver;user=user;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from systables"
url="jdbc:bea:informix://hostname:port;informixserver=ifxserver;databasename=database"/>
informix configuration - datadirect xa
see for more information on getting an evaluation copy of this driver or purchasing the software. the associated jar files are informix.jar, base.jar, and util.jar.
drivername="com.ddtek.jdbcx.informix.informixdatasource"
name="dd-informix-xa" password="password"
properties="informixserver=ifxserver;user=user;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from systables"
url="jdbc:datadirect:informix://hostname:port;informixserver=ifxserver;databasename=database"/>
informix configuration - datadirect non-xa
see above.
drivername="com.ddtek.jdbc.informix.informixdriver"
name="dd-informix" password="password"
properties="informixserver=ifxserver;user=user;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from systables"
url="jdbc:datadirect:informix://hostname:port;informixserver=ifxserver;databasename=database"/>
informix configuration - ibm xa
see for further information on informix, including how to get a free client sdk and how to buy the software. also see for more information about using this driver with weblogic server.
the associated jar files are ifxjdbc.jar and ifxjdbcx.jar.
name="ibm-informix-xa" password="password"
properties="user=user;url=jdbc:informix-sqli://hostname:port/database:informixserver=ifxserver;portnumber=port;databasename=database;ifxifxhost=hostname;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from systables"
url="jdbc:informix-sqli://hostname:port/database:informixserver=ifxserver"/>
informix configuration - ibm non-xa
see above.
name="ibm-informix" password="password"
properties="user=user;url=jdbc:informix-sqli://hostname:port/database:informixserver=ifxserver;portnumber=port;databasename=database;ifxifxhost=hostname;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from systables"
url="jdbc:informix-sqli://hostname:port/database:informixserver=ifxserver"/>
ms sql server configuration
in weblogic type 4 jdbc drivers.
drivername="weblogic.jdbcx.sqlserver.sqlserverdatasource"
name="-sqlserver-xa"
password="password"
properties="user=user;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:bea:sqlserver://hostname:port"/>
ms sql server configuration - non-xa
see above.
drivername="weblogic.jdbc.sqlserver.sqlserverdriver"
name="-sqlserver" password="password"
properties="user=user;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:bea:sqlserver://hostname:port"/>
ms sql server configuration - datadirect xa
see for more information on getting an evaluation copy of this driver or purchasing the software. the associated jar files are sqlserver.jar, base.jar, and util.jar. additionally, the files instjdbc.sql and sqljdbc.dll need to be installed on the server side; see the documentation.
drivername="com.ddtek.jdbcx.sqlserver.sqlserverdatasource"
name="dd-sqlserver-xa" password="password"
properties="user=user;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:datadirect:sqlserver://hostname:port"/>
ms sql server configuration - datadirect non-xa
see above.
drivername="com.ddtek.jdbc.sqlserver.sqlserverdriver"
name="dd-sqlserver" password="password"
properties="user=user;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:datadirect:sqlserver://hostname:port"/>
ms sql server configuration - weblogic non-xa
this driver shipped with weblogic server 6.x, 7.x, and 8.x (it is currently marked as deprecated and has a status of "end of life"; it will not be shipped with the next major release). no additional configuration is needed for this driver (no classpath or path changes). this driver has jdbc 1.0 support only.
for more details about this driver, see .
name="weblogic-sqlserver"
password="password"
properties="user=user;db=database;server=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:weblogic:mssqlserver4"/>
mysql configuration
. note that you need to download and install both the database, and the jdbc driver, connector/j. the jar for the driver must be included in the classpath.
also note that the console uses the old class name for the driver (see the output below). there is a new class name but the old name still exists and we figured it would cover configurations using the old and new classes. according to one newsgroup article, the mysql jar must come before the pointbase jar or things don't work correctly.
name="mysql" password="password"
properties="user=user testtablename="sql select 1"
url="jdbc:mysql://localhost:port/test"/>
oracle configuration
in weblogic type 4 jdbc drivers.
drivername="weblogic.jdbcx.oracle.oracledatasource"
name="-oracle-xa" password="password"
properties="user=user;portnumber=port;sid=oraport;servername=hostname"
targets="myserver" testtablename="sql select 1 from dual"
url="jdbc:bea:oracle://hostname:port"/>
oracle configuration - non-xa
see above.
name="-oracle" password="password"
properties="user=user;portnumber=port;sid=oraport;servername=hostname"
targets="myserver" testtablename="sql select 1 from dual"
url="jdbc:bea:oracle://hostname:port"/>
oracle configuration - oracle thin xa
this driver is shipped with weblogic server 6.x, 7.x, and 8.x. the associated jar file is installed in wlhome/server/lib: ojdbc14.jar for 1.4 and later (classes12.zip for earlier 's); this jar is included in the classpath in the manifest in weblogic.jar so normally they need not be included in the user's classpath.
for more information about using this driver with weblogic server, see the following documents:
drivername="oracle.jdbc.xa.client.oraclexadatasource"
name="oracle-thin-xa" password="password"
properties="user=user testtablename="sql select 1 from dual"
url="jdbc:oracle:thin:@hostname:port:oraport"/>
oracle configuration - oracle thin non-xa
see above.
name="oracle-thin" password="password"
properties="user=user testtablename="sql select 1 from dual"
url="jdbc:oracle:thin:@hostname:port:oraport"/>
oracle configuration - type 2 xa
this type 2 driver (based on oci) is shipped with weblogic server 6.x, 7.x, and 8.x (it may no longer ship with the next major release). it has limited jdbc 2.0/3.0 support. to use this driver, oracle_home must be set and the associated client software must be installed. the driver used depends on the version of oracle being used - 8.1.7, 9.0.1, and 9.2.0 are currently supported. for the 9.2.0 version, add wlhome/server/bin/ociport_8 to the path (similarly for the other versions).
additionally, the client must be configured to recognize the database using one of the oracle utilities, or by modifying oracle_home/network/admin/tnsnames.ora. here is a sample entry for a database on hostname, port port, database name oraport.
oraport =
(description =
(address_list =
(address = (protocol = tcp)(host = hostname)(port = port))
)
(connect_data =
(service_name = oraport)
)
)
for more information about this driver, see .
name="-oracle-type2-xa" password="password"
properties="user=user;server=oraport" targets="myserver"
testtablename="sql select 1 from dual"
url="jdbc:weblogic:oracle"/>
oracle configuration - type 2 non-xa
see above.
name="-oracle-type2" password="password"
properties="user=user;server=oraport" targets="myserver"
testtablename="sql select 1 from dual"
url="jdbc:weblogic:oracle"/>
oracle configuration - datadirect xa
see for more information on getting an evaluation copy of this driver or purchasing the software. the associated jar files are oracle.jar, base.jar, and util.jar.
drivername="com.ddtek.jdbcx.oracle.oracledatasource"
name="dd-oracle-xa" password="password"
properties="user=user;portnumber=port;sid=oraport;servername=hostname"
targets="myserver" testtablename="sql select 1 from dual"
url="jdbc:datadirect:oracle://hostname:port"/>
oracle configuration - datadirect non-xa
see above.
name="dd-oracle" password="password"
properties="user=user;portnumber=port;sid=oraport;servername=hostname"
targets="myserver" testtablename="sql select 1 from dual"
url="jdbc:datadirect:oracle://hostname:port"/>
oracle configuration - oracle oci xa
this type 2 driver is installed with the client-side oracle software. oracle_home must be set in the environment. the client side jar must be in the classpath: ojdbc14.jar for 1.4 and later (classes12.zip for earlier 's). the directory oracle_home/bin must be included in the path. see information above for "oracle configuration - type 2 xa" regarding client-side configuration.
drivername="oracle.jdbc.xa.client.oraclexadatasource"
name="oracle-oci-xa" password="password"
properties="user=user testtablename="sql select 1 from dual"
url="jdbc:oracle:oci:@oraport"/>
oracle configuration - oracle oci non-xa
see above.
name="oracle-oci" password="password"
properties="user=user testtablename="sql select 1 from dual"
url="jdbc:oracle:oci:@oraport"/>
pointbase configuration
for further information on pointbase, including how to get an evaluation version and how to buy the software.
name="pointbase-xa" password="password"
properties="user=user;databasename=jdbc:pointbase:server://localhost:port/demo"
targets="myserver"
testtablename="sql select count(*) from systables"
url="jdbc:pointbase:server://localhost:port/demo"/>
pointbase configuration - pointbase non-xa
see above.
drivername="com.pointbase.jdbc.jdbcuniversaldriver"
name="pointbase" password="password"
properties="user=user;databasename=jdbc:pointbase:server://localhost:port/demo"
targets="myserver"
testtablename="sql select count(*) from systables"
url="jdbc:pointbase:server://localhost:port/demo"/>
sybase configuration
in weblogic type 4 jdbc drivers.
drivername="weblogic.jdbcx.sybase.sybasedatasource"
name="-sybase-xa" password="password"
properties="user=user;url=jdbc:bea:sybase://hostname:port;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:bea:sybase://hostname:port"/>
sybase configuration - non-xa
see above.
name="-sybase" password="password"
properties="user=user;url=jdbc:bea:sybase://hostname:port;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:bea:sybase://hostname:port"/>
sybase configuration - datadirect xa
see for more information on getting an evaluation copy of this driver or purchasing the software. the associated jar files are sybase.jar, base.jar, and util.jar.
drivername="com.ddtek.jdbcx.sybase.sybasedatasource"
name="dd-sybase-xa" password="password"
properties="user=user;url=jdbc:datadirect:sybase://hostname:port;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:datadirect:sybase://hostname:port"/>
sybase configuration - datadirect non-xa
see above.
name="dd-sybase" password="password"
properties="user=user;url=jdbc:datadirect:sybase://hostname:port;portnumber=port;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:datadirect:sybase://hostname:port"/>
sybase configuration - sybase xa
this driver is shipped with weblogic server 6.x, 7.x, and 8.x. the associated jar files are installed in wlhome/server/lib: jconnect.jar and jconn2.jar; they are included in the classpath in the manifest in weblogic.jar so normally they need not be included in the user's classpath.
drivername="com.sybase.jdbc2.jdbc.sybxadatasource"
name="sybase-xa" password="password"
properties="user=user;url=jdbc:sybase:tds:hostname:port/database;networkprotocol=tds;portnumber=port;username=hostname;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:sybase:tds:hostname:port/database"/>
sybase configuration - sybase non-xa (jconnect 4.x)
see above.
name="sybase-old" password="password"
properties="user=user;url=jdbc:sybase:tds:hostname:port/database;networkprotocol=tds;portnumber=port;username=hostname;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:sybase:tds:hostname:port/database"/>
sybase configuration - sybase non-xa
see above.
name="sybase" password="password"
properties="user=user;url=jdbc:sybase:tds:hostname:port/database;networkprotocol=tds;portnumber=port;username=hostname;databasename=database;servername=hostname"
targets="myserver"
testtablename="sql select count(*) from sysobjects"
url="jdbc:sybase:tds:hostname:port/database"/>