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'

Migration to PGLister - After

Greetings!

This list has now been migrated to new mailing list software known as
'PGLister'.

Migration to pglister - Before

Greetings,

We will be migrating these lists to pglister in the next few minutes.

This final email on the old list system is intended to let you know
that future emails will have different headers and you will need to
adjust your filters.

The changes which we expect to be most significant to users can be found
on the wiki here: <a href="https://wiki.postgresql.org/wiki/PGLister_Announce" title="https://wiki.postgresql.org/wiki/PGLister_Announce">https://wiki.postgresql.org/wiki/PGLister_Announce</a>

Once the migration of these lists is complete, an 'after' email will be
sent out.

Thanks!

Stephen

BUG: odbc statement_timeout gets set to 30000

Hi All

I've found a problem with at least the 906 and 1000 odbc driver, in that, no
matter what statement_timeout is set to, after initially connecting and
setting the value to that specified in the connection settings, it is then
subsequently set to 30000.

This means that queries running longer than 30seconds are failing, which is
a major problem.

session_timeout being set to 30000 bug

Hi All

OK,I've been trying out the later odbc drivers, 906 and 1000.

MySQL Workbench 6.3.10 GA has been released

Dear MySQL users,

The MySQL developer tools team announces 6.3.10 as our GA release for
MySQL Workbench 6.3.

For the full list of changes in this revision, visit
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html">http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.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>

Download MySQL Workbench 6.3.10 GA now, for Windows, macOS 10.11+,
Oracle Linux 7, Fedora 26 and 27, Ubuntu 16.04 and 17.10
or sources, from:

<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 6.3.10 (2017-11-15)
Bugs Fixed

* Performance

API changes report for MySQL Connector/J

Hi,

I'd like to share report on API changes and backward compatibility for the MySQL Connector/J library: <a href="https://abi-laboratory.pro/java/tracker/timeline/mysql-connector-java/" title="https://abi-laboratory.pro/java/tracker/timeline/mysql-connector-java/">https://abi-laboratory.pro/java/tracker/timeline/mysql-connector-java/</a>

BC — binary compatibility
SC — source compatibility

The report is generated by the <a href="https://github.com/lvc/japi-tracker" title="https://github.com/lvc/japi-tracker">https://github.com/lvc/japi-tracker</a> tool for jars at <a href="http://central.maven.org/maven2/mysql/mysql-connector-java/" title="http://central.maven.org/maven2/mysql/mysql-connector-java/">http://central.maven.org/maven2/mysql/mysql-connector-java/</a>. The tool checks for API changes according to the article <a href="https://wiki.eclipse.org/Evolving_Java-based_APIs_2" title="https://wiki.eclipse.org/Evolving_Java-based_APIs_2">https://wiki.eclipse.org/Evolving_Java-based_APIs_2</a>.

Hope it will be helpful for users and maintainers of the library.

Thank you.

Trying to replicate from MS 2008 R2 to PostgreSQL

I have a project where I am trying to replicate some tables from a MS2008 SQL database to a PostgreSQL database. I have created a Linked Server using the PostgreSQL ANSI driver and the connection tests successfully. But when I try to create a subscription using that Linked Server, I cannot connect successfully to it. I was wondering if you might have some insights into possible avenues of research for this problem.

Problem with ODBC v.10

Hello,

We use msaccess that connects to postgresql database with your ODBC driver

With the new version 10.0, something does not work anymore :

When we create a new record in a table with the dao method tb.addnew

Then we want to get the Autonumber generated, we used to add tb.update
and tb.Bookmark=tb.LastModified and then we were able to get the
tb!MyAutoNumberField value

Now this does not wok anymore and we get The record is deleted

(note that with MSAccess database we can get the autonumber before the
tb.update)

I saw that you have changed things with Identity...

SQL ODBC Interface Developer opportunity in Livermore CA

SQL Database ODBC Developer

