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 146884 - Generated SQL should not contain schema name
Summary: Generated SQL should not contain schema name
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: John Baker
Depends on:
Reported: 2008-09-11 07:42 UTC by marco_s
Modified: 2008-09-11 16:24 UTC (History)
1 user (show)

See Also:
Exception Reporter:


Note You need to log in before you can comment on or make changes to this bug.
Description marco_s 2008-09-11 07:42:19 UTC
Currently there seems to be no way of having the generated SQL for a RowSet to exclude the schema name. I suppose it it
picked up from the database connection, at least for PostgreSQL that seems to be the only place one says anything about
a schema.

A better way would be to generate all SQL queries without schema names in table names and column names.

It is rather common to let the logged in user control against which schema the query is executed. For example PostgreSQL
have a server side configuration parameter "search_path" which is used to decide against which schema to execute the
query. The query might end up being executed against different schemas during design-time and run-time too.
Comment 1 John Baker 2008-09-11 07:56:45 UTC
I think you're referring to visualweb, correct ?