This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 213227 - In the SQL Explorer if i try to save to a file the content of a clob field, the file creation dialog creates the file but with no content inside.
Summary: In the SQL Explorer if i try to save to a file the content of a clob field, t...
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 7.2
Hardware: PC Windows XP
: P1 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-30 10:26 UTC by gleyverg
Modified: 2012-06-05 08:30 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description gleyverg 2012-05-30 10:26:22 UTC 
Product Version = NetBeans IDE 7.2 Beta (Build 201205031832)
Operating System = Windows XP version 5.1 running on x86
Java; VM; Vendor = 1.6.0_29
Runtime = Java HotSpot(TM) Client VM 20.4-b02
Comment 1 matthias42 2012-05-30 19:30:21 UTC 
Can you please provide:

a) The netbeans log file: http://wiki.netbeans.org/FaqLogMessagesFile
b) A screenshot of the resulttable prior to trying to save the file
   Everything except the clob column can be pixelized to secure sensitive data
c) Please test "Edit date" is this also empty?
Comment 2 matthias42 2012-06-03 12:18:25 UTC 
Raising priority to P1 - as this is a potential dataloss.

Thank you for the screenshots I received via email. Summary:

- The CLOB is not empty
- In the editor the file contents is present

Additional information (relevant for the diagnosis): "And by the way, i cannot delete the new created file inmediatly, I have to wait some seconds to be able to delete in this case the file test.txt."

This information made me suspicious. The described behavior is the normal windows file locking semantic preventing deletes on opened files. So the file seems not to be closed correctly. This was fixed in bug #211942.

If I interpret the mercurial logs correctly, the patch for the mentioned bug was merged after netbeans 7.2 beta was tagged and in turn was not part of the netbeans 7.2 beta.

@Jiri: Could you please check, that the fix makes it into the next release candidate/into the release.

@gleyverg: Could you please try a newer nightly build - everything after build 201205040400 (or better a current one)
Comment 3 Jiri Rechtacek 2012-06-04 09:28:39 UTC 
(In reply to comment #2)
> Raising priority to P1 - as this is a potential dataloss.
> 
> Thank you for the screenshots I received via email. Summary:
> 
> - The CLOB is not empty
> - In the editor the file contents is present
> 
> Additional information (relevant for the diagnosis): "And by the way, i cannot
> delete the new created file inmediatly, I have to wait some seconds to be able
> to delete in this case the file test.txt."
> 
> This information made me suspicious. The described behavior is the normal
> windows file locking semantic preventing deletes on opened files. So the file
> seems not to be closed correctly. This was fixed in bug #211942.
> 
> If I interpret the mercurial logs correctly, the patch for the mentioned bug
> was merged after netbeans 7.2 beta was tagged and in turn was not part of the
> netbeans 7.2 beta.
Right. The fix was integrated after a branch for beta created.

> @Jiri: Could you please check, that the fix makes it into the next release
> candidate/into the release.
Sure, it will. The fix is included in recent daily builds and will be part of upcoming NB7.2 for sure.
Comment 4 Jaroslav Havlin 2012-06-05 08:30:25 UTC 
> Sure, it will. The fix is included in recent daily builds and will be part of
> upcoming NB7.2 for sure.
Tested on current development build. Saving clob fields to files works fine.
Closing. Thank you very much for comments and evaluation.