h2 Questions
4
How do I create a table in H2 with a column named GROUP? I saw an example that used something like [*] a while ago, but I can't seem to find it.
Guelders asked 3/11, 2013 at 21:39
2
Solved
H2 seems to make a difference between name with quote and name without quote. Is there a way to make it treat them the same way?
Here's the tests that I've done :
CREATE TABLE test (dummy INT);
C...
Confirmatory asked 28/5, 2012 at 20:15
9
Solved
From a program, I created a H2 database without specifying any user or password in the JDBC URL.
Now I'm trying to access that database with the Script tool. The doc says to use -user sa in the de...
Sharpnosed asked 1/1, 2012 at 20:47
2
Solved
I am using MySQL as my database and H2 for testing. I am also using playframework 2.3.x and Scala, but I think does not matter for the question purpose.
H2 has a conflict with some functions that ...
2
Solved
Wikipedia describes the Phantom read phenomenon as:
A phantom read occurs when, in the course of a transaction, two identical queries are executed, and the collection of rows returned by the sec...
Rheology asked 26/1, 2015 at 6:43
3
Solved
I´m using the H2 database in my Quarkus project with the @QuarkusTestResource annotation. Each test method is doing tests and checks if a certain number of users exist etc.
The problem I´m facing i...
Jovanjove asked 13/11, 2020 at 22:14
1
Solved
Hi, we are trying to upgrade 2.0.202 from 1.4.200. We are getting an
error related to running our tests. While persisting
data we are getting below error. Any suggestions?
Caused by: org.h2.jdbc....
Transformer asked 23/1, 2022 at 2:10
5
6
I am creating a JavaFX program with an embedded H2 database that will be used to handle user logins and passwords. Using Intellij Ultimate, I have a database that I can run from the toolbar. In add...
1
Solved
I just downloaded activiti-app from github.com/Activiti/Activiti/releases/download/activiti-6.0.0/… and deployed in tomcat9, but I have this errors when init the app:
11:29:40,090 [http-nio-8080-e...
4
Solved
I have couple of entities in my data layer stored in particular schema. For example:
@Entity
@Table(name = "FOO", schema = "DUMMY")
public class Foo {}
I'm trying to setup H2 embedded database f...
Gorgias asked 19/8, 2016 at 11:24
2
Solved
H2 db is not accessible at localhost:8080/h2-console when using webflux. I read somewhere that this is available only when developing a Servlet-based application. But I am using Webflux with Netty....
Instar asked 23/10, 2018 at 12:27
6
Hello Im having problem with viewing my schema in H2 console Database:
Im using spring boot:
spring.datasource.initialize=true
spring.datasource.url=jdbc:h2:~/test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_E...
Gaptoothed asked 4/10, 2016 at 13:54
5
My Grails app uses a h2 database in dev mode (the default behaviour for Grails apps). The DB connection settings in DataSource.groovy are
dataSource {
pooled = true
jmxExport = true
driverClass...
Horntail asked 9/3, 2015 at 11:28
6
Solved
I am trying to persist some data into the H2 database. but I keep getting the schema not found error message as below.
Jan 02, 2014 8:55:51 PM org.apache.catalina.core.AprLifecycleListener init
I...
Evoy asked 3/1, 2014 at 5:9
6
i'm trying to use the H2 embedded DB with spring boot. But, it throws the following errors.
2016-10-19 22:05:25.818 INFO 14104 --- [ main] com.example.SpringDemoApplication : Starting SpringDemoAp...
Raptor asked 19/10, 2016 at 16:53
1
I am using Spring Data JPA and developed below query which will dynamically take the day values and fetch data, but looks like its arguable looking for Double data type. Any reason why its taking d...
Multicolor asked 13/9, 2021 at 13:59
2
As development DB I am using MySQL, and for tests I am using H2 database.
The following script works in MySQL very well, but it is fails on H2.
UPDATE `table_a`
JOIN `table_b` ON `table_a`.id=`tab...
4
Solved
Im working with H2 database and wanted to move some data. For that I created the following Query:
UPDATE CUSTOMER
SET EMAIL = SELECT service.EMAIL
FROM CUSTOMER_SERVICE AS service
INNER JOIN CUSTO...
3
Solved
I'm trying to connect to an h2 database on my local machine to create a sql DataSource object. I'm running windows and i'm having some issues defining the path to the data file in my projects app.p...
Hostility asked 23/1, 2018 at 19:3
3
H2 in-memory - INSERT - Error 42000
Tried versions 1.4.196, 1.4.197, 1.4.199.
I also tried to execute INSERT on H2 server (local) : also failed
The line giving the error: (sorry but for securi...
1
Solved
I am looking to configure the two DS in my Spring Boot application and have followed link - https://medium.com/@joeclever/using-multiple-datasources-with-spring-boot-and-spring-data-6430b00c02e7. W...
Sulfa asked 13/8, 2021 at 9:41
3
I have an application with Jboss, Seam, Hibernate and h2. I wrote a simple action for importing data to the database from an external file.
@Name("importAction")
@AutoCreate
@Scope(ScopeType.CONVE...
6
Solved
I need to start H2 database in server mode from my application. Having tried the following code:
server = Server.createTcpServer().start();
Here is the properties for the connection:
javabase.jdbc...
6
I face a problem about connecting to H2
this is my pom.xml:
<project>
<modelVersion>4.0.0</modelVersion>
<groupId>.</groupId>
<artifactId>dbConnection</a...
© 2022 - 2024 — McMap. All rights reserved.