Re: Full Text Indexing

Hi Mag, Thanks for bringing up this issue. It certainly deserves an enhancement request. I'll log one later on today. Technically, you can build your own poor-man's solution to this problem today: 1) You can build your own inverted index (as a full-fledged table) on the text column you nee

platform support proposal

Hi Derby users, Sun will stop supporting jdk1.3 at the end of March, 2006 (see http://java.sun.com/j2se/1.3/index.jsp) and is encouraging customers to migrate their applications to supported platforms. Would anyone object if the next release of Derby (release 10.2) is the last release which r

Re: To take multiple connection from a database after starting the network server

Hi Sube, Is it possible that you have brought up two copies of the Network Server, listening on different ports? Connecting to the same database through two servers would cause the error you're seeing. Granular Derby locks (among other objects) aren't shared across servers. When the first ser

Re: Question about handling of string of length 0 in PreparedStatement.setString()

Hi Bryan, Nice to see you on the list. It may be that the database which would remain nameless is Oracle. Oracle treats 0-length strings as null. Note that Oracle documentation confesses that this is a bad idea and darkly hints that future versions of Oracle may conform to the standard practi

Re: How to start derby netserver within an application

Hi Kostas, The following change to your ant script might accomplish what you intend when you say you want to start Derby in another directory: classname="org.apache.derby.drda.NetworkServerControl" dir="db" classpath="${derby.classpath}">

Re: Does Derby support ALTER TABLE DROP COLUMN?

Hi Bryan, Derby supports adding but not dropping columns. An enhancement request (396) has been filed on this issue. Regards, -Rick Bryan Pendleton wrote: I tried alter table my_table drop column my_column; and I got: ERROR 42X01: Syntax error: Encountered "drop" at line 4, column 27

Re: Does Derby support ALTER TABLE DROP COLUMN?

Derby does have a RENAME TABLE command. Cheers, -Rick Michael J. Segel wrote: On Thursday 08 September 2005 20:09, [EMAIL PROTECTED] wrote: Hi Susan, Is there any other way we can drop columns which are not objects you mentioned ? or impossible ? thanks, Wolfgang You could always

Re: Variable Length Parameter Lists

Hi Tony, The syntax is, unfortunately, rigid. What do you need to do? Do you want to avoid declaring each overload because your overloads are changing rapidly? Are you using Java 1.5 varargs? Thanks, -Rick Tony Seebregts wrote: Hi, Is there a way to specify variable length parameter lists

Re: Wish List addition

Hi Mag, This issue (bug 472) is certainly on my wishlist but since it's a modest sized feature, it won't get into the October release. We need someone to work on this feature and no-one has been donated to this effort yet. You're welcome to help out! Cheers, -Rick Mag Gam wrote: I would li

Re: derby performance and 'order by'

It might help to add another column to the index so that it covers both the restriction and the ordering information. And if we could add a primary key to a temporary table, then something like the following might take us in the right direction: create index time_index on orders( time, orderID

Re: derby performance and 'order by'

zer can't plausibly learn. o The current Derby optimizer is capable of considering only a very limited subset of the useful plans. Cheers, -Rick [EMAIL PROTECTED] wrote: Rick Hillegas wrote: It might help to add another column to the index so that it covers both the restriction a

Re: Can you use createFrom to create a database from a backup database stored in a JAR file?

Hi Michael, I'm not sure I understand the problem you're wrestling with. Forgive me if I have garbled your message. It sounds as though you want to be able to create an empty database from a template database. This is pretty easy to do with Derby: 1) Nest another jar file inside your applica

Re: derby performance and 'order by'

Thanks for the pointer to this presentation, Oyvind. It's a pretty startling observation though I'm not sure how to use it. I'd be interested in hearing your thoughts about this some time. Cheers, -Rick That reminds me of a very entertaining presentation which was held at VLDB this year:

Re: JDBC and WHERE IN clauses

Hi Tony, You could try using a temporary table to hold your parameter values. By changing the contents of the temporary table you might achieve what you want. Something like the following: declare global temporary table session.ztemp ( param int ) not logged; select * from names where id in

Re: Wish List addition

anks...I am not that good of a programming to start working on this...if I had some good leadership, I can work on it. maybe, you can be my mentor.... On 9/20/05, *Rick Hillegas* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Hi Mag, This issue (bug 472) is ce

Re: Equivalent of SQL "DROP TABLE IF EXISTS MY_TABLE" ?

Hi Wolfgang, Building on Bernt's suggestion, you can wrap the java bits in a table-dropping procedure. That takes you a step closer to what you want since you can then invoke the procedure from a sql script. Something like the following: In some public class on the classpath: publics

Re: Tests in SQL

Hi Nicolas, I don't know if anyone got back to you on this one. You can always create your own function to do this. The java code would look something like this: publicstaticStringdayOfWeek( java.sql.Date date ) throws Exception { GregorianCalendarcalendar

Re: How to suppress line "Connection number: NNN." in Network Server output

Hi Bryan, I don't see any user-visible knob which you can turn to throttle these diagnostics. The message handle encodes the fact that this diagnostic is an Informational message but I don't see a knob which lets the customer choke Informational chatter. Sorry. Regards, -Rick Bryan Pendleto

Re: How to rename column

Hi Chas, Derby doesn't support this feature today. This has been logged as enhancement request 396. Regards, -Rick Chas douglass wrote: Does Derby support a rename column version of ALTER? Random experimentation has failed to reveal it to me. Chas Douglass

Re: Full Text Indexing

I have moved the discussion about Full Text Indexing onto a wiki page: http://wiki.apache.org/db-derby/LuceneIntegration Right now this page lists some features and use cases which we might want this integration to support. Please feel free to add your own feature requests and use cases. Afte

Re: performance issue : indexes not taken into account on unions

Hi Frederic, This looks like a bug. I have logged bug 649 to track this issue. Thanks for the detailed test case. Regards, -Rick Frederic MOREAU wrote: Hello, The optimizer does not take my indexes into account when I do a select on a 'UNION ALL' type of view ; therefore, table scans are

Re: Storing Java Objects in a table

Hi Islay, It is true that old versions of Cloudscape let you declare a column to be a Serializable type. This functionality was removed from Derby because the syntax was non-standard. Most of the machinery to support this useful feature, however, still exists. I have logged enhancement reques

Re: Unique constraints on multiple fields with one nullable

Hi Dan, I believe that the Sybase behavior is correct. I have logged bug 653 to track this issue. Regards, -Rick Dan Meany wrote: I noticed that in Derby a unique constraint on two columns A and B, with B nullable, will prevent inserting two identical records that contain NULL in B. This i

Re: Unique constraints on multiple fields with one nullable

Thanks, Michael. You are correct, Derby, like DB2, finesses this issue by not allowing nullable columns in unique constraints. I have closed this bug. Cheers, -Rick Michael J. Segel wrote: On Wednesday 26 October 2005 19:22, Rick Hillegas wrote: Sorry to top post... Sigh. Seems that some

Netiquette

Recently, some provocative postings have appeared on this list. Probably the poster's colorful language was meant to sound playful and bantering. Unfortunately, it has offended some people. This would be a good time to remind everyone that the Derby community prides itself on being open, constr

Re: Invalid SQL State

Hi Chas, Derby raises an exception with the text "Invalid transaction state". However, that message has a different sql state (x0x03) than the one you're seeing. Here's the blurb from the Derby code describing what makes Derby raise this exception: // find if there are any held cursor

paging Øyvind and Naka

Hi Øyvind and Naka, I think you both may be working on fixing the same problem: the broken regression tests. The tests were broken by the fix to bug 330 and now Naka has filed bug 663 against the test problems. You might want to coordinate your efforts here. Regards, -Rick

Re: paging Øyvind and Naka

Thanks, Øyvind. Cheers, -Rick [EMAIL PROTECTED] wrote: Rick Hillegas wrote: Hi Øyvind and Naka, I think you both may be working on fixing the same problem: the broken regression tests. The tests were broken by the fix to bug 330 and now Naka has filed bug 663 against the test problems

Re: functions and list

Hi Nicolas, In old releases of Cloudscape, customers were able to create their own aggregates. This functionality was removed from Derby probably because the syntax was considered non-standard. Most of the machinery for this feature is still in the code and it should be easy to re-enable once

Re: Language based ordering is possible in Derby

Dan's workaround is very useful and Øyvind's suggestion is interesting also. It's worth pointing out that the need for these workarounds should decrease after we fix bug 533 (the re-enabling of the natonal character datatypes). I hope to get to that bug in 10.2. The national character datatypes

Re: Language based ordering is possible in Derby

I did log an enhancement request but I'm not working on it right now. Regards, -Rick Satheesh Bandaram wrote: Derby doesn't allow creating functional indexes Rick started a discussion about how to provide that functionality about 6 months ago. I thought an agreement was reached in the comm

Re: Drop column/change default.

Hi Edson, Enhancement request 396 tracks this issue and Scott MacDonald is working on it. For current capabilities, see the ALTER TABLE section of the Reference Manual. In a nutshell, you can't drop a column. Cheers, -Rick [EMAIL PROTECTED] wrote: I have found no way to drop a column from

Re: [JDO] bit/boolean in apache derby

I hope to pick up enhancement 499 as part of my 10.2 work. Regards, -Rick Satheesh Bandaram wrote: Derby doesn't support Boolean data type, much like Oracle or DB2. There is a New Feature request already logged: http://issues.apache.org/jira/browse/DERBY-499 I would consider using char(1) o

Re: [Derby 10.1] SELECT ... raises "An ON clause associated with a JOIN operator is not valid"

Hi Erik, I am not sure I understand your query. However, it looks to me as though it is trying to inner join DATACOLLECTION_ELEMENT to the previous left join result. The compiler is objecting that THIS.ID is not a column in either DATACOLLECTION_ELEMENT or the previous left join. THIS is the

Re: Fwd: COUNT queries

Hi Craig, I hope I am answering the correct question here. The behavior of aggregates is described in Part 2 of the ANSI spec, section 10.9. 1) A null column is excluded from a COUNT( colName ) aggregate. This is described in the section 10.9 under General Rules 4a. The database is supposed

