Re: NULL checking in Derby

2007-10-30 Thread Peter Ondruška
DELETE FROM quiz_options_info WHERE option_text IS NULL On 27.10.2007, at 4:36, Soumen Saha wrote: DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN ('',null);

Re: Just in memory ?

2008-09-16 Thread Peter Ondruška
Dear Antonio, you do not mention what OS you run your Derby on but in case you are on Unix they provide workaround to your requested feature already. For example by default on all Solaris you have /tmp mounted as tmpfs in swap which is in memory. Hopefully this helps to you or others. Peter On

Re: Perfroamnce of IN ( ... list ... ) statements

2008-10-05 Thread Peter Ondruška
What Derby version is it?How does it perform if you re-create index on foo_id column? p. On Sun, Oct 5, 2008 at 10:07 PM, Tim Dudgeon [EMAIL PROTECTED] wrote: If I run a statement like this is Derby: SELECT COL1, COL2 FROM FOO WHERE FOO_ID IN ( 1, 31, . 4567) it seems unexpectedly slow.

Re: performance issue

2008-10-16 Thread Peter Ondruška
Hello, speed depends also on JVM. What version and JVM parameters are you using? On 10/16/08, Jonas Ahlinder [EMAIL PROTECTED] wrote: Hi. We are developing a function to store session information, for use in a HA environment. However we are not reaching the throughput we want. Since its

Re: performance issue

2008-10-16 Thread Peter Ondruška
the actual work begins, these are empty rows that we do updates on to delete/insert/update information in the rows. This was to be able to stop the database growth, something that obviously didnt work. From: Peter Ondruška [EMAIL PROTECTED] Sent: Thursday

Re: Most efficient way to get max row id?

2008-10-19 Thread Peter Ondruška
You want to use identity: Defining an identity columnhttp://db.apache.org/derby/docs/10.4/devguide/cdevtricks21248.html On Sun, Oct 19, 2008 at 10:52 PM, Amir Michail [EMAIL PROTECTED] wrote: Hi, I was wondering what is the most efficient way to get the max automatically generated row id.

Re: getting first k rows from a query that satisfy some additional condition

2008-10-27 Thread Peter Ondruška
Please, post the query you are running.There are queries where setMaxRows will not be faster, for example if you do GROUP BY or ORDER BY. On Mon, Oct 27, 2008 at 22:51, Amir Michail [EMAIL PROTECTED] wrote: On Mon, Oct 27, 2008 at 5:45 PM, Daniel Noll [EMAIL PROTECTED] wrote: Amir Michail

Re: getting first k rows from a query that satisfy some additional condition

2008-10-27 Thread Peter Ondruška
Well, in that case database engine has to read all relevant rows, then sort and only after that it can display the first row(s). On Mon, Oct 27, 2008 at 23:02, Amir Michail [EMAIL PROTECTED] wrote: On Mon, Oct 27, 2008 at 5:59 PM, Peter Ondruška [EMAIL PROTECTED] wrote: Please, post

Re: getting first k rows from a query that satisfy some additional condition

2008-10-27 Thread Peter Ondruška
Post the query and table and index DDL. On Mon, Oct 27, 2008 at 23:10, Amir Michail [EMAIL PROTECTED] wrote: On Mon, Oct 27, 2008 at 6:07 PM, Peter Ondruška [EMAIL PROTECTED] wrote: Well, in that case database engine has to read all relevant rows, then sort and only after that it can

Re: resultSet.next very slow

2008-11-09 Thread Peter Ondruška
Dear Jim, what Derby version are you running? Have you tried PreparedStatement instead of Statement? Peter 2008/11/9, James Crow [EMAIL PROTECTED]: I have used Derby for about four months but I am fairly new. I have searched both the archive and the docmentation with no luck. The problem is

Re: faster inserts in big tables

2008-11-25 Thread Peter Ondruška
Go with latest Derby, if you load data from externat file use bulk import. Using large log file may help. 2008/11/25, [EMAIL PROTECTED] [EMAIL PROTECTED]: I have 10's of thousands of rows to add to a table, possibly 100's of thousands, and I'm wondering if there's anything else I can do to

Re: Off topic? Small business firewall candidates

2008-12-28 Thread Peter Ondruška
:-) I must say you will hear lot of advises to go UNIX or Linux or whatever different from Windows :-) I have heard there is something like iptables for Windows, google-around this topic. On Mon, Dec 29, 2008 at 00:37, Damian Carey jami...@gmail.com wrote: Hi all, Sorry if this is too off topic

Re: inserts slowing down after 2.5m rows

2009-02-27 Thread Peter Ondruška
Could be checkpoint.. BTW to speed up bulk load you may want to use large log files located separately from data disks. 2009/2/27, Brian Peterson dianeay...@verizon.net: I have a big table that gets a lot of inserts. Rows are inserted 10k at a time with a table function. At around 2.5 million

Re: How to read blobs?

2009-03-05 Thread Peter Ondruška
Hi, just add -Duser.language=en to java startup options. 2009/3/5, epdv peter.nabbef...@gmx.de: Sorry, only German language - Win, no lang=C available :( Kind regards Peter org.apache.derby.client.am.SqlException: Der für diesen CLOB/BLOB angegebene Locator ist ungültig Caused:

Re: Bug in Derby 10.5.1.1 or misuse ?

2009-05-25 Thread Peter Ondruška
Pendelton suggested filling a bug query. If I have no clue what happens this evening, I' ll do it. Peter Ondruška wrote: Can we see how you set parameters for this prepared statement? 2009/5/25, Gurvan Le Guernic glegu...@gmail.com: Hi, I have a java.lang.NullPointerException when

Re: Bug in Derby 10.5.1.1 or misuse ?

2009-05-25 Thread Peter Ondruška
). SELECT method FROM methodParameters AS mp INNER JOIN types ON mp.parameter = types.id GROUP BY method HAVING COUNT(method) = ? Peter Ondruška wrote: Would you please try if there is any difference if you remove name IN (?). 2009/5/25, Gurvan Le Guernic glegu...@gmail.com

Re: Multiple instances of an application using same embedded database?

2009-06-05 Thread Peter Ondruška
Have a look at the archives of this list. It has been discussed already that you can use server mode similarly to embedded. Your application may try first use existing database as client and if fails to connect it may start server. Actually your second application instance would benefit from

Re: Hibernate + Derby - Unable to determine stream header for hibernate type 'text'

2009-06-19 Thread Peter Ondruška
Dear Kristian, Regarding your remark about effectiveness of very small CLOB vs VARCHAR should I just use VARCHAR to store 100 to 2000 character data instead of CLOB? I do not want to index this column and storage size and access speed (read only) are important. Thanks, Peter 2009/6/19,

Re: Error 42Y55

2009-07-04 Thread Peter Ondruška
Perhaps you want to use: drop table tableName On Sat, Jul 4, 2009 at 8:10 AM, sridhar devatha devatha.srid...@gmail.comwrote: Hi, I am getting the ij drop table tableName; ERROR 42Y55: 'DROP TABLE' cannot be performed on 'tableName' because it does not exist. ij exit But, the table

Re: How would you implement a record-level versioning system with Derby and Java?

2009-07-09 Thread Peter Ondruška
Actually I would store the history values outside the main table for performance and storage overhead reasons (history table may have additional columns, e.g. When-who-etc for auditing information). Peter 2009/7/9, Donald McLean dmclea...@gmail.com: On Thu, Jul 9, 2009 at 9:03 AM, Alessandro

Re: How would you implement a record-level versioning system with Derby and Java?

