DevHeads.net

Database

Watch 2012 Northern Trust Open Live Online TV Stream golf

Watch 2012 Northern Trust Open Live Online TV Stream golf
2012 0Northern Trust Open
Match Scheduled 16-19th February 2012
Pacific Palisades, California
Purse: $6,600,000
PGA Tour
when will start 2012 Northern Trust Open Live streaming online tv golf match.It will be held on 16th February 2012 and end 19th February 2012.And how can watch 2012 Northern Trust Open online streaming live match.In the world 2012 Northern Trust Open golf streaming PGA Tour are famous to all golf faners.
2012 Northern Trust Open Live Online

Watch Porto vs Manchester City Live Stream Free Soccer Online

Watch Porto vs Manchester City Live Stream Free Soccer Online
Porto vs Manchester City
Match Scheduled 16-02-2012 from 3:05pm (US/Eastern)
Location Estádio Do Dragão (Porto)
UEFA Europa League
Porto vs Manchester City team are known to all soccer faners in the world.UEFA Europa League live streaming soccer match Porto vs Manchester City match is very exciting.
Watch Porto vs Manchester City Live

<a href="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/" title="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/">http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stre...</a>

^^**wAtcH^^**Aston Villa vs Manchester City Live Stream Soccer Online February 12, 2012

wAtcH Barclays Premier League between Aston Villa vs Manchester City live stream
Are you looking for Aston Villa vs Manchester City Free live streaming link? Then you have come to the correct place. You can watch a live online stream of Aston Villa vs Manchester City right here. The is no need to look anywhere else. The links for the event appear above.

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

Rule module implementation Bug problem

Hi Dear,
I have a doubt regarding following procedure , it work fine in Article but not
in "Page" creation (I mean the link is not proper), please help me with a
solution , pls follow the steps and try to create an article and basic page
and click the status link , you got my problem .

To display an 'Add More [Content_type]' link after user saves new content, do the following:

1. Go to admin/config/workflow/rules
2. Click Add New Rule
3. At admin/config/workflow/rules/reaction/add, give your new Rule a name, something like

'Add more content link'

Regarding life cycle information of psqlODBC

Hi,

I would like to know the source for obtaining life cycle information of
different versions of psqlODBC.

Thank you

Regards
Saksham Rastogi

psqlodbc driver issue with Win10 Update 1803

After updating their PCs several of our customers have heavy difficulties to
connect to their postgresql servers.

