Category "database"

Two conditions in where tag of Liquibase

I want to add two conditions in where tag of liquibase and exception is thrown: Reason: liquibase.exception.DatabaseException: Unknown column 'uid' in 'where cl

Spring Boot Multitenant - Access data from multiple schema at the same time or per http request using spring boot

We are working on the multitenant application in spring boot. We have created different schema for different customer and we also have public scheme for super a

Data Synchronisation in Blue Green Deployment - Cloud

In a blue green deployment environment, I'm trying to use two separate database for each environment. In this case, How does realtime data synchronisation could

Delphi, linking database stored on onedrive

I would like to connect my ado connection to a database stored on onedrive so after the development of my application... It can be distributed to multiple users

Query through all provided schemas

I have kind of 'restaurant app' with multi tenant architecture. Each Tenant in short words have their Order table where I keep all data regarding orders which w

Meaning of Long in JPARepository?

What is Long here and what on basis do we configure this in JpaRepository? public interface FirstRepository extends JpaRepository<First, Long> { }

Errors when connecting to MySQL local database

So, I have my local database, set it up, ran it from the windows services window. I open MySQL Workbench, and try to connect to the server. Hostname is localho

Trying to find "magic combinations" in MongoDB

I have two MongoDB collections in a database named "records". Here's a sample document from the first collection: course_completions { "_id" : NumberInt(1

SQLAlchemy: What is the best way to validate a model before inserting or updating

I'm trying to validate a SQLAlchemy model before it is inserted or updated, e.g class MyModel(db.Model): foo = db.Column(db.String(255)) bar = db.Colum

Oracle 19c compatibility with jdk7

I would like to know if oracle 19c is compatible with jdk 7. I have found out 2 drivers for oracle 19c ojdbc8 : for jdk8, jdk9 and jdk11 ojdbc10 : for jdk10 and

How can I get a React application to send SQL queries to an Oracle database and retrieve results?

Background: I need to create a web application that connects to an Oracle database hosted by my university through a VPN. The app does not have to be hosted onl

How to check keyspace and table size in Amazon Keyspaces

We recently migrated from Cassandra to AWS Keyspaces and I am just wondering how to check for table and keyspace total size in AWS keyspaces. Any help or sugges

What does the function fn:data() do in exist-db?

I would like to know what the fn:data() function does in exist-db. I can't find the answer anywhere on the web.

Unable to drop database mysql: ERROR 3664 (HY000)

I have a database in my application named X-Files. I want to drop it. But whenever I run the command drop database X-Files I am getting following error: mysql

How can I display the header of columns of all tables within a SCHEMA

I would like to list out all the tables and column headers within a SCHEMA to be displayed in Rows within MySQL, I can't seem to find an answer online and would

How to consolidate TypeORM migrations

At the moment I'm not a guru on TypeORM and have made a few mistakes with my migrations - with our non-production database now in a state where I'd like it, is

After submitting the data from the form it directs to white screen

I have an issue when I clicked the button and submit the data from the form.it gets directly to the white screen and nothing happen I checked the database it do

ClickHouse connection refused after shut down Linux OS (error Code: 210. DB::NetException: Connection refused)

I saw a previous post on StackOverflow related to my question. I tried to handle this connection problem by entering sudo nano /etc/clickhouse-server/config.xml

MongoDB Updating Boolean Inside Object

I am trying to update a boolean inside of an object in my discord.js v13 bot but it does not update here are the things i've tried: await gu

'The variable name '@' has already been declared. Variable names must be unique within a query batch or stored procedure.'

string subject= "INSERT INTO Subjects (ThesisNo, [Subject]) VALUES (2, @subject)"; SqlCommand commandSubject = new SqlCommand(subject,con); string temp