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
1
vote
2 answers

How can I fix this missing Derby ClientDriver issue?

I am pretty new to Java DB, and I'm trying to set up Java DB in NetBeans IDE using this tutorial: Working with the Java DB (Derby) Database During the step, where it tells to create database, I get such an error: An error occurred while creating…
Kyrylo Aleksandrov
  • 11
  • 2
1
vote
0 answers

How does Apache Derby deal with empty list in WHERE IN () clause

Hi this sql statement excutes as expected select * from table where id in(1,2,3); But there is posibility of IN() clause to be empty like below select * from table where id in(); Apache Derby complains with syntax error : encountered ")" at…
katwekibs
  • 1,342
  • 14
  • 17
1
vote
1 answer

Lexical Error running SQL for netbeans 8.2

I have Java DB configured in NetBeans. I am trying to edit the data that would be in the database using the GUI itself when running my application. I have the application running, and it shows the data inside a JTable, but when I try to edit the…
KaiKaiDes
  • 13
  • 5
1
vote
2 answers

Why cannot a suitable driver be found for jdbc:derby:derbyDB

I have recently installed jdk and jre on a Windows 10 machine and cannot get any of the projects that I had on my old machine to work. The main difficulty is that jdk1.8.0_60 does not include JavaDB/Derby, ie, there is no 'db' directory installed…
Rusty
  • 93
  • 1
  • 14
1
vote
3 answers

Passing images to Java

I am working on a project where I have extracted images from sensor and saved them to the operating system directory. I have a Java API for uploading images to the server. I need to upload these images and some other data typically float data type…
Ali R. Memon
  • 121
  • 1
  • 1
  • 12
1
vote
2 answers

Add primary key field to existing Derby table

I'm new to SQL, but managed to import my CSV data into an Apache Derby DB using ij. My table contains no primary key, and no existing field is suitable, so I'd like to create a new field, generate unique numbers to fill it, and set it as the primary…
user523071
  • 281
  • 1
  • 3
  • 11
1
vote
1 answer

Spring Transaction commit order

I have question on the order of committing in spring Transaction management. my current application requirement where i am using and my transaction triggers from my MQ receive ... Following is the order of action : MQ receives message DB…
Yesdani Shaik
  • 11
  • 1
1
vote
2 answers

Java SQL Update Query Not Working

I'm working on a simple java project that uses JavaDB and MySQL to introduce the use of databases. I'm trying to write a method for updating the scores of a game in a database. public void setTeamsScore(int matchNumber, int hScore, int vScore)…
Gabriel
  • 11
  • 1
  • 2
1
vote
0 answers

Unable to make JDBC Connection [jdbc:derby://localhost:1527/db_thermium;create=true]

I am trying, for the first time, to use the JavaDB (Apache Derby) as a database, for a graduation project (IT technician), but I am having trouble in connecting to the pre created database. I'm using Hibernate as the connection framework but I can't…
Rosivaldo Assunção
  • 11
  • 2
1
vote
1 answer

Get column data in JavaDB via foreign key

Outset: I am building a page in JSP / EJB (Java EE 8) that displays 2 tables: 1 for every user registerd in the database with their name and score and another one that displays all pending challenges to rock-paper-scisors for the currently logged in…
Synaxr
  • 23
  • 6
1
vote
1 answer

Why is this SQL query returning the author name for an article as NULL, if the author has written more than one article?

Here are my creation statements: String createFeedTable = "CREATE TABLE rss_feed (" + "channel_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), " + "channelTitle…
user465001
  • 806
  • 13
  • 29
1
vote
0 answers

How can I update current value of a sequence in JavaDB Derby database?

I'm using a sequence to generate custom id for a database table, but at first, I have to run some INSERT statements with rows which already have id in this format. So, I need to update the current value of sequence to ensure there are no duplicate…
lcnicolau
  • 3,252
  • 4
  • 36
  • 53
1
vote
0 answers

Apache Derby Concatenate Colum values on Group By

what I want to do is the following: I have a table like this: ID; STATUS; ORIGIN 1 READY a 2 READY b 3 OPEN a 4 OPEN a This should be queried to: IDS; OPEN; READY; ORIGIN 1,3,4 2 1 a 2 …
Benny
  • 1,435
  • 1
  • 15
  • 33
1
vote
0 answers

Apache Derby (JavaDB) concatenation regarding SQL92T (Prepend String to existing dataset)

I am new with JavbDB and need to simply append a string to a existing database cell like this: public boolean updateChildNodes(String filePath, String parentPath) throws SQLException { // Set new parent path for all child nodes …
metamagikum
  • 1,307
  • 15
  • 19
1
vote
2 answers

Derby's equivalent of DB2's "NOT NULL WITH DEFAULT"

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 and Derby are very compatible, it seemed like a possibility to take DDL out…
Nathan Hughes
  • 94,330
  • 19
  • 181
  • 276
1 2 3
…
25 26