[Feature] make jdbc catalog support using database location to create table.

[Stephen0421]

Search before asking

• I searched in the issues and found nothing similar.

Motivation

Now paimon support jdbc catalog to maintain metadata in relationship database. But when create database and table, it still using default warehouse path. Hope to use location in database properties to create table if it exists.

Solution

No response

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!

[tub]

We've just hit this issue, I raised a draft PR for setting the location at the Table level, but on seeing this PR I'm wondering it if makes more sense to have it at the Database level instead.
Any thoughts?