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
6
votes
3 answers

Case insensitive search in Java DB (Derby)

I'm using Derby and I can't find a way to do case insensitive search. For example, I have a table that I'm searching that contains "Hello" but I put a search query in for "hello" and at the moment I won't get a result, but I want to. I can't find…
Sara
  • 612
  • 5
  • 21
6
votes
2 answers

Java DB / Apache Derby with Android

Can I integrate Java DB or Apache Derby in my Android application? Or any inline or embedded database. Can anyone suggest code for it? I need some code because i have to make examples, not in theory. Anyone knows if this databases is supported or…
djk
  • 3,671
  • 9
  • 31
  • 40
6
votes
3 answers

How should I use UUID with JavaDB/Derby and JDBC?

I currently use INT as type for primary key in JavaDB (Apache Derby), but since I'm implementing an distributed system I would like to change the type to java.util.UUID. A few questions about this: What datatype in JavaDB/Derby should I use for…
Jonas
  • 121,568
  • 97
  • 310
  • 388
6
votes
2 answers

JavaDB - Checking if a database exists

We created a java application which uses the JavaDB database in Netbeans IDE. We want the program to check every time it starts if the database's tables have already been created, and otherwise create them. How do we do that? thanx
smash
  • 61
  • 1
  • 2
6
votes
2 answers

Database not found error when connecting to Derby network server

I'm having problems initializing my javadb network server and setting a connection to it. It's a JavaFX program. This is what I have so far: try { Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance(); javadbserver = new…
Nepze Tyson
  • 587
  • 2
  • 7
  • 16
5
votes
2 answers

Execute db statements from file

I use embedded Apache derby for my application. I have a SQL script called createdb.sql that creates all tables in a database and populates it with initial data, e.g.: SET SCHEMA APP; CREATE TABLE study ( study_id bigint not null GENERATED…
Marcin
  • 215,873
  • 14
  • 235
  • 294
5
votes
1 answer

Starting Derby Programmatically

Please have a look at the following code DataBaseConnector.java import java.sql.*; import javax.swing.*; public class DataBaseConnector { private Connection con; public DataBaseConnector() { } …
PeakGen
  • 21,894
  • 86
  • 261
  • 463
4
votes
2 answers

how do I get started unit testing a Java EE JAX-RS app using embedded GlassFish and Java DB/Derby, ideally in NetBeans sans Maven?

I'm relatively new to JAX-RS, JPA, GlassFish, Java DB, and NetBeans, and I'd like to write unit tests for my code. [Version numbers are at the bottom.] However, I'm stuck on where to begin. I've done a good bit of searching, but I don't yet have a…
Matthew Cornell
  • 4,114
  • 3
  • 27
  • 40
4
votes
2 answers

JavaDB connection issues; database not found

I am having a problem with Java DB that I just don't know how to resolve. I am creating a DB and connecting to it using Java DB's native JDBC driver. If I relocate that database physically and try to connect to it using its new path, I…
Jim Burnell
4
votes
1 answer

Embedded nosql open source java database

I'm developing an open source product and need an embedded dbms. Can you recommend an embedded open source database that ... Can handle objects over 10 GB each Has a license friendly to embedding (LGPL, not GPL). Is pure Java Is…
Sullivan
  • 443
  • 1
  • 6
  • 14
4
votes
2 answers

How to use JavaDB as SQL parser

About a month ago I built an application that used zSQL as the SQL parser to parse SQL. However, just few days ago, a heavy duty user sent in a multi row insert statement which zSQL doesn't support. This is the sample: INSERT INTO MyTable…
Reusable
  • 1,888
  • 7
  • 27
  • 46
4
votes
2 answers

How can I detect what version of JavaDB/Derby I'm using?

I use JavaDB (Derby) as an embedded database in my Java Swing application. I would like to detect and print the version of JavaDB I'm using. I have included derby.jar in my .jar-file for the application. How can I detect and print the version of my…
Jonas
  • 121,568
  • 97
  • 310
  • 388
4
votes
2 answers

PreparedStatement in a loop, how to use

I'm trying to store all the items that were created in the ITEM table and I wonder if I can do that: PreparedStatement stm = null; //String sql = "INSERT INTO ITEM (ID, TYPE, TITEL, UITGELEEND) VALUES ('%s', '%s', '%s', %b)"; try { …
aardbol
  • 2,147
  • 3
  • 31
  • 42
4
votes
3 answers

Concurrency in embedded (in-proces) databases H2, Hsqldb, Apache Derby, SQLite (JDBC)

Is it possible to use embedded databases concurrently (read/write) on the same machine (no server) with different processes. And what about concurrent read/writes in one multithreaded process? Iam trying to find out how the concurrency is solved in…
user4949624
  • 51
  • 1
  • 2
4
votes
3 answers

How do I integrate a JavaDB database into my main java package

I am working on a desktop application which uses JavaDB. I am using NetBeans 6.8 and JDK 6 Update 20 I created the database I need and connected to it through my application using ClientDriver: String driver =…
Stefanos Kargas
  • 10,547
  • 22
  • 76
  • 101
1
2
3
…
25 26