Thank you. Will do as you suggested.
On Thursday, 4 April 2019 17:37:59 UTC+5:30, Evgenij Ryazanov wrote:
>
> Hello.
>
> You can execute
> SET SCHEMA name
> command or add schema to a database URL (;SCHEMA=name).
>
> Connection.getSchema() and Connection.setSchema() work only with embedded
>
Hello.
How exactly do you read names of aliases? I cannot reproduce this issue in
1.4.197 and in other versions.
try (Connection c = DriverManager.getConnection("jdbc:h2:mem:1")) {
Statement s = c.createStatement();
s.execute("CREATE TABLE test (ID int);");
It looks like software that you use does not support Multi-release jar
files:
https://openjdk.java.net/jeps/238
Multi-relese jars are very common now.
If you use the latest version of that software, check its bugtracker and
post a new issue in it, if such issue does not exist yet.
You can
Hello.
Starting from version 1.4.197 in queries, aliases for columns in queries
are not working correctly.
Example:
CREATE TABLE test (ID int);
INSERT INTO test (ID) VALUES (1);
COMMIT;
SELECT ID AS VALUE_ID FROM test;
Result:
ID
1
Aliases for expressions work correctly:
SELECT ID + 1 AS
Hi all,
I am developing an Atlassian Confluence plugin that uses H2.
It builds fine on H2 version 196. However, if I switch to a version 197 and
above, the build starts failing with the following error:
[ERROR] Manifest com.v-and-b:sqlTableFilterPlugin:atlassian-plugin:1.0.27 :
Classes found
Hello.
You can execute
SET SCHEMA name
command or add schema to a database URL (;SCHEMA=name).
Connection.getSchema() and Connection.setSchema() work only with embedded
databases and don't work over TCP (I don't know why).
--
You received this message because you are subscribed to the Google
Hi All
I am getting a Db connection for H2 using the below URL
jdbc:h2:tcp://localhost:3456/TEST.
I am trying to set schema for this connection. But i am getting the below
error
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Feature not
supported: "setSchema && remote session"