Senthil Gugan wrote:
Hi,
I am working on LINUX SuSe10.2 OS with the following version of
softwares, jdk1.5.0_11, eclipse3.2(BIRT2.1.2).
I have installed the Derby plugin in the Eclipse plugin Directory.
Here my problem is I couldn't able to access the BIRT classic model
database
Sedillo, Derek (Mission Systems) wrote:
Do you think that 2 million records are too many to use with the import
utility?
Import utility can handle so many records. I have tested it with
importing 6 million records into a empty table and it took 18minutes on
my test machine
(RHEL AS 4, Lin
Andy Jefferson wrote:
The schema in Apache JDO is created specifying lowercase identifiers but they
haven't quoted the identifiers so will be stored UPPERCASE in Derby.
If I call
DatabaseMetaData.getColumns(conn, null, "DATASTOREIDENTITY0", null);
it returns in the order of 17ms with the c
Hannes Grund wrote:
Dear all,
I'm using the Derby-10.1.3.1 package on a Suse 9.1 Machine,
for certain reasons, I want the Derby-NetworkServer to run in
the same VM as any clients accessing the database (are there any
problems related to that particular setup ?), the database
is accessed usi
Robert Enyedi wrote:
Could you please help in our decision by pointing out some advantages
and shortcomings of Apache Derby versus Hypersonic SQL?
In case you have not already seen these articles, these might be a good
read -
http://weblogs.java.net/blog/davidvc/archive/2005/08/database_acid
Farrukh S. Najmi wrote:
I am optimizing for performance in my application. We have a large
unit test suite.
I am looking for a way to log *any* table sequential scan on any query
executed
during the running of my regression test suite to identify queries
that need to be
optimized. Is there
Supal J Patel wrote:
To debug the problem I downloaded Derby source and successfully set up
a local development environment. While looking at the source code I
found that in org.apache.derby.impl.services.jce.JCECipherProvider
class'
public int encrypt(byte[] cleartext, int offset, int leng
Kathey Marsden wrote:
2) If another server was started on the same port,
NetworkServerControl.start() prints the exception to the console
output, but does not throw an exception
I think that this also is a bug and Network Server should throw an
exception if another server is up, but wanted t
Sunitha Kambhampati wrote:
nexus wrote:
I have the same problem here. It seems that the problem arises only if
the "derby.locks.escalationThreshold" is too small?
Is there a way to release such a lock? At the moment I handle the
problem by shutting down cloudscape-server and res
nexus wrote:
I have the same problem here. It seems that the problem arises only if
the "derby.locks.escalationThreshold" is too small?
Is there a way to release such a lock? At the moment I handle the
problem by shutting down cloudscape-server and restarting it again
(very ugly).
The Clouds
Michael Andreasen wrote:
Here is a demo.
It will run ok on my desktop with -Xmx8m. However, I'm using the
database for real on a CDC device and 8 meg is about the total memory
I have for the database and the snall application together, so I'd
really like derby to operate in 4 or 6 meg tops.
Souciance Eqdam Rashti wrote:
Hello Everyone
I have a rather annoying problem. I was wondering if anyone could
provide sample code as to how I can restrict a user to a single
database or basically a certain number of database. So for example
user fred would only be allowed to access accoun
Prasenjit Sarkar wrote:
The statistics obtained do not shed much light on this issue.
I'm fairly new to Derby and would like some direction on how to proceed.
In case you have not tried, it might be useful to see what query plan
Derby is choosing by setting the debug property
derby.lang
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 + " and
LEAVE_TYPE_ID=" + leaveTypeId);
C
Andre Höing wrote:
The property is derby.system.durability=test
http://db.apache.org/derby/docs/dev/tuning/rtunproperdurability.html
I tried the durability property, but I have not seen any improvement.
I started my Application with argument: -Dderby.system.home and the new home
[EMAIL PROTECTED] wrote:
Andre Höing <[EMAIL PROTECTED]> writes:
Hi derby-users,
I am using derby to save lots of RDFTriples at starting time. This is a
little bit too slow for me.
Is there the possability to accelerate this. Bevore I used MySql with
the MyISAM engine. Is there a simular
Daniel John Debrunner wrote:
So it's a bug, but there is a workaround.
I have opened Jira entry - DERBY 802 for this.
Thanks,
Sunitha.
Grégoire Dubois wrote:
Hi all,
Here is the select I do on the following table. If "file" is a
BLOB(2G), the request is very very slow (30-60s), even if there is
only one line for the table. But if I replace BLOB(2G) by BLOB(5M) or
BLOB(1G), the request becomes very fast.
Is there a reason ?
On 8/30/05, Bryan Pendleton <[EMAIL PROTECTED]> wrote:
I'd like to arrange for a NetworkServer instance of Derbyto be automatically started up and shut down on my Red Hat
Linux system, using the conventional "chkconfig" servicemanagement, as described in , for example,
http://www.redhat.com/docs/ma
Xavier Vigouroux wrote:
Hi
In my project, I create a database that is access afterwards.
at creation, I would like to "secure" the access.
as a dummy question, what is the usual way to secure an access to the DB
whereas the user is never in the loop. All must be done programmatically?
Can yo
Hi All,
What is the correct way to connect to a database in a jar using the
client driver. Is this possible currently ?
I tried the following:
1. created database tdb3, created a jar with the database in it . Jar
file is tdb3.jar
2. Put tdb3.jar in classpath of network server and started t
sorry - a dot is missing in the link.
correct link :
http://db.apache.org/derby/docs/10.0/manuals/develop/develop38.html
Sunitha Kambhampati wrote:
http://dbapache.org/derby/docs/10.0/manuals/develop/develop38.html
Thomas Dudziak wrote:
No, I didn't start ij from within eclipse, but rather from the
commandline. And derby.home shouldn't matter when using
jdbc:derby:classpath, right ?
<>Even more interesting, I simply stopped the web server and
restartedit without any other changes, and now access to D
Arieh Markel wrote:
My assumptions are as follows:
- table lock granularity is what is in place in Derby
Are those assumptions true ?
Just wanted to point out , that by default Derby is configured for
row-level locking.
http://db.apache.org/derby/docs/10.0/manuals/develop/develop73.html#
Lars Clausen wrote:
The 10.1 docs state that the java.sql.Clob.getCharacterStream() method
is UNSUPPORTED [sic], however it works nicely when I try to use it. Is
the documentation out of date, or are there some special cases I should
know about where is it indeed unsupported?
-Lars
It se
Michael J. Segel wrote:
The only drawback is that Derby is under GPL. So as long as you follow GPL's
rules, you're ok.
< snip - lots of stuff about gpl>
Derby is* not licensed *under GPL. See
http://db.apache.org/derby/license.html
Derby is available under the Apache License, Version 2.0
Hi Hiram,
I just modified the the repro that you attached with DERBY621 to remove
the junit specific code since I dont have junit and dont know much about it.
So in your repro, the test updates one row when using testBatch , and
also when using testNoBatch methods.
I ran this test on my 10.2
Daniel Noll wrote:
Rajesh Kartha wrote:
Hi Daniel,
Can you post the way you are retrieving the CLOBs from the
ResultSet. I have used the rs.getAsciiStream() and
rs.getCharacterStream()
methods for getting CLOBs in the past (with the Client driver) and it
seemed to work just fine.
Hmm,
Lars Clausen wrote:
Hi!
I was under the impression that by default Derby does not take locks
when reading, so deadlocks should only occur when two updates collide.
However, I had the exception below this morning:
Caused by: SQL Exception: A lock could not be obtained due to a deadlock, cyc
Scott Ogden wrote:
I have observed some interesting query performance behavior and am
hoping someone here can explain.
In my scenario, it appears that an existing index is not being used
for the ‘order by’ part of the operation and as a result the
performance of certain queries is suffering.
Knut Anders Hatlen wrote:
Philippe Hamelin <[EMAIL PROTECTED]> writes:
Hi,
I just did a test program to verify performance of derby. I tooks 23 seconds to
insert 500 rows in a table.
Here is the create table statement :
String sqlCreateTable = "CREATE TABLE test (oid INT, " +
Rajes Akkineni wrote:
Hi,
Dose that mean if i have 4 tables with BLOBs it will take up 120mb ~?
No, it does not depend on the tables in database. Page cache is per
database.
Sunitha.
On Thu, 01 Sep 2005 23:32:40 +0530, Sunitha Kambhampati
<[EMAIL PROTECTED]> wrote:
Rajes Akkineni wrote:
Hi,
I have got the similar problem.
I was unable to insert bigger files in to the database.
But my situation is little different than this. I am not inserting
total 40mb file in one blob.
I have split them in to 64kb chunks and inserting in multiple rows.
I got outo
Xavier Vigouroux wrote:
Hi,
I am trying to create an agent that will check that a database is
working correctly.
In this context what operation is performed by SYSCS_CHECK_TABLE?
thanks
You may find this derby manual link helpful , - explains what all
internal consistency checks are don
Scotty Allen wrote:
Hi all,
We've been having some problems with occasional rollbacks of an embedded
database when the application is shutdown and restarted. The pattern
seems to be that you shut down our application, and then restart it, and
the database is in the same state it was the time b
Rajes Akkineni wrote:
When i tried to place 1000 64kb blobs it took more then 120 sec.
But when i removed the blob i can execute 9,00,00,000 inserts in just
3 sec.
The 90 million number seems really high to me, could it be possible
that your test may not be actually performing inserts ..?
Rajes Akkineni wrote:
Hi,
Have any one tried using BLOBs with derby?
I tried it...tried to insert 1000 64kb blobs...unfortunaly it took all
my memory and gave OutofMemoryException.
It used all the heep.
I could successfully insert 1000 rows of 64kb blobs, with jdk1.5 with
default jvm heap
Brian Bonner wrote:
I'm trying to insert data into field of a table created with CLOB(100
K). The text is only 40K in size, but it keeps throwing an error:
ERROR 54002: A string constant starting with ''version=\"1.0\"?>\n\n\n
Any thoughts on this?
How are you trying to do the insert ?
1.
Here are some manual links that you may find helpful:
http://db.apache.org/derby/docs/10.1/adminguide/cadminappsclient.html
http://db.apache.org/derby/docs/10.1/adminguide/radminappsclientxmp.html
( this has examples).
hope this helps,
Sunitha.
thank you in advance, Kostas
Sunitha Ka
Kostas Karadamoglou wrote:
Hi all,
I was using Derby 10.0 with db2cc.jar and db2_licensecc.jar in network
mode. The driver was called com.ibm.db2.jdbcDriver. Everything was
working fine :)
But now I changed to 10.1.1. The driver jar is derbyclient.jar and the
driver org.apache.derby.jdbc.C
David Van Couvering wrote:
Thanks, Sunitha, for looking into this! It would be *great* if you
posted this to the server side in response to the "Derby is slow"
judgement out there. If for whatever reason you are uncomfortable
doing this, let me know, and I'll be happy to do it with your OK.
I took a quick look at the benchmark at polepos that is mentioned in the
thread on theserverside , specially the bahrain test. This test uses
Statements instead of PreparedStatement for the select queries. ( see
BahrainJdbc.java where select queries are like "select * from bahrain
where Lice
Derby has debug flags that prints out the lock table information to
derby.log, and this can help debug lock timeout/deadlock errors. The
following faq entry talks about how to enable these flags.
http://incubator.apache.org/derby/faq.html#debug_lock_timeout
Hope this helps, but please do pos
Great to see you use Derby!
If possible, can you also post the DB dump or maybe atleast the schema
of tables/indexes used in this query .
Thanks,
Sunitha.
David Zonsheine wrote:
Hello derby-dev,
Thank you for the wonderful work you're doing.
We installed Derby on our application to be used
Gin Ng wrote:
I have a table which is referenced by several other tables. When I turn
autocommit off, do the inserts to the tables and rollback. All inserts are
rolled back except the parent table. Anyone has encountered the problem?
Gin Ng
Can you provide more details on what you are tryi
Jack Klebanoff wrote:
Sunitha Kambhampati wrote:
Edson Carlos Ericksson Richter wrote:
I've run with derby.language.logQueryPlan=true and result is that I
have table scan for only one table, that has actually one record.
I am curious as to why a table scan is being picked. Does
Edson Carlos Ericksson Richter wrote:
I've run with derby.language.logQueryPlan=true and result is that I
have table scan for only one table, that has actually one record.
I am curious as to why a table scan is being picked. Does this table
have indexes that can be used for the query in que
Edson Carlos Ericksson Richter wrote:
Responses inline:
Sunitha Kambhampati escreveu:
Edson Carlos Ericksson Richter wrote:
Hi!
I'm trying to embed Derby into Tomcat web apps (using Embedded
driver). But I found it's very, very slow.
My tables are not so big (majority hav
Edson Carlos Ericksson Richter wrote:
Hi!
I'm trying to embed Derby into Tomcat web apps (using Embedded
driver). But I found it's very, very slow.
My tables are not so big (majority have 10 or 20 records), and 2 have
many records (27000 in one, 436000 in other).
I have same database running
Paul Byford wrote:
hi,
i intend to deploy derby in embedded form as part of an application.
to protect the data i would like to use the disk encryption feature.
the issue i have is that for my application to have access to the
encrypted database data I must also deploy the bootPassword with the
In my case, I have had to put my ant.properties in C:\Documents and
Settings\Administrator for it to work.
Putting in %home% didnt seem to work. (not sure why).
Sunitha
David Van Couvering wrote:
Yes, I got this problem too, and it took me most of a day to figure it
out.
Are you on XP? If so
+1
Kathey Marsden wrote:
It seems to me that it would be very sad and bad karma to have our logo under
such a cloud of suspicion. So I would like to call a vote to reject this
tally. I've heard lots of great ideas on how to resolve this issue either
technologically or socially but I think fir
[ X] None of the above - keep trying
Susan Cline wrote:
It's time to vote for the final Derby logo!
Please submit your vote for one of these logos to the derby-user
mailing list
[ ] 32
[ ] 35
[ ] None of the above - keep trying
Remember, One vote per person
The voting is now open, and will
my vote is +1 for 5.
Susan Cline wrote:
Voting for the Apache Derby logo
The Derby community voted to accept the rules for
choosing the Derby logo:
http://mail-archives.eu.apache.org/mod_mbox/db-derby-user/200503.mbox/[EMAIL
PROTECTED]
The voting rules and ballot are below.
The voting will consist
Manoj Koshy wrote:
Problem 3
I can run Derby in a server mode allowing muliple connections to it.
So if I create a non encrypted database in server mode providing my ip
and start it
then I can run it without hitches.
But whenever I create a database in server mode using the additional parameter
of
Ruta Kadhe wrote:
Hi,
Further to my query I would like to add the Exception which I get:
" Connection to C:\derby_home\mytestDB failed. IWAS0126E Problems
encountered while trying to establish
connection Cloudscape_Embedded. Reason: 'Failed to start database
C:\derby_home\databaseName',
see the nex
Darryl Pentz wrote:
I have a tree structure in a GUI that results in a new database being created
and loaded with records when the user clicks on certain nodes.
Currently however, when the user clicks on the node, the bottleneck is when the
'create=true' call is made. This creation seems to be taki
Ryan Dewell wrote:
Hello,
The documents provide two different definitions of the max size of LONG
VARCHAR. One is 32k, and the other is unlimited. Does anyone know the real
limit of LONG VARCHAR? I'm looking for a column type similar to
Postgresql's TEXT.
-http://incubator.apache.org
Jeremiah Jahn wrote:
insertPreparedStatement.setNull(5,Types.NULL); where column is a
timestamp column.
This is with the latest official release(10.0.2.1). running on java 5
and linux.
Actually, if you are trying to set null on a column with type timestamp
, I think it should be
Bernd Ruehlicke wrote:
Hi there,
still Derby newby which is digging through the documentatins but cannot
find wht he needs ...
There are some examples in the derby tests ( in case you have
downloaded the source).
example : .
/java/testing/org/apache/derbyTesting/functionTests/tests/lang/funct
Barnet Wagman wrote:
1) you can acquire a table level lock using LOCK TABLE sql statement .
ex: lock table t1 in exclusive mode
2) There is also lock escalation mechanism in derby. When locks on
particular table in a transaction reaches a threshold
values(default:5000). it automatically esca
Adam Blinkinsop wrote:
Quote: I've pretty much tried everything relevant in "Tuning Derby" and
I've tried varying all possibly relevant Derby properties.
Is the autocommit mode setting in the "Tuning Derby" section?
- Adam
I took a quick look at the Tuning Derby manual and did not come across
Barnet Wagman wrote:
I've been working with two simple tests, an INSERT and a SELECT
Any comments/suggestions re tweaking performance would be appreciated.
Is the insert test running in autocommit mode ?
Running the inserts in autocommit mode is slow as each commit involves a
flush of the log
Andrej Tibaut wrote:
Hi Arun,
please find attached our database speed test results.
[snip]
Hi Andrej,
I am not sure I understand what the numbers mean.
example: Derby embedded, delete - (1,95) . Can you explain what 1,95
stands for.
Thanks,
Sunitha.
64 matches
Mail list logo