Re: hello

On 11/01/2015 11: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 fri

Re: Performance degradation with Derby Embedded under Tomcat vs Jetty

On 04/13/2015 12:27 AM, Øyvind Harboe wrote: I found another crucial clue: if I use ClientDriver instead of EmbeddedDriver and connect to the Derby database running under Jetty, I get identical performance with Tomcat and Jetty. This is very strong indication that there is something about the c

Re: Initializing a new record where field is NULL by default

On 02/01/2015 05:42 PM, Bryan Pendleton wrote: > You have to spell out the columns you are inserting into, > unless the columns with default values are the last columns > in the table. In that case you can just omit them in the insert > I'm pretty sure it's a bit more flexible than that. I b

Re: Initializing a new record where field is NULL by default

> On 31. jan. 2015, at 20.22, Bob M wrote: > > Hi Dyre > > I am still not grasping this. > > I have > psInsert = conn.prepareStatement("INSERT INTO TABLE VALUES(?, ?.., ?) > [27 of them] > psInsert.setString(1, date); > > psInsert.setString(25, class); > ps

Re: Inserting and deleting records

See setNull in the jdbc javadoc > On 31. jan. 2015, at 18.58, Bob M wrote: > > Thanks Dyre > > If I choose to follow your No. 2 point to consider > I set up the profit field wi

Re: Initializing a new record where field is NULL by default

> On 31. jan. 2015, at 19.23, Bob M wrote: > > Hi > > When creating a new record, what does one need to code to initialize a field > which you wish to have the default value of NULL? See columnDefinition in the manual. > > Bob

Re: Inserting and deleting records

> On 31. jan. 2015, at 14.59, Bob M wrote: > > Thank you Dyre for a brilliant reply.. > I do have a TRADE_ID number > Also, I only ever have ONE open trade at any point in time > I follow your three points completely > > Because I already have code which retrieves x records orde

Re: Inserting and deleting records

> On 31. jan. 2015, at 13.50, Bob M wrote: > > Hi Dyre > > Thank you for your explanation > I understand completely > My concept of requiring the table to look exactly as I think it should look > before any ORDER BY is WRONG!!! Well, its an intuitive way to think about it. That is

Re: Inserting and deleting records

> On 31. jan. 2015, at 08.27, Bob M wrote: > > Hi > > I have a section of code which I hope does the following:- > 1) inserts one new record with the latest (date + time) > 2) deletes one old record with the oldest (date + time) > > When I run the code for example, I get 194 new records writte

Re: Duplicate key feature request

> 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 <http://db.apache.org/derby/docs/10.11/ref/rrefsqljmerge.html> >> (jus

Re: Duplicate key feature request

I think the SQL-standard way of doing things like this is with the MERGE statement (just added to Derby in the latest release). Though the syntax may be a bit more cumbersome… In your case you don’t have a source table, so you may h

Re: Derby Error message - explanation required

So, I have never heard about Dukascopy's Forex Platform before… what is that? Based on the callstack you provided it looks like none of Derby’s heuristics for locating a tmp directory works on this platform. Arguably it is a bug that you get an NPE, but the alternative would have been something

Re: CLOB data errors after moving cursor around

To me this looks like a bug. Superficially, it looks like your call to last() has closed the rs on the server side. LOBs make things more complicated since nested queries with locators are involved. On 09/12/2014 09:26 PM, bfabec wrote: On a related note, when a result set contains a CLOB, wh

Re: Problem with Select statement

