Re: Hanging around derby.log, how to center it?

Hi, Check out the following properties: derby.system.home (http://db.apache.org/derby/docs/10.5/ref/rrefproper32066.html) and derby.stream.error.file (http://db.apache.org/derby/docs/10.5/ref/rrefproper18151.html) Gabriele Kahlout wrote (2010-03-13 12:23:37): Hello, I've developed an

Re: how to set the timezone of CURRENT_TIMESTAMP to GMT?

Den 02/08/2010 10:40 AM, skrev Erin Drummond: Hi, I have a table in a database that looks like this: CREATE TABLE Data(RowID CHAR(16) FOR BIT DATA PRIMARY KEY,Value LONG VARCHAR NOT NULL,LastUpdated TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP) The proper solution would be to use the

Re: Streaming Results

Hi, Some general remarks (don't remember the exact details of what Derby actually does with setFetchSize). Stian Brattland wrote (2010-01-14 08:43:32): Hi, I've got a question regarding results streaming. The J/Connector for MySQL supports results streaming, which means that you can

Re: Streaming Results

will attempt to fill up the communication buffer (32K) as long as at least one row fits into it. Kind regards, Stian Brattland My intention with the question was not really to point out that a the driver needs to retrive results in the most ineffective manner as possible. Bernt M. Johnsen

Re: Streaming Results

is as far is I know the normal behaviour of most JDBC drivers. Brett On Thu, Jan 14, 2010 at 7:33 PM, Bernt M. Johnsen bernt.john...@sun.comwrote: Stian Brattland wrote (2010-01-14 11:01:43): Hi, Thank you for your quick reply. I will elaborate a little on my question

Re: Streaming Results

Hi again, Stian Brattland wrote (2010-01-14 14:42:47): Hi, Thank you for your answer Knut Anders. I do understand from what you are saying that the Derby Driver never will (to user the words of Brett) materialize the entire ResultSet on the client-side before returning it to the user,

Re: time format (or: the curse of dst)

Fabio wrote (2009-10-24 11:12:48): Hello, I'm using Apache Derby to store hourly values of electricity consumption. The values are used in an electricity market simulation implemented in Java. Now because of DST, hourly values mean that (for central Europe): - one day in March has 23

Re: Derby in-memory back end - where to go next?

Kristian Waagan wrote (2009-09-07 11:26:13): Hello, In Derby 10.5 an in-memory back end, or storage engine, was included. It stores all the data in main memory, with the exception of derby.log. If this is news to you, and you want a quick intro to it, see [1] and [2]. I'm trying to

DERBY-PROPERTIES in /*..*/?

Since Derby has implemented /*...*/ comments (at last), is it possible to write /*DERBY-PROPERTIES..*/ instead of --DERBY-PROPERTIES... ? -- Bernt Marius Johnsen, Staff Engineer Database Technology Group, Sun Microsystems, Trondheim, Norway signature.asc Description: Digital signature

Re: create table if not exists ?

E.g. like this (I hope the SQLState is correct): try { stmt.executeUpdate(create table t (i integer)); } catch (SQLException e) { if (!e.getSQLState().equals(X0Y32) { throw e; } } Alternatively, use the JDBC MetaData interface to check if the table is there. Note that the

Re: Need Urgent Help: Timestamp

Hi, Sorry, but I have no experience with SQLTimestampConverter. Gerald Wheeler wrote (2009-02-11 06:51:34): Brent, Thanks very much for you response.. Do you know which pattern I can use with a timestamp textfield in the app and using SQLTimestampConverter the would return (display) Feb

Re: Need Urgent Help: Timestamp

Gerald Wheeler wrote (2009-02-09 10:35:09): All, I have a java application created w/netbeans 6.5 I am trying to input a date time into a Derby timestamp field using default pattern the insert statements work correctly and display Jan 2, 1991 12:00:00 How does one enter data into

Re: Derby/Oracle - single SQL query?

Kent Spaulding wrote (2009-02-04 12:47:15): Thanks Bernt. That works in both DBs. For the rest of what I've discovered: Creating a to_date function also works. Thanks for that too, as it looks like I'll need one for decode() as well.[1] Why would you need such a function? A date

Re: Derby/Oracle - single SQL query?

Kent Spaulding wrote (2009-02-04 10:05:30): Hi again, Thanks to the list, I'm able to use the same code for inserts for both Oracle and Derby drivers. Now I have a SQL question, one of my queries has where clauses (actually, all of them).. This works in Derby, not Oracle: and

Re: timestamp and Derby/Oracle?

Kent Spaulding wrote (2009-02-02 15:45:37): Thanks, I've headed down that path and it looks much more promising, if not painful. Oracle has been a bit odd wrt time and date vaules, but if you really need a literal in the statement, you should try teh JDBC escape syntax which should be

Re: JDK 1.4 support?

[EMAIL PROTECTED] wrote (2008-11-26 13:30:52): So, that means that either I should install an unsupported JDK 1.4 from SUN or a JDK 1.4 from IBM that I can not install because of IBM JDK licensing issues. Yes, and the Sun JDK 1.4 is still downloadable. As far as I understand, the IBM JDK is

Re: varchar length

Kristian Waagan wrote (2008-11-25 13:36:54): tom_ wrote: Hello Kristian, this is a good idea, truncating by java before writing by SQL. Yes, varchar removes trailing blanks, though it would help if it would cut larger values instead of not writing them. If you have a look at the error

Re: JDK 1.4 support?

One word of caution. While Sun's JDK 1.4 had it's end of service life 2008-10-08, IBM's JDK 1.4 has End of Service 2011-09-30 Which means that there is a supported 1.4 JDK out there. If we stop requiring 1.4 for building Derby, we can't guarantee that future versions of Derby will work for IBM's

Re: ibatis derby problem

Zsolt Koppany wrote (2008-11-21 09:42:51): Kathey, How can you always know the type of an Object? Ibatis supports also jdbc--java.util.Map mapping. How do you want to know for example if a value is not available in the Map which java type to use to set NULL?

Re: Embedded and Network Simultaneous Connections

It is no problem having an application with an embedded Derby and starting the Derby network server so that network clients may connect to the same database: You may e.g start your embedded app like this: java -Dderby.drda.startNetworkServer=true -Dderby.drda.host=ahost

Re: Date 2042-10-12 problem using Brasilia time zone

Bernt M. Johnsen wrote (2008-11-04 16:55:47): Played around with java.util.Date and found that it is done correctly up to and including 2037 and errouneously from 2038. That is, given that the change to DST for Brazil is the second Sunday in October, which is also wrong. It's now (from 2008

Re: Date 2042-10-12 problem using Brasilia time zone

I have found that this is not related to Brazil tz at all, but to transtions to DST after 2038-01-19. When time changes to DST, one hour is skipped. If a Date object is created within this non-existent hour, java.util.Date adds 1 hour to the given time to create a legal point in time. After

Re: Date 2042-10-12 problem using Brasilia time zone

Hav you tried the tzupdater to see if the lates version of tzdata fixes the problem? tzdata2008g/TZupdater 1.3.9 is newer than JRE 6u10 and contains changes for Brazil. Thomas Mueller wrote (2008-11-03 18:41:03): Hi, I submitted a bug in JSE. Regards, Thomas On Sat, Nov 1, 2008 at

Re: Date 2042-10-12 problem using Brasilia time zone

Played around with java.util.Date and found that it is done correctly up to and including 2037 and errouneously from 2038. I don't think it's a coincidence that the 32-bit number of seconds since 1970-01-01 expires (or wraps around) on 2038-01-19... -- Bernt Marius Johnsen, Staff Engineer

Re: Date 2042-10-12 problem using Brasilia time zone

Although I can't shed any light on the Java/JavaDB problem, I can clarify a bit on DST and Brazil. Brazil decided by law 2008-09-08 that at 00:00 the third Sunday in October (which is 2008-10-18) is the change from DST to normal time and at 00:00 the third Sunday of February they will change back

Re: Date 2042-10-12 problem using Brasilia time zone

Bernt M. Johnsen wrote (2008-10-31 15:45:18): Although I can't shed any light on the Java/JavaDB problem, I can clarify a bit on DST and Brazil. Brazil decided by law 2008-09-08 that at 00:00 the third Sunday in October (which is 2008-10-18) is the change from DST to normal time and at 00:00

Re: Date 2042-10-12 problem using Brasilia time zone

Bernt M. Johnsen wrote (2008-10-31 15:45:18): Although I can't shed any light on the Java/JavaDB problem, I can clarify a bit on DST and Brazil. Brazil decided by law 2008-09-08 that at 00:00 the third Sunday in October (which is 2008-10-18) is the change from DST to normal time and at 00:00

Re: Bug #DERBY-3593

Bruno Medeiros wrote (2008-04-09 16:10:50): Hi, I found a bug that i`d described in jira, but no answer up tp now. There is one comment on https://issues.apache.org/jira/browse/DERBY-3593 Did i do something wrong in the bug post? I thought a little strange haven`t found this bug in

Re: Update Substring of a field

Reginald Johnson wrote (2008-03-30 00:48:33): Is it possible to update the substring of a field? I'm trying to do something like this: UPDATE tblIntervals SET SessionMouseID = 'ggg', substr(SessionID, 0, 3) = 'ggg' WHERE SessionMouseID = 'bbb' Neither Derby, nor the SQL standard supports

Re: sql format in *.sql files

dexter195 wrote (2008-02-14 04:20:13): Hi I have a load of sql files that i need to be able to import into derby. What delimiter do i need at the end of the statements in order for derby to see it as a seperate query. i presumed that this would be ; but this doesnt work. I've tried

Re: Derby Equivalent of MySql queries

Hi, Aneez Backer wrote (2007-11-21 20:05:01): Thanks Bernt. That helped Just a small question: Is there some special (e.g. performance) requirements that force you to maintain the data in TABLEB? Since SELECT TAGCOUNT FROM TABLEB WHERE ID=xxx; should give the same result as SELECT

Re: how to suppress similar rows while copying from one table to another?

Bernt M. Johnsen wrote (2007-11-19 10:23:05): If there exists a column k in your source data which is unique and you may use the aggregate function MIN on this column you may do something like: INSERT INTO target (SELECT source.k, source.col1, source.col2, source.arbitrary FROM

Re: Derby Equivalent of MySql queries

Hi, BEGIN/END is part of SQL PSM and not supported by Derby. In addition you can't write NEW.TAG_ID or OLD.TAG_ID but have to use a refernecing clause (See http://db.apache.org/derby/docs/dev/ref/rrefsqlj89752.html). This as according to the SQL spec. In your case, the triggers can be rewritten

Re: Derby Equivalent of MySql queries

?? thanks aneez Bernt M. Johnsen [EMAIL PROTECTED] wrote: Hi, BEGIN/END is part of SQL PSM and not supported by Derby. In addition you can't write NEW.TAG_ID or OLD.TAG_ID but have to use a refernecing clause (See http://db.apache.org/derby/docs/dev/ref/rrefsqlj89752.html

Re: how to suppress similar rows while copying from one table to another?

Hi, Dag H. Wanvik wrote (2007-11-17 02:37:27): Tried in vain to come up with a clever single INSERT, though. Depending on the data, this might be done in SQL with a clever single INSERT. If there exists a column k in your source data which is unique and you may use the aggregate function MIN

Re: how to suppress similar rows while copying from one table to another?

Bernt M. Johnsen wrote (2007-11-19 10:23:05): Hi, Dag H. Wanvik wrote (2007-11-17 02:37:27): Tried in vain to come up with a clever single INSERT, though. Depending on the data, this might be done in SQL with a clever single INSERT. If there exists a column k in your source data

Re: Problem with group by with Derby

Hi, I guess you get the error message ERROR 42X04: Column 'something' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or

Re: Case insensitive indexed search possible?

Rick Hillegas wrote (2007-11-02 05:21:09): Hi Jon, The situation with case-insensitive searching did not change in the latest 10.3 release and no one has volunteered to address this issue in the next feature release, 10.4. If you want to avoid the full table scan, you can store the text

Re: Concerning UNIQUE keys

adedayo damilola wrote (2007-08-16 14:05:27): After reading the Derby document(s) I discovered that the UNIQUE constraint in Derby does not allow NULL values to be inserted into a cloumn with the constraint applied. So I was wondering if there was another way to achieve since the UNIQUE

Re: REPLACE INTO/INSERT IF NOT EXIST

Hi, Kurt Huwig wrote (2007-06-19 10:46:09): Hi, I am using HA-JDBC as a clustering solution and having a problem with exceptions due to duplicate keys. The application is multi-threaded, multi-JVM and needs to insert records into a table if they do not exist yet. It is possible, that

Re: REPLACE INTO/INSERT IF NOT EXIST

Kurt Huwig wrote (2007-06-19 12:34:38): Am Dienstag, 19. Juni 2007 schrieb Bernt M. Johnsen: Kurt Huwig wrote (2007-06-19 10:46:09): Unfortunately, both are not an option for me due to the way HA-JBDC works: it sends every SQL-update statement to every node. If it succeeds on one

Re: Characters and bytes

Williamson, Nick wrote (2007-06-19 11:09:34): Hi all, In Oracle, you can specify character columns widths in bytes (the default) or characters. The advantage of specifying column width in characters is that you can attempt to store - say - 10 multi-byte characters in a VARCHAR(10) column

Re: REPLACE INTO/INSERT IF NOT EXIST

Kurt Huwig wrote (2007-06-19 13:46:03): Am Dienstag, 19. Juni 2007 schrieb Bernt M. Johnsen: Ok, I see. I assumed that if HA-jdbc got an SQLException from one of the nodes, the complete transaction was rolled back on all nodes. I would say that such lack of transactional behaviour

Re: REPLACE INTO/INSERT IF NOT EXIST

Kurt Huwig wrote (2007-06-19 14:44:21): I must admit, that I did not read the JDBC 4.0 specs yet. Still IMHO having a cluster solution that mandates you to add handling code to every SQL command you execute is not a good idea, because I think this is the job of the cluster solution. All well

Re: User/password encryption and deployment

David Van Couvering wrote (2007-06-17 18:14:38): Oh, I get it now, 10.3 will add support for SSL. But this will encrypt all network traffic. If you just want to encrypt the password, you have to use the existing password encryption functionality (either ENCRYPT or STRONG SUBSTITUTION),

Re: User/password encryption and deployment

Bernt M. Johnsen wrote (2007-06-16 18:43:51): [EMAIL PROTECTED] wrote (2007-06-16 07:53:55): [...] There is, however small issue, if you choose ENCRYPTED_USER_AND_PASSWORD_SECURITY, newer Sun JCE's (from 1.4, I think) does not support the shared DHS value defined in the DRDA

Re: User/password encryption and deployment

Michael Segel wrote (2007-06-16 00:23:56): Which is why I'm a little suspect that the *only* way to do encryption on the wire is to be forced to bring in IBM's JCE. You don't need the IBM JCE. Sun's JDK comes with and JCE which works just fine. The docs tries to tell you that if you use an old

Re: User/password encryption and deployment

[EMAIL PROTECTED] wrote (2007-06-16 07:53:55): [...] There is, however small issue, if you choose ENCRYPTED_USER_AND_PASSWORD_SECURITY, newer Sun JCE's (from 1.4, I think) does not support the shared DHS value defined in the DRDA protocol. It's too weak. As an alternative solution for

Re: securityMechanism for network client - can't make it work

M. Johnsen [EMAIL PROTECTED] wrote: Hi, Are you sure you use Derby 10.2.1.6 or newer? The error response seems to indicate an earlier version. Bernt David Van Couvering wrote (2007-06-15 12:12:38): OK, I'm completely flummoxed. I am trying to use strong password mechanism instead

Re: securityMechanism for network client - can't make it work

it say this is what you need to do. I'll log a bug for that too. There is support for mnemonics... just use STRONG_PASSWORD_SUBSTITUTE_SECURITY instead of 8. David On 6/15/07, Bernt M. Johnsen [EMAIL PROTECTED] wrote: Well the server is new enough, but what about the client. Look here

Re: securityMechanism for network client - can't make it work

Bernt M. Johnsen wrote (2007-06-16 00:39:02): David Van Couvering wrote (2007-06-15 15:21:28): Thanks, Bernt, that was it. BTW, 8 is not a very helpful property value. It makes me feel like I'm in a COBOL or Fortran shop. We should add support for mnemonics, rather than just

Re: Connection refused

Hi, Steve Pannier wrote (2007-06-05 10:28:18): Hi all. I'm trying to access the network server using the network client driver. I connect to my database from a remote client and keep getting the connection refused error. Even when I connect from the local system, I get the error (in

Re: What is the UPDATE syntax for using two tables?

Luan O'Carroll wrote (2007-05-28 09:18:22): The SQL given is for SQLServer and I can't find the correct SQL for Derby, the problem being that Derby doesn't support the FROM clause in an UPDATE statement. I've tried the following: UPDATE TEMP_RATES SET TEMP_RATES.Level1=RATES.Level1

Re: What is the UPDATE syntax for using two tables?

[EMAIL PROTECTED] wrote (2007-05-25 09:29:23): Luan O'Carroll [EMAIL PROTECTED] writes: I have a SQL Server query that I am trying to port to Derby but I can't find the right syntax. Is there any documentation? The SQLServer query is: UPDATE TEMP_RATES SET Level1=RATES.Level1

Re: maxrows - what does it really mean?

David Van Couvering wrote (2007-05-15 10:10:52): I can imagine myself writing a nice little API that sets the offset limit, and then have a pluggable implementation for each of the drivers. But of course, that's what JDBC is supposed to do for me :) I have suggested for next the JDBC version

Re: maxrows - what does it really mean?

What David wants, is the feature rgistered in https://issues.apache.org/jira/browse/DERBY-581 Craig L Russell wrote (2007-05-13 12:06:38): Also, how is maxrows related to the fetch size of a ResultSet? As I understand it, the fetch size relates to the number of rows returned by the server

Re: maxrows - what does it really mean?

operations http://wiki.apache.org/db-derby/SQLvsDerbyFeatures), Thanks, David On 5/14/07, Bernt M. Johnsen [EMAIL PROTECTED] wrote: What David wants, is the feature rgistered in https://issues.apache.org/jira/browse/DERBY-581 Craig L Russell wrote (2007-05-13 12:06:38): Also, how

Re: maxrows - what does it really mean?

David Van Couvering wrote (2007-05-14 13:11:00): Thanks for the tip, Bernt, but I must humbly say yuck! to the syntax. OK, getting over that, it's pretty worthless to me given that Derby doesn't use it and Derby is the primary DB used by NetBeans. But let's say it was implemented -- would

Re: maxrows - what does it really mean?

Lance J. Andersen wrote (2007-05-14 16:38:03): Also, there are not a lot of DBs that support that syntax... :-( As far as I know, it's supported by DB2, MSSQL and Oracle (not quite pretty close anyway). MySQL and PostgreSQL has this non-standard LIMIT/OFFSET stuff. -- Bernt Marius Johnsen,

Re: Insert JAVA_OBJECT in embedded Derby DB

You need to serialize the object. One way of doing it is like this: ByteArrayOutputStream bos = new ByteArrayOutputStream(); ObjectOutputStream oos = new ObjectOutputStream(bos); oos.writeObject(item); oos.close(); ps.setBytes(1, bos.toByteArray()); An

Re: Help reading transaction logs

Hi, Don't know why you get a null result, it might be that you should position after some preamble or something like that. But, I'm curious about what you really want to achieve? There might be better ways to do it than reading the transaction log. Bernt Andy Stewart wrote (2007-05-03

Re: Problem in release connection

Hi, Maybe it would help to close the prepared statement befor you close the connection, which also would be the natural way of cleaning up. Bernt Shambhu wrote (2007-03-21 18:55:29): Hi, I am using Cloudscape(IBM Cloudscape Version 10.1) and derbyclient.jar provided by derby. Following

Re: How to execute optimizer overrides in a java app

I think this discussion is another arument for https://issues.apache.org/jira/browse/DERBY-1749 Then an example could be ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB /*derby-properties index=IDX1*/ order by num); while SELECT num, addr FROM derbyDB /*derby-properties

Re: profiling the derby code: statement compiler is sub-par

Hi, With this result i would guess that you do something like (Derby is compiling a new statement for each iteration): Statement s = conn.createStatement(); for (int i=0;i200;i++) { s.executeUpdate(insert into data values(+i+,.)); } Try something like PreparedStatement s =

Re: Does derby support bitwise operators in SQL?

Hi, Imran Hussain wrote (2007-03-02 10:02:11): Dan, Thanks for the response. I wonder if there is any plan to add support for this in the future? Not as far as I know, but this is a open source project, and as such this will not be implemented unless someone feels the itch to do so. You

Re: prepared statements

Hi, This behaviour is defined in the JDBC specification. Amir Michail wrote (2007-02-26 14:46:33): Hi, Why is it that prepared statements are created with respect to a connection? Why can't you share a prepared statement across connections? Amir -- Bernt Marius Johnsen, Database

Re: Atomic check for row existence and insert if doesn't exist

Hi, Ace Jayz wrote (2007-02-12 09:50:22): Ace Jayz wrote: If REPEATABLE READ is in effect, then no other transaction would be able to delete the row between the insert and the select because this would result in different results for the select statement if it were repeated.

Re: Atomic check for row existence and insert if doesn't exist

Ace Jayz wrote (2007-02-09 21:08:44): I've got a table with an identity column, P, as a primary key. This table has another column, C, with a uniqueness constraint. I want to insert a row into the table if no row has a value for C=c, and if a row does exist whose column C=c I want to get

Re: Derby fully sql-2003 compliant?

[EMAIL PROTECTED] wrote (2007-02-01 19:15:16): Christian Lang [EMAIL PROTECTED] writes: Hi, I'm trying to understand which SQL language subset Derby is using. I installed version 10.2.2.0 and tried to compile and execute the following statement: SELECT MIN(A) OVER

Re: Date Arithmetic - Add 5-day DURATION to CURRENT_DATE

Anders Morken wrote (2007-01-31 15:49:46): Sisilla: How do I insert a date value of 5 days after the current date to a column called 'responseDate' in a table called 'quotationRequest'? Perhaps, it would be similar to the following?-: INSERT INTO quotationRequest (responseDate) VALUES

Re: Derby and 2007 Extended DST

Bernt M. Johnsen wrote (2007-01-25 22:08:28): Darryl Bowler wrote (2007-01-25 14:33:13): Does anyone know if Derby is affected by this years Extended Daylight Saving Time? If so, is there a fix? Derby is indirectly affected through the Java VM. If the VM is correct, then Derby

Re: Derby and 2007 Extended DST

Darryl Bowler wrote (2007-01-25 14:33:13): Does anyone know if Derby is affected by this years Extended Daylight Saving Time? If so, is there a fix? Derby is indirectly affected through the Java VM. If the VM is correct, then Derby will behave correctly. You will have to check out the VM

Re: Derby row locking semantic

Mamta Satoor wrote (2007-01-18 13:54:28): Hi, I might be showing my ignorance here but will probably learn in the process. I looked at http://db.apache.org/derby/docs/10.2/devguide/cdevconcepts15366.html and found under Table 3 that for TRANSACTION_READ_COMMITTED, it is possible to see

Re: unique columns must be nullable ?

Xanana Gusmao wrote (2006-12-12 04:08:39): On this page http://wiki.apache.org/db-derby/HibernateHelp it says: Hibernate Annotations do not work because Derby does not allow a unique column to be nullable Is this (that Derby's unique column must be non-nullable) still true ? That's

Re: (10.1.1.0) Cannot close active connection

Xanana, It could be that you're hitting https://issues.apache.org/jira/browse/DERBY-2084 or https://issues.apache.org/jira/browse/DERBY-638 Bernt Xanana Gusmao wrote (2006-12-06 09:26:40): Kristian, In terms of upgrading, I will come back to you later on that. This is a production system

Re: Use SQL parsing

Flavio Palumbo wrote (2006-11-29 09:11:10): Hi all, maybe a bit OT ... but I'd like to use the SQL parsing engine of Derby ; my goal is to validate a string to say it's a correct SQL statement, before to execute it. Is it possible with no headache ?? The easiest way is to do

Re: Limiting select results

Charlie Babitt wrote (2006-11-25 14:53:23): Hallo! How can I limit the maximum rows that are returned in a select in apache derby? select * from table LIMIT 10; (as it works in postgres) gives me a syntax error at 10 Any help would be great... What about statement.setMaxRows(10)

Re: [OT] Two suggestions on list management...

Bernt M. Johnsen wrote (2006-11-13 23:12:04): The rest of this mail should be directed to [EMAIL PROTECTED] [FYI] Since only comitters are allowed to mail on [EMAIL PROTECTED], I forwarded your mail there. Reply from infrastructure: For example, the Dovecot mailing list will include

Re: [OT] Two suggestions on list management...

[EMAIL PROTECTED] wrote (2006-11-13 08:10:55): Has anyone else noticed an increase in Spam? Yes. I'm running a server with several mailing lists (completely unrelated to any Apache project whatsoever), and have had a notiecable increase in spam attacks on list-adresses lately. I solved the

Re: [OT] Two suggestions on list management...

The rest of this mail should be directed to [EMAIL PROTECTED] [FYI] Since only comitters are allowed to mail on [EMAIL PROTECTED], I forwarded your mail there. -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway

Re: slow subqueries

Jim Newsham wrote (2006-11-11 10:07:18): This is why a nested loop is not going to work here... 20,000 squared operations is very expensive, let alone millions squared. For a query with this profile, the inner query should only be executed once. Perhaps you can get the

Re: What is correct way of closing an embedded connection ?

legolas wood wrote (2006-10-31 01:53:52): Hi Thank you for reading my post what is proper way of closing a connection when we use an embedded Derby database? connection.close(); is it ok if we create several connection against an Embedded Derby , yes how will be the resource

Re: how to make a replication between mysql and derby?

Hi, You could also check out C-JDBC (http://c-jdbc.objectweb.org/) and especially this document: http://c-jdbc.objectweb.org/current/doc/C-JDBC_horizontal_scalability.pdf -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems,

Re: Unicode support

Ninad Agate wrote: Does Derby 10.1 support UTF-8 and UTF-16 encodings? I have not been able to find this information in the reference docs. Thanks. Derby supports Unicode for CHAR,VARCHAR,CLOB etc. Data is stored in UTF-8 on disk, and transferred between network client and server in UTF-8.

Re: read-only database in a web application?

David Harrigan wrote: Hi, The ongoing learning adventure continues! :D My database is built, now I've jar'ed it up thusly: searchdb.jar contains: searchdb/seq0 serachdb/seq0/.. searchdb/log.. searchdb/log/.. etc... Now, I've dropped this jar into the

Re: Top 1 - Limit 1

Tim Dudgeon wrote: Marl Atkins wrote: This would only work if the ID field is an Identity. As it happens, it IS so this should work for me too. THREE answers to my problem. You guys are good THANKS!! Yes, but is there an equivalent to the TOP or LIMIT keywords that other

Re: Top 1 - Limit 1

Tim Dudgeon wrote: Bernt M. Johnsen wrote: Tim Dudgeon wrote: Yes, but is there an equivalent to the TOP or LIMIT keywords that other databases use? Not in SQL (neither in Derby nor the SQL standard). The closest equivalent is Statement.setMaxRows(i). So that would

Re: DROP IF NOT EXISTS

yves pielusenet wrote: I wonder if there is something similare like : 'drop index id_index if not exists' ? I want to put a condition on a drop statement but it fails. how can I do ? You could do it like this: try { stmt.executeUpdate(drop index id_index); } catch (SQLException e) {

Re: java.sql.SQLRuntimeException: Cannot store DataSet instance to WeakHashMap

Hi all This is a JDK6 b98 problem, and not related to Derby. Bernt [EMAIL PROTECTED] wrote: The following message is a courtesy copy of an article that has been posted to comp.lang.java.databases as well. I'm cc'ing this reply to derby-user@db.apache.org, since not many derby people

Re: Alias problem in SELECT with HAVING clause

Robert Enyedi wrote: For the following database structure: CREATE TABLE users ( id INT PRIMARY KEY, email VARCHAR(64) ); CREATE TABLE notification ( id INT PRIMARY KEY, user_id INT, count INT NOT NULL ); I use this query: SELECT users.email, users.id AS user_id

Re: ENUM

Dan Scott wrote: On the SET datatype: Even the MySQL docs include a section upfront called Why you shouldn't use SET (http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html). It's not an atomic datatype. Bad. On ENUM: The SQL standard way of doing the equivalent of ENUM, and

Re: multiple network cards

You will find all the details you need in Derby Server and Administration Guide Quote (on derby.drda.host): If the property is set to 0.0.0.0, Network Server will listen on all interfaces. [EMAIL PROTECTED] wrote: Hi, I am in need of some information on the following scenario. Scenario:

Re: SQL Parser failing on NULL column contraint

I can't see any reason why anyone would spend time on this issue. 1) NULL is not a constraint. All columns are nullable by default (SQL standard and in all SQL databases to my knowledge). 2) It will not add any new functionality. 3) You will not gain anything in speed, resource usage etc.

Re: How to modify the SQLParser to handle NULL in column definitions ?

Hi, This is a developer question which should be posted on derby-dev. Anyway, although I know there are databases which allow you to specify nullability by the keyword NULL (which is redundant since columns are nullable unless given a NOT NULL constraint), this is *not* a part of the SQL

Re: case insensitive searches

Hi, Edson Carlos Ericksson Richter wrote: Is not possible to create a index based on function results? Not for the moment. It is proposed as a new feature (https://issues.apache.org/jira/browse/DERBY-455), but I don't think anyone is working on it presently. Regards, Richter

Re: Working set memory usage

Clive Borrageiro wrote: Hi, When I use derby as an embedded database that contains a large amount of records (in excess of 100,000), the Working set memory (as seen under Windows Task Manager Mem Usage) of the application's process grows with time usage. I created a simple test

Re: generated by default question

Michael Segel wrote (2006-06-14 09:23:45): 6) I can find no relation, whatsoever, defined in the standard between the existing values in a column and how the internal sequence generator of an identity column behaves. [mjs] Correct. Nor would you. That gap is left to the

Re: generated by default question

Let me clearify some items from the SQL 2003 standard related to the latest mails regarding this issue from Craig and Michael: 1) In the case of generated always, it should not be possible to insert explicit values in identity columns, nor to alter generated values. 2) Internal and

Re: generated by default question

Well, I'm the one that doesn't accept this as a bug/defect since Derby behaves according to the SQL standard. My stand is based on the chapters 4.14.17 and 9.21 in the SQL 2003 (INCITS/ISO/IEC 9075-2-2003 Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)), see

Re: A truncation error was encountered tryin,g to shrink BLOB 'XX-RESOLVE-XX' to length 1048576.

Daniel John Debrunner wrote (2006-06-06 14:39:56): Farrukh Najmi wrote: Daniel John Debrunner wrote: You probably created the table without specifying a length on BLOB, this defaults to BLOB(1M). You need to use BLOB(2G). e.g. create table T (a int, b BLOB(2G)) A bug about this

  1   2   >