RE: Out-of-memory errors

OutOfMemoryError: GC overhead limit exceeded happens when JVM spends way much garbage collecting. Could it be your heap is too small? One way to check if DateTimeFormat may be leaking memory is to run query without this function. -Original Message- From: John English Sent: Monday,

RE: Slow mount times

There is very easy way to check if you are going to run database recovery at boot time by looking into logs subfolder. If you gracefully shut down, there are only two log files. If there are more your database will perform roll forward recovery, in worst case applying all the log files. From:

Re: I don't find the JDBC driver class in derbyclient.jar

Hi, in default setup you do not need to use authentication at all. However if you do with APP user its default password is APP. This was for 10.14 and I guess the same applies to 10.15. Peter On Thu, 5 Mar 2020, 10:25 Richard Grin, wrote: > Thanks a lot Rick. I put these 3 files in the

Re: Avoid locking on DELETE

Hi Peter, Thanks. This procedure with disabling the autocommit is indeed simpler than I had before via "DELETE FROM mytable WHERE id IN (...)" but the delete itself takes longer (5-6 times) and I do not see differences with different batch sizes. I've also benchmarked this proce

Re: Avoid locking on DELETE

, continue (5.) In my case with slow disk this really performs better and should avoid your issue as well. Peter On Mon, 7 Oct 2019, 22:11 Peter, wrote: > Hi Peter, > > Thanks! I have implemented this and indeed the maximum delays are lower > but the time for a delete batch to comple

Re: Avoid locking on DELETE

Hi Peter, Thanks! I have implemented this and indeed the maximum delays are lower but the time for a delete batch to complete takes now longer (roughly 3-4 times; for batchSize=500, total deleted items around ~1). The problem is likely that I have VARCHAR for the ID column. If I increase

Re: Avoid locking on DELETE

ate stored procedure for this with two parameters (some_fixed_millis, batch_size). Your idea DELETE WHERE SELECT and limiting rows needs to be run for every DELETE step making unnecessary read I/O. On Mon, 7 Oct 2019 at 14:10, Peter wrote: > Hi Peter, > > Thanks a lot for the suggestio

Re: Avoid locking on DELETE

Hi Peter, Thanks a lot for the suggestion.This would be nice if it performs better. Is the idea to split one request into smaller parts or will "Select+Delete IDs" just perform better? And regarding the latter option - is this possible in one SQL request? So something like DELETE FR

Re: Avoid locking on DELETE

Peter, try this if it makes a difference: 1. Select entries to be deleted, note their primary keys. 2. Issue delete using keys to be deleted (1.) and use short transaction batches. On Sun, 6 Oct 2019, 01:33 Peter, wrote: > Hi, > > I have a table "mytable" with column

Avoid locking on DELETE

Derby Network Server: -Dderby.storage.pageSize=32768 Regards Peter

Re: [derby] searching within a blob

Alex, I think this may be a solution: https://db.apache.org/derby/docs/10.14/tools/rtoolsoptlucene.html On Mon, 30 Sep 2019 at 18:18, Alex O'Ree wrote: > I have a use case where i have string data stored in a blob and i want to > perform a query similar to > > select * from table where column1

Re: Derby DB Encryption

bootPassword. That’s what I found. > > Thanks for the help and pointers! It got me thinking :-) > > Regards, > Oskar > > On Jul 24, 2019, at 2:08 PM, Peter Ondruška > wrote: > > Well, you "boot" with bootPassword only once. After your database is > o

Re: Derby DB Encryption

kar Zinger wrote: > I already have authentication working fine. I would like to also have data > encryption. > > Can I have both authentication and data encryption in Derby? > > Sent from my iPhone > > On Jul 24, 2019, at 11:37 AM, Peter Ondruška > wrote: >

Re: Derby DB Encryption

Oskar, you mixed two distinct topics, encryption and authentication. You should also follow https://db.apache.org/derby/docs/10.14/security/cseccsecure42374.html. Peter On Wed, 24 Jul 2019 at 16:27, Oskar Z wrote: > Hello - hope that someone has experience with Derby encryption. > >

Re: any security how to guides for a hybrid derby setup?

Hello Alex, We are doing this: System.setProperty("javax.net.ssl.keyStore", config.getKeyStorePath()); System.setProperty("javax.net.ssl.keyStorePassword", config.getKeyStorePassword()); Kind Regards Peter Am 11.12.18 um 15:20 schrieb Alex O'Ree: > The derby security

