[VOTE][RESULT] Use svnpubsub for publishing DB project release artifacts

2014-04-05 Thread Craig L Russell
/release/db/ This can be done by anyone in the DB PMC. Infra will then establish the sync to the official Apache release directory. Thanks, everyone. Craig On 24.03.14 18:11, Craig L Russell wrote: Hi PMC, Recently the JDO project set up to use svnpubsub to publish our releases. We have opened this

Re: Most efficient way to get max row id?

2008-10-21 Thread Craig L Russell
. Amir -- http://chatbotgame.com http://numbrosia.com http://twitter.com/amichail Craig L Russell Architect, Sun Java Enterprise System http://db.apache.org/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp! smime.p7s Description: S/MIME cryptographic signature

Re: performance issue

2008-10-19 Thread Craig L Russell
Linux ) do you think multiple threads will really help ? Yes. But, before changing your benchmark, it seems better to try to understand the results you are getting. Are you willing/able to share your benchmark with the community? thanks, bryan Craig L Russell Architect, Sun Java Enterprise S

Re: Saving XML into a database

2008-08-28 Thread Craig L Russell
in context: http://www.nabble.com/Saving-XML-into-a-database-tp19149566p19204059.html Sent from the Apache Derby Users mailing list archive at Nabble.com. Craig L Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp! smime.p7s Description: S/MIME cryptographic signature

Re: Problem with UNIQUE constraint

2008-08-13 Thread Craig L Russell
ble. I have other tables, too, with UNIQUE constraint and there the constraint works properly, i. e. when an attempt is made to insert a duplicate record, an exception is thrown. I appreciate any help about how to solve this problem. Thanks in advance Dmitri Pissarenko -- http://www.xing.com/profi

Re: Problem with UNIQUE constraint

2008-08-13 Thread Craig L Russell
ce Dmitri Pissarenko Craig L Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp! smime.p7s Description: S/MIME cryptographic signature

Re: Determine which child table a record belongs to

2008-01-29 Thread Craig L Russell
associated tables for the same row in the primary table. If this is the case, then you can't use a single-valued discriminator. You could use a bit field represented as a number in which each bit corresponds to an associated Role with data in another table. Craig Craig L Russell wro

Re: Determine which child table a record belongs to

2008-01-29 Thread Craig L Russell
This is a very common pattern in object-relational mapping. The column that contains the type of crane is commonly referred to as a discriminator column, and is commonly a CHAR, VARCHAR, or NUMERIC type. The value of the discriminator column that identifies which table to look for is referr

Re: Temp Tables: User can not perform the operation in schema 'SESSION'.

2007-12-06 Thread Craig L Russell
Is it possible that this is a file system permission issue? Can both the owner of the database and the user have the same group permissions to create files in the database directory? Craig On Dec 5, 2007, at 11:34 PM, Mamta Satoor wrote: That's a very good question. It would seem that user

Re: Getting "Constraints 'SQL071017145943950' and 'SQL071017145906390' have the same set of columns, which is not allowed." while adding a Unique/primary key constraint to the table

2007-10-17 Thread Craig L Russell
Hi Suman, You do not get any extra value from II or IV. It's sufficient to have the primary key on the two columns. That gives you uniqueness for the columns and so an extra uniqueness constraint is redundant, and, well, erroneous. Craig On Oct 17, 2007, at 3:46 AM, Suman N wrote: Hi,

Re: checking if table exists

