Re: Derby Embedded driver jar file

2004-09-08 Thread Kathey Marsden
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Zahra Zahid wrote: | Thanx Susan for the reply ...but i am having problemz wid the URL | now...herez wht i am using in my propertie the database name is | omar_regsitry. | | dbURL=jdbc:derby:omar_registry;create=true; | | but when i try building the

Re: MyEclipse and Derby - Best Practice question

2004-09-30 Thread Kathey Marsden
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joachim Dagerot wrote: Hi everybody, my second post! :-) I don't really know what I want, but I would like an embedded DB (atleast in production) which I can access and edit both via my application and via DBE, if this means I should run the

Re: How to proceed ?

2004-12-13 Thread Kathey Marsden
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gaurav Anand wrote: I am on lookout for an open source/free product. [snip] Clarification about Does derby offers a network edition? I want to know whether Derby be used with a client/server application. Hi Gaurav, - From what I understand one

Re: No BIT/BOOLEAN Data Type in Derby?

2004-12-15 Thread Kathey Marsden
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Johny English wrote: Hi folks, I'm currently evaluating derby as alternative db for my app, however I found in the docs that no BIT/BOOL/BOOLEAN data type in derby. Am I missing it out ? this is strange because in most database there must be a

Re: RESEND: possible resource leak in either Derby DRDA or IBM DB2 Universal JDBC Driver

2005-01-14 Thread Kathey Marsden
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Larry Cable wrote: [snip] Although I cannot (yet) identify where the problem is, I believe there must be some problem in either the DB2 client or the derby server DRDA implementation ... anyone got any ideas/comments? - Larry Cable One

Re: Cannot connect a second time to an embedded Cloudscape/Derby DB (2)

2005-01-25 Thread Kathey Marsden
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thomas Neumann wrote: Hello, since I had problems with our local mailer daemon to confirm my subscription to the derby mailing list I do not know if this mail was send to the other list members. So this actually the second trial to send this

Re: Max size of LONG VARCHAR documentation inconsistency?

2005-02-12 Thread Kathey Marsden
That should work fine it would be BLOB's over 2G that would be problematic. Barnet Wagman wrote: The documentation is incorrect where it says maximum length is unlimited. There is actually a jira entry for documentation that is yet to be fixed.

Re: Inserting values in an identity column

2005-03-08 Thread Kathey Marsden
Christian, Could you please file a Jira entry for this? I am hoping there someone in the Derby development community that has time to take up this issue and propose and implement a solution. It seems to me that this is a serious hindrance to migration to Derby that would be good to resolve

Re: [VOTE] First round of voting for Derby Logo

2005-03-11 Thread Kathey Marsden
[ ] 1 [ ] 2 [ ] 3 [ ] 4 [X] 5 [ ] 6 [ ] 7 [ ] 8 [ ] 9 [ ] 10 [ ] 11 [ ] 12 [ ] 13 [ ] 14 [ ] 15 [ ] 16 [ ] 17 [ ] 18 [ ] 19 [ ] 20 [ ] 21 [ ] 22 [ ] 23 [ ] 24 [ ] 25 [ ] 26 [ ] 27 [ ] 28 [ ] 29 [ ] 30 [ ] 31 [ ] 32 [ ] 33 [ ] 34 [ ] 35 [ ] None of the above- Let's keep trying.

Re: Importing data from MySQL

2005-03-23 Thread Kathey Marsden
Christian Rodriguez wrote: Hello everyone, I am trying to import data from a MySQL database. So far I havent been able to do it. What I have tried: 1. Ive used the mysql dump utility to generate a file with inserts and then try to run that file from ij. One of my tables contain a large text

[VOTE] Reject tally of logo votes

2005-03-24 Thread Kathey Marsden
It seems to me that it would be very sad and bad karma to have our logo under such a cloud of suspicion. So I would like to call a vote to reject this tally. I've heard lots of great ideas on how to resolve this issue either technologically or socially but I think first we need to establish

[RESULTS] Re: [VOTE] Reject tally of logo votes

