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'

MySQL Community Server 5.7.18 has been released

Dear MySQL users,

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

MySQL Community Server 5.5.55 has been released

Dear MySQL users,

MySQL Server 5.5.55 is a new version of the 5.5 production release
of the world's most popular open source database. MySQL 5.5.55 is
recommended for use on production systems.

MySQL 5.5 includes several high-impact enhancements to improve the
performance and scalability of the MySQL Database, taking advantage of
the latest multi-CPU and multi-core hardware and operating systems.

MySQL for Visual Studio 1.2.7 has been released

Dear MySQL users,

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

This is a maintenance release for 1.2.x.

MySQL Community Server 5.6.36 has been released

Dear MySQL users,

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

ANN: DAC for MySQL 3.1.0 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.

Mroonga 7.01 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.01 has been released!

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

COLUMN_SIZE for bytea now equals -4 (09.05 vs 09.06)

Hi,

I noticed Ubuntu 12.04 package odbc-postgresql updated
from 09.05.0400 to 09.06.0200.

Since then, a 'bytea` column info obtained with SQLColumns
no longer reports COLUMN_SIZE larger than 0, but equal to -4.
AFAIU, -4 means SQL_NO_TOTAL.

Which change in the release notes corresponds to that?
<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>

Is it this one?

18. Change the default of ByteaAsLongVarBinary from 0 to 1

Best regards,

seeing errors

While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.

when it finished I used the command "show warnings," but only one
warning showed (the last one).

How can I see the warnings earlier in the load ?

-bill

MySQL Connector/C++ 2.0.4 m2 has been released

Dear MySQL users,

MySQL Connector/C++ 2.0.4 is the next development milestone of the MySQL
Connector/C++ 2.0 series. Connector/C++ 2.0 can be used to access MySQL
implementing Document Store or in a traditional way, using SQL queries.
It allows writing both C++ applications using X DevAPI or plain C
applications using XAPI.

To learn more about how to write applications using X DevAPI, see X
DevAPI User Guide (<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>) and
X DevAPI reference at
<a href="https://dev.mysql.com/doc/dev/connector-cpp/devapi_ref.html" title="https://dev.mysql.com/doc/dev/connector-cpp/devapi_ref.html">https://dev.mysql.com/doc/dev/connector-cpp/devapi_ref.html</a>.

MySQL Connector/Net 7.0.7 m6 has been released

Dear MySQL users,

MySQL Connector/Net 7.0.7 is the fourth development release that expands
cross-platform support to Linux and OS X 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 OS X. We are very excited about this change and
really look forward to your feedback on it!

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

MySQL Connector/Java 6.0.6-m5 has been released

Dear MySQL users,

MySQL Connector/J 6.0.6 m5 Development Release is a developer milestone
release for the 6.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/6.0/en/news-6-0-6.html" title="https://dev.mysql.com/doc/relnotes/connector-j/6.0/en/news-6-0-6.html">https://dev.mysql.com/doc/relnotes/connector-j/6.0/en/news-6-0-6.html</a>

As always, we recommend that you check the "CHANGES" file in the download
archive to be aware of changes in behavior that might affect your application.

To download MySQL Connector/J 6.0.6 m5, see the "Development
Releases" tab at <a href="http://dev.mysql.com/downloads/connector/j/" title="http://dev.mysql.com/downloads/connector/j/">http://dev.mysql.com/downloads/connector/j/</a>

Enjoy!

Changes in MySQL Connector/J

psqlODBC 09.06.0200 Released

Hi, all.

We are release of psqlODBC 09.06.0200. 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.

MySQL Connector/NodeJS 1.0.6 M5 has been released

Dear MySQL users,

MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI.

MySQL Cluster Manager 1.4.2 has been released

Dear MySQL Users,

MySQL Cluster Manager 1.4.2 has been released and can be downloaded
from the My Oracle Support (MOS) website.

MySQL Router 2.1.2 RC has been released

