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

Unable to set authentication and authorization for my embedded database

I have read the Derby documentation but couldn't find any solution. I want to set a user id and password for my database in my application. I have provided the user and password option in the connection URL but when I try to open it again with any…
Wali
  • 23
  • 3
2
votes
1 answer

"Schema name-of-schema does not exist" with Java Derby

Im currently making a program with Java which needs to access a Derby database. However, when I try to run it I get the error "Schema RCVT does not exist". And, as I coded it, the program ends. Here´s my code: public ResultSetTableModel(String…
2
votes
0 answers

Error code 30000, SQL state 42X02: Lexical error at line 1, column 8. Encountered: "`" (96), after: ". Line 1, column 1

I tried creating a view in Java DB, but I keep getting this error. Error code 30000, SQL state 42X02: Lexical error at line 1, column 8. Encountered: "`" (96), after : "". Line 1, column 1 This is my query: SELECT * FROM memberdetails m JOIN…
ksaj
  • 21
  • 3
2
votes
2 answers

Issues with connect to Apache Derby database on Raspberry Pi

I am working on a Java project where I make apache Derby Database connections in Netbeans with maven. I want to export project to Raspberry PI, but when i am trying to execute jar file i got an error: java.sql.SQLNonTransientConnectionException:…
manyn753
  • 21
  • 1
2
votes
1 answer

Connect to Java DB server (Derby) from network

I have used the following code to start the Java DB server: System.setProperty("derby.drda.startNetworkServer", "true"); try { NetworkServerControl serverControl = new NetworkServerControl(); serverControl.start(new…
Elio
  • 148
  • 9
2
votes
2 answers

What is the difference between HSQLDB and JavaDB? Which one is suitable for unit testing?

Could you tell me the differences between HSQLDB and JavaDB? And which one should I use in unit testing, assuming that I only use standard features? Thanks.
user168237
2
votes
1 answer

Distribute a database made with JavaDB with Java program

I'm creating a program in Java in which I have to use a lot of tables. I made the decision to create all those tables in a JavaDB file. However, now I want to distribute this filled JavaDB file with my JAR file for distribution, since connecting to…
Naxels
  • 1,725
  • 2
  • 14
  • 19
2
votes
1 answer

Start Java DB server without NetBeans

I am creating a Java APP that manages a database. I've been starting the JAVA DB server manually by right clicking - start server. with NetBeans but since I am not going to be the one that runs the application that can't be done anymore. I need a…
Joan Gil
  • 21
  • 4
2
votes
4 answers

How to connect to JavaDB from another computer?

I'm trying to learn some basic JDBC. I've created a JavaDB server and made a Java program where i can read and alter some tables in the database. I thought it would be a fun next step to be able to connect to the server from another computer…
User892313
  • 225
  • 3
  • 19
2
votes
0 answers

ERROR 42X01: Syntax error: Encountered "" in Java Derby

When I try to execute this line of code in Java String query = "create table keeplog(idk INT not null primary key GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1)," + "idl INT not null"; Statement stm =…
2
votes
1 answer

Making a database for an Android app in Netbeans 8.0.2

Let me start off by saying we're completely newbies in android programming, but are learning the basics using various tutorials on youtube and other sites. I use Netbeans IDE and have installed the Android SDK. The app we want to create is basically…
Minimax
  • 121
  • 1
  • 5
  • 20
2
votes
2 answers

How do I set up derby in eclipse on Ubuntu?

The question basically says it all. I'm trying setup up JavaDB on my virtualbox running Ubuntu 9.10. I have the package downloaded and installed through the package manager, which I believe is the right to go about it. I have also installed the…
Everett
  • 1,077
  • 5
  • 23
  • 42
2
votes
2 answers

How to store Java Objects in JavaDB Derby Database?

I have a java class to store Media objects for a movie/TV/DVD index. I'm planning to try to store these objects in a JavaDB database. It will have many thousands of entries. I have read about serializing objects, and also a bit about hibernate and…
localhost
  • 1,253
  • 4
  • 18
  • 29
2
votes
1 answer

DB contents get deleted every time I launch the app

First I want to say that Im in a programming school atm, and in the course called project development I received a half finished project from seniors to continue. So needless to say I dont know the project by heart and that paired with my…
2
votes
1 answer

Check if a table exists using JDBC

I have a table named test2 in my database. now i want to check if it exists in java code. i have written these lines of code to check if the table exists or not. DatabaseMetaData dbm = conn.getMetaData(); ResultSet rs =…
Usman Riaz
  • 2,920
  • 10
  • 43
  • 66