Skip to content

no non default schema for postgresql support #7879

@wumpz

Description

@wumpz

Apache NetBeans version

Apache NetBeans 23

What happened

Using Services I configured a Postgresql connection. Here I can config a different schema. Netbeans (or the platform) does not honor this setting. I always have to call Connection.setSchema after I got a jdbc Connection.

Within DatabaseConnection line 907 this is blocked because getConnector().supportsCommand(Specification.DEFAULT_SCHEMA) returns false.

So the connector is not initialized correctly from the database driver. BTW I tried different versions from 42.2.3 til the most recent version.

In other tools, e.g. DBeaver I am able to config the schema using the same drivers and databases.

Language / Project Type / NetBeans Component

org-netbeans-modules-db

How to reproduce

Config a postgresql db connection and specify a different schema within Services. Connect to it and check the schema.

Did this work correctly in an earlier version?

No / Don't know

Operating System

Windows 11

JDK

17,21

Apache NetBeans packaging

Apache NetBeans provided installer

Anything else

No response

Are you willing to submit a pull request?

No

Metadata

Metadata

Assignees

No one assigned

    Labels

    kind:bugBug report or fixneeds:triageRequires attention from one of the committers

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions