Re: Interfacing with embedded derby from an outside process/shell

ay Derby is booted/opened by an > application, can I connect to the same database via IJ tools and interface > with the database (UPDATE/INSERT/DELETE)? Or this is not supported? > > On Aug 2, 2017, at 10:39 AM, Kristian Waagan <krist...@apache.org> wrote: > > Hi Dmitry, > &g

Re: Interfacing with embedded derby from an outside process/shell

Hi Dmitry, Only one process can open / boot a specific database (usually a set of files on disk) at a given time. Depending on your requirements you can: a) shut down the application and boot the database using any standard JDBC tool (using the embedded driver) b) if you need to be able to

Re: Write Cache - Data Corruption

Correct, you absolutely don't need a UPS for Derby to function. The issues to consider with an abrupt shutdown would be loss of uncommitted transactions and recovery time. There's also the usual additional risk that something goes awry in the OS or with the hardware itself. That risk is likely

Re: Derby Database Corruption Issues

Hi Shreyans, I believe this is still valid advice, but the details depend on your IO-system, your operating system and your server hardware. The issue here is that Derby is told the data has been written to stable storage, but then it has in fact not. If the machine crashes at this point data

Re: how to retrieve a number with more dec places

Hi Bob, Assuming you have stored it correctly, have you tried using getBigDecimal? -- Kristian Den tir. 28. feb. 2017, 07:03 skrev Bob M : Hi I have a derby database with records that contain a price e.g. 1.21098 I retrieve it by the following line price =

Re: Export with column names in first line

tor. 8. sep. 2016 kl. 07.05 skrev Eugster Christian BB_SK < christian.eugs...@stadt.sg.ch>: > I am afraid, I am not capable to open an issue. I do not know how I can > achieve this. I cannot find a menu entry to open a new issue. > Hi Christian, You'll probably need to sign up to get an account

Re: What is the fastest query to check for an existence of a row

Den 25.05.2016 23.12, skrev Bergquist, Brett: > I have a table with 80,640,704 rows. My query currently is: > > > > SELECT > > COUNT(*) AS USE_COUNT > > FROM > PKG_9145E_V1.COSEDDROPPROFILEDSCPTABLEBUNDLE_COSEDDROPPROFILEDSCPTABLEENTRY > CBCE > > WHERE

Re: Performance issue with same index name in multiple schemas

Den 05.02.2016 13.22, skrev kosurusekhar: > Hi All, > > We are having three schemas with almost same table structure, indexes, > queries, stored procedures in one database. But in one schema we are facing > some performance issue. We are having same index names and table names in > all schemas.

Re: got wrong data with using '%' as condition

Hi Li, '_' is a wildcard character matching a single character. To search for the literal '_' you have to escape it. There may be several ways to do that, but one is described here: https://db.apache.org/derby/docs/10.11/ref/rrefjdbc28456.html Regards, -- Kristian tor. 9. jul. 2015, 18.56

Re: Performance degradation with Derby Embedded under Tomcat vs Jetty

And, by testing with a network server I think you can access JMX mbeans with VisualVM/JConsole to check connection counts. -- Kristian 13. apr. 2015 13:12 skrev Kristian Waagan krist...@apache.org: Hi Øivind, Have you turned on SQL-logging/-tracing in Derby to check the activity? Possible

Re: Performance degradation with Derby Embedded under Tomcat vs Jetty

Hi Øivind, Have you turned on SQL-logging/-tracing in Derby to check the activity? Possible things to check: o connection IDs (distinct/count) o expensive connection validation queries (not all of these are direct SQL, check pool docs/conf) o commits? o different queries? While one would expect

Re: RawStoreDaemon thread in Derby Embedded Database

Den 25.03.15 07.48, skrev Vivek Choudhary: Thanks Rick, Mike for the information provided about the Daemon thread. It clears some understanding about the significance of these threads. In my legacy application it performs following operation - 1. writes data to table under jta transaction

Re: Star Derby as a service

