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

JavaDB SQL command reduntant?

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 NOT NULL part, as a primary key is suppose, by default, to be not…
The Student
  • 27,520
  • 68
  • 161
  • 264
3
votes
1 answer

JavaDB/Derby Error 08006

In the article Using Java DB in Desktop Applications the Address Book demo have a method disconnect which have a try-catch block that catch and ignores the exception. If you add a printStackTrace you can see that the exception always occur. What's…
The Student
  • 27,520
  • 68
  • 161
  • 264
3
votes
1 answer

When to create/initialize the prepared statement

I have the following Query class with 2 methods, insert() method is used frequently and deleteRecord() is not. public class Query1 { private final static String INSERT = "insert into info values (?, current_timestamp)"; private final static String…
Kzhunter
  • 597
  • 1
  • 6
  • 19
3
votes
1 answer

Easy way migrate data from MySql to Derby (JAVADB)?

I have to migrate my database from MySql to Derby. However, I am facing a problem, that it is not possible just to create sql dump and import in JavaDB. Is there an easy way, a tool or something that I can use? or should I do everything by…
TNeykov
  • 73
  • 2
  • 8
3
votes
1 answer

WARNING: ConnectionID:1 Prelogin error: host 127.0.0.1 port 3306 Unexpected response type:74

Right now I am trying to make a simple DBConnection using Java. I am using the Eclipse IDE for the development. import java.sql.*; public class DbConnect { private static String url =…
Akira Hora
  • 458
  • 1
  • 6
  • 18
3
votes
1 answer

How to move columns in java DB Apache Derby?

I need to change specific column's position I tried Ted Hopp's solution in Move Column in MYSQL ALTER TABLE EMPLOYEES MODIFY COLUMN fname VARCHAR(25) AFTER password and i got this error: Error code -1, SQL state 42X01: Syntax error: Encountered…
user2954718
  • 67
  • 1
  • 8
3
votes
2 answers

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 it. My current data type is varchar(50) and I want to update it to varchar(150).
Josh Pritchard
  • 141
  • 1
  • 7
3
votes
1 answer

Derby JavaDB Query ON DUPLICATE KEY UPDATE

I know that MySQL supports this query (ON DUPLICATE KEY UPDATE) for example: INSERT INTO UserFailure (Realm, Username, DateOfFailure, CountOfFailure) VALUES (?,?,?,?) ON DUPLICATE KEY UPDATE CountOfFailure=?; When I am running this on embedded…
Paulius Matulionis
  • 23,085
  • 22
  • 103
  • 143
2
votes
4 answers

Keep getting access denied for root at localhost password yes even though I supply correct login info

I keep getting: Exception in thread "AWT-EventQueue-0" Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException Internal …
Bob
  • 1,355
  • 5
  • 19
  • 38
2
votes
2 answers

JavaDB wont start on App start, giving me a java.sql.SQLNonTransientConnectionException:

java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect. I am using Netbeans. If I go to the Services Tab and rightclick Java DB and start…
Dave_P
  • 174
  • 2
  • 16
2
votes
1 answer

Hibernate Mapping Files and POJOs from DB (Reverse Engineering) doesn't generate Foreign Keys

I did this tutorial, and configured the Hibernate API and the mapping: https://netbeans.org/kb/docs/web/hibernate-webapp.html (i'm using the JavaDB API with the 'sample' DB not MySQL) But i have a problem: the generated hbm.xml files dont contain…
krstf
  • 627
  • 7
  • 25
2
votes
0 answers

Maven and Embedded Glassfish Plugin - How to provide the derby jdbc driver

When running the embedded glassfish plugin I get the following message. INFO: Cannot find javadb client jar file, derby jdbc driver will not be available by default. How to provide the javadb client jar file?
Can't Tell
  • 12,714
  • 9
  • 63
  • 91
2
votes
1 answer

When and how is the Java DB updated and synced with Apache Derby?

Oracle ships the JDK with "JavaDB" which is more or less a rebranded version of Apache Derby. Is Java DB updated and synced continually with each update release of the JDK ("_uXX") or only for major releases like Java 7?
soc
  • 27,983
  • 20
  • 111
  • 215
2
votes
0 answers

How do I fix the issue of ClientDriver not found in Netbeans?

I have created a JavaDB in Netbeans and succesfully connected to it. But when I try to create a database (by right clicking on JavaDB) I get this issue. How do I fix it ? By the way, my driver (Java DB Network) contains the same class that the…
user2370139
  • 1,297
  • 1
  • 11
  • 13
2
votes
1 answer

PersistenceException with Umlaut in path

I experienced an odd behavior with a java desktop application that uses Toplink essentials as persistence provider. I have a single directory containing all I need for my application: a jar, a lib folder and a JavaDB database. The whole directory is…
Matt Handy
  • 29,855
  • 2
  • 89
  • 112
1 2 3
…
25 26