This is also true.
Can you 'detatch' your index? By this I mean store the index on a different
disk?
Also what type/size machine are you running your query on? How much memory?
What else is in the table? Are the rows fat?
HTH to point you down a possible decision path.
-Mikey
-Original
-Original Message-
From: Arnaud Masson [mailto:amas...@gmail.com]
Sent: Monday, May 04, 2009 8:04 AM
To: Derby Discussion
Subject: Re: Many background threads (rawStoreDaemon)
de...@segel.com a écrit :
-Original Message-
I have an application that opens several
-Original Message-
From: knut.hat...@sun.com [mailto:knut.hat...@sun.com]
Sent: Tuesday, January 13, 2009 4:59 AM
To: Derby Discussion
Subject: Re: Bad performance with UPDATE on a nested SELECT
[SNIP]
Yes, it looks like the same query plan. I see the following problems
with this
See my comments mixed in...
Just a caveat, you're right, I don't know your entire application, I'm just
looking at it from what little information you have shared in your posts
-Original Message-
From: Mikkel Kamstrup Erlandsen [mailto:m...@statsbiblioteket.dk]
Sent: Tuesday,
Ok,
So the fact that even on a single table, it looks like your results are in
order of your identity index and it ignores the order by clause.
Your second index on the value doesn't appear to be used unless it's a
filter before the join and then the join uses the identity index.
Since you're a bit cryptic..
On Table A, you show Col_x_ID, but in your foreign key, you show Col_x. I'm
going to assume that you meant Col_x_ID.
On Table A, do you have an index on Col_x_ID? Is Col_x_ID a unique ID? If
so, is this the primary key for the table?
That would be the first
You're not returning a part of the filesystem but just a string that
contains the path to the file object.
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 4:29 PM
To: Derby Discussion
Subject: Re: How to store many large files in the database?
-Original Message-
From: Bill Shannon [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 16, 2007 12:04 AM
To: Derby Discussion
Subject: Re: User/password encryption and deployment
[EMAIL PROTECTED] wrote:
Maybe I am missing something but what exactly are you encrypting?
SSL is
: Sunday, May 27, 2007 9:45 PM
To: Derby Discussion
Subject: Re: license question
Michael Segel wrote:
...
Derby is licensed under the Apache license.
Its pretty much open. You can do pretty much anything you want, as long
as
you attribute Apache somewhere in your code. (You'd have
-Original Message-
From: Damian C [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 27, 2007 7:44 PM
To: derby-user@db.apache.org
Subject: Fwd: license question
Jim,
This can be tricky. I am not a lawyer - but this is my understanding
of the situation.
[SNIP]license.
Derby is a
Well...
You could open a connection to your oracle database, then open a connection to
your derby database.
Select from oracle and then insert into derby...
(You could build on this to add commits and table locking...)
You could write your own loader to use a single thread to read from the
Roll over and dies?
The OP's question was could Derby handle a billion or more rows.
The answer is that it depends.
At the same time, a table with a billion rows will be less efficient than a
table with a million rows. So the first question is why a billion rows in a
single table?
To your
lock in
SYSCOLUMNS table
On Feb 18, 2007, at 1:10 AM, Michael Segel wrote:
Making a big assumption...
If each thread has its own connection, you will be blocked on your
identity column.
Yes, each thread has its own connection retrieved from
ClientConnectionPoolDataSource
But you shouldn't
Making a big assumption...
If each thread has its own connection, you will be blocked on your identity
column.
But you shouldn't be blocked longer than it takes to get the identity value.
100 threads w n records per transaction? How much memory have you allocated to
your app? And is the app
for
the word the.
Do you see the problem?
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
derby [EMAIL PROTECTED]
(312) 952-8175 [mobile]
i/o request for the data thats why i am trying
to keep the table sorted. since sequential hard disk access is much faster than
random i/o .
On Feb 6, 2007, at 8:09 AM, Michael Segel wrote:
What exactly are you trying to do?
Based on the little snippet, it looks like
The trouble with stored procedures is that the performance boost depends on a
couple of factors.
It also depemds on the complexity of the business logic that you want to
incorporate in to the stored procedure.
But even still, the benefits of using stored procedures comes from having your
I'm not sure where that came from, however I'm sure its somewhere on the wish
list.
Since the boolean type has been around for a while, and its implemented in
other databases, its not out of the realm of being added.
With respect to java objects, what are they?
Note: that was a rhetorical
I'll have to check it out.
Derby, however has some additional parameters since it is also a commercial
product where Sun and IBM are providing paid for support services.
That's a dynamic that may impact the user community, along with licensing
terms, and product niche.
One may be more
Can you provide the query?
1800 items in an IN clause?
That doesn't sound right or efficient.
Why not use a subselect?
-Original Message-
From: Robert Enyedi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 9:51 AM
To: Derby Discussion
Subject: Large IN clause produces
Cute. Now if you said that SPAM was high in sodium, hence bad for you,
Then you'd be in hot water with hormel...
:-)
Back to being serious for a moment.
I try to set up aliases for each time I join a mailing list, or sign up for a
web page.
So when I get spam to that address, I know where the
Sorry for top post, using my crack berry.
Not a good idea to use multiple files.
Why not go all the way and make derby in to an mpp db? All you would have to do
is to preprocess the inbound query then send it off to all of the nodes, taking
the result set(s) in to a local temp file and then
and reasonable explanation.
Donald
-- Original message --
From: Michael Segel [EMAIL PROTECTED]
Not a good idea to use multiple files.
Why not go all the way and make derby in to an mpp db? All you would have to
do
is to preprocess the inbound query then send it off
Well,
Sort of.
I was being a tad sarcastic.
Yes you could create a poor man's mpp with derby, however it would involve
writing a preproceesor control node.
Something for a grad student to work on.
You could implement the concept of table partitioning as well.
It would be simpler to implement
message --
From: Michael Segel [EMAIL PROTECTED]
Let me clarify.
snip
the original poster is trying to use a yugo to pull a loaded semi up a steep
hill.
It sounds like a java error. Does the LONGVARCHAR overload the comparesTo()
method?
Sent via BlackBerry.
-Mike Segel
Principal
MSCC
312 952 8175
-Original Message-
From: Sisilla Sookdeo [EMAIL PROTECTED]
Date: Fri, 10 Nov 2006 14:29:03
To:derby-user@db.apache.org
Subject: comparisons
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 05, 2006 3:49 PM
To: Derby Discussion
Subject: Re: does Derby has some form of performance problem ?
legolas wood wrote (2006-11-03 14:46:10):
Hi
Thank you for reading my post
i
Just a hunch...
Some of your fields will get rounded up to the nearest word size.
Assume word size to be 8 bytes.
So you would have
5*8 for your big ints
3*8 for your small ints
14 rounded to nearest word size = 24
Plus 16 bytes for the pointer to the rest of the varchar.
And 16 for the time
-Original Message-
From: Jean T. Anderson [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 29, 2006 1:32 PM
To: Derby Discussion
Subject: Re: multiple webapps many embedded vs single network
Michael Segel wrote:
...
Derby wasn't designed to be a central database to multiple apps
the features that they have to act as a
centralized DB, however it does have a much smaller footprint.
Does that help?
Michael Segel-2 wrote:
Depends on how tightly coupled the web apps are.
Also how tightly do you want to couple the database to the app...
Suppose at a later date you
Depends on how tightly coupled the web apps are.
Also how tightly do you want to couple the database to the app...
Suppose at a later date you have some growth. You need to move some of your
apps to a new machine.
What do you do?
Sent via BlackBerry.
-Mike Segel
Principal
MSCC
312 952 8175
Yes.
If your PK is colA,colB,colZ then in your where clause use
WHERE colA=?
AND colB=?
AND colZ=?
Followed by the rest of your where clause. The optimizer should then choose
the pk index.
Sent via BlackBerry.
-Mike Segel
Principal
MSCC
312 952 8175
-Original Message-
From: Legolas
-Original Message-
From: Dan Scott [mailto:[EMAIL PROTECTED]
Sent: Monday, October 16, 2006 6:45 AM
To: Derby Discussion
Cc: [EMAIL PROTECTED]
Subject: Re: Is it Possible to Turn off Referential Constraints for a
DBUNIT Load?
[SNIP]
And to be fair, DB2 and Oracle offer the same
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Barham
Sent: Thursday, October 12, 2006 7:32 PM
To: derby-user@db.apache.org
Subject: Is it Possible to Turn off Referential Constraints for a DBUNIT
Load?
Hi,
When using DBUnit to load a
Concurrency may have some drawbacks, if you end up holding the transaction
as you attempt to write to both databases...
If I understood the initial request, try creating an after transaction
trigger(s) on a table that you want to replicate. Have the trigger call an
SP that writes a record to a
I believe that this is a known Derby defect.
Does anyone know if this is fixed in the
upcoming release?
From: Christine
Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20,
2006 3:48 PM
To: Derby
Discussion
Subject: Performance of IN
operator
Hello,
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Sent: Monday, September 18, 2006 10:25 AM
To: Derby Discussion
Subject: Re: Insert large using SQL
Thanks for response, but i have NO acces to database over JDBC, but only
via text stream, thus i MUST use SQL
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Sent: Monday, September 18, 2006 10:56 AM
To: Derby Discussion
Subject: Re: Insert large using SQL
Michael Segel wrote:
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Sent: Monday
On Friday 15 September 2006 7:15 am, Robert Enyedi wrote:
The TO_DAYS() function returns the number of days since year 0. Did
someone successfully port this functionality to Derby? Constructing a
Java function for this is not as straightforward as it looks.
Regards,
Robert
Why?
When was
, and ~5000
products.
Is this large by Derby standards?
Regards,
-Alan-
-Original Message-
From: Michael Segel [mailto:[EMAIL PROTECTED]
Sent: Friday, September 01, 2006 9:20 AM
To: 'Derby Discussion'
Subject: RE: SQLException: The heap container with container id
Container(-1
-Original Message-
From: Geir Magnusson Jr [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 5:38 AM
To: derby-user@db.apache.org
Subject: 10.2 licensing issue...
I read Rick's note on the 10.2 licensing issue in an archive because of
strange move to the user list, so
Outch. Missed the first part of Derby's statement.
Ok.
Doesn't make sense though.
His insert is a batch insert?
Imagine if you had a table where you were inserting a record that was larger
than 64KB. (Not including blobs) Are you saying that Derby would have failed
prior to your fix?
Within
;
}
Thanks!
-Alan Baldwin-
-Original Message-
*From:* Michael Segel [mailto:[EMAIL PROTECTED] *On Behalf Of
[EMAIL PROTECTED]
*Sent:* Thursday, August 31, 2006 5:05 PM
*To:* 'Derby Discussion'
*Subject:* RE: SQLException: The heap container with container id
Ok,
Yeah, you're right.
I'm trying to think about what I did in my query that gave me the right
result.
In my test table, there were 65K rows and I was able to get the correct
count.
So I guess I'll have to go back to see what I did.
-Original Message-
From: Robert Enyedi
I'd suggest that you modify it a bit.
You probably don't want to lose case on the raw inserted data.
Case adds meaning to the content. If everything was in upper case, it would
seem like we're always SHOUTING. (Just an example.)
But the idea makes sense.
What I would suggest is that you use an
Here's a simple way to do this...
Create an index on the column. It doesn't have to be unique.
Create a before insert trigger that calls a function.
The function just needs to execute a simple query:
SELECT COUNT(*) FROM test WHERE lower(text) = ?
In my test, I created a table test and the
Hmmm...
I realize its been a while since I've read Derby's manual, but doesn't Derby
support Scrollable cursors?
A scrollable cursor will allow you to run a query and to fetch specific rows
from the result set. At a minimum, that is what Sergey is originally asking
and which is supported by
to take action to get your software up and
running.
This is not a Derby problem, you will face the same obstacles with any
database system.
Hope this helps,
--
Kristian
Thanks a lot
Flavio
-Messaggio originale-
Da: Michael Segel [mailto:[EMAIL PROTECTED] conto di
Uhm, well, there's an ugly kludge that might work...
You could always count the number of lines in the input file before you
issue the load command. This will tell you the total number of rows that
should be loaded.
You could then periodically monitor the number of rows in the table and this
The .trim() method of a String will truncate the ending white space.
You can do a substring with a starting position of 0 and the MAX value of a
VARCHAR (which should be a constant somewhere).
This should ensure that the string is truncated and will fit.
-Original Message-
From: [EMAIL
Uhm no,
Derby/Cloudscape/JavaDB (you can pick and choose your name)... is a
relational database written in Java.
With respect to column data types, you should refer to the manual... These
are also the database types supported by the JDBC class(es).
Just like any other JDBC compliant database,
Not sure exactly what you are asking
If you want to find out the limits set on the VARCHAR column, the easiest
way to do this is to query the system tables. This is going to be database
dependent.
Since you also want to allow the end user to set the limits at install
time, again you are
, without reading or disclosing
them.
Thank you.
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
Ok... Is it a bug? If so where?
I mean, heck. How should the optimizer react when it has no hints from the
select statement. One would think that a table scan would make sense.
Especially when you have such a small data set.
The interesting thing is that the table scan took so long when you only
Ok,
So if your problem can be duplicated, then it's a bug.
From the cheap seats, it looks like when you reset the base value or next
value, its losing the GENERATE BY DEFAULT and somehow the identity column is
being reset to GENERATE ALWAYS. (Not sure which is the default constraint.)
-Original Message-
From: Jean T. Anderson [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 25, 2006 9:38 AM
To: Derby Discussion
Subject: Re: Proposal for 10.2 release schedule
Daniel John Debrunner wrote:
[EMAIL PROTECTED] wrote:
-Original Message-
From: Daniel John
On Friday 16 June 2006 1:29 am, Vic Ricker wrote:
Michael Segel wrote:
Look, if you grok the math, you'll see that if you return a result from
the sequence that causes an error, then you've got a bug, when there's
another number within the result set that doesn't cause the exception.
I
by default question
On 6/16/06, Michael Segel [EMAIL PROTECTED] wrote:
I think we'll just have to agree to disagree.
Whether you agree or disagree doesn't change the fact that this is a
bug.
Whether or not this is a bug is not a 'fact'. That there is
disagreement would imply
Sigh.
Don't they teach math in engineering anymore?
Lets try this one more time.
In 9.21, if N does exist, then N represents a solution set of potential
values.
In your interpretation, you are *implicitly* adding an additional boundary
that the sequence returns the MIN(N) regardless of the
into your application rather than relying on Derby to do
something that could cause performance problems.
-Vic
P.S. The first CPU that I learned assembly language on was the 6809. It
was cool.
Michael Segel wrote:
Sigh.
Don't they teach math in engineering anymore?
Lets try
On Thursday 15 June 2006 6:38 pm, Daniel Noll wrote:
Michael Segel wrote:
Uhm,
I'm sorry, but where did I ever say 'select max()'?
Hint: I didn't because its not that efficient.
Presumably he column would be indexed if you're doing operations like
max() on it anyway, so efficiency
? ;-)
And why do you need it? ;-)
...
The point is that you don't need it.
If the insert has a value X for the identity column and X CSV, then set CSV
= X;
It works every time.
Michael Segel wrote:
Presumably he column would be indexed if you're doing operations like
max() on it anyway, so efficiency
On Friday 16 June 2006 12:10 am, Vic Ricker wrote:
Daniel Noll wrote:
Ah. I was making the assumption that the indexes were implemented
properly. For instance, an index should keep a certain amount in
memory in order to have a reasonable chance of running quickly. So the
max and min
Engineering or anything. ;-)
-Mikey
Michael Segel,
Chief Peon in Charge,
MSC Corp.
Chicago, IL, USA
look at the index on the identity column, you may find a
way to handle the cycles and trap for the constraint so that the only time
you fail is if the table is full.
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
On Tuesday 13 June 2006 1:01 pm, Craig L Russell wrote:
Hi Mikey,
[SNIP]
[mjs] Hi Craig,
Errr. No.
In short, the sequence generation is outside of the transaction,
therefore
its possible to get a jump in the sequence number due to transactions
rolling back or individual inserts
On Tuesday 13 June 2006 1:19 pm, Craig L Russell wrote:
Hi,
On Jun 13, 2006, at 11:01 AM, Craig L Russell wrote:
In fact, you could argue that if the implementation skipped
returning
a sequence value just because that value had been inserted by the
user into a column, it would be a bug.
not affect any view that references the table being
altered. This includes views that have an * in their SELECT list.
You
must drop and re-create those views if you wish them to return the new
columns.
/quote
Michael Segel wrote:
On Monday 29 May 2006 3:31 pm, hilz wrote:
After
the
enhancement/feature
-Original Message-
From: Jean T. Anderson [mailto:[EMAIL PROTECTED]
Sent: Friday, June 09, 2006 10:33 AM
To: Derby Discussion
Subject: Re: generated by default question
Michael Segel wrote:
snip
Having said that, Daniel already made a suggestion which
Right.
I don't think hilz was really suggesting piracy.
Its just as easy as to test how Informix/DB2/... handles this and to them
mimic that behavior.
You've already made a good suggestion that would be easy to implement.
I believe that there may be a more elegant solution if you look at the
to return the
new
columns.
/quote
Michael Segel wrote:
On Monday 29 May 2006 3:31 pm, hilz wrote:
After a quick glance,
This looks like a bug.
You should be able to insert your own values in the ID column,
which you
do...
then on rows that are auto
that
the value already exists and just generate a new value for me?
I find it odd to have to set the restart with to skip the values that
i set manually.
thanks for any help.
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
Uhm...
Posting in Jira and introducing it are two different things.
I notice that there is an Andrew McIntyre who works for IBM in Atlanta.
Is that you?
-Original Message-
From: Andrew McIntyre [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 11:20 AM
To: Derby Discussion;
There are other ways of doing this, however each method has their own good
points or bad points.
One way you can do this is to create a counter table.
(This allows you to have multiple counters within a single table.)
Then you can write your own procedure that will fetch the value of the
Derby is a very good, lightweight, general purpose, pure java relational
database.
Having said that, I think it's important to choose the right tool for the
right job.
Derby has its historical roots as a lightweight database. It lacks certain
features that are found in Informix or DB2 that
On Wednesday 05 April 2006 12:33 pm, Daniel John Debrunner wrote:
Michael Segel wrote:
On Tuesday 04 April 2006 6:23 pm, Daniel John Debrunner wrote:
Daniel John Debrunner wrote:
May I suggest that if you are writing samples for others to use that you
demonstrate use of parameter markers
On Wednesday 05 April 2006 2:16 pm, Daniel John Debrunner wrote:
Michael Segel wrote:
On Wednesday 05 April 2006 12:33 pm, Daniel John Debrunner wrote:
Michael Segel wrote:
On Tuesday 04 April 2006 6:23 pm, Daniel John Debrunner wrote:
Daniel John Debrunner wrote:
May I suggest that if you
knows the input values, it
would be cleaner to create a statement then excute the statement.
Statement s = con.createStatement();
s.executeUpdate(string stuff);
Less overhead.
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
On Tuesday 04 April 2006 12:16 pm, Sunitha Kambhampati wrote:
Michael Segel wrote:
On Tuesday 04 April 2006 11:48 am, Daniel John Debrunner wrote:
Anil Samuel wrote:
PreparedStatement ps = con.prepareStatement(select
TOTAL_TAKEN from DTP.LEAVE_APPROV where EMPLOYEE_ID= + employee
, so you know what to do
*/
}
}
-G
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
is to to use some API like Apache Jakarta POI :
http://jakarta.apache.org/poi/
I have not used this, but a search on the web turned up some pointers:
http://forum.java.sun.com/thread.jspa?threadID=445015start=0
Hope this helps.
-Rajesh
--
--
Michael Segel
Principal
Michael Segel Consulting Corp
with
just one socket if I can.
Advice? Thanks for your time.
ry
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
Uhm...
Not to nitpick...
There appears to be a problem with your model.
Your cities table doesn't map to your flights table.
Note: you id airports via their 3 letter code.
But you don't map this to the cities.
While this is an example, note that some cities have multiple airports.
(NY has 3*,
I have to agree with Mike that there is something missing.
First, how often are you preparing the statement?
You should only be preparing it once and within the look, set the variables
and then execute it your 1000 times.
You may see 2 seconds on the first iteration, but after that, it should be
-Original Message-
From: Kristian Waagan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 3:52 PM
To: Derby Discussion
Subject: Re: Derby JDBC Embedded Driver, Prepared Statements, and Indexes
Michael Segel wrote:
I have to agree with Mike that there is something
Max,
Perhaps I wasnt being clear.
If you write your select statement to
include a virtual column(s) of YEAR(), MONTH() and DAY(),
You can then group by them.
From: Max Ten
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 10:40
PM
To: Derby Discussion
Subject:
On Friday 03 March 2006 5:04 am, Thomas Vatter wrote:
I have shutdown derby, dropped the database by removing its folder,
started derby (no large memory consuming, stays low), recreated
the database, imported 1300 data and showed them in my application.
Memory stays low, but the ordering is
On Friday 03 March 2006 3:17 am, Rhys Campbell wrote:
Hi Rajesh,
I can post some code later when I return from work. My app is written
using Java and uses a single table Derby database. At present this only
has three records in it. I did try to completely shutdown Derby at the
end of one
a play with your ideas this evening and maybe post my code.
Thanks for your thoughts.
Regards,
Rhys
-Original Message-
From: Michael Segel [mailto:[EMAIL PROTECTED]
Sent: 03 March 2006 13:36
To: Rhys Campbell
Subject: Re: No current connection
On Thursday 02 March 2006 7:20 pm, you
to solve.
You'll get it eventually. ;-)
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
on the Informix version
Just wondering if anyone else saw the same potential...
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
for production? Are there
other outstanding memory/leak related bugs which I'm not aware of? Would
you recommend Derby for my project?
Thanks,
Jim Newsham
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
comments are welcome.
Regards,
Jim Newsham
-Original Message-
From: Michael Segel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 15, 2006 6:01 AM
To: Derby Discussion
Subject: Re: embedded derby -- does it leak
On Tuesday 14 February 2006 9:21 pm, Jim Newsham wrote:
Jim
should be
covered. Then there's the rest.
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
be a bad thing.
So the better question is... do you blame the hammer or the carpenter when he
can't hit a nail straight in to the wood?
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
On Friday 27 January 2006 12:00 am, duminda wrote:
Hi,
I'm interested in developing a GUI for Derby with Apache licence.
Schema browser
alter table (column/constraint)
DML (insert/delete/update)
This will be something like Toad to Oracle.
Is there any tool already exist?
Eclipse has
]
-Melvin
---
-
Do you Yahoo!?
With a free 1 GB, there's more in store with Yahoo! Mail.
http://us.rd.yahoo.com/mail_us/taglines/mailstorage/*http://mail.yahoo
.com/
--
--
Michael Segel
Principal
Michael Segel
On Friday 06 January 2006 11:11 am, Danny wrote:
What I was after was a way to build a list of transactions that are
available to edit for a user.
OK, just to be clear, when you say transactions you mean data stored in the
row represents a transaction, and not a database transaction.
What I
-5638 mailto:[EMAIL PROTECTED]
P.S. A good JDO? O, Gasp!
---
--
--
Michael Segel
Principal
Michael Segel Consulting Corp.
[EMAIL PROTECTED]
(312) 952-8175 [mobile]
), Types.NUMERIC);
works perefectly ok while
pstmt.setObject(2, new BigDecimal(0.9), Types.NUMERIC);
is errouneous.
BUT: pstmt.setObject(2, new BigDecimal(0.9), Types.NUMERIC, 7);
(giving the scale) does work.
--
--
Michael Segel
Principal
Michael Segel
1 - 100 of 141 matches
Mail list logo