Messages and limitations of the Amazon RDS for PostgreSQL connector
Message code list of AMAZONRDSPOSTGRESQL category
The following message codes correspond to errors that occur in Amazon RDS for PostgreSQL Connector.
This message code is output when an undefined error occurs.
|
Cause |
Solution |
|---|---|
|
An undefined error occurred. |
Check the error message or the help of the operation in which the error has occurred. |
Corresponding error
-
None
This message code corresponds to errors that occur during database processing.
|
Cause |
Solution |
|---|---|
|
The cause differs according to each error message. |
Check the error message and perform the following:
|
Corresponding error
-
java.sql.SQLException
-
org.postgresql.util.PSQLException
Exception messages of AMAZONRDSPOSTGRESQL category
|
Exception name |
Cause |
Solution |
|
|---|---|---|---|
|
InputDataNotFoundException |
Input data isn't specified. |
Specify Input data or draw data flow. |
|
|
InvalidPropertyConfigurationException |
SQL statement isn't set. |
Specify SQL statement. |
|
|
InvalidPropertyConfigurationException Target column is not selected. |
Target for Schema definition isn't selected in the Write Table operation. |
Select one or more Target for Schema definition. |
|
|
InvalidPropertyConfigurationException Target column is not selected. |
Target for Schema definition isn't selected in the Read Table operation. |
Select one or more Target for Schema definition. |
|
|
InvalidPropertyConfigurationException |
Table name isn't set. |
Specify Table name. |
|
|
java.sql.SQLException |
A database access error or some other one has occurred. |
Check the SQLException message. SQLException message is based on the specifications of the driver. The cause of the error might be output in SQLException message. For details on messages, contact the database vendor. |
|
|
ResourceNotFoundException Resource definition could not be found. Name: [] |
Destination isn't specified. |
Specify Destination. |
|
|
ResourceNotFoundException Resource definition could not be found. Name: [<connection resource name>] |
The resource definition selected in Destination isn't found. |
Check the connection resource specified in Destination. |
|
|
org.postgresql.util.PSQLException |
FATAL: database "<database name>" does not exist. |
The database doesn't exist. |
Specify an existing database in Database name of the connection resource. |
|
FATAL: password authentication failed for user "<user name>" |
The user name or the password is incorrect. |
Check User name and Password of the connection resource. |
|
|
ERROR: syntax error at or near "<table name>" |
The table name is invalid. |
Check the table name specified in Table name. |
|
|
ERROR: relation "<table name>" does not exist |
The table doesn't exist. |
Specify an existing table in Table name. |
|
|
ERROR: permission denied for table <table name> |
The user has no permission to read the table. |
Check the read permission for the table specified in Table name. |
|
|
Connection test failed. |
Can't connect to the database. |
Check Host name and Port number of the connection resource. |
|
|
SSL Error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target |
A certificate isn't imported to the keystore. |
Import a certificate to the keystore. Contact support when you import the certificate. |
|
Limitations of AMAZONRDSPOSTGRESQL category
This connector supports the following types.
|
Type name |
Support |
Remarks |
|---|---|---|
|
BIGINT |
Yes |
|
|
BIGSERIAL |
No |
|
|
BIT[(n)] |
No |
|
|
BIT VARYING[(n)] |
Limited |
|
|
BOOLEAN |
Yes |
|
|
BOX |
No |
|
|
BYTEA |
Limited |
|
|
MONEY |
No |
|
|
CHARACTER[(n)] |
Limited |
|
|
CHARACTER VARYING[(n)] |
Limited |
|
|
CIDR |
Limited |
|
|
CIRCLE |
Limited |
|
|
DATE |
Yes |
|
|
DOUBLE PRECISION |
Yes |
|
|
INET |
Limited |
|
|
INTEGER |
Yes |
|
|
INTERVAL[(p)] |
Limited |
|
|
LINE |
No |
|
|
LSEG |
Limited |
|
|
MACADDR |
Limited |
|
|
NUMERIC[(p,s)] |
Yes |
|
|
PATH |
Limited |
|
|
POINT |
Limited |
|
|
POLYGON |
Limited |
|
|
REAL |
Yes |
|
|
SMALLINT |
Yes |
|
|
SERIAL |
No |
|
|
TEXT |
Limited |
|
|
TIME[(P)] |
No |
|
|
TIME[(P)] WITH TIME ZONE |
No |
|
|
TIMESTAMP[(P)] |
Yes |
|
|
TIMESTAMP[(P)] WITH TIME ZONE |
Yes |
|
|
ARRAY |
Limited |
|
|
UUID |
No |
|
|
ENUM |
No |
|
|
XML |
No |
|
|
JSON |
No |
|
|
JSONB |
No |
|
|
RANGE |
No |
|
-
Yes: Supported.
-
Limited: Supported with limitations.
-
No: Not supported.
Specification limits
-
CHARACTER VARYING, CHARACTER, TEXT
-
The maximum byte length is 10,485,760.
-
-
BYTEA
-
Backslashes (\) and apostrophes (') aren't supported.
-
-
When the table name is enclosed with quotation marks, it's case-sensitive.
-
The default value for Fetch size is 500.
Specification limits
-
CHARACTER VARYING, CHARACTER, TEXT
-
The maximum byte length is 10,485,760.
-
-
BYTEA
-
Backslashes (\) and apostrophes (') aren't supported.
-
-
The default value for Fetch size is 500.
Specification limits
-
The following types aren't supported.
-
CIDR
-
CIRCLE
-
INTERVAL
-
LSEG
-
PATH
-
POINT
-
POLYGON
-
BIT VARYING
-
BIT VARYING(N)
-
ARRAY
-
INET
-
MACADDR
-
-
CHARACTER VARYING, CHARACTER, TEXT
-
The maximum byte length is 10,485,760.
-
-
BYTEA
-
Backslashes (\) and apostrophes (') aren't supported.
-
-
When the table name is enclosed with quotation marks, it's case-sensitive.
-
Insert before update of Update mode can't be used.
Specification limits
-
The following types aren't supported.
-
CIDR
-
CIRCLE
-
INTERVAL
-
LSEG
-
PATH
-
POINT
-
POLYGON
-
BIT VARYING
-
BIT VARYING(N)
-
ARRAY
-
INET
-
MACADDR
-
-
CHARACTER VARYING, CHARACTER, TEXT
-
The maximum byte length is 10,485,760.
-
-
BYTEA
-
Backslashes (\) and apostrophes (') aren't supported.
-