Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1  |  CUBRID 8.3.0  |  CUBRID 8.3.1  |  CUBRID 8.4.0  |  CUBRID 8.4.1  |  CUBRID 8.4.3  |  CUBRID 9.0.0 | 

Installing and Running on Windows

Details to Check when Install

CUBRID 2008 R2.0 supports both 32-bit and 64-bit Windows. You can check the version by selecting [My Computer] > [System Properties]. Make sure to install the CUBRID 32-bit version on 32-bit Windows and the CUBRID 64-bit version on 64-bit Windows.

Category

Description

64-bit

Since version 2008 R2.0, CUBRID supports both 32-bit and 64-bit Windows. You can check the version by selecting [My Computer] > [System Properties]. Make sure to install the CUBRID 32-bit version on 32-bit Windows and the CUBRID 64-bit version on 64-bit Windows.

Available free memory space

1 GB or more recommended.

Available free disk space

2 GB or more recommended (500 MB is required for initial installation and 1.5 GB is required for creating the default option database).

Required software

The CUBRID Manager and Java stored procedures require the Java Runtime Environment (JRE) version 1.6 or later.

If CUBRID Service Tray does not automatically run upon system startup, you should check followings:

  • Go to [Control Panel] > [Administrative Tools] > [Service] and verify whether Task Scheduler has started. If not, start Task Scheduler.
  • Go to [Administrative Tools] > [Task Scheduler] and verify whether CUBRID Service Tray has been registered. If not, register CUBRID Service Tray.
Setup Type
  • Server and Driver Installation: CUBRID Server, CSQL (a command line tool), interface drivers (OLE DB Provider, ODBC, JDBC, C API) are all installed.
  • Driver Installation: The interface drivers (OLE DB Provider, ODBC, JDBC, C API) are only installed. You can select this type of installation if development or operation is performed by remote connection to the computer in which the CUBRID database server is installed.
Upgrading CUBRID

To install a new version of CUBRID in an environment in which a previous version has already been installed, select [CUBRID Service Tray] > [Exit] from the menu to stop currently running services, and then remove the previous version of CUBRID. Note that when you are prompted with "Do you want to delete all the existing version of databases and the configuration files?" you must select "No" to protect the existing databases.

For more information on migrating a database from a previous version to a new version, see Migrating Database.

Configuring Environment

You can change configuration such as service ports to meet the user environment by changing the parameter values of following files which are located in the %CUBRID%conf directory. If a firewall has been configured, the ports used in CUBRID need to be opened.

File

Description

cm.conf

A configuration file for CUBRID Manager. The port that the Manager server process uses is called cm_port and its default value is 8001. Two ports are used and the port number is determined by the cm_port parameter. If 8001 is specified, 8001 and 8002 (configured number plus 1) ports will be used. For details, see CUBRID Manager Manual.

cubrid.conf

A configuration file for server. You can use it to configure the following values: database memory, the number threads based on the number of concurrent users, communication port between broker and server, etc.

The port that a master process uses is called cubrid_port_id and its default value is 1523. For details, see cubrid.conf Configuration File and Default Parameters.

cubrid_broker.conf

A configuration file for broker. You can use it to configure the following values: broker port, the number of application servers (CAS), SQL LOG, etc.
The port that a broker uses is called BROKER_PORT. A port you see in the drivers such as JDBC is its corresponding broker's port.
APPL_SERVER_PORT is a port that a broker application server (CAS) uses and it is added only in Windows. The default value is BROKER_PORT+1. The number of ports used is the same as the number of CAS, starting from the specified port's number plus 1. For details, see Parameter by Broker.
The CCI_DEFAULT_AUTOCOMMIT broker parameter is supported since 2008 R4.0. The default value in the version is OFF and it is later changed to ON. Therefore, users who have upgraded from 2008 R4.0 to 2008 R4.1 or later versions should change this value to OFF or configure the auto-commit mode to OFF.
Installing CUBRID Interfaces

You can see the latest information on interface modules such as JDBC, PHP, ODBC, and OLE DB and install them by downloading files from http://www.cubrid.org/wiki_apis.

Installing CUBRID Tools

You can see the latest information on tools such as CUBRID Manager and CUBRID Query Browser and install them by downloading files from http://www.cubrid.org/wiki_tools.