On 09/09/2014 10:20 AM, Kessler, Joerg 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, CONTENT, ENCRYPTION_KEY FROM TESTTABLE WHERE SEQ_ID = ? AND (MSGSTATE IS NULL OR MS

Re: Possible bug: duplicate value order with non-unique indexes

On 08/19/2014 08:43 PM, Jim Gray wrote: I have a problem which I think is a bug, please let me know if you agree. I don't, as there are NO guarantees about the order in which rows will be returned, unless you add an ORDER BY clause.* The existence of indices or comment overrides does not chan

Re: You cannot invoke other java.sql.Clob/java.sql.Blob methods

It would be much easier to help you if you could provide the actual stack trace you are seeing. More comments inline. On 26. juni 2014, at 08:08, china_wang <2596121...@qq.com> wrote: > Dear All, > > I have a problem that i can't get Clob when i use > spring3.0.5+ibatis2.3.0+derby10.10.0.

Re: Unique constraints and nulls

On 05/17/2014 01:16 PM, John English wrote: On 15/05/2014 10:46, Dyre Tjeldvoll wrote: Could you not do DELETE FROM FOO WHERE A = ? AND ( B = ? OR B IS NULL ) Unfortunately not. If B is not null, it would also delete the corresponding A where B is null. For example: A = X, B = Y A

Re: Derby DB suddenly can't open

On 05/14/2014 11:38 AM, wrote: I am use 10.8.2.x for more than 2 years, and it works well till today. Suddenly I can't open it even I upgrade it to 10.8.3, the stack is below: java.sql.SQLException: Database 'XingDB' not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getS

Re: Unique constraints and nulls

On 05/14/2014 04:35 PM, John English wrote: On 14/05/2014 16:52, John English wrote: Is there an easy way to constrain the values of A to be unique even when B is null? (I could try to change things so that empty strings are used instead of nulls, but that would involve changing existing code an

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

On 18. apr. 2014, at 09:08, 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 modificati

Re: When to shut down a database

There are a number of issues that for the most part are distinct 1) Commit a transaction when you're sure you don't have to abort (or when you need to release resources). 2) Close the connection when you no longer need it/it is about to go out of scope. 3) Shutdown a database to a) speed

Re: Derby replication system - Need help

On 03/23/2014 10:22 PM, spykee wrote: Hi, From my application tables ( for each table I have a trigger for INSERT, UPDATE and DELETE operation), I will need two important information: a) the columns names which changed when an update SQL occured. b) the columns values that changed during an UPD

Re: Derby replication system - Need help

On 03/18/2014 09:58 PM, spykee wrote: I agree, starting 20K threads/sec does not sound like I good idea. But since I'm not familiar with these other technologies that you use, I don't understand why you need to fire a thread per message. Why can't you have a dedicated sender thread that reads e

Re: Derby replication system - Need help

On 03/17/2014 08:48 PM, spykee wrote: Hi Dyre , Thank you for your comments. The JMS Queue ( Topic ) has an API, and it will be called from the stored procedure. The scope of the queue is to be an entry point of the messages publishes by the stored procedures, messages which will go to a cache(

Re: Derby replication system - Need help

Hi George, this is a huge topic, but I'll try to answer some of your questions inline: On 03/16/2014 04:19 PM, George Toma wrote: Hi all, I'm trying to achieve the following functionality and I would like an opinion, advice from more experienced people: - the goal is to provide a replica

Re: Adding a new record to a table

On 03/16/2014 06:54 PM, Bob M wrote: On a regular basis I add a new record and delete the oldest record in my table The records have a key and up until recently were listed by date/time order as I wish to have them I understand that this is unnecessary but it is great to always find the latest r

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

Hi guys, some comments inline: On 03/14/2014 01:33 PM, Rick Hillegas wrote: 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) SCHEMANAMEAUTHORI

Re: Apache Derby Command Line?

On 02/22/2014 07:22 PM, Turtles wrote: I have java working properly (so ignore the quotes and anything else that looks wrong). That isint the issue, its getting derby to load properly. FireDaemon loads the process a little differently than the command line but it works because other java applica

Re: Derby in production environment

On 16. jan. 2014, at 15:56, Dyre Tjeldvoll wrote: > The URL you are referring to is NOT the official Derby web page, and the > statements made there are not correct for the latest version of Apache Derby. > The official page can be found here > > http://db.apache.org/derby/

Re: Derby in production environment

The URL you are referring to is NOT the official Derby web page, and the statements made there are not correct for the latest version of Apache Derby. The official page can be found here http://db.apache.org/derby/ Derby *is* used in production and it has security controls as described here:

Re: Exporting table records

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/lastSuccessfulBuild/artifact/trunk/out/adminguide/cadmini

Re: selecting records in a derby database

On 20. okt. 2013, at 04:01, Bob M wrote: > hi > > I have a derby database and a table with over 4,000 records… It is easier to think about a table as a hash table or tree, rather than an array. So there isn't really a concept of first or last other than the ordering imposed by th

Re: st.executeQuery() got stuck

e doing when the query hangs. These are some possibilities: - Derby thread is starved - other threads take all the resources. Can happen if Derby is sharing the jvm with another application like an appserver. - Derby thread blocked. It is waiting for db lock or java monitor. - Derby thread

