Listing all databases which are active

2010-07-08 Thread Daniel Noll
down? Alternatively, is there some way to embed Derby's server which will do this automatically? Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced Nuix

Re: Filtering using the sort order on two columns

2009-08-04 Thread Daniel Noll
ar superior to doing each query separately as I don't need to keep track of how many items I got from the first query. The performance is basically identical. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer

Re: Filtering using the sort order on two columns

2009-08-04 Thread Daniel Noll
number, but I can at least cache some 100 or 1,000 and then avoid the next 99 queries. The generated column idea offered by Rick isn't bad either, but it will double storage requirements versus doing the concatenation manually, or versus this trick. Daniel -- Daniel Noll

Filtering using the sort order on two columns

2009-08-03 Thread Daniel Noll
e data in index order, starting from a given point... so I figure there is a simple solution. Daniel -- Daniel Noll                            Forensic and eDiscovery Software Senior Developer                              The world's most advanced Nuix                              

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

2009-05-14 Thread Daniel Noll
write a custom store implementation to do this. Since there is a store which can read from a jar file instead of a file, I figure it must be possible to make a store which virtualises file paths instead of taking absolute ones. Daniel -- Daniel NollForensic and

Re: How to insert new column in front of exsiting column?

2009-05-13 Thread Daniel Noll
plication which reads the database metadata and automatically generates a form based on the columns present in the table? Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world'

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

2009-05-13 Thread Daniel Noll
ould be another solution to the problem, but it's a pretty steep hill. I just thought I would throw the question out there because a simple API which takes a path and returns a path would have been an elegant solution, even if it were buried deep in the server code. Dan

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

2009-05-12 Thread Daniel Noll
ely merging together all these directories. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced Nuixemail data

Re: SQLException: Page could not be read from disk

2009-03-11 Thread Daniel Noll
the older implementation though. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced Nuixemail data analysis http://nui

Order the results, *and* slice them

2009-03-05 Thread Daniel Noll
< ? Both of these give an error at ORDER BY. Am I doing something wrong, or is this a missing part of the ROW_NUMBER() feature? Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The worl

Re: How many DRDAConnThreads is reasonable?

2009-02-26 Thread Daniel Noll
as network server is running. You can still start network server and connect with client from other jvms with client, but there is no reason not to use embedded within the same jvm. In this instance they're all in different VMs (on different computers.) Daniel

How many DRDAConnThreads is reasonable?

2009-02-26 Thread Daniel Noll
ome way to reduce the number of raw store deamons.) Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced Nuixemail data analysis

Re: How are we supposed to use Blob.getBinaryStream(long, long) ?

2009-02-16 Thread Daniel Noll
I'll open some bugs. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced Nuixemail data analysis http://nuix.com/

How are we supposed to use Blob.getBinaryStream(long, long) ?

2009-02-15 Thread Daniel Noll
p, due to Derby's read(byte[],int,int) returning 0 at EOS instead of -1. I assume that this last bit is a bug -- everything above this paragraph appears to be an error in the JDBC API itself, which Derby has blindingly followed, leading to a nearly useless method. -- Daniel Noll

Moving/copying BLOBs from one table to another

2009-02-08 Thread Daniel Noll
Derby create a second copy of the BLOB (undesirable) or will it create a reference to the *same* BLOB? Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced

Derby and handling of exceptions / errors

2009-01-13 Thread Daniel Noll
appears to catch situations I'm seeing in the logs, but is it okay to assume that the OOMEs and such will only be one level deep inside the exception hierarchy? Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer T

Re: JDK 1.4 support?

2008-11-24 Thread Daniel Noll
Dag H. Wanvik wrote: Derby doesn't enforce JDK 1.4 It does at compile-time. Admittedly I haven't tried setting jdk14.home to point to jdk6. :-) Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The wo

Re: IndexOutOfBoundsException from client driver during getBlob

2008-11-09 Thread Daniel Noll
e is normal as well. I guess I can run a test overnight to see if something similar happens, with tracing turned on. It's going to generate a lot of output though so I somewhat fear for my disk space. :-) Daniel -- Daniel NollFore

Re: IndexOutOfBoundsException from client driver during getBlob

2008-11-05 Thread Daniel Noll
rievals are being done in a separate transaction, which makes that last claim even more perplexing, unless the client reconnected in the meantime and we simply weren't told. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer

Re: Embedded database which only stores data in memory?

2008-11-04 Thread Daniel Noll
off reliability features? (not important for tests) - Anything else? Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced Nuixemail data anal

Re: IndexOutOfBoundsException from client driver during getBlob

2008-11-04 Thread Daniel Noll
Kristian Waagan wrote: Daniel Noll wrote: Hi all. Has anyone seen an exception similar to the following, coming from a call to getBlob()? Hi, Yes, I've seen it before, but only with 10.3.2.1 and earlier. The repro I have, which is very similar to the code you posted, doesn't t

IndexOutOfBoundsException from client driver during getBlob

2008-11-03 Thread Daniel Noll
I can't find a bug along these lines. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced Nuixemail data analysis http://nuix.com/

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

2008-10-27 Thread Daniel Noll
;s the current best workaround for the k..(2k-1) problem as far as I know) but I haven't noticed the same thing with setMaxRows. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The w

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

2008-10-27 Thread Daniel Noll
..(2k-1). Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced Nuixemail data analysis http://nuix.com/and eDisc

Re: How to efficiently check for existence of a row?

2008-10-19 Thread Daniel Noll
checking rs.next()? setMaxRows(1) should theoretically speed it up, but I haven't noticed performance issues which would justify setting it. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's mos

Re: How to store values that might be given in different measurement units?

2008-10-15 Thread Daniel Noll
formatting well enough, and it guarantees no loss in precision. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world's most advanced Nuixemail data analysis

Re: Client/server plus network storage of database files

2008-09-25 Thread Daniel Noll
e some way it can do it at the Network Server level, or do we have to shut down the entire Network Server and all its embedded databases to do it at our own level? Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer

Re: Client/server plus network storage of database files

2008-09-24 Thread Daniel Noll
still applies -- clients aren't connecting to the shared database, they're connecting to the network server and the network server is connecting across a network. Why is it connecting across a network? Because locally attached disks aren't big enough. Daniel

Re: Client/server plus network storage of database files

2008-09-22 Thread Daniel Noll
d SMB? Or generally any network protocol which happens to buffer? But directly connected disks also buffer, so presumably it isn't that last option. Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer The world&

Client/server plus network storage of database files

2008-09-18 Thread Daniel Noll
nd in unusable state. Or is a better solution to make the store layer more aware that these problems can be temporary? Daniel -- Daniel NollForensic and eDiscovery Software Senior Developer

Re: cannot invoke other java.sql.Clob

2008-07-22 Thread Daniel Noll
rticular ones we allow for 1MB, but the actual amount of data on average is around 1kb at present. -- Daniel Noll

Re: cannot invoke other java.sql.Clob

2008-07-21 Thread Daniel Noll
it off first. Sometimes this is inconvenient, but can't be avoided. We don't have autocommit turned on either. Or rather, we explicitly turn it off after getting the connection. Daniel -- Daniel Noll

cannot invoke other java.sql.Clob

2008-07-21 Thread Daniel Noll
back. I can't appear to reproduce the issue at all on my own computer of course. Is it possible there is a bug in Derby itself which only occurs in some situations? I mean, we're just calling getString(), and I wanted to assume that internally it would manage the blob correctly. Daniel -- Daniel Noll

Re: ShutdownException when I haven't asked the database to shut down

2008-06-09 Thread Daniel Noll
On Tuesday 10 June 2008 02:33:47 Dag H. Wanvik wrote: > Daniel Noll <[EMAIL PROTECTED]> writes: > > If this is the case, is there some way to *know* when the database > > shutdown has actually occurred? > > Normally, if a VM tries to boot a Derby database which is alr

ShutdownException when I haven't asked the database to shut down

2008-06-05 Thread Daniel Noll
Hi all. I'm getting a load of errors like this. They seem to happen at random times; sometimes I see it when creating a statement, sometimes when executing, sometimes when iterating over a result set. Once I even had it happen when creating the connection itself, which is hard to believe. Cause

Re: top N reporting with derby

2008-05-14 Thread Daniel Noll
On Thursday 15 May 2008 01:12:21 Six Fried Rice wrote: > You can write your query like this: > > SELECT ROW_NUMBER() OVER() as rownum, spool_table.* FROM spool_table > ORDER BY date_inserted WHERE rownum <= 100 > > And it should do the trick. This requires Derby 10.4. This is quite interesting. I