2007-10-03 Thread Craig L Russell
On Oct 3, 2007, at 6:44 AM, Bryan Pendleton wrote: while((result.next()) & (tableExists = false)) { Is this possibly a typo? Make sure it says: while((result.next()) && (tableExists == false)) { You want to do a logical and, not a bitwise and; The difference betwe

Re: Why do class names start with lower lowercase?

2007-09-17 Thread Craig L Russell
Hi Sha Jiang, These are utility programs for which the natural name is lower case. For each class, there is a corresponding command, and rather than try to map dblook to a class DBLook or Dblook, the natural thing is to simply have the class name the same as the command name. Craig On Se

Re: How to restrict external connections

2007-09-11 Thread Craig L Russell
Hi Néstor Boscán, Yes, only one process at a time can access the Derby database files for any particular database. There's no inter-process mechanism to prevent corruption if multiple processes were to access the files. There is a mechanism to prevent multiple processes from accessing the

Re: Static SQl in Derby

2007-08-03 Thread Craig L Russell
If your application constructs SQL dynamically, it can be designed to exploit the compiled query aspects by following some guidelines: 1. Always use parameter markers when constructing your SQL statements. So instead of generating SQL like "SELECT e.name, e.salary FROM EMPLOYEE e where e.na

Re: Wanted: Working example of JDBC4 Annotations.

2007-07-17 Thread Craig L Russell
Hi Siegfried, This is a bit confusing. Sun decided to distribute Apache Derby and call it JavaDB. The bits you download from the JavaDB site and the bits you get already installed when you install Sun's Java SE 6 JDK and the bits you can download from the Apache Derby site are the same (m

Re: Number of Concurrent Connections

2007-07-13 Thread Craig L Russell
I've personally run with several hundred connections on my MacBook Pro. I'd suggest that with this many connections, you probably will need a good connection pooling adapter and not rely on DriverManager to directly manage your connections. Craig On Jul 13, 2007, at 11:20 AM, Anestis Sisma

Re: Should I leave nulls in a lookup table?

2007-06-03 Thread Craig L Russell
On Jun 3, 2007, at 8:14 AM, Peter Ondruska wrote: CHAR(1) will be same size no matter what value it holds. But if you allow nulls, then the database has to store the null/not null flag somewhere, thereby increasing the size of the data. Craig On 3.6.2007, at 14:17, Leslie Software wrote:

Re: maxrows - what does it really mean?

2007-05-13 Thread Craig L Russell
Hi David, Generally the JDBC spec stays clear of discussing the client-server protocol. The behavior described by the JDBC method is the user-visible behavior. There are two roles involved in the behavior, which might be implemented by two different providers: the JDBC provider (client)

Re: question on Working with JavaDB Activities

2007-05-03 Thread Craig L Russell
Hi Joe, On May 3, 2007, at 3:52 AM, [EMAIL PROTECTED] wrote: I'm getting a command line error of "'javac' is not recognized as an internal or external command...". I presume there is a problem with my JAVA_HOME path, You probably should know that there is a difference between JAVA_HOME an

Re: commit then read immediately

2007-04-18 Thread Craig L Russell
Hi, On Apr 18, 2007, at 3:05 AM, frederic barachant wrote: Hello. I have an application which initialises a database upon first start then immediately starts using it. Initialisation consists in writing objects through jpa. After commit is done, the program starts and reads back those data.

Re: Regarding JPO -Enhancer

2007-04-03 Thread Craig L Russell
Hi Rohini, If you are using the example from the paper: C:\JPOX_Derby>java -Dlog4j.configuration=file:src\log4j.properties -cp lib\bcel-5.1.jar;lib\jpox-enhancer-1.1.0-rc-1.jar;lib\jpox-1.1.0- rc-1.jar; lib\jdo2-api-2.0-rc1.jar;lib\log4j-1.2.12.jar;bin org.jpox.enhancer.JPOXEnhancer src\pac

Re: Using ij to connect to a Derby database

2007-03-26 Thread Craig L Russell
Hi Laura, On Mar 26, 2007, at 3:22 PM, Laura Stewart wrote: The text in the Getting Started Guide says: "You can use the ij tool to connect to a Derby database." The word "can" implies that there is another way to connect to a Derby database. Is there? Any program can connect to a Derby d

Re: Naming the next Derby feature release

2007-03-01 Thread Craig L Russell
Speaking as a user of Derby, On Mar 1, 2007, at 12:04 PM, Rick Hillegas wrote: We wonder what the user community thinks. In particular: A) Would calling this release 11.0 make it less likely that you would be blindsided by these incompatibilities? Yes. A new major release number is a yello

Re: Single Transaction Using Multiple Method Calls That Open New Database Connections

2007-02-15 Thread Craig L Russell
Hi Sisilla, You might look at using a java.lang.ThreadLocal to store the Connection or some object that stores more state including the Connection. Since you don't have to pass the Connection through multiple layers, it can make your code simpler and less "messy". Craig On Feb 15, 2007

Re: keeping the table ordered

2007-02-06 Thread Craig L Russell
It sounds like the issue is the structure of the rows on the data pages. IIUC, once a row is stored on a data page, it's going to be there for a long long time. So as you add new rows, they are added to data pages where there is free space. The only way to move a row is to delete it and ins

Re: Group By - problems

2007-02-05 Thread Craig L Russell
Hi Diego, The message is correct and Derby is behaving as it should. If you are using GROUP BY, you are aggregating a number of rows into a smaller number of rows, so instead of e.g. 100 rows all of which contain the same clienti.provincia, you aggregate all 100 rows into a single row. In

Re: ERROR 08001:No suitable driver

2007-01-18 Thread Craig L Russell
Hi Mike, I've made that same mistake too many times to count. It sure would be a nice feature in ij for it to wait for the semicolon for a decent interval (1 minute?) and then ask the user if they are done typing yet ;-) Craig On Jan 18, 2007, at 8:22 AM, Dunk, Michael (Mike) wrote:

Re: Columns of type 'REAL' cannot hold values of type 'CHAR'

2006-12-13 Thread Craig L Russell
Hi, I'd like to suggest that you avoid the pattern of dynamic construction of SQL, as in: insertQuery = "INSERT INTO basePlusCommissionWorkers " + "VALUES ( '" + socialSecurityNumber + "', '" + grossSales + "', '" + commissionRate + "', '" + baseSa

Re: unique columns must be nullable ?

2006-12-12 Thread Craig L Russell
On Dec 12, 2006, at 6:42 PM, Randy Letness wrote: Mike Matrigali wrote: Out of curiousity what behavior does Hibernate expect when 2 nulls are inserted into a "unique" nullable column? When you specify a unique constraint in hibernate, I'm pretty sure its only used by the schema export

Re: unique columns must be nullable ?

2006-12-12 Thread Craig L Russell
On Dec 12, 2006, at 4:28 PM, Mike Matrigali wrote: Craig L Russell wrote: On Dec 12, 2006, at 2:12 PM, Daniel Noll wrote: Mike Matrigali wrote: Out of curiousity what behavior does Hibernate expect when 2 nulls are inserted into a "unique" nullable column? That'

Re: unique columns must be nullable ?

2006-12-12 Thread Craig L Russell
On Dec 12, 2006, at 2:12 PM, Daniel Noll wrote: Mike Matrigali wrote: Out of curiousity what behavior does Hibernate expect when 2 nulls are inserted into a "unique" nullable column? That's my issue with unique nullable columns too. If it were to be truly unique you could only ever have o

Re: Which mapping framework

2006-11-10 Thread Craig L Russell
Hi Marc, I know of a few mapping frameworks in Apache: Torque, Cayenne, OpenJPA. If you're looking for a standard, OpenJPA should do it. If it doesn't need to be Apache, JPOX implements standard JDO and is Apache-licensed but run out of source forge. Craig On Nov 10, 2006, at 12:31 PM, M

Re: comparisons are not supported for long varchar datatype

2006-11-10 Thread Craig L Russell
Hi Sisilla,LONG VARCHAR is a type typically used for BLOBs: images, large documents, graphics, and the like. So it's inappropriate for a primary key or unique or indexed column.Are you sure that EmployeeID is a large object? Or perhaps it should be an integer or other integral type.CraigOn Nov 10,

Re: 10.2 licensing issue...

2006-09-12 Thread Craig L Russell
On Sep 12, 2006, at 9:49 AM, Geir Magnusson Jr wrote: Craig L Russell wrote: Hi Geir, On Sep 12, 2006, at 3:37 AM, Geir Magnusson Jr wrote: I read Rick's note on the 10.2 licensing issue in an archive because of strange move to the user list, so sorry for the weird quoting :

Re: 10.2 licensing issue...

2006-09-12 Thread Craig L Russell
either : 1) Sun to put a user-oriented spec license that lets us just create those API jars and let us _compile_. 2) Sun to put the API binary jars for JDBC4 under CDDL or even the BCL. geir Geir Magnusson Jr wrote: Craig L Russell wrote: Hi Geir, On Sep 12, 2006, at 9:17 AM, Geir Magnusson

