Re: Derby Error message - explanation required

On 9/18/14 2:25 AM, Bob M wrote: Hi Knut Thanks for the advice.. My derby version is 10.11.1.1 though :) I shall come back after a trial run this evening In the meantime, a question Why is my derby.log to be found in C:\Downloads ? Hi Bob, By default, the diagnostic log is

Re: Derby Error message - explanation required

On 9/18/14 7:29 AM, Bob M wrote: Hi Rick and Knut Many thanks for your time and assistance :) By deleting the empty .tmp file we are in business again Should I add any code to stop this happening in the future? Hi Bob, I don't have any clever advice. If this happened to one o

Re: how to view the trace log

On 9/17/14 11:00 PM, Rocky.Hu wrote: > > Hi: > > I had been add the derby.properties file into the > %DERBY_HOME%\bin，and I used the Derby in client/server mode, when I > started and visited the database, it also procedure a file named > Server1.trace in the %DERBY_HOME%\bin, but I opened the file,

Re: Listing users

On 9/25/14 9:49 AM, Alessandro Manzoni wrote: I tried granting select on sysusers, but this table is accessible only by db owner. Is there a way to have a simple user, maybe with a specific role, to list user names? Hi Alessandro, You can accomplish this by declaring a table function with de

Re: Listing users

On 9/26/14 8:13 AM, Alessandro Manzoni wrote: Il 25.09.2014 21.31, Rick Hillegas ha scritto: On 9/25/14 9:49 AM, Alessandro Manzoni wrote: I tried granting select on sysusers, but this table is accessible only by db owner. Is there a way to have a simple user, maybe with a specific role, to

Re: Function calling a Procedure

On 10/3/14 9:08 AM, Alessandro Manzoni wrote: I created an udf (defined as contains sql) and a procedure (defined as modifies sql data). The function eventually calls the procedure, but its get an exception that says that the function attempted to change data but is not defined as modifies sql

Re: ij encoding

On 10/9/14 9:51 AM, Vitaliy wrote: Hello! I'm new with Derby, trying to start the ij with proper encoding. Ij wants to use default locale in my OS, but I would rather prefer using an english locale. I start ij with the command: java -Dderby.ui.locale=en -Dderby.ui.codeset=utf8 -jar E:\...\d

Re: issues.apache.org/jira/browse/DERBY-3946

Hi Kent, I'm moving this discussion to the derby-user@db.apache.org mailing list so that it will be archived in case anyone else is interested later on. The work on DERBY-3946 was superseded by the work on DERBY-4415. I've resolved DERBY-3946. Hopefully that will help point people at DERBY-44

Re: issues.apache.org/jira/browse/DERBY-3946

That will lead you to the spot in the code where short-circuiting takes place. Your custom XmlASTPrinter will need to turn on short-circuiting after it is installed. If you want, you can log a JIRA for reviving the old behavior. Hope this helps, -Rick On 10/14/14 5:40 AM, Rick Hillegas wrote

Re: issues.apache.org/jira/browse/DERBY-3946

Hi Kent, I have used XmlASTPrinter on queries against tables which don't exist. Although you get errors at bind-time, the parse tree is still dumped to derbyAST.xml. You just need to catch the bind-time exception and soldier on. Hope this helps, -Rick On 10/14/14 8:40 AM, Rick Hil

crowd-funding Derby development

I was wondering what people would think about trying to crowd-fund new Derby features and bug fixes. Right now, the Derby developers tend to focus on features and bugs which are important to their employers. This does not address the needs of smallish companies and products which can't afford t

Re: XSDB6 Another instance of Derby may have already booted

On 10/24/14 1:37 PM, Thomas Hill wrote: Hi, I am getting below error even after the derby server and the server machine had been shutdown and brought up again. Might this indicate the data base is corrupt? Is ther any way to further diagnose what is going on? Thanks java.util.concurrent.Execut

Re: derby network server start problem

On 10/28/14 2:51 AM, shoyeb sheikh wrote: Hi, I am using netbeans 8 and derby DB, I want a java code to start apache derby network server automatically at the start of my program codings, Right now I have to manually start network from Java DB node after right clicking the node Please help