Convergence CT (www.convergencect.com<http://www.convergencect.com>) is a global health information company founded in 2001
and based in Honolulu Hawaii with the goal of connecting technologies to manage and use big data
to the benefit of patients, healthcare providers, researchers, and life science companies.

SQL ODBC interface developer opportunity in Livermore CA

SQL ODBC Interface Developer position

Convergence CT (<a href="http://www.convergencect.com" title="www.convergencect.com">www.convergencect.com</a>) is a global health information company founded in 2001 and based in Honolulu Hawaii with the goal of connecting technologies to manage and use big data to the benefit of patients, healthcare providers, researchers, and life science companies. CCT has implemented over 27 clinical data warehouse systems for 76 hospitals and medical groups in Japan, Taiwan, China, Canada and the United States.

monitoring mysql performance

Hi,

I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with
MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using
innodb.

So I´m thinking of ways of improving MySQL performance and of course
for that, you need to measure.

Currently I´m checking, there are no slow queries and read and writes
perform well.

Mroonga 7.07 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.08 has been released!

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

ANN: Upscene releases Database Workbench 5.3.4

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

" Database Workbench 5.3.4 "

This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

"Version 5 included many new features", says Martijn Tonies, founder of Ups

MySQL Connector/Net 6.9.10 has been released

Dear MySQL users,

MySQL Connector/Net 6.9.10 is a maintenance release for the 6.9.x
series of the .NET driver for MySQL.

ANN: Stored routine debugger Hopper, version 2.0 released

Dear ladies and gentlemen,

Upscene Productions is proud to announce version 2 of "Hopper", a stored
routine debugger for InterBase, Firebird and MySQL.

This version includes support for Firebird 3 packages and stored functions,
MySQL diagnostic-statements, binary data in variables and much more.

For more information, check the Hopper page on this website. <a href="http://www.upscene.com/stored_procedure_debugger/" title="http://www.upscene.com/stored_procedure_debugger/">http://www.upscene.com/stored_procedure_debugger/</a>

About Hopper
Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase.

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.  Here is
an excerpt from /etc/mysql/my.cnf

    [client]
    default-character-set=utf8mb4

    [mysql]
    default-character-set=utf8mb4

    [mysqld]
    character-set-server =utf8mb4

I'm not sure that the [client] option does anything, but it doesn't seem to
hurt.

In addition, all tables are created wi

MySQL Cluster 7.3.19 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.19, has been released and can be downloaded from

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

MySQL Cluster 7.4.17 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.8 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.8, has been released and can be downloaded from

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

MySQL Community Server 5.6.38 has been released

Dear MySQL users,

MySQL Server 5.6.38, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.38 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 Community Server 5.7.20 has been released

Dear MySQL users,

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

psqlODBC 10.00.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 10.00.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 7.07 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.07 has been released!

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

error with $ in names again

Hi,

I think there’s still a bug in parsing names with dollars.

Linux RHEL66

UseServerSidePrepare=0:

create table T$001 (…) ok

create table T_$001 (…) ok

UseServerSidePrepare=1:

create table T$001 (…) ok

create table T_$001 (…) error

Here is session log for that:

$ test_odbc 0 'T$001'

Connection: DSN=PGDriver;UseServerSidePrepare=0

Returned connection string was: …;UseDeclareFetch=0;…;Parse=0;…;UseServerSidePrepare=1;LowerCaseIdentifier=0;

Exec: create table T$001 (i integer)

ok

$ test_odbc 1 'T$001'

Connection: DSN=PGDriver;UseServer

Last established connection timestamp by a specific user

Hi,

We have a MySQL instance which is currently running on version `5.7.11-enterprise-commercial-advanced-log`.

please advise

Hello.

I'm new to postgresql but would like to be a database developer.

What's the best way to join postgresql team as a volunteer?

Question about contributing a patch

Hello,I reported a bug, at <a href="https://bugs.mysql.com/bug.php?id=87637" title="https://bugs.mysql.com/bug.php?id=87637">https://bugs.mysql.com/bug.php?id=87637</a>, as well as a patch. And Bogdan, the bug hunter, told me this patch would show up on the dev contribution report. So, could anyone please tell me how to contact dev team, or how can I know the progress about integrating the patch. By the way, I signed Oracle Contributor Agreement.
Any reply would be a great help.
Thanks, sincerely
Xiaoyu

ODBC driver for Postgres Installation error

Hello,
I will be really grateful if you can guide me on how to install and use Postgres ODBC Driver for Windows 64 system.

I have downloaded psqlodbc_09_06_0500-x64.msi from from <a href="https://www.postgresql.org/ftp/odbc/versions/msi/" title="https://www.postgresql.org/ftp/odbc/versions/msi/">https://www.postgresql.org/ftp/odbc/versions/msi/</a> . Unfortunately, after finishing up all the installation at last step of registering the product, the installation package runs into error and rolls back everything.
The message says "The Installer has encountered an unexpected error installing this package. This may indicate a problem with this package.

JDBC ZonedDateTime problem

Greeings,

I am using PostgreSQL 9.3.19 on a 64 bit Linux box with
postgresql-42.1.4.jar and 64 bit Java 8.

I am doing setObject with ZonedDateTime.now(ZoneOffset.UTC) and I get:

org.postgresql.util.PSQLException: Can't infer the SQL type to use for an
instance of java.time.ZonedDateTime. Use setObject() with an explicit Types
value to specify the type to use.

What I am trying to do is set the column to the current datetime UTC.

Any help would sure be appreciated!

Blake McBride

ODBC binary downloads -- SHA256sums?

Trying to figure out how to validate my downloads.

postgresql install odbc driver

hello!

Centos 7.0
install 9.2 driver psqlodbc-09.02.0100.tar.gz
./configure

checking for dlopen... no
checking for dlopen in -ldl... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... yes
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
checking for library containing SQLGetPrivateProfileString...

install ODBC driver

hello!

install 9.5 driver
./configure

install 9.2 driver
./configure

祝好!

互联网ITS集团,流通线.行业BU 魏磊
电话:029-89633928
地址:陕西省 西安市 雁塔区 天谷八路 中软基地

MySQL Shell 8.0.3-dmr has been released

Dear MySQL users,

This is the second development release version of MySQL Shell 8.0
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Router 8.0.3-dmr has been released

Dear MySQL users,

MySQL Router 8.0.3 dmr is the first development release for
MySQL Router 8.0 series.

The MySQL Router is a new building block for high availability
solutions based on MySQL InnoDB clusters.

By taking advantage of the new Group Replication technology,
and combined with the MySQL Shell, InnoDB clusters provide an
integrated solution for high availability and scalability for
InnoDB based MySQL databases, that does not require advanced MySQL
expertise.

The deployment of applications with high availability requirements
is greatly simplified by MySQL Router.

ODBC connectin string for Postgres db needed

Hi,

Is this a good contact to obtain the connection string to a Postgres database? We would like to connect to Postgres from Cognos 10.2 /Framework Manager.

Thanks so much in advance for any assistance that you can bring us.

Challenge Accepted!

Gonzalo Ordonez
HRIS Administrator
SOS International LLC
1881 Campus Commons Drive, Suite 500
Reston, VA 20191
o. 703.391.9680, ext. 1051 | d. 703.774.1836 | f.

MySQL Connector/Net 8.0.9-dmr has been released

Dear MySQL users,

MySQL Connector/Net 8.0.9 is the sixth development release that expands
cross-platform support to Linux and macOS when using Microsoft's .NET Core
framework. Now, .NET developers can use the X DevAPI with .NET Core and
Entity Framework Core (EF Core) 1.0 to create server applications that run
on Windows, Linux and macOS. We are very excited about this change and
really look forward to your feedback on it!

MySQL Connector/Net 8.0.9 is also the eighth development release of MySQL
Connector/Net to add support for the new X DevAPI.

MySQL Connector/Java 8.0.8-dmr has been released

Dear MySQL users,

MySQL Connector/J 8.0.8 Development Release is a development milestone
release for the 8.0.x series.

This release includes the following new features and changes, also
described in more detail on

<a href="https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-8.html" title="https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-8.html">https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-8.html</a>

MySQL Connectors and other MySQL client tools and applications now
synchronize the first digit of their version number with the (highest)
MySQL server version they support.
This change makes it easy and intuitive to decide which client version
to use for which server version.

As always, we recommend that you c

MySQL Connector/Python 8.0.5 DMR has been released

Dear MySQL users,

MySQL Connector/Python 8.0.5 dmr is the sixth development release 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>.

Severe bug in SQLPrimaryKeys function in psqlODBC 09.06.0500

Hello,

there seems to be a new bug in the SQLPrimaryKeys function - e.g.

MySQL Connector/C++ 8.0.6-dmr has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.6-dmr is the next development milestone release
(dmr) 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.

A question about Oracle Contributor Agreement

Hi, I signed Oracle Contributor Agreement about a month ago, but have not got a response. I reported a bug, but I can not contribute my patch. So, could anyone please tell me how long will it take before I am informed? Thanks, sincerely

MySQL Community Server 8.0.3-rc has been released (part 2/2)

[This is part 2 of the announcement]

Bugs Fixed

* Incompatible Change; JSON: If a JSON object contained
multiple members with the same key name, MySQL kept the
first member and discarded the remainder.

MySQL Community Server 8.0.3-rc has been released (part 1/2)

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

Dear MySQL users,

MySQL Server 8.0.3-rc (Release Candidate) is a new version of the world's
most popular open source database.

Omit another where clause from original query

I have a working query:

/* start */

SELECT
u.user_id,
u.first_name AS u_first_name,
u.last_name AS u_last_name,
c.client_id AS c_client_id,
c.first_name AS c_first_name,
c.middle_name AS c_middle_name,
c.last_name AS c_last_name,
c.address AS c_address,
c.city AS c_city,
c.state AS c_state,
c.zip AS c_zip,
c.dob AS dob_ymd,
c.phone_home AS c_phone_home,
c.phone_cell AS c_phone_cell,
c.phone_work AS c_phone_work,
c.email AS c_email,
c.other_contacts AS c_other_contacts,
count(*) AS apt_qty

FROM tl_appt apt

JOIN tl_clients c ON c.client_id = apt.client_id
JOIN tl_rooms r

Mysql: desc table -> JDBC rs.getString("COLUMN_SIZE")

Hello,
I have the following table in MySQL:

mysql> desc VEREIN;
+---------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+----------------+
| V_ID | int(11) | NO | PRI | NULL | auto_increment |
| Name | varchar(50) | NO | | NULL | |
| Strasse | varchar(50) | YES | | NULL | |
| O_ID | int(11) | YES | MUL | NULL | |
+---------+-------------+------+-----+---------+----------------+
4 rows

Error Notification

Dear Support,

Most recent version of PostgreSQL ODBC Driver that we are using it for GreenPlum v 4.3.9.1 is throwing error when character varying <255 within the linked SQL Server.

ODBC for Linux/RHEL - no 9.6.5 binary build yet?

Hi,

I’ve been checking <a href="https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/" title="https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/">https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/</a>

and while many components were updated to 9.6.5, the latest ODBC is still 9.6.4.1:

postgresql96-odbc-09.06.0410-1PGDG.rhel6.x86_64.rpm.

Any plans for updating it?

Thank you.

Georgiy Pruss

ANN: DAC for MySQL 3.2.0-alpha is out!

MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also
known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct
connect to MySQL database server.

innodb_read_only issues

I've followed the instructions at
<a href="https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html" title="https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html">https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html</a>

Which starts with:

14.6.2 Configuring InnoDB for Read-Only Operation

You can now query InnoDB tables where the MySQL data directory is on
read-only media, by enabling the --innodb-read-only configuration option
at server startup.

Exactly what I want to do.

However the server bails out trying to create files.

2017-09-07T02:12:33.688368Z 0 [Note] InnoDB: Started in read only mode
2017-09-07T02:12:33.688405Z 0 [Note] InnoDB: Mutexes and rw_locks use
GCC atomic builtins
2017-09-07T02:12:3

psqlODBC 09.06.0500 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 09.06.0500.
This is a some bugfix release.
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.

SQL literal with SJIS hankaku-kana character cause missing escape

Hello, psqlODBC team.

We got a bug.
Its reproduce program and log are attached.

An SQL string that contains string leteral ended odd number of
SJIS hankaku-kana character could cause misssing the next escape.

We haven't fixed it yet.

best regards,
Haruka Takatsuka / SRA OSS, Inc. <a href="http://www.sraoss.co.jp" title="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a>

Storing default value for incorrect timestamps

Hi,

Below is my current mysql setup:
Version: 5.7
sql_mode=''
time_zone=SYSTEM
system_time_zone=PDT
Table 'test' with 2 columns:
+-------------+-----------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------+------+-----+---------------------+-------+
| Roles | int(11) | NO | PRI | NULL | |
| DateUpdated | timestamp | NO | | 0000-00-00 00:00:00 | |
+-------------+-----------+------+-----+---------------------+-------+

When I use mysql command line client to ins

Compilation failure with nmake since 503bb09

Hi all,

With the latest code of Postgres ODBC, I am seeing compilation
failures of this kind:
c:\Users\ioltas\git\pgodbc\connection.h(27) : fatal error C1083:
Cannot open include file: 'pqexpbuffer.h': No such file or directory

It seems to me that 503bb09 forgot to update win64.mak to include
$(PG_INC)/internal in the paths to scan for headers. Please see
attached a patch.

Regards,

Bug in PostgreSQL ODBC - in names with dollar

Hi,

I’m sorry, I really tried to register at pgsql-odbc list at postgresql.org, using different email addresses, but it didn’t’ work.

I saw that you may deal with this problem.

When UseServerSidePrepare is set to 1 (which is default, I guess), any names with $ in them cause error:

“The # of binded parameters < the # of parameter markers”

It’s both on Windows and Linux.

It seems that PG tries to use un-paired ‘$’ symbols as parameter marks for the server-side prepare/execute feature, even if there’s no PREPARE or EXECUTE statements.

I believe, PG should not par

Potential memory leak in java driver

Hi,

I was debugging a OOM isssue with our application server using MySQL
community driver version *5.1.41*, 1G heap which was running for approx 5
days. When heap dump was analyzed it was found that almost all the space
was consumed by mysql NonRegisteringDriver class and specifically a field
named connectionPhantomRefs.

We are using maxLifeTime of 7 Mins (Default is 30 mins), and min
connections at anypoint is 40 on single server instance. My guess is since
we are killing connection every 7 minutes so 24*60*60/7 = 12342 connections
per day.

Mroonga 7.06 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.06 has been released!

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

Syndicate content