Questions tagged as 'h2database'

Tagged questions
1
answer

Condition in Select - SQL

I have a table where the priorities of output of the supplies per customer are stored, for example: cliente | codigosuprimento | prioridade | quantidaestoque 1 | 500 | 1 | 20 1 | 501 |...
asked by 04.10.2017 / 22:36
1
answer

How to connect JDBC (H2 Database) in PHP?

How to connect a JDBC database (specifically H2 Database) in PHP? The database is in a single file with extension .db     
asked by 17.10.2015 / 17:27
3
answers

Spring Data JPA does not recognize the SQL 'Limit' command?

I'm creating a REST API, using Spring Boot, which, using data from a table, displays random phrases. Giving a Google, I discovered that it is possible to generate random results through pure SQL: SELECT <coluna> FROM <tabela> OR...
asked by 31.10.2018 / 06:21
1
answer

Change the name of a table in the H2 Database Engine

I'm trying to change the name of a table in H2, but I can not find the syntax. Does anyone know?     
asked by 13.02.2018 / 13:15
0
answers

Error opening H2 Database

I tried to open an H2 Database file that is not corrupted and H2 Database returned the following error: Encryption error in file "C:/Users/Administrator/test.h2.db" [90049-189] 90049/90049 (Help) org.h2.jdbc.JdbcSQLException: Encryption error...
asked by 08.10.2015 / 03:07
1
answer

Join the results of two SQL commands in H2

I created the following Query : SELECT s FROM SuprimentosPedidos s WHERE s.codigoModeloImpressora = :codigoModeloImpressora AND s.codigoEmpresa = :codigoEmpresa and s.prioridadeSaida = 1 ORDER BY s.prioridadeSaida, s.suprimento ASC u...
asked by 09.10.2017 / 13:31
0
answers

How to find in SQL what is the primary key of the table?

I'm learning SQL, and I ran into the following problem: I need to know which of the columns is the primary key of the table. Is there a command I can use in SELECT to get a return this information? I've already seen the topic: # It d...
asked by 01.02.2018 / 00:22
1
answer

Composite primary key definition syntax in H2 Database engine

I'm trying to set a primary key consisting of two columns when creating a table in the H2 Database Engine ( link ) , but I did not find the syntax in the manual. Could you give me tips? For example: the syntax in MySql, Postgress ... Maybe some...
asked by 23.07.2018 / 23:13