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
0
votes
1 answer

JavaDB throws error when boolean is used. why?

This is the table I try to create in JavaDB. CREATE TABLE USER( userid INTEGER NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), displayName VARCHAR(20) not null, username VARCHAR(15) not null unique, password…
Sathish Kumar k k
  • 1,732
  • 5
  • 26
  • 45
0
votes
1 answer

Using Text Box Value as the 'Where' clause in SQL query

I'm using javadb(netbeans) for a project and I am a total beginner. I have a small app which searches an address database and brings back a data grid of results. The users tpyes in all, or part of a street name into a jtextfield, hits a search…
pank
  • 1
  • 1
0
votes
1 answer

How to create tables in JavaDB and prepareStatement?

I am having problems adding data to my database when I am adding "ALTER TABLE" to my tables. I am getting the information from a web page I am working on and is written to a java method that transfers the information to my Database. Everything works…
CronbachAlpha
  • 355
  • 1
  • 5
  • 14
0
votes
1 answer

Java DB (aka Derby) doesn't restore database from a backup

As I've read from the apache manuals, I tried to restore my embedded Java DB (AKA Derby) Database using this code: private void restoreBackup() { FileDialog fileDialog = new FileDialog(new Frame(), "Choose A Backup Folder)", FileDialog.LOAD); …
Igor
  • 1,532
  • 4
  • 23
  • 44
0
votes
3 answers

Query to fetch last value in a column in derby database table

I want to fetch last value in a column in a row in a derby db table. Can someone help me?
crazyvi
  • 57
  • 1
  • 1
  • 11
0
votes
0 answers

Netbeans calling SQL commands from a text file

I want to get Netbeans to look at a text file where I have written loads of SQL commands to be executed. I'm sure it can be done, but searched and cannot find how. I am using Netbeans 7.3 Beta 2, OS X ML, Java DB and writing in Java.
John Vasiliou
  • 977
  • 7
  • 27
  • 48
0
votes
1 answer

How to Create Database IDs from Java Code?

I am manually incrementing my ID number in my database as I can't get it to work automatically. It is for a project and doesn't matter if it doesn't work automatically - I can try and solve that later. I am creating a method which checks for the…
John Vasiliou
  • 977
  • 7
  • 27
  • 48
0
votes
2 answers

How should I model my system - database implication

I have a main class, a login class and a gui class. Within my main I am creating a database connection using the Singleton pattern - only one instance of this connection. I want to access the database connection from login, to verify users upon…
John Vasiliou
  • 977
  • 7
  • 27
  • 48
0
votes
3 answers

How to check if another instance of Derby is already booted?

I'm writing some Java application that uses Java DB (i.e. Apache Derby) as database. I use the following method to connect to database: Connection getConnection() throws SQLException { EmbeddedDataSource ds = new EmbeddedDataSource(); …
Marcin
  • 215,873
  • 14
  • 235
  • 294
0
votes
0 answers

I can't start javadb in netbeans anymore

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/drda/NetworkServerControl Caused by: java.lang.ClassNotFoundException: org.apache.derby.drda.NetworkServerControl at…
Philipp Hofmann
  • 3,388
  • 26
  • 32
0
votes
1 answer

Replacing derby.jar from Oracle with derby.jar from Apache

Short version: Can I replace the derby.jar that came with my JDK (from Oracle) with the latest derby.jar from Apache? Long version: I've been using the Java DB (Oracle's supported distribution of the Apache Derby open source database) that comes…
John Fitzpatrick
  • 4,207
  • 7
  • 48
  • 71
0
votes
0 answers

Issue with JPA call to createEntityManager() in Netbeans Platform app on Ubuntu with Embedded Derby

UPDATE 2: Tested this on a Ubuntu 12.04 Virtual Machine on VMWare player so issue might be with my Ubuntu workstation. UPDATE 1: I tested this on windows 7 and an installed version works there so I submitted this as a bug report to…
simgineer
  • 1,754
  • 2
  • 22
  • 49
0
votes
2 answers

How to run my Java+Glassfish+JavaDB webapp outside of Netbeans

Each time I need to run my application I need to run it from Netbeans, because it automatically runs Glassfish server and JavaDB, but Netbeans consumes lots of memory and I would like to run my webapp (JSP files) outside of Netbeans, how can I do…
Ali Bassam
  • 9,691
  • 23
  • 67
  • 117
0
votes
1 answer

Extracting create table statements from a existing database.

I'm trying to extract a create table statement from an existing derby schema. I can get all of the columns and data types via this. select * from SYS.SYSTABLES a inner join sys.SYSCOLUMNS b on a.TABLEID= b.REFERENCEID This gives me the table name,…
kevingreen
  • 1,541
  • 2
  • 18
  • 40
0
votes
0 answers

Confused on Derby Client Server

With reference to Libraries provided by Derby, I am confused about connecting my Java application, which needs a connection to a server database (Derby/Java DB on NetBeans). In particular, I am confused between Network Server library and Network…
Abel Jojo
  • 758
  • 3
  • 14
  • 30
1 2 3
…
25 26