Re: Is Derby.jar really built using javac?

Hi Gili, Can you tell us what release of Derby is causing you problems? I built the distributions for the following releases and I did not use Eclipse to build any of these distributions. I believe that the release notes for these distributions accurately reflect the environment that I used:

Re: Caching Prepared Statements

Hi Raymond, I'm not aware of a JDBC method which returns the information you need. I ran your experiment on both 10.2 and the current trunk and verified your results. The isClosed() method (which PreparedStatement inherits from Statement and which was introduced in Java 6) returned false throu

Re: Alter TIMESTAMP field default after creation does not work

, Mark P Ashworth Rick Hillegas-2 wrote: Hi Mark, I find that this fails for me too when using the 10.2 series of releases. However, the experiment succeeds when I use the 10.3 and 10.4 releases. Regards, -Rick Mark P Ashworth wrote: Good Day, Derby version: 10.2.2.0 As part

Re: Alter TIMESTAMP field default after creation does not work

Hi Mark, I find that this fails for me too when using the 10.2 series of releases. However, the experiment succeeds when I use the 10.3 and 10.4 releases. Regards, -Rick Mark P Ashworth wrote: Good Day, Derby version: 10.2.2.0 As part of the database data upgrade process I need to do the

Re: Choosing Database Location Programatically with Embedded Driver

Hi Pierre, The location of database files is determined by two variables: 1) the database location in your connection URL and 2) the location of the Derby system directory indicated by the "derby.system.home" system property. For more detail, please see the section titled "Connecting to datab

Re: 10.4.2 maintenance release, was: java.lang.NullPointerException. [XJ001] on update

Alan Burlison wrote: Rick Hillegas wrote: I was thinking of producing a 10.4.2 maintenance release in September, hoping that we would have message localizations by then. We could probably live with that, thanks. Is there a policy for what gets backported into the release branches? Are

Re: Concatenating text from multiple rows

Hi Geoff, This sounds like a good use for a user-defined aggregate (DERBY-672). Most of the machinery for this feature actually exists inside Derby. We would have to agree on some syntax for declaring user-defined aggregates since ANSI doesn't have language for this. I'd be happy to coach some

10.4.2 maintenance release, was: java.lang.NullPointerException. [XJ001] on update

I was thinking of producing a 10.4.2 maintenance release in September, hoping that we would have message localizations by then. Regards, -Rick Mamta Satoor wrote: Alan, I am not sure if there is any schedule for next 10.4 release. Maybe someone else knows more about it. Mamta On 6/29/08, Ala

Re: need help with distinct results

I am not sure what is going on with your query. It would be helpful if you could post the full query and the results you are seeing. I have run some simple experiments with the INTERSECT operator and I have seen the following behavior: 1) The default behavior of the INTERSECT operator is to r

Re: Sensitive result set support ?

Albert Kam wrote: Hi Derby, I read from the derbydev.pdf that "Derby only supports scrollable insensitive result sets." I wonder why .. and i also wonder if derby will support this in the future ? :) Hi Albert, Scrollable, updatable, insensitive ResultSets were added in Derby 10.2. That was

Re: commit and close needs specific ordering ?

Hi Albert, I believe this is what is going on here: 1) By default, ResultSets remain open after commits. You have to explicitly close your ResultSets. See the section titled "Holdable result sets" in the Derby Developer's Guide: http://db.apache.org/derby/docs/10.4/devguide/ This section expl

Re: UpdatableResultSet Problem

Hi Albert, I believe that the problem is that your query contains an ORDER BY clause. This means that the ResultSet will not be updatable. For the details on what kinds of queries can define updatable ResultSets, please see the section titled "SELECT statement" in the Derby Reference Manual:

Re: Table Compression and FreeSpace Claiming

Hi Albert, Some comments inline... Albert Kam wrote: Dear Derby .. I'm using 10.4.1.3 I tried out a simple experiment .. 1. Fired out ij from the shell and connects to a derby database 2. Created a table, named sms_out 3. Inserted some data from a csv file using SYSCS_UTIL.S

Re: Portability issue for 'Like-clause' on non-string types ?

he JDBC driver, and was not recognized as a query parameter, since it is really just part of the string itself. If the use of "||" slows down the query significantly, than that's a real problem, since there appears to be no other way to "inject" jdbc ? into the st

Re: Portability issue for 'Like-clause' on non-string types ?

