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 125414 - Recapture Schema does not do anything
Summary: Recapture Schema does not do anything
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-01-16 17:25 UTC by Andrei Badea
Modified: 2008-11-24 16:20 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
screen dumps of issue (102.17 KB, application/pdf)
2008-08-31 12:28 UTC, jcachia
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Andrei Badea 2008-01-16 17:25:03 UTC
Split from issue 124331:

-----%<-----
Now i would expect the "Recapture Schema from Database" option to update any changes that i might have made in the 
database but it does not do anything.
-----%<-----

Sorry for the scarce description, that's all we've got from the user.
Comment 1 David Vancouvering 2008-01-24 21:04:29 UTC
Andrei, masterofpuppets, can you please provide more information.  I am unable to reproduce.  Another user is
complaining of this, so I believe you that this happens, but I just can't seem to make it happen myself.

- Are there any error messages?
- If so, can you please attach the message log?
- What database are you using, and what driver?
- Is the database local or remote?
- What steps do you take to reproduce?

Thanks,

David
Comment 2 masterofpuppets 2008-02-04 18:43:05 UTC
hi, sorry for the delayed response to your questions

I am using microsoft sql server 2005 enterprise edition
the driver is sqljdbc.jar (from sqljdbc_1.2.2828.100_enu.exe) the i downloaded from microsoft website
the steps from my ejb module were
1) new file
2) category -> persistence
3) file type -> database schema
4) enter arbitrary file name, leave the selected location as is
5) choose my database connection
6) enter my password
7) select all tables
8) finish

the database schema is successfully captured, i can look at it in the projects tab of the explorer window under 
configuration files 

Now if i make changes to the tables that i have just captured in the database example changing column type from int to 
varchar or changing column name or adding another column and save the changes.

I then click "recapture schema from database", if i have not clicked remember password, it will prompt me for the 
password (otherwise it wont which is as expected) but after that nothing happens. No error messages or confirmation 
messages. If i expand on the schema structure in the under the config files i dont see the changes the i had just made
If i delete the file and capture the schema from scratch, then everything looks fine. 


I just chalked that up to an issue with the sql driver just like the other issue i was having that the netbeans team 
said was a flaw in the driver (the other issue response is on http://www.netbeans.org/issues/show_bug.cgi?id=124331 for 
issue 1)
Comment 3 David Vancouvering 2008-07-02 17:29:48 UTC
Thanks for the information, removing INCOMPLETE keyword
Comment 4 Andrei Badea 2008-08-07 17:11:53 UTC
I followed the steps in desc3, but I couldn't reproduce the issue. After entering the password, I see the tables being
recaptured. Please try to reproduce the issue in the latest 6.5 daily build. 

Also,please run NetBeans with

netbeans -J-Dnetbeans.debug.exceptions=true -J-Dorg.netbeans.modules.dbschema.recapture.debug=true

and attach your message log to the issue. Thanks.
Comment 5 Andrei Badea 2008-08-21 18:47:36 UTC
No reply from masterofpuppets, so closing.
Comment 6 jcachia 2008-08-31 12:28:19 UTC
Created attachment 68722 [details]
screen dumps of issue
Comment 7 jcachia 2008-08-31 12:29:57 UTC
Am encountering the same issue (recapture schema does not do anything). Have started up netbeans with the command line 
suggested by abadea but cannot find message log.
Comment 8 jcachia 2008-08-31 12:34:29 UTC
Further to my previous, have succeeded using the wizard (entity class from database) by selecting datasource instead 
of configuration file. This then automatically updates the configuration file thus doing what I was trying to di using 
the pop-up menu option to recapture schema.
Comment 9 John Baker 2008-08-31 22:12:45 UTC

You can find messages.log in the userdir, under var/log (See Help->About) for the location of the userdir 
Comment 10 David Vancouvering 2008-09-24 19:52:14 UTC
We were not able to get to these issues before code freeze - changing target
milestone to 'future'
Comment 11 Roman Mostyka 2008-10-22 12:43:56 UTC
jcachia, can You update this issue? Are You still able to reproduce this issue?
We can't work on this issue since we don't have enough information. If this issue isn't updated and still in INCOMPLETE
state, then we will think that it isn't valid anymore (probably was fixed with another issue) and this issue will be closed.
Comment 12 Roman Mostyka 2008-11-24 16:16:54 UTC
We haven't got any new info in a month, so I'm closing this issue as FIXED.
Please reopen this issue if it is still valid and add some more information.
Comment 13 Roman Mostyka 2008-11-24 16:20:02 UTC
Verified.