2009-07-09 Thread Peter Ondruška
I would recommend also looking at some data warehousing articles as versioning is related to that. Though I do not have any concrete to recommend :-(. Peter 2009/7/9, Alessandro Bottoni alexbott...@yahoo.it: Donald McLean ha scritto: Actually, this is a question that I have previously

Re: Pooling

2009-09-27 Thread Peter Ondruška
Yes, Derby does not provide connection pool, pick your favourite (I can confirm c3p0 works very well for me). Peter On Sun, Sep 27, 2009 at 11:56 PM, Christopher Giblin c...@zurich.ibm.comwrote: Hi, Just to be sure - Derby does not directly support connection pooling, correct? Rather, One

Re: Abandoning Derby - thank you all for your support

2009-09-30 Thread Peter Ondruška
TK, did you work on the issues with Sun Support? Or did you just rely on free resources on mailing list? Thanks. Peter On Wed, Sep 30, 2009 at 3:51 PM, T K sanokist...@yahoo.com wrote: Unfortunately, because of the unexpected growth of some tables with dead rows - due in part to unresolved

Re: unsubscribe

2009-10-09 Thread Peter Ondruška
Dear Stavros, you seem to be using Gmail, so be so kind and click on show details link in any message received from this mailing list and click again for unsubscribe. Thanks! Peter PS: OMG is it that hard to unsubscribe?! I though it is more difficult to subscribe... Do not respond, just my

Re: AW: AW: AW: OOM with millions of weakly-referenced Derby objects

2009-11-27 Thread Peter Ondruška
I develop on Windows and deploy to AIX 5.3 using Java 6 (_17 on Windows) and SR4 http://www.ibm.com/developerworks/java/jdk/aix/j664/Java6_64.fixinfo.html and never encountered anything unusual. On Fri, Nov 27, 2009 at 4:30 PM, malte.kem...@de.equens.com wrote: Hi Dag, Thanks for your effort.

Re: Derby as an in-memory JEE datasource

2010-01-07 Thread Peter Ondruška
Any errors? On Thu, Jan 7, 2010 at 5:59 PM, Marcin Kwapisz mkwap...@zsk.p.lodz.pl wrote: Hi, is it possible to use Derby as an in-memory datasource on Glassfish v3 application server? I tried but with no luck. Regards -- Marcin  Kwapisz

Re: Derby as an in-memory JEE datasource

2010-01-08 Thread Peter Ondruška
I tested connection pool with these properties: DatabaseName=memory:Test;create=true User=APP SecurityMechanism=4 RetrieveMessageText=true Password=APP TraceFileAppend=false TraceLevel=-1 ServerName=localhost PortNumber=1527 Ssl=off LoginTimeout=0 Do not have any applications using database, but

Re: Improving data insert performance

2010-01-13 Thread Peter Ondruška
Also try using larger log files (10+MB) and if you rarely change data you load (which I guess is your case) you may want to use pageReservedSpace=0 and large pageSize (32kb?) On Wed, Jan 13, 2010 at 5:01 PM, Nathan Boy nathan@gmail.com wrote: Hello,   I have an embedded database application

Re: Java DB open for business under new management

2010-02-06 Thread Peter Ondruška
Nice history: Cloudscape, then acquired by Informix, then IBM, opensourced, Sun, now Oracle :-)) On Thu, Feb 4, 2010 at 6:06 PM, Rick Hillegas richard.hille...@sun.com wrote: Hi everyone, There seem to be a lot of rumors flying around now that Sun is a wholly owned subsidiary of Oracle. I

Re: OutOfMemoryErrors on group by select

2010-02-08 Thread Peter Ondruška
What Derby version is this? Do you have an index on groupCol? On Mon, Feb 8, 2010 at 3:11 PM, Ronald Rudy ronchal...@gmail.com wrote: I've gotten to the point where I seem to be able to frequently induce OutOfMemoryErrors when executing a statement like this one: SELECT groupCol, count(*)

Re: OutOfMemoryErrors on group by select

2010-02-08 Thread Peter Ondruška
column that is indexed to see if there's any memory benefits..   The table isn't optimized for the below statement because in production it will never be executed like that, I'm just trying to monitor some counts while the app is running.. On Feb 8, 2010, at 9:21:29 AM, Peter Ondruška wrote

Re: refresh JSP webpage when Derby DB is changed

2010-02-12 Thread Peter Ondruška
Well, websockets will not work if your clients come from corporationsas they usually deploy proxies with disallowed HTTP CONNECT. But as many said this is not really Derby topic. Just my EUR 0.02. On Fri, Feb 12, 2010 at 10:21 PM, Ronald Rudy ronchal...@gmail.com wrote: As I understand it

Re: Embedded Connection fail when disconnected from Network ? Solaris

2010-02-16 Thread Peter Ondruška
Dear B, actually this is Derby mailing list but I can tell you that you should fix your nsswitch.conf not to use dns resolver (cp /etc/nsswitch.files /etc/nsswitch.conf). Peter On Tue, Feb 16, 2010 at 5:44 PM, bruehlicke bruehli...@gmail.com wrote: Wow - actually it is totally impossible to work

Re: Case Sensitivity

2010-03-24 Thread Peter Ondruška
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

2010-03-24 Thread Peter Ondruška
), so that the quotes could be omitted? *Peter Ondruška peter.ondru...@gmail.com* 03/24/2010 05:33 PM Please respond to Derby Discussion derby-user@db.apache.org To Derby Discussion derby-user@db.apache.org cc Subject Re: Case Sensitivity select Id as id

Re: Derby Char Column Type Versus VarChar

2010-04-05 Thread Peter Ondruška
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

Re: performance: Derby vs H2

2010-04-22 Thread Peter Ondruška
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

2010-04-22 Thread Peter Ondruška
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: NFS and Derby

