2,636 questions
Advice
0
votes
1
replies
50
views
H2 Database - Reclaiming unused space like Derby
With the recent retirement of Apache Derby, I'm migrating my database to H2.
In my Spring application, I have a cron job that executes the following Derby native query in order to reclaim unused space:...
0
votes
0
answers
40
views
Can't connect to derby DB in data source explorer provided by Eclipse IDE
I am using Ubuntu 24.04 and Eclipse IDE. I wish to configure Derby DB in the Data Source Explorer in Eclipse. However, when I attempt to set up a database connection, I don't see a list of database ...
2
votes
1
answer
153
views
Spring Boot and Apache Derby - IllegalStateException: Cannot load driver class: EmbeddedDriver
After verifying with several tutorials and Stack Overflow questions for similar errors, I am not able to solve the below issue.
I want to use Apache Derby DB in embedded mode and below is how I ...
- 2,077
2
votes
1
answer
110
views
Setting class path property for Apache Derby
How does one go about setting the class path property for the Apache server derby. I am trying to debug this error upon creating a procedure and linking it to a Java function as the external name:
The ...
- 153
0
votes
0
answers
43
views
In Apache Derby, for large data churn, do you need to compress?
The TLDR: In a high churn Apache Derby database, if we never compress the database and only do an update statistics, will that affect performance long term?
We have an Apache Derby database running as ...
- 103
2
votes
2
answers
417
views
Artifactory 7.90.6 to 7.104.7 upgrade: fail to apply migrations (derby)
I tried upgrading artifactory 7.90.6 to 7.104.7. Created a backup of the artifactory/derby and access/derby derby dbs.
Launching the new version, a db migration fails. Looks like multiple JVMs attempt ...
- 1,934
1
vote
1
answer
95
views
Class org.apache.derby.jdbc.ClientDriver not found despite derbyclient.jar being in CLASSPATH
I'm running this via Visual Studio Code and have the Language Support for Java (TM) by RedHat extension. The quickstart code I am using is found here. I modified it slightly to become this:
import ...
0
votes
1
answer
31
views
How to get running count as part of a query in Apache Derby
I am trying to get a sort of "running count" from data in a Apache Derby database.
E.g. sample selected data
Part1
Part2
d1
a1
d1
a2
d2
a1
d2
a2
I would like to write a SQL statement which ...
- 16k
0
votes
0
answers
44
views
During migrating from infinispan v9.3 to v13, getting error in putAll cache update with Derby Database
During migrating from infinispan v9.3 to v13, getting error in putAll() cache update with Derby Database.
I am using derby 10.14 as my persistance store, when i am tyring to update a batch of data ...
0
votes
1
answer
241
views
Creating a new local Spark session after stopping previous one: Spark tells me that Derby is not stopped
In my unit tests I have to stop a local Spark session and create another one (using the data in metastore saved from previous session).
But when the another Spark session is created it cannot use my ...
- 3,681
0
votes
1
answer
172
views
Bean instantiation via factory method failed; Unsatisfied dependency expressed through method 'dataSourceScriptDatabaseInitializer
SpringBootDerbyApplication
package guru.springframework;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@...
- 529
0
votes
1
answer
65
views
java.sql.SQLSyntaxErrorException: Error de sintaxis: Encountered "USER" and "ORDER"
I was doing a project on NetBeans, using GlassFish and JDBC. I was working on some views using JSP and my project suddenly crashed. I tried searching for a solution but can't get to solve it. This is ...
- 111
0
votes
1
answer
136
views
Apache derby no suitable driver found
I'm developping a Java application and everything runs smooth on Eclipse.
This a maven project and no error in my pom.xlm.
When I export the project to a runnable JAR file, either by coping/packaging ...
- 116
0
votes
1
answer
154
views
Running Swing Maven jar app through command line doesn't build database, but it does when running the same app from NetBeans, how to fix?
I wrote a Maven Java swing application with Apache derby embedded mode.
Used flyway-database-derby to migrate the database (to create the database).
Used maven-shade-plugin to "Clean and Build&...
- 321
-1
votes
1
answer
79
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 ...