Re: 10.2 licensing issue...

2006-09-12 Thread Craig L Russell
Hi Geir, On Sep 12, 2006, at 3:37 AM, Geir Magnusson Jr wrote: I read Rick's note on the 10.2 licensing issue in an archive because of strange move to the user list, so sorry for the weird quoting : This issue affects users of Derby just as much as developers. Users counting on a producti

Re: 10.2 licensing issue...

2006-09-12 Thread Craig L Russell
Hi Geir, On Sep 12, 2006, at 9:17 AM, Geir Magnusson Jr wrote: A) I couldn't figure out how to build the dummy jars without cribbing templates from either the beta code or beta javadoc. To me this cribbing seemed like a forbidden, productive use of the beta-licensed distribution. What's

Re: NullPointerException in Derby client

2006-08-28 Thread Craig L Russell
On Aug 28, 2006, at 7:17 AM, Daniel John Debrunner wrote: Craig L Russell wrote: Hi Robert, Please file a bug report in the Derby JIRA. Include the stack trace along with an ij script that creates the tables and a simple jdbc program that issues the query that causes the NPE. Someone on

Re: NullPointerException in Derby client

2006-08-28 Thread Craig L Russell
Hi Robert, Please file a bug report in the Derby JIRA. Include the stack trace along with an ij script that creates the tables and a simple jdbc program that issues the query that causes the NPE. Someone on the Derby dev team will follow up. Thanks, Craig On Aug 28, 2006, at 4:56 AM, Rob