2010-11-11 Thread Peter Ondruška
You could use NFS mounted read only databases as you can do so with CD/DVD based media. The risks with read-write databases on NFS devices is (was) that in the old days of UDP protocol based NFS client/servers your connection may easily break. It is not the case anymore with decent operating

Re: Language of error message

2010-11-27 Thread Peter Ondruška
It is determined by JRE's system locale. You probably use German locale in your system's settings. If you are on Unix, set LC_ALL=en_US, if you are on Windows go to regional settings in control panel. If you cannot any of those try using your application with additional JRE parameter

Re: Language of error message

2010-11-27 Thread Peter Ondruška
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: Hot backups

2010-12-03 Thread Peter Ondruška
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

2010-12-03 Thread Peter Ondruška
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: inserting missing values

2010-12-14 Thread Peter Ondruška
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: Inserting control characters in SQL

2011-03-11 Thread Peter Ondruška
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: performance issue on 64 bit JVM

2011-06-03 Thread Peter Ondruška
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

Re: error executing multiple insert statements

2011-06-16 Thread Peter Ondruška
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: Does anyone want to run Derby 10.9 on JVM 1.4 or on CDC/FP 1.1?

2011-06-27 Thread Peter Ondruška
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: How to unlock a table in derby

2011-07-18 Thread Peter Ondruška
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: nulls in prepared statement

2011-07-19 Thread Peter Ondruška
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: nulls in prepared statement

2011-07-20 Thread Peter Ondruška
Eclipselink or Hibernate might help if you want less ugly code. Dne 20.7.2011 23:38 Tomcat Programmer tcprogram...@yahoo.com napsal(a): You must explicitly set value to null: if (cobj.getPartNo()==null) pstmt.setNull(1, java.sql.Types.VARCHAR); else pstmt.setString(1,cobj.getPartNo());

Re: nulls in prepared statement

2011-07-21 Thread Peter Ondruška
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: Opinions on new security feature requested

2011-09-02 Thread Peter Ondruška
+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: Derby secure by default

2011-09-19 Thread Peter Ondruška
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: OutOfMemoryException when executing 180,000 batches

2011-11-09 Thread Peter Ondruška
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

2011-11-09 Thread Peter Ondruška
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: AW: Does derby ned allways a rollback or commt?

2011-11-22 Thread Peter Ondruška
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: Random DRDA Error on IBM J9 JVM

2012-03-19 Thread Peter Ondruška
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: Random DRDA Error on IBM J9 JVM

2012-03-20 Thread Peter Ondruška
) at org.apache.derby.drda.NetworkServerControl.main(Unknown Source) Mon Mar 19 12:46:47 EDT 2012 : Apache Derby Network Server - 10.8.1.2 - (1095077) shutdown On Mon, Mar 19, 2012 at 12:12 PM, Peter Ondruška peter.ondruska+de...@kaibo.eu wrote: I have seen the same problem and resolved by upgrading Derby

Re: Random DRDA Error on IBM J9 JVM

2012-04-04 Thread Peter Ondruška
going to get a J9 environment setup with 10.8.2.2 in the next day or two and see how that goes. Thank you both again, Brandon On Tue, Mar 20, 2012 at 3:47 AM, Peter Ondruška peter.ondruska+de...@kaibo.eu wrote: Brandon, I run 10.8.2.2 with J9: $ java -version java version 1.6.0 Java(TM) SE

Re: Speed up single INSERT INTO statement?

2012-05-09 Thread Peter Ondruška
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: Problems with Online Backup SYSCS_BACKUP_DATABASE

2012-08-17 Thread Peter Ondruška
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. It is

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

2013-07-04 Thread Peter Ondruška
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: Proper configuration for a very busy DB?

2013-09-30 Thread Peter Ondruška
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: Proper configuration for a very busy DB?

2013-10-02 Thread Peter Ondruška
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 be

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

2013-10-09 Thread Peter Ondruška
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: How know databases connected with Derby networkServer

2014-01-24 Thread Peter Ondruška
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 to

Re: Apache Derby Command Line?

2014-02-21 Thread Peter Ondruška
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: DERBY_OPTS/DERBY_CMD_LINE_ARGS is there anywhere a list

2014-02-26 Thread Peter Ondruška
On my Windows I start Derby network server like this: set DROPBOX=%USERPROFILE%\Dropbox set PATH=%DROPBOX%\derby\bin;%PATH% set DERBY_OPTS=-Xms256m -Xmx256m set DERBY_OPTS=-Dderby.storage.pageCacheSize=4096 %DERBY_OPTS% set DERBY_OPTS=-Djava.security.manager %DERBY_OPTS% set

