<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寫(xiě)法大全

    下面的配置適用于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 閱讀(6819) 評(píng)論(0)  編輯  收藏


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


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

    導(dǎo)航

    統(tǒng)計(jì)

    常用鏈接

    留言簿(110)

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

    隨筆分類(lèi)(126)

    隨筆檔案(155)

    文章分類(lèi)(9)

    文章檔案(19)

    相冊(cè)

    搜索

    積分與排名

    最新隨筆

    最新評(píng)論

    閱讀排行榜

    評(píng)論排行榜

    主站蜘蛛池模板: 在线亚洲精品自拍| 亚洲女人被黑人巨大进入| 处破痛哭A√18成年片免费| 免费黄色小视频网站| 免费国产a国产片高清| 亚洲精品高清国产一线久久| 亚洲美女免费视频| 亚洲av中文无码字幕色不卡| 国产V片在线播放免费无码| 四虎影视成人永久免费观看视频| 国产免费AV片在线播放唯爱网| 国产男女猛烈无遮挡免费视频网站| 亚洲国产日韩在线观频| 亚洲国产精品一区第二页| 亚洲1234区乱码| 在线播放国产不卡免费视频| 无码国产精品一区二区免费式芒果| 国产精品久久久久免费a∨ | 一级做a爰性色毛片免费| 日本免费人成视频在线观看| 亚洲国产综合在线| 国产亚洲精品美女久久久久久下载| 99在线免费观看| 成年女人午夜毛片免费看| mm1313亚洲精品国产| 免费人成激情视频| 亚洲韩国—中文字幕| 亚洲av永久无码精品秋霞电影秋 | 男人扒开添女人下部免费视频| 永久免费不卡在线观看黄网站| 免费观看黄网站在线播放| 中文字幕日韩亚洲| 亚洲av日韩av无码av| 亚洲精品视频免费| 成人毛片视频免费网站观看| 亚洲老妈激情一区二区三区| 亚洲熟妇自偷自拍另欧美| 大地资源网高清在线观看免费| 永久免费看bbb| 老司机亚洲精品影院| 四虎国产精品成人免费久久 |