Den 23.09.14 13:37, skrev Alessandro Manzoni: On Derby wiki pages (http://wiki.apache.org/db-derby/DerbyWindowsService) I found how to install Derby as a service. It's made by Tanuki wrapper, but I installed succesfully myself the service using Apache commons Daemon

Re: CPU Utilization

On 07.01.2013 20:51, Pavel Bortnovskiy wrote: Hello: This is more of a general question. Our application uses Derby in the in-memory mode only. When the application is configured to use complex queries, such configuration causes CPU utilization (on the Linux server) to go as high as 300%

Re: what do errors like these mean?

On 21.12.2012 16:18, Pavel Bortnovskiy wrote: Thank you, Knut, for your prompt response. It seems that my caching of Prepared Statements is causing some problems. In some previous responses, it was indicated that Derby is caching them internally anyway, so maybe a better approach for me is not

Re: unable to take backup after derby upgrade

On 02.10.2012 17:59, Tomcat Programmer wrote: I was able to backup my derby database successfully using the previous version 10.8.2.2 and the following command, running from ij: ij CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('/usr/local/derby10/backups'); After upgrading to 10.9.1.0 the same

Re: Need derby 10.0.2.1-bin.zip version

On 28.09.2012 15:17, lakshmi Suresh wrote: Dear Team , I am trying to set up a database for the CFEveryWhere environment. When i try to run the command java org.apache.derby.drda.NetworkServerControl start i am getting error as * could not load main class

Re: Derby server listening on different interfaces

On 19.09.2012 15:13, Maison Mo wrote: Hello Derby users, I have a rather unusual use case, where I have two clients using the same Derby DB. Thus I use a Derby server. One client is on the same host as the derby server, whereas the second one is not ; I have security concerns with the non

Re: derby db not found

On 04.09.2012 00:33, Rainier Diaz Ferrer wrote: Hello Derby team, my name is Rainier, i'm having problems trying to connect to my derby database using network server. I set the derby home directory by using this. System.setproperty(derby.system.home, mylocalpathtoderbydb); this code line goes

Re: All Derby Downloads Returning 404 from All Mirrors

On 26.08.2012 17:05, Michael Urban wrote: This has been going on for at least 14 hours now. All Derby downloads are returning 404 errors from ALL mirrors, including the backups. I looked at the directory structure of the Web server and it doesn't even appear there is a directory for where the

Re: All mirrors returning 404

On 26.08.2012 03:09, Equ Zephyr wrote: All mirrors the latest releases of Derby are returning 404 errors. Hi Equ, Thanks for letting us know. I'm not having any issues with downloading Derby. Do you have an example URL which is still broken? That said, the mirror selection script doesn't

Re: jOOQ Tutorial contribution for the Blogs and articles about Derby page

On 01.08.2012 14:11, Rick Hillegas wrote: On 8/1/12 1:17 AM, Lukas Eder wrote: Hello, I was wondering if Derby would be interested in a jOOQ tutorial contribution that could be put here: http://db.apache.org/derby/blogs/index.html#persistence I have done this before for H2:

Re: Derby 10.9.1.0 Incompatible with Substituted Drives on Windows

On 31.07.2012 12:32, John I. Moore, Jr. wrote: Derby Users and Developers, I have an application that has used Derby (with the Network Server) for years, and overall I have been extremely pleased.However, I ran into a problem when trying to upgrade to 10.9.1.0. I have three computing

Re: AW: schema-questions

On 23.07.2012 15:34, malte.kem...@de.equens.com wrote: Actually I found 2 hints 1. use SET CURRENT SCHEMA 2. Make your own custom authentication For completeness, one can also specify the schema explicitly in the queries of course. I don't know if there are scenarios where this

Re: AW: AW: AW: schema-questions

On 19.07.2012 18:44, Tim Watts wrote: My impression is that your goal is to explore web app development using Derby. In general, focusing on performance tuning in the absence of an actual performance issue is not going to be very productive. The above sounds like a good piece of advice to me.

Re: Strange OutOfMemory in unittest

On 28.06.2012 12:18, mogoye wrote: Problem is found : You were right, the problem was that my JVM starts with only 64m of heap size. I don't know why but I was sure I read somewhere that with JDK 1.5 the default max heap size was 512m... It can vary depending on the machine, platform, Java

Re: Strange OutOfMemory in unittest

On 27.06.12 15:15, mogoye wrote: Hello, I'm currently working on a some junit tests to validate My DB using Derby 1.8.1.2. My code is using JPA annotations and Eclipselink implementation. The purpose of this test is to evaluate the performances of my requests. My test is doing the following

Re: Conglomerate could not be created?

On 19.06.2012 09:45, John English wrote: On 05/06/2012 18:45, Dag H. Wanvik wrote: Looks like a bug to me. The error XSCH4 Conglomerate could not be created isn't being tested for in the Derby tests as far as I can see. I also searched the bug tracker

Re: Conglomerate could not be created?

On 20.06.2012 13:05, John English wrote: On 20/06/2012 11:45, Kristian Waagan wrote: Hi John, I believe your assumptions are correct. This is a bug in Derby where the temporary row holder, used to hold generated keys, overflows and a temporary backing conglomerate is attempted created

Re: DERBY-5818

On 14.06.2012 14:12, SAURABH KEJRIWAL wrote: I want the version details through SQL query. Could you please help me for this? Hi Saurabh, Can you just confirm that doing this via a JDBC method call isn't an option for you? If JDBC is okay, maybe the method

Re: Conglomerate could not be created?

On 04.06.12 14:52, Rick Hillegas wrote: On 6/2/12 3:18 AM, John English wrote: On 01/06/2012 15:19, John English wrote: I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT

Re: Derby Locks - best practices

On 01.06.2012 21:50, Pavel Bortnovskiy wrote: Hello, David, thanks for your quick response. Usually it's one thread per in-memory table. Tables can be updated at random times and their random rows may be updated, some rows deleted or new rows inserted. In some other configuration, to avoid

Re: limit on the number of columns

On 24.05.2012 23:33, Patrick Meyer wrote: That would be excellent! I think it would be a great feature to have in Derby. Hi Patrick, Can you say anything about how many columns would be needed to support these use-cases? Are we talking about a few thousand, ten thousand, or even more

Re: Not able to run the derby server on Eclipse

On 21.05.12 10:30, Mahesh Sitaram Patil11 wrote: Hello Team, I have configured the derby database for my Java application in Eclipse but I am not able to start the Derby server in eclipse. Please find the below screen shot of the consol error I am getting: Please let me know the solution for

Re: Derby database

On 05.05.12 12:13, Aristedes Maniatis wrote: Running Derby 10.8, a customer has managed to corrupt their database somehow (possibly by forcing the database to quit when it did not shut down fast enough to their liking). I see that when I connect to it with ij in embedded mode, I get the

Re: Database shutdown not releasing file handles

On 04.04.12 05:23, Trejkaz wrote: We have the occasional user reporting that after shutting down the database, they can see file handles still open. We're using ;shutdown=true (or at least the DataSource equivalent of it) to do this, and we were led to believe that this would be sufficient to

Re: Database shutdown not releasing file handles

On 04.04.12 09:27, Trejkaz wrote: On Wed, Apr 4, 2012 at 4:46 PM, Kristian Waagan kristian.waa...@oracle.com wrote: On 04.04.12 05:23, Trejkaz wrote: We have the occasional user reporting that after shutting down the database, they can see file handles still open. We're using ;shutdown=true

Re: Is it necessary to send shutdown in JDBC URL for Network Server clients?

On 26.02.2012 17:34, Libor Jelinek wrote: Hello everbody! When running Derby Network Server scenario, is it neccessary for clients to create connection with shutdown attribute when application is about to terminate? Or is enought to call java.sql.Connection.close() method? What is more

Re: Help derby not updating

On 22.02.2012 22:27, Patricia Miriga wrote: Hello, I have been loading and running derby every morning at work. However, it has not been updating for a week now. Please advise on how to do this. Hi Patricia, I have no idea what the community can help you with. Do you have any more

Re: Shutdown DB does not work / threadding issue

On 18.02.2012 15:45, Karl Weber wrote: Hi, I am using Derby DB in an embedded environment. I am shutting down the DB and the system using the following two methods (I have ommitted all try-catch- finally stuff, logging etc.) Shutting down the DB, where fDS is an EmbeddedDataSource40: public

Re: Unsubscribe

On 03.02.2012 22:09, Gabriel Massip Fons wrote: See http://db.apache.org/derby/derby_mail.html on how to unsubscribe. Regards, -- Kristian

Re: Selecting a few rows is really slow when ordering by primary key

On 01.02.2012 14:51, Rick Hillegas wrote: Hi Simon, Glad to hear that regenerating the statistics fixed your problem. More inline... On 2/1/12 4:07 AM, Simon Chatelain wrote: ... But one small question remains, do you think that it is enough to run SYSCS_UPDATE_STATIS TICS only once, or

Re: Selecting a few rows is really slow when ordering by primary key

On 02.02.2012 11:14, Kristian Waagan wrote: On 01.02.2012 14:51, Rick Hillegas wrote: snip On 2/1/12 4:07 AM, Simon Chatelain wrote: snip You may want to set derby.storage.indexStats.log=true, and more importantly, derby.storage.indexStats.debug.trace=true. Run you app for a while

Re: DB2 9.7 Connection with Apache Derby - 10.5.3.1 on Windows 7 64-bit doesn’t work

On 26.01.2012 11:07, Moni567 wrote: Hello, I used this http://www.ibm.com/developerworks/data/library/techarticle/dm-0409kartha/ description to setup the connection between DB2 and Apache Derby. This Connection works with Apache Derby - 10.5.3.1 and DB2 9.5 on my other laptop with Windows XP.

Re: List columns that make up an index

On 20.01.12 03:49, ollie2308 wrote: Hi I am having trouble writing a query that uses the derby system tables to return all index names and the columns and their order that make up the indexes. Hi, I'm not sure if we have a good solution for this. You may find the information at [1]

Re: Shutting down in-memory Derby gracefully

On 17.01.12 03:14, Pavel Bortnovskiy wrote: Hello, all can someone please also shed light on the following: In addition to the problems described in the previous email (below), I also get intermittent Database 'memory:test' not found errors while shutting down Derby: Hi Pavel, I don't

Re: [Unloading class org.apache.derby.exe.acf81e0010x0134x5183xd9d0x00001de8a8587]

On 12/18/11 03:18 PM, Sameer Alwosaby wrote: Dear When My application save records in java db , I received this [Unloading class org.apache.derby.exe.acf81e0010x0134x5183xd9d0x1de8a8587] [ snip - more unloading messages ] [Unloading class

Re: SQLChar.getCollationKey NPE in index-stat-thread

On 11.12.2011 19:42, Jean-Yves Linet wrote: Hi, I am upgrading Derby to last version 10.8.2.2 and I am stopped by what seams to be a bug. After activation ot stats trace I get this : Sun Dec 11 19:33:11 CET 2011 Thread[pool-3-thread-1,5,main] {istat} PROXIFLEX.IDAXX_RES: update scheduled,

Re: Move from embedded to network server

On 12.09.11 11:21, johny_quest wrote: Ok, lets see if I got you correctly: I stop IBM Director. I start the Derby Network Server giving it the database directory as home (is this done within the start command?) I then reconfigure IBM Director to connect with the network mode url (not the

Re: Move from embedded to network server

-- Kristian Thank you. Kristian Waagan-2 wrote: On 12.09.11 11:21, johny_quest wrote: Ok, lets see if I got you correctly: I stop IBM Director. I start the Derby Network Server giving it the database directory as home (is this done within the start command?) I then reconfigure IBM Director

Re: Derby client fails to connect to server every time after updating to 10.8.1.2

On 02.09.11 07:40, Trejkaz wrote: Hi all. We have tests (and apps, naturally) which start up the network server and then test that connecting to it works. One test runs our wrapping around the server and uses bare JDBC code to verify that it's connectable. The other test runs our wrapping

Re: Derby (in-memory) and Hibernate

On 31.08.11 04:08, Pavel Bortnovskiy wrote: Are there any issues in using Derby (in-memory only mode) with Hibernate? Is it fully supported? Hi Pavel, I'm not aware of any, but I'm not using Hibernate a lot. Maybe someone else has experience with this, or perhaps you could ask on a Hibernate

Re: Bug report for Apache Derby 10.4.x and onwards

On 12.08.11 11:41, srgrocks wrote: Hello Apache Derby team , This is to bring to your kind attention the fact that Apache Derby 10.6.2.1 , the version I am using is giving a error on using the ON UPDATE CASCADE statement . Hello, ON UPDATE CASCADE is not supported for foreign keys. From the

Re: Table exists in same JVM after Derby is shutdown

down. Regards, Pavel. From: Kristian Waagan kristian.waa...@oracle.com To: derby-user@db.apache.org Date: 08/09/2011 01:42 AM Subject:Re: Table exists in same JVM after Derby is shutdown On 08.08.11

Re: Table exists in same JVM after Derby is shutdown

On 08.08.11 16:41, Pavel Bortnovskiy wrote: Thank you, Dag. It looks like in order to get this to work, I had to make two calls to DriverManager.getConnection. Combining /shutdown=true;drop=true/ didn't work. So, is this the correct implementation (if in-line image doesn't work, please see

Re: Mistake CLASSAPATH

On 28.06.11 16:40, Wolfram Miksch wrote: Syntax for the derbyrun.jar file. http://db.apache.org/derby/docs/dev/getstart/rgsderbyrunjarsyntax.html#rgsderbyrunjarsyntax Found problem in above file: you wrote CLASSAPATH instead of CLASSPATH Vielen Dank, Wolfram. I have fixed the typo (revision

Re: SYSCS_UTIL.SYSCS_BACKUP_DATABASE failing-urgent

On 09.06.11 09:27, Brett Wooldridge wrote: Sorry I wasn't clearer. A thead dump is a snapshot of all running threads in the system, not a stacktrace of failures. You can generate a threaddump on Windows by running your server from the command line, and when the hang occurs during backup,

Re: Feedback derby_downloads.html

On 06.06.11 11:36, Richter, Tania wrote: Hello, we are using Derby 10.8.1.2 in our project. Now we have problems that are already reported in issue Derby-5098. As we can see this issue is fixed, but there is no official release right now (10.8.1.3 is supposed to come out mid September). Is

Re: Derby network server

On 02.05.11 15:13, John English wrote: I have a webapp which runs a networked Derby server. I want to be able to access it from a separate app. The webapp starts the server from the contextInitialized() method of a ServletContextListener: server = new NetworkServerControl();

Re: BLOB streaming

On 18.02.2011 14:59, Brett Wooldridge wrote: The question is, is it still fully materialized on the server before streaming to the client? No, it's not. Ideally, the only time a BLOB would be fully materialized is if ResultSet/Blob.getBytes() is called. There used to be some exceptions

Re: commands describe and show failed in eclipse derby plugin SQL editor

On 04.01.11 07:05, Bryan Pendleton wrote: On 01/03/2011 09:56 PM, Bruce Wen wrote: I used derby eclipse plugin from http://db.apache.org/derby/releases/release-10.7.1.1.cgi. I think that the best course of action here would be for you to file a new issue in Jira, including the information

Re: Error XSDBB When Trying to Access DB From Windows, But Works In UNIX

On 10.12.10 16:35, BEK1976 wrote: Hi, Hi, What I'm asking may very well be a red herring, but it would be nice to get it confirmed anyway. What's the underlying file system on the Windows machine, and what's the maximum allowed file size for that file system? Regards, -- Kristian

Re: Derby : No suitable driver found for jdbc:derby:db;create=true

On 02.12.10 16:35, BeNdErR wrote: I modifyed as you told me, that's the error print I get in the client window: SQLState:08001 Error Code:0 Message:No suitable driver found for jdbc:derby:db;create=true The rmid window, for the activatable server, shows this error: Maybe you already said,

Re: Derby : No suitable driver found for jdbc:derby:db;create=true

On01.12.2010 19:45, BeNdErR wrote: @bryan I tryed to run ij instead of tmp.Setup, as you said, then I tryed to connect to a new db, that's what I got: ij CONNECT 'ciao;create=true'; ERRORE 08001: No suitable driver found for ciao;create=true Note that unless you have configured Derby to use

Re: ERROR 08004: Connection refused : Invalid authentication.

On 29.11.10 09:32, Sonny Laskar wrote: Dear Thomas, Thanks for your inputs. I am not much familiar with the APIs. Let me tell you how I am proceeding: 1. I have copied the database folder hatterastc from the server to my PC.(This database is embedded in 1 application.) 2. I get the error

Re: does Derby honor the statement.setQueryTimeout(int) ?

On 20.10.10 17:16, florin.herin...@sungard.com wrote: Hi everybody, I’m using Derby latest 10.6.2.1 and I’m having a problem with statement.setQueryTimeout(int). Namely I want to set a small value for the timeout (5 seconds) so that the statement (an update statement) will fail

Re: AW: does Derby honor the statement.setQueryTimeout(int) ?

via jms messages) will lead to the consumming of all available database connections, since for each jms message a new thread/transaction is created and implicitely a new connection. Regards, Florin -Ursprüngliche Nachricht- Von: Kristian Waagan [mailto:kristian.waa...@oracle.com

Re: cannot make connection

On 02.10.10 17:18, laishram rahul wrote: Sir, Im using eclipse Helios wtp latest release, connection with derby embeddeb jdbc driver is working fine but i CANNOT make connection with DERBY CLIENT JDBC DRIVER. please provide me some help if it is possible... Hello, Are you connecting to a

Re: Problem inserting a record with derby 10.6.1.0

to upgrade derby from 10.5.3.0 to 10.6.1.0. Hope this help, Lily *From:* Kristian Waagan kristian.waa...@oracle.com *To:* derby-user@db.apache.org *Sent:* Fri, September 17, 2010 3:47:21 AM *Subject:* Re: Problem

Re: Problem inserting a record with derby 10.6.1.0

:* Kristian Waagan kristian.waa...@oracle.com *To:* derby-user@db.apache.org *Sent:* Fri, September 17, 2010 3:47:21 AM *Subject:* Re: Problem! On 17.09.10 12:11, Bhat, Avinash (NSN - IN/Bangalore) wrote: Hi, This is avinash bhat, I am facing a problem in derby upgrade. Currently I have 10.5.0.3

Re: Problem!

On 17.09.10 12:11, Bhat, Avinash (NSN - IN/Bangalore) wrote: Hi, This is avinash bhat, I am facing a problem in derby upgrade. Currently I have 10.5.0.3 version installed in my system and when I tried upgrading it to 10.6.0.1 my software is not able to load it is throwing null pointer

Re: question: is is possible to identify open resources?

On 11.09.10 10:16, Patrick Holthuizen wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I use Derby with an in-memory database for unit testing. All unit tests share a single connection. Now I want to assert (not close) (in the tear down of a unit test) that all result sets and

Re: Reclaiming space from Derby

On 08.09.10 12:50, Paul Taylor wrote: HI, I use derby in embedded mode, I let the user specify a maxmium size for the derby database files, my program monitors this and if it goes over the size I use SQL to delete records that are no longer necessary in the hope of shrinking the database

Re: Create trigger with 2 sql statements

On 23.08.10 11:52, Andrzej Kasprzyszyn wrote: Hi All I would like to create following trigger CREATE TRIGGER COUNTRY_TRG AFTER INSERT ON COUNTRY DELETE FROM aTable WHERE table_name = 'country' INSERT INTO aTable(table_name, msg) VALUES('country', current_timestamp) I am receiving syntax

Re: Java exception: '-1: java.lang.ArrayIndexOutOfBoundsException' error

On 13.08.10 12:45, Shankar Devi wrote: Hi, Please let me know the timeframe for when this issue is likely to be fixed. Hi, I'm not sure we have identified the real problem yet. Can you answer my latest question which I believe was: - 1. It looks like once connection is

Re: Can't find database

it be caused by multiple threads trying to boot the database? And in case somebody wants to pursue this issue later, do you know if it happened across a range of different JVMs? Thanks, -- Kristian Thanks, David On Tue, Aug 10, 2010 at 1:48 AM, Kristian Waagan kristian.waa...@oracle.com

Re: Log connects and disconnects

also filed an improvement request: https://issues.apache.org/jira/browse/DERBY-4769 Thanks, -- Kristian Greets Damian Am 11.08.10 11:31, schrieb Kristian Waagan: On 11.08.10 10:42, Damian Hofmann wrote: Hi Derby Community Short question: Are disconnects supposed get logged if the option

Re: Derby Self-study Tutorial

On 10.08.10 21:41, Sal Ishmel wrote: May someone please assist me in this: 1. Can i do the Derby Self-study Tutorial on Mac OS 10.6? 2. I am running Eclipse 3.6 and Netbeans 6.9, both bundled with the Apache Derby. Can I run the tutorials on these IDEs? Thanx in advance.

Re: Log connects and disconnects

On 11.08.10 10:42, Damian Hofmann wrote: Hi Derby Community Short question: Are disconnects supposed get logged if the option derby.drda.logConnections is enabled? If not, how can I see if the connections get properly closed? Hi Damian, I don't think disconnects are logged. I see two

Re: Can't find database

On 09.08.10 23:55, David Van Couvering wrote: I am getting these intermittent errors that I can't reproduce on my machine: Database 'C:\VontuDev\main\dist\scan\incremental_index/MONITOR/INCREMENTAL_INFO' not found I read the docs, and there is no discussion about whether a mixed \ / path

Re: Low performance when execute more then 100 inserts

On Tue, Aug 03, 2010 at 04:01:56PM -0300, Fabricio Pedroso Jorge wrote: Hello, I have a Java application that reads a .txt file, validates the informations and then executes several inserts into de Derby 10.5 database. The problem is that when i have a lot of inserts (more than 1000), the

Re: Shutting down a database that is already shut down

On Fri, Jul 30, 2010 at 02:30:34PM -0700, David Van Couvering wrote: Do I have to worry about ensuring that a database is running before I try to shut it down, or is it OK to get a connection with URL ;shutdown=true on a database that's not booted. If I were to do that, does it boot the

Re: backing up the DB

On Mon, Aug 02, 2010 at 04:00:41AM -0700, vadali wrote: Hello, I have a few tables (with FK), that i need to save and restore. My original plan was to save the entire directory of the database on one machine, then reload it on another machine. The problem is that i might want to only

Re: Database-side programming

On 18.07.10 18:15, Saleem EDAH-TALLY wrote: Hello, This concerns getting information from 'inside' Derby through JAVA code called by a procedure. The nested connection can be obtained with jdbc:default:connection. However the URL attributes cannot be retrieved in any way. Hi, Maybe it would

Re: How to best constrain database space with many records being inserted and deleted

On 06.07.10 20:09, Bergquist, Brett wrote: I have a situation where my system is adding about 600K records a day to a table and also deleting about 600K records a day. Basically it is keeping 30 days worth of history of some network management service level agreement data. So each day

Re: Cannot setup in-memory embedded derby

On 15.07.10 11:37, Sergey Ponomarev wrote: Hi, help please. I'm trying to use in-memory derby, but get database 'login' not found error (java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: База данных 'login' не найдена.) I've included

Re: Unknown page format at page Page(257,Container(0, 432592)

On 08.07.10 18:03, Erick Lichtas wrote: Hi everyone, I have been using an embedded setup of derby (version 10.4.1.3) for quite some time. It appears that my database has become corrupt for some reason, possibly related to https://issues.apache.org/jira/browse/DERBY-3725 Hi, I'm afraid

Re: Database corruption on crash during table creation

On 06.07.10 08:23, David Van Couvering wrote: Hi, all. I seem to have a repeatable issue where my database is getting corrupted, and I can only assume it's happening when the table is getting created, because I know Derby is great on handling crashes during normal operation. First of all -

Re: Android

On 23.06.10 15:03, Paul French wrote: Anyone tried a derby database on android? I need to look at this shortly but if it is a definite “does not work” then you will save me some time. Hi, I think you're out of luck for now, at least if you want this to be an easy ride :) See DERBY-4458

Re: Hung thread after another thread is interrupted

On 22.06.10 10:03, Kristian Waagan wrote: On 22.06.10 08:46, Luke Quinane wrote: Hi Kristian, I've played around with the code a bit during the day and the attached patch seems to fix the problem where another thread is stuck. I've never really look at the Derby code before so I'm

Re: Java exception: '-1: java.lang.ArrayIndexOutOfBoundsException' error

On 02.06.10 10:35, Shankar Devi wrote: Hi Kristian, Thanks for the reply. 1. It looks like once connection is selecting from the BLOB, and then another connection deletes (or updates) it. Does this sound plausible for your application? [Devi] - yes.It is possible. In that case, how do you

Re: Hung thread after another thread is interrupted

On 21.06.10 09:20, Luke Quinane wrote: Hi all, We've seen a problem today where we have several threads querying our database and when one gets interrupted the others are stuck waiting for a lock. Here is the stack trace for the stuck thread(s): daemon prio=4

Re: can't delete my DB directory

to my expectations for two reasons: a) Since Step 2 is a read-only operation, I don't see why commit() is needed. b) Even if a commit() is needed, the shutdown shouldease all DB resources (and not hang on to any files). Any thoughts? Kristian Waagan-4 wrote: Hello, What operating system

Re: can't delete my DB directory

On 04.06.10 18:51, oldmhe wrote: Prior to exiting, my Java program issues a shutdown, and then tries to delete the DB directory (recursively), but is not able to completely delete the directory. Here's the code: try {

Re: strange behavior using embedded driver

On 01.06.2010 10:42, Marco Ferretti wrote: Hi During some edge testing of my application I came across a strange behavior using an embedded derby driver on windows: if, once the database is started, the machine is given a different ip address ( eg : the network is no longer available or the

Re: java.sql.SQLException: No suitable driver

On 28.05.2010 18:44, Marcin Krol wrote: Hello everyone, I'm trying to use Derby here as embedded database in our test automation framework (that deploys itself on the remote endpoint and executes some Java classes to test functionality of the product). Code: private void

Re: Java exception: '-1: java.lang.ArrayIndexOutOfBoundsException' error

On 26.05.10 12:12, Shankar Devi wrote: Hi, I have an intensive data-processing application which utilises Apache Derby Version - 10.3.1.4. My Customer is running this application on Windows 2003 Service Pack 2 and has 1.6 GB derby database size. Application has crashed after throwing this

Re: Truncating CLOB error

On 06.05.10 15:04, Mark Thornton wrote: On 06/05/2010 13:52, Marco Ferretti wrote: *maybe* you are affected by this http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel Very likely, especially as Mike Douglass

Re: A truncation error was encountered trying to shrink VARCHARTA 'XX-RESOLVE-XX' to length 255.

.doCall(CharacterController) Thanks in advance!! Doug Kristian Waagan-4 wrote: On 26.04.10 17:45, OggieOne64 wrote: Thanks for responding but the problem is that I am trying to insert an image (not text). The field is of type Blob. Any other ideas? BTW: How can I verify what version

Re: Very bad disk space leak in Derby

On 30.04.10 23:38, David Van Couvering wrote: Hi, all. I have a thread that runs the following query every 10 seconds: SELECT d.ITEMSET_ID, f.FILTER_INDEX, FROM FILTERS f, PENDING_DELIVERIES d WHERE f.ITEMSET_ID = d.ITEMSET_ID AND f.FILTER_INDEX = d.FILTER_INDEX AND d.SENT = 0 AND d.SERVER_ID

  1   2   3   4   >