ØG == Øystein Grøvlen - Sun Norway [EMAIL PROTECTED] writes:
ØG Peter Nabbefeld wrote:
Hello,
I just want to create a database, if it does not yet exist. Database
creation works, schema creation does not. I'm using the following
syntax (in Java):
Statement stmt
MM == Mike Matrigali [EMAIL PROTECTED] writes:
MM Note that cloudscape automatically reuses space from deleted rows when
MM new rows are inserted into the table. The main problem
MM SYSCS_COMPRESS_TABLE is solving is if there are a number of deletes
MM which will not be followed
TW == The Wogster [EMAIL PROTECTED] writes:
TW Øystein Grøvlen wrote:
Is this also true for B-tree indexes? I would imagine that if you
have a index on a monotocally increasing key (e.g., a timestamp) and
where you regularly delete old records, there may be a lot of empty
MM == Mike Matrigali [EMAIL PROTECTED] writes:
MM Derby will also reclaim space automatically in btree indexes for this
MM case as long as all the old rows on a given leaf are deleted and
MM the background process gets a chance to get a table level lock
MM at some point - the
KK == Kostas Karadamoglou [EMAIL PROTECTED] writes:
KK Hello,
KK I am new to Derby and to Transactions in general.
KK I want to perform some tasks to my databases using one thread and lock
KK the table that it uses from the remaining threads.
KK My qyestion is simple!
PB == Piet Blok [EMAIL PROTECTED] writes:
PB Hi,
PB I noticed some different behaviour between Derby EmbeddedDriver and
ClientDriver. This was a disappointment, because I wanted to develop a Derby
application that may switch between the two drivers.
PB Differences I noticed are:
XV == Xavier Vigouroux [EMAIL PROTECTED] writes:
XV hi,
XV is there a way to remove the message on console indicating new
XV connection to the server ?
As far as I can see from the code, these messages will always go to
System.out. Please file a JIRA issue if you want this
KM == Kathey Marsden [EMAIL PROTECTED] writes:
KM Øystein Grøvlen wrote:
XV == Xavier Vigouroux [EMAIL PROTECTED] writes:
XV hi,
XV is there a way to remove the message on console indicating new
XV connection to the server ?
As far as I
XV == Xavier Vigouroux [EMAIL PROTECTED] writes:
XV hi,
XV I used to spawn a networkserver that I access through JDBC.
XV I have to change my design to a Embedded Server.
XV I have now a PriviledgeActionException (on client side) when opening
XV socket to the server
XV
SAD == Suavi Ali Demir [EMAIL PROTECTED] writes:
SAD Another little detail about optimization is that
SAD Statement.setMaxRows() kind of functions on the JDBC side may
SAD not be sufficient since it is called after SQL statement is
SAD prepared and returned as an object (after
JAC == James A Craig/O/VCU [EMAIL PROTECTED] writes:
JAC Hi, I'm fairly new to Derby but I was curious if its possible
JAC to use it in a distributed setup. I currently have a small
JAC cluster and want to set it up so that I have a distributed
JAC database on it using Derby. So
LC == Lars Clausen [EMAIL PROTECTED] writes:
LC Hi!
LC We're using Derby version 10.1 (Bundle-Version: 10.1.100.208786)
LC embeddedly in our system. Even though I've put extensive rollback and
LC statement closing handling in the code, we still occasionally see cases
LC
EB == Erik Bengtson [EMAIL PROTECTED] writes:
EB Dan,
EB That doesn't help. I already tried variations of the same function,
using
EB the same code.
EB While using any java.lang.Math or other
EB java.lang.Class.operation, derby was able to retrieve and run
EB the
XV == Xavier Vigouroux [EMAIL PROTECTED] writes:
XV Hi,
XV I have a transient priviledgeException when connection to the DB with
XV ij.
XV here is the scenario:
XV 1/ I start an embeddedServer
XV 2/ wait for the ping() be ok (tested in the JVM creating the server)
XV == Xavier Vigouroux [EMAIL PROTECTED] writes:
XV If I understand you, you propose to improve my call to ping with a
XV loop on the creation (ie. url with create=true) of a *FAKE* schema
XV until it succeeds.
XV Then I have to delete all the associated files.
MM == Mike Matrigali [EMAIL PROTECTED] writes:
MM I 2nd Satheesh's query, it is useful to know why you care. Derby
MM unlike most other database's automatically maintains histogram
MM type information about the tables (this does require indexes to
MM exist). This information is
MM == Mike Matrigali [EMAIL PROTECTED] writes:
MM Would need to see the exact documentation reference, but this is not
MM the case. The storage system keeps an estimate of the number of
MM rows in a table. For performance reasons this estimate is not exact
MM (ie. we don't
I did not get any replies to this email. It would be useful if
someone could clarify whether the statistics are automatically updated
or not.
--
Øystein
ØG == Øystein Grøvlen [EMAIL PROTECTED] writes:
MM == Mike Matrigali [EMAIL PROTECTED] writes:
MM Would need to see the exact
BP == Bryan Pendleton [EMAIL PROTECTED] writes:
A Guidelines section starts on slide 19. Slide 24 lists 100-500
updates per second -- but, of course, your actual performance will
depend on the complexity of your transactions.
BP Is there a simple way that I can observe
LW == Legolas Woodland [EMAIL PROTECTED] writes:
LW Hi
LW Thank you for reading my post.
LW can some one please check and see what is wrong with this scripts ?
LW im sure that they should execute but derby return errors like :
LW org.apache.derby.client.am.SqlException:
[EMAIL PROTECTED] wrote:
Hi,
This is issue DERBY-39, can someone give an opinion on this?
It works in MSSQL and DB2
SELECT UNBOUND_P.PROJID FROM applicationidentity0.PERSONS THIS,
applicationidentity0.PROJECTS UNBOUND_P WHERE
EXISTS (SELECT 1 FROM applicationidentity0.PROJECT_MEMBER
Thomas Vatter wrote:
A clustered index should be the fastest access for retrieving ordered
columns. 'Create index' command does not yet support it. Since ordering
is my main problem at the moment I post this as request for enhancement.
What do you mean by a clustered index? It usually means
tom wrote:
I mean an index that kept up to date on disk permanently. This is the definition
that I know from the time I was using Informix Online. The syntax was 'create
clustered index ...'. I don't mean to put it on the primary key as SQL-Server
does, but having the possibility to create one
is full.
--
Øystein Grøvlen, Senior Staff Engineer
Sun Microsystems, Database Technology Group
Trondheim, Norway
Thomas J. Taylor wrote:
Hi There,
I have a Derby database that is giving me a read-only error (25502), and I
don't know why. The database was working fine, up until about a month ago.
Now, I cannot INSERT, UPDATE, or DELETE from the database - I always get
ERROR 25502. I checked Windows
Sanket Sharma wrote:
I would also appreciate your suggestions on features the community would
like to see being implemented as JMX extensions.
On the top of my head:
- Performancs statistics (e.g., transactions committed/aborted per second)
- Change dynamic properties (e.g.,
Robert Enyedi wrote:
If I need to group the values returned by the MY_USER_FUNCTION, I simply
cannot do so because the following query is invalid in Derby:
SELECT MY_USER_FUNCTION(t1.field1) AS MY_VALUE
FROM T1
GROUP BY MY_VALUE
I have not tried this, but maybe something like this will
Robert Enyedi wrote:
Thanks for the tip. I tried this, but it has the same problem with alias
referencing.
Sorry, I should have tried this first. Fernanda has given you the right
solution.
--
Øystein
David Sitsky wrote:
Some causes in the past are:
o DERBY-700
o DERBY-1838
o using durability=test mode
o running on hardware that doesn't actually sync disk when asked
o running separate jvm's on 2 machines accessing the same db across a
networked file system.
This is running on windows, we
Ralf Wiebicke wrote:
Hi!
I try to rename a column using the following statements:
create table t (a int)
rename column t.a to b
The second statement throws an exception:
[Error Code: 3, SQL State: 42X01] Syntax error: Encountered column at
ine 1, column 8.
Although this feature is
Alex Boisvert wrote:
Hi,
I stumbled upon an interesting locking behavior in Derby 10.2.2.0
http://10.2.2.0 yesterday and thought I'd post to the list to get a
better understanding of what's happening under the covers. Assume a
table with two indexes:
create table MY_TABLE (
ID
For tables with Blob or Clob columns, the default page size for the will
be 32 kB.
(Ref. http://db.apache.org/derby/docs/dev/tuning/ctunperf816059.html )
--
Øystein
Anders Morken wrote:
Anders Morken:
[...] the page size (Seemed to be 32K in this case [...]
Aha. Those 32 kilobyte pages
Xavier Hanin wrote:
con.createStatement().executeUpdate(create table Issue ( ID
char(50) ));
PreparedStatement st = con.prepareStatement(select count(*)
from Issue where ? is null);
st.setNull(1, Types.VARBINARY);
I do not think that CHAR and VARBINARY
Xavier Hanin wrote:
On 3/31/07, *Øystein Grøvlen* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Xavier Hanin wrote:
con.createStatement().executeUpdate(create table
Issue ( ID
char(50) ));
PreparedStatement st = con.prepareStatement(select
John C. Turnbull wrote:
I have just started to use Derby for configuration data for an
application and have found that whenever the app terminates unexpectedly
then Derby will not start the next time I start the application as it
complains that it’s already been opened. At the moment, I need
Brown, Andrew W (Rosetta) wrote:
After reading through the documentation it doesn't seem like passing an
array to a stored procedure is possible:
Derby does not support the SQL ARRAY type. So it will not be possible
to pass arrays as stored procedures.
--
Øystein
Adam Bovill wrote:
Hi Olav,
Thanks. That seems to have improved things.
I was wondering whether or not there was a way to create one
PreparedStatement from another. I have the first one that I've created
and would like to clone or duplicate this, w/o needing to recompile it.
So when
I observed this error a few times during some experiments I did some
time ago. See DERBY-637. Not the same setting, though. Client/server,
30 GB database. When this started to occur, all my transaction fail
with this error. Restarting the database, made the error disappear.
--
Øystein
Arthur Blake wrote:
Hello, I have been using Apache Derby 10.2.2.0 for a few months, and it
has been working quite well for me.
I upgrade to 10.3.1.4 just after the release came out, and I have been
testing it out with my application.
It seems to work fine, except when I read some BLOB
Arthur Blake wrote:
Yes, that was the problem.
If I change my code to keep the Connection open after I have a Blob in
hand, and then read the Blob it works.
It appears that also the ResultSet and PreparedStatement I used to fetch
the Blob must also remain open until I'm done reading the
Rahul Dwivedi wrote:
Are there any plans for implementing such a feature where lob locators
are stored in tables and LOB are stored some where else, or such similar
functionality to enhance performance with multiple lobs in single table.
I do not think that anyone has so far indicated that
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
(Kathey implicity told you that):
System.getProperty(derby.system.home);
I have not tried it, but it is possible
jiangshachina wrote:
Hello,
The question may be so stupid, but I really have some puzzles.
Generally, JDBC is the connector between Java application and RDBMSs.
But I think that's because the RDBMSs aren't written by Java, then we need
the middleware.
Now that, Derby is pure Java application,
Mathias Conradt wrote:
Thanks for the hint, the schema is app.
It seems that when I use ij (EmbeddedMode) to connect to
jdbc:derby:realty;(create=true) and use hibernate, it
creates/connects the
database in two different physical location. When I use ij, the database
folder is created
Dhananjay Muli wrote:
Hello,
I am facing problem with a query in postgresql having following
condition in where clause
bullyear=(acadyear-year+1)
where acadyear, bullyear and year are columns of table. The existing
sqlgrammar.jj file has a problem parsing the 'year' token occurence
Jørgen Løland wrote:
tyoup wrote:
i'm having problems with the following query
select a,b,c from ta where (b,c) not in (select bb,cc from tb where dd
= 3)
wich won't work in derby
how can i work this around ?
Hi Tyoup
If I remember correctly, IN clauses can only take handle one
Daniel Noll wrote:
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
Aneez,
Can you provide the call stack for the exception you get?
--
Øystein
Aneez Backer wrote:
Hi
Am trying to connect to derby database, but have not been successful.
I have created a database called 24k , and have also populated the tables
Here's the code:
tom_ wrote:
I have tried with the latest bits/trunk, here the problem is an exception
upgrade from 10.3 to 10.4 is not supported.
Have you followed my advice about setting the
derby.database.allowPreReleaseUpgrade property?
--
Øystein
Briggs wrote:
Well, unfortunately, freeing the Blob didn't work, the app still runs
out of memory.
The app? Your first posting indicated that the server ran out of memory.
Also, the occasional commit is also causing a problem. I end up
eventually getting this:
java.sql.SQLException: The
musky wrote:
i will make my aim more clearer here:
i have created an AFTER insert trigger on a table called chattable which has
two fields(ID INT,Message VARCHAR(255)).here is the trigger:
CREATE TRIGGER insert_trigger AFTER INSERT ON chattable REFERENCING
NEW_TABLE AS chattableupdate FOR EACH
Øystein Grøvlen wrote:
I do not think doing a select in a trigger does not make sense.
Sorry, to many negations here. I mean of course that doing a select in
a trigger does not make sense.
JDBC
does not provide you with any way to get hold of the result set.
From your description, I think
Andrew Lawrenson wrote:
I've done some more experimentation testing.
At the moment, when syscolumns is updated, if a sub-transction is done, the
update is done with an expicit no-wait on locks.
I've tried changing this so that it will use the same wait policy as the parent
transaction - when
Mark Hiles wrote:
I've just started using Derby for a uni project and have a couple of
quick questions.
When creating an embedded database, it seems to get overridden each
time I run my application. How can I make it create a database the
first time it runs, and then re-use it in the future?
Mark Hiles wrote:
I've been using create=true and it just keeps overriding the existing db..
Someone mentioned to me that it might have something to do with the fact that
I'm running an embedded version.. I'm not sure why that would matter but could
that be it?
What do you mean by
unludo wrote:
OK thanks a lot for your answers.
Regarding the 'ORDER BY RANDOM()', you also plan to have something similar?
ORDER BY RANDOM() already works for me. Example:
ij select i from t where i 5;
I
---
1
2
3
4
4 rows selected
ij select i from t where i 5 order by random();
Vic Ricker wrote:
Sorry about that. I added something to dump follow getNextException()
and getCause(). I got the following exception from getCause(), I
believe. I don't think getNextException() returned anything.
org.apache.derby.client.am.DisconnectException: A network protocol error
Rick Hillegas wrote:
A number of Derby people have expressed interest in getting together
the week of Java One. I'm thinking that people may be busy attending
sessions during Java One itself, so it might be better to meet the first
day before the Java One sessions start. That would be the
Templexp Tan wrote:
Hi,
There are some problem like the following:
java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ001,
SQLERRMC: java.lang.NullPointerException#20;#20;XJ001.U
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at
Andreas Kyrmegalos wrote:
Hello again,
I don't know what to make of this. I blame it to the late hour though.
After successfully authenticating user usertest through LDAP to
establish a connection , I get this message
ERROR 42Y07: Schema 'usertest' does not exist
when executing a
Daniel Noll wrote:
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
vodarus vodarus wrote:
it takes up to 12 seconds to calculate TESTTOTALS. Oracle PL/SQL
procedure with the same algorithm need 1,5 second.
*How can i improve performance? Or Derby is so slow because of Java /
JVM issues???*
Thanks.
I do not have any experience with performance of stored
And what tools can you use to analyse big amount of relation-data? SQL
can not be used in many cases. So people usually use stored procedures
in RDBMS - PL/SQL in Oracle. I have idea: replase Oracle with Java
application. And that Java application have RDBMS inside (like Derby in
Embedded
vodarus vodarus wrote:
I thought tt using stored procedure will avoid transferring data from
DataEngine to Application.
That cost is very little when using embedded where both are executing in
the same VM.
Using Java + Oracle will be slower than usage of PL/SQL code.
But Java + Oracle
Curry, David CIV NAVAIR 41K300D wrote:
Vista, NetBeans 6.0, using embedded Derby driver.
I have 2 apps that share a database. admin.jar is the admin app,
demo.jar is a simple client that cannot change data in the database.
Both apps are in the same folder, along with the database folder.
Jamel Meslamani wrote:
Dear all,
I am using Derby10..3 with a chemical program JChem to update my
database. But now, I am facing this problem when I try to add more
structures. Error that I get is :
ERROR 25502: An SQL data change is not permitted for a read-only connection,
user or database.
Jonas Ahlinder wrote:
The benchmark client is single-threaded atm.
To run it multi-threaded some sort of locking will most likely have ot me
implemented ( which will be done as soon as we can confirmt he performance is
ok ).
I have tried running more threads, and it does seem to give better
Have you tried to run the Derby consistency checker? (See
http://wiki.apache.org/db-derby/DatabaseConsistencyCheck).
Maybe that could give some clue about what is wrong.
--
Øystein
jrgchip wrote:
I have reported the problem as
https://issues.apache.org/jira/browse/DERBY-4032.
The problem is
Peter Nabbefeld wrote:
Hello,
I just want to create a database, if it does not yet exist. Database
creation works, schema creation does not. I'm using the following syntax
(in Java):
Statement stmt = con.createStatement();
stmt.execute(CREATE SCHEMA USER);
The result is an SQLException
69 matches
Mail list logo