Re: st.executeQuery() got stuck

On 07/ 4/13 10:36 AM, Amit wrote: This is the code I am using to execute query. Statement st = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); st.setFetchSize(100); ResultSet queryRs = st.executeQuery(sql); System.out.println("Success"); Usually the query takes 1-2

Re: Question on database, schemas and backups

On 06/28/13 09:07 AM, Maison Mo wrote: Hello, For a multi-tenant application, we evaluate the multiple databases pattern and single database / multiple schemas pattern. Regarding the backup process, it seems that the whole database is backed up by the SYSCS_UTIL.SYSCS_BACKUP_DATABASE(), thus a

Re: Problem inserting

On 04/16/13 01:46 PM, Alejandro Rodríguez González wrote: Basically, I insert using this code: public void insertInputs(Set ri) throws Exception { PreparedStatement psInsert = null; Iterator it = ri.iterator(); while (it.hasNext()) {

Re: DatabaseMetaData.getTables() resultset empty?

Ole Ersoy <[EMAIL PROTECTED]> writes: > Hi, > > I'm trying to use DatabaseMetaData.getTables() to get a list of tables > contained in a derby database. I run the statement like this (I made sure > tables are present by browsing using the eclipse Data Source explorer first): > > ResultSet result

Re: Embedded database which only stores data in memory?

Aaron Zeckoski <[EMAIL PROTECTED]> writes: > I am trying to use embedded derby for testing but I am finding it much > slower than HSQLDB to start and run and significantly more annoying > since I have to remove the actual files between test runs to ensure my > database is clean. Is there a way to

Re: Is Derby.jar really built using javac?

cowwoc <[EMAIL PROTECTED]> writes: > Is there any way for you to find out the exact JDK (vendor, version) used to > compile derby.jar? That is available in the release notes. See http://db.apache.org/derby/releases/release-10.4.1.3.cgi Look for the "Java 6"/"Compiler" items in the "Build envir

Re: Is Derby.jar really built using javac?

cowwoc <[EMAIL PROTECTED]> writes: > Hi, > > Can someone please confirm whether derby.jar is really built using javac as > the website indicates? It seems the latest version might have been built > using the Eclipse compiler, Why do you think so? The jars were built on a machine that does not h

Re: Anyone successfully used Derby with Perl (ODBC)

CheapLisa <[EMAIL PROTECTED]> writes: > If anyone has successfully used Perl (DBI / DBD) with Derby, please let me > know what I am doing wrong. > > I was able to get the DBI module installed but when I try to install > DBD::ODBC it complains that I have no ODBC driver anywhere. > > Where do I get

Re: Portability issue for 'Like-clause' on non-string types ?

Albert Kam <[EMAIL PROTECTED]> writes: > Hello again Apache Derby, > > I'm currently porting my little webapp from using mysql to apache derby. > One of the issue i'm having right now is the like clause being used for > non-string types. I have not checked the exact chapter and verse of the SQL s

Re: Problem connection to derby with PHP using PDO or ibm_db2 (Linux)

David Rekowski <[EMAIL PROTECTED]> writes: > Hello list! > > My aim is to get PHP to connect and work with Apache Derby. (See end of > message for system and versions) > > I tried to follow Dan Scotts slightly outdated tutorial from > http://coffeecode.net/archives/16-Apache-Derby-tutorial-OSCON-2

Re: Feedback releases/release-10.4.1.3.html

Andrew McIntyre <[EMAIL PROTECTED]> writes: > On Mon, Apr 28, 2008 at 1:09 PM, ted lifset <[EMAIL PROTECTED]> wrote: >> >> To Whom It May Concern: >> >> the page/section: >> http://db.apache.org/derby/releases/release-10.4.1.3.cgi#Distributions >> >> contains a link to: >> derby_core_plugin_10.4.

Re: DB gets corrupts in 10.3.1.2!!

Binoy Thomas <[EMAIL PROTECTED]> writes: > We are a firm having multiple software products & we use the Derby DB in all > our suite of products for quite many years now. We are facing a blocker > situation that is halting all our release process. > > Any help would be appreciated on the below DB c

[ANNOUNCE] Apache Derby 10.4.1.3 released

The Apache Derby project is pleased to announce a new feature release of Derby, 10.4.1.3. 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

Re: Problems with BLOBS (fixed....)

Mikael <[EMAIL PROTECTED]> writes: > Sorry about that, my head was in Mississippi or something, I managed to > use an old Derby jar file so I was not running the correct version, sorry. So which version of Derby are you testing with now? DERBY-3085 has been fixed and should be available in the 10

Re: A network protocol error was encountered and the connection has been terminated

Vic Ricker <[EMAIL PROTECTED]> writes: > Sorry about that. I added something to dump follow getNextException() > and getCause(). I got the following exception from getCause(), I > believe. I don't think getNextException() returned anything. Thanks you did exactly the right thing. I should have

Re: A network protocol error was encountered and the connection has been terminated

Vic Ricker <[EMAIL PROTECTED]> writes: > Can anyone give me any suggestions on how to debug this issue? Derby uses exception chaining. The call stack you posted only show the place where an SqlException was caught and transformed to an SQLException which was then thrown. To see the full stack t

Re: limit, offset and random

unludo <[EMAIL PROTECTED]> writes: > Hello, > > I would like to use the following constraints at the end of some queries: > > SELECT a FROM B WHERE c = 'toto' ORDER BY RANDOM() LIMIT 10; LIMIT is a non-standard extension. Derby 10.4 (soon to be released) includes the SQL ROW_NUMBER function which

Re: ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 1313))

