8.3.7 Supported Database Information

Connection to a database uses the JDBC driver DriverManager class. Information concerning the various databases is given below.

Note

Do not set multiple Driver Definitions for one driver file. Connection to the database will succeed with one set of Driver Definitions, but will fail if there is one more set of Driver Definitions.

Symfoware Server

When connecting to a Symfoware Server, use the native bridge (type 2) driver type as the connection format.

The driver definitions for remote access (RDB2_TCP linkage) are shown below.

Property	Setting
Driver file (Standard workbench)	[JDBC2.X Driver] <Installation folder>\fjjdbc\lib\fjsymjdbc2.jar [JDBC4.X Driver] <Installation folder>\fjjdbc\lib\fjsymjdbc4.jar
Driver file (Java EE 6 workbench)	[JDBC4.X Driver] <Installation folder>\fjjdbc\lib\fjsymjdbc4.jar
Driver class	com.fujitsu.symfoware.jdbc.SYMDriver
Connection URL	jdbc:symford://hostname:2050/dbname

Oracle

The driver definitions for the Oracle Thin driver are shown below.

Property	Setting
Driver file (Standard workbench)	[Oracle Database 11g JDBC Driver] <JDBC driver storage destination directory>\ojdbc6.jar
Driver file (Java EE 6 workbench)	[Oracle Database 11g Release 2 JDBC Driver] <JDBC driver storage destination directory>\ojdbc6.jar
Driver class	oracle.jdbc.OracleDriver
Connection URL	jdbc:oracle:thin:@server:1521:db

SQL Server

Microsoft(R) JDBC drivers are not bundled with Microsoft(R) SQL Server(TM). Download the SQL Server(TM) JDBC Driver 2.0 or later from the Microsoft Corporation website, then install and use the driver.

An example of the driver definitions is shown below.

Property	Setting
Driver file (Standard workbench)	<Installation folder>\sqljdbc_<version>\<location>\sqljdbc4.jar <version>: For Microsoft(R) SQL Server(TM) JDBC Driver 2.0, use "2.0". <version>: For Microsoft(R) SQL Server(TM) JDBC Driver 3.0, use "3.0". <version>: For Microsoft(R) JDBC Driver 4.0 for SQL Server(TM), use "4.0". <location>: For the English edition, use "enu" ; For the Japanese edition: use "jpn".
Driver file (Java EE 6 workbench)	<Installation folder>\sqljdbc_<version>\<location>\sqljdbc4.jar <version>: For Microsoft(R) SQL Server(TM) JDBC Driver 3.0, use "3.0" <version>: For Microsoft(R) JDBC Driver 4.0 for SQL Server(TM), use "4.0". <location>: For the English edition, use "enu" ; For the Japanese edition: use "jpn".
Driver class	com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection URL	jdbc:sqlserver://localhost:1433;databaseName=pubs

PowerGres Plus

When connecting to PowerGres Plus, copy the driver that is bundled with PowerGres Plus to a local environment and use this driver.

An example of the driver definitions is shown below.

Property	Setting
Driver file (Standard workbench)	Copy the drivers below to the local environment and use those drivers. [PowerGres Plus installation destination driver location] /usr/local/pgsqlplus/share/java/postgresql_jdbc4.jar
Driver file (Java EE 6 workbench)	Copy the drivers below to the local environment and use those drivers. [PowerGres Plus installation destination driver location] /usr/local/pgsqlplus/share/java/postgresql_jdbc4.jar
Driver class	org.postgresql.Driver
Connection URL	jdbc:postgresql://hostname:5432/<Database name>

Derby (Java DB)

When connecting to Derby (Java DB), the drivers bundled with this product can be used. The standard workbench can connect to Derby (Java DB) V10.4, and the Java EE 6 workbench can connect to Derby (Java DB) V10.8.

An example of the driver definitions is shown below.

