Re: A truncation error was encountered trying to shrink VARCHARTA 'XX-RESOLVE-XX' to length 255.

2010-04-26 Thread Kristian Waagan
On 26.04.10 17:45, OggieOne64 wrote: Thanks for responding but the problem is that I am trying to insert an image (not text). The field is of type Blob. Any other ideas? BTW: How can I verify what version of derby is running? My derby.jar is dated 8/10/2009 Hi Doug, Can you post the stack

Re: Derby 10.3 Performance

2010-04-09 Thread Kristian Waagan
On 09.04.2010 10:39, Rajesh Datla wrote: Hi All, I like to know the performance utilization of multi-processors on a machine by Derby 10.3. Does Derby 10.3 utilize all CPU's on 8 CPU machine?. Hi Rajesh, I cannot give you any hard numbers for 10.3, but I have some general

Re: SQLException Derby 10.5.3.0_1

2010-03-26 Thread Kristian Waagan
On 26.03.10 15:01, Ross Mcdonald wrote: Hi Guys. Through one of my webapps, my Jackrabbit instance is failing with an underlying Derby error: ERROR - BundleDbPersistenceManager - failed to check existence of node references: c6681b77-e4a5-4027-9d20-b53db5819964 java.sql.SQLException: The

Re: cleaning database between test cases

2010-03-19 Thread Kristian Waagan
On 19.03.10 10:11, Gabriele Kahlout wrote: Also, I've copied from the code what I seem to need, and then end up with when I use the db again in a 2nd method. Caused by: java.sql.SQLException: Database '/Volumes/STORE N GO/ws/MemorizEasy/test/db.sqlwrapper' not found. Note that after destroying

Re: TRANSLATION

2010-03-18 Thread Kristian Waagan
On 18.03.10 13:46, Rami Ojares wrote: Hi, TRANSLATION is a reserved word in Derby but I could not find it in docs. Could someone point me to a resource documenting it's use. Hi Rami, Derby doesn't support this feature, see F695 on http://wiki.apache.org/db-derby/SQLvsDerbyFeatures . The

Re: Unsubscribe

2010-03-17 Thread Kristian Waagan
On 17.03.10 04:52, amee.de...@wipro.com wrote: Hi, Can you please remove my name from this mail list? Hi Amee, Aren't the instructions at [1] working for you? Regards, -- Kristian [1] http://db.apache.org/derby/derby_mail.html Thanks and Regards, Amee * Please do not print this

Re: Derby 10.4.2.0

2010-03-17 Thread Kristian Waagan
On 17.03.2010 12:58, Falby, Walter wrote: I’m trying to get a log of the database activity to help debug a locking problem. I have the derby database in a directory. In that directory I have a derby properties file with the following contents: derby.infolog.append=false

Re: Hanging around derby.log, how to center it?

