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

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. i started the server and ten conneted to db. when i run the file it produce java.lang.ClassNotFoundException:…
Abel Jojo
  • 758
  • 3
  • 14
  • 30
2
votes
3 answers

Truncate a VARCHAR to specific length in Derby AUTOMATICALLY

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 SQLException: A truncation error was encountered trying to…
J-16 SDiZ
  • 26,473
  • 4
  • 65
  • 84
2
votes
0 answers

Does ibm jdk7 include JavaDB similar to Sun/Oracle jdk?

The Sun JDK 7 or 6 - both include the JavaDB database as part of the jdk. Does anyone know if the IBM jdk 7 ships with any such database or we can just use Apache Derby? thanks.
1
vote
2 answers

JPA java.lang.IllegalArgumentException: Object: [ id=XYZ ] is not a known entity type

I am faceing the following problem: when i run my programme i get the following exceptions: java.lang.IllegalArgumentException: Object: dviaufgabe1.MeinArtikel[ id=25 ] is not a known entity type. …
AliveAndWell
  • 11
  • 1
  • 2
1
vote
2 answers

JAVA DB: Shutdown Derby does not work

I`m using the following method to close my connection to java DB: public void shutdownDisconnect() { if(connectionExists) { String databaseURL = getDBurl(); dbProperties.put("shutdown", "true"); try { …
Jamol
  • 3,768
  • 8
  • 45
  • 68
1
vote
1 answer

How to create an in-memory database table using Derby?

I would like to create an in-memory database for testing purposes using Derby/JavaDB. I have read Java DB Developer's Guide: Using in-memory databases and tested with this code with derby.jar from JDK7 in the "build path": import…
Jonas
  • 121,568
  • 97
  • 310
  • 388
1
vote
0 answers

Getting a java.sql.SqlNonTransientConnectionException

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 while creating the database: java.sql.SqlNonTransientConnectionException: A…
Andy
  • 11
  • 2
1
vote
2 answers

java.sql.SQLException: Table 'CONNECTIONS' does not have an auto-generated column named 'connection_id'

I'm trying to retreive the connection_id column while inserting into Connections table. I have a table being generated at the start of the application like this with the column_id being auto generated. CREATE TABLE connections (connection_ID INT…
Sam
  • 2,702
  • 5
  • 31
  • 45
1
vote
2 answers

Java DB checking against Date/Time fields (event handling)?

How can I come up with a mechanism in java where I could monitor the date/time fields inside a Java DB table and as soon as the the date/time fields for one or many of the records match the system time I could grab them for further processing??! …
Sam
  • 2,702
  • 5
  • 31
  • 45
1
vote
2 answers

Java DB - Why can't I create this table with these foreign key constraints?

I am trying to create three tables: Users username userID Categories category categoryID userID (references user table) Expenses amount date expenseID categoryID (references category table) NOT WORKING! userID (references user table) NOT…
peter
  • 6,067
  • 2
  • 33
  • 44
1
vote
1 answer

Tables not created on deployment of Java EE Application

I am running into the simple scenario that I started to create a Java EE App with EJB's. As I changed the structure of some of the EJB's I thought it easiest to just remove the Tables in the Java DB (using the Netbeans interface). However, since the…
Luuk D. Jansen
  • 4,402
  • 8
  • 47
  • 90
1
vote
2 answers

Connecting to an Apache Derby/JavaDB database using Oracle SQL Developer

I've been trying to connect to an Apache Derby/JavaDB embedded database using Oracle SQL Developer but without much success. I've tried to create a new connection using the following JDBC…
Nano Taboada
  • 4,148
  • 11
  • 61
  • 89
1
vote
1 answer

How do I install derby on my Debian Sever to connect with Tomcat?

On my development machine with Windows, I am using Netbeans to develop a JSP application, so creation of the DB was straightforward with Netbeans. I installed TOmcat on my server with only ssh access, how do i then install Derby as a database and…
user2370139
  • 1,297
  • 1
  • 11
  • 13
1
vote
1 answer

Can not login after register jsp db

I have a problem with a login on my "website" i always have failed login despite this i write good login and password. It gets the value from data base name "register" and check it. And I have values in "register" in database and I normally write it…
1
vote
1 answer

how to use 'BETWEEN' condetion two times in one sql statement for same column or diffrent columns

this is sql statement give only one value SELECT count(pn1) FROM pledges WHERE date1 BETWEEN '2011-05-05' AND '2011-06-06' i want use "between" more than one time for same column or for different columns in same table for example i want use it in…
m.basleem
  • 85
  • 1
  • 2
  • 12