Ask Your Question

RichA's profile - activity

2015-10-16 04:23:44 +0200 received badge  Popular Question (source)
2015-10-16 04:23:44 +0200 received badge  Famous Question (source)
2015-10-16 04:23:44 +0200 received badge  Notable Question (source)
2015-10-16 04:13:57 +0200 received badge  Famous Question (source)
2015-10-16 04:13:57 +0200 received badge  Notable Question (source)
2015-06-29 18:52:36 +0200 received badge  Nice Question (source)
2015-05-22 12:51:10 +0200 received badge  Famous Question (source)
2014-06-28 20:27:01 +0200 received badge  Famous Question (source)
2014-03-10 08:12:02 +0200 received badge  Famous Question (source)
2013-11-20 04:26:39 +0200 received badge  Notable Question (source)
2013-11-20 04:26:39 +0200 received badge  Famous Question (source)
2013-11-20 04:26:39 +0200 received badge  Popular Question (source)
2013-10-01 19:58:51 +0200 marked best answer Base form fields do not allow entry

I am using Base to connect to a remote Mysql database.

I intended to create some forms, using the form wizard, to enter new data and change data.

Well, I can't overwrite any of the fields in the form, and I can't seem to get to a sport where I can add a new record. Basically all I can do is look at the data that's there.

I followed a tutorial on youtube in which someone created a NEW table in base and used a form to add records to it. Seemed simple there, but I can't duplicate what he's doing.

Any suggestions would be appreciated.

Here's my libreoffice version:

LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.4-0ubuntu1

Thanks.

2013-10-01 19:56:48 +0200 marked best answer Base: Connection was implicitly closed by the driver

In Base, when I connect to a remote MYSQL database using JDBC, I usually get to run one query okay, then the second query that I try gets "SQL Status: 08003 No operations allowed after connection closed.Connection was implicitly closed by the driver".

I then have to exit Base and restart it to run another query. I must be doing something wrong, but I don't know what. I believe I am using com.mysql.jdbc.driver, although I notice that when I look at Tools > Options >LibreOffice Base > Connections I do not see it in the list of drivers known to LibreOffice.

So...

What can I do to get rid of this continaul "connection implicitly closed by driver"?

In case I can't fix the above, is there any way to reconnect to the DB without exiting and restarting Base?

I am running on Ubuntu 11.04, and the following version of LibreOffice:

LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.4-0ubuntu1

Thanks very much.

2013-10-01 19:44:10 +0200 marked best answer Move Base forms & queries to different computer?

We are considering using Base to access a server-based mysql database. If we create forms and queries on one PC, can we get those forms and queries to another PC? Or do we have to manually recreate them on each PC?

I can see no obvious way to do this, looking at all the menu options while in Base.

(This is a nonprofit office without much money so we are trying to do everything cheaply or freely.)

Thanks very much.

2013-08-09 18:23:17 +0200 received badge  Popular Question (source)
2013-08-09 18:23:17 +0200 received badge  Famous Question (source)
2013-08-09 18:23:17 +0200 received badge  Notable Question (source)
2013-05-01 09:55:53 +0200 received badge  Notable Question (source)
2013-02-23 21:54:53 +0200 received badge  Popular Question (source)
2013-02-17 09:45:13 +0200 received badge  Notable Question (source)
2013-01-27 18:22:28 +0200 received badge  Notable Question (source)
2013-01-27 18:22:28 +0200 received badge  Popular Question (source)
2013-01-03 12:50:40 +0200 received badge  Popular Question (source)
2012-08-21 16:22:16 +0200 received badge  Student (source)
2012-08-21 16:22:08 +0200 received badge  Self-Learner (source)
2012-08-18 21:00:57 +0200 received badge  Popular Question (source)
2012-06-06 16:36:55 +0200 answered a question Problem: Base connection to remote MySQL DB from a Mac

This seems to be a network issue, not a Mac or Java issue: A laptop that connects to the DB okay elsewhere, cannot connect to the DB from the office where the Macs are located--even though the laptop does connect to the internet from that office.

So the problem is not solved, but the original problem description now seems irrelevant.

2012-06-06 16:31:18 +0200 received badge  Editor (source)
2012-06-06 16:29:37 +0200 asked a question Can't connect to DB using Base due to Network Security?

Summary of issue:

  1. I created MySQL database ABC on the server that hosts site xyz.org.
  2. From home, I accessed it with LibreOffice Base (using JDBC). Everything works as expected.
  3. From the office of a nonprofit organization located on a college campus, we could not do the same thing. That is, we could not access MySQL database ABC on xyz.org using Base.
  4. Thinking this might be due to some difference in software or operating system, we took into the office a laptop that does connect to ABC at home, and it cannot connect to database ABC using Base at the office--even though the laptop can access the internet and web site xyz.org from the office.
  5. Thinking the problem might be use of an IP address to specify the database's server, we created an ODB file that specifies xyz.org as server, instead of xyz.org's IP address. This makes no difference: Specifying URL instead of IP address in Base does allow connection from home, but not from the office (on the same laptop).