2005-03-28 Thread Kathey Marsden
Kathey Marsden wrote: It seems to me that it would be very sad and bad karma to have our logo under such a cloud of suspicion. So I would like to call a vote to reject this tally. I've heard lots of great ideas on how to resolve this issue either technologically or socially but I think

Re: Urgent Help Required : Accessing DB with Derby Net Server

2005-03-31 Thread Kathey Marsden
Kapil Bajaj wrote: Hi All I am trying to read a table from Cloudscape Database using Derby Net Server through Java Program Every Time I run program I get the Error No Suitable Driver Here is portion from Java Program Connection connection = null; Driver driver = null;

Re: No current connection exception

2005-04-03 Thread Kathey Marsden
[EMAIL PROTECTED] wrote: Hi, I have apache derby 10.0 running on a MontaVista Linux system (3.1 Professional with Linux/i686 2.4.20) in embedded mode. The java level is Sun's jre 1.4.2_04. There are around 500,000 records in a table in the DB. I have one thread inserting rows into this

Re: Features? Status?

2005-04-26 Thread Kathey Marsden
Dag H. Wanvik wrote: Hi Peter, Which ResultSet types does derby support (TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE)? Network Server does not support scrollable ResultSets for large objects. This will require first that Derby-208 Add support to retrieve lobs for

Re: derby and squirrel sql JDBC client

2005-06-29 Thread Kathey Marsden
Bernt M. Johnsen wrote: Some experimenting shows that the NetworkClient implicitely closes the resultset when rs.next() moves beyond the alst row, so e.g. rs.getMetaData() will fail with the given operation. I would call this a bug in the network client driver. I'll file an JIRA issue on it.

Re: Cursors

2005-07-14 Thread Kathey Marsden
Satheesh Bandaram wrote: If closing ResultSets and Statements don't release memory, I think, that would be a bug. If you have a repro, I would file a bug in Jira and attach a test case. Satheesh simmi iyer wrote: What I mean is ResultSet.close() in java is not closing the cursors at

Re: XA, Derby, Unversal JDBC driver, Websphere 5.1 - Unsupported DDM object

2005-08-04 Thread Kathey Marsden
Johan Hoogenboezem wrote: Hi, As an experiment, I set up two DB2 databases and two data sources (Using com.ibm.db2.jcc.DB2XADataSource), The Universal JDBC driver from IBM. does not support XA with Derby. Please try Derby 10.1 with the new client driver which does support XA.

Re: Derby Standards

2005-08-11 Thread Kathey Marsden
Philip Wilder wrote: I'll take what I can get. :-) Hmmm.. found this sitting in my drafts folder. Don't know if it is of any help at this late date. I don't think we have a list on the website. It would be nice. In addition to those you have mentioned, a few specs of interest off the

Re: BLOB : java.lang.OutOfMemoryError

2005-08-31 Thread Kathey Marsden
Grégoire Dubois wrote: Hi all, I'm using the org.apache.derby.jdbc.ClientDriver driver to access the Derby database through network. Writting small files (smaller than 5Mo) into the database works fine, but I can't write big files (40Mo for example), without getting the exception

Re: BLOB : java.lang.OutOfMemoryError

2005-08-31 Thread Kathey Marsden
Craig Russell wrote: Of course, since we use DRDA, we would have to see if that protocol supports blob streaming... Yes it does. The issue is with our writeStream methods they take a length parameter which they use but don't actually write out. See the issue DERBY-326 for details

Re: Momory leak in JDBC driver?

2005-09-05 Thread Kathey Marsden
Bernt M. Johnsen wrote: [EMAIL PROTECTED] wrote Two things: 1) Are you closing your ResultSets? If just let the ResultSet objects pass out of scope without closing them, they will be leaked. That is, the driver keeps a linked list of them so they won't be gc'ed. I have experienced

Re: Momory leak in JDBC driver?

2005-09-07 Thread Kathey Marsden
[EMAIL PROTECTED] wrote: Are you saying Derby client driver does not close any existing ResultSet's that were generated by the Statement when the Statement is re-executed? That would indeed be against the JDBC spec, I know the embedded driver does close existing ResultSets. Exactly :) And

Re: suppress connection %d message on console

