Hi, guys. I keep getting this random exception on a database that *does*
exist and just a moment before my process was happily accessing.
Caused by: java.sql.SQLException: Database
'C:\Vontu\Protect\scan\incremental_index\MONITOR\TARGET_1' not found.
at
org.apache.derby.impl.jdbc.SQLExce
ny SQLException that is a
SQLTransientException?
Thanks,
David
On Thu, Sep 23, 2010 at 4:22 AM, Knut Anders Hatlen
wrote:
> David Van Couvering writes:
>
> > I am getting the following deadlock? One of the locks does not have
> > a user or SQL associated with it. What should I
I am getting the following deadlock? One of the locks does not have a user
or SQL associated with it. What should I be looking for when a lock is
described in this way?
Lock : ROW, FILTERS_FOR_DELIVERY, (3,1960)
Waiting XID : {271243, X} , VONTU, DELETE FROM FILTERS_FOR_DELIVERY WHERE
ITEMSET_
Certain people, on certain machines, keep getting the exception "Database
not found." The same database previously was successfully opened and then
shut down. The shut down happens on a different thread, but I actually have
written a class that serializes access to the database so that no other
t
Thanks, Knut! It may be fine to stick with the defaults - I am
contemplating whether this is all that relevant for our customers, versus
just something that our QA team found working with smaller data sets...
On Tue, Aug 24, 2010 at 7:32 AM, Knut Anders Hatlen
wrote:
> David Van Couver
Yea, that makes sense. If this were the case, would forcing checkpoints
help the situation? Can you configure checkpoint frequency, or the maximum
size of the log?
Thanks,
David
On Mon, Aug 23, 2010 at 4:17 PM, Mike Matrigali wrote:
> David Van Couvering wrote:
>
> It will probably
AM, David Van Couvering <
da...@vancouvering.com> wrote:
> Hi, all. I have a test that updates 100 rows, each of which contains an
> int primary key and a 300-byte BLOB:
>
>
>
> --
> David W. Van Couvering
>
> http://www.linkedin.com/in/davidvc
> http://d
Hi, all. I have a test that updates 100 rows, each of which contains an int
primary key and a 300-byte BLOB:
--
David W. Van Couvering
http://www.linkedin.com/in/davidvc
http://davidvancouvering.blogspot.com
http://twitter.com/dcouvering
I get this when there is already a directory with that name. If you see the
"next exception" you'll probably see that it says the directory already
exists.
David
On Thu, Aug 12, 2010 at 3:12 AM, darie17 wrote:
>
> Hello,
>
> I'm using Derby as an embedded DB in my Java app. Well, everything wo
stian Waagan <
kristian.waa...@oracle.com> wrote:
> On 12.08.10 01:07, David Van Couvering wrote:
>
> Looks like it was a slash/forward-slash issue. I changed my code to use
> File.separator and this very strange bug (it would only happen sometimes,
> and only on some machines) l
:55, David Van Couvering wrote:
>
> I am getting these intermittent errors that I can't reproduce on my
> machine:
>
> Database
> 'C:\VontuDev\main\dist\scan\incremental_index/MONITOR/INCREMENTAL_INFO' not
> found
>
>
> I read the docs, and there is no
I am getting these intermittent errors that I can't reproduce on my machine:
Database 'C:\VontuDev\main\dist\scan\incremental_index/MONITOR/INCREMENTAL_INFO'
not found
I read the docs, and there is no discussion about whether a mixed "\" "/"
path is a problem on some systems. Could it be? Do
OK, thanks. I'll work to ensure that I only shut down a database that is
currently up, just to keep my life simple and the log empty of kruft.
David
On Mon, Aug 2, 2010 at 12:51 AM, Kristian Waagan wrote:
> On Fri, Jul 30, 2010 at 02:30:34PM -0700, David Van Couvering wrote:
> >
Do I have to worry about ensuring that a database is running before I try to
shut it down, or is it OK to get a connection with URL ";shutdown=true" on a
database that's not booted.
If I were to do that, does it boot the database and then shut it down again,
or does it do nothing?
Thanks,
David
OK, thanks, very useful.
David
On Wed, Jul 21, 2010 at 1:56 PM, Mike Matrigali wrote:
> David Van Couvering wrote:
>
>> Thanks, Mike
>>
>> I am doing some of that, and am looking into doing more of that.
>> But it's more than possible that I'll h
Gads, I'm out of it today. Thanks, *Bryan*, not Mike...
On Tue, Jul 20, 2010 at 8:34 PM, David Van Couvering wrote:
> Thanks, Mike
>
> I am doing some of that, and am looking into doing more of that.
>
> But it's more than possible that I'll have a lot of open, *
Thanks, Mike
I am doing some of that, and am looking into doing more of that.
But it's more than possible that I'll have a lot of open, *active*
databases.
We're talking a lot of data, potentially 10s of GB of BLOBs. I was
concerned a single Derby DB would not be able to handle this well, so I
Hi, all. Could you point me to a page, or just tell me, what configuration
settings I can tweak to reduce the overall memory footprint of a booted
Derby database. Losing performance is pretty much OK, this is not a
time-critical part of our code, but I have a lot of databases open and it's
impact
FYI, I was able to reproduce this amazingly easily. I created DERBY-4733.
Please let me know as soon as you can your sense of how long it would take
to fix. We're about to enter beta and I really would like to know my
options here.
Thanks!
David
--
David W. Van Couvering
http://www.linkedin
On Mon, Jul 5, 2010 at 11:52 PM, Kristian Waagan wrote:
> On 06.07.10 08:23, David Van Couvering wrote:
>
>> Hi, all. I seem to have a repeatable issue where my database is getting
>> corrupted, and I can only assume it's happening when the table is getting
>> cre
Hi, all. I seem to have a repeatable issue where my database is getting
corrupted, and I can only assume it's happening when the table is getting
created, because I know Derby is great on handling crashes during normal
operation.
First of all - is it true that a Derby database can get corrupted i
Hm, OK, thanks for the tip, it's good to know what direction to look into.
I'm not on that dev machine now, and I have to see what Eclipse is using,
but it's a version of Java 6 on XP.
David
On Sat, Jun 19, 2010 at 7:38 AM, Kathey Marsden wrote:
> On 6/18/2010 8:57 PM, D
I have a bunch of unit tests that I run as a suite. The first test that
tries to boot up the Derby database hangs, with the CPU spiked at 100%.
When I stop the process, here is where it is stuck, repeatedly (see stack
trace below).
When I run the same test by itself, it's slow to boot, but it do
Hi, all! When I use setMaxRows() in JDBC, I know it limits the number of
rows delivered through JDBC. I just wanted to confirm that when I use this,
Derby doesn't still scan through all rows and then deliver maxRows number of
rows to JDBC - that it only actually goes through the first N rows (ass
:
> On 06/15/10 12:42 AM, David Van Couvering wrote:
> > So, I have a couple of questions for you all:
> >
> > - Do the number of files held open by a database grow as the number of
> > rows in a table grows? Some of these tables will have millions of
> > records.
I am running a system that is opening a fairly large number of databases
within a single server environment. The problem is each database is keeping
open a certain number of files, and on some systems is causing failures from
too many open files.
I am trying to work around this by shutting down t
I didn't see the boot error, but I'll keep an eye out for that next time I
see it. It sounds like there's no workaround...
On Wed, Jun 2, 2010 at 11:35 PM, Knut Anders Hatlen wrote:
> On 06/ 2/10 09:34 PM, David Van Couvering wrote:
> > I am seeing this exception fairl
I am seeing this exception fairly regularly, does anyone know what I might
be doing to cause this?
Caused by: java.lang.NullPointerException
at java.io.StringReader.(StringReader.java:33)
at org.apache.derby.impl.services.uuid.BasicUUID.(Unknown Source)
at
org.apache.derby.impl.service
t statement error and subsequent queries may
> work. In all cases the system should recover fine after subsequent
> reboot, causing any transaction to back out that was in middle when the
> I/O failed.
>
>
> David Van Couvering wrote:
>
>> Hi, all. I am using Derby embedd
Hi, all. I am using Derby embedded in a server process. The server process
can receive a request to shut down, in which case it does an orderly
shutdown of all its services. This uses ExecutorService.shutdownNow(),
which sends an InterruptException to any task currently running. I am
looking at
Yep, it worked, thanks!
David
On Tue, May 11, 2010 at 7:09 AM, Dag H. Wanvik wrote:
>
> Hi David,
>
> David Van Couvering writes:
>
> > That looks interesting, but this appears to only be for error messages.
> Do
> > *all* derby.log messages get written to
n, May 10, 2010 at 4:22 PM, Dag H. Wanvik wrote:
> David Van Couvering writes:
>
> > I have a service that shuts down the Derby database after it is done
> using
> > it. This is because on Linux I was getting errors "too many open files"
> > unless I did this
I have a service that shuts down the Derby database after it is done using
it. This is because on Linux I was getting errors "too many open files"
unless I did this - I use a lot of databases, and when all of them are
booted it starts using up too many resources.
But now my problem is that every
it has to do an insert and to do the insert it
> needs the name of the file which only exists after the file is
> created.
>
> David Van Couvering wrote:
>
>> Yes, it does sound like a bug. I'll log a JIRA
>>
>> On Fri, Apr 30, 2010 at 6:50 PM, Bryan Pendleton
> I have not looked at the code but my guess is that create table is
> counting on a unique key violation to tell whether a table exists
> or not. To do this it has to do an insert and to do the insert it
> needs the name of the file which only exists after the file is
> created.
>
Yes, it does sound like a bug. I'll log a JIRA
On Fri, Apr 30, 2010 at 6:50 PM, Bryan Pendleton wrote:
> As I mentioned to Knut, I try to issue a CREATE TABLE each time I connect,
>> and ignore the exception saying it already exists if the table is already
>> there.
>>
>
> If this is leaking a
n't seem to get
removed.
Just goes to show me that I should not break my own rule to not depend on
exceptions to control non-exceptional behavior in my system. :)
David
On Fri, Apr 30, 2010 at 3:40 PM, David Van Couvering <
david.vancouver...@gmail.com> wrote:
> Yes, definitely, the n
therefore also no longer issue these spurious create table
statements.
I'll look into that, thanks, very good tip.
Fun chatting with you guys! :)
David
On Fri, Apr 30, 2010 at 3:30 PM, Kristian Waagan wrote:
> On 30.04.10 23:38, David Van Couvering wrote:
>
>> Hi, all.
>>
Note, however, it's when I get rid of the select statement that the database
growth stops. So it would seem that the transaction below is not the
culprit...
On Fri, Apr 30, 2010 at 3:32 PM, David Van Couvering <
david.vancouver...@gmail.com> wrote:
> Thanks, Knut, I'd f
Committing
On Fri, Apr 30, 2010 at 3:12 PM, Knut Anders Hatlen wrote:
> On 04/30/10 23:38, David Van Couvering wrote:
> > Hi, all.
> >
> > I have a thread that runs the following query every 10 seconds:
> >
> > SELECT d.ITEMSET_ID, f.FILTER_INDEX, FROM FILTERS f,
Another issue I'm seeing is, because I regularly shut down and then reboot
the database (this is to keep resource usage low), the derby.log file is
continually growing with shutdown/reboot messages.
The docs seem to indicate that the default should be that derby.log is
overwritten each time the da
Hi, all.
I have a thread that runs the following query every 10 seconds:
SELECT d.ITEMSET_ID, f.FILTER_INDEX, FROM FILTERS f, PENDING_DELIVERIES d
WHERE f.ITEMSET_ID = d.ITEMSET_ID AND f.FILTER_INDEX = d.FILTER_INDEX AND
d.SENT = 0 AND d.SERVER_ID = 1
The FILTERS table has about 200 rows in it,
Hm, I didn't see a "shutdown" method last time I looked. Oh, well, what do
you know, there it is! As usual, blind as a bat!
Thanks!
David
On Thu, Apr 22, 2010 at 10:56 PM, Knut Anders Hatlen wrote:
> On 04/23/10 01:08, David Van Couvering wrote:
> > Hm, I don't w
// shutdown Derby Network Server
> *DriverManager.getConnection("jdbc:derby:;shutdown=true");*
> }
> catch(SQLException se)
> {
> //ignore se
> }
>
> Just create a connection with a "jdbc:derby:;shutdown=true" url
>
>
> Maximo
>
> On Thu, Apr 2
Sorry if this is obvious, but I can't seem to figure it out. I know how to
start a network listener for an embedded database:
new NetworkServerControl().start(writer);
but how do you stop it? There is no stop method on NetworkServerControl...
Thanks!
David
--
David W. Van Couvering
http://
Yes, thanks, that should work!
David
On Wed, Apr 21, 2010 at 12:55 AM, Knut Anders Hatlen wrote:
> On 04/21/10 12:20 AM, David Van Couvering wrote:
> > I have two tables with columns a,b that together comprise the primary
> > key.
> >
> > In Oracle I can do something
I have two tables with columns a,b that together comprise the primary key.
In Oracle I can do something like DELETE FROM FOO WHERE (a, b) IN (SELECT
a, b FROM BAR WHERE MODIFIED = 1)
but in Derby this gives me a syntax error saying Error: Syntax error:
Encountered "," at line 1, column XX.
The
Hm, possibly. I can try the same thing using DriverManager.getConnection()
instead of a connection pool.
On Fri, Apr 9, 2010 at 1:10 AM, Knut Anders Hatlen wrote:
> On 04/ 8/10 09:00 PM, David Van Couvering wrote:
> > Hi, all. Don't ask me why, but I have a stress test tha
Hi, all. Don't ask me why, but I have a stress test that launches 100
simultaneous threads, all of which grab their own connection pool, and send
a CREATE TABLE command to the same Derby database. It ignores exceptions
saying the table is already created.
This works find on Windows. However, on
own") call. After this is complete you are
> shut down.
>
> On Tue, Apr 6, 2010 at 10:53, David Van Couvering
> wrote:
> > Hi, all.
> >
> > In my application environment I am using multiple databases, and when I
> have
> > no users of the database, I need
Hi, all.
In my application environment I am using multiple databases, and when I have
no users of the database, I need to shut it down, or I can run out of memory
or open files (I am maintaining a lot of databases).
But this is a multithreaded environment, and I could have another thread
immediat
You may not know that the original founders of Cloudscape came from Sybase -
a mortal enemy of Oracle. Rick was one of those Sybase folks - and now he
works for the Evil Empire. Spooky! :)
David
On Sat, Feb 6, 2010 at 1:45 PM, Peter Ondruška wrote:
> Nice history: Cloudscape, then acquired by
Yep, definitely can do that, thanks. I was just wondering if you had some
heuristics I could use.
On Fri, Feb 5, 2010 at 11:30 AM, Bryan Pendleton
wrote:
> But that's assuming a "perfect" layout for the database. I am wondering,
>> how much overhead should I account for?
>>
>
> My feeling is: t
Say I have a database with 1 million rows, each row has a BLOB column so can
vary in size from about 30bytes to 1MB, but averaging around 1K/row
There are two indexes - one for the primary key and a secondary index for
one integer column.
If I didn't account for overhead, I'd say that this would
In general we
> have rather looked at supporting both new and old types rather than pay
> a convert cost at upgrade time.
>
> /mikem
>
>
> David Van Couvering wrote:
>
>> Hi, all. Yes, I'm now using Derby within the product I'm working on in my
>> new jo
x. Space is returned to the operating system when a table or
> index is dropped.
> One needs to
> call the compress routines by hand to get a db to shrink.
>
>
> David Van Couvering wrote:
>
>> If I delete a bunch of rows from my database, does the size of the
>>
If I delete a bunch of rows from my database, does the size of the database
shrink, or does it keep the space it has allocated once I grow to a certain
size?
Thanks!
David
--
David W. Van Couvering
http://www.linkedin.com/in/davidvc
http://davidvancouvering.blogspot.com
http://twitter.com/dcou
Hi, all. Yes, I'm now using Derby within the product I'm working on in my
new job! :)
So, I have some questions. I'll send separate emails for each ones to keep
the threads simpler.
I could have quite a few rows in my table - perhaps up to 100 million. The
table will have about 5 columns. Do
---
> database
>
>
> 1 row selected
> ij> -- release the MySQL connection
> call setDatabaseURL( '', '' );
> 0 rows inserted/updated/deleted
>
> Hope this helps,
> -Rick
>
> Lan
Shouldn't Connection.getCatalog() return the name of the database you are
connected to, and shouldn't DMD.getCatalogs() return a result set with one
row, representing the database you're connected to?
This is causing us a bit of a headache when we're trying to inspect a Derby
database in NetBeans.
I noticed that if you try to create two indexes with different names on the
same column set that Derby silently ignores the command.
I can understand the rationale - it doesn't make sense to maintain two keys
against the same columns - they're the same key. But it would be useful to
say something
ption classes in JDBC 4
itself that are causing issues.
It's odd that nobody else has hit this yet - a *lot* of people are
running Derby inside J2EE containers on Java 6...
David
On Jan 14, 2008 2:32 PM, Johnny Kewl <[EMAIL PROTECTED]> wrote:
>
>
> - Original Message -
>
Hi, Derby folks. John is having trouble using Derby in a custom
classloader when running in Java 6. See the thread below. Is this a
known issue? Any ideas why this might be happening?
Thanks,
David
-- Forwarded message --
From: David Van Couvering <[EMAIL PROTECTED]>
You can also try NetBeans (shameless plug) :)
On Dec 11, 2007 8:23 AM, Jean T. Anderson <[EMAIL PROTECTED]> wrote:
> larsk wrote:
> > Does anyone know a great and free database manager software with GUI for
> > Java
> > DB/Apache Derby where I can create and open databases? Something like Mysql
>
AIL PROTECTED]> wrote:
> David Van Couvering wrote:
>
> > Very good! I'll write a blog linking to your source, people do want
> > to know how to do this.
>
> Yeah, I keep meaning to do that myself, I'll try to remember some of the
> tricks & tips and g
Very good! I'll write a blog linking to your source, people do want
to know how to do this.
David
On Nov 22, 2007 2:31 AM, Alan Burlison <[EMAIL PROTECTED]> wrote:
> David Van Couvering wrote:
>
> > It sure would be great if somebody wrote up a tutorial or blog or
>
ed message ------
From: David Van Couvering <[EMAIL PROTECTED]>
Date: Nov 21, 2007 4:38 PM
Subject: Re: [nbusers] netbeans 6.0 RC1 SQLSyntaxException: table/view
does not exist
To: [EMAIL PROTECTED]
Yes, that's right, there's no data there.
I think it may be time to write a bl
In terms of how you change your application, in general all you should
need to do is change the URL to be "jdbc:derby:dbname" from
"jdbc:derby:/server:port/dbname"
However, when you embed a database, the database is created based at
the location given by the Java system property "derby.system.hom
Very nice! Is Java DB embedded in the applet, or used solely on the
server side?
David
On Oct 31, 2007 2:41 PM, David Leader <[EMAIL PROTECTED]> wrote:
> I found the replies to my query interesting. I guess I need to ask my
> son why he favours SQLite. I much prefer to stick with a Java-based
>
Hi, all. I have just posted a survey to help us get some clarity on
what we should be focusing on for the next release of NetBeans. There
are particular features we just aren't sure how important they are.
It is very short, it should take no more than five or ten minutes, and
your input is quite
That is an annoyingly unhelpful exception "Failed to start database,"
but when I have seen it, often the cause is that somebody else already
has an embedded connection to the same database.
Anyone else know any possible causes for that error message?
David
On 10/8/07, Kevin Corby <[EMAIL PROTECT
arrow to execute the file
This way you don't have the potential of working with two databases when
you think you have one.
David
On 10/4/07, Daniel Noz <[EMAIL PROTECTED]> wrote:
>
> David Van Couvering schrieb:
>
> The other problem that can happen is that the tables
You can use Sequoia to do clustering on top of Derby, but Derby by
itself has no clustering or replication support.
There is ongoing work for the Derby 10.4 release to include support
for basic master/slave replication and failover.
Here is a good blog about setting up Sequoia with Derby (Java DB
The other problem that can happen is that the tables are created in a
different schema than the one that is used when you connect with NetBeans.
Notice that your connection in NB is labeled 'bb on APP'. That means it's
using the default schema, APP.
It's possible that your tables were created und
Oh, much better, thanks for the responses!
David
On 9/27/07, Thomas Nielsen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> There are four ODBC drivers listed on our wikipages
> http://wiki.apache.org/db-derby/UsesOfDerby
>
> One of which is the link Bryan found though Google.
>
> Thomas
>
> Bryan Pendl
Ouch. The silence is deafening...
ah, well...
On 9/26/07, David Van Couvering <[EMAIL PROTECTED]> wrote:
> Hi, all. IBM used to make an ODBC driver available for use with Derby.
> Is that still happening, or is that no longer supported?
>
> Thanks,
>
> David
>
Hi, all. IBM used to make an ODBC driver available for use with Derby.
Is that still happening, or is that no longer supported?
Thanks,
David
odil Replicator can handle
> the inter-machine communication issues.
>
> -JCT
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of David Van Couvering
> > Sent: Wednesday, 19 September 2007 03:17
> > To: Der
zation is something I hadn't realized before. Would
> synchronization be more appropriate for a
> peer-to-peer architecture than replication would be?
>
>
> David Van Couvering wrote:
> > I think the responses you have heard so far talk about replication to
> > pro
I think the responses you have heard so far talk about replication to
provide availability (HA-JDBC, the ongoing Derby effort).
What you are talking about is basically using Derby as a reliable
front-end cache to a back-end database where the connection can be
unavailable from time to time.
What
Hey, I could even add this myself. One forgets sometimes that this is
open source and that one is a committer :)
David
On 9/13/07, David Van Couvering <[EMAIL PROTECTED]> wrote:
> OK, sounds good, I guess you could do that. But I do believe that it
> would be Very Nice if Derby p
IL PROTECTED]> wrote:
> David Van Couvering <[EMAIL PROTECTED]> writes:
>
> > On 9/12/07, Øystein Grøvlen <[EMAIL PROTECTED]> wrote:
> >> David Van Couvering wrote:
> >> > OK, fair enough. So, how *do* I find out what derby.system.home is
> &g
On 9/12/07, Øystein Grøvlen <[EMAIL PROTECTED]> wrote:
> David Van Couvering wrote:
> > OK, fair enough. So, how *do* I find out what derby.system.home is
> set to??
> >
>
> I would think it is the same way as with any Java System property
>
OK, fair enough. So, how *do* I find out what derby.system.home is set to??
David
On 9/12/07, Kathey Marsden <[EMAIL PROTECTED]> wrote:
> David Van Couvering wrote:
> > Hi, guys. I know that NetBeans sets derby.system.home to
> > ~/.netbeans-derby, but whe
Hi, guys. I know that NetBeans sets derby.system.home to
~/.netbeans-derby, but when I do
VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.system.home');
I get 'NULL'.
So, I tried this on both Derby 10.3 and Derby 10.2:
$ java -Dderby.system.home=/tmp -jar derbyrun.jar server start &
VALU
I think this was actually meant to go to a different Andrei (sorry Andrey)
On 9/6/07, David Van Couvering <[EMAIL PROTECTED]> wrote:
> I think I can actually answer some of these questions :)
>
> On 9/6/07, Ken Frank <[EMAIL PROTECTED]> wrote:
> > Thanks David for s
lowed for identifiers like database names,
> table and column names, to have non ascii in them, if proper
> quoting is used when referring to them ?
>
Yes, that's right.
>
> Thanks - Ken
>
>
> David Van Couvering wrote:
>
> >Hi, all. I am getting some quest
Hi, all. I am getting some questions from Ken Frank NetBeans
internationalization quality team about Java DB and character set
encodings. Rather than try and play go-between, I'm including him
here so he can directly ask any follow-on questions.
Ken would like to understand how Derby makes use o
OK, I got one answer from Bryan (yes for client/server, no for
embedded, which makes sense) and one from Kathy (no backward
compatibility period).
Just want to check -- is client/server backward compatible or not?
Thanks,
David
On 8/28/07, Kathey Marsden <[EMAIL PROTECTED]> wrote:
>
I know I should know this, but I just want to be sure. If you upgrade
a DB from 10.2 to 10.3 (e.g. hard upgrade), I am assuming you can
still use a 10.2 driver against that database, is that correct?
Thanks,
David
Hi, all. Someone asked me if things have changed around password
encryption in 10.3 - is there some form of encryption by default, or
is the default still to send the password in the clear? I scanned the
"what's new" section of the release page but couldn't find anything
definitive...
Thanks,
D
Yes, you're right, identifierQuoteString doesn't make sense in this
case. I thought you were trying to quote the entire identifier.
I don't have an answer for you though, sorry!
David
On 8/4/07, Geoff hendrey <[EMAIL PROTECTED]> wrote:
> On the advice I got back from my last email, I tried to u
You might try getIdentifierQuoteString()
David
On 8/3/07, Geoff hendrey <[EMAIL PROTECTED]> wrote:
> I need to call DatabaseMetaData.searchStringEscape to determine the escape
> sequence, but it just returns "". I cneed call DatabasMetaData.getColumns on
> a table whose name contains an unders
HI, all
I am testing quoting identifiers in NB, and I am using
DatabaseMetaData to see if a table exists.
I create a table called test. In SquirrelSQL I see that it is called
TEST because Derby auto-upper-cased it, as expected.
Then I run DatabaesMetaData.getTables(null, null, "test", null);
a
You can use the JDBC apis. You can use connection.setAutoCommit() to
enable or disable autocommit. If autocommit is on, then every time
you execute a statement it is executed. If autocommit is off, then a
transaction is started automatically when you executed the first
statement, and you need to
Thanks, Kristian.
I checked the DBCP site. It does appear to be a fully functioning
connection pool that can work with a container or outside of a
container.
David
On 7/24/07, Kristian Waagan <[EMAIL PROTECTED]> wrote:
David Van Couvering wrote:
> I could check this out myself, bu
I could check this out myself, but time is limited, and I thought
someone might have a quick answer.
On the Phobos (JavaScript in Glassfish) email list, the following
statement is made:
"in Apache Derby there is a regular data source class
(org.apache.derby.jdbc.ClientDataSource) which does not
es not take into account constraints on the timestamp columns,
and scans all tables. No need to say the query never ends...
Any idea about this problem is welcome!
Thanks,
Olivier.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of David Van Couvering
Sent: We
Hm, if you're creating a view on all the tables, that must mean all
the tables are under a single database? If that's the case, then this
doesn't really sound like horizontal partitioning (which usually means
splitting it into multiple databases, each with its own disk and
usually each with its o
Hi, all. Over the past month, the db team in NetBeans has moved our
development discussions (feature planning and review, bug discussions,
etc.) to [EMAIL PROTECTED]
If you're interested in database support in NetBeans, we would love to
have you. You can join by sending an email to
[EMAIL
1 - 100 of 216 matches
Mail list logo