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
125
votes
22 answers

org.hibernate.hql.internal.ast.QuerySyntaxException: table is not mapped

I have example web application Hibernate 4.3.5 + Derby database 10.10.1.1+ Glassfish4.0 with IDE NetBeans 8.0Beta. I have the next exception: Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: CUSTOMERV is not mapped at…
Vlad Dobrydin
  • 2,843
  • 3
  • 12
  • 8
57
votes
12 answers

Cannot create JDBC driver of class ' ' for connect URL 'null' : I do not understand this exception

Why does it say null URL and gives a empty ' ' class in the exception when I have provided the database URL? I am trying to connect to a derby database via a servlet while using Tomcat. When the servlet gets run, I get the following…
Suhail Gupta
  • 22,386
  • 64
  • 200
  • 328
54
votes
12 answers

Unable to start derby database from Netbeans 7.4

I downloaded Netbeans 7.4 and Java 7 Update 51. I get the below error when I try to start Java DB or derby connection from Netbeans. This is on a windows 8 PC. I downloaded the version for windows xp 32 bit at work. It works fine. I am not sure what…
Superman9999
  • 815
  • 3
  • 16
  • 30
45
votes
5 answers

Hive installation issues: Hive metastore database is not initialized

I tried to install hive on a raspberry pi 2. I installed Hive by uncompress zipped Hive package and configure $HADOOP_HOME and $HIVE_HOME manually under hduser user-group I created. When running hive, I got the following error message: hive ERROR…
As high as honor
  • 451
  • 1
  • 5
  • 3
44
votes
3 answers

Name [jdbc/mydb] is not bound in this Context

I see this question was raised several times already and I went through all of them. But I am still unable to fix my problem. Could anyone help me pinpoint what I am doing wrong? I get the following error message when I try to access database.jsp: …
lcazarre
  • 713
  • 3
  • 9
  • 15
36
votes
11 answers

Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database

I am trying to run SparkSQL : val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc) But the error i m getting is below: ... 125 more Caused by: java.sql.SQLException: Another instance of Derby may have already booted the…
Amaresh
  • 3,231
  • 7
  • 37
  • 60
33
votes
1 answer

Do I need to create separate index for primary key of relational database table

If I create table with primary key is index automatically created for the table or does that need doing separately. i.e if this is the table ddl CREATE TABLE release(guid varchar(36) NOT NULL PRIMARY KEY, name varchar(255),xmldata CLOB(512 K)) do…
Paul Taylor
  • 13,411
  • 42
  • 184
  • 351
31
votes
19 answers

SQLException: No suitable driver found for jdbc:derby://localhost:1527

I get this error in Netbeans: java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/ How is this caused and how can I solve it?
Ganesh
  • 311
  • 1
  • 3
  • 3
30
votes
10 answers

how to create table if it doesn't exist using Derby Db

I am new to apache derby and I cant seem to make work CREATE TABLE IF NOT EXISTS table1 ... as can be achieved in MySql etc. I am getting a 'Syntax error: Encountered "NOT" at line 1, column 17.', when I try to run this SQL statement in my…
midhunhk
  • 5,560
  • 7
  • 52
  • 83
28
votes
5 answers

Setting up an embedded Derby database in a standalone Java application

I'm trying to setup an embedded Derby database for a standalone Java application, but after pouring through all sorts of documentation, I just can't seem to find any simple explanations or examples. I'm using Eclipse with the Derby plugin and have…
Clark Minor
  • 281
  • 1
  • 3
  • 5
28
votes
8 answers

Getting rid of derby.log

I'm using the Apache Derby embedded database for unit testing in a Maven project. Unfortunately whenever I run the test I end up with the derby.log file in the root of the project. The database itself is created in the target directory…
Allan Lykke Christensen
  • 1,337
  • 2
  • 14
  • 21
26
votes
3 answers

Experience using Derby or HSQL in production mode

Anyone ever tried to use Derby or HSQLDB in a production environment? Any good, bad or ugly experiences?
tellme
  • 871
  • 5
  • 18
  • 23
25
votes
7 answers

How to get rid of derby.log, metastore_db from Spark Shell

When running spark-shell it creates a file derby.log and a folder metastore_db. How do I configure spark to put these somewhere else? For derby log I've tried Getting rid of derby.log like so spark-shell --driver-memory 10g --conf…
Carlos Bribiescas
  • 4,197
  • 9
  • 35
  • 66
25
votes
8 answers

Am I crazy? Switching an established product from HSQLDB to Apache Derby

I have an established software product that uses HSQLDB as its internal settings database. Customer projects are stored in this database. Over the years, HSQLDB has served us reasonably well, but it has some stability/corruption issues that we've…
CarlG
  • 1,656
  • 1
  • 17
  • 21
20
votes
7 answers

@GeneratedValue(strategy = GenerationType.AUTO) not working as thought

I'm trying to persist an object to a database. Keep getting 'Column ID cannot accept null value error'. My object looks like this: @Entity public class TestTable { @Id @GeneratedValue(strategy = GenerationType.AUTO) private Integer…
NullPointer0x00
  • 1,808
  • 3
  • 18
  • 20
1
2 3
…
99 100