2005-09-13 Thread Kathey Marsden
Øystein Grøvlen wrote: XV == Xavier Vigouroux [EMAIL PROTECTED] writes: XV hi, XV is there a way to remove the message on console indicating new XV connection to the server ? As far as I can see from the code, these messages will always go to System.out.

Re: suppress connection %d message on console

2005-09-14 Thread Kathey Marsden
Øystein Grøvlen wrote: In my opinion, the logConnections property should affect both console output and output to the derby.log file. Sounds good.

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

2005-10-03 Thread Kathey Marsden
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

10.1.2 update

2005-10-05 Thread Kathey Marsden
Hello Derby Users, I wanted to give you an update on the 10.1.2 release. I recently updated the release status page at: http://people.apache.org/~kmarsden/tenOneTwoRelease.html There are currently 26 very useful fixes checked in and more on the way. See the release notes off of the status

Re: transient priviledgeException

2005-10-10 Thread Kathey Marsden
Xavier Vigouroux wrote: 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

Re: Derby XA, Hibernate 2.1.6, WebSphere 5.1 - Server returned XAER_NOTA at commit time

2005-10-17 Thread Kathey Marsden
Johan Hoogenboezem wrote: Hi Stanley 1. I will try to initiate a support case, but in my experience they drag their feet if they think the problem does not lie with WAS. They are also very likely to tell me to move to WAS 6. 2. Like I said before, the trace logs are meaningless to me. And you are

Request for 10.1.2 release candidate feedback.

2005-10-25 Thread Kathey Marsden
The 10.1.2 release candidate has been posted for vote by the Derby developers. I invite the user community to please try out the release candidate with your applications and provide feedback by responding to this mail by Tuesday 11/1/2005, 5:00pm PST or by filing issues in Jira. The release

