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

Server Derby db remote to client Java

I can't get a clear picture on the db connection. We have a server in Linux. It has a DerbyDB too. I can have a db in it. I have to create a program that runs on more than one client computers (windows). The client programs will perform…
Abel Jojo
  • 758
  • 3
  • 14
  • 30
0
votes
1 answer

In derby should I be using the APP schema or the MYDBNAME schema

Every time I create a derby database there are several schemas including the APP schema and a schema with the same name of the USERNAME. Which schema should i be using, the APP or the USERNAME schema? Why is the APP schema introduced if the USERNAME…
simgineer
  • 1,754
  • 2
  • 22
  • 49
0
votes
0 answers

Easy Example of JPA OneToMany in Enterprise and Contacts

Please i need a Simple example of a JPA Entity denoting Enterpries with Contacts. Enterprises having many Contacts referenced by rc_No(String); Look At my code, any problem @Entity public class Enterprises implements Serializable { private static…
M.Hussaini
  • 135
  • 1
  • 5
  • 15
0
votes
1 answer

Can I make a Derby sql script with parameters?

I'd like to add Derby to my glassfish application, to store one piece of information. However, I don't want to make the inserts/updates via the application if I can. I can run ij with a script to create the database and table, but to make the insert…
0
votes
1 answer

get data from user then insert it in javadb

If I have a code with interface that takes data from user then stores this data in variables of type string, how can I insert this variable in a database? Here is an example of what I say : String…
0
votes
1 answer

Table Column Names - NetBeans IDE

I am using NetBeans to build a Desktop App. I'm using JavaDB as the database. I need a column named "Date" . However , I get an error whenever I try to name a column that. Any suggestions ? Thanks in advance . P.S I'm a newbie
None
0
votes
2 answers

Derby Boolean/Integer conversion in JPQL

The error I get: ERROR 42821: Columns of type 'BOOLEAN' cannot hold values of type 'INTEGER'. For the JPQL query: SELECT b.id FROM Bar b WHERE b.latest = true Apparently because Hibernate maps a Boolean field (ie "latest) to an integer column for…
Jan Goyvaerts
  • 2,913
  • 4
  • 35
  • 48
-1
votes
1 answer

How to fix an SQL design

I'm doing the study of a medical software. This software asks the patients questions about their symptoms and from them it can determine the possible pathologies. My study involves comparing the symptoms and pathologies found by the software with…
Uriel
  • 1
  • 2
-1
votes
1 answer

Getting "executeQuery method cannot be used for update." error in Netbeans while extracting information from database

My question is about a Java Web program which search the database and returns the list of students as per the query The code is below:- public class StudentDAO { public List getStudent(String s){ List lst=new…
-1
votes
3 answers

Class [org.apache.derby.jdbc.ClientDriver] not found Exception

![JAVADB_DRIVER_LABEL library missing][1] I am trying to connect to a JavaDB through netbeans 8 IDE on Windows 7. i can connect it using the DB manager provided with netbeans in Services panel. But when trying to connect it through my code I get…
M Khetan
  • 69
  • 1
  • 3
-1
votes
2 answers

Why "response.sendRedirect" doesn't work?

This is my login part which I need to compare user input with data in the database. So If a lecturer tries to enter the system, he or she will get into lecturer interface(lecturer.html) and same goes to the student. But right now, when I try to…
MoLab
  • 15
  • 7
-1
votes
1 answer

Violation on Foreign Key

Hi I am a beginner in java db netbeans., I have two tables namely transaction and checks tables in transaction table I have columns named [transID], [PayToOrder], [BankCode], [Checknumber]. in checks table I have columns named [checknumber],…
-1
votes
2 answers

java DB and jar file

we have a standalone project. we are using Java DB and we are writting our code on netbeans. we can conncet to DB with using IDE and we can do what we want but when we make it jar file it couldnt connect to database . how can we solve this…
-2
votes
2 answers

Creating a table throws SQL Exception

I would like to create a simple SQL database with one table. Line 8 throws a SQLSyntaxErrorException. public class LoadDatabase { public static void main(String[] args) { //if createConnection() returns a connection issue SQL Statements try…
-2
votes
1 answer

java.sql.SQLException: Table/View 'SEQUENCE' already exists in Schema 'ADMIN'

My application throws this Exception. I am using Java DB as the back end and i am using JPA Internal Exception: java.sql.SQLException: Table/View 'POCKETMONEY' already exists in Schema 'APP'. Error Code: 30000 Call: CREATE TABLE…
rgksugan
  • 3,521
  • 12
  • 45
  • 53
1 2 3
25
26