Dear MySQL users,

MySQL Router 2.1.2 RC is a release candidate for MySQL Router 2.1.

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.

MySQL Connector/J 5.1.41 has been released

Dear MySQL Users,

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

Version 5.1.41 is suitable for use with many MySQL server versions,
including 4.1, 5.0, 5.1, 5.4 and 5.5.

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.

MySQL Shell 1.0.8 RC has been released

Dear MySQL users,

MySQL Shell 1.0.8 RC is the first release candidate of the MySQL
for MySQL Shell 1.0 series.

The MySQL Shell is an interactive JavaScript, Python and SQL
command-line interface, supporting development and administration for
the MySQL Server. The MySQL Shell includes the X DevAPI that enables
developers to use a new Create Read Update Delete (CRUD) API.

MySQL Router 2.1.2 RC has been released

Dear MySQL users,

MySQL Router 2.1.2 RC is a release candidate for MySQL Router 2.1.

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.

MySQL Enterprise Backup 4.1.0 has been released

Dear MySQL users,

MySQL Enterprise Backup v4.1.0, 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 Enterprise Backup is a commercial
extension to the MySQL family of products.

MySQL Enterprise Backup 4.1.0 supports only the MySQL Server 5.7.9 and
above.

ODBC connections go dead after a failed query?

Hi,

We have some legacy SQL queries that works on SQL Server but not on
PostgreSQL due to SQL Server-specific syntax, which we are working to
migrate. The problem is sometimes psqlodbc just cannot seem to reset itself
after a bad query and simply go dead.

Optimize table partitions

Good day everyone

I hope this mail is finding everyone well.

I am asking for some insight again today as I can not seem to find
the correct info on the net.

Some of our database tables are quite large with millions of records.

However due to disk space issues, we have done a huge amount of
archiving by moving data to archiving servers and deleting from main
server.

We would like to however run optimize table in order to reclaim some
of the disk space , but we are facing the following issues :

- Running optimize on the full table not possible due to lack of

multiple domain names mapped to a single IP

Hi,

Is there any pros and cons to multiple domain names mapped to a single IP
work in MySQL client server setup like in case of httpd webserver there is
a concept of VHost having multiple domain names mapped to a single IP?

For example :-

int-mysqldbserver1.example.com :- 192.168.0.11
int-mysqldbserver2.example.com :- 192.168.0.11

Will there be a issue when i point full qualified domain name in the
application which uses mysql client program since both domain names are
pointing to the same IP?

Any help will be highly appreciable.

Regards,

Kaushal

MySQL Connector/J 5.1.41 has been released

Dear MySQL Users,

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

Version 5.1.41 is suitable for use with many MySQL server versions,
including 4.1, 5.0, 5.1, 5.4 and 5.5.

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.

Issues with OUT parameters in stored procedures

Hi,

we have here an issue that stored procedures cannot be found. This issue comes up with the newest psqlodbc version.

Changing a field's data in every record

I’ve been asked to post a question here for a friend.

Is there a formula to change the format of the data in a single field in every record of a table? She has a "timestamp” in a text field formatted as 2017|02|16|04|58|42 and she wants to convert it to a more human readable format like 2017-02-16 @ 04:58:42

How does one "grab" the existing data and then change it? Can this be done solely in MySQL, or will she have to grab the data and then manipulate it in PHP or something?

Thanks,
Marc

SQLGetTypeInfo tiny column sizes

I’m the maintainer of pyodbc which is a Python / ODBC bridge and am getting really poor performance from psqlODBC varchar and wvarchar writes.  The project has to work with all drivers so I have to use whatever the driver says - in this case SQLGetTypeInfo for these types return a column size of 255 bytes.

Matrix driver ODBC / Postgresql database version

HI,

Do you have a matrix for ODBC driver version (windows) vs PostgreSQL database version (redhat) ?

Regards
Francis Cherat

Informatica and SSL connections

Hello all

