设为首页 收藏本站

运维网

 找回密码
 立即注册
查看: 748|回复: 0

[经验分享] SQL驱动的配置

[复制链接]
zuier

尚未签到
发表于 2016-11-10 00:02:17 | 显示全部楼层 |阅读模式
<!-- 各种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>

　　

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表，该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有，请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意，请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息，一经发现立即删除。若您因此触犯法律，一切后果自负，我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集，我们仅提供一个展示、介绍、观摩学习的平台，我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责，亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏，不得用于商业或者其他用途，否则，一切后果均由您自己承担，我们对此不承担任何法律责任
7、如涉及侵犯版权等问题，请您及时通知我们，我们将立即采取措施予以解决
8、联系人Email：admin@iyunv.com 网址：www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址：https://www.yunweiku.com/thread-297951-1-1.html 上篇帖子： DB2 SQL Error Codes 下篇帖子： Access与Sql区别
回复

使用道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群，最新一手资源尽在官方微信交流群！快快加入我们吧...

扫描微信二维码查看详情

客服 E-mail:iyunvcom@gmail.com

本站由青云提供云计算服务

运维网--中国最专业的运维工程师交流社区

豫ICP备20007574号-1 Copyright © 2012-2025

关于我们

发展历程

联系我们

关注我们

广告服务

广告案例

隐私条款

免责声明

用户登录

用户注册

版主守则

申请版主

手机版

金币获取

帮助中心

每日签到

Good Good

Study

Day Day

UP


客服E-mail:kefu@iyunv.com 客服QQ：1061981298


QQ群⑦：运维网交流群⑦ QQ群⑧：运维网交流群⑧ k8s群：运维网kubernetes交流群


提醒：禁止发布任何违反国家法律、法规的言论与图片等内容；本站内容均来自个人观点与网络等信息，非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来，其版权均归原作者及其网站所有，我们尊重他人的合法权益，如有内容侵犯您的合法权益，请及时与我们联系进行核实删除！



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表