Re: 10.4.1.3: 'SYSIBM.CLOBRELEASELOCATOR' is not recognized as a function or procedure.

2008-05-02 Thread Daniel Noll
On Friday 02 May 2008 16:38:31 Daniel Noll wrote: > Further information: When running 10.3.1.4 on the client, the error does > not occur (even though the server is still 10.4.1.3.) > > As I can't reproduce it with a database created on 10.3.1.4, it could be > that the database

Re: 10.4.1.3: 'SYSIBM.CLOBRELEASELOCATOR' is not recognized as a function or procedure.

2008-05-01 Thread Daniel Noll
Further information: When running 10.3.1.4 on the client, the error does not occur (even though the server is still 10.4.1.3.) As I can't reproduce it with a database created on 10.3.1.4, it could be that the database itself is older than that, so I'm currently working back through the versions

10.4.1.3: 'SYSIBM.CLOBRELEASELOCATOR' is not recognized as a function or procedure.

2008-05-01 Thread Daniel Noll
Hi guys. I have a situation where a database created under an earlier version of Derby causes errors when iterating over a result set which contains a CLOB column. Here's what is seen from the client: Caused by: org.apache.derby.client.am.SqlException: 'SYSIBM.CLOBRELEASELOCATOR' is not recogn

AssertFailure; Wrong LogInstant on log record

2008-04-17 Thread Daniel Noll
Hi guys. Does anyone know the cause for errors like this: > org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED Wrong > LogInstant on log record (396,151494700) version real position (396,499756) And is there a way to recover if it occurs? Daniel

Re: Question about Embedded Derby

2008-03-27 Thread Daniel Noll
On Friday 28 March 2008 13:21:52 Kai Ponte wrote: > First you might want to stop top posting. It makes things hard to read. > Second you might want to upgrade from Wintendo to a real OS. Hey now, don't say things like this, it's not fair to Nintendo. Daniel

Re: NPE getting length of Blob

2008-03-04 Thread Daniel Noll
On Wednesday 05 March 2008 13:54:19 Raymond Kroeker wrote: > Hi Daniel, > > What appears to be happening is that the same connection is being > returned by getConnection2(). Basically the implementation of the pool is > not thread safe. I thought reusing the connection was the entire point of

Re: NPE getting length of Blob

2008-03-04 Thread Daniel Noll
On Wednesday 05 March 2008 12:43:44 Raymond Kroeker wrote: > Hi Daniel, > Which pool/version are you using? Also how are you configuring the > pool? You want to make sure your library is wrapping the connection or > if not; is interfacing with the pooled connection/data source object. Data

Re: NPE getting length of Blob

2008-03-04 Thread Daniel Noll
On Tuesday 04 March 2008 22:36:17 Narayanan wrote: > I have tried getting a blob from a result set and tried the length() > method on it after the following Scenarios > > 1) Closing the connection The underlying problem must be something to do with Connection reuse. We discovered that am.Prepare

Re: NPE getting length of Blob

2008-03-04 Thread Daniel Noll
On Tuesday 04 March 2008 21:14:43 Narayanan wrote: > Can you give more information about the code that uses this? It looks like this. I've omitted some of the code which was present as it was calling framework methods anyway. private long id; public int read(byte[] b, int off, int len) { Con

NPE getting length of Blob

2008-03-03 Thread Daniel Noll
Hi all. I have someone seeing the following error under both 10.3.1.4 and 10.3.2.1: java.lang.NullPointerException at org.apache.derby.client.am.PreparedStatement.setIntX(Unknown Source) at org.apache.derby.client.am.CallableLocatorProcedures.blobGetLength(Unknown Source)

Re: Using derby as a chat server

2008-02-17 Thread Daniel Noll
On Thursday 14 February 2008 02:18:54 Kurt Huwig wrote: > Forget about Derby for chat and have a look at JMS. This is a good > implementation: > > http://joram.objectweb.org/ Or use something actually designed to be a chat server, such as Openfire. Daniel

Re: COUNT() optimisation