Hi Albert, As Dyre and Donald point out, the LIKE operator can only be applied to strings. You can write your own casting function to turn your integers into strings (or to extract other information which you may be encoding in integers). Something like the following should work: select * fr

Re: CSV with fails with doublequote inside the value

Hi Albert, Derby's understanding of CSV predates RFC 4180. For instance, Derby trims leading and trailing spaces from imported columns although this behavior is forbidden by RFC 4180. Derby's CSV dialect is described in the Tools Guide in a section titled "File format for input and output". T

Re: temporary tables and connection pooling

Hi Bob, I'm not aware of a master flush command in Derby. It may be useful to write your own flush() method which you can register as a Derby procedure and invoke at session boundaries. Depending on the Java support in the other databases you use, you may be able to register this method as a

Re: any feedback on this?

Bryan Pendleton wrote: How do people work around this at present? I absolutely *must* have case-insensitive indexed searches in my application. I store my critical string fields twice, in two separate columns, one column has the user-desired case, and the other column has the same data in all

Re: any feedback on this?

Geoff hendrey wrote: I posted a comment with a suggestion on an approach for dealing with case-insensitive comparisons. Any feedback? https://issues.apache.org/jira/browse/DERBY-1748?focusedCommentId=12606166#action_12606166 Hi Geoff, I have commented on the issue. Your latest proposal sound

Re: Derby Memory Issues in CDC

Hi Albert, Some comments inline... Albert Kam wrote: Hello all, I'm currently developing on CDC 1.0, using Creme JVM, running on HP iPAQ 6965 pocket pc device. I'm using Apache Derby as the embedded database for the application. I notice that the Java app has only about 29MB of memory avail

Re: Does Embedded Driver Support Multiple Databases

Hi John, You should be able to wrap a separate data source around each of your databases and access them both via the same EmbeddedDriver. There is not much information in this SQLException. Can you share more of the stack trace and/or the derby log file? That will help us puzzle through this.

Re: Trigger function broken in 10.4.1.3?

Hi Mamta, I have reproduced the stack trace and attached it to DERBY-3718. This is the stack trace I get on the trunk. Regards, -Rick Mamta Satoor wrote: Thiyagu, can you post the null pointer exception trace that you get? Mamta On 6/10/08, Thiyagu P <[EMAIL PROTECTED]> wrote: Hi, Get

Re: Trigger function broken in 10.4.1.3?

Hi Thiyagu, Thanks for finding this and supplying a reproducible test case. I have created DERBY-3718 to track this regression. Regards, -Rick Thiyagu P wrote: Hi, Getting null pointer exception when a trigger gets invoked. Steps to recreate : 1. Created new db and execute the following

Re: case-insensitive searching

Hi Geoff, The community has discussed a couple approaches to case-insensitive search. My favorite is DERBY-418 (generated columns), which pretty much aligns with what you are proposing. DERBY-481 already has a functional spec attached to it. With generated columns, you would be able to index

Re: Newbie: problem setting the derby.system.home directory

Hi Mauro, 1) Have you tried setting derby.system.home on the vm boot command line via a -D parameter? What behavior do you see when you try this? 2) What value are you setting derby.system.home to? 3) If you are seeing a stack trace, could you share that with us? Thanks, -Rick Mauro Molinar

Re: Checking for integrity in a trigger

Hi Bassam, Derby's trigger syntax is described in the "CREATE TRIGGER statement" section of the Derby Reference Manual: http://db.apache.org/derby/docs/10.4/ref/ You may also be able to implement the behavior you need by using a CHECK constraint which invokes a function. The function, in tur

Re: Statistical Information of overall queries

Hi Mahmoud, Some of the information you need can be obtained by setting a tracing property when you bring up the Derby engine. Please see the section titled "derby.language.logStatementText" in the Derby Tuning Guide: http://db.apache.org/derby/docs/10.4/tuning/ Setting this property will cau

Re: org.apache.derby.client.am.DisconnectException from Derby 10.1

A lot of work was put into improving Derby's performance and scalability in releases 10.2, 10.3, and 10.4. Glad to hear that you're seeing the benefit. Regards, -Rick sin(EaTing), wrote: Even more amazing! This time I tried to totally upgrade my Derby to 10.4. Not only every disconnect exce

Re: Database connection not bound to default database schema when authenticating through LDAP?