2010-03-16 Thread Kristian Waagan
On 14.03.10 16:46, Gabriele Kahlout wrote: I've added the following lines of code in my db init, but they still didn't make a difference: System.setProperty(derby.stream.error.filederby.stream.error.file, dir.getPath() + File.separator + derby.log); System.setProperty(derby.system.home,

Re: Hanging around derby.log, how to center it?

2010-03-16 Thread Kristian Waagan
On 16.03.10 14:01, Gabriele Kahlout wrote: and then, are these property settings permanent (stored by derby in some way), or do I need to set them at each app execution? The two properties mentioned must be set each time Derby is booted. More about properties in the Reference Manual [1].

Re: Debugging lock timeouts - versuchen01X

2010-03-03 Thread Kristian Waagan
On 03.03.2010 13:01, Gabriele Kahlout wrote: Okay. In my unit tests I try to delete the previous database completely, so as to run each test from scratch. I close the connection, and then delete all files, however this sticks: seg0, c4b0.dat. Does it have any special meaning? Eitherway, how can

Re: Question about logs directory reclaiming disk space.

2010-02-26 Thread Kristian Waagan
On 26.02.2010 20:41, PretzelLogic wrote: Hello, I'm embedding a derby db into a java app that is deployed to Tomcat 6. I have a process that will delete records and I'm wanting to reclaim the disk space after the deletion . My program is calling this fuction -- CALL

Re: GenericPreparedStatements leak due to DependencyManager?

2010-02-21 Thread Kristian Waagan
On 18.02.10 20:45, Charlie Hubbard wrote: Actually I see this as well. I had over 690,000 of these laying around, and I am using Derby 10.5.3. I don't know if I have a test case that I can share, but within my program when I profile it I see a lot of these. They look like they are weakly

Re: Using NetworkServerControl to access in-memory (only) tables of Embedded Derby

2010-02-18 Thread Kristian Waagan
On 18.02.10 18:47, Pavel Bortnovskiy wrote: Hello, Kristian: Thanks for your response. I think I found what the problem is... When my IDE (IntelliJ IDEA) hits a breakpoint, it suspends all threads. I find it funny that in all these years of programming and using IDEA, I've never realized it.

Re: Derby in windows

2010-02-18 Thread Kristian Waagan
On 18.02.10 16:07, Erik Steen Jakobsen wrote: reason for problems is always some 40 cm away from the screen. The derby standard startNetworkserver.bat did not contain any use of %DERBY_CMD_LINE_ARGS% So they were registered and so on ... But never used. Only a wrong stop command did uncover

Re: Using NetworkServerControl to access in-memory (only) tables of Embedded Derby

2010-02-16 Thread Kristian Waagan
On 16.02.10 03:02, Pavel Bortnovskiy wrote: Bryan: thank you for your response. I do see the thread you mention: Thread Group [derby.daemons]{10}(Daemon) Thread [derby.antiGC]{1}(Daemon)(WAITING) Thread [derby.rawStoreDaemon]{5}(Daemon)(TIMED_WAITING)

Re: Indexes on functions

2010-02-16 Thread Kristian Waagan
On 16.02.10 10:54, Vrin26 wrote: Hello, Is there a way to create index on functions in Derby? I have a query as 'select emp_name, emp_addrs.from empTable where UPPER(name) like ' SA%'; In Derby docs it's mentioned that indexes can be created only on column names. How can we achieve

Re: 'ERROR 40XD0: Container has been closed.: java.io.IOException'.

2010-02-15 Thread Kristian Waagan
On 15.02.10 14:15, Donald McLean wrote: When working with BLOBs and CLOBs, these sorts of errors are almost always caused by committed transactions. Since most people don't expect to need a transaction for a select, more often than not autocommit is set to TRUE and the select commits as soon

Re: refresh JSP webpage when Derby DB is changed

2010-02-12 Thread Kristian Waagan
Ronald Rudy wrote: This isn't really a Derby question, it's more of a web/Javascript question. There is no way to push data to a client. The request always originates on the client. That said, IF you are so inclined you can use Ajax type calls to poll a servlet on the server on a regular

Re: Problem storing an image in a Blob field in Java DB.

2010-02-11 Thread Kristian Waagan
On 12.02.10 06:15, Erin Drummond wrote: Odd, I am able to put a file into the database like so: Hi Erin and Dinesh, First, I never saw the original messages before Erin's answer. Not sure what's going on, because the messages are in the archives... File f = new File(image.jpg);

Re: Derby maven

2010-02-10 Thread Kristian Waagan
On 10.02.10 10:46, Giambalvo, Christian wrote: Hi all, i'd like to use derby with maven. So I added the following dependency: dependency groupIdorg.apache.derby/groupId artifactIdderby/artifactId version10.5.3.0/version

Re: OutOfMemoryErrors on group by select

2010-02-08 Thread Kristian Waagan
On 08.02.10 15:25, Ronald Rudy wrote: Version is 10.4.2.0, and no I don't - I am actually trying the group by/etc. on another 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

Re: OutOfMemoryErrors on group by select

2010-02-08 Thread Kristian Waagan
/browse/DERBY -Ron On Feb 8, 2010, at 9:48:52 AM, Kristian Waagan wrote: Hi Ronald, If you can easily control this process, can you run it with -XX:+HeapDumpOnOutOfMemoryError and post a heap dump summary? (I don't remember off the top of my head how you extract a histogram from

Re: precompile statement with result offset and fetch first clauses

2010-02-04 Thread Kristian Waagan
On04.02.10 13:23, Burk Mayer wrote: hi, i'm getting an error while precompiling a prepared statement with offset and fetch first clauses. the documentation (

Re: how to get rid of the derby.rawStoreDaemon thread

2010-02-04 Thread Kristian Waagan
On 03.02.10 15:17, Pasi Paasiala wrote: Kristian, Thank you very much for your answers. Can you still elaborate, how can I perform checkpoint and freeze? Pasi, If you want to manually invoke a checkpoint and freeze the database, you have to use some of Derby's system procedures:

Re: SQL Parser Code in Apache Derby Source Code

2010-02-04 Thread Kristian Waagan
On 05.02.10 01:43, AKA_DERBY wrote: Hello Rick, Thank you for replying. I am kind of stuck with another build error. Everytime I build it, I am getting an Ant Build error dialog pop up. http://old.nabble.com/file/p27462091/Ant_build_failed.jpg . There are links discussing this - like

Re: how to get rid of the derby.rawStoreDaemon thread

2010-02-03 Thread Kristian Waagan
On 03.02.10 13:48, Pasi Paasiala wrote: We are evaluating derby to use it for storing additional information related to our models (Java objects). When we save our model, we save the database files and folders with it. The only way that we have found to ensure that the database files are in a

Re: In-Memory Apache Derby Tables not visible from outside

2010-01-15 Thread Kristian Waagan
Pavel Bortnovskiy wrote: Hello: I am writing an application which is using Derby as an in-memory DB: Class.forName(org.apache.derby.jdbc.EmbeddedDriver); m_connection = DriverManager.getConnection(jdbc:derby:memory:testdb;create=true); In that application I am also starting

Re: Derby as an in-memory JEE datasource

2010-01-08 Thread Kristian Waagan
Marcin Kwapisz wrote: I think that sub-protocol memory is ignored. When I start Derby as a normal db server, connection can be established (with that connection pool) and everything works fine. Maybe I do something wrong. I do not know, so I asked if it is possible to configure in-memory

Re: AW: primary key constraint violation on autoincrement id

2009-12-09 Thread Kristian Waagan
malte.kem...@de.equens.com wrote: Hi Stuart, I think you should write logs then you may are able to analyse it this is a problem of your program or not. May be the ID you are using as primary key is not as unique as you think. Maybe I'm wrong, but in this case I think Derby is providing /

Re: How to clear data in Memory used by JavaDB

2009-12-08 Thread Kristian Waagan
Amandeep Singh wrote: Hi, I am using JavaDB for In-Memory DataBase, but i want that database to be removed after use from memory.How can i do so. Hello Amandeep, The in-memory feature was marked as experimental in Derby 10.5, and there isn't a proper mechanism to delete an

Re: Different DB behavior loaded from JAR vs. file system

2009-12-03 Thread Kristian Waagan
malesch wrote: I checked again, altough I was quite sure, I only connect as the user app (I have no other users). In every case values CURRENT_USER always return APP and the second query always the schema name APP with the corresponding table name. I realized that I previously wrote nonsense

Re: java.sql.SQLException: No suitable driver found for jdbc:derby:jdbcDemoDB;create=true

2009-11-19 Thread Kristian Waagan
Steve Morgan wrote: I just started using Derby. I am using NetBeans 6.7.1 with JDK 1.6.0_17. I have included Derby.jar in my IDE libraries however the system does not seem to be able to find the embedded driver. I cannot find a library called Embedded Driver. Can anyone see what I am doing

Re: OOM with millions of weakly-referenced Derby objects

2009-11-17 Thread Kristian Waagan
Larry Meadors wrote: The expected behavior is really dependent upon the underlying JDBC driver. Using the maxRows parameter is a last resort option, IMO. Limit the results with the SQL if at all possible, here's an example: http://old.nabble.com/top-N-reporting-with-derby-td17221545.html

Re: Few quick questions on Index, Optimizer

2009-11-12 Thread Kristian Waagan
kashyup wrote: Hello all, after going through much docs i think i have lost answers to much basic questions. I would appreciate any reply... Hello, Tuning is in general pretty hard, since there are so many factors. Some simple answers to get the discussion going below... Q1) Derby

Re: How to connect derby by python

2009-11-10 Thread Kristian Waagan
Zhang Qian wrote: Hi, I have to access derby DB with my python script, but I do not know if there are any python modules for this purpose I can use. Any suggestions will be really appreciated! Hi Qian, What about using Jython :) There's an article describing how to connect to Python using

