Produced by Araxis Merge on 5/10/2018 8:40:19 AM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | Thu May 10 13:40:19 2018 UTC | ||
2 | MHED_APPS_CIF.zip\VAR v4.2.7\var-resources-4.2.7@54bdc2933ef.zip\var-db\liquibase\build-lib\mysql-connector-java-5.1.23-bin.jar\com\mysql\jdbc | LocalizedErrorMessages.properties | Sat Jan 26 04:26:16 2013 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 0 | 0 |
Changed | 0 | 0 |
Inserted | 1 | 673 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | # | |||||
2 | # Fixed | |||||
3 | # | |||||
4 | ||||||
5 | ResultSet. Retrieved_ _1=Retriev ed | |||||
6 | ResultSet. Bad_format _for_BigDe cimal=Bad format for BigDecima l ''{0}'' in column {1}. | |||||
7 | ResultSet. Bad_format _for_BigIn teger=Bad format for BigIntege r ''{0}'' in column {1}. | |||||
8 | ResultSet. Column_Ind ex_out_of_ range_low= Column Ind ex out of range, {0} < 1. | |||||
9 | ResultSet. Column_Ind ex_out_of_ range_high =Column In dex out of range, {0 } > {1}. | |||||
10 | ResultSet. Value_is_o ut_of_rang e=Value '' {0}'' is o ut of rang e [{1}, {2 }]. | |||||
11 | ResultSet. Positioned _Update_no t_supporte d=Position ed Update not suppor ted. | |||||
12 | ResultSet. Bad_format _for_Date= Bad format for DATE ''{0}'' in column {1 }. | |||||
13 | ResultSet. Bad_format _for_Colum n=Bad form at for {0} ''{1}'' i n column { 2} ({3}). | |||||
14 | ResultSet. Bad_format _for_numbe r=Bad form at for num ber ''{0}' ' in colum n {1}. | |||||
15 | ResultSet. Illegal_op eration_on _empty_res ult_set=Il legal oper ation on e mpty resul t set. | |||||
16 | ||||||
17 | Statement. 0=Connecti on is clos ed. | |||||
18 | Statement. 2=Unsuppor ted charac ter encodi ng ''{0}'' | |||||
19 | Statement. 5=Illegal value for setFetchDi rection(). | |||||
20 | Statement. 7=Illegal value for setFetchSi ze(). | |||||
21 | Statement. 11=Illegal value for setMaxFie ldSize(). | |||||
22 | Statement. 13=Can not set max f ield size > max allo wed packet of {0} by tes. | |||||
23 | Statement. 15=setMaxR ows() out of range. | |||||
24 | Statement. 19=Illegal flag for getMoreRes ults(int). | |||||
25 | Statement. 21=Illegal value for setQueryT imeout(). | |||||
26 | Statement. 27=Connect ion is rea d-only. | |||||
27 | Statement. 28=Queries leading t o data mod ification are not al lowed. | |||||
28 | Statement. 34=Connect ion is rea d-only. | |||||
29 | Statement. 35=Queries leading t o data mod ification are not al lowed. | |||||
30 | Statement. 40=Can not issue INS ERT/UPDATE /DELETE wi th execute Query(). | |||||
31 | Statement. 42=Connect ion is rea d-only. | |||||
32 | Statement. 43=Queries leading t o data mod ification are not al lowed. | |||||
33 | Statement. 46=Can not issue SEL ECT via ex ecuteUpdat e(). | |||||
34 | Statement. 49=No oper ations all owed after statement closed. | |||||
35 | Statement. 57=Can not issue dat a manipula tion state ments with executeQu ery(). | |||||
36 | Statement. 59=Can not issue NUL L query. | |||||
37 | Statement. 61=Can not issue emp ty query. | |||||
38 | Statement. 63=Stateme nt not clo sed explic itly. You should cal l close() on created | |||||
39 | Statement. 64=Stateme nt instanc es from yo ur code to be more e fficient. | |||||
40 | Statement. GeneratedK eysNotRequ ested=Gene rated keys not reque sted. You need to sp ecify Stat ement.RETU RN_GENERAT ED_KEYS to Statement .executeUp date() or Connection .prepareSt atement(). | |||||
41 | Statement. Connection KilledDueT oTimeout=C onnection closed to due to sta tement tim eout being reached a nd "queryT imeoutKill sConnectio n" being s et to "tru e". | |||||
42 | UpdatableR esultSet.1 =Can not c all delete Row() when on insert row. | |||||
43 | UpdatableR esultSet.2 =Can not c all delete Row() on e mpty resul t set. | |||||
44 | UpdatableR esultSet.3 =Before st art of res ult set. C an not cal l deleteRo w(). | |||||
45 | UpdatableR esultSet.4 =After end of result set. Can not call d eleteRow() . | |||||
46 | UpdatableR esultSet.7 =Not on in sert row. | |||||
47 | UpdatableR esultSet.8 =Can not c all refres hRow() whe n on inser t row. | |||||
48 | UpdatableR esultSet.9 =Can not c all refres hRow() on empty resu lt set. | |||||
49 | UpdatableR esultSet.1 0=Before s tart of re sult set. Can not ca ll refresh Row(). | |||||
50 | UpdatableR esultSet.1 1=After en d of resul t set. Can not call refreshRow (). | |||||
51 | UpdatableR esultSet.1 2=refreshR ow() calle d on row t hat has be en deleted or had pr imary key changed. | |||||
52 | UpdatableR esultSet.3 4=Updatabl e result s et created , but neve r updated. You shoul d only cre ate updata ble result sets when you want to update/ insert/del ete values using the updateRow (), delete Row() and insertRow( ) methods. | |||||
53 | UpdatableR esultSet.3 9=Unsuppor ted charac ter encodi ng ''{0}'' . | |||||
54 | UpdatableR esultSet.4 3=Can not create upd atable res ult sets w hen there is no curr ently sele cted datab ase and My SQL server version < 4.1. | |||||
55 | ||||||
56 | # | |||||
57 | # Possible re-names | |||||
58 | # | |||||
59 | ||||||
60 | ResultSet. Query_gene rated_no_f ields_for_ ResultSet_ 57=Query g enerated n o fields f or ResultS et | |||||
61 | ResultSet. Illegal_va lue_for_fe tch_direct ion_64=Ill egal value for fetch direction | |||||
62 | ResultSet. Value_must _be_betwee n_0_and_ge tMaxRows() _66=Value must be be tween 0 an d getMaxRo ws() | |||||
63 | ResultSet. Query_gene rated_no_f ields_for_ ResultSet_ 99=Query g enerated n o fields f or ResultS et | |||||
64 | ResultSet. Cannot_abs olute_posi tion_to_ro w_0_110=Ca nnot absol ute positi on to row 0 | |||||
65 | ResultSet. Operation_ not_allowe d_after_Re sultSet_cl osed_144=O peration n ot allowed after Res ultSet clo sed | |||||
66 | ResultSet. Before_sta rt_of_resu lt_set_146 =Before st art of res ult set | |||||
67 | ResultSet. After_end_ of_result_ set_148=Af ter end of result se t | |||||
68 | ResultSet. Query_gene rated_no_f ields_for_ ResultSet_ 133=Query generated no fields for Result Set | |||||
69 | ResultSet. ResultSet_ is_from_UP DATE._No_D ata_115=Re sultSet is from UPDA TE. No Dat a. | |||||
70 | ResultSet. N/A_159=N/ A | |||||
71 | ||||||
72 | # | |||||
73 | # To fix | |||||
74 | # | |||||
75 | ||||||
76 | ResultSet. Invalid_va lue_for_ge tFloat()_- ____68=Inv alid value for getFl oat() - \' | |||||
77 | ResultSet. Invalid_va lue_for_ge tInt()_-__ __74=Inval id value f or getInt( ) - \' | |||||
78 | ResultSet. Invalid_va lue_for_ge tLong()_-_ ___79=Inva lid value for getLon g() - \' | |||||
79 | ResultSet. Invalid_va lue_for_ge tFloat()_- ____200=In valid valu e for getF loat() - \ ' | |||||
80 | ResultSet. ___in_colu mn__201=\' in column | |||||
81 | ResultSet. Invalid_va lue_for_ge tInt()_-__ __206=Inva lid value for getInt () - \' | |||||
82 | ResultSet. ___in_colu mn__207=\' in column | |||||
83 | ResultSet. Invalid_va lue_for_ge tLong()_-_ ___211=Inv alid value for getLo ng() - \' | |||||
84 | ResultSet. ___in_colu mn__212=\' in column | |||||
85 | ResultSet. Invalid_va lue_for_ge tShort()_- ____217=In valid valu e for getS hort() - \ ' | |||||
86 | ResultSet. ___in_colu mn__218=\' in column | |||||
87 | ||||||
88 | ResultSet. Class_not_ found___91 =Class not found: | |||||
89 | ResultSet. _while_rea ding_seria lized_obje ct_92=\ wh ile readin g serializ ed object | |||||
90 | ||||||
91 | ResultSet. Invalid_va lue_for_ge tShort()_- ____96=Inv alid value for getSh ort() - \' | |||||
92 | ResultSet. Unsupporte d_characte r_encoding ____101=Un supported character encoding \ ' | |||||
93 | ||||||
94 | ResultSet. Malformed_ URL____104 =Malformed URL \' | |||||
95 | ResultSet. Malformed_ URL____107 =Malformed URL \' | |||||
96 | ResultSet. Malformed_ URL____141 =Malformed URL \' | |||||
97 | ||||||
98 | ResultSet. Column____ 112=Column \' | |||||
99 | ResultSet. ___not_fou nd._113=\' not found . | |||||
100 | ||||||
101 | ResultSet. Unsupporte d_characte r_encoding ____135=Un supported character encoding \ ' | |||||
102 | ResultSet. Unsupporte d_characte r_encoding ____138=Un supported character encoding \ ' | |||||
103 | ||||||
104 | # | |||||
105 | # Usage ad visor mess ages for R esultSets | |||||
106 | # | |||||
107 | ||||||
108 | ResultSet. ResultSet_ implicitly _closed_by _driver=Re sultSet im plicitly c losed by d river.\n\n You should close Res ultSets ex plicitly f rom your c ode to fre e up resou rces in a more effic ient manne r. | |||||
109 | ResultSet. Possible_i ncomplete_ traversal_ of_result_ set=Possib le incompl ete traver sal of res ult set. C ursor was left on ro w {0} of { 1} rows wh en it was closed.\n\ nYou shoul d consider re-formul ating your query to return onl y the rows you are i nterested in using. | |||||
110 | ResultSet. The_follow ing_column s_were_nev er_referen ced=The fo llowing co lumns were part of t he SELECT statement for this r esult set, but were never refe renced: | |||||
111 | ResultSet. Too_Large_ Result_Set =Result se t size of {0} rows i s larger t han \"resu ltSetSizeT hreshold\" of {1} ro ws. Applic ation may be request ing more d ata than i t is using . Consider reformula ting the q uery. | |||||
112 | ResultSet. CostlyConv ersion=Res ultSet typ e conversi on via par sing detec ted when c alling {0} for colum n {1} (col umn named ''{2}'') i n table '' {3}''{4}\n \nJava cla ss of colu mn type is ''{5}'', MySQL fiel d type is ''{6}''.\n \nTypes th at could b e converte d directly without p arsing are :\n{7} | |||||
113 | ResultSet. CostlyConv ersionCrea tedFromQue ry= create d from que ry:\n\n | |||||
114 | ||||||
115 | ResultSet. Value____1 73=Value \ ' | |||||
116 | ResultSetM etaData.46 =Column in dex out of range. | |||||
117 | ResultSet. ___is_out_ of_range_[ -127,127]_ 174=\' is out of ran ge [-127,1 27] | |||||
118 | ResultSet. Bad_format _for_Date_ ___180=Bad format fo r Date \' | |||||
119 | ||||||
120 | ResultSet. Timestamp_ too_small_ to_convert _to_Time_v alue_in_co lumn__223= Timestamp too small to convert to Time v alue in co lumn | |||||
121 | ResultSet. Precision_ lost_conve rting_TIME STAMP_to_T ime_with_g etTime()_o n_column__ 227=Precis ion lost c onverting TIMESTAMP to Time wi th getTime () on colu mn | |||||
122 | ResultSet. Precision_ lost_conve rting_DATE TIME_to_Ti me_with_ge tTime()_on _column__2 30=Precisi on lost co nverting D ATETIME to Time with getTime() on column | |||||
123 | ResultSet. Bad_format _for_Time_ ___233=Bad format fo r Time \' | |||||
124 | ResultSet. ___in_colu mn__234=\' in column | |||||
125 | ResultSet. Bad_format _for_Times tamp____24 4=Bad form at for Tim estamp \' | |||||
126 | ResultSet. ___in_colu mn__245=\' in column | |||||
127 | ResultSet. Cannot_con vert_value ____249=Ca nnot conve rt value \ ' | |||||
128 | ResultSet. ___from_co lumn__250= \' from co lumn | |||||
129 | ResultSet. _)_to_TIME STAMP._252 =\ ) to TI MESTAMP. | |||||
130 | ResultSet. Timestamp_ too_small_ to_convert _to_Time_v alue_in_co lumn__257= Timestamp too small to convert to Time v alue in co lumn | |||||
131 | ResultSet. Precision_ lost_conve rting_TIME STAMP_to_T ime_with_g etTime()_o n_column__ 261=Precis ion lost c onverting TIMESTAMP to Time wi th getTime () on colu mn | |||||
132 | ResultSet. Precision_ lost_conve rting_DATE TIME_to_Ti me_with_ge tTime()_on _column__2 64=Precisi on lost co nverting D ATETIME to Time with getTime() on column | |||||
133 | ResultSet. Bad_format _for_Time_ ___267=Bad format fo r Time \' | |||||
134 | ResultSet. ___in_colu mn__268=\' in column | |||||
135 | ResultSet. Bad_format _for_Times tamp____27 8=Bad form at for Tim estamp \' | |||||
136 | ResultSet. ___in_colu mn__279=\' in column | |||||
137 | ResultSet. Cannot_con vert_value ____283=Ca nnot conve rt value \ ' | |||||
138 | ResultSet. ___from_co lumn__284= \' from co lumn | |||||
139 | ResultSet. _)_to_TIME STAMP._286 =\ ) to TI MESTAMP. | |||||
140 | CallableSt atement.2= Parameter name can n ot be NULL or zero-l ength. | |||||
141 | CallableSt atement.3= No paramet er named ' | |||||
142 | CallableSt atement.4= ' | |||||
143 | CallableSt atement.5= Parameter named ' | |||||
144 | CallableSt atement.6= ' is not a n OUT para meter | |||||
145 | CallableSt atement.7= No output parameters registere d. | |||||
146 | CallableSt atement.8= No output parameters returned by procedu re. | |||||
147 | CallableSt atement.9= Parameter number | |||||
148 | CallableSt atement.10 =\ is not an OUT par ameter | |||||
149 | CallableSt atement.11 =Parameter index of | |||||
150 | CallableSt atement.12 =\ is out of range ( 1, | |||||
151 | CallableSt atement.13 =) | |||||
152 | CallableSt atement.14 =Can not u se streami ng result sets with callable s tatements that have output par ameters | |||||
153 | CallableSt atement.1= Unable to retrieve m etadata fo r procedur e. | |||||
154 | CallableSt atement.0= Parameter name can n ot be | |||||
155 | CallableSt atement.15 =null. | |||||
156 | CallableSt atement.16 =empty. | |||||
157 | CallableSt atement.21 =Parameter | |||||
158 | CallableSt atement.22 =\ is not registered as an out put parame ter | |||||
159 | Communicat ionsExcept ion.2=\ is longer th an the ser ver config ured value of | |||||
160 | Communicat ionsExcept ion.3='wai t_timeout' | |||||
161 | Communicat ionsExcept ion.4='int eractive_t imeout' | |||||
162 | Communicat ionsExcept ion.5=may or may not be greate r than the server-si de timeout | |||||
163 | Communicat ionsExcept ion.6=(the driver wa s unable t o determin e the valu e of eithe r the | |||||
164 | Communicat ionsExcept ion.7='wai t_timeout' or 'inter active_tim eout' conf iguration values fro m | |||||
165 | Communicat ionsExcept ion.8=the server. | |||||
166 | Communicat ionsExcept ion.11=. Y ou should consider e ither expi ring and/o r testing connection validity | |||||
167 | Communicat ionsExcept ion.12=bef ore use in your appl ication, i ncreasing the server configure d values f or client timeouts, | |||||
168 | Communicat ionsExcept ion.13=or using the Connector/ J connecti on propert y 'autoRec onnect=tru e' to avoi d this pro blem. | |||||
169 | Communicat ionsExcept ion.TooMan yClientCon nections=T he driver was unable to create a connect ion due to an inabil ity to est ablish the client po rtion of a socket.\n \nThis is usually ca used by a limit on t he number of sockets imposed b y the oper ating syst em. This l imit is us ually conf igurable. \n\nFor Un ix-based p latforms, see the ma nual page for the 'u limit' com mand. Kern el or syst em reconfi guration m ay also be required. \n\nFor Wi ndows-base d platform s, see Mic rosoft Kno wledge Bas e Article 196271 (Q1 96271). | |||||
170 | Communicat ionsExcept ion.LocalS ocketAddre ssNotAvail able=The c onfigurati on paramet er \"local SocketAddr ess\" has been set t o a networ k interfac e not avai lable for use by the JVM. | |||||
171 | Communicat ionsExcept ion.20=Com munication s link fai lure | |||||
172 | Communicat ionsExcept ion.21=\ d ue to unde rlying exc eption: | |||||
173 | Communicat ionsExcept ion.Client WasStreami ng=Applica tion was s treaming r esults whe n the conn ection fai led. Consi der raisin g value of 'net_writ e_timeout' on the se rver. | |||||
174 | Communicat ionsExcept ion.Server PacketTimi ngInfoNoRe cv=The las t packet s ent succes sfully to the server was {0} m illisecond s ago. The driver ha s not rece ived any p ackets fro m the serv er. | |||||
175 | Communicat ionsExcept ion.Server PacketTimi ngInfo=The last pack et success fully rece ived from the server was {0} m illisecond s ago. Th e last pac ket sent s uccessfull y to the s erver was {1} millis econds ago . | |||||
176 | Communicat ionsExcept ion.TooMan yAuthentic ationPlugi nNegotiati ons=Too ma ny authent ication pl ugin negot iations. | |||||
177 | NonRegiste ringDriver .3=Hostnam e of MySQL Server | |||||
178 | NonRegiste ringDriver .7=Port nu mber of My SQL Server | |||||
179 | NonRegiste ringDriver .13=Userna me to auth enticate a s | |||||
180 | NonRegiste ringDriver .16=Passwo rd to use for authen tication | |||||
181 | NonRegiste ringDriver .17=Cannot load conn ection cla ss because of underl ying excep tion: ' | |||||
182 | NonRegiste ringDriver .18='. | |||||
183 | NonRegiste ringDriver .37=Must s pecify por t after ': ' in conne ction stri ng | |||||
184 | SQLError.3 5=Disconne ct error | |||||
185 | SQLError.3 6=Data tru ncated | |||||
186 | SQLError.3 7=Privileg e not revo ked | |||||
187 | SQLError.3 8=Invalid connection string at tribute | |||||
188 | SQLError.3 9=Error in row | |||||
189 | SQLError.4 0=No rows updated or deleted | |||||
190 | SQLError.4 1=More tha n one row updated or deleted | |||||
191 | SQLError.4 2=Wrong nu mber of pa rameters | |||||
192 | SQLError.4 3=Unable t o connect to data so urce | |||||
193 | SQLError.4 4=Connecti on in use | |||||
194 | SQLError.4 5=Connecti on not ope n | |||||
195 | SQLError.4 6=Data sou rce reject ed establi shment of connection | |||||
196 | SQLError.4 7=Connecti on failure during tr ansaction | |||||
197 | SQLError.4 8=Communic ation link failure | |||||
198 | SQLError.4 9=Insert v alue list does not m atch colum n list | |||||
199 | SQLError.5 0=Numeric value out of range | |||||
200 | SQLError.5 1=Datetime field ove rflow | |||||
201 | SQLError.5 2=Division by zero | |||||
202 | SQLError.5 3=Deadlock found whe n trying t o get lock ; Try rest arting tra nsaction | |||||
203 | SQLError.5 4=Invalid authorizat ion specif ication | |||||
204 | SQLError.5 5=Syntax e rror or ac cess viola tion | |||||
205 | SQLError.5 6=Base tab le or view not found | |||||
206 | SQLError.5 7=Base tab le or view already e xists | |||||
207 | SQLError.5 8=Base tab le not fou nd | |||||
208 | SQLError.5 9=Index al ready exis ts | |||||
209 | SQLError.6 0=Index no t found | |||||
210 | SQLError.6 1=Column a lready exi sts | |||||
211 | SQLError.6 2=Column n ot found | |||||
212 | SQLError.6 3=No defau lt for col umn | |||||
213 | SQLError.6 4=General error | |||||
214 | SQLError.6 5=Memory a llocation failure | |||||
215 | SQLError.6 6=Invalid column num ber | |||||
216 | SQLError.6 7=Invalid argument v alue | |||||
217 | SQLError.6 8=Driver n ot capable | |||||
218 | SQLError.6 9=Timeout expired | |||||
219 | ChannelBuf fer.0=Unsu pported ch aracter en coding ' | |||||
220 | ChannelBuf fer.1=' | |||||
221 | Field.12=U nsupported character encoding ' | |||||
222 | Field.13=' | |||||
223 | ||||||
224 | Blob.0=ind exToWriteA t must be >= 1 | |||||
225 | Blob.1=IO Error whil e writing bytes to b lob | |||||
226 | Blob.2=Pos ition 'pos ' can not be < 1 | |||||
227 | Blob.inval idStreamLe ngth=Reque sted strea m length o f {2} is o ut of rang e, given b lob length of {0} an d starting position of {1}. | |||||
228 | Blob.inval idStreamPo s=Position 'pos' can not be < 1 or > blo b length. | |||||
229 | ||||||
230 | StringUtil s.0=Unsupp orted char acter enco ding ' | |||||
231 | StringUtil s.1='. | |||||
232 | StringUtil s.5=Unsupp orted char acter enco ding ' | |||||
233 | StringUtil s.6='. | |||||
234 | StringUtil s.10=Unsup ported cha racter enc oding ' | |||||
235 | StringUtil s.11='. | |||||
236 | RowDataDyn amic.2=WAR N: Possibl e incomple te travers al of resu lt set. St reaming re sult set h ad | |||||
237 | RowDataDyn amic.3=\ r ows left t o read whe n it was c losed. | |||||
238 | RowDataDyn amic.4=\n\ nYou shoul d consider re-formul ating your query to | |||||
239 | RowDataDyn amic.5=ret urn only t he rows yo u are inte rested in using. | |||||
240 | RowDataDyn amic.6=\n\ nResultSet was creat ed at: | |||||
241 | RowDataDyn amic.7=\n\ nNested St ack Trace: \n | |||||
242 | RowDataDyn amic.8=Err or retriev ing record : Unexpect ed Excepti on: | |||||
243 | RowDataDyn amic.9=\ m essage giv en: | |||||
244 | RowDataDyn amic.10=Op eration no t supporte d for stre aming resu lt sets | |||||
245 | Clob.0=ind exToWriteA t must be >= 1 | |||||
246 | Clob.1=ind exToWriteA t must be >= 1 | |||||
247 | Clob.2=Sta rting posi tion can n ot be < 1 | |||||
248 | Clob.3=Str ing to set can not b e NULL | |||||
249 | Clob.4=Sta rting posi tion can n ot be < 1 | |||||
250 | Clob.5=Str ing to set can not b e NULL | |||||
251 | Clob.6=CLO B start po sition can not be < 1 | |||||
252 | Clob.7=CLO B start po sition + l ength can not be > l ength of C LOB | |||||
253 | Clob.8=Ill egal start ing positi on for sea rch, ' | |||||
254 | Clob.9=' | |||||
255 | Clob.10=St arting pos ition for search is past end o f CLOB | |||||
256 | Clob.11=Ca nnot trunc ate CLOB o f length | |||||
257 | Clob.12=\ to length of | |||||
258 | Clob.13=. | |||||
259 | PacketTooB igExceptio n.0=Packet for query is too la rge ( | |||||
260 | PacketTooB igExceptio n.1=\ > | |||||
261 | PacketTooB igExceptio n.2=). | |||||
262 | PacketTooB igExceptio n.3=You ca n change t his value on the ser ver by set ting the | |||||
263 | PacketTooB igExceptio n.4=max_al lowed_pack et' variab le. | |||||
264 | Util.1=\n\ n** BEGIN NESTED EXC EPTION ** \n\n | |||||
265 | Util.2=\nM ESSAGE: | |||||
266 | Util.3=\n\ nSTACKTRAC E:\n\n | |||||
267 | Util.4=\n\ n** END NE STED EXCEP TION **\n\ n | |||||
268 | MiniAdmin. 0=Conectio n can not be null. | |||||
269 | MiniAdmin. 1=MiniAdmi n can only be used w ith MySQL connection s | |||||
270 | NamedPipeS ocketFacto ry.2=Can n ot specify NULL or e mpty value for prope rty ' | |||||
271 | NamedPipeS ocketFacto ry.3='. | |||||
272 | NamedPipeS ocketFacto ry.4=Named pipe path can not b e null or empty | |||||
273 | MysqlIO.1= Unexpected end of in put stream | |||||
274 | MysqlIO.2= Reading pa cket of le ngth | |||||
275 | MysqlIO.3= \nPacket h eader:\n | |||||
276 | MysqlIO.4= readPacket () payload :\n | |||||
277 | MysqlIO.8= Slow query explain r esults for ' | |||||
278 | MysqlIO.9= ' :\n\n | |||||
279 | MysqlIO.10 =\ message from serv er: " | |||||
280 | MysqlIO.15 =SSL Conne ction requ ired, but not suppor ted by ser ver. | |||||
281 | MysqlIO.17 =Attempt t o close st reaming re sult set | |||||
282 | MysqlIO.18 =\ when no streaming result s et was reg istered. T his is an internal e rror. | |||||
283 | MysqlIO.19 =Attempt t o close st reaming re sult set | |||||
284 | MysqlIO.20 =\ that wa s not regi stered. | |||||
285 | MysqlIO.21 =\ Only on e streamin g result s et may be open and i n use per- connection . Ensure t hat you ha ve called .close() o n | |||||
286 | MysqlIO.22 =\ any act ive result sets befo re attempt ing more q ueries. | |||||
287 | MysqlIO.23 =Can not u se streami ng results with mult iple resul t statemen ts | |||||
288 | MysqlIO.25 =\ ... (tr uncated) | |||||
289 | MysqlIO.Sl owQuery=Sl ow query ( exceeded { 0} {1}, du ration: {2 } {1}): | |||||
290 | MysqlIO.Se rverSlowQu ery=The se rver proce ssing the query has indicated that the q uery was m arked "slo w". | |||||
291 | Nanosecond s=ns | |||||
292 | Millisecon ds=ms | |||||
293 | MysqlIO.28 =Not issui ng EXPLAIN for query of size > | |||||
294 | MysqlIO.29 =\ bytes. | |||||
295 | MysqlIO.33 =The follo wing query was execu ted with a bad index , use 'EXP LAIN' for more detai ls: | |||||
296 | MysqlIO.35 =The follo wing query was execu ted using no index, use 'EXPLA IN' for mo re details : | |||||
297 | MysqlIO.36 =\n\nLarge packet du mp truncat ed at | |||||
298 | MysqlIO.37 =\ bytes. | |||||
299 | MysqlIO.39 =Streaming result se t | |||||
300 | MysqlIO.40 =\ is stil l active. | |||||
301 | MysqlIO.41 =\ No stat ements may be issued when any streaming result set s are open and in us e on a giv en connect ion. | |||||
302 | MysqlIO.42 =\ Ensure that you h ave called .close() on any act ive stream ing result sets befo re attempt ing more q ueries. | |||||
303 | MysqlIO.43 =Unexpecte d end of i nput strea m | |||||
304 | MysqlIO.44 =Reading r eusable pa cket of le ngth | |||||
305 | MysqlIO.45 =\nPacket header:\n | |||||
306 | MysqlIO.46 =reuseAndR eadPacket( ) payload: \n | |||||
307 | MysqlIO.47 =Unexpecte d end of i nput strea m | |||||
308 | MysqlIO.48 =Unexpecte d end of i nput strea m | |||||
309 | MysqlIO.49 =Packets r eceived ou t of order | |||||
310 | MysqlIO.50 =Short rea d from ser ver, expec ted | |||||
311 | MysqlIO.51 =\ bytes, received o nly | |||||
312 | MysqlIO.53 =Packets r eceived ou t of order | |||||
313 | MysqlIO.54 =Short rea d from ser ver, expec ted | |||||
314 | MysqlIO.55 =\ bytes, received o nly | |||||
315 | MysqlIO.57 =send() co mpressed p acket:\n | |||||
316 | MysqlIO.58 =\n\nOrigi nal packet (uncompre ssed):\n | |||||
317 | MysqlIO.59 =send() pa cket paylo ad:\n | |||||
318 | MysqlIO.60 =Unable to open file | |||||
319 | MysqlIO.63 =for 'LOAD DATA LOCA L INFILE' command. | |||||
320 | MysqlIO.64 =Due to un derlying I OException : | |||||
321 | MysqlIO.65 =Unable to close loc al file du ring LOAD DATA LOCAL INFILE co mmand | |||||
322 | MysqlIO.68 =\ message from serv er: " | |||||
323 | MysqlIO.70 =Unknown c olumn | |||||
324 | MysqlIO.72 =\ message from serv er: " | |||||
325 | MysqlIO.75 =No name s pecified f or socket factory | |||||
326 | MysqlIO.76 =Could not create so cket facto ry ' | |||||
327 | MysqlIO.77 =' due to underlying exception : | |||||
328 | MysqlIO.79 =Unexpecte d end of i nput strea m | |||||
329 | MysqlIO.80 =Unexpecte d end of i nput strea m | |||||
330 | MysqlIO.81 =Unexpecte d end of i nput strea m | |||||
331 | MysqlIO.82 =Unexpecte d end of i nput strea m | |||||
332 | MysqlIO.83 =Packets r eceived ou t of order | |||||
333 | MysqlIO.84 =Packets r eceived ou t of order | |||||
334 | MysqlIO.85 =Unexpecte d end of i nput strea m | |||||
335 | MysqlIO.86 =Unexpecte d end of i nput strea m | |||||
336 | MysqlIO.87 =Unexpecte d end of i nput strea m | |||||
337 | MysqlIO.88 =Packets r eceived ou t of order | |||||
338 | MysqlIO.89 =Packets r eceived ou t of order | |||||
339 | MysqlIO.91 =Failed to create me ssage dige st 'SHA-1' for authe ntication. | |||||
340 | MysqlIO.92 =\ You mus t use a JD K that sup ports JCE to be able to use se cure conne ction auth entication | |||||
341 | MysqlIO.93 =Failed to create me ssage dige st 'SHA-1' for authe ntication. | |||||
342 | MysqlIO.94 =\ You mus t use a JD K that sup ports JCE to be able to use se cure conne ction auth entication | |||||
343 | MysqlIO.95 =Failed to create me ssage dige st 'SHA-1' for authe ntication. | |||||
344 | MysqlIO.96 =\ You mus t use a JD K that sup ports JCE to be able to use se cure conne ction auth entication | |||||
345 | MysqlIO.97 =Unknown t ype ' | |||||
346 | MysqlIO.98 =\ in colu mn | |||||
347 | MysqlIO.99 =\ of | |||||
348 | MysqlIO.10 0=\ in bin ary-encode d result s et. | |||||
349 | MysqlIO.10 2=, underl ying cause : | |||||
350 | MysqlIO.EO F=Can not read respo nse from s erver. Exp ected to r ead {0} by tes, read {1} bytes before con nection wa s unexpect edly lost. | |||||
351 | MysqlIO.No InnoDBStat usFound=No InnoDB st atus outpu t returned by server . | |||||
352 | MysqlIO.In noDBStatus Failed=Cou ldn't retr ieve InnoD B status d ue to unde rlying exc eption: | |||||
353 | MysqlIO.Lo adDataLoca lNotAllowe d=Server a sked for s tream in r esponse to LOAD DATA LOCAL INF ILE but fu nctionalit y is disab led at cli ent by 'al lowLoadLoc alInfile' being set to 'false' . | |||||
354 | NotImpleme nted.0=Fea ture not i mplemented | |||||
355 | PreparedSt atement.0= SQL String can not b e NULL | |||||
356 | PreparedSt atement.1= SQL String can not b e NULL | |||||
357 | PreparedSt atement.2= Parameter index out of range ( | |||||
358 | PreparedSt atement.3= \ > | |||||
359 | PreparedSt atement.4= ) | |||||
360 | PreparedSt atement.16 =Unknown T ypes value | |||||
361 | PreparedSt atement.17 =Cannot co nvert | |||||
362 | PreparedSt atement.18 =\ to SQL type reque sted due t o | |||||
363 | PreparedSt atement.19 =\ - | |||||
364 | PreparedSt atement.20 =Connectio n is read- only. | |||||
365 | PreparedSt atement.21 =Queries l eading to data modif ication ar e not allo wed | |||||
366 | PreparedSt atement.25 =Connectio n is read- only. | |||||
367 | PreparedSt atement.26 =Queries l eading to data modif ication ar e not allo wed | |||||
368 | PreparedSt atement.32 =Unsupport ed charact er encodin g ' | |||||
369 | PreparedSt atement.33 =' | |||||
370 | PreparedSt atement.34 =Connectio n is read- only. | |||||
371 | PreparedSt atement.35 =Queries l eading to data modif ication ar e not allo wed | |||||
372 | PreparedSt atement.37 =Can not i ssue execu teUpdate() for SELEC Ts | |||||
373 | PreparedSt atement.40 =No value specified for parame ter | |||||
374 | PreparedSt atement.43 =PreparedS tatement c reated, bu t used 1 o r fewer ti mes. It is more effi cient to p repare sta tements on ce, and re -use them many times | |||||
375 | PreparedSt atement.48 =PreparedS tatement h as been cl osed. No f urther ope rations al lowed. | |||||
376 | PreparedSt atement.49 =Parameter index out of range ( | |||||
377 | PreparedSt atement.50 =\ < 1 ). | |||||
378 | PreparedSt atement.51 =Parameter index out of range ( | |||||
379 | PreparedSt atement.52 =\ > numbe r of param eters, whi ch is | |||||
380 | PreparedSt atement.53 =). | |||||
381 | PreparedSt atement.54 =Invalid a rgument va lue: | |||||
382 | PreparedSt atement.55 =Error rea ding from InputStrea m | |||||
383 | PreparedSt atement.56 =Error rea ding from InputStrea m | |||||
384 | PreparedSt atement.61 =SQL Strin g can not be NULL | |||||
385 | ServerPrep aredStatem ent.2=Conn ection is read-only. | |||||
386 | ServerPrep aredStatem ent.3=Quer ies leadin g to data modificati on are not allowed | |||||
387 | ServerPrep aredStatem ent.6=\ un able to ma terialize as string due to und erlying SQ LException : | |||||
388 | ServerPrep aredStatem ent.7=Not supported for server -side prep ared state ments. | |||||
389 | ServerPrep aredStatem ent.8=No p arameters defined du ring prepa reCall() | |||||
390 | ServerPrep aredStatem ent.9=Para meter inde x out of b ounds. | |||||
391 | ServerPrep aredStatem ent.10=\ i s not betw een valid values of 1 and | |||||
392 | ServerPrep aredStatem ent.11=Dri ver can no t re-execu te prepare d statemen t when a p arameter h as been ch anged | |||||
393 | ServerPrep aredStatem ent.12=fro m a stream ing type t o an intri nsic data type witho ut calling clearPara meters() f irst. | |||||
394 | ServerPrep aredStatem ent.13=Sta tement par ameter | |||||
395 | ServerPrep aredStatem ent.14=\ n ot set. | |||||
396 | ServerPrep aredStatem ent.15=Slo w query (e xceeded | |||||
397 | ServerPrep aredStatem ent.15a=\ ms., durat ion:\ | |||||
398 | ServerPrep aredStatem ent.16=\ m s): | |||||
399 | ServerPrep aredStatem ent.18=Unk nown LONG DATA type ' | |||||
400 | ServerPrep aredStatem ent.22=Uns upported c haracter e ncoding ' | |||||
401 | ServerPrep aredStatem ent.24=Err or while r eading bin ary stream : | |||||
402 | ServerPrep aredStatem ent.25=Err or while r eading bin ary stream : | |||||
403 | ByteArrayB uffer.0=By teArrayBuf fer has no NIO buffe rs | |||||
404 | ByteArrayB uffer.1=Un supported character encoding ' | |||||
405 | ByteArrayB uffer.2=Bu ffer lengt h is less then "expe ctedLength " value. | |||||
406 | AssertionF ailedExcep tion.0=ASS ERT FAILS: Exception | |||||
407 | AssertionF ailedExcep tion.1=\ t hat should not be th rown, was thrown | |||||
408 | NotUpdatab le.0=Resul t Set not updatable. | |||||
409 | NotUpdatab le.1=This result set must come from a st atement | |||||
410 | NotUpdatab le.2=that was create d with a r esult set type of Re sultSet.CO NCUR_UPDAT ABLE, | |||||
411 | NotUpdatab le.3=the q uery must select onl y one tabl e, can not use funct ions and m ust | |||||
412 | NotUpdatab le.4=selec t all prim ary keys f rom that t able. See the JDBC 2 .1 API Spe cification , | |||||
413 | NotUpdatab le.5=secti on 5.6 for more deta ils. | |||||
414 | NotUpdatab leReason.0 =Result Se t not upda table (ref erences mo re than on e table). | |||||
415 | NotUpdatab leReason.1 =Result Se t not upda table (ref erences mo re than on e database ). | |||||
416 | NotUpdatab leReason.2 =Result Se t not upda table (ref erences no tables). | |||||
417 | NotUpdatab leReason.3 =Result Se t not upda table (ref erences co mputed val ues or doe sn't refer ence any c olumns or tables). | |||||
418 | NotUpdatab leReason.4 =Result Se t not upda table (ref erences no primary k eys). | |||||
419 | NotUpdatab leReason.5 =Result Se t not upda table (ref erenced ta ble has no primary k eys). | |||||
420 | NotUpdatab leReason.6 =Result Se t not upda table (ref erences un known prim ary key {0 }). | |||||
421 | NotUpdatab leReason.7 =Result Se t not upda table (doe s not refe rence all primary ke ys). | |||||
422 | ||||||
423 | JDBC4Conne ction.Clie ntInfoNotI mplemented =Configure d clientIn foProvider class ''{ 0}'' does not implem ent com.my sql.jdbc.J DBC4Client InfoProvid er. | |||||
424 | ||||||
425 | InvalidLoa dBalanceSt rategy=Inv alid load balancing strategy ' '{0}''. | |||||
426 | Connection .BadValueI nServerVar iables=Inv alid value ''{1}'' f or server variable n amed ''{0} '', fallin g back to sane defau lt of ''{2 }''. | |||||
427 | LoadBalanc ingConnect ionProxy.b adValueFor RetriesAll Down=Bad v alue ''{0} '' for pro perty "ret riesAllDow n". | |||||
428 | LoadBalanc ingConnect ionProxy.b adValueFor LoadBalanc eBlacklist Timeout=Ba d value '' {0}'' for property " loadBalanc eBlacklist Timeout". | |||||
429 | LoadBalanc ingConnect ionProxy.b adValueFor LoadBalanc eEnableJMX =Bad value ''{0}'' f or propert y "loadBal anceEnable JMX". | |||||
430 | LoadBalanc ingConnect ionProxy.b adValueFor LoadBalanc eAutoCommi tStatement Threshold= Invalid nu meric valu e ''{0}'' for proper ty "loadBa lanceAutoC ommitState mentThresh old". | |||||
431 | LoadBalanc ingConnect ionProxy.b adValueFor LoadBalanc eAutoCommi tStatement Regex=Bad value ''{0 }'' for pr operty "lo adBalanceA utoCommitS tatementRe gex". | |||||
432 | ||||||
433 | Connection .UnableToC onnect=Cou ld not cre ate connec tion to da tabase ser ver. | |||||
434 | Connection .UnableToC onnectWith Retries=Co uld not cr eate conne ction to d atabase se rver. \ | |||||
435 | Attempted reconnect {0} times. Giving up . | |||||
436 | Connection .Unexpecte dException =Unexpecte d exceptio n encounte red during query. | |||||
437 | Connection .Unhandled ExceptionD uringShutd own=Unexpe cted excep tion durin g server s hutdown. | |||||
438 | ||||||
439 | # | |||||
440 | # Connecti onProperty Categorie s | |||||
441 | # | |||||
442 | ||||||
443 | Connection Properties .categoryC onnectionA uthenticat ion=Connec tion/Authe ntication | |||||
444 | Connection Properties .categoryN etworking= Networking | |||||
445 | Connection Properties .categoryD ebuggingPr ofiling=De bugging/Pr ofiling | |||||
446 | Connection Properties .categorry HA=High Av ailability and Clust ering | |||||
447 | Connection Properties .categoryM isc=Miscel laneous | |||||
448 | Connection Properties .categoryP erformance =Performan ce Extensi ons | |||||
449 | Connection Properties .categoryS ecurity=Se curity | |||||
450 | ||||||
451 | # | |||||
452 | # Connecti onProperty Descripti ons | |||||
453 | # | |||||
454 | ||||||
455 | Connection Properties .loadDataL ocal=Shoul d the driv er allow u se of 'LOA D DATA LOC AL INFILE. ..' (defau lts to 'tr ue'). | |||||
456 | Connection Properties .allowMult iQueries=A llow the u se of ';' to delimit multiple queries du ring one s tatement ( true/false ), default s to 'fals e', and do es not aff ect the ad dBatch() a nd execute Batch() me thods, whi ch instead rely on r ewriteBatc hStatement s. | |||||
457 | Connection Properties .allowNANa ndINF=Shou ld the dri ver allow NaN or +/- INF value s in Prepa redStateme nt.setDoub le()? | |||||
458 | Connection Properties .allowUrlI nLoadLocal =Should th e driver a llow URLs in 'LOAD D ATA LOCAL INFILE' st atements? | |||||
459 | Connection Properties .alwaysSen dSetIsolat ion=Should the drive r always c ommunicate with the database w hen Connec tion.setTr ansactionI solation() is called ? If set t o false, t he driver will only communicat e with the database when the r equested t ransaction isolation is differ ent than t he whichev er is newe r, the las t value th at was set via Conne ction.setT ransaction Isolation( ), or the value that was read from the s erver when the conne ction was establishe d. Note t hat useLoc alSessionS tate=true will force the same behavior a s alwaysSe ndSetIsola tion=false , regardle ss of how alwaysSend SetIsolati on is set. | |||||
460 | Connection Properties .autoClose PstmtStrea ms=Should the driver automatic ally call .close() o n streams/ readers pa ssed as ar guments vi a set*() m ethods? | |||||
461 | Connection Properties .autoDeser ialize=Sho uld the dr iver autom atically d etect and de-seriali ze objects stored in BLOB fiel ds? | |||||
462 | Connection Properties .autoGener ateTestcas eScript=Sh ould the d river dump the SQL i t is execu ting, incl uding serv er-side pr epared sta tements to STDERR? | |||||
463 | Connection Properties .autoRecon nect=Shoul d the driv er try to re-establi sh stale a nd/or dead connectio ns? If ena bled the d river will throw an exception for a quer ies issued on a stal e or dead connection , which be long to th e current transactio n, but wil l attempt reconnect before the next quer y issued o n the conn ection in a new tran saction. T he use of this featu re is not recommende d, because it has si de effects related t o session state and data consi stency whe n applicat ions don't handle SQ LException s properly , and is o nly design ed to be u sed when y ou are una ble to con figure you r applicat ion to han dle SQLExc eptions re sulting fr om dead an d stale co nnections properly. Alternativ ely, as a last optio n, investi gate setti ng the MyS QL server variable " wait_timeo ut" to a h igh value, rather th an the def ault of 8 hours. | |||||
464 | Connection Properties .autoRecon nectForPoo ls=Use a r econnectio n strategy appropria te for con nection po ols (defau lts to 'fa lse') | |||||
465 | Connection Properties .autoSlowL og=Instead of using slowQueryT hreshold* to determi ne if a qu ery is slo w enough t o be logge d, maintai n statisti cs that al low the dr iver to de termine qu eries that are outsi de the 99t h percenti le? | |||||
466 | Connection Properties .blobsAreS trings=Sho uld the dr iver alway s treat BL OBs as Str ings - spe cifically to work ar ound dubio us metadat a returned by the se rver for G ROUP BY cl auses? | |||||
467 | Connection Properties .functions NeverRetur nBlobs=Sho uld the dr iver alway s treat da ta from fu nctions re turning BL OBs as Str ings - spe cifically to work ar ound dubio us metadat a returned by the se rver for G ROUP BY cl auses? | |||||
468 | Connection Properties .blobSendC hunkSize=C hunk to us e when sen ding BLOB/ CLOBs via ServerPrep aredStatem ents | |||||
469 | Connection Properties .cacheCall ableStatem ents=Shoul d the driv er cache t he parsing stage of CallableSt atements | |||||
470 | Connection Properties .cachePrep Stmts=Shou ld the dri ver cache the parsin g stage of PreparedS tatements of client- side prepa red statem ents, the "check" fo r suitabil ity of ser ver-side p repared an d server-s ide prepar ed stateme nts themse lves? | |||||
471 | Connection Properties .cacheRSMe tadata=Sho uld the dr iver cache ResultSet MetaData f or Stateme nts and Pr eparedStat ements? (R eq. JDK-1. 4+, true/f alse, defa ult 'false ') | |||||
472 | Connection Properties .cacheServ erConfigur ation=Shou ld the dri ver cache the result s of 'SHOW VARIABLES ' and 'SHO W COLLATIO N' on a pe r-URL basi s? | |||||
473 | Connection Properties .callableS tmtCacheSi ze=If 'cac heCallable Stmts' is enabled, h ow many ca llable sta tements sh ould be ca ched? | |||||
474 | Connection Properties .capitaliz eTypeNames =Capitaliz e type nam es in Data baseMetaDa ta? (usual ly only us eful when using WebO bjects, tr ue/false, defaults t o 'false') | |||||
475 | Connection Properties .character Encoding=I f 'useUnic ode' is se t to true, what char acter enco ding shoul d the driv er use whe n dealing with strin gs? (defau lts is to 'autodetec t') | |||||
476 | Connection Properties .character SetResults =Character set to te ll the ser ver to ret urn result s as. | |||||
477 | Connection Properties .clientInf oProvider= The name o f a class that imple ments the com.mysql. jdbc.JDBC4 ClientInfo Provider i nterface i n order to support J DBC-4.0's Connection .get/setCl ientInfo() methods | |||||
478 | Connection Properties .clobberSt reamingRes ults=This will cause a 'stream ing' Resul tSet to be automatic ally close d, and any outstandi ng data st ill stream ing from t he server to be disc arded if a nother que ry is exec uted befor e all the data has b een read f rom the se rver. | |||||
479 | Connection Properties .clobChara cterEncodi ng=The cha racter enc oding to u se for sen ding and r etrieving TEXT, MEDI UMTEXT and LONGTEXT values ins tead of th e configur ed connect ion charac terEncodin g | |||||
480 | Connection Properties .compensat eOnDuplica teKeyUpdat eCounts=Sh ould the d river comp ensate for the updat e counts o f "ON DUPL ICATE KEY" INSERT st atements ( 2 = 1, 0 = 1) when u sing prepa red statem ents? | |||||
481 | Connection Properties .connectio nCollation =If set, t ells the s erver to u se this co llation vi a 'set col lation_con nection' | |||||
482 | Connection Properties .connectio nLifecycle Intercepto rs=A comma -delimited list of c lasses tha t implemen t "com.mys ql.jdbc.Co nnectionLi fecycleInt erceptor" that shoul d notified of connec tion lifec ycle event s (creatio n, destruc tion, comm it, rollba ck, setCat alog and s etAutoComm it) and po tentially alter the execution of these c ommands. C onnectionL ifecycleIn terceptors are "stac kable", mo re than on e intercep tor may be specified via the c onfigurati on propert y as a com ma-delimit ed list, w ith the in terceptors executed in order f rom left t o right. | |||||
483 | Connection Properties .connectTi meout=Time out for so cket conne ct (in mil liseconds) , with 0 b eing no ti meout. Onl y works on JDK-1.4 o r newer. D efaults to '0'. | |||||
484 | Connection Properties .continueB atchOnErro r=Should t he driver continue p rocessing batch comm ands if on e statemen t fails. T he JDBC sp ec allows either way (defaults to 'true' ). | |||||
485 | Connection Properties .createDat abaseIfNot Exist=Crea tes the da tabase giv en in the URL if it doesn't ye t exist. A ssumes the configure d user has permissio ns to crea te databas es. | |||||
486 | Connection Properties .defaultFe tchSize=Th e driver w ill call s etFetchSiz e(n) with this value on all ne wly-create d Statemen ts | |||||
487 | Connection Properties .useServer PrepStmts= Use server -side prep ared state ments if t he server supports t hem? | |||||
488 | Connection Properties .dontTrack OpenResour ces=The JD BC specifi cation req uires the driver to automatica lly track and close resources, however i f your app lication d oesn't do a good job of explic itly calli ng close() on statem ents or re sult sets, this can cause memo ry leakage . Setting this prope rty to tru e relaxes this const raint, and can be mo re memory efficient for some a pplication s. | |||||
489 | Connection Properties .dumpQueri esOnExcept ion=Should the drive r dump the contents of the que ry sent to the serve r in the m essage for SQLExcept ions? | |||||
490 | Connection Properties .dynamicCa lendars=Sh ould the d river retr ieve the d efault cal endar when required, or cache it per con nection/se ssion? | |||||
491 | Connection Properties .eliseSetA utoCommit= If using M ySQL-4.1 o r newer, s hould the driver onl y issue 's et autocom mit=n' que ries when the server 's state d oesn't mat ch the req uested sta te by Conn ection.set AutoCommit (boolean)? | |||||
492 | Connection Properties .emptyStri ngsConvert ToZero=Sho uld the dr iver allow conversio ns from em pty string fields to numeric v alues of ' 0'? | |||||
493 | Connection Properties .emulateLo cators=Sho uld the dr iver emula te java.sq l.Blobs wi th locator s? With th is feature enabled, the driver will dela y loading the actual Blob data until the one of th e retrieva l methods (getInputS tream(), g etBytes(), and so fo rth) on th e blob dat a stream h as been ac cessed. Fo r this to work, you must use a column al ias with t he value o f the colu mn to the actual nam e of the B lob. The f eature als o has the following restrictio ns: The SE LECT that created th e result s et must re ference on ly one tab le, the ta ble must h ave a prim ary key; t he SELECT must alias the origi nal blob c olumn name , specifie d as a str ing, to an alternate name; the SELECT mu st cover a ll columns that make up the pr imary key. | |||||
494 | Connection Properties .emulateUn supportedP stmts=Shou ld the dri ver detect prepared statements that are not suppor ted by the server, a nd replace them with client-si de emulate d versions ? | |||||
495 | Connection Properties .enablePac ketDebug=W hen enable d, a ring- buffer of 'packetDeb ugBufferSi ze' packet s will be kept, and dumped whe n exceptio ns are thr own in key areas in the driver 's code | |||||
496 | Connection Properties .enableQue ryTimeouts =When enab led, query timeouts set via St atement.se tQueryTime out() use a shared j ava.util.T imer insta nce for sc heduling. Even if th e timeout doesn't ex pire befor e the quer y is proce ssed, ther e will be memory use d by the T imerTask f or the giv en timeout which won 't be recl aimed unti l the time the timeo ut would h ave expire d if it ha dn't been cancelled by the dri ver. High- load envir onments mi ght want t o consider disabling this func tionality. | |||||
497 | Connection Properties .explainSl owQueries= If 'logSlo wQueries' is enabled , should t he driver automatica lly issue an 'EXPLAI N' on the server and send the results to the confi gured log at a WARN level? | |||||
498 | Connection Properties .failoverR eadOnly=Wh en failing over in a utoReconne ct mode, s hould the connection be set to 'read-onl y'? | |||||
499 | Connection Properties .gatherPer fMetrics=S hould the driver gat her perfor mance metr ics, and r eport them via the c onfigured logger eve ry 'report MetricsInt ervalMilli s' millise conds? | |||||
500 | Connection Properties .generateS impleParam eterMetada ta=Should the driver generate simplified parameter metadata for Prepar edStatemen ts when no metadata is availab le either because th e server c ouldn't su pport prep aring the statement, or server -side prep ared state ments are disabled? | |||||
501 | Connection Properties .holdRSOpe nOverStmtC lose=Shoul d the driv er close r esult sets on Statem ent.close( ) as requi red by the JDBC spec ification? | |||||
502 | Connection Properties .ignoreNon TxTables=I gnore non- transactio nal table warning fo r rollback ? (default s to 'fals e'). | |||||
503 | Connection Properties .includeIn nodbStatus InDeadlock Exceptions =Include t he output of "SHOW E NGINE INNO DB STATUS" in except ion messag es when de adlock exc eptions ar e detected ? | |||||
504 | Connection Properties .includeTh readDumpIn DeadlockEx ceptions=I nclude a c urrent Jav a thread d ump in exc eption mes sages when deadlock exceptions are detec ted? | |||||
505 | Connection Properties .includeTh readNamesA sStatement Comment=In clude the name of th e current thread as a comment visible in "SHOW PRO CESSLIST", or in Inn odb deadlo ck dumps, useful in correlatio n with "in cludeInnod bStatusInD eadlockExc eptions=tr ue" and "i ncludeThre adDumpInDe adlockExce ptions=tru e". | |||||
506 | Connection Properties .initialTi meout=If a utoReconne ct is enab led, the i nitial tim e to wait between re -connect a ttempts (i n seconds, defaults to '2'). | |||||
507 | Connection Properties .interacti veClient=S et the CLI ENT_INTERA CTIVE flag , which te lls MySQL to timeout connectio ns based o n INTERACT IVE_TIMEOU T instead of WAIT_TI MEOUT | |||||
508 | Connection Properties .jdbcCompl iantTrunca tion=Shoul d the driv er throw j ava.sql.Da taTruncati on excepti ons when d ata is tru ncated as is require d by the J DBC specif ication wh en connect ed to a se rver that supports w arnings (M ySQL 4.1.0 and newer )? This pr operty has no effect if the se rver sql-m ode includ es STRICT_ TRANS_TABL ES. | |||||
509 | Connection Properties .largeRowS izeThresho ld=What si ze result set row sh ould the J DBC driver consider "large", a nd thus us e a more m emory-effi cient way of represe nting the row intern ally? | |||||
510 | Connection Properties .loadBalan ceStrategy =If using a load-bal anced conn ection to connect to SQL nodes in a MySQ L Cluster/ NDB config uration (b y using th e URL pref ix "jdbc:m ysql:loadb alance://" ), which l oad balanc ing algori thm should the drive r use: (1) "random" - the driv er will pi ck a rando m host for each requ est. This tends to w ork better than roun d-robin, a s the rand omness wil l somewhat account f or spreadi ng loads w here reque sts vary i n response time, whi le round-r obin can s ometimes l ead to ove rloaded no des if the re are var iations in response times acro ss the wor kload. (2) "bestResp onseTime" - the driv er will ro ute the re quest to t he host th at had the best resp onse time for the pr evious tra nsaction. | |||||
511 | Connection Properties .loadBalan ceBlacklis tTimeout=T ime in mil liseconds between ch ecks of se rvers whic h are unav ailable, b y controll ing how lo ng a serve r lives in the globa l blacklis t. | |||||
512 | Connection Properties .loadBalan cePingTime out=Time i n millisec onds to wa it for pin g response from each of load-b alanced ph ysical con nections w hen using load-balan ced Connec tion. | |||||
513 | Connection Properties .loadBalan ceValidate Connection OnSwapServ er=Should the load-b alanced Co nnection e xplicitly check whet her the co nnection i s live whe n swapping to a new physical c onnection at commit/ rollback? | |||||
514 | Connection Properties .loadBalan ceConnecti onGroup=Lo gical grou p of load- balanced c onnections within a classloade r, used to manage di fferent gr oups indep endently. If not sp ecified, l ive manage ment of lo ad-balance d connecti ons is dis abled. | |||||
515 | Connection Properties .loadBalan ceExceptio nChecker=F ully-quali fied class name of c ustom exce ption chec ker. The class must implement com.mysql .jdbc.Load BalanceExc eptionChec ker interf ace, and i s used to inspect SQ LException s and dete rmine whet her they s hould trig ger fail-o ver to ano ther host in a load- balanced d eployment. | |||||
516 | Connection Properties .loadBalan ceSQLState Failover=C omma-delim ited list of SQLStat e codes us ed by defa ult load-b alanced ex ception ch ecker to d etermine w hether a g iven SQLEx ception sh ould trigg er failove r. The SQ LState of a given SQ LException is evalua ted to det ermine whe ther it be gins with any value in the com ma-delimit ed list. | |||||
517 | Connection Properties .loadBalan ceSQLExcep tionSubcla ssFailover =Comma-del imited lis t of class es/interfa ces used b y default load-balan ced except ion checke r to deter mine wheth er a given SQLExcept ion should trigger f ailover. The compar ison is do ne using C lass.isIns tance(SQLE xception) using the thrown SQL Exception. | |||||
518 | Connection Properties .loadBalan ceEnableJM X=Enables JMX-based management of load-b alanced co nnection g roups, inc luding liv e addition /removal o f hosts fr om load-ba lancing po ol. | |||||
519 | Connection Properties .loadBalan ceAutoComm itStatemen tThreshold =When auto -commit is enabled, the number of statem ents which should be executed before tri ggering lo ad-balanci ng to reba lance. De fault valu e of 0 cau ses load-b alanced co nnections to only re balance wh en excepti ons are en countered, or auto-c ommit is d isabled an d transact ions are e xplicitly committed or rolled back. | |||||
520 | Connection Properties .loadBalan ceAutoComm itStatemen tRegex=Whe n load-bal ancing is enabled fo r auto-com mit statem ents (via loadBalanc eAutoCommi tStatement Threshold) , the stat ement coun ter will o nly increm ent when t he SQL mat ches the r egular exp ression. By default , every st atement is sued match es. | |||||
521 | ||||||
522 | Connection Properties .localSock etAddress= Hostname o r IP addre ss given t o explicit ly configu re the int erface tha t the driv er will bi nd the cli ent side o f the TCP/ IP connect ion to whe n connecti ng. | |||||
523 | Connection Properties .locatorFe tchBufferS ize=If 'em ulateLocat ors' is co nfigured t o 'true', what size buffer sho uld be use d when fet ching BLOB data for getBinaryI nputStream ? | |||||
524 | Connection Properties .logger=Th e name of a class th at impleme nts \"{0}\ " that wi ll be used to log me ssages to. (default is \"{1}\" , which lo gs to STDE RR) | |||||
525 | Connection Properties .logSlowQu eries=Shou ld queries that take longer th an 'slowQu eryThresho ldMillis' be logged? | |||||
526 | Connection Properties .logXaComm ands=Shoul d the driv er log XA commands s ent by Mys qlXaConnec tion to th e server, at the DEB UG level o f logging? | |||||
527 | Connection Properties .maintainT imeStats=S hould the driver mai ntain vari ous intern al timers to enable idle time calculatio ns as well as more v erbose err or message s when the connectio n to the s erver fail s? Setting this prop erty to fa lse remove s at least two calls to System .getCurren tTimeMilli s() per qu ery. | |||||
528 | Connection Properties .maxQueryS izeToLog=C ontrols th e maximum length/siz e of a que ry that wi ll get log ged when p rofiling o r tracing | |||||
529 | Connection Properties .maxReconn ects=Maxim um number of reconne cts to att empt if au toReconnec t is true, default i s '3'. | |||||
530 | Connection Properties .maxRows=T he maximum number of rows to r eturn (0, the defaul t means re turn all r ows). | |||||
531 | Connection Properties .allVersio ns=all ver sions | |||||
532 | Connection Properties .metadataC acheSize=T he number of queries to cache ResultSetM etadata fo r if cache ResultSetM etaData is set to 't rue' (defa ult 50) | |||||
533 | Connection Properties .netTimeou tForStream ingResults =What valu e should t he driver automatica lly set th e server s etting 'ne t_write_ti meout' to when the s treaming r esult sets feature i s in use? (value has unit of s econds, th e value '0 ' means th e driver w ill not tr y and adju st this va lue) | |||||
534 | Connection Properties .noAccessT oProcedure Bodies=Whe n determin ing proced ure parame ter types for Callab leStatemen ts, and th e connecte d user can 't access procedure bodies thr ough "SHOW CREATE PR OCEDURE" o r select o n mysql.pr oc should the driver instead c reate basi c metadata (all para meters rep orted as I NOUT VARCH ARs) inste ad of thro wing an ex ception? | |||||
535 | Connection Properties .noDatetim eStringSyn c=Don't en sure that ResultSet. getDatetim eType().to String().e quals(Resu ltSet.getS tring()) | |||||
536 | Connection Properties .noTzConve rsionForTi meType=Don 't convert TIME valu es using t he server timezone i f 'useTime zone'='tru e' | |||||
537 | Connection Properties .nullCatal ogMeansCur rent=When DatabaseMe tadataMeth ods ask fo r a 'catal og' parame ter, does the value null mean use the cu rrent cata log? (this is not JD BC-complia nt, but fo llows lega cy behavio r from ear lier versi ons of the driver) | |||||
538 | Connection Properties .nullNameP atternMatc hesAll=Sho uld Databa seMetaData methods t hat accept *pattern parameters treat nul l the same as '%' (t his is not JDBC-comp liant, how ever older versions of the dri ver accept ed this de parture fr om the spe cification ) | |||||
539 | Connection Properties .packetDeb ugBufferSi ze=The max imum numbe r of packe ts to reta in when 'e nablePacke tDebug' is true | |||||
540 | Connection Properties .padCharsW ithSpace=I f a result set colum n has the CHAR type and the va lue does n ot fill th e amount o f characte rs specifi ed in the DDL for th e column, should the driver pa d the rema ining char acters wit h space (f or ANSI co mpliance)? | |||||
541 | Connection Properties .paranoid= Take measu res to pre vent expos ure sensit ive inform ation in e rror messa ges and cl ear data s tructures holding se nsitive da ta when po ssible? (d efaults to 'false') | |||||
542 | Connection Properties .pedantic= Follow the JDBC spec to the le tter. | |||||
543 | Connection Properties .pinGlobal TxToPhysic alConnecti on=When us ing XAConn ections, s hould the driver ens ure that o perations on a given XID are a lways rout ed to the same physi cal connec tion? This allows th e XAConnec tion to su pport "XA START ... JOIN" afte r "XA END" has been called | |||||
544 | Connection Properties .populateI nsertRowWi thDefaultV alues=When using Res ultSets th at are CON CUR_UPDATA BLE, shoul d the driv er pre-pop ulate the "insert" r ow with de fault valu es from th e DDL for the table used in th e query so those val ues are im mediately available for Result Set access ors? This functional ity requir es a call to the dat abase for metadata e ach time a result se t of this type is cr eated. If disabled ( the defaul t), the de fault valu es will be populated by the an internal call to re freshRow() which pul ls back de fault valu es and/or values cha nged by tr iggers. | |||||
545 | Connection Properties .prepStmtC acheSize=I f prepared statement caching i s enabled, how many prepared s tatements should be cached? | |||||
546 | Connection Properties .prepStmtC acheSqlLim it=If prep ared state ment cachi ng is enab led, what' s the larg est SQL th e driver w ill cache the parsin g for? | |||||
547 | Connection Properties .processEs capeCodesF orPrepStmt s=Should t he driver process es cape codes in querie s that are prepared? | |||||
548 | Connection Properties .profilerE ventHandle r=Name of a class th at impleme nts the in terface co m.mysql.jd bc.profile r.Profiler EventHandl er that wi ll be used to handle profiling /tracing e vents. | |||||
549 | Connection Properties .profileSq lDeprecate d=Deprecat ed, use 'p rofileSQL' instead. Trace quer ies and th eir execut ion/fetch times on S TDERR (tru e/false) d efaults to 'false' | |||||
550 | Connection Properties .profileSQ L=Trace qu eries and their exec ution/fetc h times to the confi gured logg er (true/f alse) defa ults to 'f alse' | |||||
551 | Connection Properties .connectio nPropertie sTransform =An implem entation o f com.mysq l.jdbc.Con nectionPro pertiesTra nsform tha t the driv er will us e to modif y URL prop erties pas sed to the driver be fore attem pting a co nnection | |||||
552 | Connection Properties .queriesBe foreRetryM aster=Numb er of quer ies to iss ue before falling ba ck to mast er when fa iled over (when usin g multi-ho st failove r). Whiche ver condit ion is met first, 'q ueriesBefo reRetryMas ter' or 's econdsBefo reRetryMas ter' will cause an a ttempt to be made to reconnect to the ma ster. Defa ults to 50 . | |||||
553 | Connection Properties .reconnect AtTxEnd=If autoRecon nect is se t to true, should th e driver a ttempt rec onnections at the en d of every transacti on? | |||||
554 | Connection Properties .relaxAuto Commit=If the versio n of MySQL the drive r connects to does n ot support transacti ons, still allow cal ls to comm it(), roll back() and setAutoCo mmit() (tr ue/false, defaults t o 'false') ? | |||||
555 | Connection Properties .reportMet ricsInterv alMillis=I f 'gatherP erfMetrics ' is enabl ed, how of ten should they be l ogged (in ms)? | |||||
556 | Connection Properties .requireSS L=Require SSL connec tion if us eSSL=true? (defaults to 'false '). | |||||
557 | Connection Properties .resourceI d=A global ly unique name that identifies the resou rce that t his dataso urce or co nnection i s connecte d to, used for XARes ource.isSa meRM() whe n the driv er can't d etermine t his value based on h ostnames u sed in the URL | |||||
558 | Connection Properties .resultSet SizeThresh old=If the usage adv isor is en abled, how many rows should a result set contain b efore the driver war ns that it is suspic iously lar ge? | |||||
559 | Connection Properties .retainSta tementAfte rResultSet Close=Shou ld the dri ver retain the State ment refer ence in a ResultSet after Resu ltSet.clos e() has be en called. This is n ot JDBC-co mpliant af ter JDBC-4 .0. | |||||
560 | Connection Properties .retriesAl lDown=When using loa dbalancing , the numb er of time s the driv er should cycle thro ugh availa ble hosts, attemptin g to conne ct. Betwe en cycles, the drive r will pau se for 250 ms if no s ervers are available . | |||||
561 | Connection Properties .rewriteBa tchedState ments=Shou ld the dri ver use mu ltiqueries (irregard less of th e setting of "allowM ultiQuerie s") as wel l as rewri ting of pr epared sta tements fo r INSERT i nto multi- value inse rts when e xecuteBatc h() is cal led? Notic e that thi s has the potential for SQL in jection if using pla in java.sq l.Statemen ts and you r code doe sn't sanit ize input correctly. Notice th at for pre pared stat ements, se rver-side prepared s tatements can not cu rrently ta ke advanta ge of this rewrite o ption, and that if y ou don't s pecify str eam length s when usi ng Prepare dStatement .set*Strea m(), the d river won' t be able to determi ne the opt imum numbe r of param eters per batch and you might receive an error fro m the driv er that th e resultan t packet i s too larg e. Stateme nt.getGene ratedKeys( ) for thes e rewritte n statemen ts only wo rks when t he entire batch incl udes INSER T statemen ts. | |||||
562 | Connection Properties .rollbackO nPooledClo se=Should the driver issue a r ollback() when the l ogical con nection in a pool is closed? | |||||
563 | Connection Properties .roundRobi nLoadBalan ce=When au toReconnec t is enabl ed, and fa iloverRead only is fa lse, shoul d we pick hosts to c onnect to on a round -robin bas is? | |||||
564 | Connection Properties .runningCT S13=Enable s workarou nds for bu gs in Sun' s JDBC com pliance te stsuite ve rsion 1.3 | |||||
565 | Connection Properties .secondsBe foreRetryM aster=How long shoul d the driv er wait, w hen failed over, bef ore attemp ting | |||||
566 | Connection Properties .secondsBe foreRetryM aster.1=to reconnect to the ma ster serve r? Whichev er conditi on is met first, | |||||
567 | Connection Properties .secondsBe foreRetryM aster.2='q ueriesBefo reRetryMas ter' or 's econdsBefo reRetryMas ter' will cause an | |||||
568 | Connection Properties .secondsBe foreRetryM aster.3=at tempt to b e made to reconnect to the mas ter. Time in seconds , defaults to 30 | |||||
569 | Connection Properties .selfDestr uctOnPingS econdsLife time=If se t to a non -zero valu e, the dri ver will r eport clos e the conn ection and report fa ilure when Connectio n.ping() o r Connecti on.isValid (int) is c alled if t he connnec tion's lif etime exce eds this v alue. | |||||
570 | Connection Properties .selfDestr uctOnPingM axOperatio ns==If set to a non- zero value , the driv er will re port close the conne ction and report fai lure when Connection .ping() or Connectio n.isValid( int) is ca lled if th e connnect ion's coun t of comma nds sent t o the serv er exceeds this valu e. | |||||
571 | Connection Properties .serverTim ezone=Over ride detec tion/mappi ng of time zone. Used when time zone from server doe sn't map t o Java tim ezone | |||||
572 | Connection Properties .sessionVa riables=A comma-sepa rated list of name/v alue pairs to be sen t as SET S ESSION ... to the se rver when the driver connects. | |||||
573 | Connection Properties .slowQuery ThresholdM illis=If ' logSlowQue ries' is e nabled, ho w long sho uld a quer y (in ms) before it is logged as 'slow'? | |||||
574 | Connection Properties .slowQuery ThresholdN anos=If 'u seNanosFor ElapsedTim e' is set to true, a nd this pr operty is set to a n on-zero va lue, the d river will use this threshold (in nanose cond units ) to deter mine if a query was slow. | |||||
575 | Connection Properties .socketFac tory=The n ame of the class tha t the driv er should use for cr eating soc ket connec tions to t he server. This clas s must imp lement the interface 'com.mysq l.jdbc.Soc ketFactory ' and have public no -args cons tructor. | |||||
576 | Connection Properties .socketTim eout=Timeo ut on netw ork socket operation s (0, the default me ans no tim eout). | |||||
577 | Connection Properties .statement Intercepto rs=A comma -delimited list of c lasses tha t implemen t "com.mys ql.jdbc.St atementInt erceptor" that shoul d be place d "in betw een" query execution to influe nce the re sults. Sta tementInte rceptors a re "chaina ble", the results re turned by the "curre nt" interc eptor will be passed on to the next in i n the chai n, from le ft-to-righ t order, a s specifie d in this property. | |||||
578 | Connection Properties .strictFlo atingPoint =Used only in older versions o f complian ce test | |||||
579 | Connection Properties .strictUpd ates=Shoul d the driv er do stri ct checkin g (all pri mary keys selected) of updatab le result sets (true , false, d efaults to 'true')? | |||||
580 | Connection Properties .overrideS upportsIEF =Should th e driver r eturn "tru e" for Dat abaseMetaD ata.suppor tsIntegrit yEnhanceme ntFacility () even if the datab ase doesn' t support it to work around app lications that requi re this me thod to re turn "true " to signa l support of foreign keys, eve n though t he SQL spe cification states th at this fa cility con tains much more than just fore ign key su pport (one such appl ication be ing OpenOf fice)? | |||||
581 | Connection Properties .tcpNoDela y=If conne cting usin g TCP/IP, should the driver se t SO_TCP_N ODELAY (di sabling th e Nagle Al gorithm)? | |||||
582 | Connection Properties .tcpKeepAl ive=If con necting us ing TCP/IP , should t he driver set SO_KEE PALIVE? | |||||
583 | Connection Properties .tcpSoRcvB uf=If conn ecting usi ng TCP/IP, should th e driver s et SO_RCV_ BUF to the given val ue? The de fault valu e of '0', means use the platfo rm default value for this prop erty) | |||||
584 | Connection Properties .tcpSoSndB uf=If conn ecting usi ng TCP/IP, should th e driver s et SO_SND_ BUF to the given val ue? The de fault valu e of '0', means use the platfo rm default value for this prop erty) | |||||
585 | Connection Properties .tcpTraffi cClass=If connecting using TCP /IP, shoul d the driv er set tra ffic class or type-o f-service fields ?Se e the docu mentation for java.n et.Socket. setTraffic Class() fo r more inf ormation. | |||||
586 | Connection Properties .tinyInt1i sBit=Shoul d the driv er treat t he datatyp e TINYINT( 1) as the BIT type ( because th e server s ilently co nverts BIT -> TINYIN T(1) when creating t ables)? | |||||
587 | Connection Properties .traceProt ocol=Shoul d trace-le vel networ k protocol be logged ? | |||||
588 | Connection Properties .treatUtil DateAsTime stamp=Shou ld the dri ver treat java.util. Date as a TIMESTAMP for the pu rposes of PreparedSt atement.se tObject()? | |||||
589 | Connection Properties .transform edBitIsBoo lean=If th e driver c onverts TI NYINT(1) t o a differ ent type, should it use BOOLEA N instead of BIT for future co mpatibilit y with MyS QL-5.0, as MySQL-5.0 has a BIT type? | |||||
590 | Connection Properties .useCompre ssion=Use zlib compr ession whe n communic ating with the serve r (true/fa lse)? Defa ults to 'f alse'. | |||||
591 | Connection Properties .useConfig s=Load the comma-del imited lis t of confi guration p roperties before par sing the U RL or appl ying user- specified properties . These co nfiguratio ns are exp lained in the 'Confi gurations' of the do cumentatio n. | |||||
592 | Connection Properties .useCursor Fetch=If c onnected t o MySQL > 5.0.2, and setFetchS ize() > 0 on a state ment, shou ld that st atement us e cursor-b ased fetch ing to ret rieve rows ? | |||||
593 | Connection Properties .useDynami cCharsetIn fo=Should the driver use a per -connectio n cache of character set infor mation que ried from the server when nece ssary, or use a buil t-in stati c mapping that is mo re efficie nt, but is n't aware of custom character sets or ch aracter se ts impleme nted after the relea se of the JDBC drive r? | |||||
594 | Connection Properties .useFastIn tParsing=U se interna l String-> Integer co nversion r outines to avoid exc essive obj ect creati on? | |||||
595 | Connection Properties .useFastDa teParsing= Use intern al String- >Date/Time /Timestamp conversio n routines to avoid excessive object cre ation? | |||||
596 | Connection Properties .useHostsI nPrivilege s=Add '@ho stname' to users in DatabaseMe taData.get Column/Tab lePrivileg es() (true /false), d efaults to 'true'. | |||||
597 | Connection Properties .useInform ationSchem a=When con nected to MySQL-5.0. 7 or newer , should t he driver use the IN FORMATION_ SCHEMA to derive inf ormation u sed by Dat abaseMetaD ata? | |||||
598 | Connection Properties .useJDBCCo mpliantTim ezoneShift =Should th e driver u se JDBC-co mpliant ru les when c onverting TIME/TIMES TAMP/DATET IME values ' timezone informati on for tho se JDBC ar guments wh ich take a java.util .Calendar argument? (Notice th at this op tion is ex clusive of the "useT imezone=tr ue" config uration op tion.) | |||||
599 | Connection Properties .useLocalS essionStat e=Should t he driver refer to t he interna l values o f autocomm it and tra nsaction i solation t hat are se t by Conne ction.setA utoCommit( ) and Conn ection.set Transactio nIsolation () and tra nsaction s tate as ma intained b y the prot ocol, rath er than qu erying the database or blindly sending c ommands to the datab ase for co mmit() or rollback() method ca lls? | |||||
600 | Connection Properties .useLocalT ransaction State=Shou ld the dri ver use th e in-trans action sta te provide d by the M ySQL proto col to det ermine if a commit() or rollba ck() shoul d actually be sent t o the data base? | |||||
601 | Connection Properties .useNanosF orElapsedT ime=For pr ofiling/de bugging fu nctionalit y that mea sures elap sed time, should the driver tr y to use n anoseconds resolutio n if avail able (JDK >= 1.5)? | |||||
602 | Connection Properties .useOldAli asMetadata Behavior=S hould the driver use the legac y behavior for "AS" clauses on columns a nd tables, and only return ali ases (if a ny) for Re sultSetMet aData.getC olumnName( ) or Resul tSetMetaDa ta.getTabl eName() ra ther than the origin al column/ table name ? In 5.0.x , the defa ult value was true. | |||||
603 | Connection Properties .useOldUtf 8Behavior= Use the UT F-8 behavi or the dri ver did wh en communi cating wit h 4.0 and older serv ers | |||||
604 | Connection Properties .useOnlySe rverErrorM essages=Do n't prepen d 'standar d' SQLStat e error me ssages to error mess ages retur ned by the server. | |||||
605 | Connection Properties .useReadAh eadInput=U se newer, optimized non-blocki ng, buffer ed input s tream when reading f rom the se rver? | |||||
606 | Connection Properties .useSqlSta teCodes=Us e SQL Stan dard state codes ins tead of 'l egacy' X/O pen/SQL st ate codes (true/fals e), defaul t is 'true ' | |||||
607 | Connection Properties .useSSL=Us e SSL when communica ting with the server (true/fal se), defau lts to 'fa lse' | |||||
608 | Connection Properties .useSSPSCo mpatibleTi mezoneShif t=If migra ting from an environ ment that was using server-sid e prepared statement s, and the configura tion prope rty "useJD BCComplian tTimeZoneS hift" set to "true", use compa tible beha vior when not using server-sid e prepared statement s when sen ding TIMES TAMP value s to the M ySQL serve r. | |||||
609 | Connection Properties .useStream LengthsInP repStmts=H onor strea m length p arameter i n Prepared Statement/ ResultSet. setXXXStre am() metho d calls (t rue/false, defaults to 'true') ? | |||||
610 | Connection Properties .useTimezo ne=Convert time/date types bet ween clien t and serv er timezon es (true/f alse, defa ults to 'f alse')? | |||||
611 | Connection Properties .ultraDevH ack=Create PreparedS tatements for prepar eCall() wh en require d, because UltraDev is broken and issues a prepare Call() for _all_ sta tements? ( true/false , defaults to 'false ') | |||||
612 | Connection Properties .useUnbuff eredInput= Don't use BufferedIn putStream for readin g data fro m the serv er | |||||
613 | Connection Properties .useUnicod e=Should t he driver use Unicod e characte r encoding s when han dling stri ngs? Shoul d only be used when the driver can't det ermine the character set mappi ng, or you are tryin g to 'forc e' the dri ver to use a charact er set tha t MySQL ei ther doesn 't nativel y support (such as U TF-8), tru e/false, d efaults to 'true' | |||||
614 | Connection Properties .useUsageA dvisor=Sho uld the dr iver issue 'usage' w arnings ad vising pro per and ef ficient us age of JDB C and MySQ L Connecto r/J to the log (true /false, de faults to 'false')? | |||||
615 | Connection Properties .verifySer verCertifi cate=If "u seSSL" is set to "tr ue", shoul d the driv er verify the server 's certifi cate? When using thi s feature, the keyst ore parame ters shoul d be speci fied by th e "clientC ertificate KeyStore*" propertie s, rather than syste m properti es. | |||||
616 | Connection Properties .yearIsDat eType=Shou ld the JDB C driver t reat the M ySQL type "YEAR" as a java.sql .Date, or as a SHORT ? | |||||
617 | Connection Properties .zeroDateT imeBehavio r=What sho uld happen when the driver enc ounters DA TETIME val ues that a re compose d entirely of zeros (used by M ySQL to re present in valid date s)? Valid values are \"{0}\", \"{1}\" an d \"{2}\". | |||||
618 | Connection Properties .useJvmCha rsetConver ters=Alway s use the character encoding r outines bu ilt into t he JVM, ra ther than using look up tables for single -byte char acter sets ? | |||||
619 | Connection Properties .useGmtMil lisForDate times=Conv ert betwee n session timezone a nd GMT bef ore creati ng Date an d Timestam p instance s (value o f "false" is legacy behavior, "true" lea ds to more JDBC-comp liant beha vior. | |||||
620 | Connection Properties .dumpMetad ataOnColum nNotFound= Should the driver du mp the fie ld-level m etadata of a result set into t he excepti on message when Resu ltSet.find Column() f ails? | |||||
621 | Connection Properties .clientCer tificateKe yStoreUrl= URL to the client ce rtificate KeyStore ( if not spe cified, us e defaults ) | |||||
622 | Connection Properties .trustCert ificateKey StoreUrl=U RL to the trusted ro ot certifi cate KeySt ore (if no t specifie d, use def aults) | |||||
623 | Connection Properties .clientCer tificateKe yStoreType =KeyStore type for c lient cert ificates ( NULL or em pty means use the de fault, whi ch is "JKS ". Standar d keystore types sup ported by the JVM ar e "JKS" an d "PKCS12" , your env ironment m ay have mo re availab le dependi ng on what security products a re install ed and ava ilable to the JVM. | |||||
624 | Connection Properties .clientCer tificateKe yStorePass word=Passw ord for th e client c ertificate s KeyStore | |||||
625 | Connection Properties .trustCert ificateKey StoreType= KeyStore t ype for tr usted root certifica tes (NULL or empty m eans use t he default , which is "JKS". St andard key store type s supporte d by the J VM are "JK S" and "PK CS12", you r environm ent may ha ve more av ailable de pending on what secu rity produ cts are in stalled an d availabl e to the J VM. | |||||
626 | Connection Properties .trustCert ificateKey StorePassw ord=Passwo rd for the trusted r oot certif icates Key Store | |||||
627 | Connection Properties .Username= The user t o connect as | |||||
628 | Connection Properties .Password= The passwo rd to use when conne cting | |||||
629 | Connection Properties .useBlobTo StoreUTF8O utsideBMP= Tells the driver to treat [MED IUM/LONG]B LOB column s as [LONG ]VARCHAR c olumns hol ding text encoded in UTF-8 tha t has char acters out side the B MP (4-byte encodings ), which M ySQL serve r can't ha ndle nativ ely. | |||||
630 | Connection Properties .utf8Outsi deBmpExclu dedColumnN amePattern =When "use BlobToStor eUTF8Outsi deBMP" is set to "tr ue", colum n names ma tching the given reg ex will st ill be tre ated as BL OBs unless they matc h the rege x specifie d for "utf 8OutsideBm pIncludedC olumnNameP attern". T he regex m ust follow the patte rns used f or the jav a.util.reg ex package . | |||||
631 | Connection Properties .utf8Outsi deBmpInclu dedColumnN amePattern =Used to s pecify exc lusion rul es to "utf 8OutsideBm pExcludedC olumnNameP attern". T he regex m ust follow the patte rns used f or the jav a.util.reg ex package . | |||||
632 | Connection Properties .useLegacy DatetimeCo de=Use cod e for DATE /TIME/DATE TIME/TIMES TAMP handl ing in res ult sets a nd stateme nts that c onsistentl y handles timezone c onversions from clie nt to serv er and bac k again, o r use the legacy cod e for thes e datatype s that has been in t he driver for backwa rds-compat ibility? | |||||
633 | Connection Properties .useColumn NamesInFin dColumn=Pr ior to JDB C-4.0, the JDBC spec ification had a bug related to what coul d be given as a "col umn name" to ResultS et methods like find Column(), or getters that took a String property. JDBC-4.0 c larified " column nam e" to mean the label , as given in an "AS " clause a nd returne d by Resul tSetMetaDa ta.getColu mnLabel(), and if no AS clause , the colu mn name. S etting thi s property to "true" will give behavior that is co ngruent to JDBC-3.0 and earlie r versions of the JD BC specifi cation, bu t which be cause of t he specifi cation bug could giv e unexpect ed results . This pro perty is p referred o ver "useOl dAliasMeta dataBehavi or" unless you need the specif ic behavio r that it provides w ith respec t to Resul tSetMetada ta. | |||||
634 | Connection Properties .useAffect edRows=Don 't set the CLIENT_FO UND_ROWS f lag when c onnecting to the ser ver (not J DBC-compli ant, will break most applicati ons that r ely on "fo und" rows vs. "affec ted rows" for DML st atements), but does cause "cor rect" upda te counts from "INSE RT ... ON DUPLICATE KEY UPDATE " statemen ts to be r eturned by the serve r. | |||||
635 | Connection Properties .passwordC haracterEn coding=Wha t characte r encoding is used f or passwor ds? Leavin g this set to the de fault valu e (null), uses the p latform ch aracter se t, which w orks for I SO8859_1 ( i.e. "lati n1") passw ords. For passwords in other c haracter e ncodings, the encodi ng will ha ve to be s pecified w ith this p roperty, a s it's not possible for the dr iver to au to-detect this. | |||||
636 | Connection Properties .exception Intercepto rs=Comma-d elimited l ist of cla sses that implement com.mysql. jdbc.Excep tionInterc eptor. The se classes will be i nstantiate d one per Connection instance, and all S QLExceptio ns thrown by the dri ver will b e allowed to be inte rcepted by these int erceptors, in a chai ned fashio n, with th e first cl ass listed as the he ad of the chain. | |||||
637 | Connection Properties .maxAllowe dPacket=Ma ximum allo wed packet size to s end to ser ver. If no t set, the value of system var iable 'max _allowed_p acket' wil l be used to initial ize this u pon connec ting. This value wil l not take effect if set large r than the value of 'max_allow ed_packet' . | |||||
638 | Connection Properties .queryTime outKillsCo nnection=I f the time out given in Stateme nt.setQuer yTimeout() expires, should the driver fo rcibly abo rt the Con nection in stead of a ttempting to abort t he query? | |||||
639 | Connection Properties .authentic ationPlugi ns=Comma-d elimited l ist of cla sses that implement com.mysql. jdbc.Authe nticationP lugin and which will be used f or authent ication un less disab led by "di sabledAuth entication Plugins" p roperty. | |||||
640 | Connection Properties .disabledA uthenticat ionPlugins =Comma-del imited lis t of class es impleme nting com. mysql.jdbc .Authentic ationPlugi n or mecha nisms, i.e . "mysql_n ative_pass word". The authentic ation plug ins or mec hanisms li sted will not be use d for auth entication which wil l fail if it require s one of t hem. It is an error to disable the defau lt authent ication pl ugin (eith er the one named by "defaultAu thenticati onPlugin" property o r the hard -coded one if "defau ltAuthenti cationPlug in" proper y is not s et). | |||||
641 | Connection Properties .defaultAu thenticati onPlugin=N ame of a c lass imple menting co m.mysql.jd bc.Authent icationPlu gin which will be us ed as the default au thenticati on plugin (see below ). It is a n error to use a cla ss which i s not list ed in "aut henticatio nPlugins" nor it is one of the built-in plugins. I t is an er ror to set as defaul t a plugin which was disabled with "disa bledAuthen ticationPl ugins" pro perty. It is an erro r to set t his value to null or the empty string (i .e. there must be at least a v alid defau lt authent ication pl ugin speci fied for t he connect ion, meeti ng all con straints l isted abov e). | |||||
642 | Connection Properties .parseInfo CacheFacto ry=Name of a class i mplementin g com.mysq l.jdbc.Cac heAdapterF actory, wh ich will b e used to create cac hes for th e parsed r epresentat ion of cli ent-side p repared st atements. | |||||
643 | Connection Properties .serverCon figCacheFa ctory=Name of a clas s implemen ting com.m ysql.jdbc. CacheAdapt erFactory< String, Ma p<String, String>>, which will be used t o create c aches for MySQL serv er configu ration val ues | |||||
644 | Connection Properties .disconnec tOnExpired Passwords= If "discon nectOnExpi redPasswor ds" is set to "false " and pass word is ex pired then server en ters "sand box" mode and sends ERR(08001, ER_MUST_C HANGE_PASS WORD) for all comman ds that ar e not need ed to set a new pass word until a new pas sword is s et. | |||||
645 | ||||||
646 | # | |||||
647 | # Error Me ssages for Connectio n Properti es | |||||
648 | # | |||||
649 | ||||||
650 | Connection Properties .unableToI nitDriverP roperties= Unable to initialize driver pr operties d ue to | |||||
651 | Connection Properties .unsupport edCharacte rEncoding= Unsupporte d characte r encoding ''{0}''. | |||||
652 | Connection Properties .errorNotE xpected=Hu h? | |||||
653 | Connection Properties .InternalP ropertiesF ailure=Int ernal prop erties fai lure | |||||
654 | ||||||
655 | TimeUtil.T ooGenericT imezoneId= The server timezone value ''{0 }'' repres ents more than one t imezone. Y ou must \ | |||||
656 | configure either the server or JDBC driv er (via th e 'serverT imezone' c onfigurati on propert y) to use a \ | |||||
657 | more speci fc timezon e value if you want to utilize timezone support. T he timezon es that '' {0}'' maps to are: { 1}. | |||||
658 | ||||||
659 | Connection .exceededC onnectionL ifetime=Pi ng or vali dation fai led becaus e configur ed connect ion lifeti me exceede d. | |||||
660 | Connection .badLifecy cleInterce ptor=Unabl e to load connection lifecycle intercept or ''{0}'' . | |||||
661 | MysqlIo.Ba dStatement Intercepto r=Unable t o load sta tement int erceptor ' '{0}''. | |||||
662 | Connection .BadExcept ionInterce ptor=Unabl e to load exception intercepto r ''{0}''. | |||||
663 | Connection .CantDetec tLocalConn ect=Unable to determ ine if hos tname ''{0 }'' is loc al to this box becau se of exce ption, ass uming it's not. | |||||
664 | Connection .NoMetadat aOnSocketF actory=Con figured so cket facto ry does no t implemen t SocketMe tadata, ca n not dete rmine whet her server is locall y-connecte d, assumin g not" | |||||
665 | Connection .BadAuthen ticationPl ugin=Unabl e to load authentica tion plugi n ''{0}''. | |||||
666 | Connection .BadDefaul tAuthentic ationPlugi n=Bad valu e ''{0}'' for proper ty "defaul tAuthentic ationPlugi n". | |||||
667 | Connection .DefaultAu thenticati onPluginIs NotListed= defaultAut henticatio nPlugin '' {0}'' is n ot listed in "authen ticationPl ugins" nor it is one of the bu ilt-in plu gins. | |||||
668 | Connection .BadDisabl edAuthenti cationPlug in=Can''t disable th e default plugin, ei ther remov e ''{0}'' from the d isabled au thenticati on plugins list, or choose a d ifferent d efault aut henticatio n plugin. | |||||
669 | Connection .Authentic ationPlugi nRequiresS SL=SSL con nection re quired for plugin '' {0}''. Che ck if "use SSL" is se t to "true ". | |||||
670 | Connection .Unexpecte dAuthentic ationAppro val=Unexpe cted authe ntication approval: ''{0}'' pl ugin did n ot reporte d "done" s tate but s erver has approved c onnection. | |||||
671 | Connection .CantFindC acheFactor y=Can not find class ''{0}'' s pecified b y the ''{1 }'' config uration pr operty. | |||||
672 | Connection .CantLoadC acheFactor y=Can not load the c ache facto ry ''{0}'' specified by the '' {1}'' conf iguration property. | |||||
673 |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.