Re: No suitable driver for ij

2006-08-13 Thread Craig L Russell
Hi Jeremy, Often the "no suitable driver found" message is an incorrect url, assuming that your classpath is set up ok (which is usually the case if you can get to the ij program itself). So what's your url? Craig On Aug 13, 2006, at 6:20 PM, Jeremy Foot wrote: I have derby working fine

Re: case insensitive searches

2006-08-09 Thread Craig L Russell
On Aug 9, 2006, at 4:27 PM, Farukh S. Najmi wrote: Stephen Caine wrote: Terry, Is it possible to set Derby to do case-insensitive searches? The default seems to be case-sensitive. This would be fine as a global setting that never needs to change. Are you using 'starts with', 'contain

Re: setNull in select doesn't work

2006-07-25 Thread Craig L Russell
Hi Knut, On Jul 25, 2006, at 12:11 AM, Knut Anders Hatlen wrote: Craig L Russell <[EMAIL PROTECTED]> writes: Hi Marieke, You have hit one of the big usability issues with SQL. While many vendors have implemented "WHERE value = ?" such that it behaves exactly like "WH

Re: setNull in select doesn't work

2006-07-24 Thread Craig L Russell
Hi Marieke,You have hit one of the big usability issues with SQL. While many vendors have implemented "WHERE value = ?" such that it behaves exactly like "WHERE value IS NULL" in case the parameter passed is null, it isn't required by the governing standard, and is not therefore a bug in an impleme

Re: Logging

2006-07-21 Thread Craig L Russell
11:02 AM, Myrna van Lunteren wrote: On 7/21/06, Craig L Russell <[EMAIL PROTECTED]> wrote: Hi, Is there a simple way to have Derby log stuff? I've scoured the doc and can't really find much. What I'm mostly looking for is execution of SQL statements, results coming

Logging

2006-07-21 Thread Craig L Russell
Hi,Is there a simple way to have Derby log stuff? I've scoured the doc and can't really find much. What I'm mostly looking for is execution of SQL statements, results coming back from the database, etc. I know, pretty general, but I can't find anything at all on how to configure the logging to get

Re: should Clob.getSubstring() allow length of 0?

2006-07-17 Thread Craig L Russell
Hi Lance, On Jul 17, 2006, at 8:55 AM, Lance J. Andersen wrote: The JDBC methods should, as much as the possibly can, be consistent with the behavior of methods in the JDK. I agree with your point here. I think all of us are saying that there is no inconsistency with zero length Strings in

Re: should Clob.getSubstring() allow length of 0?

2006-07-17 Thread Craig L Russell
I've filed DERBY-1516 for this discussion. I agree with Thomas, and would just point out that it appears that it's only the embedded Derby driver that has the issue. The code in the Derby access manager Blob and Clob are implemented correctly. Craig On Jul 17, 2006, at 8:36 AM, Thomas Dudz

Re: should Clob.getSubstring() allow length of 0?

2006-07-15 Thread Craig L Russell
Jul 14, 2006, at 11:13 PM, Kathey Marsden wrote: Craig L Russell wrote: You can always work around odd code on the other side of an incompletely defined interface. But you probably have code on the Derby side that also checks for the clob.length() == 0 and take some extraordinary action

Re: should Clob.getSubstring() allow length of 0?

2006-07-14 Thread Craig L Russell
Hi Kathy, On Jul 14, 2006, at 6:46 PM, Kathey Marsden wrote: Lance J. Andersen wrote: Hi Kathy, I would probably expect a SQLException to be thrown in this case or I guess you could return nothing. I will assume then that the Derby behavior is correct and won't file a bug. Thank you

Re: should Clob.getSubstring() allow length of 0?

2006-07-14 Thread Craig L Russell
Hi Lance, Unless I'm missing something, a zero length java.lang.String is legal and necessary for completeness. Since there's nothing in the quoted text, I'd assume that a zero-length String should be returned as long as the start position is legal. Not an exception, not null, not "nothin