2008-02-10 Thread Daniel Noll
On Saturday 09 February 2008 06:30:05 Army wrote: > Can you can provide a simple example to demonstrate the behavior that > you are seeing? I tried playing around with some simple (nonsense) > tables but I wasn't able to come up with anything that sounds like what > you are describing. > > Are you

COUNT() optimisation

2008-02-07 Thread Daniel Noll
Hi all. COUNT() is constant performance if you count all the rows in a table, but linear performance if you have a condition on which rows should be counted. Is there any way to optimise the latter case? I know that indexing on the columns used in the query doesn't work. Daniel

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

2008-02-05 Thread Daniel Noll
On Wednesday 06 February 2008 04:00:26 Eric Floehr wrote: > All, > I'm experiencing a NullPointerException (somewhat random) apparently > within the Derby JDBC driver (stack trace below), and am wondering if > anyone has any suggestions on finding the root cause. I am using Derby > 10.3.2.1 (thoug

Nested query in conjunction with ordering - unreasonably slow

2008-02-03 Thread Daniel Noll
Hi all. I've been trying to determine the cause for a slowness in a certain query. I've managed to strip everything away and get to the core of what's making it slow, but I'd like to understand why. The query is of this form: SELECT jobs.id AS id, jobs.name AS name, (SELEC

Re: Determine which child table a record belongs to

2008-01-29 Thread Daniel Noll
On Wednesday 30 January 2008 05:28:14 Craig L Russell wrote: > The alternative is to include all possible tables in a query, which is > performance-limiting. Another alternative is to use single table inheritance, where you still have a type column but also put every field from every class into t

Re: Network protocol error in prepareStatement()

2007-11-12 Thread Daniel Noll
On Tuesday 13 November 2007 11:24:52 Kathey Marsden wrote: > Daniel Noll wrote: > > This is embedded in an application though so changing the connection > > properties isn't going to be easy, but do you think changing the system > > property derby.drda.debug to true on

Re: Network protocol error in prepareStatement()

2007-11-12 Thread Daniel Noll
On Tuesday 13 November 2007 04:22:18 Bryan Pendleton wrote: > > I'm getting this unusual exception during prepareStatement(): > > Hi Daniel, > > This could possibly be due to a bug in Derby. Can you reproduce > the problem? If so, can you gather more information? Here is > a wiki page which provide

Network protocol error in prepareStatement()

2007-11-11 Thread Daniel Noll
Hi all. I'm getting this unusual exception during prepareStatement(): Caused by: org.apache.derby.client.am.DisconnectException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condit

ERROR XSDG3: Meta-data for Container... -- Is this database corrupt?

2007-11-11 Thread Daniel Noll
Hi all. I had an error opening a database and the logs showed the following error (I've truncated out the common parts of the two exceptions, if more are needed I can post it somewhere that it won't cause a flood. ERROR XSDG3: Meta-data for Container [EMAIL PROTECTED] could not be accessed

Re: Server: deny connection to directories outside of known directories

2007-11-06 Thread Daniel Noll
On Tuesday 06 November 2007 20:02:04 Vemund Ostgaard wrote: > Daniel Noll wrote: > > Hi all. > > > > Is there some way for the Derby server to allow custom code to determine > > whether a directory can be opened for a database? I read something about > > a policy

Server: deny connection to directories outside of known directories

2007-11-05 Thread Daniel Noll
Hi all. Is there some way for the Derby server to allow custom code to determine whether a directory can be opened for a database? I read something about a policy file but that doesn't really suit our use case as the list of directories can be changed by the admin at runtime. Daniel

Derby, connection pooling and shutdown

2007-10-04 Thread Daniel Noll
Hi all. At present I'm using Connection directly. After I close it, if it's the last connection open to the database I am doing a ;shutdown=true to force Derby to properly close it. Now I'm changing things to use connection pooling to make things go smoother when multiple threads want to do q

Derby and string storage details

2007-09-09 Thread Daniel Noll
Hi all. If I have 1,000 of the same string in a table for some reason, is the string stored 1,000 times, or is it only stored once? Daniel

Re: Sum of time

2007-07-17 Thread Daniel Noll
Out of curiosity, what happens if you add this int to the Time 00:00:00? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902

Re: Any problems to run derby in USB drive ?

2007-07-15 Thread Daniel Noll
install SWT. :-) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902

Error opening the database

2007-07-04 Thread Daniel Noll
ource) at > org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) > at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) The database was supposedly being accessed over SMB, but I have been assured that there was only one process connected to it the entire time (checked for stale processes just in case there was one still holding a lock.) But from web searches I get the feeling that this really is some kind of corruption so if that's the case I need to know how I can fix it. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902

