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

Summary: Generated SQL should not contain schema name
Product: obsolete Reporter: marco_s <marco_s>
Component: visualwebAssignee: John Baker <jbaker>
Status: NEW ---    
Severity: blocker CC: romanmostyka
Priority: P3    
Version: 6.x   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Exception Reporter:

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 ?