When using Component Integration Services (CIS) in certain geographic regions, connection attempts return the error No Suitable Driver. Java Developer Kits used with Sybase IQ 12.7 support only the time zone codes shown in Table 1-1 and Table 1-2.
JDKs 1.3 and prior provide limited support for time zones and daylight savings time. If you encounter the No Suitable Driver error, use a TZ variable with GMT+nnn to avoid interactions between named time zones (for example, Asia/Seoul) and daylight savings time.
For databases using default JDK 1.1.8:
Substitute GMT+9 for unsupported time zone KST:
setenv TZ GMT+9
For databases using JDK 1.3:
Substitute GMT+9 for named time zone Asia/Seoul:
setenv TZ GMT+9
Set the time zone environment variable to a supported setting, start the server, and CIS works as expected. To ensure that the correct setting is always used, you can set the time zone in the start_asiq script.
Time zone setting |
Time zone code |
Time zone setting |
Time zone code |
|---|---|---|---|
0 |
GMT |
16 |
SST |
1 |
UTC |
17 |
NST |
2 |
ECT |
18 |
MIT |
3 |
EET |
19 |
HST |
4 |
ART |
20 |
AST |
5 |
EAT |
21 |
PST |
6 |
MET |
22 |
PNT |
7 |
NET |
23 |
MST |
8 |
PLT |
24 |
CST |
9 |
IST |
25 |
EST |
10 |
BST |
26 |
IET |
11 |
VST |
27 |
PRT |
12 |
CTT |
28 |
CNT |
13 |
JST |
29 |
AGT |
14 |
ACT |
30 |
BET |
15 |
AET |
31 |
CAT |
Time zone setting |
Time zone code |
Time zone setting |
Time zone code |
|---|---|---|---|
0 |
Pacific/Niue |
161 |
Europe/Belgrade |
1 |
Pacific/Apia |
162 |
Europe/Paris |
2 |
MIT |
163 |
ECT |
3 |
Pacific/Pago_Pago |
164 |
Africa/Bujumbura |
4 |
Pacific/Tahiti |
165 |
Africa/Gaborone |
5 |
Pacific/Fakaofo |
166 |
Africa/Lubumbashi |
6 |
Pacific/Honolulu |
167 |
Africa/Maseru |
7 |
HST |
168 |
Africa/Blantyre |
8 |
America/Adak |
169 |
Africa/Maputo |
9 |
Pacific/Rarotonga |
170 |
Africa/Kigali |
10 |
Pacific/Marquesas |
171 |
Africa/Khartoum |
11 |
Pacific/Gambier |
172 |
Africa/Mbabane |
12 |
America/Anchorage |
173 |
Africa/Lusaka |
13 |
AST |
174 |
Africa/Harare |
14 |
Pacific/Pitcairn |
175 |
CAT |
15 |
America/Vancouver |
176 |
Africa/Johannesburg |
16 |
America/Tijuana |
177 |
Europe/Sofia |
17 |
America/Los_Angeles |
178 |
Europe/Minsk |
18 |
PST |
179 |
Asia/Nicosia |
19 |
America/Dawson_Creek |
180 |
Europe/Tallinn |
20 |
America/Phoenix |
181 |
Africa/Cairo |
21 |
PNT |
182 |
ART |
22 |
America/Edmonton |
183 |
Europe/Helsinki |
23 |
America/Mazatlan |
184 |
Europe/Athens |
24 |
America/Denver |
185 |
Asia/Jerusalem |
25 |
MST |
186 |
Asia/Amman |
26 |
America/Belize |
187 |
Asia/Beirut |
27 |
America/Regina |
188 |
Europe/Vilnius |
28 |
Pacific/Galapagos |
189 |
Europe/Riga |
29 |
America/Guatemala |
190 |
Europe/Chisinau |
30 |
America/Tegucigalpa |
191 |
Europe/Bucharest |
31 |
America/El_Salvador |
192 |
Europe/Kaliningrad |
32 |
America/Costa_Rica |
193 |
Asia/Damascus |
33 |
America/Winnipeg |
194 |
Europe/Kiev |
34 |
Pacific/Easter |
195 |
Europe/Istanbul |
35 |
America/Mexico_City |
196 |
EET |
36 |
America/Chicago |
197 |
Asia/Bahrain |
37 |
CST |
198 |
Africa/Djibouti |
38 |
America/Porto_Acre |
199 |
Africa/Asmera |
39 |
America/Bogota |
200 |
Africa/Addis_Ababa |
40 |
America/Guayaquil |
201 |
EAT |
41 |
America/Jamaica |
202 |
Africa/Nairobi |
42 |
America/Cayman |
203 |
Indian/Comoro |
43 |
America/Managua |
204 |
Asia/Kuwait |
44 |
America/Panama |
205 |
Indian/Antananarivo |
45 |
America/Lima |
206 |
Asia/Qatar |
46 |
America/Indianapolis |
207 |
Africa/Mogadishu |
47 |
IET |
208 |
Africa/Dar_es_Salaam |
48 |
America/Nassau |
209 |
Africa/Kampala |
49 |
America/Montreal |
210 |
Asia/Aden |
50 |
America/Havana |
211 |
Indian/Mayotte |
51 |
America/Port-au-Prince |
212 |
Asia/Riyadh |
52 |
America/Grand_Turk |
213 |
Asia/Baghdad |
53 |
America/New_York |
214 |
Europe/Simferopol |
54 |
EST |
215 |
Europe/Moscow |
55 |
America/Antigua |
216 |
Asia/Tehran |
56 |
America/Anguilla |
217 |
MET |
57 |
America/Curacao |
218 |
Asia/Dubai |
58 |
America/Aruba |
219 |
Indian/Mauritius |
59 |
America/Barbados |
220 |
Asia/Muscat |
60 |
America/La_Paz |
221 |
Indian/Reunion |
61 |
America/Manaus |
222 |
Indian/Mahe |
62 |
America/Dominica |
223 |
Asia/Yerevan |
63 |
America/Santo_Domingo |
224 |
NET |
64 |
America/Grenada |
225 |
Asia/Baku |
65 |
America/Guadeloupe |
226 |
Asia/Aqtau |
66 |
America/Guyana |
227 |
Europe/Samara |
67 |
America/St_Kitts |
228 |
Asia/Kabul |
68 |
America/St_Lucia |
229 |
Indian/Kerguelen |
69 |
America/Martinique |
230 |
Asia/Tbilisi |
70 |
America/Montserrat |
231 |
Indian/Chagos |
71 |
America/Puerto_Rico |
232 |
Indian/Maldives |
72 |
PRT |
233 |
Asia/Dushanbe |
73 |
America/Port_of_Spain |
234 |
Asia/Ashkhabad |
74 |
America/St_Vincent |
235 |
Asia/Tashkent |
75 |
America/Tortola |
236 |
Asia/Karachi |
76 |
America/St_Thomas |
237 |
PLT |
77 |
America/Caracas |
238 |
Asia/Bishkek |
78 |
Antarctica/Palmer |
239 |
Asia/Aqtobe |
79 |
Atlantic/Bermuda |
240 |
Asia/Yekaterinburg |
80 |
America/Cuiaba |
241 |
Asia/Calcutta |
81 |
America/Halifax |
242 |
IST |
82 |
Atlantic/Stanley |
243 |
Asia/Katmandu |
83 |
America/Thule |
244 |
Antarctica/Mawson |
84 |
America/Asuncion |
245 |
Asia/Thimbu |
85 |
America/Santiago |
246 |
Asia/Colombo |
86 |
America/St_Johns |
247 |
Asia/Dacca |
87 |
CNT |
248 |
BST |
88 |
America/Fortaleza |
249 |
Asia/Almaty |
89 |
America/Cayenne |
250 |
Asia/Novosibirsk |
90 |
America/Paramaribo |
251 |
Indian/Cocos |
91 |
America/Montevideo |
252 |
Asia/Rangoon |
92 |
America/Buenos_Aires |
253 |
Indian/Christmas |
93 |
AGT |
254 |
Asia/Jakarta |
94 |
America/Godthab |
255 |
Asia/Phnom_Penh |
95 |
America/Miquelon |
256 |
Asia/Vientiane |
96 |
America/Sao_Paulo |
257 |
Asia/Saigon |
97 |
BET |
258 |
VST |
98 |
America/Noronha |
259 |
Asia/Bangkok |
99 |
Atlantic/South_Georgia |
260 |
Asia/Krasnoyarsk |
100 |
Atlantic/Jan_Mayen |
261 |
Antarctica/Casey |
101 |
Atlantic/Cape_Verde |
262 |
Australia/Perth |
102 |
America/Scoresbysund |
263 |
Asia/Brunei |
103 |
Atlantic/Azores |
264 |
Asia/Hong_Kong |
104 |
Africa/Ouagadougou |
265 |
Asia/Ujung_Pandang |
105 |
Africa/Abidjan |
266 |
Asia/Macao |
106 |
Africa/Accra |
267 |
Asia/Kuala_Lumpur |
107 |
Africa/Banjul |
268 |
Asia/Manila |
108 |
Africa/Conakry |
269 |
Asia/Singapore |
109 |
Africa/Bissau |
270 |
Asia/Taipei |
110 |
Atlantic/Reykjavik |
271 |
Asia/Shanghai |
111 |
Africa/Monrovia |
272 |
CTT |
112 |
Africa/Casablanca |
273 |
Asia/Ulan_Bator |
113 |
Africa/Timbuktu |
274 |
Asia/Irkutsk |
114 |
Africa/Nouakchott |
275 |
Asia/Jayapura |
115 |
Atlantic/St_Helena |
276 |
Asia/Pyongyang |
116 |
Africa/Freetown |
277 |
Asia/Seoul |
117 |
Africa/Dakar |
278 |
Pacific/Palau |
118 |
Africa/Sao_Tome |
279 |
Asia/Tokyo |
119 |
Africa/Lome |
280 |
JST |
120 |
GMT |
281 |
Asia/Yakutsk |
121 |
UTC |
282 |
Australia/Darwin |
122 |
Atlantic/Faeroe |
283 |
ACT |
123 |
Atlantic/Canary |
284 |
Australia/Adelaide |
124 |
Europe/Dublin |
285 |
Australia/Broken_Hill |
125 |
Europe/Lisbon |
286 |
Australia/Hobart |
126 |
Europe/London |
287 |
Antarctica/DumontDUrville |
127 |
Africa/Luanda |
288 |
Pacific/Truk |
128 |
Africa/Porto-Novo |
289 |
Pacific/Guam |
129 |
Africa/Bangui |
290 |
Pacific/Saipan |
130 |
Africa/Kinshasa |
291 |
Pacific/Port_Moresby |
131 |
Africa/Douala |
292 |
Australia/Brisbane |
132 |
Africa/Libreville |
293 |
Asia/Vladivostok |
133 |
Africa/Malabo |
294 |
Australia/Sydney |
134 |
Africa/Niamey |
295 |
AET |
135 |
Africa/Lagos |
296 |
Australia/Lord_Howe |
136 |
Africa/Ndjamena |
297 |
Pacific/Ponape |
137 |
Africa/Tunis |
298 |
Pacific/Efate |
138 |
Africa/Algiers |
299 |
Pacific/Guadalcanal |
139 |
Europe/Andorra |
300 |
SST |
140 |
Europe/Tirane |
301 |
Pacific/Noumea |
141 |
Europe/Vienna |
302 |
Asia/Magadan |
142 |
Europe/Brussels |
303 |
Pacific/Norfolk |
143 |
Europe/Zurich |
304 |
Pacific/Kosrae |
144 |
Europe/Prague |
305 |
Pacific/Tarawa |
145 |
Europe/Berlin |
306 |
Pacific/Majuro |
146 |
Europe/Copenhagen |
307 |
Pacific/Nauru |
147 |
Europe/Madrid |
308 |
Pacific/Funafuti |
148 |
Europe/Gibraltar |
309 |
Pacific/Wake |
149 |
Europe/Budapest |
310 |
Pacific/Wallis |
150 |
Europe/Rome |
311 |
Pacific/Fiji |
151 |
Europe/Vaduz |
312 |
Antarctica/McMurdo |
152 |
Europe/Luxembourg |
313 |
Asia/Kamchatka |
153 |
Africa/Tripoli |
314 |
Pacific/Aucklandoo |
154 |
Europe/Monaco |
315 |
NST |
155 |
Europe/Malta |
316 |
Pacific/Chatham |
156 |
Africa/Windhoek |
317 |
Pacific/Enderbury |
157 |
Europe/Amsterdam |
318 |
Pacific/Tongatapu |
158 |
Europe/Oslo |
319 |
Asia/Anadyr |
159 |
Europe/Warsaw |
320 |
Pacific/Kiritimati |
160 |
Europe/Stockholm |