Re: Start server within java-application???

2009-11-04 Thread Kristian Waagan
Hardie82 wrote: Hallo, I want to start derby in servermode within a java-application. Is this possible? I didn't find a thing in the documentation but start the server via console-statements. Hello, You have two options; - set a system property before you load the embedded driver - start

Re: data lost with ij

2009-10-30 Thread Kristian Waagan
RAPPAZ Francois wrote: Using ij, I create a database, then I build a table and populate it with a serie of insert statement. Without doing anything else I disconnect (that take a long time) and I exit. When I reconnect and run a select * from table; I got nothing in the table... If run that

New in-memory back end features suggested, rev 1 (was: Re: Derby in-memory back end - where to go next?)

2009-10-09 Thread Kristian Waagan
Kristian Waagan wrote: Hello, In Derby 10.5 an in-memory back end, or storage engine, was included. It stores all the data in main memory, with the exception of derby.log. If this is news to you, and you want a quick intro to it, see [1] and [2]. I'm trying to gather some feedback

Re: Derby in-memory back end - where to go next?

2009-10-05 Thread Kristian Waagan
. And finally, is this added complexity worth the gain? Is there an easier way? Regards, -- Kristian Thanks, -Rick Kristian Waagan wrote: Hello, In Derby 10.5 an in-memory back end, or storage engine, was included. It stores all the data in main memory, with the exception of derby.log

Re: Derby and Osgi

2009-10-02 Thread Kristian Waagan
Santiago Miguel Aranda Rojas wrote: I like Derby. I am using OSGi in order to have a SOA platform. I know derby is working in Embedded mode as OSGi bundle. I would like to know if it is possible run Derby in client-server mode using OSGi. I have dowloaded derby and I have found a

Re: Pooling

2009-09-28 Thread Kristian Waagan
Matt Doran wrote: Peter Ondruška wrote: Yes, Derby does not provide connection pool, pick your favourite (I can confirm c3p0 works very well for me). Peter We also use c3p0 with embedded derby, but it's mainly just our default configuration so if you switch our app over to a network based

Re: Derby in-memory back end - where to go next?

2009-09-25 Thread Kristian Waagan
the growth of the in-memory db * It would be great if the memory occupied by deleted records could be released Thanks, -Rick Kristian Waagan wrote: Hello, In Derby 10.5 an in-memory back end, or storage engine, was included. It stores all the data in main memory, with the exception

Re: StackOverflowError for large Scrollable result sets

2009-09-18 Thread Kristian Waagan
Jason Ward wrote: Thanks Bryan, I should have included the info from the derby.log. Here's a small snippet of the ~1K lines from the log: 2009-09-17 14:58:48.873 GMT Thread[DRDAConnThread_19,5,derby.daemons] (XID = 5212534), (SESSIONID = 21), (DATABASE = C:/temp/testDB), (DRDAID =

Derby in-memory back end - where to go next?

2009-09-07 Thread Kristian Waagan
Hello, In Derby 10.5 an in-memory back end, or storage engine, was included. It stores all the data in main memory, with the exception of derby.log. If this is news to you, and you want a quick intro to it, see [1] and [2]. I'm trying to gather some feedback on whether the current

Re: LINUX Hang on creation - ERROR XBM0J Directory already exists on second load

2009-09-03 Thread Kristian Waagan
d...@xx wrote: Hi, I have developped my application under Windows XP and everything is working correctly. Now I start testing under LINUX but without success. When I start first time the embedded driver with create=true option, the application hang but the database seams created, except that

Re: LINUX Hang on creation - ERROR XBM0J Directory already exists onsecond load

2009-09-03 Thread Kristian Waagan
going to make a small application to test only the Derby feature and will give you the result. Sincerely, JY LINET - Original Message - From: Kristian Waagan kristian.waa...@sun.com To: Derby Discussion derby-user@db.apache.org Sent: Thursday, September 03, 2009 11:20 AM Subject: Re

Re: Derby db files and folders (what to track)

2009-08-24 Thread Kristian Waagan
Prodoc81 wrote: Hi, I've got a Derby database embedded in a Java application. The complete project, including the database, is stored in a repository for version control. Several files and folders are present in a Derby database folder but which ones are required to track? I.e. which files are

Re: What is default size of Derby Blob filed?

2009-08-12 Thread Kristian Waagan
sarah.kho wrote: Hi I am trying to develop an application using JPA and derby. I have a blob filed (@Lob) in one of my entities. When it creates the field in the corresponding table it sets the size of the BLOB filed to 64k, I am wondering whether it is a Derby default or it is something related

Re: What is default size of Derby Blob filed?

2009-08-12 Thread Kristian Waagan
column in Derby, but this feature will be included in the next feature release (see DERBY-4256 [1]). Regards, -- Kristian [1] https://issues.apache.org/jira/browse/DERBY-4256 Thanks for the tip. Kristian Waagan-4 wrote: sarah.kho wrote: Hi I am trying to develop an application