Re: Concurrency in connections and Threads

Hi Arieh, I haven't run any experiments but I would expect that you would have to be careful about how you commit this work. If one thread commits the connection while another thread is in the middle of a statement, someone is likely to be disappointed. You will likely have deadlock issues i

Re: Fwd: COUNT queries

Hi Lars, count(*) iterates through the rows. I don't think it's any faster than count( colName ). -Rick Lars Clausen wrote: On Thu, 2005-11-10 at 04:41, Jeffrey Lichtman wrote: 1) A null column is excluded from a COUNT( colName ) aggregate. This is described in the section 10.9 under Ge

Re: Poor query optimizer choices is making Derby unusable for large tables

Hi Kevin, You might also try using a temporary table to split your scan up into a series of optimzable queries. Regards-Rick declare global temporary table session.accumulator ( ObjectId int NOT NULL, WordLocation int NOT NULL ) not logged; insert into session.accumulator SELECT Object

where to put a file of constants shared by client and server

I'd like to factor out the DRDA constants into a single class which can be shared by the client and server. Where should I put a file like this? Perhaps java/drda/org/apache/derby/iapi/drda Thanks for your advice, -Rick

Re: Unable to create temporary table when using a readonly database

Hi Ian, This sounds like the wrong behavior to me, and you are welcome to file a bug. I realize that is cold comfort. Regards, -Rick Leslie Software wrote: I have created a read-only database (currently a directory structure but eventually it will be moved into a .jar). I setup the propert