MySQL Cluster 7.6.6 GA has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Paritioning (Sharding) - Read & write scalability
- Transactional consistency across partitioned and distributed datasets
- Parallel cross partition queries such as joins
- Active-Active/Multi-Master geographic replication
- 99.9999% High Availability with on-line maintenance and no single point of
failure
- NoSQL and SQL APIs (including C++, Java

VB6 ODBC

Hello sir's
We want to run A VisiualBasic6 application connected with postgreSQL.
This application was running with Windows XP over many years.
Now the PC must be replaced by W7pro 64bit system.
I have installed postgreSQL 8.4 and psqlodbc_9_00_0310-x64 and later versions.
The W7 ODBC (32bit) datasource administrator does find : PostgreSql30 unicode(x64) source. Connection test ok.

RE: Bug report: x64 Row status Array uses wrong data type

I consider this closed as "bug in implementation by Oracle".

Thank you Clemens and Hiroshi for your time and effort!

Jari Siikarla

Mroonga 8.03 - Fast fulltext search for all languages on,MySQL

Mroonga 8.03 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready. It uses Groonga as a storage
and fulltext search engine.

Document:
<a href="http://mroonga.org/docs/" title="http://mroonga.org/docs/">http://mroonga.org/docs/</a>

How to install: Install Guide
<a href="http://mroonga.org/docs/install.html" title="http://mroonga.org/docs/install.html">http://mroonga.org/docs/install.html</a>

Blog:
<a href="http://mroonga.org/en/blog/2018/05/29/mroonga-8.03.html" title="http://mroonga.org/en/blog/2018/05/29/mroonga-8.03.html">http://mroonga.org/en/blog/2018/05/29/mroonga-8.03.html</a>

Changes:
<a href="http://mroonga.org/docs/news.html#release-8.03" title="http://mroonga.org/docs/news.html#release-8.03">http://mroonga.org/docs/news.html#release-8.03</a>

The main changes are as follows.

Re: NUMERIC type makes trouble in MS Access

Interesting detail: It's not an Access problem.

I've tested it with Python and Libre Office Base. NUMERIC without
precision gets set to 28,6 => like in Access.

Would it perhaps better to use MEMO instead of VARCHAR?
MEMO allows more than 8,000 chars in "Base" and some gigabytes in
Access.

But there's not enough space for an additional toggle switch :(

RE: NUMERIC type makes trouble in MS Access

Here an update:

by default, MS Access sets linked tables with "unlimited" NUMERIC
to DECIMAL with "precision: 28" and "decimals: 6" (MS Access names).
Trying to read a value [INSERT INTO public.demo VALUES (1.0 / 3)]
breaks with an error.

When creating the column using NUMERIC(28, 24), MS Access shows this:
"precision: 28" and "decimals: 24".

Re: NUMERIC type makes trouble in MS Access

Some additional information about supported functions and mappings:

<a href="https://www.devart.com/odbc/postgresql/docs/supported_data_types.htm" title="https://www.devart.com/odbc/postgresql/docs/supported_data_types.htm">https://www.devart.com/odbc/postgresql/docs/supported_data_types.htm</a>
<a href="https://www.devart.com/odbc/postgresql/docs/supported_odbc_api_functions.htm" title="https://www.devart.com/odbc/postgresql/docs/supported_odbc_api_functions.htm">https://www.devart.com/odbc/postgresql/docs/supported_odbc_api_functions...</a>

Does PGSQL-ODBC map NUMERIC the same way (to SQL_NUMERIC)?

MS Access: still having problems with NUMERIC

Hi there,

three months ago I reported a problem when using the ODBC driver
version 10 or higher in connection with Access 2010 with field
type NUMERIC.

Unfortunately I haven't received any feedback yet. Shall I ask
the question again?

Best regards,
Tobias

psqlODBC 10.03.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 10.03.0000.
please see the notes at:
<a href="https://odbc.postgresql.org/docs/release.html" title="https://odbc.postgresql.org/docs/release.html">https://odbc.postgresql.org/docs/release.html</a>

psqlODBC may be downloaded from in source, Windows Installer,
merge module, and basic zip file formats.

New Windows installer installs both 32-bit and 64-bit driver at once
on 64-bit OS.

high cpu on idle state

Sorry to bother if my question is irrelevant
but I really would like to understand why
idle persistent connection would take more than 25% of a cpu

top -c

63844 postgres  20   0 4677440 289168 287320 S  33.9  0.9   0:03.43
postgres: freeswitch freeswitch 10.0.0.1(48634) idle
62774 postgres  20   0 4677480 286488 284636 S  29.9  0.9   1:22.17
postgres: freeswitch freeswitch 10.0.0.228(29664) idle
 4901 postgres  20   0 4677480 280812 278968 S  27.6  0.9   2:43.71
postgres: freeswitch freeswitch 10.0.0.5(39044) idle
 4847 postgres  20   0 4677480 279468 277624 S  24.9  0.8   2:35.25
post

Bug?

Hi,

I noticed high cpu usage with idle connections using

psqlodbc last git version:

10793 postgres  20   0 4677484 329672 327772 S  29.2  1.0 2:21.43
postgres: freeswitch freeswitch 10.0.0.228(50478) idle
12708 postgres  20   0 4677508 323524 321652 S  27.6  1.0 0:49.71
postgres: freeswitch freeswitch 10.0.0.230(56582) idle
12725 postgres  20   0 4677508 329232 327360 R  24.9  1.0 0:52.27
postgres: freeswitch freeswitch 10.0.0.5(6330) SELECT

3 nodes are connected through VPN with tinc, freeswitch is a voip server
that establishes permanent connection.

any idea?

Fedora 26 64bits

po

32-bit odbc source compilation failed

Hi,
We hope this message finds you well.
We are looking for a 32-bit compatible ODBC driver for RedHat Linux 7.4 64 -bit version for connecting 32-bit application to a 32- bit Data Source.
We downloaded the driver 'psqlodbc-10.02.0000.tar.gz' from the URL <a href="https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=https%3a%2f%2fwww.postgresql.org%2fftp%2fodbc%2fversions%2fsrc%2f&amp;umid=76FF58ED-6C26-0805-A753-765F80188BA7&amp;auth=ec34f7633709e8bd85e48c7fc0c92c09c079e558-e50cc6da79abab78c719160d67495dc9ce4fc6f9" title="https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=https%3a%2f%2fwww.postgresql.org%2fftp%2fodbc%2fversions%2fsrc%2f&amp;umid=76FF58ED-6C26-0805-A753-765F80188BA7&amp;auth=ec34f7633709e8bd85e48c7fc0c92c09c079e558-e50cc6da79abab78c719160d67495dc9ce4fc6f9">https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=https%...</a> released on 30-03-2018.

When we try to compile it,which failed with below error.

Build with Oracle Solaris Studio

Hi,

the small patch attached makes psqlodbc buildable using Oracle Solaris
Studio (tested with version 12.3).

Regards,
Maxim

Bug report: x64 Row status Array uses wrong data type

Hi

Thank you for psq odbc driver!

I've found an issue with 64 bit driver.
The array returned from fetch for row statuses uses 16 bit values
instead of 64 bit values.

Tested on x64 Windows (7, 10, srv2012 and srv2016)
with 64 bit psqlodbc-09.06.0500 (Unicode and ANSI)
Client is set ODBC version 2

Changing SQLUSMALLINT to SQLSETPOSIROW in descriptor.h
for two structs and in the code handling these structs fixed the issue.
Code in psqlodbc-10.02.0000 is the same for these parts.

struct IRDFields_
{
StatementClass *stmt;

MySQL Cluster Manager 1.4.6 has been released

Dear MySQL Users,

MySQL Cluster Manager 1.4.6 can be downloaded from
the My Oracle Support (MOS) website.

Problem with ODBC class

Hi, ALL,
Is there a reason why following function returns empty string?

SQLHSTMT stmt = 0;
SQLHDBC hdbc = 0;
int result = 0;
SQLLEN cbTableName = SQL_NTS, cbSchemaName = SQL_NTS;
SQLWCHAR *table_name = NULL, *schema_name = NULL, *qry = NULL;
SQLWCHAR *owner = NULL;
std::wstring query;
if( pimpl->m_subtype == L"PostgreSQL" )
query = L"SELECT u.usename FROM pg_class c, pg_user u,
pg_namespace n WHERE n.oid = c.relnamespace AND u.usesysid =
c.relowner AND n.nspname = ?

MySQL for Visual Studio 1.2.8 has been released

Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the release
of MySQL for Visual Studio 1.2.8.

This is a maintenance release for 1.2.x.

Mroonga 8.02 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.02 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

ODBC 2.0 Bug: wrong timestamp data type

Hello!

I used the latest driver version
(psqlodbc_10_02_0000-x64.zip).
If your application uses ODBC version 2.0. When you
call SQLGetTypeInfo, the driver reports supported data
types that are not available for version 2.0. The first
iteration of the result of this function for the timestamp
data type is SQL_TYPE_TIMESTAMP. If you then call
SQLBindParameter, ODBC Manager returns s1003 (SQL1).log).
The error could be corrected (SQL2.log).

bigint disparity between two installations

I have a database on PostgreSQL 9.3 that I am accessing using psqlodbc
version 9.03.04.00 on a couple of different Windows machines.

I have some bigint fields that are truncated on only one of the machines.
I have called both of their odbc setups up and compared them screen by
screen a few times and they are setup the same.

A value that is stored in the database is: -40581311272
This value is read correctly on two of the machines, but is returned as
-405813112 on the third.

Registering DSN with odbcconf.exe overwrites the connection attributes with defaults

With the following command, the SSLmode of the DSN is defaults to disable,
even the "prefer" option is provided in the connection attributes.

odbcconf.exe /A {CONFIGDSN "PostgreSQL Unicode(x64)"
"DSN=test3|SSLmode=prefer"}

During the configDSN, first the connection attributes are parsed in
ParseAttributes function and later all the values are replaced with
defaults using getCiAllDefaults.

ODBC - psqlodbc-7.2.3

Hi,

I am not sure when i compiler the source using make, it failed. it worked fine when in execute the configure command.

I can't use the latest release. it does not work for me on the Solaris 10.

root@m# ./configure

checking for a BSD-compatible install... ./install-sh -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... nawk
checking whether make sets ${MAKE}... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for gcc... gcc
checking for C compiler default output...

MySQL Cluster 7.6.5-dmr has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geographic replication

- 99.999% High Availability with no single point of failure
and on-line maintenance
- NoSQL and SQL APIs (including C++, Java, http, Memcached
and JavaScript/Node.js)

MySQL Cluster 7.6.5-dmr, has been released and can be downloaded from

<a href="http://www.mysql.com/dow" title="http://www.mysql.com/dow">http://www.mysql.com/dow</a>

MySQL Cluster 7.4.20 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.4 makes significant advances in performance;
operational efficiency (such as enhanced reporting and faster restarts
and upg

MySQL Cluster 7.5.10 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.5.10, has been released and can be downloaded from

  <a href="http://www.mysql.com/dow" title="http://www.mysql.com/dow">http://www.mysql.com/dow</a>

MySQL Cluster 7.3.21 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.3.21, has been released and can be downloaded from

<a href="http://www.mysql.com/downloa" title="http://www.mysql.com/downloa">http://www.mysql.com/downloa</a>

MySQL Connector/Python 8.0.11 has been released

Dear MySQL users,

MySQL Connector/Python 8.0.11 is the first GA release version
of the MySQL Connector Python 8.0 series. This series adds support for
the new X DevAPI. The X DevAPI enables application developers to write
code that combines the strengths of the relational and document models
using a modern, NoSQL-like syntax that does not assume previous
experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/" title="http://dev.mysql.com/doc/x-devapi-userguide/en/">http://dev.mysql.com/doc/x-devapi-userguide/en/</a>.

MySQL Connector/Net 8.0.11 has been released

Dear MySQL users,

MySQL Connector/Net 8.0.11 is the first general availability release of
MySQL Connector/Net to add support for the new X DevAPI. The X DevAPI
enables application developers to write code that combines the strengths
of the relational and document models using a modern, NoSQL-like syntax
that does not assume previous experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

MySQL Connector/C++ 8.0.11 GA has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.11 is the first GA release version of the
MySQL Connector/C++ 8.0 series.

Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries.

MySQL Connector/ODBC 8.0.11 GA has been released

Dear MySQL users,

MySQL Connector/ODBC 8.0.11 is the first GA version of the MySQL
Connector/ODBC 8.0 series, the ODBC driver for the MySQL database
management system.

The available downloads include both a Unicode driver and an ANSI
driver based on the same modern codebase. Please select the driver
type you need based on the type of your application - Unicode or ANSI.
Server-side prepared statements are enabled by default. It is suitable
for use with any MySQL server version from 5.5.

This release of the MySQL ODBC driver is conforming to the ODBC 3.8
specification.

MySQL Community Server 5.6.40 has been released

Dear MySQL users,

MySQL Server 5.6.40, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.40 is
recommended for use on production systems.

For an overview of what's new in MySQL 5.6, please see

<a href="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html" title="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html">http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html</a>

Starting with 5.6.11, Microsoft Windows packages for MySQL 5.6
are available both as a "full" installer and as a "web" installer.
The full installer is significantly larger and comes bundled with
the latest software releases available.

MySQL Workbench 8.0.11-rc has been released

Dear MySQL users,

The MySQL developer tools team announces 8.0.11 as our release candidate (RC) for
MySQL Workbench 8.0.

For the full list of changes in this revision, visit
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html">http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html</a>

For discussion, join the MySQL Workbench Forums:
<a href="http://forums.mysql.com/index.php?152" title="http://forums.mysql.com/index.php?152">http://forums.mysql.com/index.php?152</a>

The release is now available in source and binary form for a number
ofplatforms from our download pages at:

<a href="http://dev.mysql.com/downloads/tools/workbench/" title="http://dev.mysql.com/downloads/tools/workbench/">http://dev.mysql.com/downloads/tools/workbench/</a>

Enjoy!

Changes in MySQL Workbench 8.0.11 (2018-04-19, Release Candidate)

* Functionality Added or Chang

MySQL Community Server 5.7.22 has been released

Dear MySQL users,

MySQL Server 5.7.22, a new version of the popular Open Source
Database Management System, has been released.

MySQL Enterprise Backup 8.0.11 has been released

Dear MySQL users,

MySQL Enterprise Backup 8.0.11, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS)
website
as our latest GA release. This release will be available on eDelivery
(OSDC)
after the next upload cycle.

MySQL Community Server 8.0.11 has been released (part 2/2)

[This is part 2 of the announcement]

     * Replication: A new system variable rpl_read_size is
       available to set the minimum amount of data in bytes that
       is read from the binary log files and relay log files.
       The default read size is 8KB.

MySQL Community Server 8.0.11 has been released (part 1/2)

[Due to size limitations, the announcement is split in 2 parts. This is
part 1.]

Dear MySQL users,

MySQL Server 8.0.11 (GA) is a new version of the world's
most popular open source database. This is the first official release
of MySQL 8.0.

The new features in this release are now deemed to be of Release quality.

Note that 8.0.11 includes all features in MySQL 5.7 and previous 8.0
Development Milestone Releases.

Deadlock when executing multiple select statements from multiple threads

Hello,

We are having a deadlock issue when executing multiple select statements from multiple threads, the issue happens with driver version (9.6.4.0) or newer, doesn't happen on 9.6.3.1 .
I've attached a simple project that triggers the deadlock, tested with visual studio 2017, release x64 build, PostgreSQL 10.3, usually happens after few runs.[please note that the proper database connection string and the table names need to be provided in the code for it to work].
I've also included the stack trace of the two threads in deadlock.

Regards,
Ayman

Re: [ANNOUNCE] psqlODBC 09.06.0500 Released

Buongiorno,

Vedi allegato e di confermare.

Grazie e a presto,
Sebastiano.

 

Sebastiano SchiaviDirettore Generaleseba. ... at sixs dot it SIxS - Soluzioni Informatiche per il SocialeVia Sant'Antonino 41 - Vaiano Cremasco (CR)Tel.0373 386177 – Fax 0373 380216Cell. 3939147485www.sixs.it Informativa privacy: Le informazioni contenute nella presente comunicazione e i relativi allegati possono essere riservati e sono comunque destinati esclusivamente alle persone o alla Società sopraindicati e non sono da considerarsi comunicazioni personali.

MySQL optimization for testing purpose

Hi all,

Looking for some configuration tips to speed execution of our non-regression tests with MySQL.

We do pure functional testing, data persistence is not critical.

Our tests are not using a lot of data, but we create and drop a lot of test tables.

We have concurrency tests (processes locking rows), so this feature matters.

Are there some InnoDB params to enable or disable to speed up our tests?

Some tests behave a bit strange, sometimes one of our test takes 1 min 30 secs, sometimes
it takes only 15 seconds...

How can this happen?

Any log I could enable and provide here?

Thanks in

SSL connection string documentation

Example of pqopt on 3rd screen: sslroot=c:\\root.crt
Example of pappy in connection string:
pqopt={sslroot=c:/root.crt}
Could you please post drove me crazy trying to figure it out.

psqlODBC 10.02.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 10.02.0000.
please see the notes at:
<a href="https://odbc.postgresql.org/docs/release.html" title="https://odbc.postgresql.org/docs/release.html">https://odbc.postgresql.org/docs/release.html</a>

psqlODBC may be downloaded from in source, Windows Installer,
merge module, and basic zip file formats.

New Windows installer installs both 32-bit and 64-bit driver at once
on 64-bit OS.

Mroonga 8.01 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.01 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready. It uses Groonga as a storage
and fulltext search engine.

Document:
<a href="http://mroonga.org/docs/" title="http://mroonga.org/docs/">http://mroonga.org/docs/</a>

How to install: Install Guide
<a href="http://mroonga.org/docs/install.html" title="http://mroonga.org/docs/install.html">http://mroonga.org/docs/install.html</a>

How to upgrade: Upgrade Guide
<a href="http://mroonga.org/docs/upgrade.html" title="http://mroonga.org/docs/upgrade.html">http://mroonga.org/docs/upgrade.html</a>

Blog:
<a href="http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html" title="http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html">http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html</a>

Changes:
<a href="http://mroonga.org/docs/news.html#release-8.01" title="http://mroonga.org/docs/news.html#release-8.01">http://mroonga.org/docs/news.html#release-8.01</a>

In this release, Mroonga requires latest Groonga 8.0.1 to fix bugs.

Postgres Foreign Data Wrapper and DB2 LUW

Is there a web page describing how to set up a PG FDW to talk to DB2 LUW ver 10.5 ?

Thanks.

How to get the MySQL Command-Line Tool to display Unicode properly?

Five months ago I posted the query shown below on StackOverflow.  I got
one reply which was not of much help.  So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.

Roger House

How to get the MySQL Command-Line Tool to display Unicode properly?

I use a Python program to write text containing Unicode characters to a
MySQL database. As an example, two of the characters are

|u'\u2640' a symbol for Venus or female u'\u2642' a symbol for Mars or male |

I use utf8mb4 for virtually all character sets involved with MySQL.

MySQL Connector/Java 5.1.46 GA has been released

Dear MySQL Users,

MySQL Connector/J 5.1.46, a maintenance release of the production 5.1
branch has been released. Connector/J is the Type-IV pure-Java JDBC
driver for MySQL.

MySQL Connector Java is available in source and binary form from the
Connector/J download pages at
<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>
and mirror sites as well as Maven-2 repositories.

MySQL Connector Java (Commercial) is already available for download on the
My Oracle Support (MOS) website.

Compilation fails with XLC in AIX

Hi,

I am compiling PostgreSQL ODBC driver 10.01.0000 in AIX using XLC compiler.
Compilation fails with the following error.

ld: 0711-317 ERROR: Undefined symbol: .getExeName
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.
Makefile:573: recipe for target 'psqlodbcw.la' failed
gmake[1]: *** [psqlodbcw.la] Error 8
gmake[1]: Leaving directory
'/home/root/postgres_source/psqlodbc-10.01.0000'
Makefile:479: recipe for target 'all' failed
gmake: *** [all] Error 2

getExeName is no more there after this commit "Move the implemetation of
GetExeName() from psqlodbc.c(psq

Lost Data Connection

I have been successfully using the following PostgreSQL connection string in multiple Excel 2010 vba applications running on 64 bit Windows 7 systems. I have moved to a Window 10 system and my application will randomly lose its connection to the DSN. It may take 5000 calls one time and then 400 calls the next. I am using a Unicode driver. I wrote a sample program that makes the same call in a loop. The code will randomly fail on Window 10 and run flawlessly on Window 7.

ANN: Upscene releases Database Workbench 5.4.2

Upscene releases Database Workbench 5.4.2

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.4.2 “

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL.

Out of operation records in local data manager far below MaxNoOfConcurrentOperations

Hi,

we run a MySQL-Cluster, currently version 7.4.15, where we get "Out of
operation records in local data manager" at approximately 55000 rows
updated or deleted in one transaction,
even though MaxNoOfConcurrentOperations=300000.

Any ideas, why 300000 operation records are not enough for 55000 rows?

regards,
Hendrik Woltersdorf

FinTech Group AG
Peter-Breuer-Str.

ODBC embedded Postgres

Hello,

We have an embedded Postgres database installed along with Vcenter Vmware
app. We wanted to connect it with ODBC connection, Is it possible? If yes,
what version of ODBC i need to install and are there any changes we will
need to make on Postgres SQL side?

Procedure error handling Best Practice

Long time Oracle PL/SQL coder but new to MySQL.

I have an error handler that looks like this ...

declare continue handler for sqlexception
begin
get diagnostics condition 1 @p3 = returned_sqlstate, @p4 = message_text;
set v_there_was_an_error_while_inserting_a_lead_summary := true;

insert into rit.rit_audit_message(severity,
message,
process_name,

summary_detail_map,
createdby2qmp_user,

Silent MALLOC/REALLOC error

Hello, psqlODBC team.

When we fetch large data via psqlodbc, we sometimes fail to
get all rows completely without any API's error responses;
SQLExecDirect returns SQL_SUCCESS and SQLFetch returns just SQL_NODATA.
But there are QR_REALLOC_error reported in mylog at that time.

I reproduced it by tweaking QR_REALLOC_return_with_error macro
to intentionally fail to allocate memory frequently.

MySQL Connector/C++ 8.0.7-rc has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.7-rc is the release candidate (RC)
of the MySQL Connector/C++ 8.0 series.

Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries.

DBLink problem between Oracle and PostGreSQL

Dear all,

I'm not sure if it is the correct address to send this king of request,
but we are currently struggling with a problem between Oracle and
PostGreSQL, passing through ODBC, so I take my change.
The situation is the following:
. On Oracle side:
 - Windows Server 2012 R2
 - Oracle 11g r2 (11.2.0.1.0)

. On PostGreSQL:
 - PostgreSQL 9.4.13
 - No details on servers or configuration, we don't have access to this.

. ODBC PostGreSQL Drivers 10.01.00.00

=> The problem is the following:
. We are currently unable to use a DBLink from Oracle to PostGreSQL, via
ODBC.

Syndicate content