Re: Corrupt database: ArrayIndexOutOfBoundsException on connect

2014-03-10 Thread Peter Ondruška
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, if

Re: When to shut down a database

2014-04-10 Thread Peter Ondruška
Where did you read that? If you declare your column to be CLOB(64K) than you have restricted its size. CLOB data type CLOB data type A CLOB (character large object) value can be up to 2,147,483,647 characters long. A CLOB is used to store unicode character-based data, such as large documents

Difference

2014-07-31 Thread Peter Ondruška
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: Difference

2014-08-01 Thread Peter Ondruška
: 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: Problem with Select statement

2014-09-09 Thread Peter Ondruška
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: Another error to be explained

2014-09-22 Thread Peter Ondruška
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

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

Re: Derby online backup with huge database

2014-11-03 Thread Peter Ondruška
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: No Powered By Derby Logo

2014-11-10 Thread Peter Ondruška
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

Locks on crashed database

2014-11-25 Thread Peter Ondruška
but it was removed for troubleshooting. Thanks -- Peter Ondruška

Re: Locks on crashed database

2014-11-27 Thread Peter Ondruška
/ * 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

Re: Urgent question about JIra issue DERBY-526

2014-12-04 Thread Peter Ondruška
, 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

2014-12-04 Thread Peter Ondruška
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: How to Combine Apache Derby without installing with Jar Directly

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

Re: Copying encypted DB?

2015-04-15 Thread Peter Ondruška
, 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: EmbeddedDriver and db.lck file

2015-06-17 Thread Peter Ondruška
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: XQuery or XSLT support in Derby

2015-10-29 Thread Peter Ondruška
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: Derby ERROR XSDB6

2015-10-30 Thread Peter Ondruška
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: BACKUP.HISTORY file

2017-01-20 Thread Peter Ondruška
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

Re: Use Apache Derby Network Server with encrypted database

2016-08-24 Thread Peter Ondruška
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: Use Apache Derby Network Server with encrypted database

2016-08-25 Thread Peter Ondruška
db.apache.org/derby/papers/DerbyTut/ij_intro.html#ij_connect > > >1. https://db.apache.org/derby/docs/10.0/manuals/develop/develop15.html > > >1. If you want a more custom example regarding the algorithm that can >be used to encrypt the database, please have a look in

Re: SYSCS_DIAG.TRANSACTION_TABLE stale records

2017-08-11 Thread Peter Ondruška
transaction > set connection conn2; > disconnect; > set connection conn1; > select count(*) from syscs_diag.transaction_table; > > Thanks, > -Rick > > On 7/11/17 10:10 AM, Peter Ondruška wrote: > > Dear all, > > the documentation mentions "The S

Re: Page cache sizing

2017-07-09 Thread Peter Ondruška
when-writing-blobs-td100948.html > > and > > https://issues.apache.org/jira/browse/DERBY-4537 > > Sorry I'm not of much more help here. > > bryan > > -- Peter Ondruška -- kaibo, s.r.o., ID 28435036, registered with the commercial register administered by the Munici

SYSCS_DIAG.TRANSACTION_TABLE stale records

2017-07-11 Thread Peter Ondruška
EXT 79241843NULLNULLSystemTransactionIDLENULLNULL and one UserTransaction (as expected): XIDGLOBAL_XIDUSERNAMETYPESTATUSFIRST_INSTANTSQL_TEXT 79604720NULLAPPUserTransactionIDLENULLSELECT * FROM syscs_diag.transaction_table

Re: Derby Database Corruption Issues

2017-07-12 Thread Peter Ondruška
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

Page cache sizing

2017-07-06 Thread Peter Ondruška
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

2017-06-28 Thread Peter Ondruška
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

2017-06-22 Thread Peter Ondruška
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

Connection authentication failure occurred. Reason: Invalid authentication..

2017-05-29 Thread Peter Ondruška
/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: Connection authentication failure occurred. Reason: Invalid authentication..

2017-05-30 Thread Peter Ondruška
in the database being > connected to? Or are they stored in a system-wide credentials database? > What other errors appear in the diagnostic log prior to this error? > > Thanks, > -Rick > > > On 5/29/17 12:12 AM, Peter Ondruška wrote: > > Hello, > > I am facing strange s

Re: Incremental Online Backup

2017-09-16 Thread Peter Ondruška
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

  1   2   >