Stack Overflow
Stack Overflow

Questions tagged [derby]

Use this tag for questions about Apache Derby, an Apache DB subproject. Derby is an open source relational database implemented entirely in Java and available under the Apache License, Version 2.0.

Apache Derby, an Apache DB subproject, is an open source relational database implemented entirely in Java and available under the Apache License, Version 2.0.

Some key advantages include:

  • a small footprint
  • Java, JDBC, and SQL standards
  • embedded Java-based solutions in addition to traditional client/server support
  • and easy of installation and deployment.

From Java 6 onward a version of Derby is included in the JDK.

Useful Links

2643 questions
8
votes
4 answers

Have additional connections to Derby (read-only)

What I want to do: My application has a full connection to a Derby DB, and I want to poke around in the DB (read-only) in parallel (using a different tool). I'm not sure how Derby actually works internally, but I understand that I can have only 1…
BennyInc
  • 193
  • 1
  • 5
8
votes
1 answer

Spring with embedded derby: hibernate dialect deprecation

I have a spring application configured with spring boot and config annotations. JPA configuration is: @Configuration @EnableTransactionManagement @EnableJpaRepositories public class JpaConfiguration { @Bean public DataSource dataSource() { …
guido
  • 18,864
  • 6
  • 70
  • 95
8
votes
3 answers

SQL query with SUM on column in JOINed table

I have two tables in a derby database that I want to query together. Orders +----+--------+--------------+------------+ | ID | UserID | PurchaseDate | TotalPrice | +----+--------+--------------+------------+ | 1 | 1 | TIMESTAMP | 7.00 …
Henry Ing-Simmons
  • 1,362
  • 5
  • 18
  • 25
7
votes
1 answer

Where is Derby database stored when I create it from Netbeans?

Where is Derby database stored when I create it from netbeans? How Can I combine it with the rest of my project in one folder?
Xcoder
  • 266
  • 1
  • 5
  • 13
7
votes
1 answer

SQLNonTransientConnectionException: No current connection, in my application while interacting with Derby database

I implemented derby data base in my application to save my data,and I am getting this exception in retrieval of result set form select query in Derby database. To establish the connection I use connection string as: I establish connection using this…
user609621
  • 101
  • 1
  • 1
  • 3
7
votes
1 answer

Shutting down derby Network server doesnt delete db.lck

I'm trying to start Derby in Network server mode from my Java application with default port. Server starts successfully. Now I attempt to connect to a DB called 'myDB' on the server. The connection is established and db.lck gets successfully…
Kryptic Coder
  • 612
  • 2
  • 8
  • 20
7
votes
1 answer

Can't connect application to database

I have a problem connecting my Web app to the database using Eclipses datasource explorer. This is what I did: Maybe i did configure wrong the driver. This is how i configurated the driver definition from eclipse Helios.…
javing
  • 12,307
  • 35
  • 138
  • 211
7
votes
2 answers

I deleted the ExampleDS from Wildfly.Now I can't deploy my app, because I got errors like this.Any tips?

I deleted the ExampleDS from Wildfly.Now I can't deploy my app, because I got errors like this. Any tips? "WFLYCTL0412: Required services that are not installed:" => ["jboss.naming.context.java.jboss.datasources.ExampleDS"], "WFLYCTL0180:…
huistbor
  • 83
  • 1
  • 5
7
votes
1 answer

how much capacity Embedded derby has?

how much data java derby DB can store?
user542719
  • 307
  • 1
  • 9
  • 21
7
votes
2 answers

Spring @Transactional commit failures ; Deby + Eclipselink

The following is the spring config Date Source
vels4j
  • 11,208
  • 5
  • 38
  • 63
7
votes
1 answer

Aren't multiple transactions supposed to concur with em.getTransaction()?

When I execute: public void beginTransaction() { em.getTransaction().begin(); } following an active transaction started in the same way, I get the following exception: Exception Description: Transaction is currently…
simpatico
  • 10,709
  • 20
  • 81
  • 126
7
votes
1 answer

Programmatically setting derby.system.home

Need to move the database and log files of JavaDB (derby) db files into deployment directories. The database is working in the application startup directory as JavaDB creates a folder with the name of the database (in my case mydb), but I want to…
pn1 dude
  • 4,286
  • 5
  • 30
  • 26
7
votes
1 answer

Configured the HA Cluster with Hive-2.0.1(Derby Support) shows redundant database names?

I have configured the HA Cluster with one Namenode and one Standby and one data node. I have started derby database with hiveserver2(Hive-2.0.1). After started the hive server, open the beeline.cmd to check the number of database exists. It shows…
Mister X
  • 3,406
  • 3
  • 31
  • 72
7
votes
2 answers

Can I use MERGE INTO to simulate "upsert" in Apache Derby?

We're using Derby and have a lot of code which goes like this: try (ResultSet rs = executeQuery(...)) { if (rs.next()) { updateRowSet(rs, ...); rs.updateRow(); } else { executeUpdate(...); } } In the past, we…
Hakanai
  • 12,010
  • 10
  • 62
  • 132
7
votes
2 answers

Derby Auto Increment by 100 when specified as 1

I used the statement below to create a Derby database table with auto-increment primary column. CREATE TABLE \"table\" (\n" + " \"id\" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL,\n" …
Bruce
  • 8,609
  • 8
  • 54
  • 83
1 2 3
…
99 100