Dear,
I use derby in my application. There is no complicated technologies to be
used, only 2- or 3-tiers architecture: derby+ibatis+J2EE/Java application.
The Java application will run periodically some piece code every time. The
time costs for that about several hours.
Yes, there are over millio
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
Hello,
I've been experiencing intermittent errors in derby.log that look like this:
The errors are causing queries to fail.
2010-05-03 11:29:29.400 GMT Thread[GC.EndPointInfo Runnable Thread -
xyz.middleware.remoting.connection.gc$endpointinf...@1cf3127,5,main]
(XID = 1089), (SESSIONID = 3), (DA
Hi,
having set-up SQL authorisation I would like to grant data modification rights
(insert, update, delete) to stored procedures only.
I was assuming that granting executing rights on a routine using GRANT EXECUTE
ON PROCEDURE to appl_user (with appl_user being a role) would automatically
grant th
Hi,
is it possible to disable/ enable a foreign key using SQL statements?
Thanks.
--
View this message in context:
http://old.nabble.com/is-it-possible-to-disable--enable-a-foreign-key-using-sql-statements--tp28439979p28439979.html
Sent from the Apache Derby Users mailing list archive at Nabbl
what are the names of the new files after the transaction that
tried to create the existing table them commits? If they are still
c*.dat then there
is definitely something wrong. If they start with a different letter
then it could be that derby is acting as expected and just did not get
aroun
I am sorry to say I didn't save the database directory and have since worked
around the problem by checking to see if the table exists before creating
it, so I don't know the names of the files. If it's important, I'll comment
out my changes for now and recreate the problem and tell you what I'd s
BTW, given that I as a user can check to see if a table already exists,
maybe the CREATE TABLE code could do the same, rather than rely on a unique
key violation?
On Mon, May 3, 2010 at 2:25 PM, Mike Matrigali wrote:
> what are the names of the new files after the transaction that
> tried to crea
Thomas writes:
> Hi,
>
> having set-up SQL authorisation I would like to grant data modification rights
> (insert, update, delete) to stored procedures only.
> I was assuming that granting executing rights on a routine using GRANT EXECUTE
> ON PROCEDURE to appl_user (with appl_user being a role)
I've been experiencing intermittent errors in derby.log that look like this:
Caused by: java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:485)
at org.apache.derby.impl.store.raw.log.LogToFile.flush(Unknown Source)
What problem I have is, the application can run for the first time, but
for the second time, it can not been completed because that derby will
be very slow.
Do you completely exit and re-start the application between these two runs?
If not, then perhaps the application is not entirely freeing a
Do I understand correctly that, if my procedures had been defined by the
database owner (which they were in my case), then additional grants would not be
required => would Derby support running routines with definer's privileges? If
so, I would file an improvement request.
For the time being, is t
12 matches
Mail list logo