Re: cannot make indexes on long varchar?

articular reason we can't do indexes on long varchar columns? > -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered with the commercial register administered by the Municipal Court in Prague, section C, file 141269. Registered office and postal address: kaibo, s.r.o., Kališnická 379

Re: Installing Derby

ain] > java.io.FileNotFoundException: derby.log (Access is denied) > *** > what have I forgotten to do ? > Bob M > > > > -- > Sent from: > http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html > -- Peter Ond

Re: attempting to migrate from postgres to derby

was an issue (in the beginning) and we had to do a lot of caching, and so the resulting main workload for derby is relative simple. (btw: We run postgres for a different workload and have made also good experience with it and nothing similar to what you reported.) Regards Peter Am 15.11.18 um 22

Re: attempting to migrate from postgres to derby

Hello Alex, May I ask why are you moving to Derby? What are your pain points with Postgres? Kind Regards Peter Am 14.11.18 um 22:22 schrieb Alex O'Ree: > Greetings. I'm looking for some kind of migration guide and for things > to watch out for when migration an application to derby. >

Re: Force TLSv1.2 or higher for the server

k.java.net/browse/JDK-8196584 and the older two are deprecated. Kind Regards Peter Am 09.07.2018 um 18:39 schrieb Bryan Pendleton: > There was a similar, but not identical, discussion around these topics > four years ago, when the code was changed to remove SSLv3 and SSLv2 > supp

Force TLSv1.2 or higher for the server

ble to add such a property or a different workaround to avoid older TLS versions? Regards Peter

Re: Very, very large .dat files

Thank for taking time to answer. Appreciated. You basically confirmed my understanding: I need to go for a DIU approach if I want table partitioning. On 05-Dec-17 17:30, Bryan Pendleton wrote: You are correct, Derby does not provide table partitioning features such as those provided by

Re: Very, very large .dat files

file, right?) Any suggestions? Any props that may control this? On 05-Dec-17 13:28, Peter Hansson wrote: We've seen .dat files  in seg0 directory grow to several hundreds of gigabytes. While everything works ok such a file becomes unmanageable from an OS point of view. Is there a way

Very, very large .dat files

We've seen .dat files  in seg0 directory grow to several hundreds of gigabytes. While everything works ok such a file becomes unmanageable from an OS point of view. Is there a way to control when Derby starts a new conglomerate?  ... so that there are more .dat files but each of them of less

Re: Incremental Online Backup

by which database can > be restored using that backup. > > Regards, > Shreyans Jain > -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered with the commercial register administered by the Municipal Court in Prague, section C, insert 141269. Registered office and postal address: kaib

Re: SYSCS_DIAG.TRANSACTION_TABLE stale records

and see if those reported by the > SYSCS_DIAG.TRANSACTION_TABLE are not in fact real XA transactions that have > not been finalized. > > > > *From:* Rick Hillegas [mailto:rick.hille...@gmail.com] > *Sent:* Tuesday, July 11, 2017 8:56 PM > *To:* derby-user@db.apache.org > *

Re: Derby Database Corruption Issues

gt; "Switch off the machine's write caching" . now the article is written in > 2013. Is it still application to derby database corruption or now it has no > effect. > > Regards, > Shreyans Jain > -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered

SYSCS_DIAG.TRANSACTION_TABLE stale records

EXT 79241843NULLNULLSystemTransactionIDLENULLNULL and one UserTransaction (as expected): XIDGLOBAL_XIDUSERNAMETYPESTATUSFIRST_INSTANTSQL_TEXT 79604720NULLAPPUserTransactionIDLENULLSELECT * FROM syscs_diag.transaction_table

Re: Page cache sizing

apache.org/derby/docs/10.13/ref/rrefproper81359.html) work >> with database that has multiple page sizes--tables with default 4096 bytes >> and tables with long/blob of 32768 byte pages? >> >> > Hi Peter, > > I'm not 100% sure how this works; I think you should run so

Page cache sizing

