Symfoware Server V12.0.0 Cluster Operation Guide

3.5 Notes and Actions to Take When Creating an Application

This section explains notes to be taken when creating an application, and actions for the application when state transition occurs.

Notes to be taken when creating an application

To use the IP address when creating an application, use the IP address that was specified when the Gls resource or takeover network resource was created. By doing this, the application can be executed by just re-executing it without any changes made when state transition occurs.

Actions for the application when state transition occurs

This section explains the error information that is returned and actions to be taken if an error occurs on the node where Symfoware is operating (while accessing an application running on another node such as an application server).

Table 3.1 JDBC driver

Status		Error information (*1)	Action
Node is down or Symfoware Server system is down	Went down during access	57P01 08006	After switch is completed, reestablish the connection, or execute the application again.
	Accessed while node/system is down	08001
Switch to standby node	Switched during access	57P01 08006
	Accessed while switching	08001

*1: This is the return value of getSQLState() in SQLException.

Table 3.2 ODBC driver

Status		Error information (*1)	Action
Node is down or Symfoware Server system is down	Went down during access	57P01 08S01	After switch is completed, reestablish the connection, or execute the application again.
	Accessed while node/system is down	08001
Switch to standby node	Switched during access	57P01 08S01
	Accessed while switching	08001

*1: This is the return value of SQLSTATE.

Table 3.3 .NET Data Provider

Status		Error information	Action
Node is down or Symfoware Server system is down	Went down during access	57P01 (*1) Empty string (*1) A NullReferenceException occurs	After switch is completed, reestablish the connection, or execute the application again.
	Accessed while node/system is down	Empty string (*1)
Switch to standby node	Switched during access	57P01 (*1) Empty string (*1) A NullReferenceException occurs
	Accessed while switching	Empty string (*1)

*1: This is the return value of the "Code" attribute in NpgsqlException.

Table 3.4 libpq - C library

Status		Error information	Action
Node is down or Symfoware Server system is down	Went down during access	PGRES_FATAL_ERROR(*1) 57P01(*2) NULL(*2)	After switch is completed, reestablish the connection, or execute the application again.
	Accessed while node/system is down	CONNECTION_BAD(*3)
Switch to standby node	Switched during access	PGRES_FATAL_ERROR(*1) 57P01(*2) NULL(*2)
	Accessed while switching	CONNECTION_BAD(*3)

*1: This is the return value of PQresultStatus().

*2: This is the return value of PG_DIAG_SQLSTATE in PQresultErrorField().

*3: This is the return value of PQstatus().

Table 3.5 ECPG - Embedded SQL in C

Status		Error information(*1)	Action
Node is down or Symfoware Server system is down	Went down during access	57P01 57P02 YE000 26000	After switch is completed, reestablish the connection, or execute the application again.
	Accessed while node/system is down	08001
Switch to standby node	Switched during access	57P01 57P02 YE000 26000
	Accessed while switching	08001

*1: This is the return value of SQLSTATE.