Re: Derby 10.5.1.1 regression

2009-08-04 Thread Kristian Waagan
Brett Wooldridge wrote: Anyone have some suggestions for debugging direction? I hate the thought that I'm stuck on 10.5 forever. Any other environment details, logging options, etc? This may be a stupid question, but is it possible to run the application using an EmbeddedXADataSource? It

Re: Does derby support arrays

2009-08-04 Thread Kristian Waagan
Paul Taylor wrote: Does Postgres supports array datatype ? i.e CREATE TABLE album ( attributes integer[] DEFAULT '{0}' } does derby support this it doesn't appear to, will it support it ? Hello Paul, No, Derby doesn't support the array data type [1]. I'm not aware of any plans to support

Re: Derby 10.5.1.1 regression

2009-08-04 Thread Kristian Waagan
Kathey Marsden wrote: Kristian Waagan wrote: Brett Wooldridge wrote: Anyone have some suggestions for debugging direction? I hate the thought that I'm stuck on 10.5 forever. Any other environment details, logging options, etc? Did you try setting the properties outlined here: http

Re: question on in-mmeory db in 10.5.1.1

2009-08-04 Thread Kristian Waagan
Wald, Mark wrote: Can an in-memory db be accessed from outside the application, for example from another application in a different JVM, maybe on a different IP address, perhaps with a jdbc connect string?'t Hi Mark, The only way that I know works at the moment, is kind of a hack and

Re: Bug : Derby table invisible from JPA provider

2009-08-03 Thread Kristian Waagan
Brieuc Desoutter wrote: Hi, I'm learning JPA from the book Pro EJB 3 : Java Persistence API. Hello Brieuc, I'm not very familiar with JPA. Do you know if the JPA providers quote your table names? Would it be hard for you to enable statement text logging in Derby and rerun the table

Re: Derby 10.5.1.1 regression

2009-07-30 Thread Kristian Waagan
Brett Wooldridge wrote: I have obtained a server-side trace of the failure. Hi Brett, I haven't decoded the DRDA trace, but do you happen to have the stack trace for the XJ001 SQLException as well? Also, how is the value of the CLOB columns being set? (i.e. setCharacterStream or setString)

Re: performance, memory consumption...and a big hello :)

2009-07-29 Thread Kristian Waagan
Tomi N/A wrote: Thank you both for the comments. Jan, I've kind of taken your advice even before I saw it :), but I tried PostgreSQL, unfortunately, with no obvious improvement. 2009/7/27 Rick Hillegas richard.hille...@sun.com: select id_group, count(id) group by id_group Not to

Re: Embedded Derby multi-user

2009-07-29 Thread Kristian Waagan
and see what happens there, but this requires that you set up the server of course. Regards, -- Kristian / Best, Clif... -Original Message- From: Kristian Waagan [mailto:kristian.waa...@sun.com] Sent: Tuesday, July 28, 2009 2:39 AM To: Derby Discussion Subject: Re

Re: Embedded Derby multi-user

2009-07-28 Thread Kristian Waagan
Clifton B. Sothoron Jr. wrote: I’m creating an application which receives various requests to insert, update and query an Embedded Derby database. It works properly except when one request does a lot of inserts. During this time query requests are blocked. I get the message edules' not

Re: Feedback releases/release-10.5.1.1.html

2009-07-28 Thread Kristian Waagan
Dohm, Christian Erich (PWA-MA) wrote: What about Maven2 artifacts for this release? Hello Christian, The automatic conversion of M1 artifacts into M2 artifacts has been stopped. This means the Derby community itself has to start producing and deploying M2 artifacts. This is tracked as

Re: Derby performance issues

2009-07-23 Thread Kristian Waagan
Dan Armbrust wrote: I have a fairly complex application which I currently support on PostgreSQL and SQL Server. Most of the SQL that is run is created by Hibernate. I'm trying out Derby as a backend for the application - and well, I'm hoping I have something configured wrong - because the

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

2009-07-01 Thread Kristian Waagan
kashyup wrote: took for a test-drive and runs great! Thanks Krisitian, Rick for the fast response and fix! Thank you for testing the patch, kashyup :) It has now been committed to the development trunk, and will be back-ported to the 10.5 branch in a few days. -- Kristian kashyup

Re: Overhead for varchar and clob