Dear all, how does derby.storage.pageCacheSize parameter ( https://db.apache.org/derby/docs/10.13/ref/rrefproper81359.html) work with database that has multiple page sizes--tables with default 4096 bytes and tables with long/blob of 32768 byte pages? Thanks, -- Peter Ondruška -- kaibo, s.r.o

SYSCS_DIAG.ERROR_LOG_READER

verything works fine and content of derby.log is read. -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered with the commercial register administered by the Municipal Court in Prague, section C, insert 141269. Registered office and postal address: kaibo, s.r.o., Kališnická 379/10, Prague 3, 130 00, Czech Republic. https://www.kaibo.eu

Re: sunsetting support for Java 8

m policy would be a great hardship for you. > > Thanks, > -Rick > > -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered with the commercial register administered by the Municipal Court in Prague, section C, insert 141269. Registered office and postal address: kaibo, s.r

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

Dear Rick, well, that is why it is strange because I am very certain I use correct username and password to connect and the data from database can be accessed. Yes, NATIVE credentials are stored in the database itself. There are no other errors or warnings besides this one. Peter On 29 May 2017

Connection authentication failure occurred. Reason: Invalid authentication..

/Glassfish with ClientXADataSource and therefore it is strange that I see mentions of Embedded in the trace. And there are no messages from Payara about failed authentications. Any ideas? :) -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered with the commercial register administered

Re: BACKUP.HISTORY file

archives at the Derby site but I have been > unable to locate any information that specifically addresses this issue. > > > > Thank you, > > > > -Eric > > > > JHU/APL > > > -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered wi

[SOLVED] Re: Alter table fails with Derby 10.10.2.0

Hi, found somewhere a hint to "SYSCS_UTIL.SYSCS_COMPRESS_TABLE", which I could use to fix my table. Regards P. Am 19.01.2017 um 06:49 schrieb Peter Nabbefeld: Hello, I'm using Derby 10.10.2.0 - (1582446). ALTER TABLE fails with following message (I've copied the Hibernate

Alter table fails with Derby 10.10.2.0

) [...] For the essage in German, the meaning is: In a base table the number of requested columns 28 differs from the maximum number of columns 29. It seems, the number of columns has been upgraded, but the new column has not been added - how can I repair that manually? Kind regards Peter

Re: Use Apache Derby Network Server with encrypted database

enz.de> wrote: > Hello Peter, > > hello George, > > > > thank you for your 2 mails. And sorry I didn't reply earlier. > > Yes, I also realized that there is no difference between the embedded and > the standalone version. > > The only exception is that you h

Re: Use Apache Derby Network Server with encrypted database

ml > > But it seems it only deals with an embedded Derby version. > > > > Regards, > > Gerrit > > > -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered with the commercial register administered by the Municipal Court in Prague, section C, insert 141269

Re: Derby ERROR XSDB6

nd to reset this figure, is restarting eclipse. I > imagine that's because DatabaseDevelopment is using a different JVM. > Is there a way to force closing the db? > > Thank you. > > -- Peter Ondruška

Re: XQuery or XSLT support in Derby

java:219) > at > com.sun.org.apache.xpath.internal.compiler.Lexer.tokenize(Lexer.java:100) > at > com.sun.org.apache.xpath.internal.compiler.XPathParser.initXPath(XPathParser.java:114) > at com.sun.org.apache.xpath.internal.XPath.(XPath.java:180) > at com.sun.org.apache.xpath.internal.XPath.(XPath.java:268) > at > com.sun.org.apache.xpath.internal.jaxp.XPathImpl.compile(XPathImpl.java:392) > ... 43 more > > > How can I avoid that? > > > > Thank you, > Greg > -- Peter Ondruška

Re: EmbeddedDriver and db.lck file

that another instance did already boot the database. Somehow the db.lck file is not released when I close the EntityManagerFactory. Any idea what's going on here? How can I force the release of the db.lck file in a ServletListener.contextDestroyed() method? With kind regards Thomas -- Peter

Re: Copying encypted DB?

, but this won't work unless the auto-generated columns are allocated with the same sequence numbers so that the foreign key references will match up. And in some case the keys are not sequential, due to deletions. Is there an easy way to do this? TIA, -- John English -- Peter Ondruška

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

derby DB.When I click on Jar file the derby also install on the system. Is it possible. Varun -- Peter Ondruška

Re: Urgent question about JIra issue DERBY-526

, but seems it is still in open state, can anyone tell me whether the issue is fixed now? And in which version if yes? Thanks so much! Lin -- Peter Ondruška

Re: Blob column behaviour, when we dont have data when having less data

in this kind of scenario ? Thanks Sekhar. -- View this message in context: http://apache-database.10148.n7.nabble.com/Blob-column-behaviour-when-we-dont-have-data-when-having-less-data-tp143363p143376.html Sent from the Apache Derby Users mailing list archive at Nabble.com. -- Peter

