Category "database"

Cloudkit Public Database Error: "WRITE operation not permitted"

I have currently a problem with the CloudKit Public Database. Sometimes I receive an error when modifying records: Permission Failure" (10/2007); server messag

When logging in to Oracle Enterprise Manager, it is asking me for the credentials again. Why?

I'm trying to log in to: https://localhost:5500/em/login First, I entered my credentials at the bottom right area. Then, I clicked the button. After that, a po

Managing database connections in Node.js, best practices?

I'm building an Node application which will query simple and more complex (multiple joins) queries. I'm looking for suggestions on how I should manage the mySQL

Query to order by the last three characters of a column

Query the name of any student in STUDENTS who scored higher than 75 marks. Order your output by the last three characters of each name. If two or more students

How to store sets of objects that have occurred together during events?

I'm looking for an efficient way of storing sets of objects that have occurred together during events, in such a way that I can generate aggregate stats on them

What are other options for storing data in a web application besides a database? [closed]

I have a pretty small database (15 tables, ~1000 rows) that is being accessed very frequently to get data. I was wondering what other options

What does GRANT USAGE ON SCHEMA do exactly?

I'm trying to create a Postgres database for the first time. I assigned basic read-only permissions to the DB role that must access the database from my PHP scr

Pimcore Database Installation on a Different Server

I have just started using Pimcore and deployed its a mysql database on another server. During its installation, it couldn't connect to the database. I created t

QSqlQuery::exec: database not open

I'm working on qt, my database was rightly connected with qt but suddenly i have the following problem every time i debug,,,i i become not able to fetch or to a

Spring Batch Framework - Auto create Batch Table

I just created a batch job using Spring Batch framework, but I don't have Database privileges to run CREATE SQL. When I try to run the batch job I hit the error

'No compatible servers were found' error message

When I install the MySql Workbench, it show this message: No compatible servers were found. You'll need to cancel this wizard and install one. But I beli

MongoDB "Writing to log file failed, aborting application"

After save about 80G data, mongodb just crash. journalctl -u mongod shows the error message below mongod[4948]: {"t":{"$date":"2022-03-31T10:38:44.089+00:00"},"

NameError: name '_mysql' is not defined after setting change to mysql

I have a running Django blog with sqlite3 db at my local machine. What I want is to convert sqlite3 db to mysql db change Django settings.py file to serve MySQL

Reading data from Sqlite Database in android application.

I am trying to read data from a database. I imported the database in the sqlite manually and now just want the connection made in android application and want t

How should I resolve --secure-file-priv in MySQL?

I am learning MySQL and tried using a LOAD DATA clause. When I used it as below: LOAD DATA INFILE "text.txt" INTO table mytable; I got the following error:

How to create identity column when importing data from Excel into MS SQL Server (with Import and Export Wizard)?

I need to import great amount of data from excel into MS SQL Server, using the Import/ Export Wizard. Then I'll continue importing more data into the same table

JDBC Derby driver not found

I've followed the JDBC tutorial at: http://docs.oracle.com/javase/tutorial/jdbc/basics/gettingstarted.html, and managed to build and create my own JDBC database

Unable to connect to Azure Database from a web app deployed on Azure App Services account

I deployed a web app on Azure App Services. When web app tries to connect to the Azure SQL Database connection failed. I downloaded the event log from Kudu, I f

Is tagging a form of data mining?

I am implementing a small CRM system. and the concept of data mining to predict and find opportunities and trends are essential for such systems. One data minin

django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

The problem Im facing while trying to connect to database for mysql. I have also given the database settings that i have used. Traceback (most recent call las