Hi,
I am not sure this can be considered a bug. The SQL model is relational,
and a priori rows can
appear in any order unless the query specifies an ORDER BY.
The index in this case is on c2 only, so as for the order of c1, bets
are off.
If you want the rows to come back sorted on c1 as well
You need to send a mail from the account you subscribed with to
derby-user-unsubscr...@db.apache.org
mailto:derby-user-unsubscr...@db.apache.org
cd this web page: http://db.apache.org/derby/derby_mail.html
Thanks,
Dag
On 12. juni 2014 17:24, Frank Rivera wrote:
Sincerely,
Frank Rivera
Tim,
if you could produce a JIRA with a repro for this scenario, we could
take a look at the generated code for the query.
Thanks,
Dag
On 11. juni 2014 16:48, Tim Dudgeon wrote:
Hi Tim,
I'm sure I don't understand the complexity of your problem. But it
sounds as though there may be tuples
Tim,
if you could produce a JITA with a repro for this scenario, we could
take a look at the generated code for the query.
Thanks,
Dag
On 11. juni 2014 16:48, Tim Dudgeon wrote:
Hi Tim,
I'm sure I don't understand the complexity of your problem. But it
sounds as though there may be tuples
Are you sure you are looking at the correct override (in case you have
several)?
I tried the one below and it didn't give me any syntax error.
A similar sample below also works as expected:
$ java -jar ~/java/sb/sb0/jars/sane/derbyrun.jar ij foo.sh
ij version 10.11
ij connect
,
-Rick
Best,
Chux
On Tue, Apr 8, 2014 at 12:32 AM, Dag H. Wanvik dag.wan...@oracle.com
mailto:dag.wan...@oracle.com wrote:
On 06. april 2014 21:02, George Toma wrote:
Hi Chux,
In my opinion the example from app. referred at commit the
transaction OR close the connection
On 04. april 2014 20:43, Zorro wrote:
Ajay Kumar Srivastava schreef op 3-4-2014 14:58:
Hi , I am struggling with crating JNDI connection with JBOSS for
derby. When I try to access table from a Servlet I use to get error
Caused by: javax.resource.ResourceException: Wrong driver class
[class
On 06. april 2014 21:02, George Toma wrote:
Hi Chux,
In my opinion the example from app. referred at commit the
transaction OR close the connection ( a connection could be transacted
too ), and not to shutdown the db. If the business rule specifies that
the db. needs to be shutdown when
On 22. feb. 2014 02:48, Turtles wrote:
I have java defined already the full command line would look like:
C:\Java Server JRE\jdk1.7.0_51\bin\java.exe -jar derby.jar %DERBY_OPTS%
-classpath %DERBY_RUNPATH% org.apache.derby.drda.NetworkServerControl
start
If you use the -jar option, you need
On 01. feb. 2014 17:31, Bryan Pendleton wrote:
On 1/31/2014 8:43 AM, John I. Moore, Jr. wrote:
One final point of clarification to my original email:
John, thanks for sharing all your findings, and thanks all of you
for the pointers to detailed information. I've tried to collect
it all at:
On 01. feb. 2014 18:20, Paul Linehan wrote:
Hi again all,
I normally connect to derby using either ij or SQuirreL SQL
or both.
Found it!
Using connect 'jdbc:derby://localhost:1527/pdata/firstdb';
I can use multiple connections - I was using a different connection string
CONNECT
On 18. nov. 2013 04:53, chongsoft wrote:
I'm using derby for 4 years, all the time I don't known how to drop a bad
table( file damaged)?
For example, if a file in seg0 named c20.dat is damaged or deleted, so
the associated table tablexxx can not be used,and even cannot de droped
with drop
On 05. nov. 2013 20:31, Katherine Marsden wrote:
On 11/5/2013 9:32 AM, Oskar Zinger wrote:
Hi Kathey,
Nope that does not seem to help.
Can you post a small reproduction of what you are seeing? Then maybe
someone familiar with replication can help identify what is going on.
Probably the
Hi,
I don't believe this situation has changed since 10.8. I agree this
situation could be improved, so I suggest filing an improvement request
in JIRA. It would also help if you could supply a self contained repro
(not strictly necessary, as I believe the description is clear enough,
but it
Derby doesn't support SQL/PL style trigger actions. You can package
custom actions in a Java stored procedure or function, though, and
call it in the trigger action. Cf.
http://db.apache.org/derby/docs/10.10/ref/rrefsqlj43125.html#rrefsqlj43125__i1149821
which has an example of trigger action
Hi,
please see answer inlined:
On 01/08/13 10:02, Steve Ebersole wrote:
I am trying to work out how to define a Java stored procedure using
Derby that performs a insert/update/delete and results in the proper
update count on the JDBC client. But I have so far been unsuccessful.
Here is
nicinch nmaill...@yahoo.com writes:
Has anybody had this behaviour and a way to fix?
Try to open the database in ij and see it it is read-only at the Derby
level. If you can make modifications using ij, the error lies outside
Derby.
e.g. something like
$ java -jar DERBYROOT/derbyrun.jar ij
cached prepared statements. If
you still see the issue, we'd love to get a repro :)
Thanks,
Dag
Best,
Suat
On 08/07/2012 05:05 PM, Dag H. Wanvik wrote:
Suat Gonul suatgo...@gmail.com writes:
Thanks for the answer! Yes, I also suspected from such a condition and
yes, my application does
Suat Gonul suatgo...@gmail.com writes:
Hello everyone,
I would like to know that if there would be a certain case causing the
exception below. I can't reproduce that exception regularly though. The
conglomerate number seems to be different in each case. I looked at
several issues about
Suat Gonul suatgo...@gmail.com writes:
Thanks for the answer! Yes, I also suspected from such a condition and
yes, my application does concurrent changes to the revisionTable. One
thread might insert records into the revisionTable while the others
query/update it.
At the outset, only changes
TXVanguard brett.den...@lmco.com writes:
Here is an example of part of a typical query (some names have been changed
to protect the innocent) that I deal with:
This query is actually only a sub-query that is joined by a UNION to an even
larger sub-query to form a full query.
The full query
Mo Maison momai...@yahoo.fr writes:
Hello,
I have read the referenced thread with great interest,
and I have a related question.
If we replace NAS with SAN (SAN is basically a remote
block device).
If a single server mounts the SAN partition, and a single
derby server is run on this
John English john.fore...@gmail.com writes:
dbInsert lines 1056/1057 look like this:
stat.executeUpdate();
ResultSet r = stat.getGeneratedKeys();
so the failure happens when the prepared statement is executed, just
before the call to getGeneratedKeys().
I tried this sample, but saw no
Aristedes Maniatis amania...@apache.org writes:
It looks like this feature is not getting much attention:
https://issues.apache.org/jira/browse/DERBY-5179
Is there any workaround to changing collations on a database without
dumping all the data and reimporting it into a new database? Can we
Katherine Marsden kmarsdende...@sbcglobal.net writes:
Particularly DERBY-5474 [2] which seems to be a common usage model
This should probably be DERBY-5473 Index growth can occur with
update of ever increasing values?
Dag
with both increasing values based on timestamps and identity columns
Looks like a bug to me. The error XSCH4 Conglomerate could not be
created isn't being tested for in the Derby tests as far as I can
see. I also searched the bug tracker
(https://issues.apache.org/jira/browse/DERBY) in vain for this
particular error.
Looking in the code where the error is
Pavel Bortnovskiy pbortnovs...@jefferies.com writes:
Besides best practices to avoid timeouts and deadlocks, I would like
to ask the following questions:
1) What's the default length of lock timeouts?
According to
http://db.apache.org/derby/docs/10.8/ref/rrefproper10607.html
Pavel Bortnovskiy pbortnovs...@jefferies.com writes:
1) What's the default length of lock timeouts?
60 seconds.
cf. http://db.apache.org/derby/docs/10.8/ref/rrefproper46141.html
Bryan Pendleton bpendleton.de...@gmail.com writes:
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.
What does java -version
Pallimakkal, Ambili V ambili.pallimak...@ca.com writes:
Hi,
We are having some issues with derby database on Z/OS.
You are using a fairly old version of Derby, 10.5.3.0. Can you
reproduce this problem with a newer version [1]?
[1] http://db.apache.org/derby/releases/release-10.8.2.2.cgi
v2cg4ss ssel...@datamentors.com writes:
I'm trying to assign values automatically to a row prior to the row
being inserted. I have no problem doing this with MySQL or Oracle,
etc...
However in Derby I was trying issued the following statement and the
last_update_uid is populated with the
Isabelle DASTUGUE isabelle.dastu...@sela-light.com writes:
Hello,
I am facing a problem with the commit: « java.sql.SQLException:
ResultSet not open. Operation 'next' not permitted. Verify that
autocommit is OFF. »
I found this documentation :
TXVanguard brett.den...@lmco.com writes:
I have several lines that look like this:
UPDATE T1 INNER JOIN T2 ON (T1.A= T2.A) SET T2.B = T1.B WHERE (T1.C = TRUE
AND T2.C = 5)
I don't believe Derbys support updating JOINs, which is why you need to
rewrite the query as suggested earlier in this
John English john.fore...@gmail.com writes:
Hi all,
When altering a table the other day I discovered that any views that
reference the table get dropped automatically (and silently), as do
any views that depend on those views, and so on. This came as a nasty
surprise to me when I tried to
Mojo Nixon steve.b.fergu...@gmail.com writes:
I am no derby expert, but I have done the following before, with good
results. Make a backup copy of all the database files, in case it doesn't
work. Then delete the files in the log directory and try to boot the
database. You might lose some
This dirty hack worked for me, although its not efficient. Tricky to get
a BLOB into ij.. anyone has a simpler way? Probably better to write a
small app to load a set of files..
Thanks,
Dag
cat - foo.sql EOF
connect 'jdbc:derby:wombat;create=true';
create table t (id int, b
Trejkaz trej...@trypticon.org writes:
Yet Derby doesn't appear to be doing this. Is this a bug?
A username must be a valid SQL identifier in Derby. If you want to use
. inside one, you need to quite it. In Java, \john.smith\, in
SQL, e.g in a GRANT statement: GRANT xxx TO john.smith,
Note
Janardhan Mallela jmaly...@zetainteractive.com writes:
Hi,
My need is to connect to Derby through PHP. I am unable to connect to Derby
10.8.2.2 with IBM DB2 v 9.7 Data Client using PHP. But I am able to connect
to Derby 10.4.2.2 with same IBM DB 2 connector. Following is the error I am
ccmarquina ccmarqu...@gmail.com writes:
I would like to know if it's possible to use ROWID to update rows in a table
derby DB. I can't find information to do it.
No. You could use Derby's support for JDBC updatable scrollable result
sets in some use cases, or roll your own ids using auto
Sandeep Dixit sdi...@ohioedge.com writes:
Here is the scenario:
I had derby 10.8.1.2 up and running for about 10 days. Few hours ago
I stopped it and restarted it. However it appears that my data is
somehow messed up (or some setting that I am not aware of).
If I run select activitytypeid
Ritu ritu.g...@tcs.com writes:
Hii
I am facing the same problem . So, is there any other way to import bulk files
(400mb) in Derby database.
Do you use an in-memory database as well?
How to overcome this heap memory problem?
If you answered yes to above, you need to allocated more heap
Eyup Dogan Okkir e...@em-glass.com writes:
Hello All,
I want to setup a database with replication (hot would be perfect).
How to achieve this using derby javadb?
What to do to use NetworkServerControl to manage replication (i.e.
passing start stop master slave ...)
I see a lot of codes
Karl Weber karl.webe...@googlemail.com writes:
Is there a way to use an R-Tree with derby db? (Or a GiST?)
In [1] R-Trees are mentioned on page 55. Is it possible to add one's own
implementation on top of derby, if it is not added to derby? How would one do
this?
This would be a
Tim Watts t...@cliftonfarm.org writes:
java.sql.SQLSyntaxErrorException:
'SYSCS_UTIL.SYSCS_IMPORT_TABLE' is not recognized as a function
or procedure.
whenever I try to execute this code:
String statement = CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
On 9/19/2011 6:09 PM, wrote:
nice to contact every one,This is my first time to mail in
english,please forgive me.
#1.It seems that when procedure in a class was loaded, drop and
reloaded, the changes of JAR file havn't take effected!
Not quite sure what you did here, but did you look
On 9/20/2011 12:20 AM, Mike Matrigali wrote:
I think that new features that rick is proposing are valuable to some
set of Derby users, and welcome their inclusion in Derby. Having one
flag to enable a set of secure oriented features also seems reasonable
as long as users can still pick and
Raymon Morcos rmor...@us.ibm.com writes:
Hello
Is there a way to list all the existing databases using the ij script on
linux.
No. There is no central database of databases in Derby.
A database can reside anywhere in the file system. A priori, ij has no
idea where.
I do a 'find root -name
Hi folks,
we are always working to make Derby more secure; in this day and age,
security is ever more on people's minds for obvious reasons;
IT systems are everywhere and the bad guys never tire of finding new
holes to break them. Up till now, Derby creates database files and logs
using the
On 05.08.2011 16:35, De Meyer Tim wrote:
Hi,
We're working on a java webapp and using a derby database (v10.5) in
embedded mode.
The first version of the application went live about 2 months ago.
The application is used to make invoices and we also store the XML of
an invoice document
On 07.08.2011 18:54, roy.mi...@comcast.net wrote:
I have been happily using Derby for two years within IntelliJ Idea,
but have now hit a wall trying to deploy the application I developed.
I have tried setting the path to derby.jar on the command line and/or
in the CLASSPATH environment
Pavel Bortnovskiy pbortnovs...@jefferies.com writes:
Hello, all:
While executing a bunch of JUnit tests within the same JVM (all executed
by IntelliJ IDEA) I started seeing strange and unexpected errors occurring
.
Upon closer inspection, I noticed that in many of those tests tables with
://wiki.apache.org/db-derby/InMemoryBackEndPrimer
As you can see, you need to provide the drop=true connection
attribute to wipe the data.
Thanks,
Dag
Thanks,
Pavel.
From:
dag.wan...@oracle.com (Dag H. Wanvik)
To:
Derby Discussion derby-user@db.apache.org
Date:
08/05/2011 05:57 PM
Subject:
Re
Thomas Hill thomas.k.h...@t-online.de writes:
Hi,
I am on version 10.7.1.1 and have read manuals and searched the net trying to
find out how to obtain the *user* property used on the connectionURL from
within
a stored procedure.
The attempt to use the connection object and
Thomas Hill thomas.k.h...@t-online.de writes:
okay - true.
I was however wondering and wanted to test whether I could replace a
potentially in terms of performace more costly JDBC statement definition
and result set processing of a 'select session_user from sysibm.sysdummy1'
or you could
Paul French paul.fre...@kirona.com writes:
We run derby 10.5.1 on J9 on WM6.1/6.5
The derby web site claims a small foot print of 2.6MB ? How do I
achieve this? What is the 2.6MB actually measuring, heap, non-heap,
both ?
Our application is hitting resource problems on WM, so we need to
Brett Mason b.ma...@adinstruments.com writes:
It does seem that Cases 1 2 are fairly easy to reproduce by terminating
the Java process while it is updating service.properties. I've included some
sample code which will trigger the problem quite reliably when it is
terminated on the following
QA Wang Yang yang.w...@support.jinfonet.com writes:
Dear Derby
Could you tell me how tuning the performance issue?
This is running sample query to fetch data from Derby database
On my dual-core XP x-32 laptop the Corporate Overview takes 406(ms).
But we saw on the dual quad core it took
Lukas Eder lukas.e...@gmail.com writes:
Hi Dag,
If you'd like to have a go, have a look at the parser in
derby src root/java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj
I've had a look. Looks like a lot of stuff I'd have to find out first
before even getting the project(s) to
Hi Brett,
some possibilities below.
Brett Mason b.ma...@adinstruments.com writes:
We've recently had some of customer reports come in where Derby is failing
with problems related to service.properties. There are three different
cases but all appear to be similar:
Case 1:
ERROR XBM0S:
Lukas Eder lukas.e...@gmail.com writes:
2. It took me a while to understand that some of the missing artefacts
are actually generated (such as the output from sqlgrammar.jj). I
imagine that can be done with the main build target in the ant
build.xml
This is correct. sqlgrammar.jj is written
Hi Tim,
you could file a new JIRA issue and attach the database as a zip file if
it's not too large.
http://db.apache.org/derby/DerbyBugGuidelines.html
I see you use the debug version of Derby. In this particular case, it
would be interesting to know what happens if you run Derby with the
Tim Wu t...@terracottatech.com writes:
it's seeming more and more like a derby bug. Also double checked the
disk on the machine where this failed, seemed healthy.
Good to know.
I've filed DERBY-5248 and attached the db to it.
Thanks, Tim!
Dag
Loic Petit loic.pe...@gmail.com writes:
Hey everyone,
I use derby to store monitoring data. As I wanted to see the performance of
my service, I have created a table with multiple timestamps that corresponds
to different points of the computing.
In order to measure the delay I want to do a
Hi Thomas,
thanks for updating the info on Derby!
Thomas Mueller thomas.tom.muel...@gmail.com writes:
- Derby: at various conferences, for example JavaOne 2007 and Jazoon
2007, Derby included benchmark results for Derby and MySQL where Derby
won, but strangely the benchmark source code is
Tim Dudgeon tdudg...@informaticsmatters.com writes:
There are some other things here that might deserve some comment:
http://www.h2database.com/html/features.html#comparison
e.g. performance of embeded derby is slow!
Without qualification, such wholesale statements are close to
meaningless,
Rick Hillegas rick.hille...@oracle.com writes:
Are there any plans to implement that?
I'm not aware of any plans in this area. You are welcome to vote for
DERBY-1576.
Or even better, help us implement it :) Open source!
Thanks,
Dag
On 14.05.2011 15:39, Lukas Eder wrote:
From what I understand, Derby's long-term goal is to support window
functions in the SQL:2003 standard way, as many other RDBMS do already
(I know of DB2, Oracle, Postgres, SQL Server and Sybase providing
extensive support). Are there any such plans in the
Hi,
In general, this resource may help you understand how Derby uses locks:
http://db.apache.org/derby/docs/10.8/devguide/cdevconcepts30291.html
and specifically how to debug deadlocks:
http://db.apache.org/derby/docs/10.8/devguide/cdevconcepts50894.html
Hi,
Libor Jelinek ljeli...@virtage.com writes:
*derby.database.defaultConnectionMode=noAccess
derby.authentication.provider=BUILTIN
derby.user.sa=veryStrongPwd
derby.user.readonly=readonly
derby.fullAccessUsers=sa
derby.readonlyAccessUsers=readonly
*
My intention is to restrict access
Libor Jelinek ljeli...@virtage.com writes:
*derby.database.defaultConnectionMode=noAccess
derby.authentication.provider=BUILTIN
derby.user.sa=veryStrongPwd
derby.user.readonly=readonly
derby.fullAccessUsers=sa
derby.readonlyAccessUsers=readonly
Ooops, I missed the fact that you had
Rick Hillegas rick.hille...@oracle.com writes:
I don't see an existing JIRA for this issue. Feel free to log one.
Rick, do you know if there is a standard way of doing this (beyond the
JDBC escape function)? I didn't find anything in the standard. It could
be that this is one of those things
gbattinelli giuseppe.battine...@gmail.com writes:
Dear all,
I'm developing my first java application with derby db, using hibernate.
What 's strange for me is that with empty db (6 tables about) my derby db
appears to be about 30MB.
I created it by Netbans and I lave log,seg0 and temp
BONNEFILLE Guilhem guilhem.bonnefi...@c-s.fr writes:
An other solution is to compress (gzip) old part of history as we
never need to update them.
Is it possible to do this with Derby?
Derby doesn't have any built-in compression facilities. You say you
don't perform updates (or deletes), so
malte.kem...@de.equens.com writes:
way I use my program it is just executing a select statement. But now
there is the funny thing: derby puts out 25001 error. Obviously it
wants a commit for this select statement... is it because I also
defined those other prepared statements or does derby
Hi Rohit,
25.02.2011 19:43, Rohit Sawarkar ?:
Can I use Java DB for mobile applications (J2ME MIDP app)... Give me
some sample examples on how to enter record and how to retrieve
it Reply me as soon as possible ..Thanks in advance :)
You need a platform the supports Java ME
Pavel Bortnovskiy pbortnovs...@jefferies.com writes:
Caused by: java.lang.NullPointerException at
org.apache.derby.exe.ac96c5c136x012ex0b13x5d52x9ccc25960.e9(Unknown
Source) at
org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source) at
Brett Wooldridge brett.wooldri...@gmail.com writes:
We are currently using Hibernate with a table managed sequence scheme
(javax.persistence.GenerationType.TABLE), but now that Derby supports
Sequences we are considering migrating to real sequences
(javax.persistence.GenerationType.SEQUENCE).
Chris Wilson ch...@aptivate.org writes:
I think that every sub-SELECT must have a table alias in Derby, so add AS
t to the end of the query (after the closing parenthesis) and it might
work :)
This is correct, cf syntax here:
Hi,
Thomas thomas.k.h...@t-online.de writes:
java.sql.SQLException: Connection refused :
javax.naming.CommunicationException
: miniserver:10389 [Root exception is java.security.AccessControlException:
access denied (java.net.SocketPermission miniserver resolve)]
at
Thomas thomas.k.h...@t-online.de writes:
to start with? Is this an AccessControl/Security issue or an issue that it
does
I is anAccessControl/Security issue.
not know how to resolve the servername to an IP-Address? What exactly would I
need to put as 'permission java.netSocketPermission'
Akash akashkumar.agra...@iiitb.net writes:
What all index types can be used in Derby. Can i include my own index in the
code.
Only normal B-tree indexes, unique and non-unique. Generated columns can
be used to alleviate the lack of ability to index on expressions.
Interesting, Pablo! Thanks, I'll give a test drive!
Dag
John English j...@brighton.ac.uk writes:
Can anyone explain what this means? It occurs when I issue what should
be a straightforward insert:
INSERT INTO resource_usage (resid,xmlid,xmltable)
(SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?)
I think we had a similar
Hi,
I think there are some issues with this code:
Clemens Eisserer linuxhi...@gmail.com writes:
Table definition:
CREATE TABLE testtable (ikey INTEGER PRIMARY KEY NOT NULL GENERATED BY
DEFAULT AS IDENTITY, name VARCHAR(127))
JdbcRowSetImplrowset = new
Hi,
vipinsudhakar sumitha.arju...@lntinfotech.com writes:
Does full upgrade provide the facility of increasing page size? If
not I have to take the back up of the derby db of older version and create a
new database with newer version along with increase in page size and just
import
Phil ph...@vodafone.ie writes:
I assume that I can define a new role (remotesupportuser for example)
with the appropriate permissions and then grant this role to specific
users. Is there a way that I can configure the derby network server to
accept remote connections only from users with the
Elma Snyman elma.sny...@sas.com writes:
I am using Tomcat 6.0.29 and the Derby embedded driver 10.5.3 and JDK
1.6.0_18. When I shutdown Tomcat, I get the following errors in the
catalina.log file:
SEVERE: The web application [/MyApp] registered the JBDC driver
dag.wan...@oracle.com (Dag H. Wanvik) writes:
The Derby engine uses a thread local variable
TableDescriptor#referencedColumnMap, which contains a weak hash map
object. It seems the weak hash map object is still there when Derby has
shut down. Since it's weak (referenced objects
Ashish Jain ashja...@gmail.com writes:
derby.connection.requireAuthentication=true.
Setting this property in derby.properties makes it a system-wide
property, cf. your issue with shutting down the server. You could also
make it a database level property (it would then only protect access for
Veresh Jain vereshj...@gmail.com writes:
Hi Veresh, this questions belongs on the Derby user's list. This list if
for development issue.
As to your question, the fact that other databases work, doesn't mean
Derby is wrong, please provide som more detail about what you are doing.
For example if
Uriah Eisenstein uriaheisenst...@gmail.com writes:
I've searched the mailing list and JIRA but didn't find any mention of full
joins. I realize that they can be implemented using unions of left and right
joins and such, but IMHO are easier to read and write as well as quite
possibly more
land...@seko-se.de writes:
Hello, all,
after searching the web it seems to me that there is at least one person who
succeeded in using derby with the JVM CreMe for PDAs. But my own trials
did not end in success.
I am not familiar with CreMe, and I haven't heard it discussed as a
viable
For the record, this discussion continued on the derby-dev list:
http://old.nabble.com/Question-observations-on-purged-rows-and-insert-rates-td29368194.html
Roberto Lopez roberto.lo...@rhiscom.com writes:
Hi, i need execute to query, mi table is
CREATE TABLE PEOPLE (
ID VARCHAR(256) NOT NULL,
NAME VARCHAR(1024) NOT NULL,
APPPASSWORD VARCHAR(1024),
CARD VARCHAR(1024),
ROLE VARCHAR(256) NOT NULL,
VISIBLE SMALLINT NOT
vadali shlomivak...@gmail.com writes:
Hi Kristian, Thank you for your reply
The db can be off when i back it up. I am unfamiliar with any compress
routines.. any pointers would be helpful.
Have a look here:
http://db.apache.org/derby/docs/10.4/adminguide/cadminspace21579.html
the 3 database to synchronize each other on startup?
Thx in advance for any help.
Frank Boettcher
--
Dag H. Wanvik, staff engineer
Sun Microsystems, Java Core and Desktop - Java DB/Derby
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43496/+47 73842196, Fax: +47 73842101
Sun IM
daksha yadav daksha29081...@gmail.com writes:
Hi
I would like to ask how to install and run apache derby on Symbian mobile
phones.
It may not be possible. Derby requires Java ME/CDC
Foundation 1.1 as a minimum. Most cell phones only support CDLC.
But if your Symbian device supports CDC, you
Luis Mario Perrot lper...@hotmail.com writes:
I like derby very much and I am doing some test with the embedded
driver. I try to load a table with 1.8 millon record and made a java
application using netbeans. I got an out of memory error message at
run time. Try again with fewer records
Hi,
The following example works using a nested connection. Your procedure
comment says: get data source bean, get connection on ds. This
probably means the procedure SQL, would run in another transaction, so
before you make the calls, you should make sure that the caller has
committed the
Clark, Harry harry.cl...@knovalent.com writes:
create procedure createTempSchema (in schemaName char(254))
language java parameter style java modifies sql data
external name
'com.kve.vanguard.model.orm.dao.TempSchemaGenerator.createTempSchema';
:
call app.createTempSchema('temp00');
1 - 100 of 219 matches
Mail list logo