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.