All Questions

Tagged with
Filter by
Sorted by
Tagged with
13votes
2answers
6kviews

DATE_SUB and DATE_ADD in H2 for MySQL

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 I ...
user avatar
  • 5,627
9votes
4answers
8kviews

Unknown data type "JSONB" when running tests in play slick with H2 Database

I have evolution problem Unknown data type: "JSONB" when running tests in playframework using playframework v2.6.6 for scala play-slick v3.0.2 play-slick-evolutions v3.0.2 postgresql - 42.0.0 ...
user avatar
  • 129
6votes
1answer
2kviews

Why is NoClassDefFoundError thrown with "run" but works fine with "dist"?

Before I asked the question I had read the question Play framework java.lang.NoClassDefFoundError only in dev mode and several other posts. They didn't help me to resolve my problem. I've created a ...
user avatar
4votes
1answer
9kviews

If-Else condition in H2 database query

I have a connector application which reads from third-party database using apache camel. I am trying to mock the same database and query operations using H2 database, so that connectivity to the ...
user avatar
4votes
2answers
560views

Memory leaks when recreating Squeryl in-memory database

I'm writing a simple Scala & Squeryl application. For test purposes, each time I run 'test' in sbt, an in-memory H2 db is created and populated with test data. After each run I can see that memory ...
user avatar
4votes
1answer
560views

Translating monad composition to SQL

I'm working on a language integrated query library in Scala (http://github.com/getquill/quill) and there's one type of monad composition that I'm struggling to generate the correspondent SQL query for....
user avatar
3votes
1answer
2kviews

How to configure Play! Framework to work with ScalaQuery and H2?

I already have some simple project with one migration script: # --- !Ups create table user ( name varchar(255) not null primary key, password varchar(255) not null ); insert into user ...
user avatar
3votes
3answers
8kviews

H2 Database Auto Server mode : Accessing through web console remotely

I am fairly new to H2 Database. As a part of a PoC, I am using H2 database(version : 1.4.187) for mocking the MS SQL Server DB. I have one application, say app1 which generates the data and save into ...
user avatar
3votes
1answer
766views

Slick insert into H2, but no data inserted

I'm sure I am missing something really stupidly obvious here - I have a unit test for a very simple Slick 3.2 setup. The DAO has basic retrieve and insert methods as follows: override def questions:...
user avatar
  • 9,716
3votes
2answers
1kviews

Package does not exist when running H2 under SBT

I have a Scala project using H2, in which I create a trigger using the following SQL: s""" | CREATE TRIGGER $triggerName | BEFORE UPDATE ON $inTable | FOR EACH ROW | AS ...
user avatar
2votes
4answers
445views

Array vs In-Memory database

I am building a REST API where I need to save 2D data (x: Double, y: Double) in application memory (no need to persist the data on disk). The no of records/data objects can grow/shrink in future. The ...
user avatar
  • 169
2votes
1answer
471views

Karaf unresolved constraint JDBC

I am trying to get a Scala library using H2 database loading in Karaf 3.0.0-RC1 and I got this error Unresolved constraint in bundle org.h2 [86]: Unable to resolve 86.0: missing requirement [86.0] ...
user avatar
  • 8,334
2votes
3answers
1kviews

Play2 and Scala, How should I configure my integration tests to run with proper DB

I'm trying to figure out how to write my db integration tests in my Play2 app. In my conf file I have specified two databases, xxx_test for regular use and h2 db for testing: db.xxx_test.driver=com....
user avatar
  • 5,993
2votes
2answers
19kviews

H2 in-memory database error "Data conversion error converting" when using UUID as primary key

I got the following error when using UUID as primary key with Slick with H2 in-memory database. I've tried to debug this for days, but no luck: Data conversion error converting "00000000-0000-...
user avatar
  • 1,004
2votes
1answer
276views

Scala Play Anorm: Placeholder not replaced

I've just started using Anorm and have stumbled across a weird behavior. When I try to do the following: val userTableName: String = "User" SQL("INSERT INTO {userTableName} (email, forename, surname, ...
user avatar

15 30 50 per page
1
2 3 4 5 6