psqlodbc.git
16 years agoPrep 08.04.0100.
Hiroshi Saito [Tue, 7 Apr 2009 16:08:45 +0000 (16:08 +0000)]
Prep 08.04.0100.

16 years agoForgot to commit a file.
Hiroshi Inoue [Mon, 6 Apr 2009 21:57:08 +0000 (21:57 +0000)]
Forgot to commit a file.

16 years agoImprove the handling of error messages at connection time.
Hiroshi Inoue [Mon, 6 Apr 2009 21:32:57 +0000 (21:32 +0000)]
Improve the handling of error messages at connection time.

16 years agoFix an infinite loop in utf8_to_ucs2().
Hiroshi Inoue [Sat, 4 Apr 2009 14:55:54 +0000 (14:55 +0000)]
Fix an infinite loop in utf8_to_ucs2().

16 years agotake some notes.
Hiroshi Saito [Sat, 4 Apr 2009 14:25:21 +0000 (14:25 +0000)]
take some notes.

16 years agoImprove the transactional control under useDeclareFetch mode.
Hiroshi Inoue [Sat, 4 Apr 2009 10:44:47 +0000 (10:44 +0000)]
Improve the transactional control under useDeclareFetch mode.

16 years agotake some notes.
Hiroshi Saito [Sun, 29 Mar 2009 15:32:27 +0000 (15:32 +0000)]
take some notes.

16 years agoAllow multiple Connsettings statements in connection string by enclosing
Hiroshi Inoue [Sun, 29 Mar 2009 04:54:43 +0000 (04:54 +0000)]
Allow multiple Connsettings statements in connection string by enclosing
them by braces({}).

16 years agoImprove the handling of empty_queries.
Hiroshi Inoue [Wed, 25 Mar 2009 15:30:35 +0000 (15:30 +0000)]
Improve the handling of empty_queries.

16 years agosome changes.
Hiroshi Saito [Wed, 25 Mar 2009 14:50:08 +0000 (14:50 +0000)]
some changes.

16 years agoAdd a textbox to setup dialog to change the directory for logging.
Hiroshi Inoue [Tue, 24 Mar 2009 21:38:45 +0000 (21:38 +0000)]
Add a textbox to setup dialog to change the directory for logging.

16 years agoChange sslverify stuff so that it can be built with older version of libpq.
Hiroshi Inoue [Mon, 23 Mar 2009 17:00:41 +0000 (17:00 +0000)]
Change sslverify stuff so that it can be built with older version of libpq.

16 years agotake some notes.
Hiroshi Saito [Mon, 23 Mar 2009 14:27:07 +0000 (14:27 +0000)]
take some notes.

16 years ago1. Correct the conversion between UTF-16 and UTF-8 for non UCS2 characters.
Hiroshi Inoue [Sun, 22 Mar 2009 14:17:10 +0000 (14:17 +0000)]
1. Correct the conversion between UTF-16 and UTF-8 for non UCS2 characters.
2. Try to convert (especially connection error) messages using local conversions
   when they are not valid unicode characters,

16 years agoFix gettext library.
Hiroshi Saito [Sun, 22 Mar 2009 04:48:21 +0000 (04:48 +0000)]
Fix gettext library.

16 years agotake some notes.
Hiroshi Saito [Sun, 22 Mar 2009 04:38:44 +0000 (04:38 +0000)]
take some notes.

16 years agoFix an inconsistent declaration of a function.
Hiroshi Inoue [Sat, 21 Mar 2009 03:29:12 +0000 (03:29 +0000)]
Fix an inconsistent declaration of a function.

16 years agoThe version is now 8.03.0402.
Hiroshi Inoue [Fri, 20 Mar 2009 15:39:22 +0000 (15:39 +0000)]
The version is now 8.03.0402.
1. Close (holdable) cursors on commit if possible.
2. Recycle columns cache info if the size becomes pretty large.
3. Add sslverify=none to conninfo in case of SSL connections
   via libpq of version 8.4.
4. Add a functionality to change the directory for logging.
5. Correct the error code for communication errors.

16 years agotake some notes.
Hiroshi Saito [Sun, 18 Jan 2009 13:19:43 +0000 (13:19 +0000)]
take some notes.