Property	Setting
Driver file (Standard workbench)	[Derby 10.4 Derby embedded JDBC driver] <Interstage Studio Installation folder>\APS\F3FMisjee\javadb\lib\derby.jar [Derby client JDBC driver] <Interstage Studio Installation folder>\APS\F3FMisjee\javadb\lib\derbyclient.jar
Driver file (Java EE 6 workbench)	[Derby 10.8 Derby embedded JDBC driver] <Interstage Studio Installation folder>\APS\F3FMisje6\javadb\lib\derby.jar [Derby client JDBC driver] <Interstage Studio Installation folder>\APS\F3FMisje6\javadb\lib\derbyclient.jar
Driver class	[Derby 10.4/10.8 Derby embedded JDBC driver] org.apache.derby.jdbc.EmbeddedDriver [Derby client JDBC driver] org.apache.derby.jdbc.ClientDriver
Connection URL	jdbc:derby:<database location>;create=true

HA Database Ready (NativeSQL)

When connecting to HA Database Ready (NativeSQL), use the native bridge (type 2) driver type as the connection format.

The driver definitions for remote access (RDB2_TCP linkage) are shown below.

Property	Setting
Driver file (Standard workbench)	[JDBC2.X Driver] <Client Installation folder>\fjjdbc\lib\fjsymjdbc2.jar [JDBC4.X Driver] <Client Installation folder>\fjjdbc\lib\fjsymjdbc4.jar
Driver file (Java EE 6 workbench)	[JDBC4.X Driver] <Client Installation folder>\fjjdbc\lib\fjsymjdbc4.jar
Driver class	com.fujitsu.symfoware.jdbc.SYMDriver
Connection URL	jdbc:symford://hostname:26551/dbname

HA Database Ready (OpenSQL)

When connecting to HA Database Ready (OpenSQL), copy the driver that is bundled with HA Database Ready (OpenSQL) to a local environment and use this driver.

An example of the driver definitions is shown below.

Property	Setting
Driver file (Standard workbench)	[JDBC4.X Driver] <Client Installation folder \OICL32\JDBC\lib\postgresql-jdbc4.jar Note: For 64-bit systems, the file is in the OICL64 folder
Driver file (Java EE 6 workbench)	[JDBC4.X Driver] <Client Installation folder>\OICL32\JDBC\lib\postgresql-jdbc4.jar Note: For 64-bit systems, the file is in the OICL64 folder
Driver class	org.postgresql.Driver
Connection URL	jdbc:postgresql://hostname:5432/<Database name>

8.3.7.2 Connection Profile Properties

This section describes the properties to be set when creating a new connection profile.

Symfoware Server

Property	Content
Database	Database name
Host	Database server name or IP address
Port number	Port number used in database connection
User name	Username used in database connection
Password	Password used in database connection

Oracle

Property	Content
SID	Database SID
Host	Database server name or IP address
Port number	Port number used in database connection
User name	Username used in database connection
Password	Password used in database connection

SQL Server

Property	Content
Database	Database name
Host	Database server name or IP address
Port number	Port number used in database connection
Use integrated authentication	Select if using Windows authentication in database connection.
User name	Username used in database connection. Set this property if not using integrated authentication
Password	Password used in database connection. Set this property if not using integrated authentication

Note

To use [Use integrated authentication] in the SQL Server connection profile, the sqljdbc_auth.dll(x86) provided with the SQL Server JDBC driver is required. Add the folder storing sqljdbc_auth.dll(x86) (example: <SQL Server JDBC driver installation folder>\sqljdbc_1.2\jpn\auth\x86) to the environment variable PATH in advance.

PowerGres Plus

Property	Content
Database	Database name
URL	URL used in database connection
User name	Username used in database connection
Password	Password used in database connection

Derby (Java DB)

Property	Content
Database location	Name of folder in which the database is deployed
User name	Username used in database connection (optional)
Password	Password used in database connection (optional)

HA Database Ready (NativeSQL)

Property	Content
Database	Database name
Host	Database server name or IP address
Port number	Port number used in database connection
User name	Username used in database connection
Password	Password used in database connection

HA Database Ready (OpenSQL)

Property	Content
Database	Database name
URL	URL used in database connection
User name	Username used in database connection
Password	Password used in database connection

8.3.7.3 Editable Data Types

The following table shows the editable data types for the Table Data editor, data extraction, and data loading.

Symfoware Server

Data Type	Explanation
CHARACTER	Fixed-length character string type
CHARACTER VARYING	Variable-length character string type
NATIONAL CHARACTER	Fixed-length national character string type
NATIONAL CHARACTER VARYING	Variable-length national character string type
NUMERIC	Exact numeric type
DECIMAL	Exact numeric type
INTEGER	Exact numeric type
SMALLINT	Exact numeric type
REAL	Approximate numeric type
DOUBLE PRECISION	Approximate numeric type
DATE	Date-time type (date)
TIME	Date-time type (time)
TIMESTAMP	Date-time type
BINARY LARGE OBJECT	Binary type