Hi Andreas, I can see that for many applications it would be useful to have a concept of a database-wide default schema, that is, a schema that all users start out in when they get a fresh connection. That is not the way Derby works. For Derby, the default schema is user-specific, not databas

Re: shutdown fails when basic security policy is active and authentication is ldap based

Myrna van Lunteren wrote: I agree with Rick that this should get documented. Perhaps, Andreas, you could log this issue as a documentation improvement in JIRA? Also, I wondered - in some recent testing I found that 'connect' permission was not sufficient, I needed "connect, resolve" to the ldapSe

Re: shutdown fails when basic security policy is active and authentication is ldap based

Hi Andreas, I agree that this issue ought to be documented. For what it's worth, I'm close to publishing a white paper on 10.4 security. That paper mentions this issue. I would like to see Derby's security documentation overhauled. This is one among many important issues which are either miss

Re: GROUP BY can only be followed by a real column?

One way to solve this problem would be to group by the return value of a function which bins the time values into two buckets. Something like this: import java.sql.*; public class z { public static int isNull( Time time ) { if ( time == null ) { return 1; } else { return 0;

Re: Problems porting trigger from DB2

Hi Carlos, The fired SET statement does not look like a legal Derby statement to me. Maybe you could tackle your problem this way: 1) Declare the Categories table to have an autoid column 2) Then migrate your legacy data into Derby 3) Then use the ALTER TABLE ALTER COLUMN statement to reset

Re: How to return an array of String in a Java routine?

Hello, As you note, Derby does not support Array types. If you need to return a collection from a SQL routine, the following may help: 1) Transform the collection into a ResultSet. As Knut points out, you have two options here: a) Write a table function. b) Write a ResultSet-returning pro

Re: Importing delimited files with header

populate my Derby db. However, it took my class 1 hour to import a file but it only took one minute when I used SYSCS_UTIL.SYSCS_IMPORT_TABLE. Will extending FlatFileVTI work a quickly as using SYSCS_UTIL.SYSCS_IMPORT_TABLE? Thanks Rick Hillegas wrote: Hi Patrick, You can write a table

Re: Importing delimited files with header

Hi Patrick, You can write a table function to help you out here. Your table function will open your file, throw away the header, and then loop through the lines in the file. I would recommend extending something like FlatFileVTI (in Derby's demo directory). You can look at PropertyFileVTI (in

Re: Less Than Symbol

Hi Kai, Your insert statement runs fine for me: the complete html fragment is successfully stored. Perhaps Netbeans is intercepting the <. You might want to take your question to the Netbeans user list. Here's what I see running the following ij script: ij> create table notes ( note varchar

Re: How to store many large files in the database?

Christian Gruber wrote: Thanks for all the replys! I know it is not the best solution to store large files in a database, but it was the easiest in an ejb3 environment. My knowledge of the maximum file size seems to be a bit outdated. What I have found now is a sizelimit for Fat32 of 4 GB, NT

Re: How to retrieve the constraints associated to a table

fporto wrote: Narayanan-4 wrote: fporto wrote: Hi, I'm receiving the following message when trying to drop a table: ERROR X0Y25: Operation 'DROP CONSTRAINT' cannot be performed on object 'SQL080516103912600' because CONSTRAINT 'SQL080525110646121' is dependent on that object. I would

Re: How to store many large files in the database?

Hi Christian, Derby does not support partitioned tables. I think you will need to write your own logic to divide the attachments among many buckets--the buckets could either be a growing number of tables inside the database or files outside the database. Regardless of how you implement the bu

Re: using derby with ant's sql task

Hi Robert, You might be able to get what you want by writing a custom ant Task, i.e., a class which extends org.apache.tools.ant.Task. If you need some examples of how to do this, you can grep the Derby source tree for "PropertySetter" or "MessageBuilder". Hope this is useful, -Rick Robert

Re: PreparedStatement.toString() - nice formatting

k wbecker wrote: I wrote a fix for this, but seeing the comments at https://issues.apache.org/jira/browse/DERBY-3676 I am not sure its a good idea. Rick Hillegas-2 wrote: Hi Will, Thanks for bringing this up. I have logged DERBY-3676 to track this request. At first blush this looks like a strai

Re: Can I write a query that joins tables in two databases?

to use an outer join. That way I can join the full card table with the users collection table and show them both cards they do not have and the number of the cards they do have. Ian - Original Message From: Rick Hillegas <[EMAIL PROTECTED]> XA, by itself, will not solve the follo

Re: Replicating Derby Database Files

hanges) to the HA systems. What would be our options here to keep the Derby database up-to-date on the HA system? Thanks and Regards, Sai Pullabhotla On Thu, May 15, 2008 at 12:14 PM, Rick Hillegas <[EMAIL PROTECTED]> wrote: Hi Sai, Single-node master/slave replication with manual failo

