使用NetWeaver创建数据库连接

本文详细介绍如何在开发环境中创建新的数据库连接,包括选择数据库供应商、填写连接URL等详细步骤,并介绍了如何连接到已存在的数据库。
创建新的数据库连接
Choose ...
       1.      Choose Window ® Show View ® Other.
       2.      Choose Data ® Database Explorer in the Show View dialog.
       3.      Choose OK.
       4.      Select Connections in the Database Explorer.
       5.      Choose New Connection from the context menu. The New Connection dialog opens.
       6.      Select a database vendor, for example, if you are using the system database server, select MAXDB ® 7.6.
       7.      Complete the Connection URL details fields:
                            a.      Enter your database name, for example, if you are using the system database, JP1.
                            b.      Enter the JDBC driver class, for example, the system driver class  com.sap.dbtech.jdbc.DriverSapDB.
                            c.      Enter the location of the JDBC driver class on the file system, for example, if you wish to use the system driver, <SAP DB installation location>\programs\runtime\jar\sapdbc.jar.
                          d.      Enter the connection URL, for example, jdbc:sapdb://<DB Host Name>/JP1?timeout=0.
       8.      To use the predefined system datasource, enter SAPDEMO as the user name for the database.
       9.      To use the predefined system datasource, enter SAPDEMO as the password for the database.
If the persistence.xml in your application is empty, the persistence container assumes you are you using the default datasource. Thus, you must supply the SAPDEMO user name and password to use the predefined database schema and access the predefined tables.
   10.      Choose Finish. The database connection appears in the Connections tree in the Database Explorer
The New Connection Dialog
连接到已存在的数据库连接
       1.      To connect to an existing database connection, select the connection in the Database Explorer.
       2.      Choose Connect from the context menu.









本文转自 牛海彬 51CTO博客,原文链接:http://blog.51cto.com/newhappy/77018,如需转载请自行联系原作者
DBeaver常用数据库驱动,亲测好用。 包含JDBC驱动列表(jdbc driver list): CacheDB.jar clickhouse-jdbc-0.2.4.jar commons-codec-1.9.jar commons-logging-1.2.jar guava-19.0.jar httpclient-4.5.2.jar httpcore-4.4.4.jar httpmime-4.5.2.jar jackson-annotations-2.7.0.jar jackson-core-2.7.3.jar jackson-databind-2.7.3.jar jaxb-api-2.3.0.jar lz4-1.3.0.jar slf4j-api-1.7.21.jar csvjdbc-1.0.35.jar csvjdbc-1.0.37.jar dans-dbf-lib-1.0.0-beta-10.jar db2jcc4.jar jt400.jar derby-10.15.1.3.jar derbyclient-10.15.1.3.jar derbyshared-10.15.1.3.jar derbytools-10.15.1.3.jar exasol-jdbc-6.1.0.jar h2-1.4.196.jar hive-jdbc-uber-2.6.5.0-292.jar hsqldb-2.4.0.jar ifxjdbc.jar ifxlang.jar iijdbc.jar antlr4-runtime-4.7.2.jar connector-api-1.5.jar jaybird-4.0.0.java8.jar jtds-1.3.1.jar mariadb-java-client-2.6.0.jar sapdbc-7.6.06.jar mssql-jdbc-8.2.0.jre8.jar mysql-connector-java-5.1.48.jar mysql-connector-java-8.0.17.jar protobuf-java-3.6.1.jar nzjdbc3.jar jdbc-odbc-bridge-jre7.jar ojdbc8.jar oraclepki.jar orai18n.jar osdt_cert.jar osdt_core.jar xdb6.jar xmlparserv2.jar postgis-jdbc-2.2.1.jar postgresql-42.2.5.jar aws-java-sdk-core-1.11.118.jar aws-java-sdk-redshift-1.11.118.jar aws-java-sdk-sts-1.11.118.jar commons-codec-1.9.jar commons-logging-1.1.3.jar httpclient-4.5.2.jar httpcore-4.4.4.jar jackson-annotations-2.10.1.jar jackson-core-2.10.1.jar jackson-databind-2.10.1.jar jackson-dataformat-cbor-2.10.1.jar joda-time-2.8.1.jar log4j-1.2.17.jar RedshiftJDBC42-no-awssdk-1.2.47.1071.jar sqlite-jdbc-3.30.1.jar jconn4.jar tdgssconfig.jar terajdbc4.jar byte-buddy-1.6.11.jar byte-buddy-agent-1.6.11.jar commons-lang-2.6.jar commons-logging-1.1.3.jar hsqldb-2.3.1.jar jackcess-2.1.6.jar mockito-core-2.7.22.jar objenesis-2.5.jar ucanaccess-4.0.2.jar vertica-jdbc-8.1.1-5.jar caffeine-2.6.2.jar waffle-jna-1.9.0.jar
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值