Re: Recursive Select for Discussion Forum

Hi Michael, You could streamline your recursive walk by using a temporary table and a database procedure. The temporary table would hold the ids you recursively harvest. It would be populated by your database procedure, which would walk up the levels of your hierarchy. When the procedure retu

Re: Get-together at ApacheCon

+1 Bernt M. Johnsen wrote: David W. Van Couvering wrote (2005-12-06 11:11:12): Hi, all. Many of us will be at ApacheCon in San Diego next week. There is a Derby BoF from 9:30 - 10:30 on Tuesday night. I was thinking that perhaps those of us who are there could me

Re: Derby-SQL: Syntax Tree generator?

Hi Ashwin, I don't know whether anyone got back to you on this topic. I hope that this addresses your question. The DumpParseTree tracepoint causes Derby to print the ASTs to derby.log. You can set this tracepoint when Derby starts up. Here for instance is how you would do it if you were run

Re: Derby-SQL: Syntax Tree generator?

completely non-persistent mode like HSQL? I do not want persistence, just SQL operations on a few thousand rows in-memory (I know this should've been posted as a separate question, well..) It looks like Dag has sent you advice on this topic. Thanks, Ashwin. On Tue, 03 Jan 2006 Ri

derby bay area lunch

We're setting up a lunch for bay area folks who use or work on Derby. We're planning on Wednesday February 1 in San Francisco--details to follow later. Let me know if you're interested in attending. Regards, -Rick

SecurityManager question

I am tracking down a problem with autoloading jdbc drivers when running from jar files under the Derby test harness on jdk1.6. Capsule summary: SUCCESS-1 The drivers correctly autoload (from the information in the jar file) when I run my test program standalone (without a SecurityManager) SUC

Re: SecurityManager question

all a SecurityManager. Hi Dan, Would appreciate any advice which might occur to you given your extensive work with SecurityManagers. Thanks, -Rick Myrna van Lunteren wrote: I am wondering - if you run the test program standalone *with* a SecurityManager, what do you get? Myrna On 2/8/06,

upcoming 10.2 release

Dear Derby user community, Yesterday, the Derby developers started a discussion about the timing and contents of the next (10.2) release. A feature freeze date of April 7 was suggested although we have not settled on this date yet. I would estimate that the actual release would appear around t

Generating user docs

I am having trouble generating the postscript versions of most of our user docs. I can generate html and monohtml versions for all user guides. I can also generate postscript versions of the Reference and Tuning guides. However, I'm having trouble generating postscript versions of the other doc

Hard vs. Soft Upgrade

Soft Upgrade is a feature which I think was introduced after I left Cloudscape. Please bear with me as I try to understand how Soft and Hard Upgrade interact. In the old days, when there was only Hard Upgrade, Upgrade satisfied the following contract: o Transitive - You could upgrade data fr

pushing back release date for jdbc4-capable Derby

A while ago, I volunteered to manage a Derby release which will include a new feature that is important to me: an implementation of JDBC4. Based on the JDBC4 schedule then, I had hoped to post that release in June. However, because the JDBC4 schedule moved back, I must post my release later, mo

Re: Query and uppercases

Although this won't help anyone solve the immediate problem immediately, this issue would be addressed by DERBY-455 (expression indexes). Regards, -Rick Craig L Russell wrote: If you are concerned about performance, please note that there is a huge difference between these two statements:

Re: Javadoc lies

ssing something; hopefully it's not obvious. :-) Craig Thanks to everyone who responded to this thread. It doesn't seem that anyone has a solution to this problem. Does anyone have a preference for which lie we tell: (1b) or (2d)? Barring a preference here, the default would be (1b)

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

Dear Derby users, Please read this message if you work on an application server or in an application layer which cares about distributed transactions and/or pooled connections. Right now the inheritance graph for Derby's DataSources does not mirror the corresponding graph of interfaces in ja

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

Thanks for forwarding this, Kathey. Regards, -Rick Kathey Marsden wrote: Rick Hillegas wrote: Dear Derby users, 0Please read this message if you work on an application server or in an application layer which cares about distributed transactions and/or pooled connections. Right now the

10.2.0.1 snapshot posted

Hello users and developers, We have posted a new snapshot of the mainline, which we expect will evolve into the 10.2 release this fall. You may find the snapshot at http://db.apache.org/derby/derby_downloads.html#Snapshot+Jars. We would be grateful if you would test-drive this snapshot and pos

Re: 10.2.0.1 snapshot posted

e 10.1.2.1 (Nov 18, 2005 / SVN 330608) but later on in the same page it appears that 10.1.2.2 and 10.1.2.3 were released already. Thanks, Craig On May 26, 2006, at 2:50 PM, Rick Hillegas wrote: Hello users and developers, We have posted a new snapshot of the mainline, which we expect will

Re: 10.2.0.1 snapshot posted

6, at 2:50 PM, Rick Hillegas wrote: Hello users and developers, We have posted a new snapshot of the mainline, which we expect will evolve into the 10.2 release this fall. You may find the snapshot at http://db.apache.org/derby/derby_downloads.html#Snapshot+Jars. We would be grateful if you

Re: 10.2.0.1 snapshot posted

I have replaced this snapshot with a new cut: 10.2.0.2. The test machinery in the previous snapshot was broken. That machinery is fixed now and the new snapshot passes the Derby regression tests. Regards, -Rick Rick Hillegas wrote: Hello users and developers, We have posted a new snapshot

10.2.0.3 snapshot published

I have updated the 10.2 snapshot with a new version, 10.2.0.3, available at http://db.apache.org/derby/derby_downloads.html#Snapshot+Jars. This version fixes a couple issues: 1) Messages should print out in the correct language now because localized message files are wired into the classpath s

updating copyrights in user guides

I'm going to make some copy-editting fixes to the user guides. While I'm in there, I'd like to update the copyright notices. I'm proposing to change the following line: "Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable." to "Copyright 1997, 2006 The Apache

Re: updating copyrights in user guides

Thanks, Jean. This sounds like it's still in flux and will require some sort of rototill of all the documentation source files. I'll hold off on changing the copyright until this settles down. Regards, -Rick Jean T. Anderson wrote: Rick Hillegas wrote: I'm going to

Re: Alter table ... modify column

This feature (DERBY-396) is currently unassigned. Someone could still make good progress on this feature in the time remaining for the 10.2 release, and the community would be delighted to give advice. :) Regards, -Rick Regards, -Rick Edson Carlos Ericksson Richter wrote: There is any news a

