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

user table with javaDB and Hibernate from within grails

let's see if I can ask this in an understandable way... I started with grails and created a domain class called user. As far as I understand, Hibernate is used to map this domain class to the database. This works pretty fine with hsqldb. Now I tried…
rdmueller
  • 10,742
  • 10
  • 69
  • 126
4
votes
2 answers

inserting data into database using jdbc

I have a java Desktop application. I am trying to insert data from two text field in to Database. But getting some runtime error. Help me to resolve it. Here is my code snippet final String s1 = t1.getText(); final String s2 =…
RAJIL KV
  • 399
  • 1
  • 7
  • 24
4
votes
3 answers

what is 'create=true' , connection javadb?

jdbc:derby:myDatabase;create=true what does create=true mean? Should all connetionurls hould have this create=true or just user and psw? Advanced thanks
Abel Jojo
  • 758
  • 3
  • 14
  • 30
4
votes
1 answer

Using timestampdiff in a Derby WHERE clause

I would like to simulate the effect of the following type of query (that is in Microsoft SQL Server syntax) in a Derby database. The goal is to return all records in the table where the date stored in "someColumn" is less than 7 days old. Here is…
John Fitzpatrick
  • 4,207
  • 7
  • 48
  • 71
4
votes
1 answer

Derby: Referencing Multiple Foreign Keys From Different Tables

Good day! I have been searching the Internet for an answer to my problem but I have not been able to get one. How do I reference foreign keys from different tables in a Derby database? This is my current SQL code: CREATE TABLE class_t (course_id…
Ace Eusebio
  • 403
  • 1
  • 7
  • 17
3
votes
2 answers

Creating a foreign key in Java db (Netbeans)

I've been having problems creating a foreign key in Java Db through Netbeans. I'm pretty sure I have to use an SQL command to change an attribute in the PLAYERS table into a foreign key as I can only specify primary keys through the interface. I…
Keith Edwards
  • 33
  • 1
  • 1
  • 3
3
votes
3 answers

How to SELECT data from in-memory Derby database table?

I have created an in-memory database table using JavaDB/Derby. I can INSERT data into the table. But it doesn't work when I try to SELECT data from the table. I create the table with: DECLARE GLOBAL TEMPORARY TABLE SESSION.memtable (id int, name…
Jonas
  • 121,568
  • 97
  • 310
  • 388
3
votes
3 answers

INSERT, and get the auto-incremented value

Consider the following table: create table language ( id integer generated always as identity (START WITH 1, INCREMENT BY 1), name long varchar, constraint language_pk primary key (id) ); To which I'd insert an entry this way. insert…
deprecated
  • 5,142
  • 3
  • 41
  • 62
3
votes
1 answer

JavaDB: get ordered records in the subquery

I have the following "COMPANIES_BY_NEWS_REPUTATION" in my JavaDB database (this is some random data just to represent the structure) COMPANY | NEWS_HASH | REPUTATION |…
medvaržtis
  • 128
  • 1
  • 11
3
votes
4 answers

Java DB Schema 'TEST' does not exist

Hy!!! I want to make a small DB Demo. My Error is: Schema 'TEST' does not exist Picture:
user547995
  • 2,036
  • 8
  • 33
  • 62
3
votes
1 answer

Start Glassfish Java DB on Eclipse

How do you start Java DB on Glassfish when Glassfish start, and on Eclipse IDE? The software versions are as follow: Eclipse 4.5.1 (Mars) Glassfish 4.1 (or 4.x) In the past there was an option in Eclipse preferences that allowed to do this. It used…
pntran84
  • 463
  • 1
  • 3
  • 11
3
votes
1 answer

Apache Derby - Syntax error: Encountered ";" at line 8, column 2

Making a small modular process in Java. However when i call the SQL statements from my website the system comes back with the error: java.sql.SQLSyntaxErrorException: Syntax error: Encountered ";" at line 8, column 2. Below is the first few lines…
Addramyr
  • 254
  • 4
  • 11
3
votes
1 answer

JavaDB ( derby ) path to database?

Using the embedded driver I can connect to my derby database using the JDBC url: jdbc:derby:mydbname But, I usually put the full path for the db like: jdbc:derby:/Users/oreyes/dbs/mydbname Is there a way I can just specify the db name and have…
OscarRyz
  • 196,001
  • 113
  • 385
  • 569
3
votes
1 answer

How to deploy a Java Swing application with an embedded JavaDB database?

I have implemented an Java Swing application that uses an embedded JavaDB database. The database need to be stored somewhere and the database tables need to be created at the first run. What is the preferred way to do these procedures? Should I…
Jonas
  • 121,568
  • 97
  • 310
  • 388
3
votes
1 answer

Java DB: can i remove tables created by derby

using: JDK 7, Eclipse Luna, Derby 10.8 I just learned how to use Derby/Java DB, and I need to know why it (derby) create these schemas and tables when I create a new DB: (image from eclipse Data Tools)
usertest
  • 2,140
  • 4
  • 32
  • 51
1 2
3
…
25 26