Oracle

Data Type	Explanation
CHAR	Fixed-length character string type
VARCHAR2	Variable-length character string type
NCHAR	Fixed-length national character string type
NVARCHAR2	Variable-length national character string type
NUMBER	Numeric data type
FLOAT	Floating point data type
LONG	Variable-length character string type
LONG RAW	Variable-length binary type
RAW	Variable-length binary type
DATE	Date-time type, but the time cannot be edited
BLOB	Binary type
CLOB	Character string type
NCLOB	National character string type

Note

Data cannot be modified or deleted in tables that have BLOB, CLOB, LONG, LONG RAW and NCLOB type columns, and that do not have a primary key.

SQL Server

Data Type	Explanation
bit	Truth value type
bigint	int type
int	int type
smallint	int type
tinyint	int type
decimal	decimal type
numeric	numeric type
money	money type
smallmoney	smallmoney type
float	Approximate numeric type
real	Approximate numeric type
datetime	datetime type
smalldatetime	smalldatetime type
char	Fixed-length character string type
varchar	Variable-length character string type
nchar	Fixed-length national character string type
nvarchar	Variable-length national character string type
binary	Fixed-length binary type
varbinary	Variable-length binary type
uniqueidentifier	GUID

PowerGres Plus

Data Type	Explanation
smallint	Small-range integer
integer	Usual choice for integer
bigint	Large-range integer
decimal	User-specified precision, exact
numeric	User-specified precision, exact
real	Variable-precision, inexact
double precision	Variable-precision, inexact
serial	Autoincrementing integer
bigserial	Large autoincrementing integer
character varying,varchar	Variable-length with limit
character,char	Fixed-length, blank padded
text	Variable unlimited length
bytea	Variable-length binary string
date	Date only
timestamp	Both date and time
timestamp with time zone	Both date and time, with time zone
time	Times of day only
time with time zone	Times of day only, with time zone
boolean	boolean type
oid	Object identifier

Derby(Java DB)

Data Type	Explanation
CHAR	Fixed-length character string type
CHAR FOR BIT DATA	Fixed-length bit string type
VARCHAR	Variable-length character string type
VARCHAR FOR BIT DATA	Variable-length bit string type
NUMERIC	Exact numeric type
DECIMAL	Exact numeric type
INTEGER	Exact numeric type
SMALLINT	Exact numeric type
BIGINT	Exact numeric type
REAL	Approximate numeric type
DOUBLE PRECISION,DOUBLE	Approximate numeric type
DATE	Date-time type (date)
TIME	Date-time type (time)
TIMESTAMP	Date-time type

HA Database Ready (NativeSQL)

Data Type	Explanation
CHARACTER	Fixed-length character string type
CHARACTER VARYING	Variable-length character string type
NATIONAL CHARACTER	Fixed-length national character string type
NATIONAL CHARACTER VARYING	Variable-length national character string type
NUMERIC	Exact numeric type
DECIMAL	Exact numeric type
INTEGER	Exact numeric type
SMALLINT	Exact numeric type
REAL	Approximate numeric type
DOUBLE PRECISION	Approximate numeric type
DATE	Date-time type (date)
TIME	Date-time type (time)
TIMESTAMP	Date-time type
BINARY LARGE OBJECT	Binary type

HA Database Ready (OpenSQL)

Data Type	Explanation
smallint	Small-range integer
integer	Usual choice for integer
bigint	Large-range integer
decimal	User-specified precision, exact
numeric	User-specified precision, exact
real	Variable-precision, inexact
double precision	Variable-precision, inexact
serial	Autoincrementing integer
bigserial	Large autoincrementing integer
character varying,varchar	Variable-length with limit
character,char	Fixed-length, blank padded
text	Variable unlimited length
bytea	Variable-length binary string
date	Date only
timestamp	Both date and time
timestamp with time zone	Both date and time, with time zone
time	Times of day only
time with time zone	Times of day only, with time zone
boolean	boolean type
oid	Object identifier

Note

In the Java EE 6 workbench, tables of decimal and numeric types cannot be operated.