I'm looking for a good way to run a Apache Derby server in network mode. I'm using the NetworkServerControl to start the server and it's working great. I start the server like this: /** * starts the network server * @return true if sucessfull */ public boolean start() { try { // just to be sure that we don't start tw...
Is it possible to change the auto-increment offset on a pre-existing table with JavaDB? I'm having a problem where inserting new records usually (but not always) fails with an error complaining about using an existing key (my auto-increment column). To populate this database, I took a dump from another database (MySQL) and used a Jav...
I am having a problem with Java DB that I just don't know how to resolve. I am creating a DB and connecting to it using Java DB's native JDBC driver. If I relocate that database physically and try to connect to it using its new path, I consistently get XJ004 errors: ERROR XJ004: Database 'blahblah' not found. I am sure I am using th...
Hi , 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 ...
How can I truncate a VARCHAR to the table field length AUTOMATICALLY in Derby using SQL? To be specific: CREATE TABLE A ( B VARCHAR(2) ); INSERT INTO A B VALUES ('1234'); would throw a SQLException: A truncation error was encountered trying to shrink VARCHAR '123' to length 2. Is there a easy way to suppress this exception? ...
I'm getting the following error when I try to run a Java class which interacts with Java DB. I try loading driver with : Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); In libraries, "derby.jar" do exist. I'm using NetBeans IDE 6.0. Could anyone help me to solve this problem? ...
Are there any DBs for Java that can be run in an embedded mode with some tables being stored in-memory while loading others from disk? H2 and JavaDB seem to be the two leaders for Java DBs and I know they both have an in-memory mode, but do they make you load the whole DB into memory or can you decide on a table-by-table basis? ...
I want to use Java DB in embedded mode in a Java application running from a CD-ROM. Does anyone have any experience of doing this? Will it work? The database will only have selects issued against it. ...
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 APP.POCKETMONEY (ID INTEGER NOT NULL, DateofSpending DATE, DESCRIPTION VARCHAR(255), AMOUNT IN...
I am using JPA and Java Embedded DB in my application. I try to write some data to the database and when i try to read it back I am able to do it. But the application is closed and when I open it again none of the data exists. Here is my persistence.xml file <?xml version="1.0" encoding="UTF-8"?> <persistence version="1.0" xmlns="h...