Re: Apache Derby (in the guise of Java DB) now shipping in Sun Java SE SDK

Hi Edson, By using the RENAME TABLE command, you can eliminate one of the data-copies mentioned in your workaround. Regards, -Rick Edson Carlos Ericksson Richter wrote: Unfortunately, for developers, TBDITW don't allow change column names, datatypes, nullability, etc... At least, no without

Self-configuring embedded Derby applications

Dear Derby users, I would like to understand if anyone thinks that they might be affected by the following issue. This issue affects customers who do the following: o Run an embedded Derby application which generates its own Derby properties on the fly. o In the same VM, run other JDBC appl

Re: Self-configuring embedded Derby applications

t dynamic from osgi and JBoss perspectives. Thanks Charlie Kelly P.S. What is a "Heisenbug"? Sorry for the jargon. It's a term which Jim Gray coined for bugs which arise from non-deterministic behavior and which can disappear when you instrument the application to look for the

Proposal for 10.2 release schedule

Last week, Sun Microsystems announced that it will bundle Derby with the next major release of the reference jdk, Java SE 6, also known as Mustang or jdk1.6. If you download the latest Mustang build, you will see that it contains our Derby 10.2.0.3 snapshot in the "db" directory parallel to "li

Re: Proposal for 10.2 release schedule

