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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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

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: 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

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: 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: 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: 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: 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: 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: 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: 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: 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/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: 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: 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: 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: 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: 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

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: 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: 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

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: 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

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'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: 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: 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: 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: 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: 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: 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: 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/16/14 8:16 PM, Bob M wrote: I have a java program which uses derby in embedded mode.. Everything was working fine until my laptop had a meltdown and I have had to go back to factory settings and reinstall software etc. Everthing ( Derby database, tables etc.) is setup a

Re: Question ad JDBC driver, maybe DriverManager and derby ...

On 9/12/14 7:29 AM, Rony G. Flatscher (Apache) wrote: On 12.09.2014 15:29, Rick Hillegas wrote: On 9/12/14 3:37 AM, Rony G. Flatscher (Apache) wrote: Hi there, tried to find this information on the Internet, but also in the derby wiki, but was not successful so far, hence posting this

Re: Improving performance of encrypted databases by increasing page cache

On 9/8/14 10:15 AM, Raffaele Sgarro wrote: Database encryption turned out to be the performance bottleneck of my application. Running the same queries on the same data gives very different figures when the database is encrypted. Since I must keep the data encrypted on disk, I thought I could av

Re: Question ad JDBC driver, maybe DriverManager and derby ...

On 9/12/14 3:37 AM, Rony G. Flatscher (Apache) wrote: Hi there, tried to find this information on the Internet, but also in the derby wiki, but was not successful so far, hence posting this question here where hopefully those in the know can help out. Using derby from Oracle's JDK 7 distribu

Re: NPE from InternalTriggerExecutionContext.cleanup()

On 8/29/14 8:17 AM, Tim Dudgeon wrote: Using Derby 10.10.1.1 I'm seeing strange behaviour when doing a series of inserts that have triggers associated. About 2000 rows get inserted fine, then it blows up completely. The derby.log file contains stuff like this: Database Class Loader started - d

[ANNOUNCE] Apache Derby 10.11.1.1 released

The Apache Derby project is pleased to announce feature release 10.11.1.1. Apache Derby is a subproject 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 wi

Re: How to get Derby folder size from remote Server?

On 8/24/14 8:14 PM, Myrna van Lunteren wrote: This message was stuck in moderation also; my attempt to moderate it through failed. --- From: Nguyen Hai Dong mailto:dong...@yahoo.com>> To: derby-user@db.apache.org Cc: Date: Mon, 21 Jul 2014 00:26:59

Re: Feedback on documentation "Getting started with Java DB"

On 8/24/14 8:10 PM, Myrna van Lunteren wrote: another lost moderated message - from July 21 -- From: "Mathias Trapp" mailto:mathias.tr...@gmx.de>> To: mailto:derby-user@db.apache.org>> Cc: Date: Mon, 21 Jul 2014 07:12:15 +0200 Subject: Feedback on documentation "Getting started wi

I can not get output parameter values from procedure, was: missed moderated message