Re: Locks on crashed database

/ * This can be observed by having records in TRANSACTION_TABLE (and related in LOCK_TABLE) with state PREPARED:br / * SELECT * FROM SYSCS_DIAG.LOCK_TABLE;br / * SELECT * FROM SYSCS_DIAG.TRANSACTION_TABLE; * * @author Knut Anders Hatlen, Peter Ondruška (just slightly modified) * */ public class

Locks on crashed database

but it was removed for troubleshooting. Thanks -- Peter Ondruška

Re: No Powered By Derby Logo

By Derby” logo combination. Does one exist? Are there plans to create on in the near future? _ John I. Moore, Jr. SoftMoore Consulting -- Peter Ondruška

Re: Derby online backup with huge database

Sekhar. -- View this message in context: http://apache-database.10148.n7.nabble.com/Derby-online-backup-with-huge-database-tp143121.html Sent from the Apache Derby Users mailing list archive at Nabble.com. -- Peter Ondruška

Re: Another error to be explained

in context: http://apache-database.10148.n7.nabble.com/Another-error-to-be-explained-tp142334.html Sent from the Apache Derby Users mailing list archive at Nabble.com. -- Peter Ondruška

Re: Another error to be explained

-to-be-explained-tp142334p142338.html Sent from the Apache Derby Users mailing list archive at Nabble.com. -- Peter Ondruška

Re: Problem with Select statement

Hello, can you describe your table testtable please? On 9 Sep 2014, at 10:20, Kessler, Joerg joerg.kess...@sap.com wrote: Hi, I want to execute select statement on a table using a Java program and JDBC. The statement is actually not very difficult: SELECT MSG_NO, SEND_TO, CREATED_TIME,

Re: Difference

:-) Thanks. I considered 10.10.2.0 stable, actually for me an my use it is very stable.   Peter On Thursday, 31 July 2014, 19:31, Myrna van Lunteren m.v.lunte...@gmail.com wrote: Hi, 10.10.2.0 has all the *new* functionality of 10.9.1.0 and 10.10.1.0. Plus it has more bug fixes than

Difference

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

Re: When to shut down a database

Preview by Yahoo  and String limitations   Peter On Friday, 11 April 2014, 6:09, Chux chu...@gmail.com wrote: Awesome insights guys, thanks for all your help. BTW, I could not access the online documentation for some reason. Although I read somewhere that 64k is the maximum size you can allocate

Re: Corrupt database: ArrayIndexOutOfBoundsException on connect

