OT - (again) SourceForge Community Choice Awards

[drewjensen]

The category: Best Project for the Enterprise

..... Firebird ...... with a whooping 18.05% of the vote.

For those that don't know Firebird has been around a long, long time -
think InterBase and Borland.

Most notable feature of Firebird (I used F'bird and InterBase a fair bit
in the past) is NO LOCKING! The engine uses record versioning
instead...it's an interesting idea actually and does offer good
performance for a fairly wide variety of usage scenarios, but it never
quite caught on in the Corporate IT world.

Anyway, just thought I'd pass that along.

OO.o won for the "Best Project for Government" running away with 48.27%
of the vote.

Bis später,

Drew



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

Drew,

I'm still looking for a way to keep my jdbc connection live to a MySQL
database remotely.  I saw something about a parameter you can pass but
no details ever came out of the question I asked.

Any ideas?  My connection times out after 10 very short minutes.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Keith Clark wrote:
> Drew,
>
> I'm still looking for a way to keep my jdbc connection live to a MySQL
> database remotely.  I saw something about a parameter you can pass but
> no details ever came out of the question I asked.
>
> Any ideas?  My connection times out after 10 very short minutes.
>
>  

Hey Keith,

Have you tried adding
?autoReconnect=true
to your connection properties?


Drew

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Sat, 2009-07-25 at 11:54 -0400, Drew Jensen wrote:

> Keith Clark wrote:
> > Drew,
> >
> > I'm still looking for a way to keep my jdbc connection live to a MySQL
> > database remotely.  I saw something about a parameter you can pass but
> > no details ever came out of the question I asked.
> >
> > Any ideas?  My connection times out after 10 very short minutes.
> >
> >  
>
> Hey Keith,
>
> Have you tried adding
> ?autoReconnect=true
> to your connection properties?
>
>
> Drew

Where do I do that Drew?

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Sat, 2009-07-25 at 11:54 -0400, Drew Jensen wrote:

> Keith Clark wrote:
> > Drew,
> >
> > I'm still looking for a way to keep my jdbc connection live to a MySQL
> > database remotely.  I saw something about a parameter you can pass but
> > no details ever came out of the question I asked.
> >
> > Any ideas?  My connection times out after 10 very short minutes.
> >
> >  
>
> Hey Keith,
>
> Have you tried adding
> ?autoReconnect=true
> to your connection properties?
>
>

I tried adding that and still disconnects after 10 minutes

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Alex Thurgood]

Hi Keith,

> I tried adding that and still disconnects after 10 minutes
>

All that parameter does is tell the driver to attempt a reconnect if the connection drops. Depending on how you access your remmote mysql server, you can still be disconnected. I have the same problem with my ssh redirected mysql connection. I first thought that the ssh server disconnected me after a certain timeout, but apparently it is, in my case at least, a network reliability problem, i.e. the actual internet connection is not stable enough and the server detects that my connection has dropped and thus severs any further attempt until I manually reinitialise the connection. PITA, but unfortunately have no other solution. I also get at the OOo end a JDBC error message "the server has had no activity for the last X ms" where X is variable.

Alex


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Sat, 2009-07-25 at 19:39 +0200, Alex Thurgood wrote:

> All that parameter does is tell the driver to attempt a reconnect if
> the connection drops. Depending on how you access your remmote mysql
> server, you can still be disconnected. I have the same problem with my
> ssh redirected mysql connection. I first thought that the ssh server
> disconnected me after a certain timeout, but apparently it is, in my
> case at least, a network reliability problem, i.e. the actual internet
> connection is not stable enough and the server detects that my
> connection has dropped and thus severs any further attempt until I
> manually reinitialise the connection. PITA, but unfortunately have no
> other solution. I also get at the OOo end a JDBC error message "the
> server has had no activity for the last X ms" where X is variable.
>

I don't think my problem is connectivity.  Same error, but I've tried it
on two different installations with two completely different internet
connections.  One is cable the other phone company.



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Keith Clark wrote:

> On Sat, 2009-07-25 at 19:39 +0200, Alex Thurgood wrote:
>  
>> All that parameter does is tell the driver to attempt a reconnect if
>> the connection drops. Depending on how you access your remmote mysql
>> server, you can still be disconnected. I have the same problem with my
>> ssh redirected mysql connection. I first thought that the ssh server
>> disconnected me after a certain timeout, but apparently it is, in my
>> case at least, a network reliability problem, i.e. the actual internet
>> connection is not stable enough and the server detects that my
>> connection has dropped and thus severs any further attempt until I
>> manually reinitialise the connection. PITA, but unfortunately have no
>> other solution. I also get at the OOo end a JDBC error message "the
>> server has had no activity for the last X ms" where X is variable.
>>
>>    
>
> I don't think my problem is connectivity.  Same error, but I've tried it
> on two different installations with two completely different internet
> connections.  One is cable the other phone company.
>  

One thing for sure after doing a little  research for you - you guys are
not alone with this problem.

Anyway - and this is just something that seemed to come up a fair bit in
my readings:
Have you tried using the actual IP address to the server in your
connection settings and not a DNS name?



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Sat, 2009-07-25 at 16:49 -0400, Drew Jensen wrote:

> Keith Clark wrote:
> > On Sat, 2009-07-25 at 19:39 +0200, Alex Thurgood wrote:
> >  
> >> All that parameter does is tell the driver to attempt a reconnect if
> >> the connection drops. Depending on how you access your remmote mysql
> >> server, you can still be disconnected. I have the same problem with my
> >> ssh redirected mysql connection. I first thought that the ssh server
> >> disconnected me after a certain timeout, but apparently it is, in my
> >> case at least, a network reliability problem, i.e. the actual internet
> >> connection is not stable enough and the server detects that my
> >> connection has dropped and thus severs any further attempt until I
> >> manually reinitialise the connection. PITA, but unfortunately have no
> >> other solution. I also get at the OOo end a JDBC error message "the
> >> server has had no activity for the last X ms" where X is variable.
> >>
> >>    
> >
> > I don't think my problem is connectivity.  Same error, but I've tried it
> > on two different installations with two completely different internet
> > connections.  One is cable the other phone company.
> >  
>
> One thing for sure after doing a little  research for you - you guys are
> not alone with this problem.
>
> Anyway - and this is just something that seemed to come up a fair bit in
> my readings:
> Have you tried using the actual IP address to the server in your
> connection settings and not a DNS name?

Yes, I always use the IP and not the DNS name.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Keith Clark wrote:

> On Sat, 2009-07-25 at 16:49 -0400, Drew Jensen wrote:
>  
>> Keith Clark wrote:
>>    
>>> On Sat, 2009-07-25 at 19:39 +0200, Alex Thurgood wrote:
>>>  
>>>      
>>>> All that parameter does is tell the driver to attempt a reconnect if
>>>> the connection drops. Depending on how you access your remmote mysql
>>>> server, you can still be disconnected. I have the same problem with my
>>>> ssh redirected mysql connection. I first thought that the ssh server
>>>> disconnected me after a certain timeout, but apparently it is, in my
>>>> case at least, a network reliability problem, i.e. the actual internet
>>>> connection is not stable enough and the server detects that my
>>>> connection has dropped and thus severs any further attempt until I
>>>> manually reinitialise the connection. PITA, but unfortunately have no
>>>> other solution. I also get at the OOo end a JDBC error message "the
>>>> server has had no activity for the last X ms" where X is variable.
>>>>
>>>>    
>>>>        
>>> I don't think my problem is connectivity.  Same error, but I've tried it
>>> on two different installations with two completely different internet
>>> connections.  One is cable the other phone company.
>>>  
>>>      
>> One thing for sure after doing a little  research for you - you guys are
>> not alone with this problem.
>>
>> Anyway - and this is just something that seemed to come up a fair bit in
>> my readings:
>> Have you tried using the actual IP address to the server in your
>> connection settings and not a DNS name?
>>    
>
> Yes, I always use the IP and not the DNS name.
>
>  

Ok - well let me come at this a different way.

Why is this a problem? What is it you want to happen or not happen, i.e
I should not have a new logon screen open just because the connection
was lost.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Sat, 2009-07-25 at 17:09 -0400, Drew Jensen wrote:

> Keith Clark wrote:
> > On Sat, 2009-07-25 at 16:49 -0400, Drew Jensen wrote:
> >  
> >> Keith Clark wrote:
> >>    
> >>> On Sat, 2009-07-25 at 19:39 +0200, Alex Thurgood wrote:
> >>>  
> >>>      
> >>>> All that parameter does is tell the driver to attempt a reconnect if
> >>>> the connection drops. Depending on how you access your remmote mysql
> >>>> server, you can still be disconnected. I have the same problem with my
> >>>> ssh redirected mysql connection. I first thought that the ssh server
> >>>> disconnected me after a certain timeout, but apparently it is, in my
> >>>> case at least, a network reliability problem, i.e. the actual internet
> >>>> connection is not stable enough and the server detects that my
> >>>> connection has dropped and thus severs any further attempt until I
> >>>> manually reinitialise the connection. PITA, but unfortunately have no
> >>>> other solution. I also get at the OOo end a JDBC error message "the
> >>>> server has had no activity for the last X ms" where X is variable.
> >>>>
> >>>>    
> >>>>        
> >>> I don't think my problem is connectivity.  Same error, but I've tried it
> >>> on two different installations with two completely different internet
> >>> connections.  One is cable the other phone company.
> >>>  
> >>>      
> >> One thing for sure after doing a little  research for you - you guys are
> >> not alone with this problem.
> >>
> >> Anyway - and this is just something that seemed to come up a fair bit in
> >> my readings:
> >> Have you tried using the actual IP address to the server in your
> >> connection settings and not a DNS name?
> >>    
> >
> > Yes, I always use the IP and not the DNS name.
> >
> >  
> Ok - well let me come at this a different way.
>
> Why is this a problem? What is it you want to happen or not happen, i.e
> I should not have a new logon screen open just because the connection
> was lost.

If I am using Base, and I leave to do something else for 10 minutes and
come back to work some more, Base errors.  I have to close down Base and
start it back up again in order to use it.

That is a very short time and a pain to stop and start again.

I use MySQL Query Browser and no matter how long I leave it, for days
even, I can just type a query and execute it.  No reconnection required
besides just the original one when I started the program.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Keith Clark wrote:

> On Sat, 2009-07-25 at 17:09 -0400, Drew Jensen wrote:
>  
>> Keith Clark wrote:
>>    
>>> On Sat, 2009-07-25 at 16:49 -0400, Drew Jensen wrote:
>>>  
>>>      
>>>> Keith Clark wrote:
>>>>    
>>>>        
>>>>> On Sat, 2009-07-25 at 19:39 +0200, Alex Thurgood wrote:
>>>>>  
>>>>>      
>>>>>          
>>>>>> All that parameter does is tell the driver to attempt a reconnect if
>>>>>> the connection drops. Depending on how you access your remmote mysql
>>>>>> server, you can still be disconnected. I have the same problem with my
>>>>>> ssh redirected mysql connection. I first thought that the ssh server
>>>>>> disconnected me after a certain timeout, but apparently it is, in my
>>>>>> case at least, a network reliability problem, i.e. the actual internet
>>>>>> connection is not stable enough and the server detects that my
>>>>>> connection has dropped and thus severs any further attempt until I
>>>>>> manually reinitialise the connection. PITA, but unfortunately have no
>>>>>> other solution. I also get at the OOo end a JDBC error message "the
>>>>>> server has had no activity for the last X ms" where X is variable.
>>>>>>
>>>>>>    
>>>>>>        
>>>>>>            
>>>>> I don't think my problem is connectivity.  Same error, but I've tried it
>>>>> on two different installations with two completely different internet
>>>>> connections.  One is cable the other phone company.
>>>>>  
>>>>>      
>>>>>          
>>>> One thing for sure after doing a little  research for you - you guys are
>>>> not alone with this problem.
>>>>
>>>> Anyway - and this is just something that seemed to come up a fair bit in
>>>> my readings:
>>>> Have you tried using the actual IP address to the server in your
>>>> connection settings and not a DNS name?
>>>>    
>>>>        
>>> Yes, I always use the IP and not the DNS name.
>>>
>>>  
>>>      
>> Ok - well let me come at this a different way.
>>
>> Why is this a problem? What is it you want to happen or not happen, i.e
>> I should not have a new logon screen open just because the connection
>> was lost.
>>    
>
> If I am using Base, and I leave to do something else for 10 minutes and
> come back to work some more, Base errors.  I have to close down Base and
> start it back up again in order to use it.
>
> That is a very short time and a pain to stop and start again.
>
> I use MySQL Query Browser and no matter how long I leave it, for days
> even, I can just type a query and execute it.  No reconnection required
> besides just the original one when I started the program.
>
> Keith
>  