So, to me it seems to be some kind of security or firewall issue on the campus. But I don't know enough about this to understand what kind of network or firewall rule can allow access to xyz.org from a browser but prevent access to a MySQL DB on xyz.org's server via Base.

Does anyone have any suggestion for what I might try next, or knowledge about what security rule might be preventing access?

Thanks very much.

2012-06-01 21:15:08 +0200 asked a question Problem: Base connection to remote MySQL DB from a Mac

On a Linux machine (Ubuntu 11.04) I set up a connection between Base and a remote MySQL database. (I am using JDBC to connect, using class com.mysql.jdbc.Driver.)

I copied the ODB file from the Linux machine to a Windows 7 machine, and was able to use it in Base to connect to the remote MySQL database.

The same ODB file was copied to a Mac running OS X 10.5.8, and got the following error when it was used to try to connect to the remote MySQL DB:

SQL Status: 08001 Server connection failure during transaction. Due to underlying exception: 'java.net.ConnectException: Connection refused'.

Is there something different about the way we need to connect in Base on a Mac to a remote MySQL DB?

Is it possible we need to create a new ODB file on the Mac instead of using the copied ODB file?

I am trying to get some suggestions because I am not actually sitting at the Mac trying this. I am talking by phone to someone sitting at the Mac, who I am trying to give simple directions to, to get the connection set up there.

Note: On the Linux and Windows machines I had problems with frequent disconnects, which I resolved by adding parameters to the database name, in Base, as follows:

"name_of_mysql_database?connectTimeout=0&socketTimeout=0&autoReconnect=true"

Is it possible the parameters above appended to the database name can cause problems when used on the Mac?

Thanks in advance for any solutions or suggestions.

2012-05-30 12:25:50 +0200 marked best answer Base search on primary key of table is slow

I am using Base to connect to a remote MYSQL database. One of the tables has about 4500 records.

I created a Base form to access this table. The form initially displays with the first 10 or so records. I performed a Search for the primary key of about the 500th record in the table and it took forever. I could see record numbers slowly incrementing--it seemed like it was retrieving one record at a time and checking the key field for the search value.

I then created an index on the table, to see if that would speed up the process. I did this directly on the MYSQL database itself, not going through Base. After that, Base still seemed to be looking record-by-record, perhaps ignoring the index and perhaps not knowing about the incex.

Is there any way to speed this up? Is there a way to get Base to use the index on the table when it searches?

I have some familiarity with MYSQL and Postgresql, but I am new to Base. I am trying to use it to create a front-end for some non-technical people who don't know SQL and just need to enter and access data.

Thanks very much.

2012-05-28 23:13:52 +0200 received badge  Teacher (source)
2012-05-28 23:13:52 +0200 received badge  Self-Learner (source)
2012-05-28 21:15:54 +0200 answered a question Base: Connection was implicitly closed by the driver

To fix the problem, add "?autoReconnect=true" (without the quotes) immediately after the name of the database (no intervening spaces).

2012-05-28 21:14:18 +0200 answered a question Frequent disconnects from remote database

Apparently what is needed is to add "?autoReconnect=true" (without the quotes) immediately after the name of the database (no intervening space).

I did this and no more disconnects.

2012-05-28 17:43:10 +0200 asked a question Frequent disconnects from remote database

I am using Base to connect to a remote MySQL database.

When I set up the original connection I specified "Connect to an existing database" of type "MySQL"

On the next screen I chose "Connect using JDBC" On the next screen I specified MySQL driver class "com.mysql.jdbc.Driver" (I tested the class and it loads successfully, although I did notice another time that I was able to connect successfully even when the class did not load successfully.)

Whenever I am working with this database it will disconnect if I fail to communicate with the database for a couple of minutes (or so).

As long as I keep performing DB operations I stay connected. If I pause I lose the connection.

At that point I know of no way to reconnect except by exiting from Base and restarting it. IS THERE A WAY TO RECONNECT WITHIN BASE?

Since this is a JDBC connection, is there some Java parameter I need to set?

I notice that when I go to Tools > Options > LibreOffice > Java > Parameters there is a place to add a parameter. SHOULD I ADD SOME PARAMETER HERE?

I notice that when I go to Tools > Options > LibreOffice Base > Connections, the driver com.mysql.jdbc.Driver is NOT listed among the drivers known to LibreOffice. Should it be? Are any of the drivers listed relevant to me then? Am I really using one of the listed drivers and not com.mysql.jdbc.Driver.

Any answers--or clarification of something I seem confused about--would be appreciated.

I have tried this under Ubuntu 11.04, and also Windows 7.

Thanks very much.

2012-05-27 17:47:55 +0200 answered a question Base form fields do not allow entry

Finally realized Base did not know that these tables had primary keys.

Editing the tables under Base to mark the key fields as keys did not work.

What worked was to copy/paste the tables under Base, specifying the primary keys during the paste step, then dropping the original table and renaming the copy to the name of the original. Each new table is apparently identical to the old one, but now Base knows about its primary key and allows adds/changes.