Just a reminder to do backups and run the database with log archiving. Everything is built in Derby. I know for you it is too late for you :( Peter On 10 Mar 2014, at 17:20, Myrna van Lunteren m.v.lunte...@gmail.com wrote: Although Derby has transaction control and a recovery mechanism

Re: AW: DERBY_OPTS/DERBY_CMD_LINE_ARGS is there anywhere a list

I prefer not to touch anything in Derby installation as it's structure is almost perfect so that is my own script outside Derby. It is matter of preference and manageability if you set DERBY_OPTS in system/login/launch script. Peter On 27 Feb 2014, at 09:54, Kempff, Malte malte.kem

Re: DERBY_OPTS/DERBY_CMD_LINE_ARGS is there anywhere a list

=-Djava.security.policy=%DROPBOX%\config\derby.policy %DERBY_OPTS% set DERBY_OPTS=-Dderby.system.home=C:\TEMP %DERBY_OPTS% start Derby server startNetworkServer Peter On 26 Feb 2014, at 11:23, Kempff, Malte malte.kem...@de.equens.com wrote: Hi to all, I used to use Derby as embedded data base. Right

Re: Apache Derby Command Line?

C:\Java Server JRE\jdk1.7.0_51\bin\java.exe should be: C:\Java Server JRE\jdk1.7.0_51\bin\java.exe Peter On 22 Feb 2014, at 02:48, Turtles 3turt...@videotron.ca wrote: C:\Java Server JRE\jdk1.7.0_51\bin\java.exe

RE: data synchronization with no network

We have attempted this with a several different variations. We have not been able to make it work. Has anyone successfully synced data with a client by manually shipping logs? Peter Haynes Pariveda Solutions 24 East Greenway Plaza | Suite 1717 | Houston, Texas 77046 (M) 713.408.8072 | (F

Re: How to log queries in Apache Derby?

I do this: DERBY_OPTS=-Xms256m -Xmx256m -Dderby.storage.pageCacheSize=2048 -Dderby.system.home=/MQHA/db -Dderby.storage.tempDirectory=$TMPDIR -Dderby.infolog.append=true -Dderby.language.logQueryPlan=false -Dderby.language.logStatementText=false startNetworkServer Peter On 3 Feb 2014

Re: How know databases connected with Derby networkServer

Emory is cheap nowadays. Just run each database in separate JVM. If you are on Linux or AIX I would recommend IBM Java with class sharing.. Peter On 24 Jan 2014, at 11:32, AirDT cont...@solgt.fr wrote: Hello everyone, I run a NetworkServer that allows multiple users to connect

Re: Able to reconnect previously shutdown in-memory derby database

My guess is that similar to filesystem if you only shutdown Derby without JVM exit database is still there. Similar to filesystem where you need to remove database from filesystem. Peter On 9 Oct 2013, at 14:26, pelle.ullberg pelle.ullb...@gmail.com wrote: Hi, Could someone please

Re: Proper configuration for a very busy DB?

I mean transaction log, by default they are in log subdirectory of database, next to seg0 directory. If you can do batch insertions. Peter On 1 Oct 2013, at 17:53, Jerry Lampi j...@sdsusa.com wrote: Peter: Each client has one connection. It is used for the entire session (which can

Re: Proper configuration for a very busy DB?

Do you open new connection every time or do you have a pool? How often does Derby checkpoint/switch log file?   Peter - Original Message - From: Jerry Lampi j...@sdsusa.com To: Derby User Group derby-user@db.apache.org Cc: Sent: Monday, 30 September 2013, 21:28 Subject: Proper

Re: Is there some way to shut down a Derby database faster?

So if users need data after working with database give them consistent copy using backup http://db.apache.org/derby/docs/10.0/manuals/admin/hubprnt43.html#HDRSII-BUBBKUP-63476 Peter On 4. 7. 2013, at 23:17, Trejkaz trej...@trypticon.org wrote: On Fri, Jul 5, 2013 at 12:44 AM, Bryan Pendleton

Re: Can anyone help

Are you closing prepared statements and result sets On Dec 14, 2012 7:58 PM, DICKERSON, MICHAEL md2...@att.com wrote: I am posting a dump I got from an application that uses Derby and JBoss. Can anyone help with why it is running out of memory…or where to look? I am thinking it has something

Re: Problems with Online Backup SYSCS_BACKUP_DATABASE

hi, there should be in the backup destination as much disk space available as your database size without logs. Peter On 17. 8. 2012, at 13:06, Stefan R. elstefan...@gmail.com wrote: Hi, We're using Derby DB (Version 10.8.2.2) in a larger project. Our database size is now around 12GB

derby.jar Classpath

application uses its own class loader and therefore none of the above is true. I'm guessing that derby.jar uses the property java.class.path to find the path to its other components. So my question is, Is there a way to load derby.jar without explicitly declaring it on the classpath. Peter

Re: Speed up single INSERT INTO statement?

Consider batching inserts and use larger log file. On 9 May 2012 19:01, TXVanguard brett.den...@lmco.com wrote: I need to speed up a single INSERT statement in Derby. The statement has the form: INSERT INTO table (col1, col2) SELECT a, b FROM In my application, it take about 10

Re: Random DRDA Error on IBM J9 JVM

Apr 04 14:46:24 EDT 2012 : Apache Derby Network Server - 10.8.2.2 - (1181258) shutdown On Tue, Mar 20, 2012 at 8:22 AM, Brandon L. Duncan brandonl.dun...@gmail.com wrote: Thanks Peter and Myrna for the feedback. Myrna, those Wiki links were helpful; I did not even know they existed. I'm

Re: Random DRDA Error on IBM J9 JVM

- r9_20101028_17488ifx17 GC - 20101027_AA) JCL - 20110530_01 at that works, also SR9 FP3 work fine (this is on AIX). On Mon, Mar 19, 2012 at 6:18 PM, Brandon L. Duncan brandonl.dun...@gmail.com wrote: Thanks Peter. Do you remember if you upgraded to 10.8.2.2 or 10.8.1.2? We do have a test environment

Re: Random DRDA Error on IBM J9 JVM

I have seen the same problem and resolved by upgrading Derby to 10.8. There must be something strange in J9 and Derby coexistence. This happened very random. On Mon, Mar 19, 2012 at 4:55 PM, Brandon L. Duncan brandonl.dun...@gmail.com wrote: I was wondering if anyone came across this error

Re: AW: Does derby ned allways a rollback or commt?

I would extend your question: is there any difference in commit or rollback after single select statement? Dne 22.11.2011 12:45 malte.kem...@de.equens.com napsal(a): ** So what would be the best practice using a rollback or a commit when just reading a database? ** ** Malte

Re: OutOfMemoryException when executing 180,000 batches

Of course you get OOME if you use memory only database and your data size plus overheads exceeds heap. Dne 8.11.2011 23:44 Pavel Bortnovskiy pbortnovs...@jefferies.com napsal(a): Is it unusual that Derby (used in-memory only) seems to throw an out of memory exception when executing 180,000

Re: Setting Derby NetworkServer JVM size using NetworkServerControl

append: DERBY_OPTS=-Xms1g -Xmx1g to bin\derby_common.bat On Wed, Nov 9, 2011 at 5:39 PM, Hawley, Dan dan.haw...@lmco.com wrote: Hi, I have an urgent problem that I have not been able to solve by myself.  I am populating many derby databases with data in preparation for going live with a

Re: Derby secure by default

Rick, I’d vote for secure by default in v.11. Thanks On Mon, Sep 19, 2011 at 6:39 PM, Rick Hillegas rick.hille...@oracle.com wrote: The Derby developers are considering introducing a single master security property. Turning this property on will enable most Derby security mechanisms: 1)

Re: Opinions on new security feature requested

+1 for more restrictive permissions. Actually when I run Derby on Unix it runs under own user+group and database files are not accessible by others. On Fri, Sep 2, 2011 at 7:31 PM, Dag H. Wanvik dag.wan...@oracle.com wrote: Hi folks, we are always working to make Derby more secure; in this day

Re: nulls in prepared statement

You would only subclass PreparedStatement as public MyPreparedStatement extends PreparedStatement and override setString method. And in your code use replace PrepareStatement with MyPreparedStatement. On Thu, Jul 21, 2011 at 5:31 PM, Tomcat Programmer tcprogram...@yahoo.com wrote: Well may be

Re: nulls in prepared statement

()); Hi Peter, thanks for responding but I am aware of this as I indicated in my post. You realize how tedious this will be with any significant number of fields? What I am asking about is if there is an alternate solution. Thanks in advance, TC