[Fwd: [VOTE] 10.1.2 release candidate #2]

2005-11-04 Thread Kathey Marsden
candidate #2, including DERBY-662 which should be considered a critical upgrade for anyone running on Windows who drops tables in their application. Thanks Kathey Original Message From: Kathey Marsden [EMAIL PROTECTED] Subject:[VOTE] 10.1.2 release candidate #2

Re: Question about using URLClassLoader and Derby

2005-11-09 Thread Kathey Marsden
David W. Van Couvering wrote: I am forwarding this to folks I know within Sun who have done a *lot* of work within classloaders as part of the app server effort. I'll get back to you with any information I get. Thanks David for forwarding this to the gurus. What would be really great is if

Re: Question about using URLClassLoader and Derby

2005-11-10 Thread Kathey Marsden
[EMAIL PROTECTED] wrote: // untested code follows protected Class loadClass(String name, boolean resolve) throws ClassNotFoundException { Class cl = findLoadedClass(name); if (cl == null) { // cut off delegation to parent for certain classes // to ensure

Re: networkserver security manager issue

2005-11-10 Thread Kathey Marsden
Jean T. Anderson wrote: Daniel John Debrunner wrote: ... So, I guess the examples do need to be updated. I logged DERBY-701 . For anybody searching the archives, the three security policy file examples in the Developer's Guide are each missing one line, so they don't work. Example 1:

Re: Question about using URLClassLoader and Derby

2005-11-14 Thread Kathey Marsden
Kathey Marsden wrote: I am moving this to derby-dev as I think my new questions are more appropriate for this list. Oops, didn't actually move it but that's ok. We can keep it on derby-user for a bit. Hopefully there won't be any Derby internal code changes required to make this all work.

Re: Question about using URLClassLoader and Derby

2005-11-15 Thread Kathey Marsden
Jeremy Boynes wrote: [EMAIL PROTECTED] wrote: BTW, where would your application run? I am assuming it is outside of any managed environment like application server. In an ideal world, I would like to be able to specify all the properties for a Derby engine (rather than a database)

Re: SqlException: Run out of sections to use

2005-11-17 Thread Kathey Marsden
[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] writes: Here is the client's stack trace. I have none on the server. org.apache.derby.client.am.SqlException: Run out of sections to use,sections limited to 32k currently at org.apache.derby.client.am.SectionManager.getSection(Unknown Source)

Re: ClassCastException in CountAggregator

2005-12-07 Thread Kathey Marsden
Jean T. Anderson wrote: Edson Carlos Ericksson Richter wrote: I solved my problem not using derby :( Appear the list is more interested in voting logos, than solving critical bugs. Your frustration is understandable -- it must have seemed like Derby was doing nothing else today but

Re: how to insert some custom value in anidentity field

2006-01-30 Thread Kathey Marsden
Legolas Woodland wrote: Hi Thank you for reading my post. I have a table with one identity column , so Derby will generate a value for this column in evry insert. what should i do if i need to make some record with customized ID ? for example i want my admin user to have id=1 ? how i should

Re: Options for testing failover in a clustered environment

2006-02-08 Thread Kathey Marsden
Jean T. Anderson wrote: Kathey Marsden wrote: I got a request from a user who actually who asked for an option to automatically shutdown the database if there are no more connections. Does anyone have any ideas how to handle the scenario below and conditionally shutdown

Printing XAExceptions to derby.log

2006-02-13 Thread Kathey Marsden
I noticed that with derby.stream.error.logSeverityLevel=0 XAExceptions do not print to the derby.log.They are not SQLExceptions so I guess this makes sense, but seems contrary to the general log all the errors semantics of this setting. Is there a supported way to get XAExceptions to print

Re: upcoming 10.2 release

2006-02-14 Thread Kathey Marsden
Edson Carlos Ericksson Richter wrote: [snip lots of great improvements for Derby that probably won't make it by April 7 #:( ] What is most important now is to identify *bugs* that need to be fixed in 10.2. There are 137 open code bugs against DERBY. Vote for the issues that are important to you

Re: upcoming 10.2 release

2006-02-14 Thread Kathey Marsden
Edson Carlos Ericksson Richter wrote: I worked with database as large as 700Mb without problems. The unique problem I really find in Derby is lack of some very basic features, like renaming columns (even if part of primary/foreign keys), and unblocking online backup, both enhancements, not

Re: embedded derby -- does it leak

2006-02-15 Thread Kathey Marsden
Jim Newsham wrote: Are there other outstanding memory/leak related bugs which I'm not aware of? Would you recommend Derby for my project? With embedded there is an issue in 10.1, https://issues.apache.org/jira/browse/DERBY-599 This bug is related to large objects getting materialized and

Re: How can I get sysinfo for a custom Derby classloader?

2006-02-22 Thread Kathey Marsden
Andrew McIntyre wrote: On 2/22/06, Kathey Marsden [EMAIL PROTECTED] wrote: 2) Will DERBY-668 mean that it won't print the right information anyway, even if I get the coding right? Unfortunately, I'm sure this is true. Thanks Andrew. I changed the title of DERBY-668 as I think

Re: select count(*) == ClassCastException:CountAggregator

2006-03-01 Thread Kathey Marsden
Andrew McIntyre wrote: On 3/1/06, Chris Newell [EMAIL PROTECTED] wrote: The problem was: - This issue arises when executing the statement select count(*) from DEFAULT_SCHEMA.general_events. If I execute it using a datasource from the Tomcat pool I got the exception:

Please try the Derby 10.1.2.4 snapshot if ...

2006-05-11 Thread Kathey Marsden
1) You use client XA. There are critical XA fixes including DERBY-898 which resolve potential data integrity problems. 2) You have queries that might benefit from the dramatic performance improvements of the DERBY-649/805 fixes. 3) You transfer large data values or use batch

Re: Please try the Derby 10.1.2.4 snapshot if ...

2006-05-11 Thread Kathey Marsden
Kathey Marsden wrote: This is your chance to provide input *before* 10.1.3 is released in June. Helpful to provide the link to the download page: http://db.apache.org/derby/derby_downloads.html Look for: Derby 10.1.2.4 (May 9, 2006 / SVN 405564) [zip http://db.apache.org/derby/binaries

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

2006-05-15 Thread Kathey Marsden
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 inheritance graph for Derby's DataSources does not mirror the corresponding

Re: The tutorial on migrating DB to derby