Re: Replicating Derby Database Files

Hi Sai, Single-node master/slave replication with manual failover was added to Derby in version 10.4. You should not try to manually copy a Derby database which is in use. Hope this helps, -Rick Sai Pullabhotla wrote: Hello, We have a need to replicate Derby Database from the production sy

Re: PreparedStatement.toString() - nice formatting

Hi Will, Thanks for bringing this up. I have logged DERBY-3676 to track this request. At first blush this looks like a straightforward project for a newcomer. If you want to implement this yourself, I would be happy to coach you through the code. Regards, -Rick wbecker wrote: Is there a wa

Re: Can I write a query that joins tables in two databases?

Hi Ian, You can use Derby as an XA data source. There is a small section on this topic ("XA and the Network Server") in the Server and Administration Guide. There is also some related material in the section titled "J2EE Compliance: Java Transaction API and javax.sql Interfaces" in the Refere

Re: can't remove jar file from database (ERROR X0X13)!!!

fter every reboot every processes will be closed. The effect is always the same :( Regards && tnx for answer :-] Sebastian On Tue, May 13, 2008 at 3:30 PM, Rick Hillegas <[EMAIL PROTECTED]> wrote: Thanks for the detailed explanation, Sebastian. Now I think I am tracking you. Th

Re: can't remove jar file from database (ERROR X0X13)!!!

tabase will be stored in the jar directory of the database (e.g. My_databse/jar). If i'm wrong, please correct me. Regards Sebastian Pfaff On Tue, May 13, 2008 at 12:54 AM, Rick Hillegas <[EMAIL PROTECTED]> wrote: Hi Sebastian, I'm not sure I'm understanding your que

Re: can't remove jar file from database (ERROR X0X13)!!!

gards && tnx in advance Sebastian On Mon, May 12, 2008 at 6:23 PM, Rick Hillegas <[EMAIL PROTECTED]> wrote: Hi Sebastian, The following query will show you the names of the jar files loaded into your database: select s.schemaname, f.filename from sys.sysschemas s, sys.sysfile

Re: can't remove jar file from database (ERROR X0X13)!!!

Hi Sebastian, The following query will show you the names of the jar files loaded into your database: select s.schemaname, f.filename from sys.sysschemas s, sys.sysfiles f where s.schemaid=f.schemaid So, for instance, the following script runs like this for me: ij> call sqlj.install_jar( '/U

Re: Dropped procedure still cached?

Hi Tian, It sounds as though the old procedure class is stuck in Derby's classloaders. This topic comes up occasionally and the user guides should probably explain this better. 1) If your user-written procedures and functions live inside jar files which you have loaded into your Derby datab

Re: how to get names of column constraints ?

Hi Maris, When you declare a constraint, Derby creates a backing index for that constraint. If you do not explicitly name the constraint, then Derby will make up a name. The constraint name which Derby makes up is the same name that Derby gives to the backing index. If you don't name your con

Re: Concatenating two numbers as a string

Bogdan Calmac wrote: To concatenate two numbers in a string you have to do something like this (in derby 10.3): trim(char(min_value)) || trim(char(max_value)) This is pretty ugly, considering that it could have been as simple as: min_value || max_value Also, the documentation for the concaten

Re: Concatenating two numbers as a string

Bogdan Calmac wrote: To concatenate two numbers in a string you have to do something like this (in derby 10.3): trim(char(min_value)) || trim(char(max_value)) This is pretty ugly, considering that it could have been as simple as: min_value || max_value Also, the documentation for the concaten

Re: Spatial Indexing

Hi Kalyan, Derby does not support spatial datatypes. The question comes up often. I am certain that the community would be very supportive if someone wanted to add spatial datatypes to Derby. Regards, -Rick [EMAIL PROTECTED] wrote: Hello, I was wondering if Derby supports Spatial Indexing

Re: Encoding problem

Hi Łukasz, Can you give us some more information on what you can do in ij but not in your own Java client? Samples of the successful and unsuccessful code might help us better understand what's not working for you. Thanks, -Rick Łukasz Kaleta wrote: Hi, I have problem with getting data fr

Re: Paging Result Sets

Six Fried Rice wrote: On Apr 28, 2008, at 8:02 AM, Rick Hillegas wrote: The new 10.4 release provides support for the sql standard ROW_NUMBER function, which you can use for paging through query results. You can find this function documented in the ROW_NUMBER subsection of the "Bui

Re: Cannot Use DROP in ALTER Table in NetBeans 6.0.1 (Derby Integrated)

s creating and populating tables much faster. OR as an alternative, are there any GUIs available to work with bare JAVA-DB database like toad? Please let me know your suggestions. Thanks Dev. On Thu, May 1, 2008 at 6:38 PM, Rick Hillegas <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>

Re: Problem with stored procedure names

Hi Nicholas, I don't have anything smarter to recommend than the tried-and-true design pattern of a portability library. Here you would have an interface which abstracts out the differences between the databases which you have to support. In your case you would have two implementations of thi

Re: How to import data from external csv (i had it in mysql !)

Hi Mike, One solution would be to do this: 1) Create a dummy table with the same shape as your target table 2) Import the data into the dummy table 3) Copy from the dummy table into the target table but specify that you only want rows which won't generate collisions. Something like this: --