Re: nulls in prepared statement

You must explicitly set value to null: if (cobj.getPartNo()==null) pstmt.setNull(1, java.sql.Types.VARCHAR); else pstmt.setString(1,cobj.getPartNo()); On Wed, Jul 20, 2011 at 4:42 AM, Tomcat Programmer tcprogram...@yahoo.com wrote: Hi Everyone, I've tried doing research on this on the web but

Re: How to unlock a table in derby

Rollback might work as well :) Dne 18.7.2011 15:57 Lahiru Gunathilake glah...@gmail.com napsal(a): I will try it, thank you Byan ! Lahiru On Fri, Jul 15, 2011 at 8:47 PM, Bryan Pendleton bpendleton.de...@gmail.com wrote: I execute query lock table table name in share mode but I cannot

Re: Does anyone want to run Derby 10.9 on JVM 1.4 or on CDC/FP 1.1?

Please drop 1.4 Dne 27.6.2011 16:05 Rick Hillegas rick.hille...@oracle.com napsal(a): The 1.4 JVM has not been supported as a free platform for some time (although I believe you can buy a support contract for 1.4 if you need to). Does anyone plan to run Derby 10.9 on this platform? Does anyone

Re: error executing multiple insert statements

Run this in ij. That is for running SQL scripts. Or execute each statement (without ;) separately. On Thu, Jun 16, 2011 at 8:03 PM, Lothar Krenzien lkrenz...@web.de wrote: Hello, I'd like to execute multiple insert statements over JDBC at once, but can't get it work ;( Here a small demo:

Re: performance issue on 64 bit JVM

Unless you need to address heap over 32bit JVM limits use 32bit JVM. Just my EUR .02 :-) 2011/6/3 Arnaud Masson amas...@gmail.com: 64-bit uses more memory, so if your Xmx is too small, the 64-bit version may have more GC overhead. You can increase Xmx or activate compressed-pointers to have