2006-06-14 Thread Kathey Marsden
Jean T. Anderson wrote: [EMAIL PROTECTED] wrote: Hi, I was just going through the tutorial at http://db.apache.org/derby/integrate/db_ddlutils.html I am going through this tutorial too today.I got through the tutorial fine but on migrating another db I see the exception below #:(

Re: The tutorial on migrating DB to derby

2006-06-14 Thread Kathey Marsden
Kathey Marsden wrote: Jean T. Anderson wrote: [EMAIL PROTECTED] wrote: Hi, I was just going through the tutorial at http://db.apache.org/derby/integrate/db_ddlutils.html I am going through this tutorial too today.I got through the tutorial fine but on migrating another db I see

Re: The tutorial on migrating DB to derby

2006-06-14 Thread Kathey Marsden
Thomas Dudziak wrote: seems to be ok according to the Clob javadocs (http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Clob.html#getSubString(long,%20int)), right ? A string is only returned (and getSubString called) if the length of the clob is within int range, so length() seems to return

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

2006-06-16 Thread Kathey Marsden
Edson Carlos Ericksson Richter wrote: Unfortunately, for developers, TBDITW don't allow change column names, datatypes, nullability, etc... If you haven't already, please make sure you vote for DERBY-396. Already high on the list.

Re: Self-configuring embedded Derby applications

2006-06-19 Thread Kathey Marsden
Rick Hillegas wrote: 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

Re: Proposal for 10.2 release schedule

2006-06-23 Thread Kathey Marsden
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 into a pretzel, can be straightened out. I'm not ready to propose an alternative--but I expect to know more soon. Something along

Questions about Network Server API Behavior

2006-06-26 Thread Kathey Marsden
I was playing with starting Network Server and redirectect console output from an application using the NetworkServerControl API. And I noticed a few things. 1) I had to set the file to autoflush to see the console output go to the file. I tend to think this is a bug. Should

Language Based Ordering

2006-06-30 Thread Kathey Marsden
There was an old thread on derby-user about Language based ordering. http://www.nabble.com/Language-based-ordering-is-possible-in-Derby-tf482505.html#a1313448 So that valuable information won't get lost and so there is a place for people to build upon what was discussed there I put the

Re: Derby Shutdown

2006-07-01 Thread Kathey Marsden
Daniel Morton wrote: Hello All... I was just wondering, why does Derby throw an SQLException when it shuts down, ie: Shutdown is implemented with attributes on the url with the getConnection() method which can either a) return a connection or b) throw an exception. Obviously it

Re: Migrating CLOBs to new DB schema

