Hi,
Thanks for the mail! I will add support for the schema name in the next release:
CREATE [[GLOBAL | LOCAL] TEMPORARY] LINKED TABLE [IF NOT EXISTS]
name(driverString, urlString,
userString, passwordString, [originalSchemaString,] originalTableString)
[EMIT UPDATES | READONLY]
This is backward compatible. When multiple tables exist in different
schema, and the schema name is not set, an exception is thrown.
Regards,
Thomas
On Fri, Sep 19, 2008 at 1:12 PM, Toshiaki Takashima
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
>
>>
>> Is it possible to alter the interface of CREATE LINKED TABLE statement
>> so that you can specify schema explicitly?
>>
>
> if that suggestion is not unacceptable, is it possible to modiry
> TableLink.java
>
> from :
> (line:83)
> ResultSet rs = meta.getColumns(null, null, originalTable,
> null);
>
> to :
> ResultSet rs = null;
> if (originalTable.indexOf(".") < 0) {
> rs = meta.getColumns(null, null, originalTable, null);
> } else {
> String schemaPart = originalTable.substring(0,
> originalTable.indexOf("."));
> String tablePart =
> originalTable.substring(originalTable.indexOf(".") + 1);
> rs = meta.getColumns(null, schemaPart, tablePart, null);
> }
>
> ?
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