David Sitsky <[EMAIL PROTECTED]> writes: > For what its worth, I did another run last night on my 6 quad-core > system. This time I had the derby issue happen for a JVM process on > machine 1, two processes on machine 4, and one on machine 5. I run > four JVM processes per quad-core machine. > >

Re: Newbie question

[EMAIL PROTECTED] writes: > Chris Collins <[EMAIL PROTECTED]> writes: > >> Select is a good start, procedures would probably work to some extent, >> though one can imagine that some of the power is lost if for say I wanted to >> perform an insert into that pseudo table. >> >> I am syncing 10.4 sou

Re: Newbie question

Chris Collins <[EMAIL PROTECTED]> writes: > Select is a good start, procedures would probably work to some extent, > though one can imagine that some of the power is lost if for say I wanted to > perform an insert into that pseudo table. > > I am syncing 10.4 source tree as I write this email. Th

Re: Derby and Bitronix JTA connection failure

Brett Wooldridge <[EMAIL PROTECTED]> writes: > Hello list, > > I am stuck trying to figure out an issue with using the Bitronix JTA > Transaction Manager with Derby (v10.3.2.1). Here’s the details: > > I’m running Derby as a network server on the standard port. I have a unit > test which uses th

Re: why you're not winning

Bob Power <[EMAIL PROTECTED]> writes: > Hi there, > > I'm moving from sql server to derby and I just spent > about 2 hrs looking at migration options and in > particular ddlutils - I've given up - I'm going to do > it manually - I develop on Windows (unfortunately) and > am used to downloading and

Re: Transaction Problems of a Derby Stored Procedure

"sin(EaTing)," <[EMAIL PROTECTED]> writes: > Thanks, Dan. > The document I read seems already the latest, which is Derby Developer's > Guide Version 10.3. > And I am still confused about the isolation mode, I traced the stored > procedure using getTransactionIsolation() and the return value shows

Re: java.lang.OutOfMemoryError