16 years ago1) Fix a bug reported by Milen Manev that SQLExec *select for a table* -> SQLDescribe...
Hiroshi Inoue [Sun, 18 Jan 2009 13:09:55 +0000 (13:09 +0000)]
1) Fix a bug reported by Milen Manev that SQLExec *select for a table* -> SQLDescribeCol() -> add a column to the table -> SQLExec *select for the table* -> SQLDescribeCol() for the added column causes a bad result.
2) Use strncpy_null() instead of strncpy().

16 years agotake some notes.
Hiroshi Saito [Sun, 4 Jan 2009 05:26:39 +0000 (05:26 +0000)]
take some notes.

16 years agoAdjustment gcc conditions.
Hiroshi Saito [Sun, 4 Jan 2009 05:19:27 +0000 (05:19 +0000)]
Adjustment gcc conditions.

16 years ago1.Take domain types into account in SQLColumns() (Thanks to Luiz K. Matsumura).
Hiroshi Inoue [Sun, 4 Jan 2009 02:40:04 +0000 (02:40 +0000)]
1.Take domain types into account in SQLColumns() (Thanks to Luiz K. Matsumura).
2.Take RESTRICT actions into account in SQLForeignKeys() (report from Farid Zidan).
3.Fix a bug that small negative decimal values are mistaken for
  non-negative (bug report from Dominic Smith).
4.Use MSG_NOSIGNAL/MSG_NOSIGPIPE option on send()/recv() to avoid
  crash on SIGPIPE (bug report from Brian Feldman).
5.Remove a spurious "." with no trailing digits in timestamp representation
  (bug report from Brian Feldman).
6.Rename trim() funtion in order to avoid conflict of function name
  (report from Dominic Smith).
7.Put back the change to add *read only* clause for read only cursors.
8.Improve pgtype_transfer_octet_length().

16 years agoThe specification method of the ROLLBACK option is added.
Hiroshi Saito [Sun, 23 Nov 2008 03:12:34 +0000 (03:12 +0000)]
The specification method of the ROLLBACK option is added.
Suggestion of Andrus-san.

16 years agotake some notes.
Hiroshi Saito [Sun, 23 Nov 2008 02:50:24 +0000 (02:50 +0000)]
take some notes.

16 years agoThe version is now 8.3.0401.
Hiroshi Inoue [Sun, 23 Nov 2008 01:00:53 +0000 (01:00 +0000)]
The version is now 8.3.0401.
1) Avoid a crash on exit when using SSL connections by resetting
   CRTPTO_xx_callbacks before unloding libpq.
2) Correct the funtion name DiscardRollbackState pointed out by Zoltan Boszormenyi.
3) Correct the value of INDEX_QUALIFIER column which returned by
   SLQSTATISTICS();

16 years agoFixed typo....
Hiroshi Saito [Tue, 18 Nov 2008 16:19:35 +0000 (16:19 +0000)]
Fixed typo....

16 years agoOops, falls xalibname.c.
Hiroshi Saito [Fri, 7 Nov 2008 14:37:25 +0000 (14:37 +0000)]
Oops, falls xalibname.c.

16 years agofalls pgenlist.def.
Hiroshi Saito [Fri, 7 Nov 2008 14:07:11 +0000 (14:07 +0000)]
falls pgenlist.def.

16 years agoPrep release Version 08.03.0400. REL-08_03_0400
Hiroshi Saito [Fri, 7 Nov 2008 13:33:58 +0000 (13:33 +0000)]
Prep release Version 08.03.0400.

16 years agoFixed Soalris compiller error.
Hiroshi Saito [Tue, 4 Nov 2008 15:48:48 +0000 (15:48 +0000)]
Fixed Soalris compiller error.
-Wall was taken as gcc limitation.
Thanks report Marcin Ligorowski.

17 years agoOops I forgot to set the value to the buffer.
Hiroshi Inoue [Wed, 29 Oct 2008 13:40:54 +0000 (13:40 +0000)]
Oops I forgot to set the value to the buffer.

17 years agoSuppress some complier warnings.
Hiroshi Inoue [Tue, 7 Oct 2008 21:45:40 +0000 (21:45 +0000)]
Suppress some complier warnings.

17 years agoRemove some compiler warnings thanks to Zoltan Boszormenyi.
Hiroshi Inoue [Mon, 6 Oct 2008 21:46:09 +0000 (21:46 +0000)]
Remove some compiler warnings thanks to Zoltan Boszormenyi.

