arielch / aoo-my-sdbc Goto Github PK

Original issue 6 created by arielch on 2012-09-09T10:59:19.000Z:

Moved from AOO bugzilla bug: https://issues.apache.org/ooo/show_bug.cgi?id=112884

Description, the bug still valid, tested with 1.0.2 version under win7 with MySQL 5.5:
"Please make a registered DD document connected to a Mysql Server
using the Native Connector available to reproduce this Issue.
Make on the server een "Test" table with 2 columns "Name" and "Title"
then run the macro in the joined document.

The Macro opens a Datasourcebrowser and populate the Grid with data out of
the "Test" table
Then we try to close the open Connection, (whos failed with the native
Connector and stays "half alive with other drivers

With the native Connector the Connection Stay as "sleep' op on the Server until we close OO"
I attached the original bugdoc.

Original issue 4 created by arielch on 2012-09-09T07:18:51.000Z:

Currently we not provide MySQL connector to OS X.
For the remainder I created this issue if we can build native driver for Mac OS X, we needs to solve the issue.

Several bugs were reported on AOO bugzilla with native drivers:
https://issues.apache.org/ooo/show_bug.cgi?id=113905
https://issues.apache.org/ooo/show_bug.cgi?id=119410
https://issues.apache.org/ooo/show_bug.cgi?id=119242

May be duplicates, but contains lot of information.

Original issue 10 created by arielch on 2013-01-09T18:55:46.000Z:

Steps to reproduce:

1. Open a table data view
2. The table must have a Date field
3. Click on the filter button
4. In dialogbox, choose your Date field and select = condition
5. In value field, input # 01/01/2013#

Behavior expected: rows are filtered on 01/01/2013 date
Wrong behavior: none rows are displayed

But if you select a row with 01/01/2013 and click on AutoFilter, that's work as expected. Rows are filtered correctly.
Now, click on Filter button: dialogbox show # 01/01/2013# value.

Original issue 13 created by arielch on 2013-10-16T08:44:26.000Z:

• Step 1: run wampserver
• Step 2: On the Database wizard check "Connect to an existing database" and select MySQL
• Step 3: check "Connect directly"
• Step 4: enter the "Database name" and the server (localhost or 127.0.0.1)
• Step 4: enter "User name" (root) no password is required for this database
• Step 5: connection test fails with message "User and password are mandatory"

My system has windows 7

Original issue 1 created by arielch on 2012-09-09T03:43:34.000Z:

MySQL esta correctamente trabajando en mi equipo ArchLinux x64, estoy intentando conectarme desde ApacheOpenOffice en español, descargado de la página oficial, instale la extensión correcta de este sitio, y el error mostrado es el que anexo.

¿Que otra información puedo aportar?

Saludos

Original issue 14 created by arielch on 2013-10-25T00:43:05.000Z:

libmysql supports automatic reconnection, see http://dev.mysql.com/doc/refman/5.6/en/auto-reconnect.html

The driver should support this as a generic setting, or per database.

Original issue 8 created by arielch on 2012-09-14T08:51:39.000Z:

Menu File - New - Database

• Step 1: On the Database wizard check "Connect to an existing database" and select MySQL
• Step 2: check "Connect directly"
• Step 3: enter the "Database name". Check "Named pipe" and enter "dummy". Press "Next >>"
• Step 4: enter "User name" and password
• Step 5: create the database

If you look in MySQL Workbench, the connection is done via TCP, not with a Named pipe.

Original issue 5 created by arielch on 2012-09-09T07:43:49.000Z:

Moved here from AOO bugzilla:https://issues.apache.org/ooo/show_bug.cgi?id=110943

The main part of description:
"1. create a new mysql driver and use the mysql native driver (I use version 1.0.1)
2. create 2 tables

CREATE TABLE rel1
(
idx decimal(10,0) NOT NULL DEFAULT '0',
f_text varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (idx)
)

CREATE TABLE rel2
(
idx decimal(10,0) NOT NULL DEFAULT '0',
f_text1 varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
idx_2 decimal(10,0) NOT NULL DEFAULT '0',
PRIMARY KEY (idx)
)

1. open the relation design window
2. add the 2 tables
3. open INSERT / NEW RELATION
4. select field idx from table rel1 and field idx_2 from table rel2
5. click OK
6. double click the created relation
   ==>> as you can see the relation fields are missed up or is empty"

Screenshot attached to original bug.

Original issue 12 created by arielch on 2013-08-17T19:46:03.000Z:

AOO 4.0.0 with sdbc 1.2.0 connector can not connect to MySQL server.

Error: The connection to the data source "native_named_pipe" could not be established.

SQL Status: HY000
Error code: 2017

Can't open named pipe to host: . pipe: MySQL56 (2)

In AOO 3.4 with 1.1.0 works correctly. It seems to me it is a regression.

Original issue 9 created by arielch on 2012-10-01T00:06:38.000Z:

MySQL supports secure (encrypted) connections between MySQL clients and the server using the Secure Sockets Layer (SSL) protocol.

The driver should support them too.

Original issue 11 created by arielch on 2013-07-12T16:27:13.000Z:

I tried to install sdbc drive to AOO 4.0.0RC, it is failed.
AOO 4.0. was reinstallation of developer versions. Tried again, removed user profile, same problem happened.

I get error message: loading component library failed: aoo-my-sdbc-uno.dll
The file copied into folder, but not loads.
Maybe some changes in UNO, caused this?
Need to build new version to AOO 4.0?

Restarted AOO, in extension window the driver is inactive, when tried to activate, the error message is same - as shown in attached screen shot.

My computer windows 8, 64 bit version.

(The report builder is OK)

Original issue 16 created by arielch on 2014-06-28T18:01:39.000Z:

What steps will reproduce the problem?
1.trying to connect a MySQL database with MySQL connector

What is the expected output? What do you see instead?
With previous versions of LO the connection works fine , with the 4.2.5 version ( the new stable version ) the connection fails with this message :

Type: com.sun.star.sdbc.SQLException
Message: Invalid for this platform protocol requested(MYSQL_PROTOCOL_SOCKET).
Ligne : 27

What version of the product are you using? On what operating system?
Windows 8.1 , LO 4.2.5.2 , MySQL connector 1.0.1

Please provide any additional information below.

In Tools > SQL
Execute a DROP or CREATE TABLE instruction
Tables list is not refreshed

Original issue 15 created by arielch on 2014-01-21T11:04:26.000Z:

Unable to execute SHOW command.
That will be nice to run SHOW TABLES or SHOW AUTHORS.

Original issue 2 created by arielch on 2012-09-09T06:52:38.000Z:

This is a moved issue from AOO bugzilla:https://issues.apache.org/ooo/show_bug.cgi?id=104309
Excerpt from original bugreport:

"To add a little more details:

Connecting to a MySQL server in an intranet works fine. Connecting to a server outside this intranet does not seem to work with the Connector/OOo - you'll get a 10060 error. On the very same machine, Connector/J (the JDBC driver) is able to connect fine to the very same MySQL server.

There are different reports whether Connector/ODBC works: On my own machine, I could not get C/ODBC to connect (version 5.1.05, Windows), nonetheless there are other reports about C/ODBC being able to connect.

First investigations by the MySQL team showed this might be a problem in
Connector/C, a component used by our native driver."

Original issue 7 created by arielch on 2012-09-13T13:55:03.000Z:

Create a new database document, connecting to MySQL with the native connector.
In the user interface, select the Tables category on the left.
AOO Base displays tables of all the data bases the user has access rights.

Expected behaviour: display only the tables from the database selected when creating the database document.

Original issue 3 created by arielch on 2012-09-09T06:59:39.000Z:

Moved here from AOO bugzilla: https://issues.apache.org/ooo/show_bug.cgi?id=109327

From bug description:
"just trye to get this code working

Dim oCallableStatement as Object 'com.sun.star.sdbc.CallableStatement
If (Not GlobalScope.BasicLibraries.isLibraryLoaded("Tools")) Then
GlobalScope.BasicLibraries.LoadLibrary("Tools")
End If

oDBConnection = ConnectToDatabase( "mysql_native", "user", "password" )

strSql = "call teststoredprocedure(?)"
oCallableStatement = oDBConnection.prepareCall( strSql ) '>>>> trows the
Exception that Prepareclall is not Implemented

' oCallableStatement.registerOutParameter( 1, MySQLTypes. )

oCallableStatement.setString(1, "stringparameter")

oCallableStatement.Execute()

ResultSet = oCallableStatement.getString( 2 )

Print ResultSet

End Sub"