Add method to define default Schema name at the connection itself about pgjdbc

[davecramer]

What is the concept here ? I don't believe the API allows you to set a schema so this would be a non-api method ?

[alexismeneses]

Dheerendra,

Is the need fulfilled by

Connection.setSchema(String)

for which an implementation is already provided since commit ea55458 (PR #154)?

Or is it a different matter there?

[DheerendraRathor]

@alexismeneses connection.setSchema is fine, but I want to set it at the time of connection itself as a property, so it should get the schema at the time of connections and not after connecting. It can be defined as a property and then can be passed to connection Drivermanager.getConnection(url,properties)

[davecramer]

That's a little different than exposing a method.

What you really want is the default schema to be set.

Dave

Dave Cramer

On 20 May 2014 10:51, Dheerendra Rathor [email protected] wrote:

@alexismeneses https://github.com/alexismeneses connection.setSchema is
fine, but I want to set it at the time of connection itself as a property,
so it should get the schema at the time of connections and not after
connecting. It can be defined as a property and then can be passed to
connection Drivermanager.getConnection(url,properties)

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/155#issuecomment-43636286
.

[alexismeneses]

Are any other JDBC driver out there implementing such a connection property? If so, what's the most common name for it?

Note that it will only save a method call in Java but it won't change the need to internally make a call to the backend after the connection has been opened.

As I understand it, a useful case would to make some schema unaware Java/JDBC programs to use a particular schema without even knowing it, just by being given a magic jdbc url property. It could be a nice feature.

[alexismeneses]

Dave, this one should be fixed now (commit d2c1ef7 PR #156).

@DheerendraRathor, the name of the property is currentSchema, it's merged into the master.