Ok - just making sure I was on the same page with you.

Actually Query Browser times out also - unless you are using a localhost
database server, but I doub't that or we wouldn't be having this
discussion. (hmm, maybe I'm wrong on that - but it doesn't really matter)

I think then the best way to help you is to look at how to handle the
lost connection so that you don't have to shut it all down and start it
all up again - heck, it would be nice if you didn't even know it happened.

But that is not for tonight - sorry. For one thing it would be nice to
address this in a moe generalized way with a set of basic functions ( or
java perhaps) and then perhaps donate this to Roberto should he like to
add said functions to the Base Tools library he is distributing at the
extension site. In other words give it a little thought.

But more importantly - I promised my 16 year old Nephew to take him and
a couple of his friends to the Demolition Derby tonight at the county
fair...just us guys...and need to head the door here pretty quickly.

But I'll get into it with you tomorrow if you like....maybe we can find
others on the list with some ideas also.

Drew


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Sat, 2009-07-25 at 17:26 -0400, Drew Jensen wrote:

> Keith Clark wrote:
> > On Sat, 2009-07-25 at 17:09 -0400, Drew Jensen wrote:
> >  
> >> Keith Clark wrote:
> >>    
> >>> On Sat, 2009-07-25 at 16:49 -0400, Drew Jensen wrote:
> >>>  
> >>>      
> >>>> Keith Clark wrote:
> >>>>    
> >>>>        
> >>>>> On Sat, 2009-07-25 at 19:39 +0200, Alex Thurgood wrote:
> >>>>>  
> >>>>>      
> >>>>>          
> >>>>>> All that parameter does is tell the driver to attempt a reconnect if
> >>>>>> the connection drops. Depending on how you access your remmote mysql
> >>>>>> server, you can still be disconnected. I have the same problem with my
> >>>>>> ssh redirected mysql connection. I first thought that the ssh server
> >>>>>> disconnected me after a certain timeout, but apparently it is, in my
> >>>>>> case at least, a network reliability problem, i.e. the actual internet
> >>>>>> connection is not stable enough and the server detects that my
> >>>>>> connection has dropped and thus severs any further attempt until I
> >>>>>> manually reinitialise the connection. PITA, but unfortunately have no
> >>>>>> other solution. I also get at the OOo end a JDBC error message "the
> >>>>>> server has had no activity for the last X ms" where X is variable.
> >>>>>>
> >>>>>>    
> >>>>>>        
> >>>>>>            
> >>>>> I don't think my problem is connectivity.  Same error, but I've tried it
> >>>>> on two different installations with two completely different internet
> >>>>> connections.  One is cable the other phone company.
> >>>>>  
> >>>>>      
> >>>>>          
> >>>> One thing for sure after doing a little  research for you - you guys are
> >>>> not alone with this problem.
> >>>>
> >>>> Anyway - and this is just something that seemed to come up a fair bit in
> >>>> my readings:
> >>>> Have you tried using the actual IP address to the server in your
> >>>> connection settings and not a DNS name?
> >>>>    
> >>>>        
> >>> Yes, I always use the IP and not the DNS name.
> >>>
> >>>  
> >>>      
> >> Ok - well let me come at this a different way.
> >>
> >> Why is this a problem? What is it you want to happen or not happen, i.e
> >> I should not have a new logon screen open just because the connection
> >> was lost.
> >>    
> >
> > If I am using Base, and I leave to do something else for 10 minutes and
> > come back to work some more, Base errors.  I have to close down Base and
> > start it back up again in order to use it.
> >
> > That is a very short time and a pain to stop and start again.
> >
> > I use MySQL Query Browser and no matter how long I leave it, for days
> > even, I can just type a query and execute it.  No reconnection required
> > besides just the original one when I started the program.
> >
> > Keith
> >  
>
> Ok - just making sure I was on the same page with you.
>
> Actually Query Browser times out also - unless you are using a localhost
> database server, but I doub't that or we wouldn't be having this
> discussion. (hmm, maybe I'm wrong on that - but it doesn't really matter)
>
> I think then the best way to help you is to look at how to handle the
> lost connection so that you don't have to shut it all down and start it
> all up again - heck, it would be nice if you didn't even know it happened.
>
> But that is not for tonight - sorry. For one thing it would be nice to
> address this in a moe generalized way with a set of basic functions ( or
> java perhaps) and then perhaps donate this to Roberto should he like to
> add said functions to the Base Tools library he is distributing at the
> extension site. In other words give it a little thought.
>
> But more importantly - I promised my 16 year old Nephew to take him and
> a couple of his friends to the Demolition Derby tonight at the county
> fair...just us guys...and need to head the door here pretty quickly.
>
> But I'll get into it with you tomorrow if you like....maybe we can find
> others on the list with some ideas also.
>
> Drew

