I would like to modify some Derby DB's structure, do you know any good (multiplataform) editor for doing this?
thanks!
|
Using Apache Derby with Java (J2ME, but I don't think that makes a difference) is there any way of checking if a database already exists and contains a table?
Cheers,
Pete
|
Is there any free software out there for extracting the diagram of my derby database?
(Like MySQL Workbench for MySQL?)
Or maybe a plugin for netbeans?
Thank you
|
When trying to monitor a Java application using visualvm I can't obtain useful information, because a lot of my classes (but not only mine) can't be instrumented, displaying the following message:
Profiler ... |
I have an Apache Derby database running (in networked mode) inside a java swing application, I connect to it through direct JDBC calls via a java client application.
This is all very ... |
I've got unit tests (in maven) that use derby.
At the end of the test run, there is a very long pause, with these log messages before the pause.
INFO: Closing Hibernate SessionFactory
Nov ... |
How to configure Grails to work with Apache Derby instead of HSQLDB
|
|
Can we manage UDFs, and triggers in Derby database from our own Java Application ?
By managing I mean :
- checking if it exists;
- adding;
- removing.
|
I am running a jetspeed portal which contains various portlet applications and have come across an issue after a recent reinstall where some of the portlets will return
Cannot ... |
I am trying to create a database deadlock and I am using JUnit. I have two concurrent tests running which are both updating the same row in a table over ... |
I have a desktop program which uses an embedded data base mechanism. For the first time a user will execute a program, it must create a database. So that, next time ... |
I have a table in a application, which loads in data from a Derby DB with a Client/Server driver. Everything works in NetBeans, even with the NetBeans DB service disconnected, but ... |
How can I drop all constraints in a Derby database via JDBC?
|
I have a Java application which uses an embedded Apache Derby DB for storing data. I want to give the user the option to enable/disable encryption of the database.
I found ways ... |
I'm using Derby ij to look into my local Apache Derby database. It's just a folder and I connect to it like this:
connect 'jdbc:derby:C:\Users\Torben\MyDatabase' USER 'me' PASSWORD 'secret';
It works, but ... |
I get following error on Result set
java.sql.SQLException: ResultSet not open. Verify that autocommit is OFF.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.ResultSet.next(Unknown Source)
...
|
I am new to Derby and I noticed that I face similar problems as when using the DB2 RDBMS as far as null values are concerned. The Derby documentation states, that ... |
I'm looking to create a table for users and tracking their objectives. The objectives themselves would be on the order of 100s, if not 1000s, and would be maintained in their ... |
I need to develop an ordering system for a client that works with tablet computers. Because they are not always connected, the app needs a replication of the database and the ... |
Is there a graphical tool (GUI) to execute ij 'describe' commands on Derby DB, outside the ij prompt?
I tried to use Netbeans, SQuirreL and DbVisualzer but it doesn't seem to help. ... |
I want to build wanted db in wanted location programly in java.
public class DerbyCreateTable {
public static void main(String [] args) {
Connection con = null;
try {
...
|
I just started with Derby DB yesterday. I have a small concern that when i connect to a Derby Db, i dont have to specify any username and password, unlike MySQL ... |
I have a 2d array with 24 columns and about 800 rows. Each column consist of values either 0 or 1. I would like to store this array in derby database. ... |
i've a table with ID, Name both are String type in ID i'v value like
1.3.6.1,
1.3.6.2,
1.3.6.1.2,
1.3.6.1.3,
1.3.6.1.4,
1.3.6.2.1.
1.3.7.2,
1.3.7.5,
1.3.8.1,
etc
I need to retrieve records like 1.3.6. .. but not like 1.3.6.ANY_NUMBER. ... |
I am new to using Derby and databses in eclipse, and I have become a tad lost and in need to a bit of help. I have established a database connection, ... |
I have a program that starts up the Derby Network Server using the NetworkServerControl API and when I want to shut down the network server, I want to be done gracefully ... |
Hy,
I'm developing an RESTful web service and I want to expose my data through it.
I have a database (Derby), where I have two tables (User and Schedule).
Now I want to ... |
In Apache Derby using the embedded ij command client, what should be the statement to execute to
generate a DDL for a particular object say a table?
I tried it with this one.
ij> ...
|
I have a problem with java and derby. When I launch my application, I create the database, add a table, insert some data into it. Then I exit my program, I ... |
We have a problem with database derby. Sometimes operation of writing takes many time.
Is possible that many operations of reading blocking writing?
Thanks.
|
here is to follow my previous question on Derby. I finally got it to show me the execution plan for my query and intresting values came up:
http://pastebin.com/wQAicPAV (SO ... |
Can two Derby databases run on the same host? I have spent a day on this, and I don't know if the problem is in my configuration or a more fundamental ... |
There's seems a problem between Eclipslink and Derby Auto-Icrement column when i insert value via UnitOfWork.
SessionFactory sessionFactory = new SessionFactory("default");
Session session = sessionFactory.getSharedSession();
UnitOfWork uow = session.acquireUnitOfWork();
SysUser usr2 = new SysUser();
usr2.setUserName("test");
usr2.setUserPassword("test");
uow.registerObject(usr2);
uow.commit();
Here's the ... |
Does anybody know of a few open source projects that are using apache derby?
Background:
I need to analyze the parse trees of some sql statements, and have derby's sql parser isolated ... |
when i run sql query select * from GRABBER.CANDIDATES where EMAIL=xxx@xxxxx.xx i get Error code -1, SQL state 42X02: Lexical error at line 1, column 55. Encountered: "@" (64), after : ... |
Originally posted by mike cool: hi i use derby with java but i have some Q: 1-how can i create new user in my database using sql query 2-what sql dialect derby uses, and where can i find some references (like ms sql book online) thx Let's start with your 2nd question first: Derby (like many other databases) more-or-less implements SQL-92, ... |
Please don't confuse setFetchSize() and and setMaxRows(). Setting the fetch size suggests to the driver the number of rows it should get in a chunk from the database. You set it to reduce the number of network requests made to the database while iterating over the resultSet, or control the size of the driver's internal data buffers. The driver implementation might ... |
Is there a TOP Clause for a Derby database query? I'm writing a query for my Java app and I'm using Apache Derby as the data source, but it doesn't seem to like the TOP clause that I'm using. Example: SELECT TOP 10 * FROM Orders I use SQL Server quite a bit and that's where I'm getting that from. However, ... |
Hello All, Thanks for the replies. As to the IDE, I'm "still" using emacs (at least for this project). I'm getting more familiar w/ Eclipse everyday but not completely up to speed. I'm accessing my derby database as an internal database, versus having a derby database server running and connecting to it remotely. Does that make a difference w/ setting up ... |
Thanks for the link. Looks like I misinterpreted what "memory-resident" means. In the derby case, it appears to mean that the entire contents of the database are loaded into memory - so the app doesn't need to read from disk at run time. I was under the impression it meant a database with a lifecycle similar to one of the container ... |
Iam having two java programs,first one is a java application which produces or fills up the database and second one is a Web server that consumes that database. I've Embeded database and File system for storing data approach as my both programs are running with in the same Machine. The obvious problem here is once one application made to run , ... |
It's good for embedded systems but horrible IMHO for larger J2EE applications. The only aspect of a J2EE application I'd use it for is running messaging queues, not as a central repository. Stick with MySQL (or Oracle if you have the cash) for J2EE systems. [ May 04, 2008: Message edited by: Scott Selikoff ] |
|
Hi, I received this error message "another instance of derby have already booted". Background: I am using Netbeans IDE 5.5.1 and trying to connect to the user repository database using the embedded Apache Derby database in JAMES. I had previously succeeded in connected to the database. I then close the JAMES server and Netbeans. After that, when I re-open Netbeans and ... |
|
|
Hello all, I am using JBuilder 2007. i am running the builtin derby database. i made a servlet and tried to connect it with my database but for some reason it throws an SQL exception that Error.java.sql.SQLException: No suitable driver here is my code. package testing; import java.io.IOException; import java.io.PrintWriter; import java.sql.*; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /** * Servlet ... |
Hello, I am not sure if it is the right place to ask about apache derby; but if it is I had heap out of memory where 1 of the objects occupying ~20% of the heap was org.apache.derby.impl.services.cache.ConcurrentCache. I run multiple instances of embedded derby databases within my java application where I restart from time to time the databases to reclaim ... |
|
|
hi ... I am new to using derby .. i have some doubts on it ... please clarify... 1). can i use embeddedDriver of derby with commons pool and dbcp 2) Can i use the con from the pool (created with embeddedDriver and pools) to be accessed by multiple users to make insert,delete operations 3) Do i have to shutdown the ... |
it written in some books by default JDK6 comes with Derby (DB)jars and by adding a couple of jar files to class path we can simply use the database. But my computer has jdk 6.1, but there is nothing related to derby is in lib folder? may i know how to test JDK 6 new features through my command prompt or ... |
My textbook(how to program 7th java, deitel) refers for Java DB (Derby), but I can not find /db/ directory...at C:\Program Files\Java\jdk1.6.0_15 ? well how install this embeded functionality? C:\Program Files\Java\jdk1.6.0_15>dir Volume in drive C is HP Volume Serial Number is 92B7-446D Directory of C:\Program Files\Java\jdk1.6.0_15 20/09/2009 18:59 . 20/09/2009 18:59 .. 09/08/2009 22:40 bin 25/07/2009 06:23 3,841 COPYRIGHT ... |
|
Hello ranch! I have an application in which i need to print html document on the fly. There is going to be one document for every section in a contact manager. i have a derby database that takes care of the user data and i want to display this data in the recently mentioned html documents. I am working on a ... |
|
|
HI all, I am new here and working through a simple app. So forgive my ignorance. I am not finding an answer searching the forums. I have a Derby db setup, I've used Hibernate to automate some of my setup. I am trying to create a Struts2 Select list with information from one of the columns, Usernames, in the db. I ... |
When I extract a inserted record(apache Derby embeded db) to view it I load a DECIMAL datatype of 100.00 from the database to the controller variable payRate with data type BigDecimal. The database loads a BIGDECIMAL from this controller just fine. but the data type is noted as DECIMAL(5,2) in the table createion. Is there a code example other than the ... |
|
|
|
|
package test; import java.sql.*; import java.util.logging.Level; import java.util.logging.Logger; /** * * @author SRIDARSHAN */ public class Main { /** * @param args the command line arguments */ public static void main(String[] args) { try { // TODO code application logic here Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); } catch (ClassNotFoundException ex) { Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex); } try { Connection con = DriverManager.getConnection("jdbc:derby:testDB", "test", "test"); System.out.println("success"); } ... |
Hi Could anyone please advice me about a strange behavior of derby Database? 1. I have created a table in an Embedded Derby Database with the name "PC" 2. In this table there is a field with the name "EMPID" type of INT, and it is accepting null entries. 3. I have created the dbconnection dBconnection = DriverManager.getConnection(connString + database, user, ... |
|
Hi guys I'm currently using netbeans and need to make a program for school where the user is able to store questions he's written in a database. I have connected to the database well and have no errors except when I try to save the information to the database here is my code: String myInsertsql = " VALUES(\'" + newquestion1.getQuestion() + ... |
|
I'm working on my java by creating a fictitious company and acting like the programmer for the company. My hr department wants a program to enter employee information and by able to save it to a database. This is the first part of the request. So far I have created a database and gui to interact with the database. Here is ... |
|
|
} catch(IOException e) { e.printStackTrace(); } catch(SQLException e) { e.printStackTrace(); } } ... public static void showPackets() { String query = "Select * From APP.PACKETS "; Statement st = null; ResultSet rs = null; int id = -1; byte[] data = null; try { st = conn.createStatement(); rs = st.executeQuery(query); while (rs.next()) { id = rs.getInt("id") ; data = rs.getBytes("packet") ; ... |
Hello friends, i have been using JavaDB ans swing application ,and i have been trying to set the "derby.system.home" System property in this way: System.setProperty("derby.system.home", "C: databases"); and in this way: System.setProperty("derby.system.home", "C:/databases"); and any result i could not find. I could be able to set this path as the DB path. Can anybody give me any advice. Thanks for all ... |
|
If someone knows the derby database I would appreciate some help. I am trying to run the nsserver demo found in the program files of the db-derby-10.3.1.4.bin folder. There is a java class called NetworkServerControl.java which is supposed to be imported but only exists in a batch file in some other folder. Can anyone tell me how to get the nsserverdemo ... |
Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); System.out.println("connection success"); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } try { String driver = "org.apache.derby.jdbc.EmbeddedDriver"; // the database name String dbName="america"; // define the Derby connection URL to use String connectionURL = "jdbc:derby:" + dbName + ";create=true"; Connection conn = null; Statement s; PreparedStatement psInsert; ResultSet myWishes; String printLine = " __________________________________________________"; String createString = "CREATE TABLE WISH_LIST " + ... |
Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); System.out.println("connection success"); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } try { String driver = "org.apache.derby.jdbc.EmbeddedDriver"; // the database name String dbName="america"; // define the Derby connection URL to use String connectionURL = "jdbc:derby:" + dbName + ";create=true"; Connection conn = null; Statement s; PreparedStatement psInsert; ResultSet myWishes; String printLine = " __________________________________________________"; String createString = "CREATE TABLE WISH_LIST " + ... |
Can anyone show me simple ways to code printFirstProduct, printLastProduct, printProductByCode, insertProduct, and deleteProduct methods? This is a very simple database consisting of just ProductCode, Description and Price fields. An example of the insert method would be this: public boolean insertProduct(Product p) { try { Connection connection = connect(); String insert = "INSERT INTO Products (ProductCode, Description, Price) " + "Values ... |
What do you mean by connect exactly? as in when i press F6 to compile and run my application (using the IDE), a script automatically starts the database that i need to work with. for example: if i want to run my app in NetBeans 5.5 i just press F6. but if i havent started up my database manually yet from ... |
ah right. the filestructure of how classes are arranged on disk does correspond to the package names, but that's for the convenience of the compiler. I probably just told you something you already knew, sorry! what do you mean by "default directory"? derby.jar needs to be wherever the app server expects to see libraries. at a guess, in a directory called ... |
|