17 years agoPrep release Version 08.03.0300. REL-08_03_0300
Hiroshi Saito [Fri, 26 Sep 2008 13:44:33 +0000 (13:44 +0000)]
Prep release Version 08.03.0300.

17 years agoBigEndian support for ucs2(utf-16)<->utf8 conversion.
Hiroshi Inoue [Wed, 24 Sep 2008 14:46:55 +0000 (14:46 +0000)]
BigEndian support for ucs2(utf-16)<->utf8 conversion.

17 years agoSuppress some compiler warnings.
Hiroshi Inoue [Wed, 24 Sep 2008 13:14:32 +0000 (13:14 +0000)]
Suppress some compiler warnings.

17 years agoSuppress a compiler warning.
Hiroshi Inoue [Tue, 23 Sep 2008 16:37:06 +0000 (16:37 +0000)]
Suppress a compiler warning.

17 years agoImprove SQLGUID format handling.
Hiroshi Inoue [Mon, 22 Sep 2008 22:13:22 +0000 (22:13 +0000)]
Improve SQLGUID format handling.

17 years agoadded the some changes.
Hiroshi Saito [Mon, 22 Sep 2008 13:40:38 +0000 (13:40 +0000)]
added the some changes.

17 years agoSuppress some compiler warnings.
Hiroshi Inoue [Mon, 22 Sep 2008 12:42:02 +0000 (12:42 +0000)]
Suppress some compiler warnings.

17 years ago1. Support FE/BE communications on Big Endian platform.
Hiroshi Inoue [Sun, 21 Sep 2008 15:35:44 +0000 (15:35 +0000)]
1. Support FE/BE communications on Big Endian platform.
2. Check strerror_r function's return type.
3. Suppress some compiler warnings.

17 years agousing -Wall.(attached is a list of warnings)
Hiroshi Saito [Tue, 16 Sep 2008 14:49:40 +0000 (14:49 +0000)]
using -Wall.(attached is a list of warnings)

17 years agoaddition on a document.
Hiroshi Saito [Sun, 10 Aug 2008 00:12:37 +0000 (00:12 +0000)]
addition on a document.

17 years agoFix some bugs.
Hiroshi Inoue [Sat, 9 Aug 2008 23:30:53 +0000 (23:30 +0000)]
Fix some bugs.
1. Reset the column binding information after SQLMoreResults().
2. Save the rowset size properly for the FETCH_NEXT operation
   in case of >= 3.0 drivers.

Enable geqo optiomizer by default.

17 years agocommit test
Hiroshi Saito [Sat, 9 Aug 2008 14:51:38 +0000 (14:51 +0000)]
commit test

17 years agoNote that the data sources applet may be in the Administrative Tools folder on some...
Dave Page [Tue, 15 Jul 2008 14:21:43 +0000 (14:21 +0000)]
Note that the data sources applet may be in the Administrative Tools folder on some versions of Windows

17 years agoFixed has a default promotion can't match an empty parameter name list declaration.
Hiroshi Saito [Sun, 6 Jul 2008 15:08:21 +0000 (15:08 +0000)]
Fixed has a default promotion can't match an empty parameter name list declaration.

17 years agoThe version is now 8.3.0201.
Hiroshi Inoue [Fri, 4 Jul 2008 13:49:33 +0000 (13:49 +0000)]
The version is now 8.3.0201.
1. SQLGUID type support thanks to Jan-Willem Goossens.
2. Fix a bug about silently adding a *for read only* clause.
3. Fix a 64bit mode bug about handling of arrays of parameters.
4. Change the implemetatin of SQLForeignKeys() for 8.3+ servers.
5. Not commit the transaction too early in useDeclareFetch mode.
6. Add a cursor open check for SQLPrepare().

17 years agoOmission in change of reference. REL-08_03_0200
Hiroshi Saito [Sun, 4 May 2008 16:11:15 +0000 (16:11 +0000)]
Omission in change of reference.
8.2 -> 8.3

17 years agoAdjustment of a library.
Hiroshi Saito [Sat, 3 May 2008 18:52:06 +0000 (18:52 +0000)]
Adjustment of a library.
(PostgreSQL Version 8.3 of MSVC)