Re: Cannot Use DROP in ALTER Table in NetBeans 6.0.1 (Derby Integrated)

Hi Dev, Do you know what version of Derby you are using with Netbeans? Column dropping and renaming were added to Derby in release 10.3.1.4. Hope this helps, -Rick Devang kamdar wrote: Hi, I am trying to get started with Derby and Netbeans I am not able to use the DROP command. Getting fol

Re: SQLSyntaxErrorException:

Hi Brandon, I suspect that you need to put single quotes around the string value which you want to match in PDFNAME. Something like the following: select pdflocation from files where pdfname = 'foo' Without the single quotes, Derby thinks that foo is the name of a column and Derby objects t

Re: org.apache.derby.client.am.SqlException: A lock

Hi Shaoyong, For tips on how to avoid deadlocks, please see the "Deadlocks" section of the Derby Developer's Guide: http://db.apache.org/derby/docs/10.3/devguide/ Hope this helps, -Rick Shaoyong Wang wrote: We are using Derby 10.3.1.4. Occasionally, we saw the following error. Can anybody

Re: issues when connecting to a database

Hi Brandon, From the stack trace, it appears that the engine doesn't know where your database lives. From the server startup command and connection URL, it appears that Derby is looking for the database in the current directory of the server process. You can modify that startup command to poi

Re: median query

Hi Stephen, You may be able to write a user function to help. There's an example of a median-calculating user function in the "scores" demo. For an example of how to write and use this function, search for "getMedianTestScore" in the demo subtree of your Derby distribution (it should be availa

Re: Derby get-together at Java One

Mike Matrigali wrote: Knut Anders Hatlen wrote: Rick Hillegas <[EMAIL PROTECTED]> writes: A number of Derby people have expressed interest in getting together the week of Java One. I'm thinking that people may be busy attending sessions during Java One itself, so it might be bet

Re: Paging Result Sets

Hi Geoff, The new 10.4 release provides support for the sql standard ROW_NUMBER function, which you can use for paging through query results. You can find this function documented in the ROW_NUMBER subsection of the "Built-in functions" section of the 10.4 Reference Manual. Hope this helps,

Re: Let me know the default username and password of Derby

Sripada naresh wrote: Hi, This is Naresh. I want to know the Derby database default username and password. Please let me know it. Thanks & regards, -Naresh S. Hi Naresh, By default, Derby runs without user authentication. This means that there is no default username and password. Derby au

Re: limitation in stored procedure names

Hi Nic, The "." is used to separate identifiers in valid SQL names. For a schema object like a procedure, the name can have only one dot in it. The piece before the dot identifies a unique schema in the database and the piece after the dot identifies a unique procedure name inside that schema

Re: Problem with "order by"

Hi Brad, As Thomas points out, Derby hews closely to the SQL standard, which does not allow an ORDER BY clause in subqueries. The gnarly details of the standard grammar can be found here: http://savage.net.au/SQL/sql-2003-2.bnf.html Regards, -Rick Bradley Munz wrote: Hi there, I have a bi

