Trejkaz writes:
> Hi.
>
> Due to various accidents we have ended up producing a table with
> multiple entries for the same key (part of the accident is that the
> index was not created to be unique...)
>
> I would like to try writing a migration to delete out of date rows and
> perhaps even make
Grzegorz Zuber writes:
> Hi,
>
> I was doing wide research how can I do XQuery or XSLT query using
> Derby.
>
> I'm doing query like this:
>
> SELECT
> XMLSERIALIZE(
> XMLQUERY('
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
> xmlns:fo="http://www.w3.org/1999/XSL/Format";>
>
>
>
>
>
>
Peter Ondruška writes:
> Dear all,
>
> I have a database that has locks in SYSCS_DIAG.LOCK_TABLE. How do I
> remove those locks? I restarted the database but the locks are still
> there. SYSCS_DIAG.TRANSACTION_TABLE also has related record with
> status PREPARED. This database was used with XA on
gquintana writes:
> From documentation, Derby is supposed to implement JDBC4.2 which introduces
> JSR 310 (Date & Time API) support into JDBC (among other things).
>
> Reading http://openjdk.java.net/jeps/170, I would have thought the following
> code would work, but it doesn't:
>
> LocalDate bir
writes:
> The link :
> http://db.apache.org/derby/docs/dev/tools/ttoolsij98878.html (Tool and
> Utilities Guide) cannot be found.
>
> The link is located at the bottom of page:
> https://db.apache.org/derby/papers/DerbyTut/ij_intro.html
Thanks for reporting this issue, Han.
Looks like there are
Bob M writes:
> Hi
>
> It seems that I do NEED to delete this temporary folder before each opening
> of the database
>
> As I am very unsure of derby coding would somebody care to suggest what I
> need to add and where to add it?
Hi Bob,
Since Derby fails because it is not able to access the tm
Dyre Tjeldvoll writes:
> So, I have never heard about Dukascopy's Forex
> Platform before… what is that?
>
> Based on the callstack you provided it looks like none of Derby’s
> heuristics for locating a tmp directory works on this platform.
> Arguably it is a bug that you get an NPE, but the alt
Tim Dudgeon writes:
> On 03/09/2014 13:21, Knut Anders Hatlen wrote:
>> I don't think so. Derby doesn't allow UPDATE statements in BEFORE
>> triggers
>
> I was meaning to just set the column value from the sequence into the
> new values, not using an insert s
Tim Dudgeon writes:
> On 02/09/2014 13:37, Knut Anders Hatlen wrote:
>> Tim Dudgeon writes:
>>
>>> No joy. Seems like nothing extra is being logged.
>>
>> From the stack trace, cleanupOnError() seems to be called from this
>> catch block in
Tim Dudgeon writes:
> No joy. Seems like nothing extra is being logged.
>From the stack trace, cleanupOnError() seems to be called from this
catch block in GenericPreparedStatement.executeStatement():
} catch (StandardException se) {
/* Cann't handle recompiling SPS action recompile
Tim Dudgeon writes:
> Thanks for the response.
> So its seems I'm probably right that my trigger is the ultimate cause.
> Any ideas on how to work out what is failing here as the real culprit
> seem to being masked.
Hi Tim,
If you set the system property derby.stream.error.logSeverityLevel=0, s
John English writes:
> I have a table with two columns whose combined value I want to be unique:
>
> create table Foo (
> A integer,
> B integer,
> primary key(A),
> unique(A,B)
> );
>
> This works fine except when B is null, when I can have multiple rows
> containing identica
Martijn Blankestijn writes:
> In the "JDBC Maintenance Release 4.2" proposed changes the following
> is written
>
> "21 Add the following mapping to table B-4, Mapping from Java Objects
> to JDBC Types
> • Map the Java Object Type javax.time.LocalDate to the JDBC Type DATE
>
> 22 Add the followin
Tim Dudgeon writes:
> I'm having problems will calling functions from within a trigger.
> The problem seems to be with the outer function call (FLOOR() in this
> case, but it also happens with other functions). It works fine in the
> SELECT statement, but when used in the trigger it throws a
> Ar
Tim Dudgeon writes:
> I'd like to check that my understanding of how triggers work is correct.
>
> 1. There is no procedural language like PL/SQL. The only solution here
> is to use Java stored procedures.
>
> 2. Triggers can only execute a single statement. If you need to do
> multiple things th
Tim Dudgeon writes:
> I'm struggling with getting a function working that uses a Java static
> method that uses varargs.
> I understand this should work with 10.10.1.1?
>
> I create function like this:
>
> CREATE FUNCTION FORMAT_CPD_CODE
> ( FORMAT VARCHAR(100), VAL INT ... )
> RETURNS VARCHAR(20
Lasantha Siriwardana writes:
> Hi All,
>
> I've setup an derby in-memory db using derby distribution 10.10.1.1.
> Below are the configurations;
> Max Heap Size - 3GB
> Page Cache Size - 1
> I stored nearly one million records in a table with around 50 columns
> and trying to retrieve the data
irajon writes:
> I use Derby as an embedded database. My program Is sent to clients with the
> database. I have a client that installed an update to my software and
> somehow, a new table was generated incorrectly. The program did a create
> table, but when I look at this client's database, I
Frans Verster writes:
> Hi Guys and Girls,
>
> Sorry to bother.. I am making some Java DB / Apache Derby Table
> Functions, working very nice. I need to know the user querying the
> function to return only his/her items. How can I get the
> session/login/current user?
Hi Frans,
The SESSION_USER
"David G.P." writes:
> I still can't add the pronunciatioin, as the page is immutable...
The ContributorsGroup page on the Derby wiki was lacking an acl
directive that is present on the other Apache projects'
ContributorsGroup pages. Not sure if that's significant, but I've added
that directive
"David G.P." writes:
> I registered with the name "studiosi" in the wiki.
Hi David,
I've added your user name to
https://wiki.apache.org/db-derby/ContributorsGroup . I think that should
be enough to give you write access to the wiki. Please let us know if
you run into any problems.
--
Knut An
Pugazhal Srinivasan writes:
> In a application server we configure and use the Embedded derby server
> to register a derby function table (in EJB in our case) and are able
> to call the function from other places in the application, including
> servlet.
>
> But we are unable to call the same fun
Mamta Satoor writes:
> Manohar, this procedure was added in Derby 10.3 and that would explain
> why it won't work with 10.2. But I am not sure why it is not working
> when you try it with 10.5.
If the database was created with 10.2, the procedure still won't exist
if you just boot it with the 10
"Dag H. Wanvik" writes:
> 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 desc
Bob M writes:
> Hi
> I am working through Derby tutorial and am up to step 2 using 'ij'
>
> I tried the command connect 'jdbc:derby:DBName;create=true';
>
> and got the following error result..
>
> Thread[main,5,main] java.io.File Not FoundException:derby.log denied>
> ER
Burghard Britzke writes:
> it seems to be impossible to start the Network-Server as a maven goal.
> The maven dependency
>
>
> org.apache.derby
> derbynet
> 10.10.1.1
>
>
> loads a file named 'derbynet-10.10.1.1.jar'.
>
> When trying to Start the NetworkServerControl to start the
> Network-Serv
Virag Kothari writes:
> Hi,
>
> Is there a way to cast from clob to blob in derby?
> From the table at
> http://db.apache.org/derby/docs/10.2/ref/rrefsqlj33562.html, there
> isn't seem a direct or indirect way to do so.
Hi Virag,
I don't think there is a way to do that directly in Derby. You'll
jefffro writes:
> Suppose I have a view defined as the union of multiple table queries e.g.
>
> create view v1 as
> SELECT col1 as a , col2 as b FROM table1
> UNION
> SELECT col2 as a , col3 as b FROM table2
> UNION
> SELECT col4 as a , col5 as b from table 3;
>
> If I use this view in a
Rick Hillegas writes:
> On 8/25/13 2:40 AM, tim.wickett wrote:
>> Hi again, I am having more trigger problems. This time I am trying to create
>> a history when values are updated. This is my code
>>
>> CREATE TRIGGER update_location
>> AFTER UPDATE ON WASTE_ITEM
>> REFERENCING OLD AS o
Guillaume CHAUVET writes:
> Hi Knut,
>
> Thank you for your reply. So now, I use the ClientConnectionPoolDataSource as
> DataSource into my OpenJPA configuration.
> But getPooledConnection[X](...) methods aren't invoked by the ORM, only
> getConnection[X]() methods inherited from ClientBaseDat
Guillaume CHAUVET writes:
> IMO, an interesting feature will be a listener pattern provided by the
> JDBC driver. In this way, if a DisconnectedException will be throws,
> we will can notify a connection lost to another observers.
Hi Guillaume,
If you use org.apache.derby.jdbc.ClientConnectionP
Anon User writes:
> Greetings,
>
> With derby.infolog.append=true set, derby.log will not be delete and
> re-create upon stop and start Derby.
> Furthermore, once the application is stable, most likely derby would not be
> reset for a very long time.
>
> Question: Does Derby provides some kind of
cdarling writes:
> Hi,
> I'm new to derby and I'm tring out its amazing features (under the
> guidance of
> "http://docs.oracle.com/javadb/10.8.2.2/getstart/getstartderby.pdf";).
> I've encountered a problem and I‘ve (fortunately) get over it. I'm
> writing to share my experience and hoping (poss
Amit writes:
> Also, I did jstack on derby process and got a thread in BLOCKED state,
> what is the reason for this?
>
> "DRDAConnThread_5" prio=6 tid=0x27500c00 nid=0x178c in Object.wait()
> [0x2801f000]
> java.lang.Thread.State: BLOCKED (on object monitor)
> at java.lang.Object.wait(Native Me
Trejkaz writes:
> On Tue, Jul 2, 2013 at 10:18 PM, Rick Hillegas
> wrote:
>> If you simply exit the VM without requesting an orderly shutdown, then the
>> checkpoint won't be performed. However, the cleanup performed by that
>> checkpoint still has to be performed. It will be performed the next
Hi all,
Some of you may already have noticed that Oracle's latest security
update release of Java SE included a fix for a vulnerability in the
javadoc tool (CVE-2013-1571). The javadocs included in all versions of
Derby from 10.2.1.6 up to 10.10.1.1 were built with versions of the
javadoc tool tha
Dag Wanvik writes:
> On 11.06.2013 18:50, benrahman wrote:
>
> /Master derby.log/
>
> BEGIN REPLICATION ERROR MESSAGE (6/5/13 3:35 PM)
> Exception occurred during log shipping.
> java.net.SocketException: Connection reset by peer: socket write error
> a
Martin writes:
> It looks like hints are not allowed for deletes. :(
That's correct. There is a request for enabling it in JIRA:
https://issues.apache.org/jira/browse/DERBY-4136
Please feel free to give the JIRA issue a vote to make it more visible.
Thanks,
--
Knut Anders
smadin writes:
> I use UNION ALL to join these statements. But my problem is, sql exception
> is thrown saying that there is a problem in ORDER clause when statements are
> separated using parentheses.
> " java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at
> line 1, column xxx
Guillaume CHAUVET writes:
> Hi Rick,
>
> Thank you very much, I understand my mistake now : I wanted to make a single
> SQL request instead of two requests.
> By cons I have to write a Java program to do that, but this is not a problem
> in my case.
Hi Guillaume,
Even though Derby doesn't al
manojkumar16 writes:
> I am writing a default scheduler for my project and it needs to be triggered
> 7 days later the deployment of project.
> Can somebody help me writing an INSERT statement which takes (CURRENT_DATE +
> 7 days) as a value for DATE field.
>
> INSERT INTO PURGE_ACC (START_DATE,
Guillaume CHAUVET writes:
> Hello Derby users !
>
> I encountered some difficulties with Derby and CallableStatement. In my case,
> I try to save a custom property into DB Derby properties (A database internal
> version number).
>
> To do that, I use SYSCS_SET_DATABASE_PROPERTY and SYSCS_GET_DA
Oleksii Puzyr writes:
> Hi Knut, thank you for response.
>
> bash-3.2$ java -version
> java version "1.6.0_43"
> Java(TM) SE Runtime Environment (build 1.6.0_43-b01-447-11M4203)
> Java HotSpot(TM) 64-Bit Server VM (build 20.14-b01-447, mixed mode)
>
> bash-3.2$ sudo systemsetup -gettimezone
> Tim
ping wei writes:
> Replication confirm is functioning as after failover replication ( properly
> shutdown ), able to see table updated.
>
> However, if i waited a minute up to 10 minute, cut off the connection (
> shutdown slave derby service ) then connect again ( turn on slave derby
> service
Oleksii Puzyr writes:
> Hi all,
>
> Using embedded 10.10.1.1:
>
> CREATE TABLE TEST
> (
> ID INT NOT NULL,
> DATE TIMESTAMP NOT NULL
> );
>
> insert into test(id, date) values (1,'1988-12-25 18:00:34');
> select date(date),date from test;
>
> Result:
> '1988-12-24', '1988-12-25 17:00:34'
John English writes:
> I have a query that looks like this:
>
> SELECT tests.id,tests.item,title FROM tests,item_usage
> WHERE username='X' AND item_usage.item=tests.item
> ORDER BY tests.item,title
>
> The item_usage table is defined like this:
>
> CREATE TABLE item_usage (
> usernam
Isabelle DASTUGUE writes:
> Hello,
> I have a database which is currently 272 MB If I created a second with
> the same structure and the same data is important, it does more than
> 2MB
> I attempted to reduce the first with:
> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE (),
> CALL SYSCS_UTIL.SYSCS_
John English writes:
> I want to select all rows from a table where a varchar column is a
> zero-length string. Of course this works:
> SELECT * FROM my_table WHERE my_col='';
> but I would have expected this to work too:
> SELECT * FROM my_table WHERE my_col NOT LIKE '%_%';
> The first quer
Oskar Zinger writes:
> I'm using Derby Replication in my product and trying to figure out
> what is the best approach for "stopping" the database before starting
> replication (before copying the database from Master to Slave).
>
> I'm currently using "shutdown" approach... as described in the
>
Al Eridani writes:
> We have an application that has started to use Derby and we are
> running into some lock timeouts.
>
> When several threads are trying to acquire the same lock, how does
> Derby decide which thread to service the next time the lock becomes
> available?
>
> Is it using Java lo
Pavel Bortnovskiy writes:
> we have a need to create a java-mapped function which will take 92
> parameters, but we are running into Derby’s limitation:
>
> Caused by: java.sql.SQLException: The limit for the number of
> parameters for a procedure has been exceeded. Limit is 90 and number
> of pa
Mo Maison writes:
> Hello Derby users,
>
> I detected a strange behaviour, where indices created by uniques
> constraints are not reported in DatabaseMedata.getIndexInfo() :
>
> getIndexInfo(String catalog,
> String schema,
> String table,
> boolean uniq
Pavel Bortnovskiy writes:
> Thank you, Knut, for your prompt response.
>
> It seems that my caching of Prepared Statements is causing some problems.
> In some previous responses, it was indicated that Derby is caching
> them internally anyway, so maybe a better approach for me is not to
> cache t
John English writes:
> On 20/12/2012 14:12, Jean-Yves Linet wrote:
>> Hi,
>> May you could give more details about the structure of your table.
>
> The table looks like this:
>
> CREATE TABLE system_log (
> id INTEGER GENERATED ALWAYS AS IDENTITY,
> timeTIMESTAMP DE
Pavel Bortnovskiy writes:
> Once in a while, I see the following errors. What may cause them?
>
> java.sql.SQLException: Container 1,329 not found.
The error means that one of the database files (table or index) cannot
be found. It typically happens because some DDL operation (for example
DROP I
Bryan Pendleton writes:
> Forwarding to the list.
> On 12/19/2012 04:10 AM, 王旭 wrote:
>> *Question one**:***
>>
>> Firstly, I created a table.
>>
>> CREATE TABLE CV
>>
>> (
>>
>> AGE INTEGER NOT NULL,
>>
>> RT DECIMAL(20,10),
>>
>> PRIMARY KEY (AGE)
>>
>>
Pavel Bortnovskiy writes:
> Hello:
>
> Is it safe to call .addBatch() and .executeBatch() methods from
> multiple threads on the same PreparedStatement?
>
> Simple example: batching and executing a large number of the same
> statements (with the same PreparedStatement) by using ExecutorService.
Steve Nobles writes:
> My company is evaluating whether to use Derby for a
> desktop/client-server application where security and 21-CFR 11
> compliance is important. I’m looking for technical documents attesting
> to the robustness of Derby’s security features. Something like unit
> test coverag
Kim Haase writes:
> Should I file a doc JIRA to clarify that ALTER TABLE adds the new
> column at the end?
That would be great.
> It seems obvious, but perhaps we should clarify
> that a programmatic attempt to change the data type of a column will
> still result in the changed column being app
david myers writes:
> On 03/12/12 14:12, Knut Anders Hatlen wrote:
>
> Zorro writes:
>
>
> Dear All,
>
> When doing in ij a bulk Insert into a table of my Derby database I do
> get a NullPointerException.
>
>
> Hi Harm-Jan,
>
>
Zorro writes:
> Dear All,
>
> When doing in ij a bulk Insert into a table of my Derby database I do
> get a NullPointerException.
Hi Harm-Jan,
It looks like you've come across a bug. I managed to reproduce the
NullPointerException in my environment, so I filed a bug report and
posted the steps
John English writes:
> Can anyone tell me what the correct syntax is to make this join work?
>
> SELECT * from a,b LEFT JOIN c ON a.foo=c.foo AND b.bar=c.bar;
>
> That is, I want the crossproduct of a and b, with columns from c when
> they correspond to rows in BOTH a and b, and nulls if not.
Bhavesh Thanki writes:
> Hi
>
> I have a question to ask i want to configure Derby db with my Squirrel
> sql client. I have added the driver jar but it is asking me for a
> password in the sql connection window.#
> what do i enter as i cannot leave it blank.
Hi Bhavesh,
If you haven't set up D
Thomas Hill writes:
>> Hi Thomas,
>>
>> I think you'd need to add a REFERENCING clause to the trigger definition
>> and pass in the new value as an argument to the procedure. Something
>> like:
>>
>> CREATE TRIGGER "TR_XY"
>> AFTER INSERT
>> ON "TBL_XY"
>> REFERENCING NEW AS NE
Thomas Hill writes:
> Rick Hillegas writes:
>
>>
>> On 10/21/12 11:45 PM, Thomas Hill wrote:
>> > CREATE TRIGGER "TR_XY"
>> >AFTER INSERT
>> >ON "TBL_XY"
>> >FOR EACH ROW
>> >CALL PROCEDURE "SP_xy"('xyz', 0);
>> Hi Thomas,
>>
>> That's almost correct. If you remove the keyword
JHead writes:
> Hi there.
>
> Is there any way to grant schema privileges to users like create / alter /
> drop table? I did a lot of search without any result.
>
> It works in DB2 with the following syntax:
>
> GRANT CREATEIN, DROPIN ON SCHEMA S1 TO FRANK
>
> I want to allow to create and a
Al Eridani writes:
> Hello, I'm trying to insert rows in a table where one of the columns
> 'ver' is a smallint and I want it populated with the next higher value
> of those meeting a condition.
>
> If I try
>
> insert into abc (abc_id, xyz_id, ver)
> values (default,1,(SELECT coalesce((SELECT 1+
Maison Mo writes:
> Hello,
>
> As I encountered some problems with Derby connections after deadlocks,
> I searched into bug database and found a very similar bug :
> https://issues.apache.org/jira/browse/DERBY-5552
>
> I use 10.6.2.1. According to jira, this bug is solved in 10.6.2.2.
> Unfortuna
Suat Gonul writes:
> Hi Knut,
>
> It seems that is the problem, thanks. But, then I think I should escape
> special characters contained the values. Is there standard procedure for
> this? Is there a list of of special characters? What do you suggest?
I'd suggest that you use prepared statements
Suat Gonul writes:
> Hi everyone,
>
> I have a table having two columns: id (Primary key, varchar 1024),
> revision(long). There is also an index on the revision field.
>
> I can insert records in which the id has more than 128 characters into
> this table using PreparedStatement when the query i
Matthew Hauck writes:
> I am writing about the well known error: "Failed to start database
> '...' with class loader ..." I realize that you cannot have two
> simultaneous connections from two different JVMs to a derby embedded
> database. My question is whether or not it is possible to disconne
TXVanguard writes:
> (Note: I have another post that uses the INSERT statement below as an
> example, but this post concerns a different problem.)
>
> When I run the query below, I get a java.lang.NullPointerException. The
> exception goes away if I change the "EMN.ASM IS NULL" to "EMN.ASM = 0"
John English writes:
> I'm having trouble with the following error: "Conglomerate could not be
> created". It happens when I do this:
>
> INSERT INTO resource_usage (resid,itemid,itemtype)
> (SELECT resid,?,? FROM resource_usage
> WHERE itemid=?
> AND itemtype=?
> AND NOT
Mike Matrigali writes:
> On 5/17/2012 10:07 AM, David Zanter wrote:
>> Does anyone know, is there a way to get derby statistics from a
>> running system regarding the hit/miss rates for the Derby Page Cache.
>>
>> i.e. Statistics that would help determine if the:
>> derby.storage.pageCacheSize
Martin Lichtin writes:
> Hi
> Implementations of connection pooling typically use a "test query" to first
> check
> whether a connection is still valid before sending the actual query across.
> A test query looks like
> SELECT SYSDATE FROM DUAL (eg. PostgreSQL or Oracle)
> or
> SELECT 1 (eg.
"Brett Mason" writes:
> Hi there,
>
> I think I have encountered a bug where rolling back a transaction can leave
> a table in an inconsistent state if the table has been previously altered
> through the addition of new columns. It appears that if newly added columns
> have not been changed from
John English writes:
>> Derby also has unique indexes that, in contrast to unique constraints,
>> consider two null values duplicates:
>>
>>CREATE UNIQUE INDEX FOO_3 ON foo(section,title)
>
> But that won't actually prevent me entering duplicate values with a null
> section value, will it?
I
John English writes:
> I have a table with a (possibly null) foreign key, and a non-null value:
>
> CREATE TABLE foo (
> section INTEGER DEFAULT NULL,
> title VARCHAR(100) NOT NULL,
> ...
> CONSTRAINT foo_1 FOREIGN KEY(section) REFERENCES bar(section)
> ON
John English writes:
> I have a webapp running under Jetty 8 using Derby 10.8.1.2. It runs fine
> for a few weeks and then grinds to a halt (which on a Windows box also
> grinds Windows to a halt). It sometimes crashes with an OutOfMemoryError
> with a message that it can't create any more native
Thomas Hill writes:
> Hi,
> can someone please share an example how the Client side application code to
> call
> procedure looks like when I want my stored procedure to return TWO resultsets?
> The derby Wiki (extract see below) says 'WORK IN PROGRESS' in the section
> where
> documentation on
David Sitsky writes:
> Hi,
>
> I have an application on very beefy hardware, which for better or
> worse, has a gigantic number of derby databases it has to open on
> startup. I have some multi-threaded code which opens the databases in
> parallel, but I have found many of the threads are stuck
jesusaplsoft writes:
> Is there any way to unencrypt a working encrypted db?
As far as I know, the only way to do this currently is to create a new,
unencrypted database and manually migrate the data from the encrypted
database.
Maybe you can use DdlUtils (http://db.apache.org/ddlutils/) to do
Bryan Pendleton writes:
>> 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
Alternatively, from a Java application, this information can be
retrieved by a calling
Robert DiPietro writes:
> Hello!
>
> I have been deving against a Derby DB on which requireAuthentication
> is true, the provider is built-in, and all users have been defined in
> the derby.properties file (so they are all system level users). This
> has been extremely convenient in development,
Rick Hillegas writes:
> On 12/21/11 3:59 AM, JulioSerje wrote:
>> Hi Rick,
>>
>> Unfortunately our expressions would require a high number of subqueries;
>> ours is an engineering application that require many values from several
>> tables in order to compute multiple complex formulae.
>>
>> In o
Bryan Pendleton writes:
>> 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 *cha
Myrna van Lunteren writes:
> On Thu, Dec 8, 2011 at 4:21 AM, wrote:
>> Hello,
>>
>> I'm trying to use UCASE to "normalize" different case variants of
>> text field values. There's just a little problem. It works fine for
>> all normal characters including German umlauts (Ä, Ö, Ü, ä, ö, ü)
>> ..
mane_uk writes:
> Hi All,
>
>I am trying to run the command CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE but I
> am having the following error message:
>
> Exception in thread "main" java.sql.SQLException: The exception
> 'java.sql.SQLException: Column 'COLUMN21' is either not in any table in the
> FRO
Karl Weber writes:
> Hi,
>
> Derby does support UDTs. One can use any java.io.Serializable java class as a
> UDT.
>
> On the other hand, derby does not support SQL ARRAY types.
>
> However, every java array is an object that implements java.io.Serializable,
> so can one define a UTD of the form
Spezifikum writes:
> Hi,
> i get the error message
> "SQLIntegrityConstraintViolationException: UPDATE on table 'CDENTRY'
> caused a violation of foreign key constraint 'LINKEDTO_FK' for key
> (0). The statement has been rolled back."
> I see, why Derby refuses to do so and i am indeed thankfull
"Phil Bradley" writes:
>>
>> Please bear with me, I do not understand the following paragraph:
>> > At the moment, this doesn't address the problem. Specifically, even
>> > after taking these steps, the exception gets thrown after every database
>> > operation.
>> When I read that sentence, I ge
Ross Harman writes:
> Does Derby support the Oracle (+) notation for outer joins?
No, Derby only supports the LEFT OUTER JOIN and RIGHT OUTER JOIN syntax
for outer joins.
http://db.apache.org/derby/docs/10.8/ref/rrefsqlj29840.html
--
Knut Anders
amfr...@web.de writes:
> Hi,
>
> i need a table with 1 or 0 rows in it. So that after 1 row is inserted
> the table can only be updated or the row deleted, but there can never
> be a row inserted.
> I came as far as this:
>
> CREATE TABLE test
> (field1 INTEGER NOT NULL
> CHECK (field1 = 1) UNIQ
maxf11 writes:
> I've tried this way but...it doesn't work.
> I've modified source code of SimpleApp :
>
> EmbeddedSimpleDataSource ds = new EmbeddedSimpleDataSource();
> System.out.println("Loaded the appropriate driver.");
>
> Connection conn = null;
> /*
>
Paul French writes:
> Hello All,
>
> we have an issue where derby takes a long time to startup. Anything
> from minutes to hours.
>
> We are running derby on J9 on a windows mobile 6.5
>
> It seems to be due to the fact that devices are being powered off and
> so derby is not shutdown cleanly.
>
john netzel writes:
> From what I see, the sequence statements count every time
> a prepared statement that has squence impeded in it, is built. It
> would be nice if this was in the Derby Reference Manual.
Hi John,
I don't think the sequences are intended to be incremented each time a
statem
maxf11 writes:
> Hi all!
>
> I'm developing a Java application for a PDA WM 6.5.
> I'm trying to use Derby DB with JVM CreMe 4.12 (JDK 1.3.1).
> I've downloaded Derby 10.2.2 version, and I've tried to run the simpleApp
> application.
> I've created a directory \derby on the filesystem, with 3 fil
Spezifikum writes:
> Hi
> i have to read the structure of some tables i created and display that
> in my HTML pages. So i tried to do something like
> execute( "describe myTable" ) and get an SQL exception (invalid syntax).
> Should i instead query some system tables?
Hi Malte,
The DESCRIBE syn
Pavel Bortnovskiy writes:
> Hello:
>
> Can you please tell me whether this behavior expected or is it a bug?
>
> 1. a table with SMALLINT is created:
>
> CREATE TABLE Test_Table (pk_VARCHAR_5FDG6 VARCHAR(256) NOT NULL,
> SMALLINT_Q6Y06 SMALLINT, PRIMARY KEY(pk_VARCHAR_5FDG6))
>
> 2. values ar
Thomas Hill 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'
> by an assumed less costly request o
1 - 100 of 536 matches
Mail list logo