`
weishaoxiang
  • 浏览: 96243 次
  • 性别: Icon_minigender_1
  • 来自: 广西
社区版块
存档分类
最新评论

SQL驱动的配置

    博客分类:
  • J2EE
 
阅读更多
<!-- 各种SQL驱动的配置方式 -->
<Beans>
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>net.sourceforge.jtds.jdbc.Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-33</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Microsoft SQL Server (jTDS driver)</name>
                <url>jdbc:jtds:sqlserver://<hostname>[:<port>]/<dbname></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.microsoft.jdbc.sqlserver.SQLServerDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-11</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Microsoft SQL Server</name>
                <url>jdbc:microsoft:sqlserver://<server_name>:<1433></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.apache.derby.jdbc.ClientDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-29</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Derby</name>
                <url>jdbc:derby://<server_name>:<port>/<databaseName>[;create=true]</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.hsqldb.jdbcDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-18</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>HSQLDB Server</name>
                <url>jdbc:hsqldb:hsql://<server>[:<1476>]</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.enhydra.instantdb.jdbc.idbDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-5</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>InstantDB</name>
                <url>jdbc:idb:<pathname></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.mimer.jdbc.Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-12</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Mimer SQL</name>
                <url>jdbc:mimer:[//[<user>[:<password>]@]<server>[:<1360>]][/<dbname>][property-list]</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>net.sourceforge.jtds.jdbc.Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-34</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Sybase (jTDS driver)</name>
                <url>jdbc:jtds:sybase://<hostname>[:<port>]/<dbname></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.pointbase.net.netJDBCDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-23</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Pointbase Embedded</name>
                <url>jdbc:pointbase:embedded:<dbname></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-2</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Oracle (OCI driver)</name>
                <url>jdbc:oracle:oci8:@<database_name></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.hsqldb.jdbcDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-17</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>HSQLDB Web Server</name>
                <url>jdbc:hsqldb:http://<server>[:<1476>]</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.ibm.db2.jcc.DB2Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-30</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Derby (IBM Universal driver)</name>
                <url>jdbc:db2://<server_name>:<port>/<databaseName></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.sybase.jdbc2.jdbc.SybDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-8</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Sybase Adaptive Server Anywhere</name>
                <url>jdbc:sybase:Tds:<host>:<port>?ServiceName=<DBNAME></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.internetcds.jdbc.tds.Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-16</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>jTDS (FreeTDS)</name>
                <url>jdbc:freetds:sqlserver://<hostname>[:<4100>]/<dbname>[;<property>=<value>[;...]]</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>uk.co.thinksql.ThinkSQLDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-14</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>ThinkSQL</name>
                <url>jdbc:thinksql://<server>:<9075></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.postgresql.Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-7</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>PostgreSQL</name>
                <url>jdbc:postgresql:[<//host>[:<5432>/]]<database></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.ibm.db2.jdbc.net.DB2Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-31</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>IBM DB2 (Universal driver)</name>
                <url>jdbc:db2://<host_name>:<port>/<dbname></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.hsqldb.jdbcDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-20</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>HSQLDB In-Memory</name>
                <url>jdbc:hsqldb:.</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.sap.dbtech.jdbc.DriverSapDB</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-21</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>SAPDB</name>
                <url>jdbc:sapdb:[//host/]dbname[?name=value[&name=value]*]</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.hsqldb.jdbcDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-19</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>HSQLDB Standalone</name>
                <url>jdbc:hsqldb:<databaseName></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.pointbase.net.netJDBCDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-22</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Pointbase Server</name>
                <url>jdbc:pointbase:server://<server_name>/<dbname></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>sun.jdbc.odbc.JdbcOdbcDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-1</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>JDBC ODBC Bridge</name>
                <url>jdbc:odbc:<alias></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.sybase.jdbc2.jdbc.SybDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-9</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Sybase Adaptive Server Enterprise</name>
                <url>jdbc:sybase:Tds:<host>:<port>/<DBNAME></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.apache.derby.jdbc.ClientDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>77079d8e:11e6801bd64:-7fdf</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true">
                        <Bean Class="net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper">
                                <string>C:\Program Files\MyEclipse-6.0M1\myeclipse\eclipse\plugins\com.genuitec.eclipse.derby_5.9.100\lib\derbyclient.jar</string>
                        </Bean>
                </jarFileNames>
                <name>MyEclipse Derby</name>
                <url>jdbc:derby://<host>:<port>/<db>;create=true</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-28</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Microsoft SQL Server 2005</name>
                <url>jdbc:sqlserver://<server_name>:<port>[;databaseName=<dbname>]</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>COM.ibm.db2.jdbc.net.DB2Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-24</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>IBM DB2 (App driver)</name>
                <url>jdbc:db2://<host_name>:6789/<dbname></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.axiondb.jdbc.AxionDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-13</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Axion</name>
                <url>jdbc:axiondb:<database-name>[:<database-directory>]</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>interbase.interclient.Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-3</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>InterClient</name>
                <url>jdbc:interbase://<server>/<full_db_path></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.ncr.teradata.TeraDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-27</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Teradata</name>
                <url>jdbc:teradata:[//host[:1025]/]<database></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-4</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Oracle (Thin driver)</name>
                <url>jdbc:oracle:thin:@<server>[:<1521>]:<database_name></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.mckoi.JDBCDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-15</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Mckoi</name>
                <url>jdbc:mckoi://<host>[:9157][/<schema>]/</url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.mysql.jdbc.Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-26</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>MySQL Connector/J</name>
                <url>jdbc:mysql://<hostname>[<:3306>]/<dbname></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>org.firebirdsql.jdbc.FBDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-25</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Firebird (JayBird JCA/JDBC driver)</name>
                <url>jdbc:firebirdsql:[//host[:port]/]<database></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.ibm.db2.jdbc.net.DB2Driver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-32</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>IBM DB2 (Universal Type 2 driver)</name>
                <url>jdbc:db2:<dbname></url>
        </Bean>
        
        <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver">
                <driverClassName>com.sunopsis.jdbc.driver.xml.SnpsXmlDriver</driverClassName>
                <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier">
                        <string>-10</string>
                </identifier>
                <jarFileName/>
                <jarFileNames Indexed="true"/>
                <name>Sunopsis XML</name>
                <url>jdbc:snps:xml?f=<file-name>&ro=true</url>
        </Bean>
</Beans>

 

分享到:
评论

相关推荐

    sql-server驱动包

    SQL Server驱动包是用于连接Microsoft SQL Server数据库的关键组件,它提供了必要的接口,使得应用程序能够与SQL Server进行数据交互。在本篇文章中,我们将深入探讨SQL Server驱动的不同类型、其工作原理以及如何...

    DBeaver连接sqlserver驱动

    总之,DBeaver连接SQL Server驱动需要正确配置数据源信息,并确保使用与SQL Server版本相匹配的JDBC驱动。遵循"说明.txt"文件的指示,通常可以顺利解决问题。在处理过程中,遇到任何困难,都可以查阅DBeaver的官方...

    sqlserver驱动jar

    本文将深入探讨SQL Server驱动jar的相关知识点,包括其作用、如何使用以及在Java开发中的配置方法。 首先,了解JDBC驱动程序的作用。JDBC是Java平台上的一个标准API,它允许Java应用程序通过Java代码与各种类型的...

    SQL Server ODBC 驱动

    4. **测试连接**: 创建DSN后,可以进行测试连接以确保配置正确无误,如果成功,表明已能通过ODBC驱动访问SQL Server数据库。 5. **应用开发**: 开发人员可以在他们的应用程序中使用ODBC API来连接到创建的数据源,...

    kettle链接SQL server驱动 sqljdbc

    在Kettle中配置SQL Server数据库连接时,我们需要依赖特定的数据库驱动,这就是SQL JDBC驱动。 SQL JDBC驱动是微软提供的Java Database Connectivity (JDBC) 驱动,使得Java应用程序能够与SQL Server进行交互。有两...

    SQL驱动 jar包

    SQL驱动,正如标题所示,是一个关键组件,它允许应用程序通过编程接口与SQL数据库进行通信。在这个场景中,我们讨论的是一个专门用于连接Microsoft SQL Server数据库的Java驱动程序,即"SQL驱动jar包"。 jar(Java ...

    sqlserver驱动

    在使用这些驱动时,你需要确保你的开发环境已经正确配置了必要的依赖,比如安装了对应的数据库服务器、客户端工具,以及驱动所需的库或服务。同时,你需要知道如何编写正确的连接字符串,包括服务器名、数据库名、...

    sqlserver驱动2012版

    在实际应用中,安装SQL Server Native Client 2012驱动后,Navicat用户可以在工具中配置新的数据库连接,选择SQL Server作为服务器类型,输入服务器名称、登录凭据等信息,利用这个驱动建立安全稳定的连接,从而实现...

    SQuirrel SQL Client配置hive驱动

    本篇文章将详细讲解如何在SQuirrel SQL Client中配置Hive驱动,以便进行Hive数据库的查询和操作。 首先,我们需要准备的是Hive的JDBC驱动。在提供的压缩包文件中,我们看到一个名为`hive-jar`的文件,这通常是一个...

    oracle与sql驱动

    Oracle数据库和SQL驱动是IT行业中两个非常重要的概念,它们在数据管理和应用程序开发中扮演着...通过选择合适的SQL驱动类型,正确配置JDBC连接,并进行性能调优,开发者可以创建出满足业务需求的高质量数据库解决方案。

    SQL2000驱动包

    在这个“SQL2000驱动包”中,包含了三个关键的组件,它们是:msbase、mssqlserver和msutil。这些组件对于正确地连接到SQL Server 2000数据库以及执行相关操作至关重要。 1. **msbase**: msbase是SQL Server客户端...

    sql server 2005 jdbc驱动配置

    这里我们将详细探讨SQL Server 2005的JDBC驱动配置过程,以及可能遇到的问题和解决方法。 首先,对于SQL Server 2005,微软提供了专门的JDBC驱动,即`com.microsoft.sqlserver.jdbc.SQLServerDriver`。这个驱动不同...

    sql驱动包下载(绝对真实)

    6. 安装和配置:安装SQL驱动包通常涉及到将其添加到项目的类路径或依赖管理中。例如,在Java中,可以将JDBC驱动的jar文件放入项目的lib目录,或在Maven/Gradle等构建工具中声明依赖。 7. 兼容性和安全性:选择合适...

    sqlserver2000驱动

    在本文中,我们将深入探讨这些驱动程序的功能、类型、安装与配置,以及与SQL Server 2000交互的相关知识。 首先,SQL Server 2000驱动程序主要分为两大类:ODBC(Open Database Connectivity)驱动和JDBC(Java ...

    sqlserver驱动包:sqljdbc4.jar

    SQL Server驱动包`sqljdbc4.jar`是微软官方提供的Java数据库连接器(JDBC),用于在Java应用程序中与Microsoft SQL Server进行通信。JDBC是Java编程语言中的一个标准API,它使得开发人员能够以标准化的方式访问各种...

    kettle 连接sqlserver 驱动

    标题 "kettle 连接sqlserver 驱动" 涉及到的是在数据集成工具 Pentaho Data Integration(简称 Kettle 或 PDI)中,如何配置和使用 SQL Server 数据库的连接。Kettle 是一个强大的ETL(Extract, Transform, Load)...

    SQL server 2000的驱动程序

    SQL Server 2000的驱动程序设计允许开发者自定义行为,例如通过注册表设置或配置文件调整连接参数,或者通过API扩展驱动功能。 总结来说,SQL Server 2000的驱动程序是连接应用程序与数据库的关键桥梁,通过ODBC、...

    SQl驱动包

    本文将详细介绍SQL驱动包及其在Eclipse中的配置和使用。 SQL驱动包,顾名思义,包含了连接数据库所需的类库和API,它允许Java应用程序通过JDBC(Java Database Connectivity)接口与各种类型的数据库系统进行通信。...

    SQLDeveloper工具/MySQL/SQLServer驱动程序

    在实际操作中,为了使用这些驱动程序,你需要将压缩包中的文件解压,并按照SQLDeveloper的指导安装和配置相应的驱动。MySQL驱动通常对应JDBC(Java Database Connectivity)驱动,以jar文件形式存在,而SQL Server则...

    sqlserver java驱动

    本文将深入探讨如何使用Java语言连接到SQL Server 2000数据库,主要关注Java提供的三种驱动类型,以及如何配置和使用它们。 首先,我们需要理解“java to database”标签所指的含义。这表示我们将讨论Java与数据库...

Global site tag (gtag.js) - Google Analytics