Dbeaver Database Administration Tools Connect Sybase database usage Experience __ Database

Source: Internet
Author: User
Tags driver manager sybase sybase database win32

Download a DBeaver1.4 version from http://dbeaver.jkiss.org/, the software is completely free, the function and Dbvisualizer compared, slightly less, but simple and easy to use, operating efficiency seems to be higher. This is an example of Sybase ASA, Sybase ASE, MySQL, and its simple configuration and usage.

dbeaver download


1. Download http://dbeaver.jkiss.org/DBeaver1.4

I have always used only uncompressed version: Http://dbeaver.jkiss.org/files/dbeaver-1.4.0-win32.win32.x86.zip

dbeaver create table sql 


2. Solution to D:\tools, this will have a root directory dbeaver, there is an executable program Dbeaver.exe, if you look at the readme, you know it relies on an external JVM. Create a Dbeaver.exe shortcut, set to the target (target): D:\tools\dbeaver\dbeaver.exe -VM D:\SHARED\JDK1.6.0_02\BIN\JAVAWthat specifies the location of the JVM. Of course, you have to be prepared for jdk1.6.

3. Click on the shortcut to open the Dbeaver. While ready for Sybase's JDBC Drive, ASE and ASA can share a single driver. Set up the subdirectory drivers\sybase under the Dbeaver and put the Jconn3.jar in. If you do not have it, you can copy one from the installed ASA11/12, in the Java subdirectory, or from the ase15\jconnect-6_0\classes subdirectory below. If you don't have these installed versions at hand, you can copy one from the attachment jconn3 http://dl.iteye.com/topics/download/86b782dc-b1e2-314d-8135-f733ef6db518 here.

export database dbeaver


4. Start adding JDBC Driver Manager, database->driver manager->create new driver

The ASA driver configuration is shown in the following illustration:

dbeaver vpn


The driver configuration of ASE is shown in the following illustration:

dbeaver stored procedure
(Note: Although there is a Sybase JDBC driver example in the template, it is Jtds, an open source product that is not very well supported and not as good as the official Jconn3.jar)

5. With two registered Driver manager, we can create a connection to ASA and ASE.
For ASA, you can build one on site:
Java Code D:\shared\asa110\bin32>dbinit.exe ... \demo.db SQL Anywhere Initialization utility version 11.0.1.2250 char collation sequence: 936ZHO (casesensitivity=ignore) char character set encoding: GBK NCHAR collation Column: UCA (casesensitivity=ignore; Accentsensitivity=ignore; Punctuationsensitivity=primary) NCHAR Character Set encoding: UTF-8 creating system tables Creating system views setting option values successfully creating the database. \demo.db "Up DB Service: D:\shared\asa110\bin32>dbeng11.exe. \demo.db

Then use Dbeaver to connect this ASA, the port is 2638. As shown in figure:

dbeaver mysql public key retrieval is not allowed

dbeaver csv driver
This will allow you to successfully connect to the demo database.

As for ASE, it's much simpler.
Its connection information is shown in the following illustration:

This is the local effect diagram of the ASE connection:

dbeaver sql client
6. There is a special situation, many people easily make mistakes, is the above mentioned ASA connection, that Dbeng only started a demo.db, if it started multiple db, how to create a connection to each db.
For example, I started the demo2.db and demo.db two db, in a engine or service.
In the key place is to set a special attribute, that is the ServiceName attribute, fill in the name of the DB.
Demo.db corresponding is the demo, demo2.db corresponding is the Demo2.
To start multiple db, use the Dbsrv utility: D:\shared\asa110\bin32>dbsrv11.exe. \demo.db.. \demo2.db

7. As for MySQL, it's easier. We can create a MySQL subdirectory below the drivers subdirectory to store the JDBC driver for MySQL. Mysql-connector-java-5.0.7-bin.jar can be. You can download it on the MySQL official web site. For a quick installation and find a MySQL, you can refer to my another article:
http://iihero.iteye.com/blog/995036, there is an update inside.
This is an output intermediate result of the download installation mysql5.1.58 and should eventually generate the iihero5.1 service.

After starting the iihero5.1 service, go to the D:\mysql related directory:
Java code   d:\mysql-5.1.58-win32\bin>mysql -u root   welcome to the  mysql monitor.  commands end with ; or \g.   Your MySQL  connection id is 4   server version: 5.1.58-community mysql  community server  (GPL)       copyright  (c)  2000, 2010, oracle  and/or its affiliates. All rights reserved.   this software  comes with absolutely no warranty. this is free software,   And you are welcome to modify and redistribute it under the  GPL v2 license      type  ' help; '  or  ' \h '  for help. Type  ' \c '  to clear the current input  statement.      mysql> use mysql   database changed   Mysql> select user,host, password from user;   +------+-----------+----------+   | user |  host      | password |   +------+-----------+----------+    | root | localhost |           |   | root | 127.0.0.1 |           |   |      | localhost |           |   +------+-----------+----------+   3 rows  in set  (0.00 sec)       mysql>  

The password is empty always is improper, may follow: http://dev.mysql.com/doc/refman/5.1/en/assigning-passwords.html in the introduction modifies the root password:
Java code   Mysql> set password=password (' test123 ');   query ok, 0 rows  affected  (0.00 sec)       mysql> set password for  ' @ ' localhost '  = password (' test123 ');   query ok, 0 rows affected  ( 0.00 SEC)       mysql> select user,host,password from user;    +------+-----------+-------------------------------------------+   | user | host       | password                                    |   +------+-----------+----------------------------------- --------+   | root | localhost | *676243218923905cf94cb52a3c9d3eb30ce8e20d  |   | root | 127.0.0.1 |                                             |   |       | localhost | *676243218923905cf94cb52a3c9d3eb30ce8e20d |    +------+-----------+-------------------------------------------+   3 rows in  set  (0.00 sec)   

This will change the root and the user's password to test123.
It is convenient to use Dbeaver to create a connection and log in. The following is an overall screenshot:


The overall feeling is that this tool is easier to use and clearer.
I have also developed a xsql command-line tool that is entirely console-style.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.