Re: How delete rows in table with free disk space?

2007-07-03 Thread Daniel Noll
y:GenoCensusMin2"); Statement stat = > connect.createStatement(); > stat.executeUpdate("DELETE FROM Project WHERE id="+idProjet);" > > But disk space size of my system directory is the same before and after > the deletion. > > Can you help me? Have you tried usi

Re: Unusual network utilisation

2007-06-11 Thread Daniel Noll
On Tuesday 12 June 2007 11:59:11 [EMAIL PROTECTED] wrote: > Hi Daniel, > > Can you pls mention the Derby version you are using ? It appears to be 10.2.2.0. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http:/

Unusual network utilisation

2007-06-11 Thread Daniel Noll
0MB blob. I haven't experienced this problem ever myself, but we've had a report like this come in so I'm wondering if there is some kind of reasonable explanation. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 06

Re: license

2007-05-27 Thread Daniel Noll
is is clearly one way to make a mixed GPL/LGPL product -- change the licence on all LGPL components to GPL. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902

Re: ERROR XSAI2: The conglomerate requested does not exist.

2007-05-13 Thread Daniel Noll
On Monday 14 May 2007 10:04:33 Daniel Noll wrote: > I'll see if I can get access to the derby.log file. Okay, now I have derby.log and the same error occurs twice. Once on checkpoint, but it also happens earlier when trying to do a real query (figures.) Here's the lines whic

Re: ERROR XSAI2: The conglomerate requested does not exist.

2007-05-13 Thread Daniel Noll
he things customers consistently fail at is that they go and haphazardly modify the permissions on files without knowing what will happen, rather than just blocking access to the top-level directory entirely, resulting in a directory with mixed permissions. :-/ Daniel -- Daniel Noll Nuix Pty Ltd Suite

ERROR XSAI2: The conglomerate requested does not exist.

2007-05-10 Thread Daniel Noll
exactly? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902

Re: give me derby gui link (how i add new table in derby

2007-05-03 Thread Daniel Noll
anyway, so you might as well just write the SQL. :-) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for the named recipient. If y

Re: Problems running JavaDB on Windows

2007-03-26 Thread Daniel Noll
that your scripts do not allow spaces in the directory names. But spaces are legal. What gives? You'll need to edit the batch file to put quotes around anything which might have spaces. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280

Re: Large multi-record insert performance

2007-03-18 Thread Daniel Noll
I need to rerun these tests with a networked database but setting that up isn't as trivial as a unit test. :-) Also the benefits of doing it for networked mode probably vary greatly depending on the network itself. Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Austral

Re: Large multi-record insert performance

2007-03-18 Thread Daniel Noll
actually contain this all automatically, we have a utility method which we call and pass a callback to, which handles the transaction for us so that we don't need to do commit/rollback everywhere. (The method also handles retries if something bad happens.) Daniel Noll Nuix Pty Ltd Suite 7

Re: Large multi-record insert performance

2007-03-18 Thread Daniel Noll
n the same test a few thousand times and take an average, before telling whether batching is really slower or faster. Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This me

Re: Large multi-record insert performance

2007-03-15 Thread Daniel Noll
meaningless without redoing the same test on your own application. Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you

Re: unique columns must be nullable ?

2006-12-12 Thread Daniel Noll
to migrate anything. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient y

Re: SQL for inserting BLOB data?

2006-11-28 Thread Daniel Noll
then put that binary data into the BLOB column. Inserting byte[] is allowed. Inserting Blob is possible too... but AFAIK there is not actually any method of creating one. (I asked about this a while back and can't remember getting any responses to the question. :-/) Daniel -- Daniel

Re: Derby data types

2006-11-28 Thread Daniel Noll
rticularly clean with how it embeds SQL.) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not th

Re: Using Derby as a binary store

2006-11-28 Thread Daniel Noll
files to store the data. It turned out to be more efficient to use SQL to store them because the glut of smaller files caused issues on NTFS. But I consider NTFS to be a legacy filesystem. On modern filesystems like ReiserFS, it would probably be quite efficient. Daniel -- Daniel Noll Nuix