Re: BigDecimal incompatibility from 1.5 -> 1.4

2006-07-13 Thread Craig L Russell
Hi Ray,This sounds like a bug in the compiler. Have you raised an issue with the JDK folks?CraigOn Jul 13, 2006, at 9:38 AM, Ray Kiddy wrote:I have been e-mailing with Andrew McIntyre about getting some things done in the build of Derby on Mac OS X.We (at Apple) are seeing something and I am wonder

Re: Deadline: Monitoring and Management Requirements for Derby June 18

2006-06-19 Thread Craig L Russell
I have to agree that the focus of the project should be on the implementation of the MBeans for Derby. Lots of clients can access the properties exposed by the MBean. Craig On Jun 19, 2006, at 3:11 PM, David Van Couvering wrote: Sanket Sharma wrote: What ever feature I deliver, will be

Re: "generated by default" question

2006-06-14 Thread Craig L Russell
+1 Craig On Jun 14, 2006, at 4:07 AM, Bernt M. Johnsen wrote: 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

Re: "generated by default" question

2006-06-13 Thread Craig L Russell
Hi G, On Jun 13, 2006, at 12:07 PM, Michael Segel wrote: If there exists a value N such that you can return V1 that doesn't throw an exception due to the unique constraint on the identity column, then the sequence should return that number. Or rather Derby should trap for this and determin

Re: "generated by default" question

2006-06-13 Thread Craig L Russell
Hi, On Jun 13, 2006, at 11:01 AM, Craig L Russell wrote: In fact, you could argue that if the implementation skipped returning a sequence value just because that value had been inserted by the user into a column, it would be a bug. I withdraw this argument after re-reading the words. It is

Re: nullable FK constraint

2006-06-13 Thread Craig L Russell
Hi,On Jun 13, 2006, at 10:54 AM, Nefi Percola wrote:Hi Piet,Thanks for the reply.  Actually I followed Daniel's post and he was right about the FK constraint.  My real problem is that I'm trying to persist a user that already has an account id into the database before the account record is inserted

Re: "generated by default" question

2006-06-13 Thread Craig L Russell
Hi Mikey, On Jun 13, 2006, at 10:47 AM, [EMAIL PROTECTED] wrote: by default" question Hi Mikey, On Jun 12, 2006, at 10:05 PM, [EMAIL PROTECTED] wrote: [mjs] I believe the problem is in how you're interpreting clause 3): " 3) If there exists a non-negative integer N such that SMIN <

Re: "generated by default" question

2006-06-13 Thread Craig L Russell
Hi Mikey, On Jun 12, 2006, at 10:05 PM, [EMAIL PROTECTED] wrote: [mjs] I believe the problem is in how you're interpreting clause 3): " 3) If there exists a non-negative integer N such that SMIN <= CBV + N * INC <= SMAX and the value (CBV + N * INC) has not already been

Re: Dublin anyone?

2006-06-01 Thread Craig L Russell
I'm not a derby committer, but I do plan to attend ApacheCon in Dublin later this month. I've got a presentation on Friday.Craig Craig Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp! smime.p7s Descript

Re: JMX Extensions to Derby

2006-06-01 Thread Craig L Russell
On Jun 1, 2006, at 1:51 AM, Bernt M. Johnsen wrote: Øystein Grøvlen wrote (2006-06-01 09:24:18): Sanket Sharma wrote: I would also appreciate your suggestions on features the community would like to see being implemented as JMX extensions. On the top of my head: - Performancs statistics

Re: "generated by default" question

2006-05-30 Thread Craig L Russell
Hi G, Do you have a good solution that you can write up in detail and post to JIRA? Then someone with an itch can fix it. Do-ocracy in action. Craig On May 30, 2006, at 7:38 AM, [EMAIL PROTECTED] wrote: Hmmm, Yeah, that's what I'm afraid of. Essentially what they are asking is that if y

Re: 10.2.0.1 snapshot posted

2006-05-26 Thread Craig L Russell
Hi Andrew, I hadn't seen this jewel before. Thanks for letting me know that the release numbering scheme is well-established and consistent. Craig On May 26, 2006, at 8:38 PM, Andrew McIntyre wrote: On 5/26/06, Craig L Russell <[EMAIL PROTECTED]> wrote: Does this mean that t

Re: 10.2.0.1 snapshot posted

