Hi, I’ve been experiencing a performance problem with deleting blobs in derby, and was wondering if anyone could offer any advice. This is primarily with 10.4.2.0 under windows and solaris, although I’ve also tested with the new 10.5.1.1 release candidate (as it has many lob changes), but this makes no significant difference. The prob...
I am getting the following exception whe using derby to do a UPDATE in oracle Database org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.derby.client.am.DisconnectException: A communication error has been detected. Communication protocol being used: Reply.fill(). Com...
I've just received a new data source for my application which inserts data into a Derby database only when it changes. Normally, missing data is fine - I'm drawing a line chart with the data (value over time), and I'd just draw a line between the two points, extrapolating the expected value at any given point. The problem is that as miss...
I'm using the Apache Derby embedded database for unit testing in a Maven project. Unfortunately whenever I run the test I end up with the derby.log file in the root of the project. The database itself is created in the target directory (jdbc:derby:target/unittest-db;create=true) so that is not a problem. After consulting the reference gu...
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? ...
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 ...
I'm using in-memory derby db for my java application. I would like to delete all the tables/databases it created once the application ends. So when it starts back up, I want it to start fresh. ...
Hello good fellas.I'm using netbeans 6.7 on windows.I've been using DerbyClient in my spring test project and i've successfully change the driverClassName from org.apache.derby.jdbc.ClientDriver to org.apache.derby.jdbc.EmbeddedDriver.I was formally browsing through the bd from the service tab of netbeans.Now that i've changed the conne...
I'm using hibernate to persist an entity to my database. For the moment it's a derby DB, but I will be moving it over to an oracle DB soon. in my classname.hbm.xml I have the id defined as such: <id name="id" type="long"> <column name="ID"/> <generator class="increment"/> </id> How do I set the starting value for the id? ...
I 'RTFM' and did not find a way to retrieve the columns involved in a unique constraint for a given schema and table. Somewhere I read that there should be an implicitly created unique index, which backs the unique constraint. Its name is supposed to be equal to the name of the conglomerate that corresponds to the unique constraint. So...
Hi .. I'm a beginner with jdbc ... I have a problem running this code : This code uses appache derby and in order to make it work I first started the derby server.. java -jar "C:\Program Files\Sun\JavaDB\lib\derbyrun.jar" server start And then started the program java -classpath derbyclient.jar -jar TestDB.jar I se...
Hi, 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 good and works great however I know have an additional requirement to implement concurrent licenses for this client/server application. Ideally a user...
Is it possible to query apache derby for a list of current connections/active sessions? Any system tables etc? thanks, Phillip ...
My application at present uses Microsoft Access, but now may be hosted on Linux boxes. Additionally while being accessed from multiple computers, one of these may update the records (when its being read by other users). I also require that the embedded database should support complex SQL queries - like inner SQL, Joins, etc. I tried SQ...
I'm trying to connect to derby using this: dbProperties.put("create", "true"); dbProperties.put("dataEncryption", "true"); dbProperties.put("encryptionAlgorithm", "DES/CBC/NoPadding"); dbProperties.put("encryptionKey", "1234567890123456"); dbProperties.put("securityMechanism", ClientDataSource.STRONG_PASSWORD_SUBSTITUTE_SECURITY); // p...
Hi guys i can connect Derby via Eclipse Database Development but i cannot connect Derby with same url with Eclipse Database Development's through Hibernate. Error :"Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database " ...
Hi All, Our app sends the contents of the derby.log file to our server whenever Apache Derby throws a SQLException in our app. In order to get detailed logs, we are setting the 'derby.infolog.append' property to true. However, we are noticing enormously large logs files since the logs also contain bootup output each time a connection ...
I am wondering what the performance of a query would be like using the LIKE keyword and the wildcard as the value compared to having no where clause at all. Consider a where clause such as "WHERE a LIKE '%'". This will match all possible values of the column 'a'. How does this compare to not having the where clause at all. The reason I...
Hi All, I'm working on a Java desktop application that reads and writes from/to different files. I think a better solution would be to replace the file system by a SQLite database. How hard is it to migrate to this system and embed a database in my application? are there real performance gains? Thanks a lot ...
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? ...