Subject | Re: [Firebird-Java] Re: Denied connections due to character set |
---|---|
Author | William L. Thomson Jr. |
Post date | 2017-02-14T03:24:28Z |
The fun continues.... Thus far nothing works. I first ran into this only with
3.x but now is happening with all version of 2.x. It is not happening on my
servers just on desktop applications.
I tried the various combos, where you see spaces below, NONE UTF8 ASCII...
That means I did each combo, with -Dfile.encoding, and without. All produced
each error.
This combo produced this, pretty sure same for ISO-8859-1 and ISO8859-1
-Dfile.encoding=ISO8859_1
url?lc_type=ISO8859_1
Feb 13, 2017 9:50:51 PM org.firebirdsql.logging.JulLogger warn
WARNING: No EncodingDefinition for ISO8859_1 / null specifying ISO8859_1 as
connection encoding
java.sql.SQLNonTransientConnectionException: No valid encoding definition for
Firebird encoding ISO8859_1 and/or Java charset null
-Dfile.encoding=NONE UTF8 ASCII
url?lc_type=NONE UTF8 ASCII ISO8859_1
java.sql.SQLException: Your user name and password are not defined. Ask your
database administrator to set up a Firebird login.; Install incomplete, please
read the Compatibility chapter in the release notes for this version
[SQLState:28000, ISC error code:335544472
url?lc_type=NONE&encoding=NONE
org.firebirdsql.jdbc.FBSQLException: Specified properties contain reference to a
DPB parameter under original and alias names: original name isc_dpb_lc_ctype,
alias : encoding
--
William L. Thomson Jr.
[Non-text portions of this message have been removed]
3.x but now is happening with all version of 2.x. It is not happening on my
servers just on desktop applications.
I tried the various combos, where you see spaces below, NONE UTF8 ASCII...
That means I did each combo, with -Dfile.encoding, and without. All produced
each error.
This combo produced this, pretty sure same for ISO-8859-1 and ISO8859-1
-Dfile.encoding=ISO8859_1
url?lc_type=ISO8859_1
Feb 13, 2017 9:50:51 PM org.firebirdsql.logging.JulLogger warn
WARNING: No EncodingDefinition for ISO8859_1 / null specifying ISO8859_1 as
connection encoding
java.sql.SQLNonTransientConnectionException: No valid encoding definition for
Firebird encoding ISO8859_1 and/or Java charset null
-Dfile.encoding=NONE UTF8 ASCII
url?lc_type=NONE UTF8 ASCII ISO8859_1
java.sql.SQLException: Your user name and password are not defined. Ask your
database administrator to set up a Firebird login.; Install incomplete, please
read the Compatibility chapter in the release notes for this version
[SQLState:28000, ISC error code:335544472
url?lc_type=NONE&encoding=NONE
org.firebirdsql.jdbc.FBSQLException: Specified properties contain reference to a
DPB parameter under original and alias names: original name isc_dpb_lc_ctype,
alias : encoding
--
William L. Thomson Jr.
[Non-text portions of this message have been removed]