Hello.
On Sunday, 29 September 2019 18:09:22 UTC+8, pr1 wrote:
>
> Hello,
> could someone explain the compatibility modes in H2?
> If you use the Oracle-db driver in H2, must you write you SQL statements
> using the Oracle-SQL syntax?
>
What exactly do you mean? If you use the H2 Console to
Hello,
could someone explain the compatibility modes in H2?
If you use the Oracle-db driver in H2, must you write you SQL statements
using the Oracle-SQL syntax?
If that is not the case, how does H2 translate H2-SQL statements to
Oracle-SQL statements?
Many thanks.
Cheers,
pr1
--
You
Hi Evgenij.
I've added an ALTER USER statement to my script, and it now works fine.
Many thanks.
Cheers,
pr1
CREATE USER IF NOT EXISTS us1 PASSWORD 'us1';
ALTER USER us1 ADMIN TRUE;
CREATE SCHEMA IF NOT EXISTS MY_SCHEMA AUTHORIZATION us1;
SET SCHEMA = MY_SCHEMA;
CREATE TABLE table1 (
Hello.
When you created this database a user with ADMIN rights were created using
the user name and password that were specified to create a first
connection. You need to use its user name and password to connect to the
database.
After it you can either execute this script under that account
Hello,
In a Spring Boot project, I have defined an H2 Scope.
My schema-h2.sql script contains the following code:
CREATE SCHEMA IF NOT EXISTS ABC_SCHEMA AUTHORIZATION xyz;
SET SCHEMA = ABC_SCHEMA;
Unfortunately, when I "install" my Java project, I get the following error
message:
Admin