John English <[EMAIL PROTECTED]> writes: > I have a table containing about 22000 records defined as follows: > > CREATE TABLE system_log ( > id INTEGER GENERATED ALWAYS AS IDENTITY, > timeTIMESTAMP DEFAULT NULL, > usernameVARCHAR(15), > facilityVARCHAR(15

Re: NullPointerException in Derby driver (from at least 10.2.2.0)

Eric Floehr <[EMAIL PROTECTED]> writes: > Daniel, > > Yes, we see that as well, but not always. Following is the stack trace of > that. Did you ever find the solution to the problem? Thanks so much! > > SQL Error code: 4 > SQL State: 08003 > java.sql.SQLNonTransientConnectionException: No

Re: derby databse connection in Hibernate

cnapagoda <[EMAIL PROTECTED]> writes: > I try to connect derby database using Hibernate. But I got error like this. > > Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: > USERINFO is not mapped [FROM USERINFO] > at > org.hibernate.hql.ast.util.SessionFactoryHelper.requi

Re: using SELECT as an SQL triggered action

musky <[EMAIL PROTECTED]> writes: > somebody please help me here please!! > please!! > its urgent... Please see http://www.catb.org/~esr/faqs/smart-questions.html#urgent > > musky wrote: >> >> i will make my aim more clearer here: >> i have created an AFTER insert trigger on a table called cha

Re: distinct and order by

tom_ <[EMAIL PROTECTED]> writes: > I am using "disctinct" because of some self-joins and also needed to add an > "order by" clause. An error is shown. Is it not possible to use distinct and > order by together? I think it is allowed. Executing select distinct * from sys.systables order by tablen

Re: Installing and Using Java Procedures.

Briggs <[EMAIL PROTECTED]> writes: > Hey, thanks for your reply. I am still way confused on this. And > trying to find examples of the SQL/JRT spec is almost impossible. I > am trying to make some sense of the examples of creating store > procedures off the http://wiki.apache.org/db-derby/Derby

Re: Generate Always and SQLIntegrityConstraintViolationException

Daniel John Debrunner <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: >> Daniel John Debrunner <[EMAIL PROTECTED]> writes: >>> I think the real bug is that canCacheRow is being passed in as true >>> for the row of (default) when it should be false if the default column >>> definition does

Re: Generate Always and SQLIntegrityConstraintViolationException

Daniel John Debrunner <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: > >> I'm currently running the tests with the following patch which seems to >> fix the repro: >> >> Index: java/engine/org/apache/derby/impl/sql/execute/RowResultSet.java >> ==

Re: Generate Always and SQLIntegrityConstraintViolationException

[EMAIL PROTECTED] writes: > Knut Anders Hatlen <[EMAIL PROTECTED]> writes: > >> wbecker <[EMAIL PROTECTED]> writes: >> >>> I don't understand how this can be happening, but it is: >>> >>> I've created at a table: >>> >>> CREATE TABLE Foo ( >>>id INT NOT NULL GENERATED ALWAYS AS IDENTITY(ST

Re: Generate Always and SQLIntegrityConstraintViolationException

Knut Anders Hatlen <[EMAIL PROTECTED]> writes: > wbecker <[EMAIL PROTECTED]> writes: > >> I don't understand how this can be happening, but it is: >> >> I've created at a table: >> >> CREATE TABLE Foo ( >>id INT NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT >> BY 1) >>

Re: How do I share an Apache derby database to other users?

[EMAIL PROTECTED] writes: > larsk <[EMAIL PROTECTED]> writes: > >> I am trying to create an application (in Java 6.0) that will create and use >> an Apache Derby database. I want to make it so other users will be able to >> access this database at the same time. >> How do I make this possible? Wha

Re: How do I share an Apache derby database to other users?

larsk <[EMAIL PROTECTED]> writes: > I am trying to create an application (in Java 6.0) that will create and use > an Apache Derby database. I want to make it so other users will be able to > access this database at the same time. > How do I make this possible? What do I need to do on the server ap

Re: Help with performance of apache derby server

musky <[EMAIL PROTECTED]> writes: > also note that when the user presses the back and next buttons provided in > the testing GUI to navigate through the questions a select operation is > made.there will be a maximum of say 1000 questions in the database tables. Don't think the size of your proble

Re: Using Derby's VTI

Rick Hillegas <[EMAIL PROTECTED]> writes: > Hi Andreas, > > Some comments inline... > > Andreas Haufler wrote: >> Hi there, >> >> we're trying to use Derby's VTI interface in order to integrate Derby with >> Lucene. I already saw some efforts to integrate Lucene via "normal" function >> calls, but

Re: sql query input prompts

MR GS REARDON <[EMAIL PROTECTED]> writes: > Hello: > > I'm looking for documentation and examples on user input prompts in > a sql query. Not sure I grok what you're saying here? Do you want to write SQL which reads input from a terminal, or window? The conventional way of doing this (w

Re: Please Help with apache network server!

musky <[EMAIL PROTECTED]> writes: > i want to build a java application which will run on multiple nodes which > access a database to retrieve questions(different questions may be retrieved > by diferent hosts) and their answers to these multiple choice questions are > entered into the database as

Re: newbie question

Brad Berens <[EMAIL PROTECTED]> writes: > I've googled for this but all I can find is create statements so I'm hoping > someone can just give me a quick answer. I'm trying to write some db > creation scripts. Normally in MSSQL I would use an if exists from the > system tables to check whether or

Re: Commercial Support for Derby

Test <[EMAIL PROTECTED]> writes: > I am sorry if this is too naive question, but if we use Apache Derby > (not JavaDB) does that still mean that Sun would support it? Java DB is exactly the same as Derby. It is only called Java DB for legal reasons. > I am a bit puzzled about semantics as it se

Re: FW: Advice on *very* badly performing query

Matt Doran <[EMAIL PROTECTED]> writes: > That did it!!! From 22 minutes down to less than a second. :) > > I'm kinda embarassed that I didn't figure it myself. Don't be. It is not obvious. > I had not idea > that derby didn't keep any stats up-to-date without performing that > operation expl

Re: systemtables

Thomas Vatter <[EMAIL PROTECTED]> writes: > Hi there, > > I am trying to make a selection from the systemtables and running into > an error message. The select string is >select * from SYS.systables t where t.tablename = 'mytable' > > (The table 'mytable' really is existing in systables.tablen

Re: Secure Delete

Ruben Misrahi <[EMAIL PROTECTED]> writes: > We want to get "security-certified" and we need to know if deleting a record > in Derby actually eliminates or physically overrides that space Yes, AFAIK. > and/or if there is a way to do that. > And more specifically, if I have a 200 byte field and

Re: Invalid transaction state - held cursor requires same isolation

[EMAIL PROTECTED] (Dag H. Wanvik) writes: > Geoff hendrey <[EMAIL PROTECTED]> writes: > >> "Well, it is even harder for us, since we don't see the relevant part >> of your code..." >> >> Oh, I think you misunderstood me. You don't need to see my code to answer my >> question. >> >> My question w

Re: creating an index on a column that has a UNIQUE constraint just fails silently?

Stacey Brown <[EMAIL PROTECTED]> writes: > http://db.apache.org/derby/docs/10.3/ref/ > > In the section "CREATE INDEX statement" it says, > > "If a column or set of columns has a UNIQUE or PRIMARY KEY > constraint on it, you can not create an index on those columns." > > > I'm using derby

Re: Invalid transaction state - held cursor requires same isolation level

Geoff hendrey <[EMAIL PROTECTED]> writes: > Here are 3 lines from my code: > > Connection c = ConnectionManager.getConnection(req); > c.setAutoCommit(false); > c.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED); > > > The *second* time this block executes, I get this exception fro

Re: exponential increase in insert time

sudhakar <[EMAIL PROTECTED]> writes: > I'm using embedded derby in a Java SE application with OpenJPA. The > applications parses a text file and creates JPA entity objects which it > then turns around and persists in the embedded derby database using JPA. A general observation: The more fancy fra

Re: Reducing memory usage

Charlie Hubbard <[EMAIL PROTECTED]> writes: > Hi, > > I have a database that I have been storing binary data in a Blob > column. I've decided that it was a bad idea and I'd like to remove it > from the DB and store it on the filesystem. I've written a small > program to extract the contents from

Re: Embedded Derby

Daniel Noz <[EMAIL PROTECTED]> writes: > Hello derby-users, > > I develop a richt client application with netbeans using derby-db and > toplink as JPA implementation. > If i use the embedded driver (see value="org.apache.derby.jdbc.EmbeddedDriver"/>) it works great to > persist Entity-Objects. >

Re: DevGuide: glitch in generation?

Thomas Kellerer <[EMAIL PROTECTED]> writes: [snip] > But I have noticed that the reference to the css in the header is incorrect: > > href="/export/home/rh161140/derby/docs/10.3/out/devguidetemp/commonltr.css" > type="text/css" rel="stylesheet" /> > > this is taken from the 10.3 distribution arc

Re: DevGuide: glitch in generation?

caston first <[EMAIL PROTECTED]> writes: > I am reading the HTML PAGES dev guide, and every time > there is a reference to an actual code item in-line > with text (in Courier font), it is an obfuscated > (meaningless) word, viz.: > > This base text (as a result of a copy operation): > > The stand

Re: Maximum connections to embedded database

Mark P Ashworth <[EMAIL PROTECTED]> writes: > Good Day, > > I would like to know the maximum number of connections that a Embedded Derby > database can maintain? This is a bit tricky to answer, since the answer can be either unlimited or one, depending on what you actually mean by "connection".

[comp.lang.java.databases] Derby eclipse install

I just realized that I had snipped the actual question in the reply I sent to comp.lang.java.databases. Here is the full post. Sorry about that. --- Begin Message --- The install instructions for Derby 10.3.1.4 in Eclipse 3.3 implies that it is as simple as having the Eclipse\plugins directory c

Re: Hibernate: table/view does not exist

Mathias Conradt <[EMAIL PROTECTED]> writes: > I try to exchange postgres with derby/javadb 10.3.1.4 and created a derby > database using ij (I'm new to derby). > I use CONNECT 'jdbc:derby:realty;'; for the connection in ij > and after the creation I can do selects on the table using ij. The usern

Re: Unraveling FK errors

"Williamson, Nick" <[EMAIL PROTECTED]> writes: > Hi all, > > If you get errors like these when you're creating a schema... > > "ERROR 42915: Foreign Key 'PIN_FK1' is invalid because 'the delete rule > of foreign key can not be CASCADE. (The relationship would cause another > table to be delet

Re: Wanted: Example using SQLXML

sieg <[EMAIL PROTECTED]> writes: > See below. Incidentally, in a another posting, someone explained to me that > downloading and installing derby was redundant with installing Java 1.6. Not quite. Derby aka JavaDB is _bundled_ with the JDK (not the JRE). And you still need to include the Derby ja

Re: Number of Concurrent Connections

Emir Causevic <[EMAIL PROTECTED]> writes: >> If not, what would you suggest? > Buy Oracle. :) Nope. If I had that kind of money I would buy a sports car :) -- dt

Re: Number of Concurrent Connections

Anestis Sismanidis <[EMAIL PROTECTED]> writes: > Hello > > How many concurrent connections can a derby database handle (in > network server mode)? Is there a limitation? I'm currently running the NetworkServer with 250+ threads on a 32 core machine without problems. Not a production system, but..

Re: Multiple System Directories

Anestis Sismanidis <[EMAIL PROTECTED]> writes: > What I need is: > > Two totally different derby databases in totally different directories > (one directory in the cdrom and the other in the user home > directory). I need all that in the same JVM. > The problem is that there is only one "derby.sy

Re: Is the derby project still active?

Daniel Fitzgerald <[EMAIL PROTECTED]> writes: > It has been quite a while since any new builds or enhancements have > been done on this software. Excuse me. Since when is six months "quite a while"? Even for open source projects? > Is this project dead or in stasis? The 892 unread emails in m

Re: How to shutdown with authentication

"Calvin (Yu-Hui) Liu" <[EMAIL PROTECTED]> writes: > Hi, Leonard, > > I'm new to derby so maybe this is a stupid question for you: why do > you want to use derby, especially use it as a network service? In > another word, what's the use case of you? It's reasonable for me to > use it as embedded db

Re: What is the UPDATE syntax for using two tables?

Luan O'Carroll <[EMAIL PROTECTED]> writes: > I have a SQL Server query that I am trying to port to Derby but I > can't find the right syntax. Is there any documentation? > > The SQLServer query is: > > UPDATE TEMP_RATES > SET Level1=RATES.Level1 > FROM TEMP_RATES INNER JOIN RATES ON TEMP_RATES .CO

Re: question on Working with JavaDB Activities

Joe Annoni <[EMAIL PROTECTED]> writes: > Couple of novice questions here (your help is much > appreciated!): > > 1) While going through the "Working with JavaDB" pdf > in Step 2 of Activity 3 (ie, page 14), I'm getting a > command line error of "'javac' is not recognized as an > internal or extern

Re: any derby gui software for dery query builder

mfa <[EMAIL PROTECTED]> writes: > thank you for your reply > > sir any derby graphic user interfase software such as toad and sqldevloper > > please send me link for download So are you saying that the two links you just received were of no use to you? If so, could you please explain why? -- d

Re: Derby process taking up more than 20% of cpu for more than 5hrs with only one user connected.

Sachin Chitale <[EMAIL PROTECTED]> writes: > Hi, > > To give you a background of what I was testing: Please post which the Derby version and jvm version you're using, and also any non-default properties. If you can post your schema, (table, columns, indexes) that would also be helpful. -- dt

Re: Derby process taking up more than 20% of cpu for more than 5hrs with only one user connected.

Sachin Chitale <[EMAIL PROTECTED]> writes: > Hi, > > To give you a background of what I was testing: > > We have process that uses database as our guranteed message store. To give a > stress test to Derby, this program was run to store about 70k+ messages. Then > a subscriber was started to fetc

  1   2   >