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 - Recreate Table: doesn't use currently used SCHEMA
Summary: Recreate Table: doesn't use currently used SCHEMA
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 4.x
Hardware: All All
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-08-11 16:49 UTC by dmladek
Modified: 2006-08-01 12:50 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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