2006-07-05 Thread Kathey Marsden
John English wrote: I have a database where I need to change the schema for a couple of crucial tables. This involves changing the types of some fields, so I can't just do an alter table. The tables contain CLOBs, so I can't use the provided SYSCS export/import procedures. [snip what John

[Fwd: Language based matching]

2006-07-07 Thread Kathey Marsden
redirecting to derby-user. I sent this to derby-dev by mistake. ---BeginMessage--- Does anyone know of an easy built in Java mechanism for Locale sensitive matching? I continue to work with a user trying to develop a strategy for language based string type handling in Derby 10.1. The

Lock debugging walktrhough on IRC

2006-07-13 Thread Kathey Marsden
Sunitha was walking the folks on IRC, mostly X-Gen and myself through debugging a lock timeout. The plan is for me to take what I learn and make it into a tutorial Wiki page so I won't go into great detail here as it will be more formally summarized later. There were two IRC sessions and

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

2006-07-14 Thread Kathey Marsden
Lance J. Andersen wrote: Derby is correct. The clarified JDBC 4 javadocs indicates the following: |pos| - the first character of the substring to be extracted. The first character is at position 1. |length| - the number of consecutive characters to be copied

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

2006-07-14 Thread Kathey Marsden
Lance J. Andersen wrote: Hi Kathy, I would probably expect a SQLException to be thrown in this case or I guess you could return nothing. I will assume then that the Derby behavior is correct and won't file a bug. Thank you for the clarification but I don't think your comment was either

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

2006-07-16 Thread Kathey Marsden
Lance J. Andersen wrote: First, it seems someone took my subtle attempt at humor the wrong way. My apologies as I was not trying to insult or offend anyone. Thank you Lance for clarifying your intent.I clearly misinterpreted your post and my request for clarification should have

My comment to Lance ( Was Re: should Clob.getSubstring() allow length of 0?)

2006-07-17 Thread Kathey Marsden
Now that the Clob.getSubstring() thread is back on track, I wanted to try to clarify my OK/Not OK post in Clob.getSubstring() thread and apologize for any trouble it caused the community or Lance. There I think were actually many points of misunderstanding. and poor judgment on my

Workarounds for language based ordering and matching in Derby

2006-07-18 Thread Kathey Marsden
Thanks all for your help with this issue. I added what I learned a table with a potential language based character type processing strategy at http://wiki.apache.org/db-derby/LanguageBasedOrdering I hope users will update this page as time goes on if they get something working. I left the

Re: Database Procedures Question

2006-07-18 Thread Kathey Marsden
[EMAIL PROTECTED] wrote: Thank you, Dan. That was exactly the problem. Import Table Data has an ugly parameter list and I missed one. Now about that much less than helpful error message - could someone please file a JIRA request for that? To file a Jira issue you just need to register for

Please try your applications with 10.2 optimizer changes

2006-07-19 Thread Kathey Marsden
Army has been working hard to make lots of great optimizer improvements, most recently DERBY-781. For the vast majority of applications this should should show performance benefit, but there are risks any time optimizer changes are made and it would be a good idea to make sure that your app

Re: Please try your applications with 10.2 optimizer changes

2006-07-19 Thread Kathey Marsden
Daniel John Debrunner wrote: Or try now and when the DERBY-781 changes are committed. The earlier the feedback the better chance of it being addressed in 10.2 release. Yes, definitely worth testing now. There has been a great deal of code change in the past year that might affect users.

!!! Regression Search and Destroy Contest !!!

2006-07-20 Thread Kathey Marsden
I posted the Wiki page this morning for the Derby 10.2 Regression Search and Destroy contest. The contest winners will be: The top three developers or users who have made the greatest contribution toward a seamless upgrade to 10.2. Details are at:

Re: Logging

2006-07-21 Thread Kathey Marsden
Craig L Russell wrote: It was the logStatementText that I was looking for in this particular case. I just overlooked it. because it was well hidden I think. I think there is a great documentation improvement opportunity here. This information is hidden in the tuning guide which is not

Re: Logging

2006-07-21 Thread Kathey Marsden
Craig L Russell wrote: Hi, Is there a simple way to have Derby log stuff? I've scoured the doc and can't really find much. I logged https://issues.apache.org/jira/browse/DERBY-1570 for this issue. I put in a suggestion for a possible quick fix for 10.2 so hopefully someone will pick it

Re: !!! Regression Search and Destroy Contest !!!

2006-07-24 Thread Kathey Marsden
We now have our panel of judges. Thanks to Stan, Rajesh and John for volunteering. Now all we need is an army of users to try their applications and flush all the bugs out of the product and documentation for 10.2. Please take a look and participate.

Re: Query performance of joining table and a view

2006-08-01 Thread Kathey Marsden
Hi Mustafa, Do you have a reproducible case that can illustrate this issue? If so, please file a Jira entry. Please include not only the DDL but how to insert the data and how much is needed to see a difference. Also, one more question, did you try this on 10.2 or 10.1? The derby

RegressionSearchAndDestroy ruling: Re: [jira] Created: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

2006-08-02 Thread Kathey Marsden
Prasenjit Sarkar (JIRA) wrote: Regression: The fields of views are not being calculated properly since 10.1.2.4 Good find Prasenjit, Thank you! Judges for the RegressionSearchAndDestroy contest: can you give

Regression Search And Destroy Contest Update

2006-08-17 Thread Kathey Marsden
Hello Derby Users, I wanted to send out an update on the Regression Search and Destroy contest and make a most urgent appeal for user testing for 10.2. The contest page is at: http://wiki.apache.org/db-derby/RegressionSearchAndDestroy 10.2 beta is available now at:

Re: 10.2 licensing issue

2006-09-11 Thread Kathey Marsden
Rick Hillegas 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 addition, we would remove JDBC4-specific documentation from our user

Have you tried 10.2 beta?

2006-09-11 Thread Kathey Marsden
Have you tried 10.2 beta? What were your results? Positive or negative or why it is not worth your time I'd like to know. The reason is this: Open source software development is based (as I understand it) on iterative feedback and involvement from users especially beta. Any regression

Re: Have you tried 10.2 beta?

2006-09-11 Thread Kathey Marsden
Stephen Caine wrote: I followed your link to send in beta reports (http://wiki.apache.org/ db-derby/TenTwoApplicationTesting), but I could not find how to submit a report. Can you be more specific? Thanks Steven! And I assume all went well. This is great news. Please just edit the wiki

User community role 10.2 testing of optimizer changes

2006-09-12 Thread Kathey Marsden
In the licencing discussion, I mentioned that we really need more user feedback before we release 10.2. Discussion has occurred on the developer list on that point and is on this thread. http://www.nabble.com/10.2-plans-%28was-Re%3A-10.2-licensing-issue%29-tf2256208.html The summary is that

Re: User community role 10.2 testing of optimizer changes

2006-09-12 Thread Kathey Marsden
Kathey Marsden wrote: We need users especially those who have complex or performance sensitive queries to try their existing applications and give us feedback. Yikes, I forgot the beta link. http://people.apache.org/~rhillegas/10.2.1.3-beta/ Other 10.2 information http://wiki.apache.org

Re: User community role 10.2 testing of optimizer changes

2006-09-12 Thread Kathey Marsden
Army wrote: Users may also want to remember the policy of scratch your own itch or fry your own fish: I as a developer tend to have more time and inclination to address issues with contributed code closer to the time I actually made the contribution. This is a good point and I bet your

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

2007-03-07 Thread Kathey Marsden
Quartz wrote: Hi, I was wondering why derby is ~200 times slower than mysql on a simple INSERT statement. I'm not expecting a pure java db to be as fast, but not that slower. I insert 200 'int' fields in a nearly empty table, with only 1 field as primary key. I insert rows in ascending PK

Re: Store very large Strings

2007-04-13 Thread Kathey Marsden
Ruben Fonseca wrote: Thank you! I didn't know about the CLOB type! However, I'm still having problems when *reading* from the CLOB.. When I call the ResultSet.getString on the CLOB I get a IOException thrown, when the String is large... Is this a known problem? I am not sure if it

Re: Derby Db tables returned in uppercase???

2007-04-23 Thread Kathey Marsden
Dustin S Houck wrote: Hello, I have been playing around with derby to determine if we want to use it in a project at my work. I have the db set up and populating the db with table and am able to connect to the db using jdbc. But after playing around with it and completing some queries it

[Fwd: 10.3 Bug fixing]

2007-05-04 Thread Kathey Marsden
Hello derby-user, Below is a mail I sent to derby-dev. Users can gain points as well by banging on 10.3 and logging bugs. Users can download the alpha release from http://dbtg.thresher.com/derby/bits/trunk/. Please try out 10.3 and help us produce a quality release. See

Re: ERROR 58009: Network protocol exception

2007-05-21 Thread Kathey Marsden
m96 wrote: the question that i have is: what is DSS chain and what does error 58809 mean? additionally is there a user name convention - if yes, where is it documented? User names are SQL92Identifiers and the rules are documented at:

Re: Hibernate commit issue

2007-05-30 Thread Kathey Marsden
Josh Donkersloot wrote: Hi, I have been having an issue where the database portion of my application becomes unusable after a commit fails. I am using hibernate 3.2.4 and derby 10.2.2. The following exception is thrown. The database call that causes this exception has been called numerous

Re: Difference between two timestamp fields

2007-06-04 Thread Kathey Marsden
Dmitri Pissarenko wrote: Hello! I need to calculate the difference between two timestamp fields in seconds. I tried this query: SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND, APP.MyTable.startTime, APP.MyTable.endTime)} FROM APP.MyTable WHERE APP.MyTable IS NOT NULL