2006-05-26 Thread Craig L Russell
ps these are patch distributions, cut off the living, growing end of the 10.1 branch and given to targetted customers. Can anyone else shed light on this? Regards, -Rick Craig L Russell wrote: Hi Rick, One question: Why is the snapshot called 10.2.0.1 and not just 10.2? It sounds from the n

Re: 10.2.0.1 snapshot posted

2006-05-26 Thread Craig L Russell
Hi Dan, Thanks for confirming that 10.1.2.1 is the latest. Craig On May 26, 2006, at 4:01 PM, Daniel John Debrunner wrote: Craig L Russell wrote: I also see on the snapshots page that: Latest Official Release 10.1.2.1 (Nov 18, 2005 / SVN 330608) but later on in the same page it appears

Re: 10.2.0.1 snapshot posted

2006-05-26 Thread Craig L Russell
Hi Rick, In the JDO project, I define a dependency on Derby via maven pom: org.apache.derby derby 10.1.1.0 org.apache.derby derbytools 10.1.1.0 In order for me to test your snapshots, th

Re: 10.2.0.1 snapshot posted

2006-05-26 Thread Craig L Russell
Hi Rick, One question: Why is the snapshot called 10.2.0.1 and not just 10.2? It sounds from the name like this is the first patch after the release of 10.2. I must be missing something. I was expecting the file to be called db-derby- snapshot-10.2-409481.zip not db-derby-snapshot-10.2.0.1

Re: Proposal to change Derby's public api for XADataSource and ConnectionPoolDataSource

2006-05-16 Thread Craig L Russell
Hi, It appears that you have made the appropriate change. XADataSource is not a user API, and in fact isn't a kind-of DataSource. It was misnamed (IMHO) from the beginning. An XADataSource is a factory that produces XAConnections, which are not Connections, but are chimeras (produced by an

Re: Out of Memory

2006-05-15 Thread Craig L Russell
Hi, Often, memory leaks are caused by not closing statements or result sets. If you post the program that leaks, we might be able to help you figure out if it's a problem in your application or a problem in Derby. Regards, Craig On May 15, 2006, at 5:02 AM, Michael Andreasen wrote: I a

Re: Javadoc lies

2006-05-08 Thread Craig L Russell
to specify at the "bolted web page" which API you're interested in, I think it's better than finding out the hard way that the javadoc info is incorrect. Craig Thanks, -Rick Craig L Russell wrote: Hi Rick, I'm intentionally cross-posting to derby-user just bec

Re: Javadoc lies

2006-05-05 Thread Craig L Russell
Hi Rick,I'm intentionally cross-posting to derby-user just because lies in javadoc are supposed to affect users, not only developers.How about:3. Build two sets of javadoc, one using jdk 1.4 and another using 1.6. Distribute both sets of javadoc. Require the user to choose which javadoc to use base

Re: [WWD] Review of Final Chapters (5 and 6)

2006-05-03 Thread Craig L Russell
Hi Stan, When you get around to discussing architecture issues, you might make sure you get feedback from the derby experts. My understanding is that you can use the embedded Derby with both same-vm clients and outside-vm clients by starting the network server when you start the embedded

Re: SecurityException on mail.jar and activation.jar

2006-05-02 Thread Craig L Russell
Hi Hans, Have you double checked your path to make sure the jar you verified is the jar that's being used? Craig On May 1, 2006, at 11:56 PM, Hans Cappelle wrote: I really think this is a Derby issue. Had some conversation with a developer of sun who told me they indeed can only sign jars

Re: Query and uppercases

2006-04-26 Thread Craig L Russell
If you are concerned about performance, please note that there is a huge difference between these two statements: 1. SELECT * FROM CITY_INFO WHERE UPPER(?) = CITY_NAME and 2. SELECT * FROM CITY_INFO WHERE ? = UPPER(CITY_NAME) Query 1 will work if your data is already upper case. You can do a

Re: How to find master record primary key to use it in inserting details records

2006-04-13 Thread Craig L Russell
Hi Legolas, If you're using JDBC, you can use the Statement.getGeneratedKeys() method. You define the master table with the primary key column being IDENTITY. You insert a row using Statement.execute(), call getGeneratedKeys, and the ResultSet returned from the method contains the value o

Re: PreparedStatement Persistance

2006-04-05 Thread Craig L Russell
On Apr 5, 2006, at 10:31 AM, Daniel John Debrunner wrote: Daniel Morton wrote: Over the past few threads, someone mentioned that the PreparedStatements are cached on the database even when the connection that created the PreparedStatements are closd... I was discussing that very issue with an

Re: unable to execute procedure

