428 questions
1
vote
0
answers
40
views
Conditional data sources in SpringBoot integration test
I have a SpringBoot app and I have added JUnit5 integration tests that use testcontainers:
class ControllerClassTest extends AbstractIntegrationTest {
@ParameterizedTest(name = "{0}")
...
- 11
-1
votes
1
answer
76
views
JDBC won't connect to a database in .java program with the derby ij tool open after I disconnected from the database in Ij
I have a UserDataDB that I cannot get a connection to in a Java program after I was connected to it in Windows CMD. With java org.apache.derby.tools.ij open in CMD I connect to UserDataDB and ...
2
votes
0
answers
139
views
Hsqldb and PostgreSQL string_agg: object not found
My Spring Boot web application uses PostgreSQL v12 for production and h2 v2.1.214 embedded database for unit testing.
It worked well until I have a native query to test.
This query uses the string_agg ...
- 538
1
vote
0
answers
39
views
Why foreign key is invalid in eXtremeDB?
I installed eXtremeDB emebeded on my Ubuntu 20.04, and tried following commands:
CREATE TABLE coops (id1 INT NOT NULL, name string NOT NULL, PRIMARY KEY (id1));
CREATE TABLE factories (id INT NOT ...
- 402
1
vote
0
answers
761
views
Issue with persisting data using de.flapdoodle.embed.mongo
I'm having trouble with persisting data using de.flapdoodle.embed.mongo. I've followed the documentation and examples I found online, but when I shut down my application, the data disappears.
Here's ...
- 103
0
votes
1
answer
480
views
Spring data per request repository on in memory database
I'm writing a RESTful web service using spring boot. For some computations could be useful load input data into a table of an in memory database (e.g. Hsqldb) and do some aggregations and calculus. ...
0
votes
1
answer
143
views
c++ embedded database to store numeric data coming from stl vectors and retrieved through stl vectors?
i'm looking if there is any database with c++ interface in order to store and receive numeric data (int,unsigned int, doubles,floats etc) but also strings.
My application usually contains data in the ...
- 11
2
votes
2
answers
8k
views
postgresql as an embedded Database
Need a small help regarding the embedded version of PostgreSql. I see that we can create an embedded form of PostgreSql https://github.com/zonkyio/embedded-database-spring-test . But the page ...
- 337
0
votes
0
answers
240
views
Can realmdb be used as embedded database in a springboot or any other standalone application?
We are looking for an embedded database that ships with application jar file and runs along side the application. This database should also sync data with Mongodb Atlas. We have found Realmdb to be a ...
- 11
1
vote
0
answers
248
views
How do I set the encoding for non-Latin characters in zonky Embedded?
I have a spring-boot application. I use a postgres database. Migration of the database is done with liquibase. When executing liquibase changesets I fill some tables, with some characters. For testing,...
- 71
3
votes
0
answers
1k
views
Connecting to existing in-memory H2 from different application/process
I have a simple Quarkus application that uses an in-memory H2 database. The JDBC connection string has some custom settings: jdbc:h2:mem:quarkus_db;DATABASE_TO_LOWER=TRUE;DB_CLOSE_DELAY=-1;MODE=...
user4695271
0
votes
2
answers
1k
views
How to work with multiple connections to a single database?
I'm new to stack overflow and I am currently using NetBeans with java to make a desktop app where multiple users can access one database at the same time. But unfortunately, I tried several codes ...
- 11
1
vote
1
answer
648
views
Integration tests sometimes throw "java.lang.IllegalStateException: Data source context must be initialized"
It seems to happen randomly when running integration tests that need docker.
Happens only on Windows.
stack trace:
java.lang.IllegalStateException: Data source context must be initialized
at io....
- 11
0
votes
0
answers
2k
views
How to use RocksDb to make many concurrent writes and reads without database loosing data between hosting desktop app launches?
I'm building a product, Zet Universe, that enables users to work with data coming from different sources in one place. It's a desktop app for Windows, it has multiple plugins that obtain data from ...
3
votes
1
answer
247
views
RavenDB embedded with Raven Management Studio?
Is it still possible to use the Raven Management Studio with embedded? I only find 10 year old Questions with guides that use Parameters/options that don't exist anymore.
- 145
0
votes
1
answer
1k
views
Java EmbeddedDatabase (H2) logging
I would like to change the logging of my EmbeddedDatabase. Atm every time I open a connection it logs "... Creating new JDBC Driver Connection to ...". In my test suite, I open for every ...
user18513066
0
votes
1
answer
363
views
Does using mysql's api belong to Embedded database?
I am confused about "Does using mysql's api belong to Embedded database?",cuz I think using mysql's api only belongs to "Remote connection to the database".For example,I use mysql'...
- 21
1
vote
1
answer
400
views
Which database( embedded or normalized) is better in terms of scalability?
We know that MongoDB uses sharding to provide horizontal scaling. These clusters support deployments with large data sets and high-throughput operations. Sharding allows users to partition a ...
- 11
13
votes
2
answers
21k
views
Unable to make field long java.nio.Buffer.address accessible: module java.base does not "opens java.nio" - LMDB using Java API
I'm trying to create DB and env using LMDB. I'm facing an issue on Env. create().
I have used LMDB documentation for this.
Exception in thread "main" java.lang.ExceptionInInitializerError
...
- 156
-2
votes
1
answer
231
views
Desktop application database for python program [closed]
I am designing a desktop application using Python.
I am facing a problem in choosing the most appropriate database, the program works online and offline.
In the case of offline, there is no problem ...
0
votes
1
answer
724
views
NoSQL embedded database with data change notification callback
I am using SQLite embedded in a .Net Desktop application developed with WPF.SQLite provides a callback for any write operation performed to the database (within the same connection) ref
In this ...
- 308
0
votes
1
answer
108
views
H2 database: Is NIO JVM bug message related to H2 (and possibly database corruption)?
We're currently using H2 version 199 in embedded mode with default nio file protocol and MVStore storage system. In some installations we encounter DB corruption within minutes after batch operations (...
0
votes
1
answer
421
views
H2 database: Does a 60 second write delay have adverse effects on db health?
We're currently using H2 version 199 in embedded mode with default nio file protocol and MVStore storage system. The write_delay parameter is set to 60 seconds.
We run a batch insert/update/delete of ...
0
votes
2
answers
2k
views
How to configure in memory embedded database for mongoDB similar to H2 Database in Spring Boot
I am trying to configure in memory embedded Mongo database with Spring Boot similar to H2 Database. Is there any option available in Spring Mongo?
-2
votes
1
answer
315
views
Keep track of users' actions without external database
Long story short: We're looking for a way to record the progress of users on our .NET website, ideally with an asset stored on the application layer. We need to be able to download the stored data (...
- 61
0
votes
1
answer
650
views
How to get the generated ID of an auto increment column after insertion of a record in HSQLDB within same connection?
I have created a table as
create table test(log_id integer identity primary_key, filename varchar, filecontent blob)
Now my query in java inserts values in test using prepared statement as
...
- 123
0
votes
1
answer
69
views
Unable to retrive data from GDBM databas from differnt function in c
hi there i am trying to develop 3 tier server with embedded database.
my issue is that i am able to save data in gdbm database but when i try to retrieve data from other functions it always returns ...
- 13
1
vote
1
answer
1k
views
h2 database persists data but resets on application start
I have a basic test for an embedded database that I'm trying to get working for a java project. As it stands now I am able to save rows to the database with my entity repository object, and after the ...
- 339
0
votes
1
answer
471
views
Import data from mysql workbench to H2
I'm trying to import data from mysql workbench to H2 and I got this error.
CREATE TABLE `jobs` (
`id` int NOT NULL AUTO_INCREMENT,
`engjob` varchar(45) NOT NULL,
`itajob` varchar(45) NOT NULL,
...
- 1
0
votes
1
answer
553
views
HSQLDB server connection using username and password in server startup command in cmd is not working
i am starting hsqldb server with db_name as MDB and credentials as user=test and password=test using command prompt as:
java -cp hsqldb.jar org.hsqldb.server.Server --database.0 file:/E:/DB/mdb --...
- 123
-1
votes
1
answer
103
views
Do foreign keys in Apache Derby automatically populate a column?
I've been trying to create an Apache Derby RDB, but the columns I have with a foreign key constraint will not populate with the values of the referenced column (it will have null values). The only way ...
0
votes
1
answer
124
views
How to make a file path compatible with an embedded database? (Apache Derby Embedded)
Recently I've been trying to use a JFileChooser to select where a database will be created; however, the problem I've run into is that the file path that I got from the JFileChooser has it has ...
1
vote
1
answer
426
views
Is there any embedded database for Node.js that allows to use mongoose driver API?
I'd like to use mongoose driver API in my web application but I'd like also have an embedded database for my app. I don't want install mongodb in the server.
Is there any embedded database for node.js ...
-1
votes
1
answer
186
views
HSQDLDB throws ArrayIndexOutOfBoundsException: when encrypted DB is introduced
//java code in netbeans
//Registering the HSQLDB JDBC driver and getting connection
Class.forName("org.hsqldb.jdbc.JDBCDriver");
con = DriverManager.getConnection("jdbc:hsqldb:...
- 123
4
votes
0
answers
590
views
Where to put an embedded database in an AspNet Core application
I have lately re-discovered embedded databases such as Sqlite (sql, relational) and LiteDb (noSql) and I like working with them for small web apps or mobile apps.
However, I cannot find any good ...
- 16k
0
votes
1
answer
1k
views
Is there 1 GB data storage space in any 1 table of MySQL?
We have web-based app in production with thousand of users. We analyzed embedded DBs and while reading about data storage capacity of mySQL, we come across this
Each individual table should not ...
- 123
0
votes
1
answer
36
views
MongoDB group elements in an array
I want, for each product_id, the sum of prices in all orders and another result that I want to achieve is the sum of the price for products in the same array an same id.
\\orders collection:
{
...
0
votes
0
answers
353
views
How to deploy embedded database contained within .jar file?
I'm currently developing a java application where users shall be able to create profiles, sign in with their login data, store some information connected to their user profile, etc. within a database. ...
- 405
1
vote
0
answers
1k
views
H2 in-memory database error “Data conversion error while using GEOMETRY" (JdbcSQLException: Data conversion error converting)
I am getting below error while loading GeoJson into H2 table .
Please help.
a8155d5f4049c052934acaff7ff80000000000007371007e0020bfc3e16d6dc1a47b4049c054477ff1527ff8000000000000' (CZONE: THE_GEOM ...
- 11
0
votes
1
answer
155
views
Embedded Java Database with Restore Point and Flashback system
I'm looking for a java embedded database that having functionality for doing something similar to undo-redo like create restore point / flashback on Oracle Database.
I want to create a restore point ...
- 119
3
votes
2
answers
7k
views
java.lang.NoClassDefFoundError while connecting to Embedded Derby Database
I'm using Apache NetBeans IDE 11.3 (with JDK 13) and Derby in Embedded Mode. I am getting the following error while connecting to the database:
Exception in thread "main" java.lang....
- 111
0
votes
1
answer
1k
views
When should you use RocksDB or LevelDB
In the scenario where you've stored ~1TB of key/value, and need to provide a production API to 1000s of users.
Further, the store will only be used for read operations only (after 1-time initial write)...
- 5,827
4
votes
1
answer
4k
views
Is there a way where we can test Postgres Jsonb queries using embedded database for Unit Testing?
I want to unit test In Java Spring-boot Postgres native query for jsonb datatype without hitting the actual DB.Instead using some embedded database or other approach ,but embedded databases like H2 ...
6
votes
1
answer
10k
views
Fixing deprecated SimpleMongoDbFactory to SimpleMongoClientDbFactory break Embedded Mongo tests
I work on a project which was extending SimpleMongoFactory to enable multi tenancy
public class MultiTenantMongoFactory extends SimpleMongoDbFactory {
After migrating from Spring boot 2.1.10 to 2.2.1,...
- 61
0
votes
1
answer
130
views
Can I use an embedded database to store accounts?
We are working on java game application and want to add an account login system to it. Our plan was to set up a web server (Spring) and a database (postresql), and handle login requests from the app ...
- 23
0
votes
1
answer
427
views
Spring embedded Mongo DB
I have a project with Spring Boot and Embedded Mongo DB also i want to look up the data that has been stored there. how to that
i followed this tutorial https://springframework.guru/spring-boot-with-...
- 361
0
votes
0
answers
277
views
Embedded DBs compatible with SQL Server Data
Working on a JAX-RS application which uses Microsoft-SQL-Server as a Database.
It does not use any ORM frameworks, just plain old JDBC.
Most of the application's operations involve store and retrieve ...
- 8,191
0
votes
0
answers
457
views
Embedded database error : Why it is giving null result
I am trying to write Junit test case for my repository class which has jdbctemplate using embedded database.
But when I am running the test method, the query is returning null. From logs I can see ...
1
vote
2
answers
689
views
Is it possible to compact an embedded HSQL DB from a Spring Boot application?
I've created a Spring Boot application with an embedded, file-based HSQL database. The data file being created is getting fairly large, especially given the usage model, so I'm wondering if there is a ...
1
vote
1
answer
1k
views
Run Liquibase over Wix Embedded MySql
Currently I have some new modules using Spring Boot and a H2 embedded database for functional testing.
The legacy module works with a lot of Liquibase scripts to construct the whole database.
I was ...
- 2,841