Re: Difference between two timestamp fields

2007-06-06 Thread Kathey Marsden
Dmitri Pissarenko wrote: Hello! SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND, APP.MyTable.startTime, APP.MyTable.endTime)} FROM APP.MyTable WHERE APP.MyTable IS NOT NULL Should this be WHERE APP.MyTable.startTime IS NOT NULL ? Thanks for the hint! Now I'm getting

Re: Lock debugging walktrhough on IRC

2007-06-18 Thread Kathey Marsden
John Embretsen wrote: Does anyone know if any kind of lock debugging tutorial or related information was ever added to the wiki [1] (as Kathey mentioned last year) or any of the manuals? I was out for quite a while last year so was not able to pursue this. Unfortunately, I don't think I

Re: Invalid transaction state

2007-08-02 Thread Kathey Marsden
John C. Turnbull wrote: When disconnecting from my Derby 10.2.2.0 database I get an exception with an SQL State of 25000 – “Invalid transaction state”. What exactly does that mean and what does it indicate? You need to rollback or commit before closing the connection. Kathey

Re: Trailing space in VARCHARs

2007-08-05 Thread Kathey Marsden
Andrew ``Bass'' Shcheglov wrote: If I have a table with a VARCHAR field with a UNIQUE constraint placed on that field, I can't insert two records that differ only in trailing space, say 'foo' and 'foo '. I have 2 questions: 1. Is the described above a legitimate behaviour of Derby? Seems to

