posted 5 years ago in CUBRID Life category by Esen Sagynov
CUBRID, basically, supports JDBC, ODBC and OLEDB. CUBRID Manager (hereinafter, abbreviated to CM) basically supports the query execution using JDBC. You may already have seen some of these tools on CUBRID homepage.
Let's examine JDBC connection tools. The following is a brief description of all possible CUBRID-based support tools other than the above-mentioned CM support tools.
First, connect to CUBRID from a non-CM tool by using JDBC. When CUBRID is installed, CUBRID JDBC is located at the path $CUBRID/jdbc. This is the path that Windows users should keep in mind first when it comes to a non-CM tool that will be examined here later. The name of CUBRID JDBC is cubrid_jdbc.jar.
Squirrel SQL is an open source program and many of DBMSs can access to it by using JDBC. It can be downloaded from Sourceforge.net and requires different versions of Java depending on its version. Squirrel SQL supports basic features such as export and import, and also provides a number of special features, such as the ability to output data in a query form or change the character sets used by the editor. Of course, sophisticated administrator features of CM are not included, but simple table manipulation such as creation and deletion can be done through the UI as well.
QuantumDB Eclipse Plugin
QuantumDB is a tool that allows developers using Eclipse to install and use Eclipse plug-in without running a separate query execution tool. This tool allows the execution of multiple queries and provides the results of a general editor. You can compare and check the results through execution and result windows separated by multiple tabs. While QuantumDB provides fewer features than SQuirreL SQL, it is useful for checking the results of the query executions using JDBC. QuantumDB is also an open source program, and can be downloaded from sourceforge.
When you install a Windows product, ODBC and OLEDB are installed automatically. Of course, ODBC should be registered in the Control Panel. To use the registered ODBC or OLEDB in an editor such as CM, rather than in a web environment such as ASP, you need ODBC or a tool using OLEDB . In this case, the typical tool to be used is QTADO.
QTADO is a tool that shows the CUBRID connections visually using ODBC and OLEDB. With this tool, you can execute queries or use features such as export/import, and create/delete simple tables. This tool features a simple and convenient UI. If you are a user having the experience with MSSQL, you will find this UI familiar. QTADO is a shareware.
For detailed descriptions of each product, follow the provided links. For interworking with CUBRID, see CUBRID attached above.
In addition to the tools introduced above, general tools using JDBC will provide the basic query execution environment. However, these tools will need some complementary measures because they provide insufficient support for DBMS-specialized features. Users who find CM to be inconvenient and unfamiliar might want to experience CUBRID using another tool. Open source means open to everyone, so it might not be a bad idea to experiment with tools that I haven't mentioned here.