Questions tagged [derby]

Apache Derby, an Apache DB subproject, is an open source relational database implemented entirely in Java and available under the Apache License, Version 2.0.

Filter by
Sorted by
Tagged with
0 votes
1 answer
79 views

How to export tables from Derby to SQL Server

How to export tables from Derby to SQL Server? Is that possible?
Mars's user avatar
  • 9
0 votes
1 answer
51 views

Isn't a PK automatically a proper unique indexed key

I'm checking out some newish features of Apache Derby for my Java EE app. IntelliJ provides helpful shortcuts for creating a simple DB schema. After a few clicks I have create table "Names" (...
Captain Giraffe's user avatar
0 votes
0 answers
229 views

How to convert MYSQL Query to support with Derby database

I used below mention query to cerate report in My Project with MYSQL with Java NetBeans. It works successfully. SELECT CASE WHEN sortId = 1 THEN CAST(orderId AS CHAR(10)) ELSE '' END AS orderId, CASE ...
tharinduhd's user avatar
0 votes
1 answer
46 views

Update end date by adding duration to start date in derby database

I created table using Derby database. CREATE TABLE PROJECT (PID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, PSDATE DATE, PDURATION INTEGER, PEDATE DATE, PRIMARY KEY (PID) ); I attempted to update ...
tharinduhd's user avatar
1 vote
1 answer
2k views

Will Derby, H2, or SQLite give faster load time and/or smaller file size than HSQL?

I have some flat files with the following columns; 3 integers, 3 reals, and 1 varchar(20). For querying I need an index that contains both 1 of the integer columns and the varchar column. Each file ...
Edmund's user avatar
  • 713
0 votes
1 answer
17 views

How do I get the some of the values from 2 foreign keys in a table?

I've spent a good amount of time on this but, still have no idea as to the sql query I can use to get the student name, and class name from the payments_per_student table. edit: This using JPA work ...
user465001's user avatar
1 vote
1 answer
829 views

Please explain SYSCS_UTIL.SYSCS_CREATE_USER() function

Can someone please explain to me how SYSCS_UTIL.SYSCS_CREATE_USER() works? I tried adding a new user like this: SYSCS_UTIL.SYSCS_CREATE_USER('user', 'someP@ss'), and it gave an exception Error code ...
Johan Brink's user avatar
2 votes
0 answers
239 views

Building a tree in Apache Derby 10.10

I know this question has been asked probably a million times, so please forgive me asking it again. I am not a DBA and have very little knowledge of SQL and Derby, but need some kind of a solution as ...
kooker's user avatar
  • 123
9 votes
1 answer
6k views

PostgreSQL "freeze"/"unfreeze" command equivalents

In Derby (an embedded database written in Java which is mostly used for testing or prototyping) there are "freeze" and "unfreeze" commands which can be used during an online backup. "Freeze" simply ...
Dan's user avatar
  • 287
2 votes
1 answer
2k views

Convert Oracle database to Derby

I need to migrate an existing Oracle Database into a Derby one. I want to know if there's a tool, a script or another way to do that work. It is using any of the interesting features of Oracle, as I ...
Yann Tombmyst Tremblay's user avatar
2 votes
0 answers
458 views

Two different ON DELETE paths, how do I need to change the schema?

For a project in school I'm designing a website that sells items via auctions. Think eBay, but on the complexity scale of school project. We went through the process of making an ER Diagram and ...
Huckle's user avatar
  • 121
1 vote
3 answers
4k views

Derby/SQL - How to increase performance when left joining and retrieving varchar columns

Through trial and error I found that if I do a left join such as: SELECT firsttable.id, secondtable.id, secondtable.varcharColumn FROM firsttable LEFT JOIN secondtable ON ...
Stephane Grenier's user avatar
4 votes
1 answer
4k views

Derby slows down after 1.2 million records

I'm using a Derby database, mass insertions slow down to 1/4 to 1/6 the speed once there are 1.2 million records (about 6 GB database size, one major table, other tables are tiny). Is that normal? Is ...
Mary Aubaun's user avatar
2 votes
2 answers
136 views

Long JOINS Returns No result all tables have one to many relationship with a particular table [closed]

I have a Table Enterpries with Primary Key 'RCNO'. All other tables have a one to many relationship with Enterprise via it's RCNO column. I make a Join of all the tables and i get nothing. Below is ...
M.Hussaini's user avatar
11 votes
3 answers
10k views

Does making a field unique make it indexed?

If I make a unique constraint on a field, do I also need to make an index on that field in order to get a scalable insert time? Or is this done for me (even if the index it uses isn't publicly ...
corsiKa's user avatar
  • 213
3 votes
1 answer
1k views

Are there any good database management applications for JDBC/Java databases?

I am working with an Apache Derby/JavaDB database via JDBC. Before have I been working with MySQL and used phpMyAdmin as a good Database Management tool. Is there any good desktop application for ...
Jonas's user avatar
  • 33.1k
74 votes
3 answers
43k views

What are the drawbacks with using UUID or GUID as a primary key?

I would like to build a distributed system. I need to store data in databases and it would be helpful to use an UUID or a GUID as a primary key on some tables. I assume it's a drawbacks with this ...
Jonas's user avatar
  • 33.1k