2009-06-30 Thread Kristian Waagan
Donald McLean wrote: I'm working on something where I need to store strings of indeterminate length and I'm curious about the difference in storage costs for varchar vs clob. I'm not going to make my decision based on the difference - disk space is too cheap for it to be that big of a deal, but

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

2009-06-30 Thread Kristian Waagan
with the maximum length allowed for the VARCHAR data type and see if the difference changes. At least in 10.4, the result would depend on the value itself as well (the bytes per char encoding ratio). Regards, -- Kristian Thanks, Peter 2009/6/19, Kristian Waagan kristian.waa...@sun.com

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

2009-06-19 Thread Kristian Waagan
kashyup wrote: Hello all, We have just started to look into Derby as our embedded DB for a desktop app version. Env: Hibernate 3.2 and Derby 10.5.1 I have defined a java string field of type 'text' in Hibernate Mapping (works great on Postgres 8.1 and Oracle 10g) I use Hibernate

Re: DERBY 10.5 | Embedded vs Server Based

2009-06-08 Thread Kristian Waagan
Derek Roscoe wrote: Knut, hi! Thanks for the response and help. I truly appreciate it. Would you feel the same way if it were a public website with thousands of users? Hi Derek, When you say thousands of users, how many of these are concurrent users? I think I would still go for the

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

2009-06-05 Thread Kristian Waagan
On Fri, 2009-06-05 at 22:58 +0200, Peter Ondruška wrote: 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.

Re: Inserting into BLOB field

2009-06-02 Thread Kristian Waagan
cmathrusse wrote: I know this has been asked before... I need to perform an insert into a BLOB field. Previously my field was defined as a CLOB and there was no issue. But due to a new requirement I need to change this to a BLOB. The issue that I have now is that I cannot insert any seed data

Re: What happens during a database upgrade?

2009-05-27 Thread Kristian Waagan
Rick Hillegas wrote: David Goulden wrote: Good day, We would like to update our derby version from 10.4.1.3 to 10.5.1.1 due to the newer version's much improved performance with large CLOBS. However our client is very conservative and would like to be sure the upgrade won't cause any

Re: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.

2009-05-22 Thread Kristian Waagan
Kristian Waagan wrote: Schueller, Henriette wrote: Hello, I want to report a bug. Hi Henriette, Thank you for coming to the user list with your Derby problem :) Derby uses Jira to track bugs, which you can find at [1]. Also, thanks a lot for providing a repro. I ran it with a debug build

Re: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.

2009-05-20 Thread Kristian Waagan
Schueller, Henriette wrote: Hello, I want to report a bug. Hi Henriette, Thank you for coming to the user list with your Derby problem :) Derby uses Jira to track bugs, which you can find at [1]. Also, thanks a lot for providing a repro. I ran it with a debug build, and can confirm that

Re: Problems create SQL Function

2009-05-19 Thread Kristian Waagan
(timeNumber bigint) returns date language java external name 'DateFunctions.getDate' parameter style java no sql; 0 rows inserted/updated/deleted ij values getDate(23423423432); 1 -- 1970-09-29 1 row selected ij Cheers, -- Kristian Kristian Waagan-4 wrote: dacia wrote: Hi

Re: No changes applied in Java? Cant find it in derby tools.

2009-05-19 Thread Kristian Waagan
MarcelK1607 wrote: i've written some java code to connect and update a small test database. I create a table in Java code, but when i look into my database there is nothing there. There seems to be some difference in between connecting in Java and using the CLI. Any tips / pointers on how to

Re: Network encryption and authentication with SSL/TLS

2009-05-18 Thread Kristian Waagan
o...@me.com wrote: Dear Derby Users Can anyone help me with the following: I have a derby network server install on a virtual private server machine. When the server is started in this fashion: RUNCOMMAND=bin/startNetworkServer -h 0.0.0.0 I can connect, insert, delete and query my database.

Re: Long text/CLOB – SQLException: Java exception: '-1: java.lang.ArrayIndexOu tOfBoundsException'

2009-05-18 Thread Kristian Waagan
hbf wrote: Dear Knut, Thanks a lot for your quick reply. It's a known issue then. Hello Kaspar, Can you tell us which isolation level you are using when you see this error? I'm wondering if the bug is restricted to read uncommitted, or if it can be seen with other isolation levels as

Re: Unexplained exception: temp file cannot be found