The following code works fine on 10.10.2.0 for me: import java.sql.*; import java.util.*; public class zz { public static voidmain( String... args ) throws Exception { Connection conn = DriverManager.getConnection( "jdbc:derby:memory:db;create=true" ); conn.prep

Re: Difference

On 7/31/14 4:07 AM, Peter Ondruška wrote: Dear all, what is the difference between version 10.10.2.0 and 10.8.3.0? Or why is there 10.8.3.0 along with 10.10.2.0? Thanks Peter The "Latest Official Releases" tend to be the latest releases produced on the 2 most active release branches. Once we

Re: Hellow, I have some problem in customize security policy with derby (modified)

tor.startSystemModule(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.runWithState(Unknown Source) at org.apache.derby.impl.services.monitor.FileMonitor.(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.startMonitor(Unknown Source)

Re: Hellow, I have some problem in customize security policy with derby (modified)

Could you attach the security policy you are using as well as the derby.log file which shows the complete stack trace of the security exception? Thanks, -Rick On 7/28/14 10:03 PM, 정용환 wrote: Hellow, I am derby user in korea. I have a problem while I try to replication. I success to re

Re: Prefabricated database with specific properties and hidden structure.‏

Hi Vasilis, Derby has many security mechanisms which may be relevant. However, I don't see how they could be combined to satisfy every constraint of your problem. The relevant mechanisms include: 1) Fine-grained SQL authorization. 2) Coarse-grained connection access modes. 3) Definer's righ

Re: java.security.AccessControlException: access denied ("java.lang.RuntimePermission" "getClassLoader")

On 7/23/14 1:08 PM, spykee wrote: Hi Rick, Thank you for the tips. My problem was solved ( I used the fastest solution, -noSecurityManager). Sadly to say that Netbeans does not allow me to pass arguments for the Database and I have to use the console, and beside this, I used Squirrel to connect

Re: java.security.AccessControlException: access denied ("java.lang.RuntimePermission" "getClassLoader")

Hi George, Some responses inline... On 7/22/14 12:21 PM, spykee wrote: Hi Rick, I tried to start it from the console& Netbeans, but I encountered the same errors ( I downloaded the latest Apache Derby, *10.10.2.0* - I'm using* Windows 8.1* ). What I did was : 1. Go on Apache Website and dow

Re: java.security.AccessControlException: access denied ("java.lang.RuntimePermission" "getClassLoader")

Hi George, I don't see this problem with release 10.10.2.0 when I run the network server this way... java org.apache.derby.drda.NetworkServerControl start -p 8246 ...and run the following script... connect 'jdbc:derby://localhost:8246/memory:db;create=true'; call sqlj.install_jar( 'helloWor

Re: AW: Problems with import of CSV to Table

On 6/24/14 8:45 AM, Kempff, Malte wrote: I found my problem now, it was a not existing file for input, I had overseen in the error report. FEHLER XIE04: Nicht gefundene Datendatei: memorecords.dat But I have also another question. When I tried to give nulls in the import export statement us

Re: trigger with cascade delete problem

On 6/16/14 1:07 AM, Tim Dudgeon wrote: On 13/06/2014 13:59, Rick Hillegas wrote: Maybe you can share a simplified problem which shows why this aggregation is so tricky. Thanks, -Rick Hi Rick Thanks for your patience! I've tried to create a minimal version that describes the pr

Re: trigger with cascade delete problem

Hi Tim, I still don't think I understand what's not working. Here's my crude understanding: 1) You have 3 tables: MAIN - This contains the information to be aggregated. GROUPING - This contains facts needed to group the information in MAIN AGGREGATES - This contains a pre-computed, grouped

Re: trigger with cascade delete problem

On 6/12/14 5:33 AM, Tim Dudgeon wrote: OK, so here's a simplified example. Didn't want to raise a JIRA as I'm really not sure this is a bug. Tim drop table MAIN; drop table DELETIONS; drop table CHANGED; create table MAIN ( MAIN_ID INT generated always as identity, GROUPING_ID INT,

Re: trigger with cascade delete problem

On 6/11/14 2:40 AM, Tim Dudgeon wrote: I've encountered a tricky problem that I can't see a solution to at present. Let me describe. I have 3 tables: MAIN - the main data table with results in. GROUPING - a table that is related to MAIN, with MAIM having a FK constraint to GROUPING AGGREGATES

Re: CREATE TABLE lexical error

On 4/19/14 8:18 AM, Patrick Meyer wrote: Thanks John. Yes, I was cutting and pasting from Notepad, but I was doing that for all four lines. I don't understand why it worked for some lines but not others. Nevertheless, the cutting and pasting is not my real problem. I created these four sta

Re: Best way to have a DB browser in your destop app

On 4/18/14 12:08 AM, Chux wrote: Hello guys, I have a desktop app using Java FX and so I have Derby as embedded DB. These builds I deploy to my clients. I need however a little tool to somehow access the embedded database for viewing, and maybe some on-the-fly modifications. When the FX app is

Re: --DERBY-PROPERTIES throws error

ceived this e-mail in error and that any review, use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete this email. On Apr 17, 2014, at 10:14 AM, Rick H

Re: --DERBY-PROPERTIES throws error

Hi Frank, I am unable to reproduce the problem you are seeing when I run the following script using Derby 10.10.1.1: connect 'jdbc:derby:memory:db;create=true'; create table attachment( guid int, file_name varchar( 10 ) ); create index ATTACHMENT_LINKNAMES_INDEX on attachment( guid, file_name

Re: When to shut down a database

would like to know what the limit is. variable clob(64 K) Thanks, Chux On Thu, Apr 10, 2014 at 5:32 AM, Dag H. Wanvik <mailto:dag.wan...@oracle.com>> wrote: On 09. april 2014 17:51, Rick Hillegas wrote: On 4/8/14 2:00 AM, Chux wrote: Hey Dag,

Re: When to shut down a database

On 4/8/14 2:00 AM, Chux wrote: Hey Dag, Thanks for your insight. I'm using this as an embedded DB in a Java FX desktop application. This is a dumb question but would you recommend shutting down the database ever after a transaction? Like after you create a record then you shut it down after

Re: Derby replication system - Need help

Hi George, Sounds like you're working on an interesting problem. First a general comment, then some detailed advice inline. I'm not sure where you are in your design right now. At one point it sounded as though you were going to collect changes via triggers, which would call stored procedure

Re: Turning on SQL authorization results in loss of table's ownership and permissions

Hi Wojciech, Some comments inline... On 3/13/14 12:50 PM, Wojciech Barej wrote: Hello Rick, Thank you for replying to my issue. It drives me crazy. I have done what you asked of me. Results: 1) SCHEMANAMEAUTHORIZATIONID APPAPP NULLIDAPP SAAPP SQLJAPP SYSAPP SYSCATAPP SYSCS_DIAGAPP SYSCS_U

Re: Turning on SQL authorization results in loss of table's ownership and permissions

Hi Wojciech, I am not able to reproduce your results. I am including a script which tries to capture your experiment. This script works for me both on the development trunk and on 10.9.1.0. I have a couple questions: 1) Does this script work for you? 2) What is the output of the following q

Re: Unnecessary increment of sequence

On 1/3/14 4:49 AM, Tim Dudgeon wrote: I'm trying to use a sequence to generate a value where one is not supplied, but I'm not able to only increment the sequence when its needed. This is actually going on in a trigger, but to simplify matters here is an example that illustrates the problem: V

Re: Apache Derby Command Line?

On 2/21/14 5:48 PM, Turtles wrote: I have java defined already the full command line would look like: C:\Java Server JRE\jdk1.7.0_51\bin\java.exe -jar derby.jar %DERBY_OPTS% -classpath "%DERBY_RUNPATH%" org.apache.derby.drda.NetworkServerControl start I see that you are using 7u51. Are you seein

Re: Number of connection to an embedded derby database

On 2/18/14 9:04 AM, Rohit Jhunjhunwala wrote: Hi, I am using an embedded derby database (Apache Derby 10.8.1.2) in my java desktop application. I would like to know that is there any way to monitor the number of active connections from my desktop application to the derby database. I understa

Re: adding a record to a table

On 2/17/14 8:45 PM, Bob M wrote: Hi guys (John and Rick) Thank you for your considerations (even though they are a bit above my level of comprehension) I have added a constraint a follows:- CONSTRAINT tablekey_pk PRIMARY KEY(Trading Date, Trading_Time) however, lets step back a bita

Re: adding a record to a table

On 2/17/14 2:03 AM, John English wrote: On 17/02/2014 11:29, Bob M wrote: Hi John I am having difficulty following your latest message.sorry :( I don't understand where to give constraints names? Is it when I set up the table? Yes, replace PRIMARY KEY(x) with CONSTRAINT c PRIMARY KEY

Re: ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.

On 2/13/14 11:55 AM, Derek Lewis wrote: Hello, I'm struggling to write upgrade and rollback SQL for a CHAR(16) FOR BIT DATA column. It's currently 16-bytes long, but I'd like to migrate it to a BLOB since I'll need to put more data in it soon. I'm using liquibase for the migration. Upgradi

Re: How to log queries in Apache Derby?

Hi Paul, Some comments inline... On 2/1/14 12:14 PM, Paul Linehan wrote: Hi all, I am trying to log queries to my Apache Derby server. My $DERBY_HOME is as follows - Ubuntu Linux 64bit - Java jdk1.7.0_45. Can access my database through Squirrel and ij. ==

Re: How know databases connected with Derby networkServer

On 1/24/14 2:32 AM, AirDT wrote: Hello everyone, I run a NetworkServer that allows multiple users to connect to multiple Derby database. How do I know databases connected at a given moment ? In order to : - Have knowledge of potential users connected to each connected dataBase - Shutdown these d

Re: Migrating from MySQL to Apache - having difficulty with Timestamp.

On 1/23/14 11:41 AM, Paul Linehan wrote: -00-00 00:00:00' Hi Paul, I see that the Reference Manual does not state that the year, month, and day fields of the timestamp must be positive integers. The following script shows this behavior: connect 'jdbc:derby:memory:db;create=true'; creat

Re: Network Server Access Permissions and Java 1.7.0_51

On 1/22/14 4:18 AM, John I. Moore, Jr. wrote: -Djava.security.manager -Djava.security.policy=C:\Java\db-derby\1010_server.policy Hi John, I am able to reproduce the results you are seeing. I have updated the 1010_server.policy attached to https://issues.apache.org/jira/browse/DERBY-6438. The

Re: Creating tables - migrating from MySQL.

On 1/21/14 11:39 AM, Paul Linehan wrote: 2014/1/21 Rick Hillegas: Hi Rick, and thanks for your input. You might want to take a look at the optional foreignViews tool, which can be useful for data migration projects like yours: http://db.apache.org/derby/docs/10.10/tools

Re: Creating tables - migrating from MySQL.

On 1/21/14 7:07 AM, Paul Linehan wrote: Hi Bryan, I'm trying to migrate a system (72 tables) from MySQL to Apache. Have you considered using ddlutils: http://db.apache.org/ddlutils/ Yeah, looks interesting for when I come to settle down and write this sort of thing, but what I'm trying to d

Re: read from a Derby db with only "SEQ0" forlder and "service.properties" file

On 1/17/14 8:26 AM, Paolo Forte wrote: Hi, I’m Paolo Forte,sorry for my bad English; I’m not a developer but there is an application software in my farm that use Derby Db; The pc is crashed but I have a copy of “seq0” folder and "service.properties" file; The db under application softwar

Re: Network Server Access Permissions and Java 1.7.0_51

On 1/17/14 7:23 AM, John I. Moore, Jr. wrote: Java version 1.7.0_51 (latest version) causes the following error when trying to start the network server. I can see from the issue tracker that there is a fix to be added that should correct this problem in the next release, but is there an easy

Re: Multiple Derby Network Server instances on a same computer

Hi AirDT, On 1/17/14 7:41 AM, AirDT wrote: Hi 1 - Is it possible to run multiple Derby Network Server instances on a same computer? (each one with a different port and a different system derby directory) ? Yes, you can run multiple servers on the same machine. The system directory is a JVM-wid

Re: Derby in production environment

Hi AirDT, The following wiki page lists products which use or support Derby. This is a community-maintained page so it's probably stale. In addition, it only cites the tiny fraction of products which bothered to identify themselves here: http://wiki.apache.org/db-derby/UsesOfDerby Hope this

Re: Exporting table records

On 1/13/14 12:56 AM, Dyre Tjeldvoll wrote: On 01/11/2014 08:20 PM, Bob M wrote: Hi I have a derby database with one table which I access using Netbeans What is an easist way for me to export the contents of the table ? Did you check out https://builds.apache.org/job/Derby-docs/lastSuccessfu

Re: Using ASTParser and TreeWalker for parsing SQL query

Hi Venu, Glad to hear that this technique is working for you. A couple general comments: A) If you need code added to the Derby engine, the best approach would be to file a JIRA and attach a patch file. That makes it easier for committers to evaluate your improvements and track changes to th

Re: Biggest Apache Derby database(s).

On 1/9/14 8:49 AM, Paul Linehan wrote: Hi Rick, I would like to know (with references/URLs preferably) what are the kinds of sizes that large Derby installs stretch to? Would it go to 1TB? More? Less? At Sun Microsystems Straight from the horse's mouth no less! :) we ran a stress test on

Re: Biggest Apache Derby database(s).

On 1/8/14 10:33 PM, Paul Linehan wrote: Hi all, I would like to know (with references/URLs preferably) what are the kinds of sizes that large Derby installs stretch to? Would it go to 1TB? More? Less? Thanks in advance for any info, pointers and esp. references and URLs. Rgs, Paul... Hi

Re: varargs functions: primitive or Object type?

On 1/6/14 6:09 AM, Rick Hillegas wrote: On 1/6/14 4:47 AM, Tim Dudgeon wrote: I'm trying to write a function that performs aggregation and I'm not clear on how to handle the varargs part. Lets assume I was wanting to write a function that does averaging, and handles null values corre

Re: varargs functions: primitive or Object type?

On 1/6/14 4:47 AM, Tim Dudgeon wrote: I'm trying to write a function that performs aggregation and I'm not clear on how to handle the varargs part. Lets assume I was wanting to write a function that does averaging, and handles null values correctly. I'm defining my function like this: CREATE F

Re: Unnecessary increment of sequence

On 1/3/14 4:49 AM, Tim Dudgeon wrote: VALUES SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE('APP', 'SEQ_CPD_CODE'); VALUES COALESCE(99, NEXT VALUE FOR seq_cpd_code); VALUES SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE('APP', 'SEQ_CPD_CODE'); Hi Tim, You could write a function to issue the "next value for" only when n

Re: Database Table Null Pointer Exception

On 12/17/13 4:01 AM, Knut Anders Hatlen wrote: irajon writes: ... You might want to take a look at the ForeignTableVTI table function described in https://issues.apache.org/jira/browse/DERBY-4962, which helps migrating data between two databases. (Although it won't help with working around th

Re: Derby logs are not getting printed

Hi Lasantha, You might try setting the properties as JVM properties on the boot command line. Maybe your properties file is not being found. Hope this helps, -Rick On 12/11/13 5:59 PM, nglasantha wrote: Hi Bryan, Thanks for your reply. I have configured derby home by giving JVM parameter.

Re: Retrieving constraint columns from system tables

Hi Bennie, You may be able to get the information you need by joining the table functions which are loaded by the databaseMetaData tool introduced in Derby version 10.10.1: http://db.apache.org/derby/docs/10.10/tools/rtoolsoptdbmetadata.html I have included a script which shows how to get so

<    1   2   3   4   5   6   7   8   9   10   >