thank you for the advise. I never used that tool but I try to get my hands
on it as soon as possible and let you know.
--
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 emai
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 th
Hi, i'm sorry for my bad english
i want tu use a LISTAGG class here is the class content
package packagetest;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.h2.api.AggregateFunction;
import com.google.common.base.Joiner;
Hi zoltan,
When you create the linked table, try creating it using select * from
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 wrote:
>
> Hi!
>
> Is there any progress in this issue? I still ha
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
In that statement, where you have given the table name as TEST , replace it
with 'select * from TEST' and see if that helps.
Thanks,
Piush
> On Sep 16, 2016, at 7:32 AM, Zoltan Koczkas wrote:
>
> Hi Piush!
>
> Sorry, but I am pretty new to H2 and database themes, so I don't understand
> how
Hi Piush,
I get:
Table "select * from TEST(com.microsoft.sqlserver.jdbc.SQLServerException:
Incorrect syntax near the keyword 'select'.)" not found; SQL statement:
CREATE LINKED TABLE
TEST('com.microsoft.sqlserver.jdbc.SQLServerDriver','jdbc:sqlserver://mssqlserver.at:1433','User','PW','select
Check this out
CREATE LINKED TABLE LINK('org.h2.Driver', 'jdbc:h2:test2', 'sa', 'sa', 'TEST');
CREATE LINKED TABLE LINK('', 'jdbc:h2:test2', 'sa', 'sa',
'(SELECT * FROM TEST WHERE ID>0)');
CREATE LINKED TABLE LINK('javax.naming.InitialContext',
'java:comp/env/jdbc/Test', NULL, NULL, '(SE