2009-05-14 Thread Kristian Waagan
Tim Dudgeon wrote: Dag H. Wanvik wrote: It looks as if the creating of a temporary file failed. Does the path exist (C:\Users\Csizi\Documents\IJCProjects\ijc-project\.config\localdb\db\tmp), and if so, is it writable for this account? Dag Yes, the user has confirmed that this directory

Re: Can we do some kind of virtual path mapping with Network Server?

2009-05-13 Thread Kristian Waagan
Daniel Noll wrote: Hi all. We have a setup where databases can basically be anywhere on the server (it's up to the user) and thus we cannot use derby.system.home to get relative paths. To get around this we have gone with absolute paths, but absolute paths aren't so great either.

Re: Showstopper bug in 10.5.1.1?

2009-05-12 Thread Kristian Waagan
tsvetozar wrote: I've also found some strange bugs when upgraded to Derby 10.5.1.1 and while testing they appeared completely occasionally without any specific reason. When I test them with 10.4.2.0 - everything works just fine. I am using the Embedded Derby engine and from the Exception I

Re: Showstopper bug in 10.5.1.1?

2009-05-12 Thread Kristian Waagan
Alan Burlison wrote: Kristian Waagan wrote: Can you please provide some more information on the problems you are seeing? Are they already logged in the issue tracker[1]? (if not, feel free to add new issues!) Yes, I've added https://issues.apache.org/jira/browse/DERBY-4225 Is autocommit

Re: Row Locking

2009-05-03 Thread Kristian Waagan
wfalby wrote: My application processes events. These events are sent to registered users. These events can be deleted when they reach a certain age. There is a thread to send events to registered users and there is another thread to delete old events. The thread sending an event should lock it

Re: Row Locking

2009-05-03 Thread Kristian Waagan
Dag H. Wanvik wrote: Kristian Waagan kristian.waa...@sun.com writes: [1] https://issues.apache.org/jira/browse/DERBY DERBY-? The issue number fell out here? Not really, I just didn't remember the issue number off the top of my head

Re: Weird

2009-04-16 Thread Kristian Waagan
John Whitt wrote: please remove me from this group Please see http://db.apache.org/derby/derby_mail.html Regards, -- Kristian ] [ snip ]

Re: master and slave are not in synch for replicated database

2009-04-13 Thread Kristian Waagan
Philip Rossomando wrote: I have long been a silent member of this group but I now need help. The following code was written by me to insert a Blob into the DB. public void insertImage(BufferedImage image) { try { byte[] bytes =

Re: ClientDataSource in OSGi

2009-03-25 Thread Kristian Waagan
, feel free to log a Jira issue at https://issues.apache.org/jira/browse/DERBY Thank you for your feedback! Regards, -- Kristian JJ Kristian Waagan wrote: JJ Snyder wrote: Hi, I am running Equinox standalone and have installed and started the derby bundle (derby.jar). I am able to access

Re: ClientDataSource in OSGi

2009-03-24 Thread Kristian Waagan
JJ Snyder wrote: Hi, I am running Equinox standalone and have installed and started the derby bundle (derby.jar). I am able to access the EmbeddedDataSource from another bundle successfully. I then install and start the derbyclient.jar as a bundle but when I try to access the

Re: How to configure Derby/java DB on opensolaris for remote access

2009-03-23 Thread Kristian Waagan
Jan Lagerpusch wrote: Hi, I am not sure whether this belongs to the derby or to the opensolaris/SMF mailing list, but I’ll give it a try here: I am desperately trying to enable remote access to the SUNWjavadb (coming with GlassFish) on an x86 openSolaris (2008.11) system. I would like to

Re: Problem with DELETE on big table

2009-03-23 Thread Kristian Waagan
Emmanuel Cecchet wrote: Hi Kristian, I used the default heap size for Sun JRE 1.6.0 update 7 for Windows. I did tests with -Xmx1g and the problem persists but it takes much longer (hours). The table is pretty simple, only INT, BIGINT and VARCHAR(16), but it is very large (100 million rows).

Re: Configuration

2009-03-19 Thread Kristian Waagan
Fernando Freitas wrote: Hello again, somebody knows? 1) How could I use some file xml or another configuration file configure the database, like to choose the place that I will create my Database's instance.? Hi Fernando, You could set the Java system property derby.system.home, or use

Re: SQLException: Page could not be read from disk

2009-03-11 Thread Kristian Waagan
Maris Orbidans wrote: Sometimes insert fails with error message saying that a page could not be read from disk. We can't reproduce it but it has happened 3 times. Any ideas what can cause this problem? Hello Maris, Just a shot in the dark, but is there code in your software stack that calls

Re: Problem with DELETE on big table

2009-03-10 Thread Kristian Waagan
Emmanuel Cecchet wrote: Hi Kathey, I re-checked derby.log and there was an OOM error. Hello Emmanuel, Do you know the maximum allowed size of the heap and the page cache size used when the OOME occurred? Also, have you overridden the page size, or are you using Blob/Clob in your tables?

Re: How to read blobs?

2009-03-06 Thread Kristian Waagan
epdv wrote: Kristian Waagan schrieb: epdv wrote: Thank You for the answer - but I've also got problems with autocommit(false): Recordset not open. How can I get the InputStream then, and can I access the opened InputStream independently from the blob, i.e. can I read the stream still after

Re: How to read blobs?

2009-03-05 Thread Kristian Waagan
epdv wrote: Hello! I want to read blobs in a loop (more exact: the length of the blobs). I'm using a connection with autocommit(true) and a prepared statement with sth. like select mydata, myblob where mykey=?. Then I'm using the following loop: while (rs.next()) { int m =

Re: generated always as identity

2009-03-05 Thread Kristian Waagan
George H wrote: Have you tried setting the start and increment values of the identity statement like GENERATED ALWAYS AS IDENTITY(START WITH x, INCREMENT BY y ) where x is the last auto_increment number from mysql and y is well the step number to increment by. -- George H george@gmail.com

Re: How to read blobs?

2009-03-05 Thread Kristian Waagan
epdv wrote: Thank You for the answer - but I've also got problems with autocommit(false): Recordset not open. How can I get the InputStream then, and can I access the opened InputStream independently from the blob, i.e. can I read the stream still after freeing the blob? You can operate on

Re: inserts slowing down after 2.5m rows

2009-03-03 Thread Kristian Waagan
Brian Peterson wrote: I thought I read in the documentation that 1000 was the max initial pages you could allocate, and after that, Derby allocates a page at a time. Is there some other setting for getting it to allocate more at a time? Another question is why the maximum is set to 1000

Re: unsubscribe

2009-02-16 Thread Kristian Waagan
Stavros Kounis wrote: Hello Stavros, To unsubscribe from the Derby list(s), you have to send a mail to the correct address. Please see http://db.apache.org/derby/derby_mail.html I copied you on the CC list. Regards, -- Kristian

Re: 10.4.2.1 doesn't solve ORDER BY problem

2009-02-08 Thread Kristian Waagan
Geoff hendrey wrote: I built from source, and also ran the sysinfo command on the 10.4.2.1 jar that I got from sun. Both yield identical information, indicating 10.4.2.1 is the build. See output below from running sysinfo against the sun downloaded jars. Hi Geoff, Looking at the

Re: is it possible to create a schema at connection time?

2009-02-03 Thread Kristian Waagan
DerbyNoob wrote: Ok here is my scenario: I have two java applications, which are going to use the same database (embedded as a derby server), but with 2 different schemas. I want each application to use its own schema. Currently a application connects to the database like this: connect

Re: Can an embedded Derby connection support multiple simultaneous result sets?

2009-02-03 Thread Kristian Waagan
John T. Dow wrote: On Tue, 03 Feb 2009 08:58:28 +0100, Kristian Waagan wrote: John T. Dow wrote: On Mon, 02 Feb 2009 17:10:52 +0100, Knut Anders Hatlen wrote: John T. Dow j...@johntdow.com writes: [ snip ] try { Statement s1 = jdbcConn.createStatement

Re: 'updateString' not allowed because the ResultSet is not an updatable ResultSet

2009-02-02 Thread Kristian Waagan
John T. Dow wrote: I get this error message: 'updateString' not allowed because the ResultSet is not an updatable ResultSet. It happens after creating a result set with this query: select * from orders where (orders.recordno = (select max(orders.recordno) from orders)) --snip-- Hi John,

Re: Can an embedded Derby connection support multiple simultaneous result sets?

2009-02-02 Thread Kristian Waagan
John T. Dow wrote: On Mon, 02 Feb 2009 17:10:52 +0100, Knut Anders Hatlen wrote: John T. Dow j...@johntdow.com writes: [ snip ] try { Statement s1 = jdbcConn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); Statement s2 = jdbcConn.createStatement(

<    1   2   3   4   >