17 years agoPrep next release.
Hiroshi Saito [Sat, 3 May 2008 07:27:37 +0000 (07:27 +0000)]
Prep next release.

17 years agoFixed the first DSN name mistake.
Hiroshi Saito [Sat, 3 May 2008 07:22:50 +0000 (07:22 +0000)]
Fixed the first DSN name mistake.

17 years agoAdjustment of *nix compile problem.
Hiroshi Saito [Sat, 3 May 2008 06:47:35 +0000 (06:47 +0000)]
Adjustment of *nix compile problem.

17 years ago1. Fix a bug in socket which uses a socket variable.
Hiroshi Inoue [Sat, 3 May 2008 05:57:42 +0000 (05:57 +0000)]
1. Fix a bug in socket which uses a socket variable.
2. Support column alias without "as" so that links from
   the SQLServer work.
3. Take ';' into account when the driver adds "for read only"
   clause.
4. Use the E'.. ' notation not only in '=' expressions but
   also in LIKE expressions.
5. Change to return milliseconds parts for timestamp fields.
6. Change to return a specific sqlstate in case of multiple
   parameters.

17 years agoFix bug of the selection not using SSL.
Hiroshi Saito [Mon, 28 Jan 2008 16:10:10 +0000 (16:10 +0000)]
Fix bug of the selection not using SSL.
Per report Stephen M. Lathrop.

17 years agoFix problem disable of USE_SSL. REL-08_03_0100
Hiroshi Saito [Sat, 26 Jan 2008 13:49:26 +0000 (13:49 +0000)]
Fix problem disable of USE_SSL.
Per report Stephen M. Lathrop.

17 years agoFix final FreeLibrary of SSL.
Hiroshi Saito [Tue, 22 Jan 2008 12:10:16 +0000 (12:10 +0000)]
Fix final FreeLibrary of SSL.

17 years agoPrep release 08.03.0100
Hiroshi Saito [Mon, 21 Jan 2008 05:45:20 +0000 (05:45 +0000)]
Prep release 08.03.0100

17 years agoPrep release 08.03.0100
Hiroshi Saito [Mon, 21 Jan 2008 05:19:32 +0000 (05:19 +0000)]
Prep release 08.03.0100

17 years agoCompile of SSPI cannot be supported in VC+6. SSPI should use vcproj more than by...
Hiroshi Saito [Mon, 21 Jan 2008 02:27:16 +0000 (02:27 +0000)]
Compile of SSPI cannot be supported in VC+6. SSPI should use vcproj more than by VC+7.

17 years agoFix problem of CRLF code.
Hiroshi Saito [Mon, 21 Jan 2008 02:09:03 +0000 (02:09 +0000)]
Fix problem of CRLF code.

17 years agoVCExpress compile adjustment.
Hiroshi Saito [Sat, 29 Dec 2007 02:12:24 +0000 (02:12 +0000)]
VCExpress compile adjustment.

17 years agoSSPI is enable and delay load specification.
Hiroshi Saito [Fri, 28 Dec 2007 15:40:56 +0000 (15:40 +0000)]
SSPI is enable and delay load specification.

17 years agoFixed include path problem.
Hiroshi Saito [Fri, 28 Dec 2007 14:42:12 +0000 (14:42 +0000)]
Fixed include path problem.

17 years agoExpression was corrected.
Hiroshi Saito [Fri, 28 Dec 2007 14:00:40 +0000 (14:00 +0000)]
Expression was corrected.

17 years agoRelease preparation.
Hiroshi Saito [Fri, 28 Dec 2007 13:51:26 +0000 (13:51 +0000)]
Release preparation.

17 years agoadd the sspi modules.
Hiroshi Saito [Fri, 28 Dec 2007 13:39:41 +0000 (13:39 +0000)]
add the sspi modules.

17 years ago*** empty log message ***
Hiroshi Inoue [Wed, 26 Dec 2007 13:28:36 +0000 (13:28 +0000)]
*** empty log message ***

17 years agoCorrect the flow of trial of multi protocols and fix related bugs about handling...
Hiroshi Inoue [Sun, 4 Nov 2007 00:32:38 +0000 (00:32 +0000)]
Correct the flow of trial of multi protocols and fix related bugs about handling of connection errors.

