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
13
votes
4 answers

Automatically start JavaDB (Derby) on GlassFish

I am planning to deploy GlassFish v3 open source edition to a production environment. It comes with JavaDB (Apache Derby) which is just what I need. The only problem is that JavaDB is not started by default when GlassFish starts. I would have to…
del.ave
  • 1,888
  • 5
  • 17
  • 23
13
votes
1 answer

JPA 2.0 Criteria and grouping of Predicates

I encounter problem with Hibernate EntityManager 3.5.3-Final when it comes to composite predicates. Example (not actual code snippet, but the idea should be clear): CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder(); Predicate…
Jarek Rozanski
  • 780
  • 1
  • 6
  • 13
13
votes
7 answers

Derby vs PostgreSql Performance Comparison

We are doing research right now on whether to switch our postgresql db to an embedded Derby db. Both would be using glassfish 3 for our data layer. Anybody have any opinions or knowledge that could help us decide? Thanks! edit: we are writing some…
Austin
  • 139
  • 1
  • 1
  • 3
12
votes
2 answers

Persisting an entity when ID is null and automatically generated in the database

I'm using EclipseLink with JavaDB and every time I try to persist a new user entity I get an error relating to the fact the ID field of the new user entity is null. I know it's null -- and it should be because the ID field is generated as the…
Richard Barker
  • 1,161
  • 2
  • 12
  • 30
12
votes
4 answers

Exporting Derby database in Netbeans

I have a project with a derby database in it. I want to be able to make a backup or export the database so I can give it with the project files to my lecturer.
Steven
  • 123
  • 1
  • 1
  • 7
11
votes
2 answers

Does Derby support table and column comments?

Does Derby support table and column comments?
Rakesh Goyal
  • 3,117
  • 8
  • 39
  • 69
11
votes
1 answer

Declaring foreign key in Apache Derby database

I am using Apache Derby database with ij 10.10. I have two tables. First is usertable and the second is logintable. In my usertable I have two columns: userid and name. My logintable table has two columns: userid and password. I need to set one…
rainu
  • 733
  • 2
  • 12
  • 26
11
votes
11 answers

SQL LIKE Performance with only the wildcard (%) as a value

I am wondering what the performance of a query would be like using the LIKE keyword and the wildcard as the value compared to having no where clause at all. Consider a where clause such as "WHERE a LIKE '%'". This will match all possible values of…
Chris Dail
  • 25,715
  • 9
  • 65
  • 74
11
votes
2 answers

where is org.apache.derby.jdbc.ClientDriver?

I downloaded the jar of Core Apache Derby database engine, which also includes the embedded JDBC driver (10.9.1.0). But that jar doesn't include the .class file of ClientDriver in the jdbc package. Why is that ? Where can i find this class file ? I…
saplingPro
  • 20,769
  • 53
  • 137
  • 195
11
votes
4 answers

data sources derby - connection refused

I am trying to connect a database with a java project. After reading some tutorials and the course support, I have understood that I need to make a new data source under the Admin Console. So, I've logged in into the admin console, then navigated…
Steffi
  • 867
  • 5
  • 14
  • 29
10
votes
1 answer

Derby DB SQL, Select Rows starting from row number

How can I select from row X to row Y in a SQL query in Derby DB? For example: I would like to select rows 15 - 30, but not top 15. Select all the rows starting from row number 30. I tried LIMIT and ROWNUM but they do not work. How can I do it in…
Junior Programmer
  • 310
  • 1
  • 6
  • 20
10
votes
8 answers

Alter a table column with auto increment by 1 in derby

I have created a table in derby Netbeans and now i realize that i need to make a column as auto incremented by 1 which is a primary key. How can i do so? I tried the following code but was in vain. ALTER TABLE ISSUERECIPT ALTER IRCODE SET INCREMENT…
Nitesh Verma
  • 1,795
  • 4
  • 27
  • 46
9
votes
1 answer

apache derby - explain select

I'm programming Java application working with Apache Derby and i'm looking for equivalent for "explain" statement (working for mySQL for example). It's not working in Derby. Is there something similar?
planky
  • 440
  • 1
  • 4
  • 16
9
votes
6 answers

How to use SEQUENCE in Apache Derby?

I'd like to use SEQUENCE support in Apache Derby 10.7. I've created the sequence with the following statement: CREATE SEQUENCE SAMPLE_SEQ AS INT MAXVALUE 999999 CYCLE; How can I select next/current value from the SAMPLE_SEQ? Could you please help…
Tomasz Błachowicz
  • 5,731
  • 9
  • 41
  • 47
9
votes
1 answer

Warning when using Apache Derby in memory

I have a number of unit tests, which use Apache Derby in memory. My connection url is: jdbc:derby:memory:srf.derby;create=true I discovered that each time, when a method marked as @Transactional is finishing, I receive a Derby warning 12:53:28:5328…
Pavel Bernshtam
  • 4,232
  • 8
  • 38
  • 62
1 2
3
…
99 100