Top "Javadb" questions

In-memory Java DB

Are there any DBs for Java that can be run in an embedded mode with some tables being stored in-memory …

database in-memory in-memory-database javadb

Retrieve id of record just inserted into a Java DB (Derby) database

I am connecting to a Java DB database with JDBC and want to retrieve the id (which is on auto …

sql jdbc javadb

Database not found error in Apache Derby

First, this is my first time with Apache Derby. I am using netbeans, willing to use embedded apache derby, and …

java netbeans jdbc derby javadb

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, …

sql derby javadb

How to catch java.sql.SQLIntegrityConstraintViolationException?

My application uses JPA+JavaDB and when I try to persist an object that violates a constraint I get SQLIntegrityConstraintViolationException …

java jpa javadb

How can I identify columns when SELECTing from multiple tables with JDBC?

I have two tables that I join on the id-column, they look like: +-------+ | users | +----+--+---+ | id | name | +…

sql jdbc join resultset javadb

java.lang.ClassNotFoundException Netbeans java derby

I use Netbeans, doing a java app. I created a class ConnectDB for db connetion using Java DB in netbeans. …

java database database-connection derby javadb

Java DB (Derby) Database Alter Column Size

I'm trying to alter the size of a field in my Java DB Database. I just can't seem to do …

java database derby javadb

In JavaDB apache derby I dont know what is causing a Error: Syntax error: Encountered ")" at line 30, column 1. SQLState: 42X01

CREATE TABLE "TravelerProfile" ( "idTravelerProfile" int NOT NULL, "AccountID" int NOT NULL, "GivenName" varchar(45) DEFAULT NULL, "FamilyName" varchar(45) DEFAULT NULL, "Title" …

sql syntax-error derby javadb

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 …

java derby javadb