Hi Andrew, Like you I'm happy that Geir Magnusson is working the JCP issues and I'm optimistic that the time line, which had been twisted into a pretzel, can be straightened out. I'm not ready to propose an alternative--but I expect to know more soon. Something along the lines of your proposal

Re: Proposal for 10.2 release schedule

Hi Kathey, Right now, I'm planning to back out BOOLEAN before the branch. Regards, -Rick Kathey Marsden wrote: Rick Hillegas wrote: Hi Andrew, Like you I'm happy that Geir Magnusson is working the JCP issues and I'm optimistic that the time line, which had been twisted

Re: Status of adding BOOLEAN-type

elease of Derby before re-enabling BOOLEAN. My vote would be for (2c) but I don't sense enough enthusiasm for BOOLEAN to justify a major release in the near term. Regards, -Rick Kristian Waagan wrote: Rick Hillegas wrote: Hi Kathey, Right now, I'm planning to back out BOOLEAN befo

Wiki page for upcoming 10.2 release

Using Andrew's 10.1.3 wiki page as a template, I have created a first cut of a wiki page describing the upcoming 10.2 release (http://wiki.apache.org/db-derby/TenTwoRelease). Please feel free to improve this page. In particular, JIRA-pros may want to review whether the pointer to open 10.2 bugs

10.2.0.4 snapshot available

I have generated a new 10.2 snapshot, which rolls up improvements that accumulated over the last month. Please test-drive it. You can download the snapshot from http://db.apache.org/derby/derby_downloads.html#Snapshot+Jars. For more information, see the wiki page describing the snapshot: http:

Re: Java Data Types in Derby

Hi Jitendra, Jitendra Kharche wrote: Thanks Kristian. I checked. The column size is smaller than the data being inserted. I have two questions 1. Does Derby support java data types like cloudscape? I think you may be asking whether Derby, like Cloudscape, supports abstract data types, tha

Re: TRUE/FALSE SQL functionality

Hi Joel, There is a lot of interest in enabling the BOOLEAN datatype. Unfortunately, our first attempt at this foundered on network protocol and release-compatibility issues. At this time, we don't understand how to enable this datatype without issuing a major release of Derby (release 11).

j2me pieces

As part of building the beta, I will need the j2me pieces needed to trigger the building of the optional jsr169 support. Could someone email me the relevant classes.zip and jdbc.jar referred to by BUILDING.txt? Getting my hands on these files is proving to be a chore. I have downloaded what I t

10.2.1.0 beta candidate available for testing

Please test-drive the 10.2.1.0 beta candidate, available at http://people.apache.org/~rhillegas/10.2.1.0-beta/. I have updated the 10.2 release page to direct you to the beta candidate: http://wiki.apache.org/db-derby/TenTwoRelease. I have also updated the snapshot description page with more up

Re: Packaging the stored functions and procedures

Hi Robert, The Derby Developer's Guide explains how to load the database with jar files of user-written functions and procedures. Please see the following section of that guide: "Deploying Derby Applications" -> "Loading classes from a database" Hope this helps, -Rick Robert Enyedi wrote:

10.2.1.1 beta now available for testing

A new Derby beta candidate, 10.2.1.1, is now available for testing. This version fixes many bugs which surfaced in the previous version, including bugs affecting security, GRANT/REVOKE, and query performance. Please test-drive this better beta. It's available at http://people.apache.org/~rhille

10.2.1.2 beta now available

I have posted the latest Derby beta, 10.2.1.2, at http://people.apache.org/~rhillegas/10.2.1.1-beta/. You can reach the beta from the 10.2 wiki page (http://wiki.apache.org/db-derby/TenTwoRelease) and from the 10.2 snapshot description (http://wiki.apache.org/db-derby/TenTwoSnapshot). Over the

Re: ENUM

As a further refinement on this excellent approach, you can encapsulate the validator in a function. Something like this: CREATE TABLE standard ( sizes VARCHAR(32) CONSTRAINT sizes_ck CHECK ( sizeIsLegal( sizes ) ) ); For more information on how to wire Java methods into your DDL and queries,

10.2.1.3 beta candidate now available

I have rolled up this week's patches into a new beta candidate, 10.2.1.3. As usual, you can navigate to the beta in the following ways: 1) from the master 10.2 release page (http://wiki.apache.org/db-derby/TenTwoRelease) 2) from the snapshot discription page (http://wiki.apache.org/db-derby/Te

10.2 licensing issue

I must report today that the restrictions imposed by the beta JDK license have not been lifted. As you know, the JDK 6 beta license requires a disclaimer that bars the use of the code for any productive use. This restriction is meant to forestall binary incompatibilities with the final, GA ver

Re: 10.2 licensing issue

Andrew McIntyre wrote: On 9/11/06, Rick Hillegas <[EMAIL PROTECTED]> wrote: I can see two alternatives for us: 1. Ship 10.2 on the current schedule but do not include the JDBC4 drivers. When run on Java SE 6, Derby 10.2 would continue to expose our JDBC3 implementation. In additi

Re: 10.2 licensing issue...

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 : He said : "I must report today that the restrictions imposed by the beta JDK license have not been lifted. As you know, the JDK 6 b

Re: 10.2 licensing issue...

Geir Magnusson Jr wrote: Rick Hillegas wrote: 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 : He said : "I must report today that the restrictions imposed b

Re: 10.2 licensing issue...

al message -- From: Geir Magnusson Jr <[EMAIL PROTECTED]> Rick Hillegas wrote: 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 : He s

Re: 10.2 release delay

Hi Robert, I updated the wiki a few days ago because I noticed that the original dates were clearly stale--we had already slipped by a couple weeks. I pushed the projected dates out long enough to allow for a couple release candidates in case our first attempt flops. Discussion about release

[ANNOUNCE] Apache Derby 10.2.1.6 released

The Apache Derby project is pleased to announce a new feature release of Derby, 10.2.1.6. Apache Derby is a subproject of the Apache DB project. Derby is a pure Java relational database engine which conforms to the ANSI SQL and JDBC standards. Derby aims to be easy for developers and end-users to

Re: alter nullability with 10.2

Bob Durie wrote: Hi - the new derby claims support for altering the nullability of a column. Anyone know what the new alter table syntax is to do this? Hi Bob, The sytax is ALTER TABLE tableName ALTER COLUMN columnName NULL or ALTER TABLE tableName ALTER COLUMN columnName NOT NULL For deta

Re: Best choice for column's data type to represent boolean data

Hi Ian, Two issues block the introduction of a BOOLEAN datatype: 1) We need DRDA support in order to transport this type across our network layer. I am cautiously optimistic that we will see this type appear in the DRDA spec early in 2007. So, soon, this issue will not block us. 2) DERBY-88

Re: unique columns must be nullable ?

DERBY-653 may be relevant to this issue. Regards, -Rick Bernt M. Johnsen wrote: 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 co

[ANNOUNCE] Apache Derby 10.2.2.0 released

The Apache Derby project is pleased to announce a new bug-fix release of Derby, 10.2.2.0. Apache Derby is a subproject of the Apache DB project. Derby is a pure Java relational database engine which conforms to the ANSI SQL and JDBC standards. Derby aims to be easy for developers and end-users to

Re: is there any support/plan to support boolean type in derby?

Kristian Waagan wrote: legolas wrote: Hi Thank you for reading my post. is there any support/plan to booean in derby? Hello Legolas, This topic has been raised earlier, and an effort was made to add the boolean data type to Derby. However, this effort stranded because of lacking support in

Re: Some design related questions about using derby embedded mode.

legolas wood wrote: Hi Thank you for reading my post. We have planned to use Derby embedded for our application internal data storage. Here I have some questions which any answers could be helpful about them. - We need highest performance, Should we use stored procedure? Hi Legolas, In t

Re: is there any support/plan to support boolean type in derby?

Army wrote: Rick Hillegas wrote: The next rev of the DRDA spec will define a boolean data type. I'm expecting to see that rev published in the next couple months. Any idea if it will define an XML data type, as well? Army Hi Army, Yes, the XML datatype will appear in the upcoming r

Re: Complete Derby/JDBC Stored Proc Example ?

Hi Joe, The information you need can be found in the following sections of the Derby Developer's Guide: o "Loading classes from a database" o "Derby server-side programming" In addition, the Scores demo, in the codeline, shows you how to declare and invoke Java methods as functions and proc

derby training

Does anyone know of a company which supplies training on Derby? There's a book on Derby written by the IBM folks (Off to the Races). Does anyone know of other training materials (other than what appears on the Derby website)? Thanks, -Rick

Re: derby training

Thanks, Charlie. Do you have a website I could check out? Regards, -Rick Charlie Kelly wrote: Hi Rick, We've integrated Derby into J2EE and Eclipse rich client applications. We provide training, architecture, and implementation. Charlie Kelly Rick Hillegas wrote: Does anyone know

Re: Security in Derby

Hi Alexander, In terms of using a Java Security Manager, there will be better out-of-the-box support for a secure network server in the next feature release (10.3). That work is tracked by https://issues.apache.org/jira/browse/DERBY-2196. Right now, you can grab a generic policy file from the

Re: Security in Derby

to - which isn't always the most user friendly. > > - Alex > > On 2/20/07, Rick Hillegas <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > >> >> Hi Alexander, >> >> In terms of using a Java S

  1   2   3   4   5   6   7   8   9   10   >