Hi Piush!
Sorry, but I am pretty new to H2 and database themes, so I don't understand
how to accomplish this, where to put the SELECT.
I create the linked table with such a statement:
CREATE LINKED TABLE LINK('org.postgresql.Driver', 'jdbc:postgresql:test', 'sa',
'sa', 'TEST');
where TEST is the table name on the other (linked) database. So where do I
have to insert the SELECT in this statement?
Thanks,
Zoltan
2016. szeptember 16., péntek 12:05:50 UTC+2 időpontban Piush Kumar a
következőt írta:
>
> Hi zoltan,
> When you create the linked table, try creating it using select * from
> <table name>
> Syntax and see if that helps. I don't have access to the sql server now
> to verify.
>
> Thanks,
> Piush
>
> On Sep 16, 2016, at 4:59 AM, Zoltan Koczkas <zkoc...@gmail.com
> <javascript:>> wrote:
>
> Hi!
>
> Is there any progress in this issue? I still have this problem with the
> latest beta 1.4.192 of the H2 driver.
>
> Thanks,
> Zoltan
>
> 2013. április 27., szombat 21:38:30 UTC+2 időpontban Peter a következőt
> írta:
>>
>> Thomas, thanks very much for picking this up.
>>
>> In SSMS connected directly to the SQLServer2005 server, when I run:
>>
>> select top 5 RECORDDATE from SecurityMaster;
>>
>> I get
>> Msg 207, Level 16, State 1, Line 1
>> Invalid column name 'RECORDDATE'.
>>
>> Running
>> select top 5 RecordDate from SecurityMaster;
>>
>> runs fine and returns the first five records.
>>
>> I see the same behaviour when I run the queries in DBVis via the same
>> SQLServerDriver jdbc driver I am using for the linked table.
>>
>> What does the linked table feature use to check the case sensitivity of
>> the SQLServer?
>> Is there a way I can quote the column names in query to the linked table
>> that will bypass the autoconversion to uppercase?
>>
>> Thanks, Peter
>>
>>
>> On Saturday, April 27, 2013 1:14:22 AM UTC-7, Thomas Mueller wrote:
>>>
>>> Hi,
>>>
>>> H2 converts all case insensitive identifier names to uppercase
>>> internally. But I would expect if the identifiers are case sensitive in MS
>>> SQL Server, then this should not happen. Maybe the implementation of the
>>> linked table feature is different however; unfortunately I don't have MS
>>> SQL Server installed right now so I can't easily test it.
>>>
>>> Are the column names actually case sensitive, that means if you run
>>> "select RECORDDATE from SecurityMaster" in the MS SQL Server, does it
>>> throw an exception?
>>>
>>> Regards,
>>> Thomas
>>>
>>>
>>>
>>>
>>> On Sat, Apr 27, 2013 at 4:07 AM, Peter <pjcr...@gmail.com> wrote:
>>>
>>>> Bump. Should I provide more information? Is this even possible? Thanks,
>>>> Peter
>>>>
>>>>
>>>> On Thursday, April 25, 2013 9:34:29 AM UTC-7, Peter wrote:
>>>>>
>>>>> I am having trouble with column name case sensitivity with linked
>>>>> tables in SQL Server 2005.
>>>>>
>>>>> Example. The column name in SQL Server is RecordDate in the table
>>>>> SecurityMaster
>>>>>
>>>>> I create a linked table as:
>>>>>
>>>>> create linked table if not exists
>>>>> L_SecurityMaster(
>>>>> 'com.microsoft.sqlserver.jdbc.SQLServerDriver',
>>>>> 'jdbc:sqlserver://feedqa\SQL2005:1773;DatabaseName=testdb',
>>>>> 'user', 'password',
>>>>> 'dbo.SecurityMaster');
>>>>>
>>>>> Executing show columns from L_Securitymaster shows all the columns in
>>>>> capitals, i.e. RECORDDATE instead of RecordDate.
>>>>>
>>>>> Various combinations of [RecordDate], 'RecordDate' and so on all fail
>>>>> for one reason or another. I tried to search documentation but sorry I
>>>>> can't see what I am supposed to do. Can anyone help me with the correct
>>>>> way
>>>>> to link and query MS SQL Server tables with case sensitive column names?
>>>>>
>>>>> Many thanks, Peter
>>>>>
>>>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "H2 Database" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to h2-database...@googlegroups.com.
>>>> To post to this group, send email to h2-da...@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/h2-database?hl=en.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>>
>>>>
>>>
>>> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database...@googlegroups.com <javascript:>.
> To post to this group, send email to h2-da...@googlegroups.com
> <javascript:>.
> Visit this group at https://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
