2013-10-11 07:33:05,767 [main ] DEBUG
factory.support.DefaultListableBeanFactoryReturning cached instance of
singleton bean
'org.springframework.transaction.interceptor.TransactionInterceptor#0'
2013-10-11 07:33:05,907 [main ] DEBUG org.hibernate.SQLvalues next value for
SEQ_USER
2013-10-11
I know I can just slap a synchronized block around these two methods
to make it bulletproof, but there are two problems with this:
(1) synchronized is slow and Derby's shutdown is not fast at all...
(2) I don't know what other apps might be open in the same JVM at the same.
I'm not sure
C:\Users\HeartBeat\Desktopjava org.apache.derby.tools.sysinfo
- Derby Information
[C:\Users\HeartBeat\Desktop\Derby\lib\derby.jar] 10.10.1.1 - (1458268)
[C:\Users\HeartBeat\Desktop\Derby\lib\derbytools.jar] 10.10.1.1 - (1458268)
CLASSPATH: .;C:\Program Files (x86)\Java\jre7\lib\ext\QTJava.zip;C:\Program
Files\Java\jdk1.7.0_25\db\lib;C:\Program
Files\Java\jdk1.7.0_25\bin;C:\Program Files\Java\jre7\bin
Don't name the *directories* here, name the actual *jar files*.
As in:
set CLASSPATH=C:\Program Files
C:\Users\Docecho %CLASSPATH%
.;C:\Program Files (x86)\Java\jre7\lib\ext\QTJava.zip;C:\Program
Files\Java\jdk1.7.0_25\db\lib\derbyrun.jar;C:\Program
Files\Java\jdk1.7.0_25\bin;C:\Program Files\Java\jre7\bin;C:\Program
Files\Java\jdk1.7.0_25\db\lib\derbyclient.jar
After making the changes and
C:\Users\Docjava org.apache.derby.tools.sysinfo
- Derby Information
JRE - JDBC: Java SE 7 - JDBC 4.0
[C:\Program Files\Java\jdk1.7.0_25\db\lib\derby.jar] 10.8.2.2 - (1181258)
[C:\Program Files\Java\jdk1.7.0_25\db\lib\derbytools.jar] 10.8.2.2 -
(1181258)
[C:\Program
Here's the output:
java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver
Hmmm...
It sure seems like a classpath problem, but you can find the
class when you run simple utilities like ij or sysinfo.
Perhaps the classpath that your application is running with is
somehow
On 8/22/2013 1:31 AM, Ayesha Dissanayaka wrote:
I am a newbie to derby and I would like to try out improve performances of
aggregate functions
Hi, and welcome to Derby!
In the area of improvements to aggregate functions
in Derby, you could consider working on the implementation
of window
I need script to create new schema app2 with the exact replica of app1 schema
Have you investigated dblook?
http://db.apache.org/derby/docs/10.10/tools/ctoolsdblook.html
thanks,
bryan
Exiting the VM isn't really an option for me anyway, this is just when
someone is closing the database, potentially planning to open another
one.
Another question along the same lines then - if I kick off the
shutdown in another thread, what happens if the same database is then
reopened while
i create one table in the already existing Derby by but table is creating
successfully but unable to insert the record.
What happens when you try to insert the record?
Do you get an exception?
What does the exception say?
Here's how to read the exception information:
Hi John,
Here's my perspective on what you posted:
1) Anytime you issue a SELECT statement with an ORDER BY, and the
rows don't come back in that order, that's a bug. As you point
out, it would be best if you could narrow this down to a simple
reproducible case when you report it.
However,
C:\Users\pocky\derby\db-derby-10.9.1.0-bin\DERBYTUTORjava -jar
%DERBY_HOME%\lib\derbyrun.jar server start
C:\Users\pocky\derby\db-derby-10.9.1.0-bin\DERBYTUTOR
It is odd that you didn't see any output from the command:
java server start
Normally when I run that command there is
I am using netbeans. When I use embedded driver in netbeans i get errors, even
though the derbyclient is in the
library. If i add derbyclient.jar in the client it runs perfectly, even though
the driver is:
Class.forName(org.apache.derby.jdbc.EmbeddedDriver).newInstance();
The choice of the
I caught SQLException and he said that : No suitable driver found for
jdbc:derby:MoneyBack1;create=true;user=miltone;password=password
So your classloader can't find the derby driver. Have you checked that
derby.jar is on your classpath?
The sysinfo tool is useful for diagnosing classpath
On 02/18/2013 07:40 AM, Wujek Srujek wrote:
Hi. But why is there any local transaction? I haven't started any, I just set
autoCommit to false
There is always a transaction; Derby won't let you ever
access the database without one.
What auto-commit does is to automatically commit the
One more question, though: the uncommitted insert comes up
in the subsequent select - is this data coming from the server,
from the active tx, or does the jdbc driver cache the data somehow?
The results are coming from the server. The server shows you your own
uncommitted updates, but won't
What I can't figure out is the name of the database the network client
should connect to, aka the last element of the JDBC URL.
The last element is basically the same: it is the path to the database,
starting from the network server's derby.system.home location.
So if you do:
The change in timing is spectacular: it now takes about 0.4 seconds
Great news!
I think it would be cool if you could write up a short summary of
your findings and put it on the hints and tips section of the
Derby community wiki.
thanks,
bryan
Forwarding to the list.
On 12/19/2012 04:10 AM, 王旭 wrote:
*Hello Pendleton*
**
*I am a loyal user of derby database from China. I found some problems
in the course of use, so I need your help urgently.*
**
*Derby Version**:**10.4*
*Question one**:***
Firstly, I created a
I've checked my computer and couldn't find another version of derby
installed anywhere.
The 'sysinfo' tool can be useful for figuring out which copy of Derby
is getting run, and from what location:
http://db.apache.org/derby/docs/10.9/tools/rtoolssysinfo41288.html
thanks,
bryan
My company is evaluating whether to use Derby for a desktop/client-server
application where security and 21-CFR 11 compliance is important.
Although Derby can be used perfectly well as a standalone database, it
is also designed to be embedded into a containing application.
The Derby libraries
while ago I knocked up a Maven plugin which can start Derby for you during
the build (in the same VM) and be used by integration tests (which are not
forked. of course).
Hi Martin,
You might want to add some information about your tool to the Uses of Derby
section of the Derby wiki at
. What does U and X mean after the trans. Ids?
The query is:
DELETE FROM TRIP_TIMETABLE
WHERE EXISTS(
SELECT ID FROM TRIP WHERE (ID IN (?)) AND ID =
TRIP_TIMETABLE.trips_ID
)
What can be wrong with this query?
I'm not exactly sure what's wrong, but I agree that they both
DELETE FROM ConnectionEntity conn WHERE conn.stopOrPass.id
IN +
(SELECT sop.id FROM StopOrPassEntity sop WHERE
sop.partialTrip.id IN +
(SELECT prtTrip.id FROM PartialTripEntity prtTrip WHERE
prtTrip.trip.id IN : Ids))
There have
And that would lead me to expect that each engine (and therefore class
loader) would get its own, separate namespace of in-memory databases.
That seems like correct behavior to me.
thanks,
bryan
ij CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('/usr/local/derby10/backups');
...
ERROR 38000: The exception 'java.security.AccessControlException: Access denied
(java.io.FilePermission
/usr/local/derby10/backups/PRAT write)' was thrown while evaluating an
expression.ERROR XJ001: Java exception:
So the 'boolean' word definately works, just not in the instance of a
create table as statement.
Yes, that sounds like a bug. Boolean has recently been added to the
DDL language, and this might have been missed.
Did you try searching JIRA to see if it's a known bug? If not, please
log a bug
i need to connect my java code with ma database..hou should i
write the database connection code in windows..i need
hostname,name of the db,type of driver,tcp/ip port no of db,username,password.
http://db.apache.org/derby/docs/10.9/getstart/
bryan
I was given some data for academic research purposes all zipped up. Once I
opened them I found out I had part of a derby database! (two folders were
sent; seg and log).
I'm now trying to reconstruct a derby database with these folders but not
having any luck. I essentially created a new db with
On 08/17/2012 04:05 AM, Stefan R. wrote:
database, got an I/O Exception while writing to the backup container file
/mnt/backup/2012-08-13-00-00-00/bd/seg0/c9b1.dat.#012#011at
org.apache.derby.client.am.Statement.completeExecute(Unknown
...
org.apache.derby.client.am.SqlException: Java
After adding these in, I get assertion failures when trying to run
some queries, which is perhaps not surprising.
Seemingly, it seems all the user conglomerates are present, looking
at the list of filenames present.
Is there any way I can get this database into a useable state?
I can't think
I would have expected that around line 175 I would get the row count
as it was before the uncommitted
transaction started and that no lock would be needed to just read.
Unfortunately, Derby doesn't currently implement these snapshot isolation
types of semantics.
Is this the way it is supposed
1) Does Java DB support database level audit trail ?
Derby does not provide any support for tracking security-related operations.
If you only need to audit update statements, you may be able to
define triggers that do what you need.
Typically this is done by having your triggers append
These Derby dbs (version 10.5.1.1) are stored on a NAS (cluster Isilon NL
series) shared between
webservers. The derby db is directly acceded on NAS and it is thread safe.
When you say the Derby dbs are stored on a device shared between webservers,
do you mean that there are Derby
I am attempting to configure Derby with Eclipse. I have downloaded the DerbyUI
svn source and after importing the source into Eclipse per the instructions I
have an error in the plugin.xml file indicating org.apache.derby.core cannot be
resolved.
Has anyone else encountered this and know what
Caused by: java.io.FileNotFoundException:
D:\repos\TOPIK\workspace\log\db_20120614_114744\loggingDB20120614_114744\log\log2846.dat
(The process cannot access the file
because it is being used by another process)
Check to see if you have an active Anti-Virus scanning program
which is monitoring
Does anyone have explanation on the error? Is there anything we can do to drop
the table successfully?
There's some sort of a bug here. If you can file it in JIRA with whatever
supporting
information you can provide (ideally, a reproduction case or perhaps a backup
of the
database with this
On 07/03/2012 03:20 PM, TXVanguard wrote:
Don't worry too much about the details: just look at the SELECT DISTINCT,
the WHERE, the GROUP BY, etc. What are some general strategies for speeding
up this kind of statement?
What the community knows about this sort of thing is mostly collected
On 06/30/2012 02:24 PM, fed wrote:
I have a derby database 10.8.x and i use it with jdo/datanuclues.
I am trying to update it to 10.9 but after updating it the database
becomes unusable, it gives me an ArrayIndexOutOfBoundsException on
conn.getMetaData().getIndexInfo(... ).
From time to time,
Derby is used heavily in my project and its tables are frequently accessed
concurrently by multiple threads. Some threads update
one or several tables, while other threads perform run select statements
against those. I’ve written to this group several times
whenever errors occurred, but some of
Currently I have a DB named myDB and myDB consists of a few tables in it.
Lets say I want to write to myDB from different computers concurrently(each
computer will have its own myDB), how do I merge and combine the DB from
each computer into 1 central DB at the end of the day?
One technique is
How to limit thesize of db file afterlarge amounts of insert and delete
operation?
One common technique for handling this pattern of activity, is to use
a collection of tables, rather than a single table, and to drop entire
tables rather than deleting rows from an existing table.
For example,
C:\java org.apache.derby.tools.sysinfo
Error: Could not find or load main class org.apache.derby.tools.sysinfo
C:\echo %CLASSPATH%
C:\Program Files\Apache\db-derby-10.8.1.2-bin\lib\derby.jar;C:\Program Files
\Apache\db-derby-10.8.1.2-bin\LIB\derbytools.jar;
Sometimes it is hard to get the
*_java.lang.OutOfMemoryError: Java heap space_*
Is it because of the size of our database (3,1 GB!)? and what can I do to
improve the performance of the Derby Database, and
to resolve the error?
The Derby Tuning Guide provides a lot of useful general advice about how to
tune the performance
and echo $CLASSPATH
/home/kb9agt/jdk1.7/db/lib/derby.jar:.
I see A : separated list of directories
I think I need
java -cp $CLASSPATH WwdEmbedded
Yep. Did the trick. Please update the tutorial as soon as you can.
I'm glad you got it figured out, but I'm not sure what's wrong.
The whole point
confused here on the archived logs and the active logs.
In general, there can be multiple logs covering the time between one
backup and the next backup, and those logs must be applied, serially,
in the correct order, to recover the database fully.
Once you take that next backup, you no longer
room. I have noticed that no matter what I do, the ~10MB of memory that is
taken when the database connect is initiated is held no matter what commands
Certainly sounds like the database isn't getting fully shut down.
dynamDS.setShutdownDatabase(shutdown);
It's not clear to me that this
On 02/26/2012 08:43 AM, Libor Jelinek wrote:
Hello everbody!
I would like to ask the community how to see a list of connected clients to
Derby Network Server?
Have you tried runtimeinfo:
http://db.apache.org/derby/docs/10.8/adminguide/tadminappsruntimeinfo.html
thanks,
bryan
Why i aways got an StackOverflowError exception when i try to run CALL
SYSCS_UTIL.SYSCS_COMPRESS_TABLE() ?
...
Caused by: java.lang.StackOverflowError
at java.lang.ThreadLocal.get(ThreadLocal.java:125)
at java.lang.StringCoding.deref(StringCoding.java:46)
at
get reports (and also felt it our self) that our app simply is losing
its connection to the DB.
What are the symptoms, exactly?
That is, what is it that makes you think you are losing your connection?
One thing that occurs to me is a bit of a long-shot: are you using a
connection pooling
=== java.io.IOException: No space left on device at
sun.nio.ch.FileDispatcher.pwrite0(Native Method) at
Also check if your database is located on a FAT-32 filesystem or
similar, where database files are limited by the filesystem to
a max 2GB size.
Similar things can happen with
We have one particular user reporting an issue where getRuntimeInfo()
stalls while trying to read the data back from the server:
SwingWorker-pool-1-thread-3 Id=48 RUNNABLE
at java.net.PlainSocketImpl.isConnectionReset(PlainSocketImpl.java:623)
- locked java.lang.Object@48183ac5
On 02/02/2012 02:53 PM, TXVanguard wrote:
UPDATE T1 INNER JOIN T2 ON (T1.A= T2.A) SET T2.B = T1.B
Perhaps something like:
update t2 set b = (select b from t1 where t1.a = t2.a)
thanks,
bryan
Yes, autocommit is turned off.
Any other thoughts?
Well, I never had any trouble getting the LOCK TABLE feature to work,
so I'm not sure what's wrong.
One possibility is that the query plan output is misleading you.
That is, although the query plan output might indicate that the
optimizer is
I have tried to force table level locking by;
1. SQL - lock table wayNodes6 in share mode
2. st.execute(call
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.locks.escalationThreshold','1'));
But the query execution plan always states it has chosen row level locking
Do you have autocommit
well i use jdbc.EmbeddedDriver for my db connectivity and i connect to mydb
with this statement jdbc:derby:C:/Users/user1/firstdb i get in the
firstdb folder but i do not see the tables i have created.so where are they?
Make sure you say ;create=true at the end of your connect statement,
What root canal Just to get column names of an index
I always just use ij's show indexes command.
http://db.apache.org/derby/docs/10.8/tools/rtoolsijcomrefshow.html
thanks,
bryan
ResultSet rs = s.executeQuery(values upper('Straße'));
So it seems the value is returned correctly, but the meta-data is wrong
(STRASSE is 7 characters long, not 6). ij uses the meta-data to
determine how much space each column should have.
6 *characters* long, but 7 *bytes* long?
Do we
Exception in thread main java.sql.SQLException: Import error on line 1 of
The error message is telling you that the error is on the very first line of
the data file.
Sometimes spreadsheet exports contain a special column headers row at the very
start. Usually your spreadsheet tool has a
On 11/22/2011 04:01 AM, Peter Ondruška wrote:
I would extend your question: is there any difference in commit or rollback
after single select statement?
Nothing much that I ever found. I always use commit to complete my selects,
because it feels cleaner, at the application level, to use
is there a way to mix an unique column with null values. So that i have an
column where only unique values are allowed with the
exception of multiple null values.
Yes.
Since Derby 10.4, that is the way that Derby's table-level UNIQUE constraints
have worked. See:
On 10/27/2011 09:26 PM, Sundar Narayanaswamy wrote:
I insert 1 rows into the table, then delete all that rows. I then call
SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
with just the option to purge rows so that the space left behind by deleted
rows can be reused for future inserts. I have
the
Is it possible to give rules of the following kind:
Every field of type INTEGER will take N bytes (N=4?),
every field of type VARCHAR(X) will take I*X+J bytes (I, J =?),
every field of type VARCHAR with NULL value will take K bytes,
every row will take the sum of all field-widths plus L bytes,
I'm using Derby-10.8.1.2 bin installation for use in my program,
I got the following error stack :
java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver
And is derbyclient.jar in your CLASSPATH?
thanks,
bryan
I'm newbie of derby but there is something not clear for me.
There are soo few data that 12MB seems to excessive...could you please let me
know?
SYSCS_DIAG.SPACE_TABLE can help you figure out where your space goes:
http://db.apache.org/derby/docs/10.8/ref/rrefsyscsdiagtables.html
thanks,
the call jdbc:derby:EMDatabase;create=trueis not a valid call to embedded
driver. It is a call to a derby server
correct url should be ( as far as I know) jdbc:derby:path to
database;create=true
No, the server-style URL always has the double slash after the derby:, as in:
C:\WINDOWS\SYSTEM32\java.exe -splash:EMsplash.jpg -jar C:\Program
Files\ElectionManager\EMServer.jar
Not sure if this is the problem, but I believe that if you use '-jar' on
your command line, then CLASSPATH is ignored, and ALL the classes have to
come from the jar, right?
thanks,
bryan
I am getting error that database 'wombat' not found.
You can specify ;create=true at the end of your connection URL and
then Derby will automatically create the database for you.
thanks,
bryan
pstmt.setString(1,cobj.getPartNo());
where the getPartNo() method returns null. When this happens I get a null
pointer exception.
It's not an exact match, but your description sounds VERY close to
https://issues.apache.org/jira/browse/DERBY-1938
Can you post a full stack trace of your
On 07/18/2011 07:16 AM, Lahiru Gunathilake wrote:
Hi Byan,
I am creating the connection with autoCommit=true parameter, does this work
with derby or should I explicitly commit the
transaction?
Lahiru
I believe if you do this, the system will automatically insert a 'commit'
immediately
I execute query lock table table name
in share mode but I cannot see any documentation on how to unlock a derby
table.
Commit.
thanks,
bryan
1. Does the compiler take the amount of records in consideration when
compiling the query?
Yes. The optimizer has statistical information about the size of
the various tables, and about their keying structures, etc.
2. Am I right to assume the cause of the delay is in the excessive
amount of
On 07/05/2011 11:12 PM, dinesh nautiyal wrote:
Hi,
I want to use derby database with Eclipse,Plz suggest me how to pulg in Derby
with eclipse.
Thanks and Regards
Dinesh.
Perhaps you are looking for a resource like this:
Now, I was using the SQuirreL SQL Client to look at my databases
as they were being created, but I couldn't use ij with the database
*_and_* SQuirreL at the same time.
Correct. Two separate JVMs cannot both access the same database using
the embedded driver concurrently.
What I'm wondering
Yes, I think you should file a JIRA. For what it's worth, it seems to
work with a URL like this:
jdbc:derby:https:http://localhost:8080/ipinfo
Wow! Is this in the Derby docs somewhere?
thanks,
bryan
can it be used for big enterprise applications?
Yes!
does data access and write operations gets slow down as volume of data
increases over time?
Somewhat, but you can get tens of millions of rows into a well-designed Derby
database
without any noticable slowdown.
is there any
According to the JavaDoc, there exists a
org.apache.derby.impl.io.URLStorageFactory, which is addressed by using the
http sub
protocol. However, when I attempt to access the following URL, Derby throws an
exception:
Connection _conn_ =
On 06/16/2011 11:38 AM, Lothar Krenzien wrote:
But shouldn't it works with JDBC too ?
Perhaps you are looking for the batch facility of JDBC, as in the
addBatch/executeBatch methods on java.sql.Statement:
http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Statement.html#executeBatch()
On 06/07/2011 12:38 AM, Vijender Devakari wrote:
Hi,
Can you respond to this as this is very urgent.
Mike replied:
http://mail-archives.apache.org/mod_mbox/db-derby-user/201106.mbox/%3c4de90f37.2040...@sbcglobal.net%3E
problems above. I suspect derby has been terminated or interrupted while
updating the service.properties file and left the file system in an
inconsistent state. Although I imagine the window for this to happen would
be fairly narrow.
As far as I can tell the call to
I am using *ij-tool* just for look up. It works great on windows. When I use it
on a bash-shell (Solaris) the *cursor-keys* do
not work, but I get some strange letters typed like this:
*ij select ^[[A^[[B^[[C^[[D*
It seems that those keys are not defined in some way. They work with in the
In the webapp:
server = new NetworkServerControl();
server.start(null);
Perhaps your webapp is trying to run these lines multiple times?
It can be very tricky to ensure that your webapp starts the
Network Server once and only once. You may be starting it
a second time, and the second instance
On 04/01/2011 07:40 PM, Kris Hayden wrote:
hello. i have been coding an application by hand and have been having
a hard time getting the derby.jar file to be loaded from inside my jar
Do you literally mean a jar-within-a-jar, not a jar-within-a-war and
not a jar-within-a-ear? I don't think
On 04/02/2011 08:32 AM, Matt Pouttu-Clarke wrote:
The JDK loads the jars correctly as long as the manifest is updated
correctly. Use it all the time with Derby and it works great.
Thanks Matt! That's good to know; I was unaware of that capability.
If you have time to put a few pointers to
Perhaps the Derby generated columns feature would be of help.
You could write some code that would generate the search values
by processing your blob of data, then build an index on the
generated search terms.
Knut Anders has a nice writeup of generated columns here:
Is it possible to import data via SYSCS_UTIL.SYSCS_IMPORT_DATA when the first
row of data is a header that contains column
names? For example the data are orgnized like this:
name,age,weight
bob,17,150
sue,18,120
If not, does anyone know a workaround?
I've always just stripped off that first
On 03/14/2011 02:42 AM, bilal haider wrote:
contents of startserver.bat
set CLASSPATH=lib\derby.jar;lib\derbynet.jar
java -cp %CLASSPATH% org.apache.derby.drda.NetworkServerControl start -h
localhost -p 1527
pause
and the posdb and startserver.bat are in same location.
any derby rule or good practice how many commits are to be
done in respect of how much memory is assigned to the JVM derby resides in?
In general, a commit should be performed at the completion of a
natural unit of work in your application, to tell the database
that you are finished making
On 03/08/2011 10:01 AM, malte.kem...@de.equens.com wrote:
close prepared statement after each operation, because there might be a pooling
within derby or derby driver for those statements, or should I
rather leave those three kinds of prepared statements (insert,
update delete) open till my
On 03/07/2011 04:35 AM, Prakash Jaya wrote:
After creating the database with user name and password in eclipse , then after
restarting the server , when trying to access
the data it is saying schema does not exist.
but before restarting the server i am able to access
The most common cause of
On 02/25/2011 11:43 PM, linux86 wrote:
Can I ignore the lock on db or access to db in read only mode?
No, those techniques are likely to bring crashes and database
corruption, I'm afraid.
In general, the only way to have multiple independent Java executables
accessing the same Derby database
The runtime statistics yields the following output for statement 1
(first prepared statement compile) and statement 2 (same prepared
statement executed again with different parameter):
Begin Compilation Timestamp : 2011-02-24 13:09:50.816
End Compilation Timestamp : 2011-02-24 13:09:50.901
18 Feb 2011 18:17:35,218- Thread: 15 SEVERE [com.vontu.lookup.csv.CsvLookup]
Failed to initialize Csv lookup.
Cause:
com.vontu.lookup.common.InitializationException: The exception
'java.sql.SQLException:
Column 'COLUMN2' is either not in any table in the FROM list or appears within
a join
but I run into following error on startup of the database (no matter
what application (my app, SQuirrel, OpenOffice base) I use, and with
all databases I could find):
Restore of a serializable or SQLData object of class , attempted to
read more data than was originally stored
I'm not sure
C:\Program Files (x86)\NetBeans 6.9.1\javafx\javafx-sdk\binjavafx
-classpath c:\application\application.jar application.Main
and application starts correctly. When I click on button to interact with db
an exception occurrs, saying it can't find db
The database name typically is written in your
update T_Professor set weight_In_B_D = weight_In_B_D + ?) - ?) *
?) / ?) where (id = ?)
I'm not sure why the arithmetic is carried out using different
intermediate scale and precision when you use dynamically substituted
values for the constants in your expressions.
Did you try using the
I'm using linux. DB size is 350MB only.
The problem is solved once I restart derby. Derby version is 10.6.
Hmmm... Interesting. I haven't seen this behavior before.
Possibly you had an active transaction, which had performed
some updates but had not yet committed, and the database
was
I'm new to derby, when I start writing data into db i'm getting the follwoing
exception from derby.log
can any one help me to fix it.
= begin nested exception, level (1) ===
java.io.IOException: No space left on device
Welcome to Derby.
You have filled up your disk.
Thanks. I've verified disk space. It has enough space.
FilesystemSize Used Avail Use% Mounted on
/dev/xvdf 99G 18G 77G 19% /mnt/rw-ti
ERROR XSLA0: Cannot flush the log file to disk
/mnt/rw-ti/rw/DerbyDatabase/TICYCLESMFR/log/log1460.dat.
There are
101 - 200 of 575 matches
Mail list logo