javadb « derby « Java Database Q&A





1. Truncate a VARCHAR to specific length in Derby AUTOMATICALLY    stackoverflow.com

How can I truncate a VARCHAR to the table field length AUTOMATICALLY in Derby using SQL? To be specific:

CREATE TABLE A ( B VARCHAR(2) );
INSERT INTO A B VALUES ('1234');
would throw a ...

2. Can Derby / JavaDB _really_ encrypt with Triple DES rather than (plain) DES?    stackoverflow.com

It seems to be confusing Triple-DES (>128bit) with plain DES (64bit). I'm trying to encrypt a Derby database with Triple DES (or DESede) using Java 1.5 I found this discussion forum ...

3. JavaDB administration tools    stackoverflow.com

My current employer wants to use JavaDB for his new project. Allright with it, as my favoured SQLite isn't working very well with java and I, er..., don't really feel like ...

4. JavaDB SQL command reduntant?    stackoverflow.com

Correct me if I am wrong, but this SQL command:

create table MYTABLE (ID INTEGER NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1))
does not need the ...

5. JavaDB ( derby ) path to database?    stackoverflow.com

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 ...

6. dump JDBC Derby database to a SQL script    stackoverflow.com

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 ...

7. JavaDB - Checking if a database exists    stackoverflow.com

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

8. What is Derby's equivalent of DB2's "NOT NULL WITH DEFAULT"    stackoverflow.com

I'm investigating how feasible it is to change some unit tests (for an application running on DB2) to use Derby. Having found this question where the answer claims that DB2 ...

9. How should I use UUID with JavaDB/Derby and JDBC?    stackoverflow.com

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. ...





10. Is Derby/Java DB included in Java 6?    stackoverflow.com

I've read in a couple of places that Derby/Java DB is included in Java SE 6, e.g. http://java.sun.com/developer/technicalArticles/J2SE/Desktop/javase6/beta2.html but I can't find anyone who has used it without installing ...

11. Case insensitive search in Java DB (Derby)    stackoverflow.com

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 ...

12. Apache derby Double datatype - and trying to default it to "null"    stackoverflow.com

Well, I'm a bit puzzeled here, yet it seems to be a really dumb question. I'm trying to create a table that has a double column that is null by default. What ...

13. Getting a java.sql.SqlNonTransientConnectionException    stackoverflow.com

I am rather new to Java and JavaDB. I am trying to create a database in Netbeans 7.0.1 and after the server starts, I get an error that says: "An error occurred ...

14. javac: package org.apache.derby.client.am does not exist    stackoverflow.com

I'm trying to compile a java program that is using JavaDB/Derby. On the command line I can run

java org.apache.derby.tools.sysinfo
without errors, but the following line in several of the files causes the ...

15. JavaDB (Derby) sample database    forums.netbeans.org

16. netbeans j2se derby javadb authentification password    forums.netbeans.org

hi i'm using java persistence api to connect by jdbc to an embedded javadb database, the boot password appears in the persistence.xml file. I cannot find out how to configure the program to ask for the password each time it connects, rather than storing the password in the xml file. The password is visible to anyone reading the persistence.xml file. Is ...





17. JDK 6 and JavaDB or Apache Derby... How do I install?    coderanch.com

No dice, Rob Prime. I reinstalled the JDK and made sure all the boxes that said "This feature will be installed to the hard disk" were checked. I suppose it's a POSSIBILITY that it's been installed this whole time and I dunno how to access/use it. My textbook gives instructions on where to find the JavaDB driver, and how to test ...