Cihlar, Jan | 2 Aug 2011 12:11
Favicon

FW: Patch for unixODBC 2.3.0

Hi,

 

One my colleague (Miloslav Marik) prepared a patch for unixODBC fixing some issues:

 

Two issues were observed when testing unixODBC. The test application created about 200 connections to a database server and allocated about 200 statements per connections.

 

(1) Extremely slow shut down. The problem is caused by a single linked list of descriptor handlers and statement handlers so when removing a handler from a list, the list must be searched from the beginning. The patch replaces the single linked lists by a double linked list.

 

(2) Extremely slow manual commit transaction. The problem is caused by a global statement list. The list is searched for statements belonging to a connection to check state transition. The patch introduces per connection statement list.

 

(3) There was also one sprintf not surrounded by an “if” statement.

 

The new functionality is available only for sources compiled with the “fast-validate” option.

 

The patch was accepted by Nick to 2.3.1pre.

 

Bye

 

Jan


This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev <at> mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
Nick Gorham | 2 Aug 2011 12:14
Favicon

Re: FW: Patch for unixODBC 2.3.0

On 02/08/11 11:11, Cihlar, Jan wrote:

Hi,

 

One my colleague (Miloslav Marik) prepared a patch for unixODBC fixing some issues:

 

Two issues were observed when testing unixODBC. The test application created about 200 connections to a database server and allocated about 200 statements per connections.

 

(1) Extremely slow shut down. The problem is caused by a single linked list of descriptor handlers and statement handlers so when removing a handler from a list, the list must be searched from the beginning. The patch replaces the single linked lists by a double linked list.

 

(2) Extremely slow manual commit transaction. The problem is caused by a global statement list. The list is searched for statements belonging to a connection to check state transition. The patch introduces per connection statement list.

 

(3) There was also one sprintf not surrounded by an “if” statement.

 

The new functionality is available only for sources compiled with the “fast-validate” option.

 

The patch was accepted by Nick to 2.3.1pre.


Yep, thanks Jan (and Miloslav), it looks like a worthwhile change. So its added to SVN and the 2.3.1pre on the ftp site now.

--
Nick
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev <at> mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
Nick Gorham | 12 Aug 2011 23:36
Favicon

Re: Driver Manager FTP download issues

On 12/08/2011 22:33, Shiva Kamalakkannan wrote:
Greetings

The Driver Manager FTP download location seems to have static issues.

ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.0.tar.gz might be temporarily down or it may have moved permanently to a new web address.

Please let us know if you have alternate mirrors to download the ODBC Driver manager.
 

Many Thanks
Shiva Kamalkannan
Hi,

Seems ok at the moment, can you try again?

--
Nick
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev <at> mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
Cihlar, Jan | 17 Aug 2011 15:36
Favicon

SYSTEM_LIB_PATH set to "conftest"

Hi,

 

I have noticed in 2.3.0 that SYSTEM_LIB_PATH is set to “conftest” which seems to be wrong. The following patch should fix the problem (if I understood the meaning of SYSTEM_LIB_PATH correctly):

 

--- configure.in.orig   2011-08-17 15:18:29.000000000 +0200

+++ configure.in        2011-08-17 15:18:55.000000000 +0200

<at> <at> -152,7 +152,7 <at> <at>

AC_DEFINE_DIR([DEFLIB_PATH], [libdir], [Lib directory])

AC_DEFINE_DIR([LIB_PREFIX], [libdir], [Lib directory])

AC_DEFINE_DIR([SYSTEM_FILE_PATH], [sysconfdir], [System file path])

-AC_DEFINE_DIR([SYSTEM_LIB_PATH], [lib], [Lib path])

+AC_DEFINE_DIR([SYSTEM_LIB_PATH], [libdir], [Lib path])

AC_DEFINE_DIR([PREFIX], [prefix], [Install prefix])

AC_DEFINE_DIR([EXEC_PREFIX], [exec_prefix], [Install exec_prefix])

AC_DEFINE_DIR([BIN_PREFIX], [bindir], [Install bindir])

 

Bye

 

Jan


This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev <at> mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
Nick Gorham | 17 Aug 2011 16:05
Favicon

Re: SYSTEM_LIB_PATH set to "conftest"

On 17/08/11 14:36, Cihlar, Jan wrote:

Hi,

 

I have noticed in 2.3.0 that SYSTEM_LIB_PATH is set to “conftest” which seems to be wrong. The following patch should fix the problem (if I understood the meaning of SYSTEM_LIB_PATH correctly):

 

--- configure.in.orig   2011-08-17 15:18:29.000000000 +0200

+++ configure.in        2011-08-17 15:18:55.000000000 +0200

<at> <at> -152,7 +152,7 <at> <at>

AC_DEFINE_DIR([DEFLIB_PATH], [libdir], [Lib directory])

AC_DEFINE_DIR([LIB_PREFIX], [libdir], [Lib directory])

AC_DEFINE_DIR([SYSTEM_FILE_PATH], [sysconfdir], [System file path])

-AC_DEFINE_DIR([SYSTEM_LIB_PATH], [lib], [Lib path])

+AC_DEFINE_DIR([SYSTEM_LIB_PATH], [libdir], [Lib path])

AC_DEFINE_DIR([PREFIX], [prefix], [Install prefix])

AC_DEFINE_DIR([EXEC_PREFIX], [exec_prefix], [Install exec_prefix])

AC_DEFINE_DIR([BIN_PREFIX], [bindir], [Install bindir])

 

Bye


Yep, that looks about right.

--
Nick
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev <at> mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
Steve Langasek | 23 Aug 2011 08:50
Picon
Favicon

unixodbc-gui-qt 2.3.0 tarball?

Hi there,

The unixODBC 2.3.0 release has been out for some time now, dropping the GUI
tools which are now a separate project
(http://sourceforge.net/projects/unixodbc-gui-qt/).  However,
http://sourceforge.net/projects/unixodbc-gui-qt/files/ says that "this
project has no files", and there are no tags in the svn repo.  Is there a
2.3.0 release tarball for unixodbc-gui-qt available somewhere?  If not, is
there any hope of this happening soon?

Thanks,
--

-- 
Steve Langasek                   Give me a lever long enough and a Free OS
Debian Developer                   to set it on, and I can move the world.
Ubuntu Developer                                    http://www.debian.org/
slangasek <at> ubuntu.com                                     vorlon <at> debian.org
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev <at> mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev

Gmane