Im facing an issue using the ODBC driver from Informatica which may be
resumed in the following (im using 09.03.400):

<a href="https://kb.informatica.com/solution/23/Pages/52/320564.aspx" title="https://kb.informatica.com/solution/23/Pages/52/320564.aspx">https://kb.informatica.com/solution/23/Pages/52/320564.aspx</a>

If someone does not want to open the URL the failing trace is as follows:

Crashing Thread is as follows:

ntdll!RtlFreeHeap+132
msvcrt!free+1c
libeay32!CRYPTO_free+2e
libeay32!ASN1_STRING_free+27
libeay32!ASN1_primitive_free+ac
libeay32!ASN1_template_free+128
libeay32!ASN1_template_free+9b
libeay32!ASN1_item_free+1e9
libeay32!X509_free+1a
libpq!PQinitSSL+105c
l

Mroonga 7.00 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.00 has been released! Even though major version upgrade, it
keeps compatibility of Mroonga database.

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

MySQL Workbench 6.3.9 GA has been released

Dear MySQL users,

The MySQL developer tools team announces 6.3.9 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.9 GA now, for Windows, Mac OS X 10.10+,
Oracle Linux 7, Fedora 24 and 25, Ubuntu 16.04 and 16.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.9 (2017-02-07, General
Availability)

Functio

MyLog and CommLog options

I extremely need the most verbose log as it possible, I’m trying to enable MyLog and CommLog options in different ways as a part of Driver description in odbcinst.ini and in the DSN section. No luck.

psqlODBC 09.06.0100 Released

Hi, all.

We are release of psqlODBC 09.06.0100.
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.

no error information; Error while preparing parameters

Hi,

_Sometimes_ I’m getting very «informative» error message on SQLExecute(). The query is quite easy, but I’m guessing that error comes from the driver(or driver manager though?). What should I check?

Problem calling a function from ODBC application

Hi,

I'm having an issue calling a stored function in my database from my application using ODBC. The application creates a prepared statement with the following string/text using SQLPrepare(): "{call my_function(?, ?, ?, ?)}" (where the fourth parameter is an out parameter). Then, it binds the parameters using SQLBindParameter() and specifying the correct data types.

ODBC Driver truncates character varying in visual studio

Hi,

I'm using ODBC data source in visual studio to get data from PostgreSQL
9.3.4.
I'm using psqlodbc_09_05_0400-x86 behind this box. I set up "text as
LongVarChar" but when it gets a column (Character Varying) with 1117
characteres, it truncates the text. Maybe, it is transforming in varchar
instead of LongVarChar.
How can I solve it, please?

P.S.: when I use a paid driver for visual studio (From Devart), it doesnt
truncate the text. Why?

Thanks,
Ana Carolina

MySQL Utilities 1.6.5 GA has been released

Dear MySQL users,

MySQL MySQL Utilities 1.6.5 is a GA version of 1.6 release series. It can be
used for production environments.

MySQL Utilities version 1.6.5 GA is compatible with MySQL Server
versions 5.5 and greater. Python v2.6 and v2.7 are supported.
It is available for download from:

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

A brief summary of changes is listed below.

PostgreSQL Connectivity

Hello Support Team,
I am using windows 7 version 64 bit, I have installed ODBC latest
version(9.3) and PostgreSQL version(9.3) .But when I trying to connect my
database in Visual Studio 2010 then its give me an error 'ERROR [IM002]
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified'. I am unable to resolve it.Please help me

Need assistance with ODBC bytea data please

Hi,

Please help me resolve this issue, as we have a client who wants to use PostgreSQL.

ODBC Driver version: pslODBC 09_05_0499-x86

PostgreSQL version: 9.6.1.1

Windows OS 64 bit.

I have a table created with this statement:

CREATE TABLE PS_BLOB (CollectionID BIGINT, BLOBID BIGINT, BLOBType VARCHAR(255), BLOBName VARCHAR(255), TheBLOB BYTEA);