Re: No Powered By Derby Logo

On 11/8/14 4:23 AM, John I. Moore, Jr. wrote: There are a lot of "Powered By" logos on the Apache web site (e.g., see http://apache.org/foundation/press/kit/ and http://apache.org/foundation/press/kit/poweredBy/), and there is an official Derby logo (http://db.apache.org/derby/logo.html), but

Re: No Powered By Derby Logo

Hi John, I have combined the poweredBy and Derby logos and put them here: http://db.apache.org/derby/logo.html#logo_with_nimbus Hope this helps, -Rick On 11/8/14 4:23 AM, John I. Moore, Jr. wrote: There are a lot of "Powered By" logos on the Apache web site (e.g., see http://apache.org/fou

Re: No Powered By Derby Logo

-Rick _ John I. Moore, Jr. SoftMoore Consulting *From:*Rick Hillegas [mailto:rick.hille...@gmail.com] *Sent:* Monday, November 10, 2014 9:33 PM *To:* Derby Discussion *Cc:* John I. Moore, Jr. *Subject:* Re: No Powered By Derby Logo Hi John, I have combine

Re: Using UserDefinedType (UDT) as Stored Procedure parameter will be a performance threat?

It is hard to say what is causing your performance problem. Can you profile this code and see which statement is taking too long? More inline... On 11/19/14 6:52 AM, kosurusekhar wrote: Hi folks, In one of my requirement i have variable number of store procedure parameters to use, and max will

Re: User Defined Type as Table Column

On 11/27/14 3:56 AM, kosurusekhar wrote: Hi folks, We decided to create a table column with User Defined Type (A java class has big byte array& certain other properties), Is there any issues or any problems (performance side) while doing insert / update / delete into or from this table? If any

Re: Duplicate key feature request

On 11/30/14 4:17 AM, Dyre Tjeldvoll wrote: On 29. nov. 2014, at 19.02, John English wrote: On 29/11/2014 14:50, Dyre Tjeldvoll wrote: I think the SQL-standard way of doing things like this is with the MERGE statement (just added to

Re: Duplicate key feature request

On 12/1/14 4:08 AM, John English wrote: On 01/12/2014 03:47, Rick Hillegas wrote: On 11/30/14 4:17 AM, Dyre Tjeldvoll wrote: Anyway here is my attempt at formulating INSERT ON DUPLICATE KEY UPDATE using MERGE (untested, no warranty): MERGE INTO T AS DST USING SYSIBM.SYSDUMMY1 ON DST

Re: Urgent question about JIra issue DERBY-526

On 12/3/14 12:09 AM, Lin Ren wrote: Hi Guys, Sorry for the broadcast… I have a quick question about issue DERBY-526, I’m currently using Derby version 10.10.1.3, and still meet the same problem: When I using IPv6 JDBC URL like: “jdbc:derby://2001:db8:0:f101:0:0:0:9:1527/xxx;create=true;use

Re: Duplicate key feature request

On 12/4/14 2:26 AM, John English wrote: On 02/12/2014 00:30, Rick Hillegas wrote: On 12/1/14 4:08 AM, John English wrote: However, why not in any case consider deriving a separate subclass of SQLException for the duplicate key case? It wouldn't break any existing code, it's presumab

Re: Duplicate key feature request

On 12/8/14 5:31 PM, John English wrote: On 04/12/2014 23:44, Rick Hillegas wrote: Hi John, Yes, that's true. You're welcome to log an enhancement request for this behavior. Regards, -Rick Thanks. Can you tell me where/how I do this? Hi John, Instructions for using JIRA to lo

Re: ddlToDatabase writeDataToDatabase

On 12/12/14 10:50 AM, Kevin Luo wrote: Hi, I've been thrown to the bottom of valley over last 2 hours trying to figure out why I was keeping the error message:" >>Returning connection org.apache.commons.dbcp.PoolableConnection@fc23cf to data source. >>Remaining connections: None F:\NBProj

Re: How to Combine Apache Derby without installing with Jar Directly

On 1/6/15 11:09 PM, Varun Sawaji wrote: Hi, I have application which was developed using Java and Apache Derby. I want to create executable JAR and run on any system which doesnot have derby DB.When I click on Jar file the derby also install on the system. Is it possible. Varun Hi Varun,

Re: drop schema question

On 1/10/15 8:38 PM, zhosn wrote: Hi，Bryan ： I not create table,view etc.When i create schema,Only created a schema.when i run script"DROP SCHEMA schemaName RESTRICT"System tip:no drop,Why? and Derby no support keyword"cascade". -- View this message in context: http://apache-database.10

Re: SYSCOLUMNS Locking Under High Load

On 1/14/15 7:00 AM, Chip Mitchell wrote: Hey all - I was wondering if anyone has come accross this situation before. We have a relatively simple table (below). And it seems that during high insert loads, we see long running transactions and locking. But what I was surprised to see was that the

Re: Derby log

Hi Alessandro, The simplest way to achieve your goal is to provide a public static method which returns a custom java.io.OutputStream or java.io.Writer. Then point to that method using the system property derby.stream.error.field as described in the Reference Manual: http://db.apache.org/derb

Re: Derby log

On 2/13/15 3:36 AM, Alessandro Manzoni wrote: Il 12.02.2015 22.20, Rick Hillegas ha scritto: Thank you Rick, Hi Alessandro, The simplest way to achieve your goal is to provide a public static method which returns a custom java.io.OutputStream or java.io.Writer. Then point to that method

Re: RawStoreDaemon thread in Derby Embedded Database

On 2/24/15 4:31 AM, Vivek Choudhary wrote: Please can someone provide me information regarding the use of RawStoreDaemon thread in Derby database. I am pretty new to derby database and was looking for some information regarding this. Also, since this is a daemon thread does this impact to an

preallocated values for generated columns

It sounds as though you are not shutting down your Derby engine gracefully before your application exits. For instructions on how to shutdown Derby gracefully, please see http://db.apache.org/derby/docs/10.11/devguide/tdevdvlp40464.html By default, Derby sequence generators preallocate blocks

Re: Tree view in Derby Stored Procedure

On 4/10/15 6:20 AM, BalNagendra wrote: Dear All, I am attempting to write s Stored Procedure in Derby similar to Oracle CONNECT BY/START WITH. CONNECT BY/START WITH builds a hierarchical data set from a EMP and MGR self-referencing. I am able to successfully implement this using Java but it sits

Re: Tree view in Derby Stored Procedure

Again, I think that a table function would be well suited to this task. A table function is a public static method which returns a ResultSet. See http://db.apache.org/derby/docs/10.11/devguide/cdevspecialtabfuncs.html. I don't have any better idea than that. I think that a streaming interface

Re: Security contact

On 4/29/15 11:24 AM, Philippe Arteau wrote: Hi, What is the official way to report vulnerabilities related to derby DB? I don't see any contact in : https://db.apache.org/derby/derby_mail.html https://db.apache.org/derby/derby_comm.html Thanks Hi Philippe, Security vulnerabilities in the db

Re: can't get warning 01003 in nested select in update

On 5/16/15 7:25 AM, Bryan Pendleton wrote: 3, when the select in an update statement, can't get the warning 01003. ij(CONNECTION1)> UPDATE APP.EMP T1 SET SALARY = ( SELECT AVG ( T2 . SALARY ) FRO M APP.EMP T2 ) WHERE WORKDEPT = 'D21' AND SALARY < ( SELECT AVG ( T3 . SALARY ) FROM APP.EMP T3 );

Re: Apache Derby Network Server, Insufficient data while reading from the network

On 5/22/15 4:57 AM, kosurusekhar wrote: Hi All, We are using derby as database in our two different kind of applications. In the desktop application the design is when ever we open my application we have to start the Derby network server& while closing the application we have to close the derb

Re: Working around Java 7 issue with DH-based cipher suites

On 6/25/15 9:37 AM, Besosa, Michael wrote: I'm in the process of migrating an application that was successfully using embedded Derby to the Derby Network Server using SSL in basic mode. I've run into what seems to be an old issue with Java 7 and cipher suites that use Diffie-Hellman key exchang

Re: How can I run derby client in network mode so that the SocketPermissions required for it can be specified in my custom policy file without having to add it in the java.policy file

On 7/29/15 8:08 AM, amani wrote: I am trying to use the Apache derby in java application with security manager enabled with custom security policies loaded at runtime. In java code Policy.getPolicy() shows all the policies that I have added in custom policy file before invoking the derby client.

Re: Unsubscribe

On 8/3/15 9:32 AM, Curry, David CIV NAVAIR 535100D wrote: Hi David, To unsubscribe from this list, please send a message to derby-user-unsubscr...@db.apache.org as described here: http://db.apache.org/derby/derby_mail.html Thanks, -Rick

Re: Unsubscribe

On 8/3/15 10:21 AM, Yash Swarnkar wrote: Plz unsubscribe Hi Yash, To unsubscribe from this list, please send a message to derby-user-unsubscr...@db.apache.org as described here: http://db.apache.org/derby/derby_mail.html Thanks, -Rick

Re: Unknown page format at page Page(7,Container(0, 161)) [SYSCOLUMNS_INDEX1] on bootup

Hi David, If all else fails, you can create an empty database with the same schema as the old one, and then siphon data out of the corrupt database into the new database using the custom tool attached to https://issues.apache.org/jira/browse/DERBY-6136. Something like this... call syscs_util

Re: Trouble starting Derby in-memory server using Gradle and Liquibase

What John says. Please see the Derby Server and Administration Guide for more details: http://db.apache.org/derby/docs/10.12/adminguide/index.html Thanks, -Rick On 10/27/15 2:01 AM, John English wrote: On 26/10/2015 21:03, Dave Alvarado wrote: *I’m using Gradle 2.7 and Derby 10.12.1.1. I wou

Re: hello

On 11/1/15 2:37 PM, בבנייה בבנייה wrote: I trying to leran derby for a project that include it. I want to say that it's very not full , there is much misunderstand for who that not familiar with all issues like class path, start server and more. I think that should at least be a quick and frien

Re: How to get xml attribute using Apache Derby

Hi Greg, Analyzing this requires a deeper knowledge of xml processing than I can claim. The error is being thrown by org.apache.derby.iapi.types.XML.XMLSerialize() at a point in the code with this comment: /* XML serialization rules say that sequence "normalization" * must o

Re: Difference between having no default and having DEFAULT NULL

Hi Trejkaz, What version of Derby did you use to create the original schema? This behavior (COLUMN_DEF = NULL) goes back at least as far as Derby 10.10.1.1. There is no semantic difference between a column which is declared without a default and a column which is declared as DEFAULT NULL. Th

Re: SYSCS_UTIL.SYSCS_CHECK_TABLE

On 11/26/15 6:49 AM, 5...@informatik.uni-hamburg.de wrote: Hello, I would like to test the consistency check function but I have difficulties inserting certain inconsistencies into the database for proper testing. I found a Testscript which uses T_ConsistencyChecker.class and managed to run

Re: What creates rawStoreDaemon threads in embedded derby db?

On 12/2/15 8:00 AM, culgr01 wrote: People have made similar observations in the past, but we've never identified a clear reproducible case Is there some information that would help you guys solve this problem? I have a thread dump of the issue, and a heap dump. However, I can't give them to yo

Re: where condition in CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY fails

On 11/30/15 9:02 PM, Anjana Prakash wrote: CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY('select t.tablename from sys.systables t,sys.sysschemas s where t.schemaid = s.schemaid and t.tabletype=T','test.txt',null,'/',null); Hi Anjana, Your call to SYSCS_UTIL.SYSCS_EXPORT_QUERY() fails because you need to

Re: Using a SELECT FROM command correctly

Hi Bob, Have you tried adding the following WHERE clause to your query: where is not null Hope this helps, -Rick On 12/7/15 6:01 PM, Bob M wrote: Hi I was using the following command successfully:- "SELECT * FROM ORDER BY y DESC DESC OFFSET 1 ROW FETCH NEXT 1 ROW ONLY"

Re: Subscribe

On 12/16/15 10:25 AM, Colm McHugh wrote: Hi Colm, To subscribe to derby-user, please send a message to derby-user-subscr...@apache.org. To subscribe to derby-dev, please send a message to derby-dev-subscr...@apache.org as described here: http://www.apache.org/foundation/mailinglists.html

Re: getting a subset from a database of records

On 12/30/15 5:29 PM, Bob M wrote: Hi My database records contain a field A which either has a numeric entry or is I wish to pull out a subset where the value of various fields are set by me. That part is working OK. But, in addition, I only want those records where the above field A is not

Re: interpreting an error message

On 2/14/16 5:26 PM, Bob M wrote: Hi all The following is from my log:- 2016-02-15 02:13:28 java.sql.SQLNonTransientConnectionException: Connection authentication failure occurred. Reason: Invalid authentication.. 2016-02-15 02:13:28 Number of records in table USDCAD_S: 4100 2016-02-15

Re: Derby mail list subscription for L2 Support

Hi Audrey, I think that it should be sufficient for you to subscribe to derby-user. It looks as though your previous message went to the correct mailbox (derby-user-subscr...@db.apache.org), the one which will trigger that subscription (provided that you responded to the automatically generate

Re: Would it be beneficial to merge the derby-user and derby-dev mailing lists?

On 6/18/16 9:11 AM, Bryan Pendleton wrote: Hi all, It is not 100% clear to me why we have separate 'derby-user' and 'derby-dev' mailing lists. On our web site, http://db.apache.org/derby/derby_mail.html, we describe the two lists as follows: derby-user: For discussions about how to use

Re: Not able to execute function in a UDF

On 7/5/16 9:11 PM, Dinesh Bajaj wrote: CREATE FUNCTION invoice_total ( invoiceNumber int ) RETURNS DECIMAL LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA EXTERNAL NAME 'FXBilling.DBJAR.DBMethods.getInvoiceTotal' Hi Dinesh, It's hard to say what's going on. Could you share the Java code which

Re: Not able to execute function in a UDF

ION CODE * Should you require any other info, kindly let me know. Thanks, Dinesh On Thursday, 7 July 2016 7:34 AM, Rick Hillegas wrote: On 7/5/16 9:11 PM, Dinesh Bajaj wrote: > CREATE FUNCTION invoice_total > ( invoiceNumber int ) > RETURNS DECIMAL > LA

Re: Not able to execute function in a UDF

ling the function that resides in the "App" schema, the "NO SQL" version of the function is being called. Thanks for helping me diagnosing the problem. Much appreciated :) :) -Dinesh On Friday, 8 July 2016 7:04 AM, Rick Hillegas wrote: On 7/7/16 1:40 AM, Dinesh Bajaj wrote

Re: lose ownership on date base after set derby.database.sqlAuthorization to true

On 7/11/16 6:07 AM, rsmon wrote: Thank you, but i have created data database via Netbeans and i have created with username testeur and be connected like shows this picture if i pass select * from TESTEUR.CLIENT i obtain Erro

Re: lose ownership on date base after set derby.database.sqlAuthorization to true

Hi Régis, More responses inline... On 7/12/16 12:23 AM, rsmon wrote: Hi Ricks, Thank you for your response. Effectively when i execute select * from sys.sysschemas where schemaName = 'TESTEUR'; i obtain: 278b81cd-0155-d9ce-d86a-12e9eb35 TESTEUR APP As you note, this indicates that the da

Re: Puzzling error

On 8/4/16, 7:32 AM, Donald McLean wrote: I am running Derby 10.12.1.1 under Java 1.8.0u102. I am getting an exception trying to delete a record that I added not long before (as part of a unit test) (see stack trace below). Any thoughts, hints, or ideas as to what I'm doing wrong would really

Re: Does derby support "server-side cursors" in embedded mode?

Hi Johann, Some responses inline... On 11/7/16, 7:16 AM, Johann Petrak wrote: What I would like to do is this: use Derby in embedded mode to create a very large table with fields "key" and "value": create table mytable ( key varchar(100) not null, value varchar not null) and a non-unique in

Re: SQL help needed

Hi John, The outer join is the typical SQL approach to computing the difference between two relations: select * from x left join y on x.a = y.a and x.b = y.b where y.a is null; Hope this helps, -Rick On 11/27/16, 2:13 AM, John English wrote: I'm trying to find all rows in a table where

Re: Security problem with ggregate functions using Java

Thanks for raising this issue, Nicholas. Can you include the full stack trace for the error? The template policy may need to grant some additional privilege to the engine jar file. It is also possible that you have run into the following defect: https://issues.apache.org/jira/browse/DERBY-4354

Re: Security problem with ggregate functions using Java

derbytools.jar // permission java.util.PropertyPermission "user.*", "read"; permission java.util.PropertyPermission "java.home", "read"; permission java.util.PropertyPermission "java.class.path", "read"; permission java.util.Prope

Re: Triggers, locks and transactions

On 3/7/17, 12:41 PM, nicholas walton wrote: Hi, I have a a data model built around triggers. It accepts data in via only one table RAW_DATA upon which I have one BEFORE trigger CREATE TRIGGER lock_transaction NO CASCADE BEFORE INSERT ON raw_data REFERENCING NEW AS NEW LOCK raw_data in EXCLUSI

Re: Using Derby as a network server

On 5/7/17 8:46 AM, Daniel Godefroy wrote: I am trying to use Derby as a network server. I have a network drive mapped as Z: where the whole derby system is stored under z:javadb. I have a z:/Derby/actif directory which contains the derby software. I need that any computer can start the derby se

Re: Identity column and 40XL1 error

Hi Abhi, You may have tripped across a problem with the IDENTITY_VAL_LOCAL() function. When identity columns were re-worked to use sequence generators, concurrency tests were run which involved many writers, that is, many sessions which concurrently issued INSERT statements. I don't recall mu

Re: Updating 2 derby tables

Hi Bob, It is hard to tell what the problem is from the code below, since that code only refers to one table. A more complete picture of the code might suggest some clues. Thanks, -Rick On 5/18/17 3:53 PM, Bob M wrote: Hi Until recently I had just the one single derby database table and cou

Re: Identity column and 40XL1 error

ction. The JDBC approach to retrieving the keys generated by the current session is to use java.sql.Statement.getGeneratedKeys(). Hope this helps, -Rick On Fri, May 19, 2017 at 5:18 AM, Rick Hillegas mailto:rick.hille...@gmail.com>> wrote: Hi Abhi, You may have tripped acros

Re: Updating 2 derby tables

On 5/19/17 1:13 PM, Bob M wrote: hey - we got to here - [b] !! There is more going on in your code than is apparent from the snippet you included. For instance, the output contains the line "hey - we got to here - [b] !!" but that line does not appear in the source code you p

Re: Identity column and 40XL1 error

dKeys internally supported by Derby using IDENTITY_VAL_LOCAL()? What am I missing here? Is there a way around this? On Sat, May 20, 2017 at 5:49 AM, Rick Hillegas mailto:rick.hille...@gmail.com>> wrote: On 5/18/17 9:12 PM, Abhirama wrote: Rick, My code is not explicitly firi

Re: Identity column and 40XL1 error

Is getGeneratedKeys internally supported by Derby using IDENTITY_VAL_LOCAL()? What am I missing here? Is there a way around this? On Sat, May 20, 2017 at 5:49 AM, Rick Hillegas mailto:rick.hille...@gmail.com>> wrote: On 5/18/17 9:12 PM, Abhirama wrote: Rick, My cod

Re: Connection authentication failure occurred. Reason: Invalid authentication..

Hi Peter, This is the error which Derby raises when the user presents invalid credentials at connection time. Are you confident that correct credentials were given? Are the NATIVE credentials stored in the database being connected to? Or are they stored in a system-wide credentials database?

Re: Obtaining a scroll insensitive resultset from a select query.

On 6/5/17 11:39 AM, Daniel Godefroy wrote: I need to use a resultset with 4 or 5 rows for a payroll. I get it from a simple select statement. I will use it for every employee in the payroll. I need to process the different rows for each employee. The recordset should then be of the type scrool_

Re: Derby metadata locked, parameterized query.

On 6/8/17 9:52 AM, Charron, Tom wrote: Recently, we have updated some code we have to go thru Parameterized queries, and we are seeing a rare, but odd, problem. Sometimes, we are encountering a lock timeout on the metadata during preparation of the queries. What would cause the read only

Re: When is the next release due?

On 6/17/17 5:52 AM, Hooman Valibeigi wrote: Hi I am waiting for the next release of derby which includes the fix for bug #6918 . The fix has been committed to both 10.14 and 10.13 branches 7 months ago. Does anyone know when the next release i

Re: When is the next release due?

r. The developer community is discussing when that will happen. Thanks, -Rick Best, Hooman Valibeigi On Sat, Jun 17, 2017 at 7:23 PM, Rick Hillegas mailto:rick.hille...@gmail.com>> wrote: On 6/17/17 5:52 AM, Hooman Valibeigi wrote: Hi I am waiting for the next release of derby wh

sunsetting support for Java 8

The current schedule for Java 9 calls for a GA date some time this autumn: http://mail.openjdk.java.net/pipermail/jdk9-dev/2017-June/005867.html. Shortly after that, I would expect that the Derby community would publish a new 10.14.1 feature release: https://wiki.apache.org/db-derby/DerbyTenFo

Re: sunsetting support for Java 8

ll be welcomed by people developing apps for Mac OSX, since jigsaw promises to reduce the size of those app bundles. Just my guess, though. Thanks, -Rick p. On 22 June 2017 at 04:15, Rick Hillegas <mailto:rick.hille...@gmail.com>> wrote: The current schedule for Java 9 calls for

Re: SYSCS_DIAG.ERROR_LOG_READER

Hi Peter, Thanks for reporting this defect. I have logged https://issues.apache.org/jira/browse/DERBY-6943 to track this issue. There I wondered what the correct behavior should be and I listed 3 options. If you have opinions about what's correct, then please add a comment to that issue. Th

Re: SYSCS_DIAG.TRANSACTION_TABLE stale records

Hi Peter, How are you disconnecting the sessions? I would expect to see 1 transaction for every active session, as the following script demonstrates: -- 1 active session = 1 open transaction connect 'jdbc:derby:memory:db;create=true' as conn1; select count(*) from syscs_diag.transaction_table;

Re: Write Cache - Data Corruption

On 7/14/17 6:21 PM, Shreyans Jain wrote: If we have a ups and we properly shutdown the OS, will then we have to disable write cache for the hard-disk in order to prevent data corruption. Are there any chances left for the data to be corrupted by power failure with write cache on? Regards, Shr

Re: Write Cache - Data Corruption

. See, for instance, https://en.wikipedia.org/wiki/Uninterruptible_power_supply. Hope this helps, -Rick On Sat, Jul 15, 2017 at 8:02 PM, Rick Hillegas mailto:rick.hille...@gmail.com>> wrote: On 7/14/17 6:21 PM, Shreyans Jain wrote: If we have a ups and we properly shutdown the

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

Hi Dmitry, In embedded mode, an application boots the Derby engine by making a JDBC connection. By itself, the embedded engine does not listen on any port for connection requests from other processes. So if your application uses the embedded driver, the engine won't respond to any other proces

derby is ready for JDK 9

For the past year and a half, we have been building and testing Derby against early access versions of JDK 9. JDK 9 appears to be in the final months of testing before GA. I have run the Derby regression tests against Derby release 10.13.1.1, using the JDK 9 build 181 platform. The tests run cl

Re: TIP: Run a derby network server with maven

Thanks for these links, Steinar. On 8/19/17 7:01 AM, Steinar Bang wrote: I needed to temporarily run a derby network server to examine behaviour of some of my SQL queries, that was different in derby (which I use for tests, both unit tests and integration tests), and PostgreSQL. What I did, was

Re: Java 9 support

On 10/11/17 9:39 PM, The Love of a Rainbow wrote: Project Jigsaw in Java 9 forbids the same package being provided by different modules. Derby falls into this pit by client and net containing the same shared packages, meaning both cannot be used in the same module: error: module com.example read

Re: read only db and luceneSupport

On 10/17/17 5:05 PM, Tulay Sri wrote: Hi, Within a java app I created a read-only database db.jar with lucenesupport and created a lucene index. I am now trying to use it to query within another java code as part of a large ETL job, However, when it comes to using the db to query lucene based

[ANNOUNCE] Apache Derby 10.14.1.0 released

The Apache Derby project is pleased to announce feature release 10.14.1.0. Apache Derby is a sub-project of the Apache DB project. Derby is a pure Java relational database engine which conforms to the ISO/ANSI SQL and JDBC standards. Derby aims to be easy for developers and end-users to work w

Re: read only db and luceneSupport

The stack trace has no line numbers, so I can't tell what is failing. Can you try your experiment with a debug version of Derby (e.g., db-derby-10.13.1.1-lib-debug.zip)? Thanks, -Rick On 10/18/17 10:34 AM, Tulay Sri wrote: 1. Query: SELECT * FROM TABLE( LUCENESUPPORT.LISTINDEXES() ) T 2. St

Re: Setting SSLContext for Derby client

Can you explain more about what you are trying to do and what is missing from the SSL/TLS support described in the Derby Security Manual: http://db.apache.org/derby/docs/10.14/security/index.html Thanks -Rick On 10/18/17 4:56 PM, Trejkaz wrote: Hi. We want to enforce SSL usage with Derby, bu

proposed high level module structure for Derby

My last comment on https://issues.apache.org/jira/browse/DERBY-6945 proposes how we could decompose Derby into Jigsaw-ready modules. Mostly, these correspond to the existing release jars. However, one additional module (and jar file) is proposed; it corresponds to the code currently shared acro

Re: Use cases for shutdown=true in embedded Derby

On 11/27/17 10:32 PM, Антон Крылов wrote: Hello, I was wondering when would one want to shut down an embedded Derby database using shutdown=true in recent Derby versions? Liquibase does use this, and this very part causes trouble both in Derby (https://issues.apache.org/jira/browse/DERBY-206

Re: "No suitable driver found" exception on rowset.execute, but result set fetching succeeds

Hi Amy, It's hard to tell what's going on without seeing the full stack trace. I'm afraid that I don't have a lot of experience with RowSets. The error message seems to indicate that the Derby embedded driver is not loaded into the RowSetFactory's class loader. I have a couple questions abou

Re: Derby Scheduler and FETCH FIRST question

On 1/24/18 4:45 AM, g.h...@aurenz.de wrote: Hello everyone, I'm using Apache Derby v10.14.1.0 and having some problems using the FETCH FIRST clauses. https://db.apache.org/derby/docs/10.14/ref/rrefsqljoffsetfetch.html I'm accessing the database using the Derby Embedded driver. I have a tab

Re: AW: Derby Scheduler and FETCH FIRST question

rland Interbase / Firebird, MySQL and especially with PostgreSQL. And PostgreSQL would have done a lot faster than this. By the way: PostgreSQL also has a more easy to use approach in aspect of analysis: https://www.postgresql.org/docs/9.6/static/using-explain.html Would be great of Derby woul

Re: AW: Derby Scheduler and FETCH FIRST question

have done a lot faster than this. By the way: PostgreSQL also has a more easy to use approach in aspect of analysis: https://www.postgresql.org/docs/9.6/static/using-explain.html Would be great of Derby would offer something similar. Regards, Gerrit *Von:*Rick Hillegas [mailto:rick.hille...@gmail

Re: Retrieving current username within table function

On 2/8/18 10:57 AM, Nigel Jones wrote: Newbie warning ... I'm trying to figure out how I could determine the current username when in a table function (in fact I'm writing some java code that plugs into someone else's table function ...) I was originally thinking of something like the snippe

Re: deadlock on select count(*) from tableName

Seems odd that a read-only query would grab exclusive, blocking locks. Is there other outstanding work in those transactions? On 3/29/18 2:42 AM, palo.liska wrote: Hi did someone saw deadlock during concurrent select count(*) from tableName? 09:15:41,959 [ERROR] o.h.e.j.s.SqlExceptionHelper:14

Re: Identity column and 40XL1 error

Can you share the derby.log for this problem? Thanks, -Rick On 3/29/18 1:45 AM, palo.liska wrote: Rick Hillegas-3 wrote Hi Abhi, Here is one more idea. I believe that you said that you are running an in-memory database. That means that you do not need to worry about leaking pre-allocated

<    4   5   6   7   8   9   10   11   >