2006-04-04 Thread Craig L Russell
Hi Dan, May I suggest that if you are writing samples for others to use that you demonstrate use of parameter markers in PreparedStatements. This will perfom better on Derby and all other relational database engines. I think this is a very important point, and if you look at the procedure,

Re: [web] Derby site reorganization (resend)

2006-03-27 Thread Craig L Russell
Hi Jean, On Mar 27, 2006, at 5:04 PM, Jean T. Anderson wrote: I just hate it when you hit the wrong key and something gets sent before it's ready. Here's a resend. I reorganized the Derby web site and put a review copy here: http://people.apache.org/~jta/DerbyTest/ I never had an issu

Re: SQL Exception

2006-03-03 Thread Craig L Russell
funny. I've been doing the same. Not just with Java but with ESQL/C too. In C, it's a simple switch(){} structure with a default being to set the value to setNull(); Ok, Java isn't C, but the concept transcends languages. Bernt M. Johnsen wrote On 03/01/06 11:21,:

Re: SQL Exception

2006-03-03 Thread Craig L Russell
if (value == null) { ps.setNull(parameterIndex, sqltype); } else { ps.setObject(parameterIndex, value); } And how did I know deep inside my code what myMetadata is? Did I pass it in as a parameter? Why should this inner loop have to know the details of what type the parameter is? Craig Be

Re: SQL Exception

2006-03-01 Thread Craig L Russell
I have to say I don't understand the rationale for throwing an exception here. Looking at the stack trace, I agree with Bernt that the user is calling setObject(column, null). What I don't agree with is that there is any ambiguity as to what the user means. The setObject javadoc sez: The J

Re: order by

2006-02-28 Thread Craig L Russell
Hi Tom, I can't think of anything to cause your problem as you have described it. I'd suggest filing a JIRA issue and attaching a small sample program (either Java with JDBC or an ij script) that shows the problem. Then the experts can sink their teeth into it. Craig On Feb 28, 2006, a

Re: Using/Adressing a "row number" in a SELECT query

2006-02-22 Thread Craig L Russell
ts array $counter++; } } And for a worst-case scenario, it turns out that this isn't really all that bad: there is almost no network traffic required to simply move the fetch() pointer ahead by a row when you're not actually retrieving a row. Dan On 2/20/06, Craig L Russell <

Re: Using/Adressing a "row number" in a SELECT query

2006-02-20 Thread Craig L Russell
mething like :    SELECT * FROM(SELECT ..., [row] AS n FROM ... WHERE ... ) WHERE n BETWEEN $start AND $end ... in order to get a paging system on the results ? On 2/19/06, Craig L Russell <[EMAIL PROTECTED]> wrote: Hi,You might consider using a column that the database automatically increm

Re: Using/Adressing a "row number" in a SELECT query

2006-02-19 Thread Craig L Russell
Hi,You might consider using a column that the database automatically increments for each inserted row. Then you could select ranges of this column values.It's not clear from your description whether you know in advance that you want a certain range of rows that were inserted, or exactly what. If yo

Re: embedded derby -- does it leak

2006-02-15 Thread Craig L Russell
I'll reiterate my understanding, repeating David's assertion that I'm not speaking for Sun officially.There is no intent by Sun to maintain a separate code line for any reason including patches or new functionality that is not available to the community. We're *not* forking the code base.Translatin

Re: SecurityManager question