Re: Derby-10.3.2.2 Release Date

Hi David, No-one has volunteered to produce another release from the 10.3 branch. At this time, engineers seem to be backporting fixes from the trunk to the 10.4 branch but I don't see a lot of backports to 10.3. You can, of course, check out the 10.3 branch yourself and build your own distr

Re: threads and derby

Hi Brandon, I can see that Kristian is already giving you excellent advice on this issue. You may also want to take a look at the large section titled "Controlling Derby application behavior" in the Derby Developer's Guide: http://db.apache.org/derby/docs/10.3/devguide/ In particular, you may

Re: Managing many databases

Six Fried Rice wrote: Rick: Thank you very much for your responses. I have a few followup questions below: On Apr 15, 2008, at 1:03 PM, Rick Hillegas wrote: Please take a look at the section titled "Accessing a read-only database in a zip/jar file" in the Derby Developer'

Re: Managing many databases

Hi Geoff, You have asked a lot of interesting questions. I will try to give you some feedback on some of your questions. Hopefully others can provide more information. Please see my responses inline... Six Fried Rice wrote: I'm a first-time poster so I hope I'm following protocol here. I se

Re: Derby get-together at Java One

Mike Matrigali wrote: Knut Anders Hatlen wrote: Rick Hillegas <[EMAIL PROTECTED]> writes: A number of Derby people have expressed interest in getting together the week of Java One. I'm thinking that people may be busy attending sessions during Java One itself, so it might be bet

Re: viewing table structure

Hi Brandon, The Derby interactive sql tool, ij, supports a describe command, which you can use to display the structure of tables and views. You can find an explanation of this command in the "ij commands and errors reference" section of the Derby Tools and Utilities Guide: http://db.apache.o

Re: Derby get-together at Java One