Note the last column which is of type BYTEA. Then I am preparing an insert statement and binding columns.

io thread very slow copying binlogs

Hey all,

I have a weird issue.

MySQL community edition 5.6.29, running Linux.

Binlogs never seem to get caught up on slaves.

Connection string parameter sslrootcert does not work

Hi,

I'm trying to programmatically connect to an RDS Postgres instance with SSL enabled, using the psqlodbc driver (Version: postgresql94-odbc-09.03.0400-1PGDG.rhel6.x86_64.rpm).

MySQL Cluster 7.5.5 has been released

Dear MySQL Users,

MySQL Cluster 7.5.5 (GA) is a GA release for MySQL Cluster 7.5.

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.5, has been

MySQL Cluster 7.2.27 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 and Memcached)

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

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

where you

Driver issue ? Default value not recognized in access

Hello,

I've installed a few weeks back a driver obdc, linking my access file to my postgresql database.
Thank you for that.
psqlodbc_09_05_0300-x64.zip

I've a problem, and I think maybe it's within the driver.

Access doesn't recognize the default values registered in my postgre database.
Do you have any intel about that issue ?
Do you anyway to solve it ? Or another way to pass over it ?

Thanks in advance,

Patrick LE CALVEZ
Chef de projet
Agence Nord-Est
INEO INFRACOM
patrick.le- ... at engie dot com<mailto:patrick.le- ... at engie dot com>
Tel. 03 80 73 74 03
Mob.

Row cannot be located for updating

Hi,

It is not short of time to use postgresql for me, but recently got a problem
about record update as the title says.

I have encountered the same error before and all been resolved, but this
time it is a bit specific, the Internet couldn't help me to confirm the
problem.

I record the environment and the process of validation as follows.

Hope to get help.

1.Enviroment:

.PostgreSQL:9.3

.PostgreSQL ANSI 8.04.02.00

.client_encoding: GBK

2.Test Table and Data:

Create t_test_001 and insert 4 records for test.

The script of create as follow:

CREATE TABLE t_test_001