2006-02-08 Thread Craig L Russell
Hi Rick, What does the security policy file say with regard to the jar file? That is, what permissions are granted to the code base defined by the jar? As I recall, there are various permissions needed to be granted to the Derby code base (regardless of whether it's autoloaded or loaded

Re: OutOfMemoryErrors when testing Derby with DOTS

2006-02-01 Thread Craig L Russell
On Feb 1, 2006, at 8:06 AM, John Embretsen wrote: Craig L Russell wrote: If this test code is representative of the actual application, then the application is in trouble and should be reimplemented in the jdbc area. It is a very well-understood requirement of well- behaved

Re: OutOfMemoryErrors when testing Derby with DOTS

2006-01-31 Thread Craig L Russell
Hi Dan, On Jan 31, 2006, at 12:04 PM, Daniel John Debrunner wrote: Daniel John Debrunner wrote: There's no guessing, if the application has a reference to an open JDBC object then it is still using it. If it no longer has a reference to a open JDBC open then it is no longer using it and

Re: Finding length of a result set

2006-01-31 Thread Craig L Russell
Hi John, This is a common "problem" for which there is no good, satisfying solution. If you want an exact answer, you have to run the query to count the results. So it's no surprise to me that running COUNT() with the query takes as long as running the query that returns the results you

Re: OutOfMemoryErrors when testing Derby with DOTS

2006-01-31 Thread Craig L Russell
Hi John, On Jan 31, 2006, at 9:14 AM, John Embretsen wrote: Tuesday, January 31, 2006, 3:03:38 AM CET, Craig L Russell wrote: Hi John, On Jan 30, 2006, at 12:11 PM, John Embretsen wrote: [snip old quotes] Any reason why itemID is bound to the preparedStatement and not itself passed as

Re: OutOfMemoryErrors when testing Derby with DOTS

2006-01-30 Thread Craig L Russell
Hi John, On Jan 30, 2006, at 12:11 PM, John Embretsen wrote: Monday, January 30, 2006, 7:46:42 PM, Craig L Russell wrote: Hi, On Jan 27, 2006, at 4:11 PM, Ramandeep Kaur wrote: Hi, As per Stan's mail about prepared statements, I checked the source code for DOTS test case that Joh

Re: OutOfMemoryErrors when testing Derby with DOTS

2006-01-30 Thread Craig L Russell
Hi,On Jan 27, 2006, at 4:11 PM, Ramandeep Kaur wrote:Hi,   As per Stan's mail about prepared statements, I checked the source code for DOTS test case that John ran (ATCJ2.java) to see if prepared statements are getting closed properly. I found that there are few methods in ATCJ2.java where prepared

Re: Removing Derby tagline

2006-01-25 Thread Craig L Russell
Seems non-controversial. Unlike the "Pure Java Database". :-(+1 to remove the tag line pending Sun's decision.CraigOn Jan 25, 2006, at 3:41 PM, Manjula Kutty wrote:yes..I also agree to remove the tagline   --Manjula  On 1/25/06, David W. Van Couvering <[EMAIL PROTECTED]> wrote: We are trying to fin

Re: The text that goes with the Derby logo (Was: Derby logo on the web site)

2006-01-17 Thread Craig L Russell
Hi,I have no issues with the proposed banner.http://issues.apache.org/jira/secure/attachment/12321532/masthead_derby2.pngCraigOn Jan 17, 2006, at 6:31 PM, Samer Kanjo wrote:I liked the positioning of the original tagline. The new tagline seems tofar away from "Apache Derby".-Original Message---

Re: running ij from the command line

2006-01-12 Thread Craig L Russell
Hi,I think your problem is in the command linejava -cp derby.jar;derbytools.jarThe semicolon terminates the java command, and it's treated by the command line interpreter as java -cp derby.jarderbytools.jar...Isn't this supposed to be:java -cp derby.jar:derbytools.jar...CraigOn Jan 12, 2006, at 12:

Re: Select records that are not locked?

2006-01-06 Thread Craig L Russell
On Jan 6, 2006, at 9:30 AM, Bryan Pendleton wrote:Danny wrote: What I was after was a way to build a list of transactions that are available to edit for a user.What I don’t want in the list is any transactions that are currently being edited by another user. I think you should implement this notion

Re: setObject(idx, bigDecimal, Types.NUMERIC); doesn't work ?

2006-01-05 Thread Craig L Russell
Hi,I asked Lance Anderson, spec lead for JDBC 4.0, about this issue and he replied that he thinks that due to compatibility with existing applications that rely on this behavior, it's unlikely to change.My opinion is that the behavior is surprising, and that most applications that discover that the

Re: Select records that are not locked?

2006-01-05 Thread Craig L Russell
Hi Danny,On Jan 5, 2006, at 11:14 AM, Danny wrote:Is there a way on a select statement to select all rows that match the whereclause criteria, except for any rows that are locked?I hope not. That's not the way I understand databases are supposed to work. The result of a query is not dependent on th

Re: Select for update, cursors

2005-12-28 Thread Craig L Russell
Hi Danny,In my experience, your proposed implementation strategy generally won't scale past a few users. The reason is that you will have locks held during user think time, which is to be avoided for scalable applications.Alternative things to consider:1. When the first user clicks on a transaction

Re: Incorporating the new derby logo into the web site

2005-12-22 Thread Craig L Russell
Hi Jean,On Dec 21, 2005, at 7:57 PM, Jean T. Anderson wrote:We voted for more than just the one version of the logo with the text. In any event, that specific logo is great for the Derby documentation, but it's too wide for web site display. The screen shot at http://issues.apache.org/jira/secure/a

  1   2   >