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.
Product Version = NetBeans IDE Dev (Build 200408101800) Operating System = SunOS version 5.9 running on sparc Java; VM; Vendor = 1.5.0-beta3; Java HotSpot(TM) Client VM 1.5.0-beta3-b62; Sun Microsystems Inc. Java Home = /space/jdks/jdk1.5.0/jre System Locale; Encod. = en_US (nb); UTF-8 Home Dir; Current Dir = /home/dm103276; /space/netbeans/4.0/netbeans-4.0/bin ------------------------------------------------------------------------------- I'm using DB2-8.1 server on M$W2K and this COM.ibm.db2.jdbc.net.DB2Driver from db2java.zip I've added the driver, and created new connection, where I select different scheme then it was defaultly selected (DB2ADMIN). I select DAN schema. Here I've created 2 tables: People and Country I grab the structure of People Table and dropped (deleted People TAble). And Wanted to recreate it: I browsed to people.grab and executed this script, but no table was created. Then I executed once more and get SQL error complaining that table already exists :-( hhmmm and realy Tabler was created in DB2ADMIN scheme instead my DAN scheme which I selected.
Because the grab structure does not contain information about schema, it is created in user's 'default' schema. I'm not sure, how it should work correctly, if the schema has to be the same. You can modify the create command available in dialog to add the correct schema. As we discuss with Radko, this action is confusing and Radko plan to remove it in the future. Setting target milestone to future.
This seems to work. The current schema (the one the user is connected to) is used as the target schema for the recreated table. The only case when it doesn't work is when the Edit Table Script button is pressed -- the generated CREATE TABLE statement doesn't contain the schema.
Fixed the CREATE TABLE statement when Edit Table Script is pressed. Checking in src/org/netbeans/modules/db/explorer/actions/RecreateTableAction.java; /cvs/db/src/org/netbeans/modules/db/explorer/actions/RecreateTableAction.java,v <-- RecreateTableAction.java new revision: 1.25.22.2; previous revision: 1.25.22.1 done