Re: Backward compatibility question

2007-08-28 Thread Kathey Marsden
David Van Couvering wrote: I know I should know this, but I just want to be sure. If you upgrade a DB from 10.2 to 10.3 (e.g. hard upgrade), I am assuming you can still use a 10.2 driver against that database, is that correct? Nope. Hard upgrade is a path of no return. Kathey

java.lang.ClassCastException in case statement: Is it a bug

2007-08-28 Thread Kathey Marsden
I was wondering if the cast exception returning null from a case statement is expected or a bug. If I cast the NULL to DATE it works ok. ij create table t (d date, vc varchar(30)); 0 rows inserted/updated/deleted ij insert into t values(CURRENT_DATE, 'hello'); 1 row inserted/updated/deleted

Re: java.lang.ClassCastException in case statement: Is it a bug

2007-08-29 Thread Kathey Marsden
Dag H. Wanvik wrote: Kathey Marsden [EMAIL PROTECTED] writes: I was wondering if the cast exception returning null from a case statement is expected or a bug. If I cast the NULL to DATE it works ok. This changed from 10.2 to 10.3; works in 10.2, btw. Thanks Dag. I filed DERBY

Re: SYSCS_GET_DATABASE_PROPERTY not working?

2007-09-12 Thread Kathey Marsden
David Van Couvering wrote: Hi, guys. I know that NetBeans sets derby.system.home to ~/.netbeans-derby, but when I do VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.system.home'); I get 'NULL'. So, I tried this on both Derby 10.3 and Derby 10.2: $ java -Dderby.system.home=/tmp -jar

Re: Derby 10.3.1.4 compiling problems

2007-09-14 Thread Kathey Marsden
Paulo Jesus wrote: The problem seems to start after, or inside, the first run of ant ... Derby does not have a dependency based build. I always do an ant clobber between builds. If it builds cleanly after an ant clobber then that is good. The problem you reported with the scripts is

Re: PreparedStatement problem with big BLOBS

2007-09-21 Thread Kathey Marsden
Mikael wrote: Hi ! I have a pretty weird problem, I use a Derby 10.3.1.4 with the ClientDriver and I run the code below: // Data is a byte[] vector ByteArrayInputStream is = new ByteArrayInputStream( data); String sql = UPDATE MyTable SET FContents=? WHERE FName=' + name +

Re: PreparedStatement problem with big BLOBS

2007-09-21 Thread Kathey Marsden
Mikael wrote: Here is a modified version of the SimpleApp that comes with Derby, if you run it without any argument (embedded mode) it works just fine, but if you add the argument derbyclient to run it in client mode it throws the exception, Thanks Mikael, I was able to reproduce the

  1   2   3   >