<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    David.Turing's blog

     

    針對(duì)Weblogic的JDBC寫法大全

    下面的配置適用于Webloic 6.x/7.x/8.x的config.xml文件

    Cloudscape configuration

    A demo version of software, including the driver, shipped with WebLogic Server 6.X and 7.X. The associated jar files were installed in WLHOME/samples/eval/cloudscape/lib. The JDBC driver classes are located in cloudscape.jar. When using this DBMS, specify the following option for weblogic.Server:
    -Djava.system.property.cloudscape.system.home=<home directory for cloudscape database>

    See http://www-3.ibm.com/software/data/cloudscape/ for further information on Cloudscape, including how to get an evaluation version and how to buy the software.

    <JDBCConnectionPool DriverName="COM.cloudscape.core.JDBCDriver"
    Name="Cloudscape" Password="PASSWORD"
    Properties="user=USER;dbserver=localhost" Targets="MYSERVER"
    TestTableName="SQL SELECT 1"
    URL="jdbc:cloudscape:DATABASE;create=true"/>

    DB2 Configuration

    DB2 Configuration - BEA XA

    This driver is new in WebLogic Server 8.1SP2. It can be used on any version of WebLogic Server 8.1. The associated jar files are installed in WLHOME/server/lib: wldb2.jar, wlbase.jar, and wlutil.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.

    For more details about this driver, see The DB2 Driver in WebLogic Type 4 JDBC Drivers.

    <JDBCConnectionPool DriverName="weblogic.jdbcx.db2.DB2DataSource"
    Name="BEA-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 - BEA Non-XA

    See above.

    <JDBCConnectionPool DriverName="weblogic.jdbc.db2.DB2Driver"
    Name="BEA-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 http://www.datadirect.com/ 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.

    <JDBCConnectionPool DriverName="com.ddtek.jdbcx.db2.DB2DataSource"
    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.

    <JDBCConnectionPool DriverName="com.ddtek.jdbc.db2.DB2Driver"
    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 http://www.ibm.com/software/data/db2/ 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:
    Installing and Using the IBM DB2 Type 2 JDBC Driver
    Using the IBM DB2 Type 2 XA JDBC Driver

    <JDBCConnectionPool DriverName="COM.ibm.db2.jdbc.DB2XADataSource"
    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.

    <JDBCConnectionPool DriverName="COM.ibm.db2.jdbc.app.DB2Driver"
    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

    Informix Configuration - BEA XA

    This driver is new in WebLogic Server 8.1SP2. It can be used on any version of WebLogic Server 8.1. The associated jar files are installed in WLHOME/server/lib: wlinformix.jar, wlbase.jar, and wlutil.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.

    For more details about this driver, see The Informix Driver in WebLogic Type 4 JDBC Drivers.

    <JDBCConnectionPool
    DriverName="weblogic.jdbcx.informix.InformixDataSource"
    Name="BEA-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 - BEA Non-XA

    See above.

    <JDBCConnectionPool
    DriverName="weblogic.jdbc.informix.InformixDriver"
    Name="BEA-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 http://www.datadirect.com/ 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.

    <JDBCConnectionPool
    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.

    <JDBCConnectionPool
    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 http://www-3.ibm.com/software/data/informix/ for further information on Informix, including how to get a free client SDK and how to buy the software. Also see Installing and Using the IBM Informix JDBC Driver for more information about using this driver with WebLogic Server.

    The associated jar files are ifxjdbc.jar and ifxjdbcx.jar.

    <JDBCConnectionPool DriverName="com.informix.jdbcx.IfxXADataSource"
    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.

    <JDBCConnectionPool DriverName="com.informix.jdbc.IfxDriver"
    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

    MS SQL Server Configuration - BEA XA

    This driver is new in WebLogic Server 8.1SP1. It can be used on any version of WebLogic Server 8.1. The associated jar files are installed in WLHOME/server/lib: wlsqlserver.jar, wlbase.jar, and wlutil.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.

    Additionally, the files instjdbc.sql and sqljdbc.dll need to be installed on the MS SQL Server database server side.

    For more details about this driver, see The MS SQL Server Driver in WebLogic Type 4 JDBC Drivers.

    <JDBCConnectionPool
    DriverName="weblogic.jdbcx.sqlserver.SQLServerDataSource"
    Name="BEA-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 - BEA Non-XA

    See above.

    <JDBCConnectionPool
    DriverName="weblogic.jdbc.sqlserver.SQLServerDriver"
    Name="BEA-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 http://www.datadirect.com/ 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.

    <JDBCConnectionPool
    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.

    <JDBCConnectionPool
    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 The WebLogic jDriver for SQL Server.

    <JDBCConnectionPool DriverName="weblogic.jdbc.mssqlserver4.Driver"
    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

    This open-source database is available from http://www.mysql.com/. 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.

    <JDBCConnectionPool DriverName="org.gjt.mm.mysql.Driver"
    Name="MySQL" Password="PASSWORD"
    Properties="user=USER TestTableName="SQL SELECT 1"
    URL="jdbc:mysql://localhost:PORT/test"/>

    Oracle Configuration

    Oracle Configuration - BEA XA

    This driver is new in WebLogic Server 8.1SP2. It can be used on any version of WebLogic Server 8.1. The associated jar files are installed in WLHOME/server/lib: wloracle.jar, wlbase.jar, and wlutil.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.

    For more details about this driver, see The Oracle Driver in WebLogic Type 4 JDBC Drivers.

    <JDBCConnectionPool
    DriverName="weblogic.jdbcx.oracle.OracleDataSource"
    Name="BEA-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 - BEA Non-XA

    See above.

    <JDBCConnectionPool DriverName="weblogic.jdbc.oracle.OracleDriver"
    Name="BEA-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 JDK 1.4 and later (classes12.zip for earlier JDK'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:
    Using the Oracle Thin Driver
    Using Oracle Thin/XA Driver

    <JDBCConnectionPool
    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.

    <JDBCConnectionPool DriverName="oracle.jdbc.driver.OracleDriver"
    Name="Oracle-Thin" Password="PASSWORD"
    Properties="user=USER TestTableName="SQL SELECT 1 FROM DUAL"
    URL="jdbc:oracle:thin:@HOSTNAME:PORT:oraPORT"/>

    Oracle Configuration - BEA 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 WebLogic jDriver for Oracle.

    <JDBCConnectionPool DriverName="weblogic.jdbc.oci.xa.XADataSource"
    Name="BEA-Oracle-Type2-XA" Password="PASSWORD"
    Properties="user=USER;server=oraPORT" Targets="MYSERVER"
    TestTableName="SQL SELECT 1 FROM DUAL"
    URL="jdbc:weblogic:oracle"/>

    Oracle Configuration - BEA Type 2 Non-XA

    See above.

    <JDBCConnectionPool DriverName="weblogic.jdbc.oci.Driver"
    Name="BEA-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 http://www.datadirect.com/ 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.

    <JDBCConnectionPool
    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.

    <JDBCConnectionPool DriverName="com.ddtek.jdbc.oracle.OracleDriver"
    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 JDK 1.4 and later (classes12.zip for earlier JDK's). The directory ORACLE_HOME/bin must be included in the PATH. See information above for "Oracle Configuration - BEA Type 2 XA" regarding client-side configuration.

    <JDBCConnectionPool
    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.

    <JDBCConnectionPool DriverName="oracle.jdbc.driver.OracleDriver"
    Name="ORACLE-OCI" Password="PASSWORD"
    Properties="user=USER TestTableName="SQL SELECT 1 FROM DUAL"
    URL="jdbc:oracle:oci:@oraPORT"/>

    PointBase Configuration

    PointBase Configuration - PointBase XA

    A demo version of software, including the driver, ship with WebLogic Server 7.X and 8.X. The associated jar files are installed in eval/pointbase/lib. The JDBC driver classes are located in pbclient44.jar (note that 44 is a version number and may change depending on the WebLogic Server release). When using this driver, specify the following option for weblogic.Server:
    -Dpointbase.ini=<home directory for the pointbase database>/pointbase.ini

    See http://www.pointbase.com/ for further information on PointBase, including how to get an evaluation version and how to buy the software.

    <JDBCConnectionPool DriverName="com.pointbase.xa.xaDataSource"
    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.

    <JDBCConnectionPool
    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

    Sybase Configuration - BEA XA

    This driver is new in WebLogic Server 8.1SP2. It can be used on any version of WebLogic Server 8.1. The associated jar files are installed in WLHOME/server/lib: wlsybase.jar, wlbase.jar, and wlutil.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.

    For more details about this driver, see The Sybase Driver in WebLogic Type 4 JDBC Drivers.

    <JDBCConnectionPool
    DriverName="weblogic.jdbcx.sybase.SybaseDataSource"
    Name="BEA-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 - BEA Non-XA

    See above.

    <JDBCConnectionPool DriverName="weblogic.jdbc.sybase.SybaseDriver"
    Name="BEA-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 http://www.datadirect.com/ 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.

    <JDBCConnectionPool
    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.

    <JDBCConnectionPool DriverName="com.ddtek.jdbc.sybase.SybaseDriver"
    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.

    <JDBCConnectionPool
    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.

    <JDBCConnectionPool DriverName="com.sybase.jdbc.SybDriver"
    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.

    <JDBCConnectionPool DriverName="com.sybase.jdbc2.jdbc.SybDriver"
    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"/>

    posted on 2007-03-01 08:05 david.turing 閱讀(6811) 評(píng)論(0)  編輯  收藏


    只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。


    網(wǎng)站導(dǎo)航:
     

    導(dǎo)航

    統(tǒng)計(jì)

    常用鏈接

    留言簿(110)

    我參與的團(tuán)隊(duì)

    隨筆分類(126)

    隨筆檔案(155)

    文章分類(9)

    文章檔案(19)

    相冊(cè)

    搜索

    積分與排名

    最新隨筆

    最新評(píng)論

    閱讀排行榜

    評(píng)論排行榜

    主站蜘蛛池模板: 亚洲AV网站在线观看| 91香蕉国产线观看免费全集| 国产精品亚洲专区一区| 亚洲精品动漫免费二区| 亚洲欧洲无码一区二区三区| 中文字幕免费观看| 久草免费手机视频| 中文字幕久精品免费视频| aa在线免费观看| 中文字幕一区二区免费| 国产成人高清亚洲一区久久| 亚洲AV性色在线观看| 国产成人亚洲综合a∨| 无遮挡免费一区二区三区 | 国产精品四虎在线观看免费| 高清国语自产拍免费视频国产 | 美女视频黄a视频全免费网站色| 亚洲国产精品日韩在线| 亚洲国产精品一区二区久| 456亚洲人成影院在线观| 亚洲精品色播一区二区| 深夜A级毛片视频免费| 中文字幕在线免费看| 人妻无码一区二区三区免费| 99re6在线视频精品免费下载| 中文毛片无遮挡高潮免费| 午夜影视在线免费观看| 亚洲人成色7777在线观看不卡| 中文字幕亚洲综合久久菠萝蜜| 亚洲人成电影亚洲人成9999网| 亚洲AV成人无码天堂| 色网站在线免费观看| 成人无码区免费A∨直播| 91成人免费观看| 日本高清免费中文字幕不卡| 国产91色综合久久免费| 国产片免费在线观看| 亚洲精品亚洲人成人网| 亚洲欧洲国产经精品香蕉网| 亚洲AV日韩AV一区二区三曲| 中文字幕在线免费看|