No problem Drew.  I'll be around tomorrow to offer what I can.

Now, go enjoy yourselves!  Your help is always appreciated.

Have fun this evening.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Alex Thurgood]

Hi Drew, Keith,


> > I use MySQL Query Browser and no matter how long I leave it, for
> days
> > even, I can just type a query and execute it.  No reconnection
> required
> > besides just the original one when I started the program.

> Actually Query Browser times out also - unless you are using a
> localhost
> database server, but I doub't that or we wouldn't be having this
> discussion. (hmm, maybe I'm wrong on that - but it doesn't really
> matter)
>

Yes, the MySQL Query Browser will also time out, but if it does, it notices this when it tries to execute a query and will ask you if you want to reconnect and then parse the query. If you click on "Yes" or "OK" (can't remember the exact message now), it will do all of this transparently.

As Keith has mentioned with OOo you have to close the error message, which for some dumb reason often exceeds the size of my desktop window (because you get a load of Java error message handling drivel about nested exceptions) and is a pain to get rid of, then you have to shut down your Base file (or form) and reconnect. I regularly spend time building my queries (not an SQL guru and I like to experiment), and by the time I'm ready, discover that the damn thing has disconnected. With the MySQL Query Browser this is not an issue, as indicated above, but then again it uses a direct C++ client database access and not the Java connector driver. Perhaps this problem will go away once the native mysql driver extension is as functional as the other connectors. For the moment (I mean in its present "stable" incarnation), it isn't.

I know that Frank is on holiday at the moment, so he'll probably only read all about this after he gets back and gets around to trawling through the mountain of emails that will have piled up in his mail inbox during his absence...and of course, if the problem is with the connector, and not OOo, then there will be little that can be done on the OOo side :-)


Alex


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Howdy,

> Yes, the MySQL Query Browser will also time out, but if it does, it notices this when it tries to execute a query and will ask you if you want to reconnect and then parse the query. If you click on "Yes" or "OK" (can't remember the exact message now), it will do all of this transparently.
>  

Lets call this - The right way to do error handling for end users, shall we.

> As Keith has mentioned with OOo you have to close the error message, which for some dumb reason often exceeds the size of my desktop window (because you get a load of Java error message handling drivel about nested exceptions) and is a pain to get rid of, then you have to shut down your Base file (or form) and reconnect. <snip>
>  

Ok then - let's look at what is laying around to test this on - I would
like a general error handling function for connections so how about not
sticking with just JDBC.

The Test Network then:

-- Server --
Ubuntu 9.04 AMD 3300+ (64bit) / MySQL 5.1.31-1ubuntu2 / VirtualBox 2.2.4

-- Virtual (hosted) Clients --
Client 1 - MS Win 7 / OO.o 3.2m_50 (spcl FilePicker build) / JRE
1.6_0_13 / Connector-J 5.1.6
Clinet 2 - MS Win 7 / OO.o 3.1.1m_16 / (beta 1) MySQL Native Connector /
JRE 1.6_0_13

--Physical Clients--
Client 3 - Kubuntu 9.04 / OO.o 3.1 / OpenJDK 6 / Connector-j 5.1.6 (hard
wired - Linksys router)
Client 4 - HP mini 110 Mi (hp variant ubuntu Linux) / Go - OO 2.4.1 /
JRE 1.6_0_14 / Connector-J 5.1.6 (WiFi/G - Belkin G+ router) [NOTE will
most likely swap out to OO.o 3.1.1 as we go]

Base line test 1 - Client 1
Created a new Base file that connects to the MySQL server with the JDBC
connector.
Logon to the server via the Base file, go to the tables section.

(Meanwhile my evil twin fires up MySQL Aministrator on the host and
kills the user connection)

Double click on a table...looks like what Alex described -
http://baseanswers.com/downloads/ConnError/ConnLostError.PNG

let's call that - Not the right way to do error handling for end users.

Great, so where do we start....

[Thinking I need to start a new pot of coffee for this]


Drew

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Sun, 2009-07-26 at 11:45 +0200, Alex Thurgood wrote:
> Yes, the MySQL Query Browser will also time out, but if it does, it
> notices this when it tries to execute a query and will ask you if you
> want to reconnect and then parse the query. If you click on "Yes" or
> "OK" (can't remember the exact message now), it will do all of this
> transparently.

Actually, I left MySQL Query Browser open all night last night.  I just
entered a query and executed it.  If it reconnects, it does so without
informing me at all.  No dialog comes up.  The query just runs.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Keith Clark wrote:

> On Sun, 2009-07-26 at 11:45 +0200, Alex Thurgood wrote:
>  
>> Yes, the MySQL Query Browser will also time out, but if it does, it
>> notices this when it tries to execute a query and will ask you if you
>> want to reconnect and then parse the query. If you click on "Yes" or
>> "OK" (can't remember the exact message now), it will do all of this
>> transparently.
>>    
>
> Actually, I left MySQL Query Browser open all night last night.  I just
> entered a query and executed it.  If it reconnects, it does so without
> informing me at all.  No dialog comes up.  The query just runs.
>
> Keith
>
>  

 Well by default MySQL should time out a connection after 8 hours (
28,800 seconds IIRC) of inactivity...but that can be configured larger
(or smaller) - I have found at least one instance of a server that was
set to 7 days.



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Sun, 2009-07-26 at 12:11 -0400, Drew Jensen wrote:

> Keith Clark wrote:
> > On Sun, 2009-07-26 at 11:45 +0200, Alex Thurgood wrote:
> >  
> >> Yes, the MySQL Query Browser will also time out, but if it does, it
> >> notices this when it tries to execute a query and will ask you if you
> >> want to reconnect and then parse the query. If you click on "Yes" or
> >> "OK" (can't remember the exact message now), it will do all of this
> >> transparently.
> >>    
> >
> > Actually, I left MySQL Query Browser open all night last night.  I just
> > entered a query and executed it.  If it reconnects, it does so without
> > informing me at all.  No dialog comes up.  The query just runs.
> >
> > Keith
> >
> >  
>  Well by default MySQL should time out a connection after 8 hours (
> 28,800 seconds IIRC) of inactivity...but that can be configured larger
> (or smaller) - I have found at least one instance of a server that was
> set to 7 days.

The server I'm connected to is set for 10 minute time out/disconnect.
MySQL Query Browser must be reconnecting and just not telling the user.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Keith Clark wrote:
> The server I'm connected to is set for 10 minute time out/disconnect.
> MySQL Query Browser must be reconnecting and just not telling the user.
>  
I like that handling even more then a dialog with an OK button.

Alright well I've been 'reading' for a bit here - in the Developers
Guide - and running into an interesting situation. Where I thought I
would be going takes me to interfaces (services, etc) marked as
deprecated and finding other items that look promising but they all seem
to be marked as UnPublished. ( Now that only means that the interface is
subject to change w/out notice...not that they can't be used)

So far the only thing that is becoming clear is that we are not gong to
be doing much of this in OO.oBasic...



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Drew Jensen wrote:

> Keith Clark wrote:
>> The server I'm connected to is set for 10 minute time out/disconnect.
>> MySQL Query Browser must be reconnecting and just not telling the user.
>>  
> I like that handling even more then a dialog with an OK button.
>
> Alright well I've been 'reading' for a bit here - in the Developers
> Guide - and running into an interesting situation. Where I thought I
> would be going takes me to interfaces (services, etc) marked as
> deprecated and finding other items that look promising but they all
> seem to be marked as UnPublished. ( Now that only means that the
> interface is subject to change w/out notice...not that they can't be
> used)
>
> So far the only thing that is becoming clear is that we are not gong
> to be doing much of this in OO.oBasic...
>

Well - maybe this is a place to start:
http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/XDatabaseAccessListener.html

Maybe not...but gotta start somewhere.



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...