1. Any good Derby DB Editor? stackoverflow.comI would like to modify some Derby DB's structure, do you know any good (multiplataform) editor for doing this? |
2. Apache Derby - Check Database Already Created? stackoverflow.comUsing 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 |
3. Derby Entity Relationship Diagram stackoverflow.comIs 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 |
4. How to avoid messages like "Profiler Agent Warning: Failed to lookup cached class org/apache/derby/impl/services/locks/ActiveLock" when profiling a J... stackoverflow.comWhen 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 ... |
5. Managing concurrent access to an Apache Derby database stackoverflow.comI 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 ... |
6. Derby gets stuck closing? stackoverflow.comI'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 ... |
7. How to configure Grails to work with Apache Derby? stackoverflow.comHow to configure Grails to work with Apache Derby instead of HSQLDB |
8. Can a java application manage triggers and UDFs in Derby database? stackoverflow.comCan we manage UDFs, and triggers in Derby database from our own Java Application ? By managing I mean :
|
9. Jetspeed null PortletDefinition stackoverflow.comI 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 ... |
10. How to create a database deadlock using jdbc and JUNIT stackoverflow.comI 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 ... |
11. If there is a necessary data base stackoverflow.comI 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 ... |
12. Distributing a Derby DB with a Java application stackoverflow.comI 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 ... |
13. Drop all constraints in Derby via JDBC stackoverflow.comHow can I drop all constraints in a Derby database via JDBC? |
14. Drop Derby encryption stackoverflow.comI 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 ... |
15. Is there a tool other than ij to look into a local derby database (folder)? stackoverflow.comI'm using Derby ij to look into my local Apache Derby database. It's just a folder and I connect to it like this: |
16. Resultset not open stackoverflow.comI 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) |
17. Derby's handling of NULL values stackoverflow.comI am new to Derby and I noticed that I face similar problems as when using the DB2 RDBMS as far as |
18. Derby - How to handle additions to objective fields stackoverflow.comI'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 ... |
19. Java RIA app with local database + synchronisation support stackoverflow.comI 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 ... |
20. running 'describe' command on a Graphical ij tool stackoverflow.comIs 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. ... |
21. how to set up wanted db in wanted location with derby in java stackoverflow.comI want to build wanted db in wanted location programly in java. |
22. How secure is Derby DB? stackoverflow.comI 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 ... |
23. Storing arrays in derby database stackoverflow.comI 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. ... |
24. Complicated LIKE Expression in derby (Java DB) stackoverflow.comi've a table with ID, Name both are String type in ID i'v value like |
25. How to access a java Derby database? I could really do with a few helpful pointers stackoverflow.comI 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, ... |
26. Does Apache Derby have a graceful shutdown? stackoverflow.comI 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 ... |
27. Expose database using REST web service stackoverflow.comHy, 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 ... |
28. How to print DDL command in Apache Derby stackoverflow.comIn 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. |
29. Java and Derby - Database will not save? stackoverflow.comI 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 ... |
30. Does database operation of writing can be blocked by operation of reading? stackoverflow.comWe have a problem with database derby. Sometimes operation of writing takes many time. Is possible that many operations of reading blocking writing? Thanks. |
31. Derby's subquery optimization issue stackoverflow.comhere 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 ... |
32. Can two Derby databases run on the same host? stackoverflow.comCan 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 ... |
33. Derby Auto-Increment and Eclipselink UnitOfWork stackoverflow.comThere's seems a problem between Eclipslink and Derby Auto-Icrement column when i insert value via UnitOfWork. |
34. Opensource project using apache derby stackoverflow.comDoes 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 ... |
35. derby Encountered: "@" bytes.comwhen 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 : ... |
36. derby dialect coderanch.comOriginally 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, ... |
37. Derby ... limiting fetched rows number coderanch.comPlease 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 ... |
38. Derby TOP Clause coderanch.comIs 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, ... |
39. derby database front end coderanch.comHello 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 ... |
40. Why does Derby leave files on the hard drive? coderanch.comThanks 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 ... |
41. A case where Java DB(derby) failing,plz help coderanch.comIam 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 , ... |
42. java db derby coderanch.comIt'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 ] |
43. Derby database coderanch.com |
44. another instance of derby have already booted Using JAMES coderanch.comHi, 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 ... |
45. Connectin in derby? coderanch.com |
46. Myeclipse Database Explorer - Derby coderanch.com |
47. derby problem coderanch.comHello 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 ... |
48. apache derby default CacheManager coderanch.comHello, 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 ... |
49. using DBVisualizer with derby coderanch.com |
50. Unable to create a derby datasource coderanch.com |
51. Derby and commons dbcp compatibility coderanch.comhi ... 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 ... |
52. does jdk 6 by default contains derby software coderanch.comit 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 ... |
53. My textbook refers for Java DB (Derby), but I can not find /db/ directory...at coderanch.comMy 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 |
54. running derby in older version coderanch.com |
55. help with rendering html with derby based data on the fly coderanch.comHello 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 ... |
56. Save and retrieve image in derby database coderanch.com |
57. apache derby coderanch.com |
58. Method to return list of info from derby coderanch.comHI 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 ... |
59. Apache Derby data base DECIMAL converting to BigDecimal coderanch.comWhen 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 ... |
60. Apache Derby ToursDB dbforums.com |
61. using if in derby java-forums.org |
62. procedures in derby java-forums.org |
63. And aslo configuring Derby in linux java-forums.org |
64. problem with java derby java-forums.orgpackage 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"); } ... |
65. Derby Mystery..!!!! java-forums.orgHi 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, ... |
66. problem with begin on the precedure of Derby java-forums.org |
67. Need help with derby database connection/insert java-forums.orgHi 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() + ... |
68. Derby database problem java-forums.org |
69. Basic Database (Derby) Distribution Question java-forums.orgI'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 ... |
70. Appache Derby forums.oracle.com |
71. Derby Database Problems.... forums.oracle.com |
72. Storing Java objects into a Derby db forums.oracle.com} 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") ; ... |
73. Problems setting derby.system.home forums.oracle.comHello 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 ... |
74. Any tools for Java database derby? forums.oracle.com |
75. derby database forums.oracle.comIf 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 ... |
76. help required in derby database forums.oracle.comClass.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 " + ... |
77. help required in derby database forums.oracle.comClass.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 " + ... |
78. Derby Database forums.oracle.comCan 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 ... |
79. Automatically Connceting to a Derby Database on Startup? forums.oracle.comWhat 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 ... |
80. No class found in Class.forName() (Derby db) forums.oracle.comah 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 ... |
81. MAXIMUM DATABASE SIZE SUPPORTED BY DERBY forums.oracle.com |