!
-
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
Dept. of Computing| ** NON-PROFIT CD FOR CS STUDENTS **
University of Brighton|-- see http://burks.bton.ac.uk
-
.
-
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
Dept. of Computing| ** NON-PROFIT CD FOR CS STUDENTS **
University of Brighton|-- see http://burks.bton.ac.uk
-
. Thanks again for pointing this out.
-
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
Dept. of Computing| ** NON-PROFIT CD FOR CS STUDENTS **
University
.
-
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
Dept. of Computing| ** NON-PROFIT CD FOR CS STUDENTS **
University of Brighton|-- see http://burks.bton.ac.uk
-
,
--
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
School of Computing MIS | Those who don't know their history
University of Brighton| are condemned to relive it (Santayana)
--
tried Float, which
is no better.
The big difference is that, using primitive types, I can't handle nulls...
Anyone got any ideas whhat I'm doing wrong?
--
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer
.
http://issues.apache.org/jira/browse/DERBY-479
http://issues.apache.org/jira/browse/DERBY-1030
This works fine for me. Thanks!
--
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http
answer is to say SELECT * FROM user_list WHERE link'', which seems a bit
perverse to me...
--
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
School of Computing
what's going on here, though...
--
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
School of Computing MIS | Those who don't know their history
University
other ideas that I could try?
--
John English | mailto:[EMAIL PROTECTED]
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
School of Computing MIS | Those who don't know their history
University
what I can do to prevent this, or at least to narrow down
the reasons for the error? My last-ditch catch Throwable handler doesn't
give me a stack frame dump so it's hard to tell what's really going on.
TIA,
--
John English
download that supports
column renaming but doesn't have XML as a reserved word? Or is there
another solution that I've missed?
TIA,
--
John English | mailto:j...@brighton.ac.uk
Senior Lecturer | http
download that supports
column renaming but doesn't have XML as a reserved word? Or is there
another solution that I've missed?
TIA,
--
John English | mailto:j...@brighton.ac.uk
Senior Lecturer | http
On 29/01/2010 18:11, Rick Hillegas wrote:
John English wrote:
I've tried surrounding the name XML in double quotes (xml) but that
doesn't work.
Hi John,
Have you tried uppercasing as well as doublequoting the column name.
E.g., XML rather than xml?
That is *exactly* the solution. I always
to be
caused by a multi-query transaction of this sort (since the locks all
have the same XID)? If so, it would narrow down the things I need to
look at...
Many thanks for your advice!
--
John English | mailto:j
) result set to
commit the transaction?
--
John English | mailto:j...@brighton.ac.uk
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
School of Computing MIS | Those who don't know their history
University
!
--
John English | mailto:j...@brighton.ac.uk
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
School of Computing MIS | Those who don't know their history
University of Brighton| are condemned to relive it (Santayana)
--
.
Can anyone:
(a) confirm my reasoning?
(b) suggest a workaround?
Many thanks,
--
John English | mailto:j...@brighton.ac.uk
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
School of Computing MIS
the tests for an assembly before deleting the assembly itself,
which works fine (but makes my code look untidy!).
Regards,
--
John English | mailto:j...@brighton.ac.uk
Senior Lecturer | http
.
--
John English | mailto:j...@brighton.ac.uk
Senior Lecturer | http://www.it.bton.ac.uk/staff/je
School of Computing MIS | Those who don't know their history
University of Brighton| are condemned to relive
)
but of course this doesn't do it. Obviously I could write a Java program
that does this, but this means reinventing the IJ wheel. Is there any
existing way to do this?
TIA,
John English | My old University of Brighton home page
On 11/03/2011 17:42, Peter Ondruška wrote:
Have you tried \b ?
Hmm, silly me. I tried RTFMing -- stupid thing to do!
John English | My old University of Brighton home page is still here:
| http
On 11/03/2011 17:46, John English wrote:
On 11/03/2011 17:42, Peter Ondruška wrote:
Have you tried \b ?
Hmm, silly me. I tried RTFMing -- stupid thing to do!
OK, now I've tried it. It doesn't work. LENGTH('\b') == 2, not 1.
Any other suggestions
having
to define a function in Java to convert an int to a char for lack of a
better idea, but I'm amazed that there isn't a built-in function for
this.
John English | My old University of Brighton home page is still here
C:foo\db.
ij
Is there something I'm missing here?
TIA,
John English | My old University of Brighton home page is still here:
| http://www.it.brighton.ac.uk/staff/je
,
John English | My old University of Brighton home page is still here:
| http://www.it.brighton.ac.uk/staff/je
,
John English | My old University of Brighton home page is still here:
| http://www.it.brighton.ac.uk/staff/je
open?
I'm starting it once from the webapp, then trying to connect
externally with IJ before I go any further.
John English | My old University of Brighton home page is still here:
| http
,
John English | My old University of Brighton home page is still here:
| http://www.it.brighton.ac.uk/staff/je
.
Cheers,
John English | My old University of Brighton home page is still here:
| http://www.it.brighton.ac.uk/staff/je
replace * with a CASE to turn the right-hand
nulls into zeroes?
John English | My old University of Brighton home page is still here:
| http://www.it.brighton.ac.uk/staff/je
WeekNumber(aDate) in the SELECT statement.
A bit simpler than the ugly CASE!
Cheers,
John English | My old University of Brighton home page is still here:
| http://www.it.brighton.ac.uk/staff/je
java-code to derby?
No, you have to compile it and have it on the classpath.
John English | My old University of Brighton home page is still here:
| http://www.it.brighton.ac.uk/staff/je
inefficient (particularly for big tables), what with
selecting stuff from the same table four times and then throwing most of
it away.
Can anyone suggest a more elegant solution?
TIA,
John English | My old University
this helps,
Yes, many thanks for the advice!
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff/je/
any informed opinions on this...
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff/je/
... :-)
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff/je/
!
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff/je/
. Or am I missing something?
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff/je/
having columns
A, B, C where A is the PK and B is FK to T2, and T2 has B, A, D, have
T with A,B,C,D)? Or again, am I missing something?
John English | My old University of Brighton home page is still here:
| http
56
Total: 7 entries2,285
60,600 7,436,208
TIA,
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff
dumps!
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff/je/
really doesn't appeal to me).
Can anyone think of another way to do this?
TIA,
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff/je/
it
will work before and after the changeover.
Oh well. Maintenance is always such fun.
Thanks,
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff/je/
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?
John English | My old University
for!
John English | My old University of Brighton home page is still here:
| http://www.cem.brighton.ac.uk/staff/je/
,'final'),(32,55,'final');
-- 4 rows inserted
Can anybody throw any light on what's going on here please?
--
John English
will look into this further!
--
John English If we were to define a religion to be a system of thought
which contains unprovable statements, so it contains an element of
faith, then Gödel has taught us that not only is mathematics a religion
but it is the only religion able to prove itself
parameters, and again got the same thing.
So I'm still thrashing around in search of a solution...
--
John English If we were to define a religion to be a system of thought
which contains unprovable statements, so it contains an element of
faith, then Gödel has taught us that not only is mathematics
On 01/06/2012 15:19, John English wrote:
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
On 04/06/2012 16:35, Kristian Waagan wrote:
On 04.06.12 14:52, Rick Hillegas wrote:
On 6/2/12 3:18 AM, John English wrote:
On 01/06/2012 15:19, John English wrote:
I'm having trouble with the following error: Conglomerate could
not be
created. It happens when I do this:
INSERT
On 04/06/2012 19:57, Katherine Marsden wrote:
On 6/4/2012 9:29 AM, John English wrote:
I'm on 10.8, and I only have about a dozen matching rows at the
moment. No stack trace that goes further than my own code; all I have
is stuff like this:
Check the derby.log for the error and full stack
.
Looking in the code where the error is reported in the source code, it
looks like it shouldn't happen. Could you post a JIRA bug report for
this error, please? It you are able to make a stand-alone repro that
will increase your chances of having it fixed.
OK, many thanks, will do.
--
John English
for the Conglomerate could not be created
error to anyone?
TIA,
--
John English
On 20/06/2012 15:25, Kristian Waagan wrote:
Logged as DERBY-5823 [1].
The bug is data dependent in that it requires a certain number of rows
to be inserted, so that may be what's causing your repro to fail
triggering the bug.
OK, many thanks.
--
John English
this exception (probably caused by nested select statements):
Hi Pavel,
What transaction isolation level are you using for the connections
involved?
--
John English
, all items with parent=2, and so on down the chain
of descendants? Or in other words, the transitive closure of the set?
TIA,
--
John English
haven't been able to think of.
--
John English
in the process or recursively trying to construct the
transitive closure of all the possible approaches that this page links
to... :-)
--
John English
);
}
while (res.next());
}
else {
//
// No unprocessed rows found, so return
//
return;
}
}
}
}
}
--
John English
acceptable, but I haven't been able
to come up with the devious trick I need. Can anyone help?
TIA,
--
John English
hundred.
What I really need is a create temporary view, or better still a way
to smuggle a value inside the Connection that I use for the query that
could be picked up inside TimeFormat. Sigh.
Thanks for trying anyway!
--
John English
is based on the formatted
text (which is now correctly localised) and the sorting is still based
on the underlying timestamp.
I can't say I'm impressed with the elegance of my code, but what the
hell, it works!
--
John English
.
Thanks for your input,
--
John English
)
at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown
Source)
... 10 more
--
John English
On 03/11/2012 13:15, John English wrote:
Suddenly for no discernable reason I'm getting this error (stacktrace
below) while using getString() to read from a clob, the contents of
which is only about 60K in length.
Something interesting: I've fixed the problem (i.e. made it go away).
I'm
connection for both queries.
So I'm totally baffled. Happy to have found a workaround but very
annoyed that I don't understand why it works.
Thanks for your help,
--
John English
something like
Column 'A.FOO' is not in any table in the FROM list
I know I'm probably being stupid, but please help anyway!
TIA,
--
John English
=c.bar
but I knew there must be a better way!
--
John English
is
fixed when the function is defined.
Does anyone have any ideas what else I could try? Or is there anything
in the pipeline for a future version that might be relevant?
TIA,
--
John English
case expression it could work.
Here an example function.
[...snip...]
Found in
http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/
Thanks, it looks promising; I'll have a long think about this!
--
John English
and ORDER BY clauses.
So for now, I'm still stuck.
Your suggestions and advice gratefully appreciated!
--
John English
classes which support the script.
Hmm, looks interesting!
Hope this helps,
Me too, but I need to spend some time digesting your example...
Many thanks for this,
--
John English
!
--
John English
On 04/12/2012 20:46, John English wrote:
I'm going to try using a user-defined function to format the name and thus avoid
the extra GROUP BY elements (which are my immediate suspect for the performance
hit), but does anyone have any other suggestions for improving on this solution?
Just
for upwards of 30 seconds at a time?
TIA,
--
John English
applications I have
open at the time, which suggests to me that there's a lot of swapping going on...
--
John English
with different variations of formatting and views and see what I can find out.
Thanks,
--
John English
On 23/01/2013 14:02, John English wrote:
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 exception is presumably reporting a syntax error, but since you didn't give
details of the exception I can't be sure.
--
John English
you try and connect?
HTH,
--
John English
On 23/02/2013 17:47, john miltone wrote:
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?
--
John
to access the database
directly rather than going through your app?
--
John English
be going on here?
TIA,
--
John English
the behaviour.
John English
database? (I am a bear
of very little brain when it gets to understanding execution plans!)
Many thanks,
--
John English
thanks!
--
John English
0 AND 100)
);
--
John English
it to the bug
report if I succeed.
--
John English
table has a composite primary key. I've now found two queries where this
particular table sorts wrongly, but no other cases.
Anybody got any thoughts whether this might be a factor?
--
John English
, then you'll need
to post the less interesting parts of your code.
HTH,
--
John English
ON waste_container
CALL go_bang();
--
John English
current_location, which current_location
does the RHS of the condition refer to?
--
John English
a procedure to insert or not seems to be the only way to do what you want.
HTH,
--
John English
and also a tutorial on JDBC.
--
John English
= conn.prepareStatement(DELETE FROM tablename WHERE CURRENT OF
MYCURSOR);
statements.add(psDelete);
Why not just use rs.deleteRow() instead of using a cursor?
--
John English
didn't notice?
--
John English
has up to about 100 concurrent clients, and
I stop it for about half an hour every 3-4 months to install fixes and updates.
I've been running it like this for about 3 years now.
--
John English
column
is null in the records not being returned.*
*CAST(AGE AS varchar(3)) ||'|'||*
Perhaps use something like this:
CASE WHEN Age IS NULL THEN '' ELSE Age END || '|'
--
John English
in derby.properties for
even more information.
HTH,
--
John English
1 - 100 of 194 matches
Mail list logo