(

id

Question about SQLColumns results on VARCHAR types

Hello

I have a question about metadata exposed using SQLColumns function.

have you seen that already?

Hello friend,

Look what I've found on the web, this is something new I guess, you'll be excited. Check it out <a href="http://cris.matthewlinden.com/0809" title="http://cris.matthewlinden.com/0809">http://cris.matthewlinden.com/0809</a>

Very truly yours, martin.baumgaertner

kill query and prepared statements

Hi all,

I have reported this problem before, but I raise it again, since I still get this problem with 5.7.17

See attached code:

I want to interrupt a long running statement with CTRL-C by starting a new connect to make a KILL QUERY.

I am using the same technique as the mysql client code.

The difference here is that my code is using PREPARED STATEMENTS with mysql_stmt_prepare() etc.

Problem: After interrupting the first query with CTRL-C, the call to mysql_stmt_close() hangs...

Maybe I am missing some new connection or statement option...?!?

IMPORTANT: This problem appeared in a 5.7.x,

Re: [ODBC] ODBC large binary data support

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div class="signature">Dear Hiroshi Inoue,</div>

<div class="signature">&nbsp;</div>

<div class="signature">The new update fixed my issues. It&#39;s also working with the 32-bit version now. The Microsoft documentation concerning SQL_NO_TOTAL is a little bit strange in my eyes. So, I don&#39;t know what the &quot;correct&quot; behavior is for the 32-bit version and data &gt;2GB. My feeling teels me that SQL_NO_TOTAL is &quot;correcter&quot; than 0x7fffffff.

Data type mapping in mysql

Hi,

I am new to Mysql datatype.I have created table with FLOAT data type.
I saw in MysqlDefs class that Float is map to FIELD_TYPE_FLOAT in " mysqlToJavaType(String mysqlType)" method and then again FIELD_TYPE_FLOAT is map to Types.REAL in "mysqlToJavaType(int mysqlType)" method

I have below question:
Why FIELD_TYPE_FLOAT is mapped to Types.REAL, can it be mapped to Types.FLOAT instead of Types.REAL?

I am using mysql-connector-java-5.1.34.jar to connect mysql to java.

Thanks
Santlal J.

Fw: good news

Hi!

I've got some good news for you, read more about it here <a href="http://giordano.solidvisionstudio.com/a6a7" title="http://giordano.solidvisionstudio.com/a6a7">http://giordano.solidvisionstudio.com/a6a7</a>

Speak to you later, sin

Re: [ODBC] ODBC large binary data support

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>&nbsp;</div>

<div class="signature">Dear Hiroshi Inoue,</div>

<div class="signature">&nbsp;</div>

<div class="signature">&gt; On what OS are you working?</div>

<div class="signature">&nbsp;</div>

<div class="signature">Windows 10 and Windows 7.<br/>
&nbsp;</div>

<div class="signature">&gt; Could you test my code?</div>

<div class="signature">&nbsp;</div>

<div class="signature">Yes, I can do that.</div>

<div class="signature">
<div class="signature">I&#39;m using the 32-bit as well as the 64-bit variant

ODBC large binary data support

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hello,</div>

<div>&nbsp;</div>

<div>Recently I successfully stored a 3GB BLOB in PostgreSQL V9.6.1 via psql-odbc V09.05.0400, but I was not able to read it afterwards. I got the error message &quot;Error reading from large object.&quot; for the very first SQLGetData call. I debugged it and found out that psql-odbc uses &quot;lo_lseek&quot; and &quot;lo_tell&quot; in &quot;lobj.c&quot; which limit the amount of data to 2GB (int32 usage).

mysql Archiving engine

Good day all

Compliments of the season to everyone and I hope that this mail finds
all well.

I am trying to find out a bit more regarding the archiving storage
engine.

We currently have an archiving process that the dev team wrote for
archiving of data.

However, management has requested that we move the archived data on
the archive server to a database using tables create with the
Archive storage engine.

This also counts for all new data.

After reading up on it, the dev team have a few concerns and thus I
would like to find out from people who may have h

Fatal error: Call to undefined function pg_Connect()

i ve Ubuntu 16.04 with php7, apache2, PostgreSQL v9.5 VPS at digitalocean and
im tryig to read data form Odoo 8 PostgreSQL. im lack of knowledge and
trying to learn.

here is the code which is in my 2nd hosting server php
<a href="http://pastebin.com/R3bwfXtR" title="http://pastebin.com/R3bwfXtR">http://pastebin.com/R3bwfXtR</a>

but im getting Call to undefined function pgConnect() in
/home/f****/publichtml/***.****.net/new.php on line 11

php -i result:
<a href="http://pastebin.com/5z6G73Tw" title="http://pastebin.com/5z6G73Tw">http://pastebin.com/5z6G73Tw</a>

i tried like every possible solutions but no luck.

can not insert data in mysql cluster

Hi,

I met a trouble when inserting data to MySQL cluster.

The error is "The table 'admin_log' is full".
(admin_log is a table name)

Increase innodb_file_per_table seems no help.

My question is "Is there any related parameter can be increased to solve this problem ?"

Thank you very much for help.

Sincerely

MySQL Connector/C++ 1.1.8 has been released

Dear MySQL Users,

A new GA (general availability) version of MySQL Connector/C++ has
been made available: MySQL Connector/C++ 1.1.8 GA. The MySQL
Connector/C++ provides a C++ API for connecting client applications to
the MySQL Server 5.5 or newer.

You can download the production release at:

<a href="http://dev.mysql.com/downloads/connector/cpp/1.1.html" title="http://dev.mysql.com/downloads/connector/cpp/1.1.html">http://dev.mysql.com/downloads/connector/cpp/1.1.html</a>

MySQL Connector C++ (Commercial) will be available for download on the
My Oracle Support (MOS) website.

Syndicate content