Stack Overflow
Stack Overflow

Questions tagged [javadb]

Java DB is Sun's supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based SQL, JDBC API, and Java EE yet small, only 2.6 MB.

Java DB is Oracle's supported distribution of the Apache Derby open source database. It is fully transactional, secure, easy-to-use, standards-based SQL, JDBC API, and Java EE yet small, only 2.6 MB.

380 questions
1
vote
0 answers

JavaDB embedded database can not create table?

I want to create embedded database using JavaDB derby and create a table inside it, Program works fine inside NetBeans when run the program and every thing went OK, when I build the program and run it outside NetBeans the program creates the…
ahmadx
  • 11
  • 2
1
vote
0 answers

How do we distribute the javadb along with a jar so that it starts automatically when jar is run?

I have created a project which needs a Javadb connection. What is the best way to distribute the javadb along with my jar? Is there a way to include it in the jar itself and start it when the jar is loaded? I am new to javadb, any help would be much…
AnOldSoul
  • 4,017
  • 12
  • 57
  • 118
1
vote
0 answers

How can I programmatically export and import java db with its data?

I have lots of data to be exported from one machine and imported into another. Therefore I need to write a Java application to export the entire database along with its data and then run another java code to import it into another machine. I saw…
AnOldSoul
  • 4,017
  • 12
  • 57
  • 118
1
vote
0 answers

No suitable driver found for jdbc (only in jar file)

I'm using netbeans to create a simple java maven application with a very simple JavaDB database connectivity. I've configured the dependencies in maven pom.xml file as follows, and my application works correctly when I run it from the…
tybandara
  • 279
  • 2
  • 10
1
vote
1 answer

Why my data does not get persisted?

I am using JPA and Java Embedded DB in my application. I try to write some data to the database and when i try to read it back I am able to do it. But the application is closed and when I open it again none of the data exists. Here is my…
rgksugan
  • 3,521
  • 12
  • 45
  • 53
1
vote
2 answers

In Derby DDL how to concatenate string and number as identity

I've looked everywhere in the last 3 hours but still can't get this to work. I need to be able to concatenate the 1prefix and 1suffix value to form an id consisting of string and number. How do I define the table. create table dicounts_list ( …
heisenberg
  • 1,784
  • 4
  • 33
  • 62
1
vote
2 answers

JavaDB: Is it possible to change auto-increment offset on existing table?

Is it possible to change the auto-increment offset on a pre-existing table with JavaDB? I'm having a problem where inserting new records usually (but not always) fails with an error complaining about using an existing key (my auto-increment…
Tim Frey
  • 9,901
  • 9
  • 44
  • 60
1
vote
1 answer

Installing Java EE 6 Tutorial examples: JavaDB error (java.sql.SqlNonTransientConnectionException: recv failed)

I'm trying to install and run Java EE 6 Tutorial examples. In this particular case, Duke's Forest Case Study Example. No problem with first install step "To Create the JDBC Realm and Populate the Database", apparently the JavaDB is created and…
madvargas
  • 21
  • 1
  • 8
1
vote
1 answer

SQL Foreign keys not auto incrementing

When I comment out every call of the foreign keys the code runs, creates the tables correctly and fills them with the incrementing id, but when I call the foreign keys in it just breaks and the id stays as null CREATE TABLE CustomerDetails ( …
Matt Richardson
  • 31
  • 3
1
vote
2 answers

how can i delete javaDB database folder

I am using JavaDB in my application,different database files are created on each operations and i want to delete all database files at the close of application but on close database folder not deleted from file system path using file method…
raji
  • 31
  • 3
1
vote
1 answer

Java DB and jasper report nested select

I'm creating nested select view to be run in Jasper Netbeans report from JAVA DB , and need to distinct the grouped based on same below statement either by CASE injected inside the select or using if is workable inside JAVA DB or any other way, last…
Mohamed Bawaneen
  • 139
  • 1
  • 12
1
vote
0 answers

Java - Cannot modify Embedded Database table using variable

I'm using Java Netbean with Embedded JavaDB at directory D:. First, when I build this project i can CRUD without problem, but after moving to embedded Database, now i cant use delete or update SQL(using local String variable), With this SQL it…
newbie
  • 11
  • 1
1
vote
1 answer

dump JDBC Derby database to a SQL script

I think this task should be obvious but I couldn't find how to do it. I am going to create a Java DB database (Derby) that will later be copied from my computer to another computer through a SQL script. Can I create it using Netbeans' GUI and then…
phunehehe
  • 8,618
  • 7
  • 49
  • 79
1
vote
1 answer

howto: in-memory derby db with glassfish

I need run arquillian+junit tests on a remote Glassfish 4.1 server. The database tables for these test cases needs to be (1) created in-memory, (2) with embedded JavaDB and (3) dropped after the test execution. Would the following…
Kiran Mohan
  • 2,696
  • 6
  • 36
  • 62
1
vote
1 answer

Change tables from Boilerplates Java DB Web Starter sample code on bluemix

I'm currently studying the sample code from the Boilerplates Java DB Web Starter app on bluemix and I'm having some troubles changing the table. My DB is ready and functioning there. I tried to change the code to instead of getting from the todolist…
Daiane
  • 35
  • 8
1 2 3
…
25 26