17 years agoI may have introduced a bug in the last change which may cause an
Hiroshi Inoue [Fri, 2 Nov 2007 23:01:41 +0000 (23:01 +0000)]
I may have introduced a bug in the last change which may cause an
infinite loop of trial to use the same (should be lower) version of
protocols. Also try to use SSPI service for SSL support when libpq
is unavailable.

18 years ago1. Fix a bug in copy_and_convert_field() when fetching bookmark columns.
Hiroshi Inoue [Mon, 29 Oct 2007 15:04:48 +0000 (15:04 +0000)]
1. Fix a bug in copy_and_convert_field() when fetching bookmark columns.
   This bug could occur in case no suitable? lo type is found.
2. Improve the parse statement operation so that it detect srf in
   <from clause>.

18 years agoThe correction of the previous commit message.
Hiroshi Inoue [Sat, 27 Oct 2007 13:16:43 +0000 (13:16 +0000)]
The correction of the previous commit message.
2c2
< 1. Correct the COLUMN_LENGTH return value of SQLColumns() for varchar/bpchar
---
> 1. Correct the DISPLAY_SIZE return value of SQLColumns() for varchar/bpchar

18 years agoThe version is now 8.2.0501.
Hiroshi Inoue [Sat, 27 Oct 2007 01:14:00 +0000 (01:14 +0000)]
The version is now 8.2.0501.
1. Correct the COLUMN_LENGTH return value of SQLColumns() for varchar/bpchar
   type columns (Unicode driver).
2. Change to not return database name if case of MS Query.
3. The first cut to use Windows SSPI. The trial to use Schannel service
   for SSL support.
4. Be more careful about <for locking clause> in UseDeclareFetch mode.
   Add missing? "for read only" clause for read only queries for 8.3
   or later servers for safety.

18 years agoPrep Version 08.02.0500
Hiroshi Saito [Fri, 21 Sep 2007 06:36:27 +0000 (06:36 +0000)]
Prep Version 08.02.0500
The document addition which I have forgotten.

18 years agoDuplication deletion.
Hiroshi Saito [Wed, 12 Sep 2007 05:49:10 +0000 (05:49 +0000)]
Duplication deletion.

18 years agoOops,typo..
Hiroshi Saito [Wed, 12 Sep 2007 05:43:28 +0000 (05:43 +0000)]
Oops,typo..

18 years agoPrep Ver 08.02.0500
Hiroshi Saito [Wed, 12 Sep 2007 05:40:39 +0000 (05:40 +0000)]
Prep Ver 08.02.0500
and Fixed build of without OpenSSL.

18 years agoCorrect the format of Bind message under 64bit environment.
Hiroshi Inoue [Tue, 11 Sep 2007 14:38:11 +0000 (14:38 +0000)]
Correct the format of Bind message under 64bit environment.

18 years agoPrep Ver 08.02.0500.
Hiroshi Saito [Wed, 5 Sep 2007 12:28:23 +0000 (12:28 +0000)]
Prep Ver 08.02.0500.

18 years agoSome changes.
Hiroshi Saito [Sat, 1 Sep 2007 00:53:55 +0000 (00:53 +0000)]
Some changes.

18 years agoThe version is now 8.2.0403.
Hiroshi Inoue [Fri, 31 Aug 2007 23:40:10 +0000 (23:40 +0000)]
The version is now 8.2.0403.
1. Support SQLColAttribute for MS specific SQL_CA_SS_COLUMN_KEY.
   Some MS applications use this.
2. Improve the check of updatability of queries by checking
   if they have multiple tables.
3. Reduce the round trip overhead in FE/BE communications
   (especially in useDeclareFetch mode).
4. Fix a bug in ResolveOneParam() pointed out by Rainer Bauer.
5. Add a flag which lets SQLTables() show only accessible tables.
6. The unicode driver now can handle utf-16 surrogate pairs.

18 years agomissing break..
Hiroshi Saito [Wed, 22 Aug 2007 01:18:09 +0000 (01:18 +0000)]
missing break..

18 years agoOops, typo..
Hiroshi Saito [Wed, 22 Aug 2007 01:15:22 +0000 (01:15 +0000)]
Oops, typo..

18 years agocomment and code condition correction.
Hiroshi Saito [Wed, 22 Aug 2007 01:11:58 +0000 (01:11 +0000)]
comment and code condition correction.