day sounds good to you. Thanks, -Rick Rick Hillegas wrote: I suspect that a lot of Derby users and developers will be in San Francisco for Java One this year (May 6-9, http://java.sun.com/javaone/sf/). This would be a great opportunity to get together, connect faces with names, and gener

Re: load data from comma delimeted file into derby

Brandon Dohman wrote: I can’t manage to find the information that I used previously on how to load data from a comma delimited file into derby. Could someone either provide the code, or the link to the information on it. Thanks No virus found in this outgoing message. Checked by AVG.

Re: Boolean data type

rse. Where can I find the DERBY-499 issue? I'm new to this list so just starting to learn the ropes. Bayless - Original Message - From: "Rick Hillegas" <[EMAIL PROTECTED]> To: "Derby Discussion" Sent: Monday, April 07, 2008 7:32 AM Subject: Re: Boolean data

Re: Boolean data type

Hi Bayless, DERBY-499 is an issue which tracks the work needed to add a boolean datatype to Derby. A functional spec has been written for this issue, but no-one has volunteered to do the work. The boolean datatype will not appear in the upcoming 10.4 release which is now being tested. Regard

Re: resultsets from stored procedures?

Stanley Bradbury wrote: David Parker wrote: I would like to be able to create a java stored procedure that returns a ResultSet. Ideally, I would be able to call this as a function from within an SQL statement. The application requires that given a parent-child relationship where a given row

Re: Newbie question

Hi Chris, I may be misunderstanding your question so please bear with me. The upcoming 10.4 release of Derby will provide a feature called Table Functions. This will let you make your external data look like a table to Derby so that you can issue SELECTs against it. The feature is described b

Re: STDDEV for Derby

Hi Art, Can you tell us what section of the Reference Guide makes this claim? The old Cloudscape engine offered syntax for creating user-defined aggregates but that machinery does not work in Derby. There is a JIRA for this feature: DERBY-672. You may be able to do what you need by using Derb

Re: Migrating from Postgresql to Apache Derby

Forums @ Existanze wrote: Rick Hillegas wrote: Forums @ Existanze wrote: Hello all, As the subject reads, my development team and I are trying to migrate to apache derby, because we will start deploying our application with the database embedded, instead of having the hassle of installing a

Re: Migrating from Postgresql to Apache Derby

Forums @ Existanze wrote: Hello all, As the subject reads, my development team and I are trying to migrate to apache derby, because we will start deploying our application with the database embedded, instead of having the hassle of installing a database on each client. Following are some of my

Re: Storing array in database

Hi Varun, The getArray() and setArray() methods are part of the JDBC api and they operate on the SQL Array datatype. Derby does not support this datatype so these methods throw "not implemented" exceptions as Narayanan said. The supported datatypes are described in the Derby Reference manual i

Re: Derby get-together at Java One

Hi Mike, I agree. We should meet somewhere that doesn't require a Java One pass. Regards, -Rick Mike Matrigali wrote: I would be interested in attending but may not have a javaone pass, so would be nice if the location was somewhere nearby but not need a javaone pass to attend.

Derby get-together at Java One

I suspect that a lot of Derby users and developers will be in San Francisco for Java One this year (May 6-9, http://java.sun.com/javaone/sf/). This would be a great opportunity to get together, connect faces with names, and generally talk about what we're all doing and what we want out of Derb

Re: Index Names

Chris wrote: I'm wanting to drop a row/record/index in my Derby Embedded installation (pre-installed in ColdFusion 8 Developer's Edition), but the index-names aren't as simple as I had originally assumed (0, 1, 2,...). I visited http://db.apache.org/derby/docs/10.3/ref/rrefsqlj59893.html to

Re: java.security.AccessControlException doing a file write

Hi Brad, Writing a valid security policy file can be a bit tricky. I am not sure that you have identified the codebase of your jar file with a legal URL. I would expect to see some double slashes in the URL. The following kind of URL works for me: grant codeBase "file:///opt/DerbyTrunk/jars/

Re: DERBY-3216 reopen?

James A. Shepherd wrote: Hi, I added a comment to DERBY-3216 that means I believe it still affects released version 10.3.2.1. Currently DERBY-3216 is closed. Can someone reopen it please, or should I file a new jira? https://issues.apache.org/jira/browse/DERBY-3216?focusedCommentId=1256

Re: java.sql.SQLDataException: The resulting value is outside the range for the data type DOUBLE.

Hi Hong, The max and min values of the Derby double datatype are not the max and min values of the Java double type. The Derby behavior is documented in the Derby Reference Guide in the section titled "DOUBLE PRECISION data type". Here's what that section says: "DOUBLE value ranges: * Sm

Re: Installing and Using Java Procedures.

[EMAIL PROTECTED] wrote: Briggs <[EMAIL PROTECTED]> writes: Hey, thanks for your reply. I am still way confused on this. And trying to find examples of the SQL/JRT spec is almost impossible. I am trying to make some sense of the examples of creating store procedures off the http://wiki.ap

Re: Rename Schema

Hi Raymond, Derby does not provide a command to rename a schema. Tables, columns, and indexes can be renamed but not schemas. Regards, -Rick Raymond Kroeker wrote: I would like to know if it is possible to rename a schema; if anyone has tried it; and what their results were. I've looked fo

Re: Case-Insensitive Unique Constraint

Hi Sai, This problem comes up frequently. One solution to it is an unimplemented feature called computed columns (see DERBY-481). Hopefully, we can raise the visibility of that issue. In the meantime, I think that changing your INSERT and UPDATE code is a good approach. You can give yourself

Re: Fwd: [nbusers] Issues with Derby in customer classloader using Java 6

Hi David, Do you know what version of Derby is being used and what the error is? Does the problem occur if they user Derby 10.1? When running 10.2 or 10.3 on Java 6, Derby uses different JDBC implementations. There could be some problem there. Regards, -Rick David Van Couvering wrote: Hi,

Re: Using Derby's VTI

Hi Andreas, Some comments inline... Andreas Haufler wrote: Hi there, we're trying to use Derby's VTI interface in order to integrate Derby with Lucene. I already saw some efforts to integrate Lucene via "normal" function calls, but I think, using the VTI is a better approach. However, I only f

Re: Copy varchars from table A to Blobs in Table b?

Hi Jim, Derby, complying with the ANSI SQL standard, does not allow you to cast non-BLOB to BLOB. The ANSI rules are documented in part 2 of the 2003 SQL standard, section 6.12. The Derby behavior is documented in the Derby Reference Guide section titled "Data type assignments and comparison,

Re: Failed to start database

und out that another application by whatever reasons tries to make a shutdown in the described situation. I wonder if this trial could result in a database crash - eventually afterwards when the other application does the shutdown. It would explain why I am observing the recovery problem so often. R

<    4   5   6   7   8   9   10   11   >