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 47124

Summary: Recreate Table: doesn't use currently used SCHEMA
Product: db Reporter: dmladek <dmladek>
Component: CodeAssignee: Andrei Badea <abadea>
Status: RESOLVED FIXED    
Severity: blocker    
Priority: P3    
Version: 4.x   
Hardware: All   
OS: All   
Issue Type: DEFECT Exception Reporter:

Description dmladek 2004-08-11 16:49:38 UTC 
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.
Comment 1 Pavel Flaska 2005-03-24 14:13:46 UTC 
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.
Comment 2 Andrei Badea 2006-08-01 12:48:36 UTC 
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.
Comment 3 Andrei Badea 2006-08-01 12:50:45 UTC 
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