18 years agoStandard correction and a multibye condition addition.
Hiroshi Saito [Tue, 21 Aug 2007 06:56:24 +0000 (06:56 +0000)]
Standard correction and a multibye condition addition.

18 years agoSHIFT-JIS-2004 Japanese, standard JIS X 0213.
Hiroshi Saito [Tue, 21 Aug 2007 05:23:03 +0000 (05:23 +0000)]
SHIFT-JIS-2004 Japanese, standard JIS X 0213.
Since PostgreSQL Version 8.3.

18 years agoadditional document.
Hiroshi Saito [Tue, 21 Aug 2007 05:19:17 +0000 (05:19 +0000)]
additional document.

18 years agoRecord of progress.(Snapshot version)
Hiroshi Saito [Wed, 8 Aug 2007 02:02:59 +0000 (02:02 +0000)]
Record of progress.(Snapshot version)

18 years agoFix *nix build error.
Hiroshi Saito [Tue, 12 Jun 2007 15:39:28 +0000 (15:39 +0000)]
Fix *nix build error.

18 years agoFix a bug which doesn't free connection list properly.
Hiroshi Inoue [Tue, 12 Jun 2007 14:24:56 +0000 (14:24 +0000)]
Fix a bug which doesn't free connection list properly.

18 years agoFix DelayLoadDLL was made explicit.
Hiroshi Saito [Tue, 12 Jun 2007 06:22:07 +0000 (06:22 +0000)]
Fix DelayLoadDLL was made explicit.
However, The DEBUG mode of /MTd contains some problems by the reason Release DLL is /MT.
This problem is closely related to the release of OpenSSL. Therefore, we are going
to still investigate this problem and to cope with it. Then, please understand having
not solved yet.

18 years agoAdd the How to specify as a connection option.
Hiroshi Saito [Mon, 11 Jun 2007 02:21:36 +0000 (02:21 +0000)]
Add the How to specify as a connection option.

18 years agoVarious problems of configure cleared.
Hiroshi Saito [Mon, 11 Jun 2007 01:51:12 +0000 (01:51 +0000)]
Various problems of configure cleared.
These problems were fixed by Peter Eisentraut.

18 years agoHandle standard_conforming_strings also in case via libpq.
Hiroshi Inoue [Mon, 4 Jun 2007 11:49:49 +0000 (11:49 +0000)]
Handle standard_conforming_strings also in case via libpq.

18 years ago. Add CC_set_autocommit to psqlodbc(a).def files.
Hiroshi Inoue [Mon, 4 Jun 2007 10:24:49 +0000 (10:24 +0000)]
. Add CC_set_autocommit to psqlodbc(a).def files.
. Handle Standard_conforming_strings.

18 years agoThe version is now 8.2.0402.
Hiroshi Inoue [Sat, 2 Jun 2007 05:32:19 +0000 (05:32 +0000)]
The version is now 8.2.0402.
. Fix some bugs in case without MSDTC support.
. Refine the realloc handling.
. Put back the @@IDENTITY implementation so as not to use lastval().
. Change SQLColumns() to return correct column length in the Unicode driver.
. Remove the connection count limitation.
. Fix Protocol=7.4--1 notation (should be Protocol=7.4).
. Fix a typo in socket.c (bug report from Rainer bauer).

18 years agoFixed HANDLE_ENLIST_IN_DTC.
Hiroshi Saito [Fri, 4 May 2007 13:17:20 +0000 (13:17 +0000)]
Fixed HANDLE_ENLIST_IN_DTC.
(*nix compile error)

18 years agoClean up some of the accumulated Autoconf mess here. Put back the
Peter Eisentraut [Fri, 4 May 2007 12:20:24 +0000 (12:20 +0000)]
Clean up some of the accumulated Autoconf mess here.  Put back the
PGAC_ARG_ macros so that the options parsing is more robust, put the
macro calls in the right order, and make the detection of the driver
manager behave less oddly.  All the required macros are now in-tree, so
everything can be bootstrapped without external PostgreSQL source trees.

18 years agoPut Autotools-generated files into subdirectory config/; add macro files
Peter Eisentraut [Fri, 4 May 2007 10:39:02 +0000 (10:39 +0000)]
Put Autotools-generated files into subdirectory config/; add macro files
used from PostgreSQL there so you don't need a PostgreSQL source tree to
bootstrap the code.