Re: Date - Timestamp format for inserts?

2006-11-21 Thread Daniel Noll
;t immediately obvious, it's also possible to reuse that PreparedStatement (in fact it's recommended, if you're calling the statement multiple times.) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/

Re: Date - Timestamp format for inserts?

2006-11-19 Thread Daniel Noll
nk Systems, Inc.',NULL,'Marl',NULL,'Atkins',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL ,NULL,'marl','marl',0,1,'2006-09-10-00',1,'2050-01-01-00' ) Is there any particular reason you're not doing this the normal way? (i.e. usi

Re: maximum file size

2006-11-12 Thread Daniel Noll
(one such reason might be that they want to use the same filesystem from another OS.) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only

Re: does Derby has some form of performance problem ?

2006-11-05 Thread Daniel Noll
in a whole second coffee. ;-) The other side of the coin is that when a user opens a case which happens to contain 20 databases, it may take a *very* long time. But at the same rate, HSQLDB really isn't capable of maintaining databases as big as we encounter anyway. Daniel -- Daniel

Re: does Derby has some form of performance problem ?

2006-11-05 Thread Daniel Noll
.PS... This H2 thing is new to me. I wonder what it's like at handling tens of gigabytes of data.) -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902 This message i

Re: Startup time for Derby

2006-07-27 Thread Daniel Noll
a database as a kind of document which the user can load, and it means increased time to load the document from the user's point of view. HSQLDB in comparison was instantaneous. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 069

Re: "generated by default" question

2006-06-15 Thread Daniel Noll
x and min should already be in-memory. I take it that Derby doesn't do this? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902 This message is intended only for

Re: "generated by default" question

2006-06-15 Thread Daniel Noll
e problem would be what to do when two users tried to insert rows at around the same time. The second would fail to commit the transaction and have to try again. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 06

Strange assert failure, should I be worried?

2006-06-08 Thread Daniel Noll
pper.java:91) at com.nuix.store.binary.DatabaseBinaryStore$StoredInputStream.read(DatabaseBinaryStore.java:413) So should I be worried about this kind of error? It's the first time I've ever seen one, and viewing the same data over and over doesn't seem to reproduce the problem. D

Creating a Blob

2006-05-18 Thread Daniel Noll
this (if at all.) Does Derby have a "secret" way to create a Blob object? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902 This message is intended onl

Re: setBinaryStream

2006-05-12 Thread Daniel Noll
ure request for that one -- it would be the best JDBC enhancement ever made, IMO. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902 This message is intended only for

Re: Can I embedded Derby Dabase in Webapplication

2006-02-16 Thread Daniel Noll
with distributing any other jar file with your application. Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient yo

Re: how to package derby in java application?

2006-01-17 Thread Daniel Noll
me i 'm in urgent need. You would do it in the same way you would include any other JAR file with your application. Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is intended only for

Re: running ij from the command line

2006-01-12 Thread Daniel Noll
ndows, colon on everything else (the class path is formatted similarly to the PATH environment variable, which also follows this rule.) Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is int

Re: Recursive Select for Discussion Forum

2005-11-30 Thread Daniel Noll
aniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance o

Re: Recursive Select for Discussion Forum

2005-11-29 Thread Daniel Noll
presumably have a discussion or thread table already. Selecting all messages in that discussion then becomes a trivial matter. Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the named recipient

Strange error: "ResultSet not open. Operation 'next' not permitted."

2005-11-23 Thread Daniel Noll
<-- This line did it. } finally { rs.close(); } Autocommit is indeed off, but regardless of that, we're not actually updating this database at any point in time, just reading data out of it to put it in another. Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 Yo

Unidentified error

2005-11-07 Thread Daniel Noll
best. Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action

Re: Garbage Collector and memory

2005-10-24 Thread Daniel Noll
s. And of course, this reuses the same statement, because creating multiple statements when you only actually need one is wasteful. Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the na

Spaces in the database name with the client driver

2005-10-11 Thread Daniel Noll
d for this issue? As it's a URL we're supposed to specify, I tried using %20 but that didn't work anyway. I also tried modifying the URL parsing code in the ClientDriver class but that results in a network protocol error. Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Stree

  1   2   >