Add current_timestamp default to existing timestamp column

To whom it may concern, Although mentioned in the documentation, doesn't appear to work? Could you please give me correct syntax for this? Or add this to the Jira items? Thanks a lot for your help. Kind regards, Peter PS: I couldn't find any examples anywhere, only a web discussion where

Re: Inserting control characters in SQL

Have you tried \b ? Peter On Mar 11, 2011 4:41 PM, John English john.fore...@gmail.com wrote: I have a DDL schema which I am processing using IJ. I want to insert a row into a table containg a backspace character: CREATE TABLE foo (name VARCHAR(20), value VARCHAR(200)); INSERT INTO foo

Re: inserting missing values

You need to check using wasNull method whether the value is null. See jdbc javadocs for ResultSet class. On Dec 14, 2010 8:46 PM, Patrick Meyer meyer...@gmail.com wrote: What is the best way to handle missing values. For example, suppose I have an array that I want to insert into a table, like

Re: Hot backups

Yes,see docs. On Dec 3, 2010 4:23 PM, Clemens Wyss clemens...@mysign.ch wrote: Does Derby support hot backup(s)? Regards Clemens

Re: Hot backups

No prob. Was on mobile while replying to your msg. On Fri, Dec 3, 2010 at 6:03 PM, Clemens Wyss clemens...@mysign.ch wrote: RTFM - http://db.apache.org/derby/docs/dev/adminguide/derbyadmin.pdf sorry thx Von: Peter Ondruška [mailto:peter.ondru...@gmail.com] Gesendet: Freitag, 3. Dezember 2010

Re: Language of error message

to english, but don't know how to do that. Thanks in advance Thomas -- Peter

Re: Language of error message

Yeah,that's what I ment... just forgot user. On Nov 27, 2010 4:23 PM, Marco Ferretti marco.ferre...@gmail.com wrote: set locale from vm options? -Duser.language=language -Duser.region=region -- Marco (from iPhone) On Nov 27, 2010, at 3:50 PM, Thomas thomas.k.h...@t-online.de wrote: Hi,

Re: NFS and Derby

not work and probably should be clearer that data corruption could occur.  I will file an issue to beef up the language based on the conversation in this thread. http://db.apache.org/derby/docs/10.5/devguide/cdevdvlp40350.html -- Peter

Re: performance: Derby vs H2

Rayson, some/most of us are looking for best performance AND best stability/scalability/tools/etc. When I look for performance I usually go with Berkeley DB JE ;-) On Thu, Apr 22, 2010 at 7:14 PM, Rayson Ho raysonlo...@gmail.com wrote: On Thu, Apr 22, 2010 at 12:06 PM, bruehlicke

Re: performance: Derby vs H2

Not really. By stability I mean being happy Derby user since its Cloudscape ages.. On Thu, Apr 22, 2010 at 7:45 PM, Rayson Ho raysonlo...@gmail.com wrote: On Thu, Apr 22, 2010 at 12:24 PM, Peter Ondruška peter.ondru...@gmail.com wrote: Rayson, some/most of us are looking for best performance

Re: Derby Char Column Type Versus VarChar

I think Oracle Database and Derby behavior will be same. CHAR(size) will preallocate size*characters in database page/block whereas VARCHAR(size) will not. Maybe if you give us any hint what are you trying to do we could help better. Peter On Mon, Apr 5, 2010 at 3:41 PM, Mamatha Kodigehalli

SELECT .. ORDER BY .. DESC delivers wrong ordering

the column NAME_DE is selected. I cross-checked the behaviour with PostgreSQL, it delivered the results as I expected. Peter -- Peter Jodeleit Lead Developer www.e-Spirit.com -- Folgen Sie uns auf Twitter: www.twitter.com/espirit_news

Re: Case Sensitivity

select Id as id, Code as code, TypeStr as typeStr from MyTable On Wed, Mar 24, 2010 at 10:30 PM, Pavel Bortnovskiy pbortnovs...@jefferies.com wrote: Hello, all: when executing a statement, such as:                

Re: Case Sensitivity

Not that I know, this is by SQL standard. On Wed, Mar 24, 2010 at 10:43 PM, Pavel Bortnovskiy pbortnovs...@jefferies.com wrote: Thank you, Peter, for your prompt response. Is enclosing them in quotes the only way to do so? Is there any setting which can be applied to Derby (or a -Define

  1   2   >