NetBeans Forums

 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
  

Database connection profiles dissappear after restarting 7.0

 
Post new topic   Reply to topic    NetBeans Forums -> NetBeans Users
View previous topic :: View next topic  
Author Message
neek



Joined: 01 Apr 2010
Posts: 6

PostPosted: Tue Jun 07, 2011 4:57 am    Post subject: Database connection profiles dissappear after restarting 7.0 Reply with quote

Product Version: NetBeans IDE 7.0 (Build 201104080000)
Java: 1.6.0_23; Java HotSpot(TM) Client VM 19.0-b09
System: Linux version 2.6.38.6-27.fc15.i686 running on i386; UTF-8; en_GB (nb)
Userdir: /home/neek/.netbeans/7.0

Hi all,

I've had this issue since 6.x, hoped moving to 7.x would fix it. I generally want about 20 database connection profiles in my Services->Databases list. They're all MySQL connections, to either a local db, or via ssh tunnels to remote databases. I create them by right clicking the "Databases" root node, choosing New Connection, driver "MySQL (Connector/J Driver)" (the default .jar shipped with netbeans, which never changes), and setting up the connection settings. Nothing unusual here.

I often find that restarting netbeans results in a few of them disappearing. They don't appear in the list. I can re-create them, use them happily for a few days, and after some time restart Netbeans and find they're gone. I can't tell if it's the same ones that keep disappearing, I'm never paying close enough attention to notice which ones are there and which not.

I've noticed ~/.netbeans/7.0/config/Databases/Connections, in which I have 60 xml files. Only 12 of them have content, the others are 0 bytes long. Only those with content result in a Databases node. This morning, I find 12 nodes in my Databases list, and only 12 of the 60 files have content (about 400 bytes each). They're all owned by my user, permissions are good, I can see no problems with reading/writing these files.

So, it seems something is causing these jdbc_mysql___host_post_stuff.xml files to be truncated, or wiped somehow.

Is there a log I can monitor that might tell me when this is happening?

I've removed the 0 byte xml files and will monitor the situation to see if I notice any other useful info. The problem might have gone away now that I've cleared away the crufty files.

Nick
Back to top
neek



Joined: 01 Apr 2010
Posts: 6

PostPosted: Wed Jun 08, 2011 5:45 am    Post subject: Still a problem. Connected to closing netbeans? Reply with quote

Well, it just happened again. Seems to be related to closing Netbeans.

- booted machine this morning, worked until about 11:30am, quit netbeans by clicking the 'x' in the title bar, waited a few minutes doing other tasks, rebooted machine.
- on reboot, loaded netbeans, two connection profiles that I created yesterday are gone.

Contents of Connections dir (with connection names obscured by 'x' chars):

Code:
[neek Connections]$ ls -ltr
total 48
-rw-rw-r-- 1 neek neek 424 Jun  3 23:29 jdbc_paradox_____tmp_rsdata___on.xml
-rw-rw-r-- 1 neek neek 409 Jun  3 23:29 jdbc_mysql___localhost_3307_xxxx_1.xml
-rw-rw-r-- 1 neek neek 388 Jun  3 23:29 jdbc_mysql___localhost_3306_xx__.xml
-rw-rw-r-- 1 neek neek 408 Jun  3 23:29 jdbc_mysql___localhost_3307_xxxx.xml
-rw-rw-r-- 1 neek neek 423 Jun  6 17:27 jdbc_mysql___localhost_3307_xxxx_5.xml
-rw-rw-r-- 1 neek neek 424 Jun  6 21:39 jdbc_mysql___localhost_3306_xxxx_7.xml
-rw------- 1 neek neek   0 Jun  7 10:51 nohup.out
-rw-rw-r-- 1 neek neek 405 Jun  7 16:13 jdbc_mysql___localhost_3306_xxxx_1.xml
-rw-rw-r-- 1 neek neek 413 Jun  7 22:22 jdbc_mysql___localhost_3308_xxxx_2.xml
-rw-rw-r-- 1 neek neek   0 Jun  7 22:22 jdbc_mysql___localhost_3307_xxxx_2.xml
-rw-rw-r-- 1 neek neek 405 Jun  8 11:29 jdbc_mysql___localhost_13306_xxx.xml
-rw-rw-r-- 1 neek neek 403 Jun  8 11:29 jdbc_mysql___localhost_13306_xxx_1.xml
-rw-rw-r-- 1 neek neek 405 Jun  8 11:29 jdbc_mysql___localhost_13306_xxx_3.xml
-rw-rw-r-- 1 neek neek 400 Jun  8 11:29 jdbc_mysql___localhost_3306_xxxx_6.xml
-rw-rw-r-- 1 neek neek   0 Jun  8 11:29 jdbc_mysql___localhost_3306_xxxx_1.xml


As you can see, one was lost yesterday, the other at 11:30 today when I quit netbeans.

It happens to both local connections (port 3306) and ssh tunnelled connections (3307). So, it doesn't seem to be related to connectivity, as he 3306 database was definitely available at the time.

I have two logs of interest in ~/.netbeans/var/log ..
Code:
[neek log]$ ls -ltr
total 2172
-rw-rw-r-- 1 neek neek 977541 Jun  3 23:29 metrics.1
-rw-rw-r-- 1 neek neek 106473 Jun  7 22:22 messages.log.2
-rw-rw-r-- 1 neek neek 163036 Jun  8 11:29 messages.log.1
-rw-rw-r-- 1 neek neek 479444 Jun  8 11:50 uigestures.1
-rw-rw-r-- 1 neek neek 370254 Jun  8 11:52 metrics
-rw-rw-r-- 1 neek neek  49838 Jun  8 11:56 messages.log
-rw-rw-r-- 1 neek neek  43741 Jun  8 11:58 uigestures


So messages.log.1 was finished with when I quit netbeans. There is no mention of any jdbc or xml files in it. I must say, there are also no timestamps on the log lines, which makes it impossible for me to tell what was logged when.

messages.log.0 has been created after the reboot when restarting netbeans, at 11:50, and has no useful into in it. The connection .xml file has already been lost by then.

Any clues still gratefully received Smile

Nick
Back to top
Display posts from previous:   
Post new topic   Reply to topic    NetBeans Forums -> NetBeans Users All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB
By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo