From derbyatkinsonsusan@example.org Sat Oct 01 01:35:46 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 30124 invoked from network); 1 Oct 2005 01:35:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Oct 2005 01:35:43 -0000 Received: (qmail 84787 invoked by uid 500); 1 Oct 2005 01:35:42 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 84765 invoked by uid 500); 1 Oct 2005 01:35:41 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 84754 invoked by uid 99); 1 Oct 2005 01:35:41 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Sep 2005 18:35:41 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO e5.ny.us.ibm.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Sep 2005 18:35:46 -0700 Received: from d01relay02.pok.ibm.com (d01relay02.pok.ibm.com [83.161.120.155]) by e5.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id j911ZD4u032541 for <atkinsonsusan@example.org>; Fri, 30 Sep 2005 21:35:13 -0400 Received: from d01av04.pok.ibm.com (d01av04.pok.ibm.com [83.161.120.155]) by d01relay02.pok.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j911ZDZQ098844 for <atkinsonsusan@example.org>; Fri, 30 Sep 2005 21:35:13 -0400 Received: from d01av04.pok.ibm.com (loopback [83.161.120.155]) by d01av04.pok.ibm.com (8.12.11/8.13.3) with ESMTP id j911Z2lN002256 for <atkinsonsusan@example.org>; Fri, 30 Sep 2005 21:35:02 -0400 Received: from [83.161.120.155] (svl-arbrown.svl.ibm.com [83.161.120.155]) by d01av04.pok.ibm.com (8.12.11/8.12.11) with ESMTP id j911Z0g4001985 for <atkinsonsusan@example.org>; Fri, 30 Sep 2005 21:35:02 -0400 Message-ID: <atkinsonsusan@example.org> Date: Fri, 30 Sep 2005 18:34:48 -0700 From: Army <atkinsonsusan@example.org> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion <atkinsonsusan@example.org> Subject: Re: ODBC driver and JDBC Escape functions References: <atkinsonsusan@example.org> In-Reply-To: <atkinsonsusan@example.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Nicolas Dufour wrote: > Hi > > I access to my derby database thru a DB2 ODBC driver and I have seen > that the JDBC Escape functions are not working, of course, in particular > the one called TIMESTAMPDIFF. Then How can I compute this difference > between two dates from ODBC with my derby database ?? > Hi Nicolas, First things first: can you be more specific about what error you're seeing, just so we can make sure we're on the same page? The TIMESTAMPDIFF function is a relatively new addition to Derby and thus the DB2 ODBC driver doesn't yet reflect the fact that Derby supports it. Until a corresponding change can be made to the ODBC driver, you'll probably have to find another way to compute the difference between two dates. As one alternative, if your environment supports Java you could create a Java stored procedure that does the date-diff operation and then call that procedure from ODBC. The procedure could either use Java classes/methods to do the diff, or it could get the current connection and then call the JDBC escaped TIMESTAMPDIFF function. For example, if you want the diff in days then you could do something like: public static int tsDiffDays (Timestamp ts1, Timestamp ts2) throws SQLException { Connection conn = DriverManager.getConnection( "jdbc:default:connection"); PreparedStatement pSt = conn.prepareStatement( "values { fn timestampdiff (SQL_TSI_DAY, ?, ?) }"); pSt.setTimestamp(1, ts1); pSt.setTimestamp(2, ts2); ResultSet rs = pSt.executeQuery(); rs.next(); return rs.getInt(1); } (Of course, you'd have to add better error-checking than I what I've shown here ;) After that, you can create a function like the following: create function tsdiff (tsone timestamp, tstwo timestamp) returns int language java parameter style java external name 'MyDateFunctions.tsDiffDays'; Then, from your ODBC program, instead of trying to call the timestamp escape function, you'd just use "values tsdiff (current_timestamp, timestamp('...'))". I realize it's a bit of a hassle, but that might allow you to do what you want even though the ODBC escape function isn't working... Hope that helps, but let me know if you have any other questions, Army From derbyatkinsonsusan@example.org Sun Oct 02 13:21:30 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 69472 invoked from network); 2 Oct 2005 13:21:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Oct 2005 13:21:30 -0000 Received: (qmail 94950 invoked by uid 500); 2 Oct 2005 13:21:29 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 94619 invoked by uid 500); 2 Oct 2005 13:21:28 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 94608 invoked by uid 99); 2 Oct 2005 13:21:28 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Oct 2005 06:21:28 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO sccrmhc11.comcast.net) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Oct 2005 06:21:32 -0700 Received: from [83.161.120.155] (pcp0011932243pcs.summit01.nj.comcast.net[83.161.120.155]) by comcast.net (sccrmhc11) with ESMTP id <2005100213210401100rdj9ee>; Sun, 2 Oct 2005 13:21:04 +0000 Message-ID: <atkinsonsusan@example.org> Date: Sun, 02 Oct 2005 09:20:58 -0400 From: Nicolas Dufour <atkinsonsusan@example.org> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion <atkinsonsusan@example.org> Subject: Re: ODBC driver and JDBC Escape functions References: <atkinsonsusan@example.org> <atkinsonsusan@example.org> In-Reply-To: <atkinsonsusan@example.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Thank you very much ! It helps a lot and open me a lot of possibilities with this database, specially by adding java procedures. Nicolas Army wrote: > Nicolas Dufour wrote: > >> Hi >> >> I access to my derby database thru a DB2 ODBC driver and I have seen >> that the JDBC Escape functions are not working, of course, in particular >> the one called TIMESTAMPDIFF. Then How can I compute this difference >> between two dates from ODBC with my derby database ?? >> > > Hi Nicolas, > > First things first: can you be more specific about what error you're > seeing, just so we can make sure we're on the same page? > > The TIMESTAMPDIFF function is a relatively new addition to Derby and > thus the DB2 ODBC driver doesn't yet reflect the fact that Derby > supports it. Until a corresponding change can be made to the ODBC > driver, you'll probably have to find another way to compute the > difference between two dates. > > As one alternative, if your environment supports Java you could create > a Java stored procedure that does the date-diff operation and then > call that procedure from ODBC. The procedure could either use Java > classes/methods to do the diff, or it could get the current connection > and then call the JDBC escaped TIMESTAMPDIFF function. For example, > if you want the diff in days then you could do something like: > > public static int tsDiffDays (Timestamp ts1, Timestamp ts2) > throws SQLException > { > Connection conn = DriverManager.getConnection( > "jdbc:default:connection"); > > PreparedStatement pSt = conn.prepareStatement( > "values { fn timestampdiff (SQL_TSI_DAY, ?, ?) }"); > > pSt.setTimestamp(1, ts1); > pSt.setTimestamp(2, ts2); > > ResultSet rs = pSt.executeQuery(); > rs.next(); > return rs.getInt(1); > > } > > (Of course, you'd have to add better error-checking than I what I've > shown here ;) After that, you can create a function like the following: > > create function tsdiff (tsone timestamp, tstwo timestamp) returns int > language java parameter style java external name > 'MyDateFunctions.tsDiffDays'; > > Then, from your ODBC program, instead of trying to call the timestamp > escape function, you'd just use "values tsdiff (current_timestamp, > timestamp('...'))". > > I realize it's a bit of a hassle, but that might allow you to do what > you want even though the ODBC escape function isn't working... > > Hope that helps, but let me know if you have any other questions, > Army > > > From derbyatkinsonsusan@example.org Sun Oct 02 22:51:33 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 8220 invoked from network); 2 Oct 2005 22:51:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 2 Oct 2005 22:51:32 -0000 Received: (qmail 94399 invoked by uid 500); 2 Oct 2005 22:51:31 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 94372 invoked by uid 500); 2 Oct 2005 22:51:31 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 94360 invoked by uid 99); 2 Oct 2005 22:51:31 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Oct 2005 15:51:31 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO rwcrmhc11.comcast.net) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Oct 2005 15:51:34 -0700 Received: from [83.161.120.155] (pcp0011932243pcs.summit01.nj.comcast.net[83.161.120.155]) by comcast.net (rwcrmhc11) with ESMTP id <20051002225104013003q467e>; Sun, 2 Oct 2005 22:51:05 +0000 Message-ID: <atkinsonsusan@example.org> Date: Sun, 02 Oct 2005 18:50:54 -0400 From: Nicolas Dufour <atkinsonsusan@example.org> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion <atkinsonsusan@example.org> Subject: Argg stored procedures ! Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Still working on my porting an SQL Server database to a derby one, I have some questions for you. Before, thanks to Army for the function creation. I have read the IBM forum about derby stored procedure and I have created one which works prefectly in ij but i cant call the procedure from an ODBC link !? I just put : CALL ALTTIME2(1) And the link said : wrong syntax ! Like it doesnt understand everuthing including the word 'CALL' ! Ok .. thanks odbc .. it helps a lot... if you have any idea about this one. Another question about stored procedure : I want to create a stored procedure which the goal will be to do a select with a 'where in ' and a list of integer. This list of integer should be the parameter of my stored procedure, but how can i do that ? or perhaps its not the right way to do it ? Thank you a lot Nicolas From derbyatkinsonsusan@example.org Mon Oct 03 16:00:45 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 52517 invoked from network); 3 Oct 2005 16:00:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 16:00:44 -0000 Received: (qmail 61808 invoked by uid 500); 3 Oct 2005 16:00:43 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 61647 invoked by uid 500); 3 Oct 2005 16:00:42 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 61636 invoked by uid 99); 3 Oct 2005 16:00:42 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 09:00:42 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO brmea-mail-4.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 09:00:45 -0700 Received: from phys-d3-ha21sca-2 ([83.161.120.155]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id j93FxfvH002107 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 10:00:19 -0600 (MDT) Received: from conversion-daemon.ha21sca-mail1.sfbay.sun.com by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <atkinsonsusan@example.org> (original mail from atkinsonsusan@example.org) for atkinsonsusan@example.org; Mon, 03 Oct 2005 09:00:04 -0700 (PDT) Received: from [83.161.120.155] (vpn-129-150-29-96.SFBay.Sun.COM [83.161.120.155]) by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <atkinsonsusan@example.org> for atkinsonsusan@example.org; Mon, 03 Oct 2005 09:00:04 -0700 (PDT) Date: Mon, 03 Oct 2005 08:59:49 -0700 From: Rick Hillegas <atkinsonsusan@example.org> Subject: Re: Wish List addition In-reply-to: <atkinsonsusan@example.org> To: Derby Discussion <atkinsonsusan@example.org> Message-id: <atkinsonsusan@example.org> MIME-version: 1.0 Content-type: text/plain; charset=UTF-8; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) References: <atkinsonsusan@example.org> <atkinsonsusan@example.org> <atkinsonsusan@example.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Mag, Sorry to get back to you a week late. I've been on the road. I would be happy to give you advice on how to wire Lucene support into Derby. I think the first step would be to ask Dan what he's up to. I got the impression that Dan was building some piece of the Lucene support. Once we understand what Dan's doing then we can figure out how you can contribute. Depending on how Dan's approaching this, there may be some work left to do in the language layer. I can give you advice on how to navigate that body of code. Cheers, -Rick Mag Gam wrote: > Rick: > > thanks...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* <atkinsonsusan@example.org > <mailto:atkinsonsusan@example.org>> wrote: > > Hi Mag, > > This issue (bug 472) is certainly on my wishlist but since it's a > modest > sized featue yo 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 like to add 'full text indexing' as a wishlist item. > There has > > been some good tutorials with Lucene, but I prefer an integrated > > solution. Does anyone have some schema or triggers to get this done? > > > > > > From derbyatkinsonsusan@example.org Mon Oct 03 16:10:03 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 55898 invoked from network); 3 Oct 2005 16:10:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 16:10:03 -0000 Received: (qmail 70912 invoked by uid 500); 3 Oct 2005 16:10:01 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 70889 invoked by uid 500); 3 Oct 2005 16:10:01 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 70878 invoked by uid 99); 3 Oct 2005 16:10:01 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 09:10:01 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO e32.co.us.ibm.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 09:10:05 -0700 Received: from westrelay02.boulder.ibm.com (westrelay02.boulder.ibm.com [83.161.120.155]) by e32.co.us.ibm.com (8.12.11/8.12.11) with ESMTP id j93G8kVO014308 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 12:08:46 -0400 Received: from d03av02.boulder.ibm.com (d03av02.boulder.ibm.com [83.161.120.155]) by westrelay02.boulder.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j93G9ctP530222 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 10:09:38 -0600 Received: from d03av02.boulder.ibm.com (loopback [83.161.120.155]) by d03av02.boulder.ibm.com (8.12.11/8.13.3) with ESMTP id j93G9cDK028234 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 10:09:38 -0600 Received: from [83.161.120.155] (dyn9030040118.svl.ibm.com [83.161.120.155]) by d03av02.boulder.ibm.com (8.12.11/8.12.11) with ESMTP id j93G9ZuK028015 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 10:09:37 -0600 Message-ID: <atkinsonsusan@example.org> Date: Mon, 03 Oct 2005 09:09:35 -0700 From: Army <atkinsonsusan@example.org> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion <atkinsonsusan@example.org> Subject: Re: Argg stored procedures ! References: <atkinsonsusan@example.org> In-Reply-To: <atkinsonsusan@example.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Nicolas Dufour wrote: > I have read the IBM forum about derby stored procedure and I have > created one which works prefectly in ij but i cant call the procedure > from an ODBC link !? I just put : > CALL ALTTIME2(1) > > And the link said : wrong syntax ! > Like it doesnt understand everuthing including the word 'CALL' ! What's the specific error that you're getting--can you include that in your email? Also, what version of the ODBC driver are you using? I created a stored procedure in ij and then made the same call you mentioned above ("CALL ALTTIME2(1)") from an ODBC program and it seems to have worked for me. I also tried a different syntax: { CALL ALTTIME2 (1) } And that worked, as well. I'm not sure what I'm doing differently from you, but if you're able to tell us 1) the exact line you use to make the ODBC call, 2) the exact error message that you're seeing, and 3) what version of the driver you're using, hopefully we can figure out where the problem is... Thanks, Army From derbyatkinsonsusan@example.org Mon Oct 03 16:17:15 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 58879 invoked from network); 3 Oct 2005 16:17:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 16:17:14 -0000 Received: (qmail 88749 invoked by uid 500); 3 Oct 2005 16:17:10 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 88674 invoked by uid 500); 3 Oct 2005 16:17:09 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 88652 invoked by uid 99); 3 Oct 2005 16:17:09 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 09:17:08 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO brmea-mail-3.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 09:17:12 -0700 Received: from phys-gadget-1 ([83.161.120.155]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id j93GGj1N016627 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 10:16:46 -0600 (MDT) Received: from conversion-daemon.gadget-mail1.uk.sun.com by gadget-mail1.uk.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <atkinsonsusan@example.org> (original mail from atkinsonsusan@example.org) for atkinsonsusan@example.org; Mon, 03 Oct 2005 17:16:46 +0100 (BST) Received: from [83.161.120.155] (dhcp-gnb07-211-251.France.Sun.COM [83.161.120.155]) by gadget-mail1.uk.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <atkinsonsusan@example.org> for atkinsonsusan@example.org; Mon, 03 Oct 2005 17:16:46 +0100 (BST) Date: Mon, 03 Oct 2005 18:17:21 +0200 From: Xavier Vigouroux <atkinsonsusan@example.org> Subject: transient priviledgeException To: Derby Discussion <atkinsonsusan@example.org> Message-id: <atkinsonsusan@example.org> MIME-version: 1.0 (Apple Message framework v623) X-Mailer: Apple Mail (2.623) Content-type: text/plain; charset=US-ASCII; format=flowed Content-transfer-encoding: 7BIT X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, I have a transient priviledgeException when connection to the DB with ij. here is the scenario: 1/ I start an embeddedServer 2/ wait for the ping() be ok (tested in the JVM creating the server) 3/ start ij to create a schema. then in 4, I get a transient error...i.e if I retry it works. what should I wait for to be sure the server is ready to recieve cmd? -- Xavier VIGOUROUX - sun microsystems From derbyatkinsonsusan@example.org Mon Oct 03 16:40:59 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 72584 invoked from network); 3 Oct 2005 16:40:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 16:40:59 -0000 Received: (qmail 29508 invoked by uid 500); 3 Oct 2005 16:40:57 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 29439 invoked by uid 500); 3 Oct 2005 16:40:57 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 29428 invoked by uid 99); 3 Oct 2005 16:40:57 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 09:40:57 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO brmea-mail-4.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 09:41:01 -0700 Received: from phys-d3-ha21sca-2 ([83.161.120.155]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id j93GeYvD010923 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 10:40:35 -0600 (MDT) Received: from conversion-daemon.ha21sca-mail1.sfbay.sun.com by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <atkinsonsusan@example.org> (original mail from atkinsonsusan@example.org) for atkinsonsusan@example.org; Mon, 03 Oct 2005 09:40:53 -0700 (PDT) Received: from [83.161.120.155] (vpn-129-150-29-96.SFBay.Sun.COM [83.161.120.155]) by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <atkinsonsusan@example.org> for atkinsonsusan@example.org; Mon, 03 Oct 2005 09:40:52 -0700 (PDT) Date: Mon, 03 Oct 2005 09:40:38 -0700 From: Rick Hillegas <atkinsonsusan@example.org> Subject: Re: Equivalent of SQL "DROP TABLE IF EXISTS MY_TABLE" ? In-reply-to: <atkinsonsusan@example.org> To: Derby Discussion <atkinsonsusan@example.org> Message-id: <atkinsonsusan@example.org> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) References: <atkinsonsusan@example.org> <atkinsonsusan@example.org> <atkinsonsusan@example.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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: public static void dropTable( String schema, String table ) { try { Connection conn = DriverManager.getConnection( "jdbc:default:connection"); PreparedStatement ps = conn.prepareStatement ( "drop table " + schema + "." + table ); ps.execute(); ps.close(); } catch (SQLException e) {} } Then the following script works: create procedure DROP_TABLE ( schemaName varchar( 128 ), tableName varchar( 128 ) ) parameter style java modifies sql data language java external name 'z.dropTable' ; call DROP_TABLE( 'app', 'foo' ); create table app.foo( keyCol int primary key ); Cheers, -Rick Bernt M. Johnsen wrote: >>>>>>>>>>>>>Bernt M. Johnsen wrote (2005-09-26 12:09:26): >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>>>atkinsonsusan@example.org wrote (2005-09-26 18:11:26): >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>Hi there, >>> >>>To initialize my database, I want to use an SQL >>>equivalent of "DROP TABLE IF EXISTS MY_TABLE" . >>> >>>I've tried it but of course didn't work >>> >>>Does Derby support this kinda SQL or Is there any workaround >>>I can drop a table if it exists ?? >>> >>> >>One way could be: >> try { >> stmt.executeUpdate("DROP TABLE MY_TABLE"); >> } catch (SQL_Exception e) { >> if (!e.getSQLState().equals("proper SQL-state for table does not exist")) >> >> > >In Derby it is: > if (!e.getSQLState().equals("42Y55")) > > > From derbyatkinsonsusan@example.org Mon Oct 03 19:40:43 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 52349 invoked from network); 3 Oct 2005 19:40:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 19:40:43 -0000 Received: (qmail 10605 invoked by uid 500); 3 Oct 2005 19:40:42 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 10268 invoked by uid 500); 3 Oct 2005 19:40:41 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 10257 invoked by uid 99); 3 Oct 2005 19:40:41 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 12:40:41 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO brmea-mail-4.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 12:40:45 -0700 Received: from phys-d3-ha21sca-2 ([83.161.120.155]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id j93JeIvD006329 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 13:40:18 -0600 (MDT) Received: from conversion-daemon.ha21sca-mail1.sfbay.sun.com by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <atkinsonsusan@example.org> (original mail from atkinsonsusan@example.org) for atkinsonsusan@example.org; Mon, 03 Oct 2005 12:40:36 -0700 (PDT) Received: from [83.161.120.155] (vpn-129-150-29-96.SFBay.Sun.COM [83.161.120.155]) by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <atkinsonsusan@example.org> for atkinsonsusan@example.org; Mon, 03 Oct 2005 12:40:36 -0700 (PDT) Date: Mon, 03 Oct 2005 12:40:22 -0700 From: Rick Hillegas <atkinsonsusan@example.org> Subject: Re: Tests in SQL In-reply-to: <atkinsonsusan@example.org> To: Derby Discussion <atkinsonsusan@example.org> Message-id: <atkinsonsusan@example.org> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) References: <atkinsonsusan@example.org> <atkinsonsusan@example.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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: public static String dayOfWeek( java.sql.Date date ) throws Exception { GregorianCalendar calendar = new GregorianCalendar(); calendar.setTime( date ); int weekday = calendar.get( Calendar.DAY_OF_WEEK ); switch( weekday ) { case 1: return "Sunday"; case 2: return "Monday"; case 3: return "Tuesday"; case 4: return "Wednesday"; case 5: return "Thursday"; case 6: return "Friday"; case 7: return "Saturday"; default: throw new SQLException( "Unknown weekday: " + weekday ); } } Then you could declare this as a function and use it as you described: create function app.dayOfWeek ( dateValue date ) returns varchar( 8 ) parameter style java no sql language java external name 'z.dayOfWeek' ; values app.dayOfWeek( date( '2005-10-03' ) ); Cheers, -Rick Nicolas Dufour wrote: > Thanks > > Derby is really complete :) > > However, I didnt find in the builtin function a way to retrieve the > day of the week of a date or a timestamp, I mean monday, tuesday > ...and so on. > Is there such function anywhere ? > > Nicolas > > Suavi Ali Demir wrote: > >> SELECT CASE WHEN COL1 is NULL THEN 0 ELSE 1 END FROM MYTABLE >> >> Regards, >> Ali >> >> */Nicolas Dufour <atkinsonsusan@example.org>/* wrote: >> >> Hello >> >> I try to put tests in select clause. >> I mean I have a field which can be null and I want to create a >> select >> which return 0 when the field is null and 1 in the other case. >> Is it possible to do that in Derby ? >> I try also to look in a string and if i recognize a pattern >> extract two >> parts of it and if not just take the all value. >> How can i do that ? >> >> Thanks >> >> Nicolas >> > > From derbyatkinsonsusan@example.org Mon Oct 03 21:52:02 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 94200 invoked from network); 3 Oct 2005 21:52:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 21:52:02 -0000 Received: (qmail 26013 invoked by uid 500); 3 Oct 2005 21:52:01 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 25685 invoked by uid 500); 3 Oct 2005 21:52:00 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 25671 invoked by uid 99); 3 Oct 2005 21:52:00 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 14:52:00 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO red.amberpoint.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 14:52:04 -0700 Received: from [83.161.120.155] (bp-work.edgility.com [83.161.120.155]) by red.amberpoint.com (8.12.11/8.12.11) with ESMTP id j93LpYiU018260 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 14:51:35 -0700 (PDT) Message-ID: <atkinsonsusan@example.org> Date: Mon, 03 Oct 2005 14:51:34 -0700 From: Bryan Pendleton <atkinsonsusan@example.org> User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: atkinsonsusan@example.org Subject: How to suppress line "Connection number: NNN." in Network Server output Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I've been running Derby 83.161.120.155 in Network Server mode using an unmodified version of startNetworkServer.ksh from the Derby distribution. I notice that my network server process produces output of the form: Connection number: 121538. Connection number: 121539. Connection number: 121540. How do I suppress this output? thanks, bryan From derbyatkinsonsusan@example.org Mon Oct 03 22:46:37 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 7297 invoked from network); 3 Oct 2005 22:46:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 22:46:37 -0000 Received: (qmail 76410 invoked by uid 500); 3 Oct 2005 22:46:36 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 76385 invoked by uid 500); 3 Oct 2005 22:46:35 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 76374 invoked by uid 99); 3 Oct 2005 22:46:35 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 15:46:35 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO brmea-mail-4.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 15:46:39 -0700 Received: from phys-d3-ha21sca-2 ([83.161.120.155]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id j93MkDvD006745 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 16:46:13 -0600 (MDT) Received: from conversion-daemon.ha21sca-mail1.sfbay.sun.com by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <atkinsonsusan@example.org> (original mail from atkinsonsusan@example.org) for atkinsonsusan@example.org; Mon, 03 Oct 2005 15:46:30 -0700 (PDT) Received: from [83.161.120.155] (vpn-129-150-26-49.SFBay.Sun.COM [83.161.120.155]) by ha21sca-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <atkinsonsusan@example.org> for atkinsonsusan@example.org; Mon, 03 Oct 2005 15:46:30 -0700 (PDT) Date: Mon, 03 Oct 2005 15:46:16 -0700 From: Rick Hillegas <atkinsonsusan@example.org> Subject: Re: How to suppress line "Connection number: NNN." in Network Server output In-reply-to: <atkinsonsusan@example.org> To: Derby Discussion <atkinsonsusan@example.org> Message-id: <atkinsonsusan@example.org> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) References: <atkinsonsusan@example.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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 Pendleton wrote: > I've been running Derby 83.161.120.155 in Network Server mode > using an unmodified version of startNetworkServer.ksh > from the Derby distribution. > > I notice that my network server process produces output > of the form: > > Connection number: 121538. > Connection number: 121539. > Connection number: 121540. > > How do I suppress this output? > > thanks, > > bryan > From derbyatkinsonsusan@example.org Mon Oct 03 22:54:36 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 8626 invoked from network); 3 Oct 2005 22:54:35 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 22:54:35 -0000 Received: (qmail 86530 invoked by uid 500); 3 Oct 2005 22:54:35 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 86202 invoked by uid 500); 3 Oct 2005 22:54:34 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 86191 invoked by uid 99); 3 Oct 2005 22:54:34 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 15:54:34 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO e5.ny.us.ibm.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 15:54:38 -0700 Received: from d01relay02.pok.ibm.com (d01relay02.pok.ibm.com [83.161.120.155]) by e5.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id j93MsBTl006329 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 18:54:11 -0400 Received: from d01av03.pok.ibm.com (d01av03.pok.ibm.com [83.161.120.155]) by d01relay02.pok.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j93MsBVc065750 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 18:54:11 -0400 Received: from d01av03.pok.ibm.com (loopback [83.161.120.155]) by d01av03.pok.ibm.com (8.12.11/8.13.3) with ESMTP id j93MsBNL016866 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 18:54:11 -0400 Received: from [83.161.120.155] (sig-9-48-111-212.mts.ibm.com [83.161.120.155]) by d01av03.pok.ibm.com (8.12.11/8.12.11) with ESMTP id j93Ms9ik016809 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 18:54:10 -0400 Message-ID: <atkinsonsusan@example.org> Date: Mon, 03 Oct 2005 15:54:08 -0700 From: Kathey Marsden <atkinsonsusan@example.org> User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion <atkinsonsusan@example.org> Subject: Re: How to suppress line "Connection number: NNN." in Network Server output References: <atkinsonsusan@example.org> <atkinsonsusan@example.org> In-Reply-To: <atkinsonsusan@example.org> X-Enigmail-Version: 83.161.120.155 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Rick Hillegas wrote: > 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. > This is logged as: http://issues.apache.org/jira/browse/DERBY-569 Current alternatives include starting the server programatically and suppressing or redirecting output. I think it would be a fairly easy starter project for someone who is interested in making the change. Kathey From derbyatkinsonsusan@example.org Mon Oct 03 23:10:11 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 12119 invoked from network); 3 Oct 2005 23:10:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 23:10:11 -0000 Received: (qmail 7104 invoked by uid 500); 3 Oct 2005 23:10:10 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 7082 invoked by uid 500); 3 Oct 2005 23:10:10 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 7071 invoked by uid 99); 3 Oct 2005 23:10:09 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 16:10:09 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO red.amberpoint.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 16:10:12 -0700 Received: from [83.161.120.155] (bp-work.edgility.com [83.161.120.155]) by red.amberpoint.com (8.12.11/8.12.11) with ESMTP id j93N9jCO024473 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 16:09:45 -0700 (PDT) Message-ID: <atkinsonsusan@example.org> Date: Mon, 03 Oct 2005 16:09:45 -0700 From: Bryan Pendleton <atkinsonsusan@example.org> User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: atkinsonsusan@example.org Subject: How can I tell if Derby is using my derby.properties file or not? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Sorry, rank beginner question here: I've placed a derby.properties file into the directory that (I think) is my derby.system.home directory, and I'm trying to tell whether derby is in fact using my properties or not. Does Derby write any special sort of messages to derby.log upon reading my derby.properties file? Or is there some other way that I can verify that the desired properties have been read? thanks, bryan From derbyatkinsonsusan@example.org Mon Oct 03 23:39:11 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 17153 invoked from network); 3 Oct 2005 23:39:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Oct 2005 23:39:11 -0000 Received: (qmail 29014 invoked by uid 500); 3 Oct 2005 23:39:09 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 28992 invoked by uid 500); 3 Oct 2005 23:39:08 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 28981 invoked by uid 99); 3 Oct 2005 23:39:08 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 16:39:08 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO Boron.MeepZor.Com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2005 16:39:12 -0700 Received: from [83.161.120.155] (dmz-firewall [83.161.120.155]) by Boron.MeepZor.Com (8.12.8/8.12.8) with ESMTP id j93Na1i5003782 for <atkinsonsusan@example.org>; Mon, 3 Oct 2005 19:38:33 -0400 Message-ID: <atkinsonsusan@example.org> Date: Mon, 03 Oct 2005 16:34:38 -0700 From: Rajesh Kartha <atkinsonsusan@example.org> User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion <atkinsonsusan@example.org> Subject: Re: How can I tell if Derby is using my derby.properties file or not? References: <atkinsonsusan@example.org> In-Reply-To: <atkinsonsusan@example.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Bryan Pendleton wrote: > Sorry, rank beginner question here: I've placed a > derby.properties file into the directory that (I think) > is my derby.system.home directory, and I'm trying to tell > whether derby is in fact using my properties or not. > > Does Derby write any special sort of messages to > derby.log upon reading my derby.properties file? Or is > there some other way that I can verify that the desired > properties have been read? > > thanks, > > bryan > The derby.log does not show any special messages about the derby.properties being read .As long as the derby.system.home is pointing to the correct location that has the derby.properties file, it will be read. See: http://db.apache.org/derby/docs/10.0/manuals/tuning/perf14.html http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408bradbury/ One simple way to check is to add some debug properties to the derby.properties file and see if they are reflected in the derby.log. Example: To log all executed statements to the log file: derby.language.logStatementText=true -Rajesh From derbyatkinsonsusan@example.org Tue Oct 04 07:33:51 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 59778 invoked from network); 4 Oct 2005 07:33:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Oct 2005 07:33:50 -0000 Received: (qmail 43211 invoked by uid 500); 4 Oct 2005 07:33:49 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 43161 invoked by uid 500); 4 Oct 2005 07:33:48 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 43150 invoked by uid 99); 4 Oct 2005 07:33:48 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 00:33:48 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO file1.syd.nuix.com.au) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 00:33:51 -0700 Received: from [83.161.120.155] (host78.syd.nuix.com.au [83.161.120.155]) by file1.syd.nuix.com.au (Postfix) with ESMTP id 6CE3BB762A for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 17:33:23 +1000 (EST) Message-ID: <atkinsonsusan@example.org> Date: Tue, 04 Oct 2005 17:37:18 +1000 From: Daniel Noll <atkinsonsusan@example.org> Organization: NUIX Pty Limited User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Users Mailing List <atkinsonsusan@example.org> Subject: CLOBs and the Client driver Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi. Are there any known problems in Derby 10.1 with regards to retrieving CLOBs? We have a system which can work in both embedded and client mode, and I've discovered that using it in client mode results in an empty string (not null, but "") returned for a CLOB-type column. The same issue doesn't happen on the embedded driver, and I can't find any immediately obvious records in JIRA which describe a similar problem. Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this message or attachment is strictly prohibited. From derbyatkinsonsusan@example.org Tue Oct 04 14:54:38 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 66351 invoked from network); 4 Oct 2005 14:54:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Oct 2005 14:54:38 -0000 Received: (qmail 73822 invoked by uid 500); 4 Oct 2005 14:54:36 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 73779 invoked by uid 500); 4 Oct 2005 14:54:35 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 73768 invoked by uid 99); 4 Oct 2005 14:54:35 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 07:54:35 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO nwkea-mail-2.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 07:54:37 -0700 Received: from phys-epost-1 ([83.161.120.155]) by nwkea-mail-2.sun.com (8.12.10/8.12.9) with ESMTP id j94EsBHT022247 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 07:54:11 -0700 (PDT) Received: from conversion-daemon.epost-mail1.sweden.sun.com by epost-mail1.sweden.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <atkinsonsusan@example.org> (original mail from atkinsonsusan@example.org) for atkinsonsusan@example.org; Tue, 04 Oct 2005 16:54:10 +0200 (MEST) Received: from [83.161.120.155] (atum12.Norway.Sun.COM [83.161.120.155]) by epost-mail1.sweden.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <atkinsonsusan@example.org> for atkinsonsusan@example.org; Tue, 04 Oct 2005 16:54:10 +0200 (MEST) Date: Tue, 04 Oct 2005 16:54:10 +0200 From: Manyi Lu - Sun Norway <atkinsonsusan@example.org> Subject: Derby and JSR-169 To: Derby Discussion <atkinsonsusan@example.org> Message-id: <atkinsonsusan@example.org> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040618 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi all, I know that Derby has support for JSR-169 which is JDBC API for CDC. Anyone knows whether Derby has passed the TCK tests for JSR-169? Thanks for your help! Manyi From derbyatkinsonsusan@example.org Tue Oct 04 15:20:02 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 82340 invoked from network); 4 Oct 2005 15:20:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Oct 2005 15:20:02 -0000 Received: (qmail 31482 invoked by uid 500); 4 Oct 2005 15:20:00 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 31417 invoked by uid 500); 4 Oct 2005 15:19:59 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Delivered-To: moderator for atkinsonsusan@example.org Received: (qmail 88371 invoked by uid 99); 4 Oct 2005 08:17:25 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) X-Envelope-Sender: atkinsonsusan@example.org Message-ID: <atkinsonsusan@example.org> Date: Tue, 04 Oct 2005 10:17:00 +0200 From: Davor Prezel <atkinsonsusan@example.org> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: atkinsonsusan@example.org Subject: JDBC Driver returns read-only column metadata Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I'm trying to get Derby 10.1 Net Server to work with Torque, but when I try to insert or update the ColumnMetadata returns the read-only flag as true nad therefore Torque cannot save it. I have checked and the databse itself is NOT readonly. I have not used any extra parameters to get the Derby to start, nor did I put some extra parameters to Derby JDBC client. I'm using Derby JDBC client bundled with the Derby Server 10.1 I appreciate the help on this. Thanks Dav From derbyatkinsonsusan@example.org Tue Oct 04 16:02:59 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 98630 invoked from network); 4 Oct 2005 16:02:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Oct 2005 16:02:58 -0000 Received: (qmail 3966 invoked by uid 500); 4 Oct 2005 16:02:57 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 3929 invoked by uid 500); 4 Oct 2005 16:02:57 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 3917 invoked by uid 99); 4 Oct 2005 16:02:56 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 09:02:56 -0700 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO e36.co.us.ibm.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 09:03:00 -0700 Received: from d03relay04.boulder.ibm.com (d03relay04.boulder.ibm.com [83.161.120.155]) by e36.co.us.ibm.com (8.12.11/8.12.11) with ESMTP id j94G1B4Q032474 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 12:01:11 -0400 Received: from d03av01.boulder.ibm.com (d03av01.boulder.ibm.com [83.161.120.155]) by d03relay04.boulder.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j94G3DNX467146 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 10:03:14 -0600 Received: from d03av01.boulder.ibm.com (loopback [83.161.120.155]) by d03av01.boulder.ibm.com (8.12.11/8.13.3) with ESMTP id j94G2Vkb002844 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 10:02:31 -0600 Received: from [83.161.120.155] (DMCSDJDT41P.usca.ibm.com [83.161.120.155]) by d03av01.boulder.ibm.com (8.12.11/8.12.11) with ESMTP id j94G2UHH002824 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 10:02:31 -0600 Message-ID: <atkinsonsusan@example.org> Date: Tue, 04 Oct 2005 09:02:30 -0700 From: Daniel John Debrunner <atkinsonsusan@example.org> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion <atkinsonsusan@example.org> Subject: Re: Derby and JSR-169 References: <atkinsonsusan@example.org> In-Reply-To: <atkinsonsusan@example.org> X-Enigmail-Version: 83.161.120.155 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Manyi Lu - Sun Norway wrote: > Hi all, > > I know that Derby has support for JSR-169 which is JDBC API for CDC. > Anyone knows whether Derby has passed the TCK tests for JSR-169? Are there any TCK tests for JSR-169? If so is there a link for them? Thanks, Dan. From derbyatkinsonsusan@example.org Tue Oct 04 16:08:08 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 244 invoked from network); 4 Oct 2005 16:08:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Oct 2005 16:08:07 -0000 Received: (qmail 9843 invoked by uid 500); 4 Oct 2005 16:08:06 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 9815 invoked by uid 500); 4 Oct 2005 16:08:06 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 9804 invoked by uid 99); 4 Oct 2005 16:08:06 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 09:08:06 -0700 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=HTML_50_60,HTML_MESSAGE,HTML_TITLE_EMPTY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO brmea-mail-4.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 09:08:11 -0700 Received: from phys-bur-1 ([83.161.120.155]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id j94G7jvD008756 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 10:07:45 -0600 (MDT) Received: from conversion-daemon.bur-mail1.east.sun.com by bur-mail1.east.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <atkinsonsusan@example.org> (original mail from atkinsonsusan@example.org) for atkinsonsusan@example.org; Tue, 04 Oct 2005 12:07:45 -0400 (EDT) Received: from [83.161.120.155] (vpn-129-150-64-184.East.Sun.COM [83.161.120.155]) by bur-mail1.east.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTPA id <atkinsonsusan@example.org> for atkinsonsusan@example.org; Tue, 04 Oct 2005 12:07:45 -0400 (EDT) Date: Tue, 04 Oct 2005 12:07:48 -0400 From: "Lance J. Andersen" <atkinsonsusan@example.org> Subject: Re: Derby and JSR-169 In-reply-to: <atkinsonsusan@example.org> To: Derby Discussion <atkinsonsusan@example.org> Message-id: <atkinsonsusan@example.org> MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_e7oYR+7e3TN3dmxfaRjy0A)" X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) References: <atkinsonsusan@example.org> <atkinsonsusan@example.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. --Boundary_(ID_e7oYR+7e3TN3dmxfaRjy0A) Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT Apache would have to apply for a scholarship for the TCK see http://jcp.org/aboutJava/communityprocess/final/jsr169/index.html lance Daniel John Debrunner wrote: >Manyi Lu - Sun Norway wrote: > > > >>Hi all, >> >>I know that Derby has support for JSR-169 which is JDBC API for CDC. >>Anyone knows whether Derby has passed the TCK tests for JSR-169? >> >> > >Are there any TCK tests for JSR-169? > >If so is there a link for them? > >Thanks, >Dan. > > > --Boundary_(ID_e7oYR+7e3TN3dmxfaRjy0A) Content-type: text/html; charset=us-ascii Content-transfer-encoding: 7BIT <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> Apache would have to apply for a scholarship for the TCK see <a class="moz-txt-link-freetext" href="http://jcp.org/aboutJava/communityprocess/final/jsr169/index.html">http://jcp.org/aboutJava/communityprocess/final/jsr169/index.html</a><br> <br> lance<br> <br> Daniel John Debrunner wrote: <blockquote cite="atkinsonsusan@example.org" type="cite"> <pre wrap="">Manyi Lu - Sun Norway wrote: </pre> <blockquote type="cite"> <pre wrap="">Hi all, I know that Derby has support for JSR-169 which is JDBC API for CDC. Anyone knows whether Derby has passed the TCK tests for JSR-169? </pre> </blockquote> <pre wrap=""><!----> Are there any TCK tests for JSR-169? If so is there a link for them? Thanks, Dan. </pre> </blockquote> </body> </html> --Boundary_(ID_e7oYR+7e3TN3dmxfaRjy0A)-- From derbyatkinsonsusan@example.org Tue Oct 04 16:12:16 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 1566 invoked from network); 4 Oct 2005 16:12:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Oct 2005 16:12:16 -0000 Received: (qmail 18535 invoked by uid 500); 4 Oct 2005 16:12:14 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 18510 invoked by uid 500); 4 Oct 2005 16:12:14 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 18499 invoked by uid 99); 4 Oct 2005 16:12:13 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 09:12:13 -0700 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO e5.ny.us.ibm.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 09:12:17 -0700 Received: from d01relay02.pok.ibm.com (d01relay02.pok.ibm.com [83.161.120.155]) by e5.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id j94GBmj4016048 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 12:11:48 -0400 Received: from d01av01.pok.ibm.com (d01av01.pok.ibm.com [83.161.120.155]) by d01relay02.pok.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j94GBl6C092172 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 12:11:47 -0400 Received: from d01av01.pok.ibm.com (loopback [83.161.120.155]) by d01av01.pok.ibm.com (8.12.11/8.13.3) with ESMTP id j94GBlWt007624 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 12:11:47 -0400 Received: from [83.161.120.155] (DMCSDJDT41P.usca.ibm.com [83.161.120.155]) by d01av01.pok.ibm.com (8.12.11/8.12.11) with ESMTP id j94GBkIR007507 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 12:11:47 -0400 Message-ID: <atkinsonsusan@example.org> Date: Tue, 04 Oct 2005 09:11:46 -0700 From: Daniel John Debrunner <atkinsonsusan@example.org> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion <atkinsonsusan@example.org> Subject: Re: Derby and JSR-169 References: <atkinsonsusan@example.org> <atkinsonsusan@example.org> <atkinsonsusan@example.org> In-Reply-To: <atkinsonsusan@example.org> X-Enigmail-Version: 83.161.120.155 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Lance J. Andersen wrote: > Apache would have to apply for a scholarship for the TCK see > http://jcp.org/aboutJava/communityprocess/final/jsr169/index.html To quote that page: "The TCK will be available to Qualified Not-for-Profits and Qualified Individuals for no charge as per Section F.III of the JSPA 2." When *will* the TCK be available, or is it now? Dan. From derbyatkinsonsusan@example.org Tue Oct 04 16:24:37 2005 Return-Path: <derbyatkinsonsusan@example.org> Delivered-To: atkinsonsusan@example.org Received: (qmail 5613 invoked from network); 4 Oct 2005 16:24:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Oct 2005 16:24:37 -0000 Received: (qmail 39297 invoked by uid 500); 4 Oct 2005 16:24:36 -0000 Delivered-To: atkinsonsusan@example.org Received: (qmail 39260 invoked by uid 500); 4 Oct 2005 16:24:35 -0000 Mailing-List: contact atkinsonsusan@example.org; run by ezmlm Precedence: bulk list-help: <mailto:atkinsonsusan@example.org> list-unsubscribe: <mailto:atkinsonsusan@example.org> List-Post: <mailto:atkinsonsusan@example.org> List-Id: <derby-user.db.apache.org> Reply-To: "Derby Discussion" <atkinsonsusan@example.org> Delivered-To: mailing list atkinsonsusan@example.org Received: (qmail 39248 invoked by uid 99); 4 Oct 2005 16:24:35 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 09:24:35 -0700 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=HTML_50_60,HTML_MESSAGE,HTML_TITLE_EMPTY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.161.120.155] (HELO brmea-mail-4.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Oct 2005 09:24:39 -0700 Received: from phys-bur-1 ([83.161.120.155]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id j94GODvD002106 for <atkinsonsusan@example.org>; Tue, 4 Oct 2005 10:24:13 -0600 (MDT) Received: from conversion-daemon.bur-mail1.east.sun.com by bur-mail1.east.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <atkinsonsusan@example.org> (original mail from atkinsonsusan@example.org) for atkinsonsusan@example.org; Tue, 04 Oct 2005 12:24:12 -0400 (EDT) Received: from [83.161.120.155] (vpn-129-150-64-184.East.Sun.COM [83.161.120.155]) by bur-mail1.east.sun.com (iPlanet Messaging Server
{'source': 'Apache Software Foundation Public Mail Archives'}