Re: Derby Replication Issue

che.org/derby/docs/10.4/adminguide/cadminreplication.html On Thu, Aug 27, 2020 at 11:20 PM Michael Remijan wrote: > Embedded database can only be accessed by the application, nothing > external. Seems to me like replication between embedded databases wouldn’t > work. > > >

Derby Replication Issue

Hello, I am trying to setup replication b/w two Derby databases. Its embedded with an application. Configuration for replication is done as per the documentation here When the application tries to start master instance,

Re: Using Derby and TOMCAT

On 5/24/2017 8:53 AM, George S. wrote: On 5/24/2017 6:34 AM, Daniel Godefroy wrote: I want to use Derby and Tomcat in a web site. The web server is on a linux 2.6.32 with an Apache server 2.2.32. Not really important. Tomcat and Java versions are vastly more critical. I dont think

Re: Using Derby and TOMCAT

les in the web application directory, removing the webapp will cause tomcat to delete your DB. Don't put the DB files in the web app directory, or make sure that you're really careful. Thank you -- George S. *MH Software, Inc.* Voice: 303 438 9585 http://www.connectdaily.com

Re: How to drop a bad table?

One solution that would work with pretty much any system is to copy the non-bad tables to a new database, drop the bad database, and rename the new database. On 11/17/13 8:53 PM, chongsoft wrote: I'm using derby for 4 years, all the time I don't known how to drop a bad table( file damaged)?

Re: derby network server can not be started automatically

Typically, you use the distribution's startup mechanisms to signify what services are required. For example, in OpenSUSE, you would define the startup script using comment meta-data that indicates what services your service is dependent upon. Here's an example from OpenSUSE 12.

Re: derby network server can not be started automatically

Start derby after the network interface comes up? On 8/12/13 4:35 PM, Rong Qu wrote: On Linux, we wrote a script to call NetworkServerControl so that derby network server can be started automatically after reboot. After reboot, we got following error message from derby Can not listen on po

Re: Peculiar sorting behaviour?

The most likely thing is that the query you're running in the web page is not what you think. On 4/2/13 3:39 AM, John English wrote: I have a query that looks like this: SELECT tests.id,tests.item,title FROM tests,item_usage WHERE username='X' AND item_usage.item=tests.item ORDER BY tes

Re: IDENTITY fields as primary keys: inserts vs. system generated values

FWIW, on SQL Server, you have to do a DBCC CHECKIDENT command, and on PostgreSQL, you do an ALTER SEQUENCE x RESTART WITH command. On 3/26/13 6:21 PM, rgasch wrote: I'm in the process of porting an application to derby and I've hit a major stumbling block in the sense that we're using a SQL s

Re: DriverManager.getConnection error with JDK 7

You might want to read this page and resubmit the question. http://www.catb.org/esr/faqs/smart-questions.html In particular, you might want to post the command line used to invoke Java, and post the text of the error. Also, can you explain the part about not using class for name? On 2/23/13

Re: Problems to use Derby Network Server

Fabricio, Can you try executing the following command on your client machine... "ping 203.203.1.1" (less quotes), and reply with what is returned. You might be having some kind of network issues. In addition, I would recommend you move the database directory into the DERBY_HOME directory.

Re: Converting a value held in a VARCHAR column into an INTEGER

The advantage of this approach is that you can put a useful index on integerPower and that might speed up your queries. This *is* an enormous advantage, but I dont think I want to go down this route because I would potentially have to perform some database maintenance every time I want to inse

Re: Converting a value held in a VARCHAR column into an INTEGER

Since everything is being brought in as a VARCHAR, is there any reason you cannot use the .startsWith(") method from the String class? String.startsWith() may execute faster than Integer.parseInt() (or so I assume - logically at least, this seems probable), but I think the Interger.parseInt()

Re: Converting a value held in a VARCHAR column into an INTEGER

public class MyFunctions { public static Integer toInt(String str) { try { return Integer.valueOf(str); } catch(NumberFormatException nfe) { return null; } } } *smiles* Thanks Sylvain.

Re: Converting a value held in a VARCHAR column into an INTEGER

The advantage of this approach is that you can put a useful index on integerPower and that might speed up your queries. This *is* an enormous advantage, but I dont think I want to go down this route because I would potentially have to perform some database maintenance every time I want to inse

Re: Converting a value held in a VARCHAR column into an INTEGER

I think you could use a custom function here. Wow! I didn't realise you could do this. Derby is written in pure Java, so of course its extendable. Tee vista of possibilities this provides (for me as a Java programmer) is jaw dropping! :) I'll definitely look into this. Thanks Sylvain

Re: Converting a value held in a VARCHAR column into an INTEGER

You may be able to use a CASE expression to solve this problem: SELECT name, power FROM card WHERE ( case when power = '*' or power = '{' or power = '^' then null else integer( power ) end ) > 7; Unfortunately, the non-numeric characters I mentioned are the only ones in the data set *at the m

Converting a value held in a VARCHAR column into an INTEGER

Hi, I'm using Apache Derby version 10.5.3. I have a table with a column of type VARCHAR... CREATE TABLE db.card ( name VARCHAR(64)NOT NULL, powerVARCHAR(16)NOT NULL ) The column predominantly holds numeric data, but I made the column type VARACHAR because th

Derby Db tables returned in uppercase???

any settings/workarounds to fix this?? Dustin S. Houck Software Engineer II Raytheon Technical Services Company, LLC

table size estimation

This is a follow up email to my earlier posting regarding storage. Based on the query given,select * from NEW org.apache.derby.diag.SpaceTable('SYS','SYSTABLES') AS x;using it for my table, the estimated size of a record is coming to be 131 bytes. The table consists of 5 bigints, 3 smallints, 1 tim

storage estimation

Hi, how do I estimate the average record length of a table. Actually, I have a fast growing table and I need to understand the disk size requirement of it. In Oracle, the all_tables table provides this information.

Re: case insensitive searches

Stephen Caine wrote: Terry, Is it possible to set Derby to do case-insensitive searches? The default seems to be case-sensitive. This would be fine as a global setting that never needs to change. Are you using 'starts with', 'contains' or 'equals'? These operators tend to be case sensit

How to log queries that do sequential scan of any table

I am optimizing for performance in my application. We have a large unit test suite. I am looking for a way to log *any* table sequential scan on any query executed during the running of my regression test suite to identify queries that need to be optimized. Is there a way that I could do this

syscs_util.syscs_import_data error

Anyone experienced this before?   table definition is: ij> create table INDIGO.ATTRIBUTE (ATTRIBUTE_ID SMALLINT NOT NULL , ATTRIBUTE_PARENT_ENTITY_ID SMALLINT NOT NULL, ATTRIBUTE_INTERNAL_NAME VARCHAR(50), ATTRIBUTE_EXTERNAL_NAME VARCHAR(50), ATTRIBUTE_MAX_WIDTH SMALLINT, ATTRIBUTE

possible minor bugs

against current release rather than devlopment branch 1. the bin.jar distribution doesn't contain the frameworks directory and sub directorys 2. embedded/bin/setEmbeddedCP.ksh seems to non unix [windowss?] line endings [ I haven't investigated the other files in this directory] cat -st gives ^M