Re: help with a Cloudscape/Cloudsync issue...
Hi, Will, Cloudscape 4.0 (and 5.x) pre-date Derby. Perhaps you might try the IBM developerWorks Cloudscape forum: http://www.ibm.com/developerworks/forums/forum.jspa?forumID=370 regards, -jean Will Landymore wrote: Just wondering if someone can help me on this one…. …Using Cloudscape 4.0 and when there is a failure of the refresh of the data/database, Cloudscape will write the username/password of the account being used to the log in clear text. Is there a good way that you can stop this from happening? *Will Landymore* ( Tel: +1 903 939 7040 ( Cell: +1 903 590 0542 **%** Skype: [EMAIL PROTECTED] This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient, please do not copy this message or attachment or disclose the contents to any other person. This e-mail and any attachments have been scanned for certain viruses prior to leaving Mercy Ships. However, Mercy Ships will not be liable for any losses as a result of any viruses being passed on.
Re: Apache license question
The FAQs on this page might help you: http://www.apache.org/foundation/licence-FAQ.html regards, -jean On Wed, 9 Jan 2008 22:12:05 -0800 (PST), Gavin Bong [EMAIL PROTECTED] said: If I write another piece of software using some code from apache derby, and license the derivative work under Apache license; what do I need to add in the header of the source code ? What I am thinking of doing: a) Include the original license file from the source file. b) Include as comments, a description of the changes made e.g. change package address to my local package. Is this sufficient? Did I violate anything? Thanks G -- View this message in context: http://www.nabble.com/Apache-license-question-tp14728253p14728253.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: Successful Delivery
congratulations! and thanks for letting the derby community know about this! -jean Donald McLean wrote: I just wanted to throw in a little Rah! Rah! here. On December 3rd, we went live with the first version of our software that uses Derby and Hibernate for persistent storage. We have learned quite a few things on this journey, some of which are reflected in the implementation of DatabaseManager that is posted on the Wiki. Some of the more interesting lessons such as the mechanism we implemented to update the database of our live application and how we handle multiple user threads came afterwords. Unfortunately, I can't post that code (the version of DatabaseManager on the Wiki was developed independently) however, if anyone is interested, I might be talked into writing a short paper. I would like to throw a big thank you to all of the Derby developers. Without this product this delivery would probably have been much more painful. Donald McLean P.S. The application is a tool used by astronomers who are preparing their proposals for time on the Hubble Space Telescope.
Re: Database manager for Java DB/Apache Derby?
David Van Couvering wrote: You can also try NetBeans (shameless plug) :) hey, any and all plugs are great! Let's make sure they are all on the wiki (I know NetBeans is). -jean On Dec 11, 2007 8:23 AM, Jean T. Anderson [EMAIL PROTECTED] wrote: larsk wrote: Does anyone know a great and free database manager software with GUI for Java DB/Apache Derby where I can create and open databases? Something like Mysql Administrator and Mysql Query Builder for Mysql. Thanks in advance! I continue to hear good things about SQuirrelSQL and a couple others. Resources are listed on these pages: http://wiki.apache.org/db-derby/UsesOfDerby http://wiki.apache.org/db-derby/WorkingWithDerby I hope you find something you like, -jean
Re: Links to ApacheCon presentations (was ApacheCon presentation on Table Functions)
John Embretsen wrote: Jean T. Anderson wrote: Jeanfrancois Arcand and Francois Orsini also did a presentation -- if a link to it is available, please post and I'll add it to the page. I believe the slides are available here: http://mediacast.sun.com/share/forsini/20071114_RIA_Comet_Derby_04.pdf (link copied from Francois' blog: http://blogs.sun.com/FrancoisOrsini/entry/developing_real_time_ria_with ) thanks! It should be visible on the web site in an hour or so. cheers, -jean
Links to ApacheCon presentations (was ApacheCon presentation on Table Functions)
On Mon, 19 Nov 2007 08:03:38 -0800, Rick Hillegas [EMAIL PROTECTED] said: The next feature release of Derby, 10.4, will provide a new feature, table functions. This feature will let you use SQL to slice, dice, and zipper together data sets which live outside Derby. I talked about this feature at ApacheCon last week. You can find my presentation at: http://people.apache.org/~rhillegas/vtiDemo/doc/saucerSeparation.html thanks, Rick -- I initialized an ApacheCon US 2007 section on this page and added your link to it: http://db.apache.org/derby/papers/ApacheCon.html Jeanfrancois Arcand and Francois Orsini also did a presentation -- if a link to it is available, please post and I'll add it to the page. thanks, -jean -- Jean T. Anderson [EMAIL PROTECTED]
Transactions and XA support with client jdbc driver
I'm at ApacheCon in Atlanta where I responded to a user's question that I figured it'd be good to run by the list because I was relying solely on memory. The question had to do with transaction management. The user thought that Derby only supports transactions in embedded mode (does not support transactions with the client jdbc driver), and there was further confusion between sql transactions and xa support. Here's what I said 1) Derby has always supported sql transactions in both embedded and client modes, regardless of the client jdbc driver being used. 2) XA has to do with managing distributed transactions (i.e., two phase commit). Embedded has always supported that. The Derby client jdbc driver supports it. The db2 jcc driver does not support that for derby. (I was suspected confusion left over from the early days before Derby had the client driver and the only client/server option was to download the db2 driver). how close was my answer to reality? thanks! -jean
Re: Migrating a MySQL Database to Apache Derby
Bryan Richardson wrote: Hello all, Can anyone tell me how I can migrate a MySQL database to Apache Derby? Can ij do this? If so, is there a tutorial? If not, is there still a way? Thanks in advance! -- BTR Depending on your mysql release and what you specifically need to do, ddlutils might be an easy way to do this. A derby tutorial is here: http://db.apache.org/derby/integrate/db_ddlutils.html Info about ddlutils support for mysql is here: http://db.apache.org/ddlutils/databases/mysql.html The Derby tutorial walks through building ddlutils, but that's no longer necessary because you can now download the ddlutils release: http://db.apache.org/ddlutils/download.html I'll try to update the derby tutorial soon to use the ddlutils download instead of build it. regards, -jean
Re: how to select all table names of some database in derby?
On Sun, 24 Jun 2007 01:20:24 +0800, amadis [EMAIL PROTECTED] said: Hi, derby-user i created a table in derby, but i forgot the name of the table, is there any sql that can show all the names out? This wiki page has a sql query that might help: http://wiki.apache.org/db-derby/ListTableNames It also mentions the ij 'show tables' command that was introduced with 10.2. -jean p.s. That wiki page is linked from this general hintstips page: http://wiki.apache.org/db-derby/HintsAndTips
Re: stored procedure in java db
Victor Muñoz wrote: queria saber como se realiza un procedimiento almacenado(stored procedure) en java db, su estructura y a la vez como se llama al procedimiento para poder ocuparlo I hope this page might help -- espero que esta pagina ayude: http://wiki.apache.org/db-derby/DerbySQLroutines regards, -jean
Re: How do I Open / Close a db using odbc interface?
m96 wrote: hi, checkout [3]. since i had a crashing and freezing problem with odbc connections from MS Query and Brio i couldn't test it if it also works from ODBC. just check your derby log to see if the db is booted and shutdown. cheers... [3] http://db.apache.org/derby/manuals/reference/sqlj251.html That's a 10.0 doc pointer, which is probably up to date for shutdown=true, but here's the current 10.2 link anyhow: http://db.apache.org/derby/docs/10.2/ref/rrefattrib16471.html And here's the html head for the 10.2 reference manual: http://db.apache.org/derby/docs/10.2/ref/ -jean On Sun, 2007-06-03 at 04:44 -0700, yarono wrote: by open / close I mean that after I started the connection and created a db and inserted values to a table, I want to close the db (save it to file) and the later on be able to open the file and get the db as it was at the point of closure. m96 wrote: hi, what do you mean with open/close? just start your network server as described in the tutorial [1] and configure your odbc connection with IBM DB2 connect [2] and connect to your db like any other db. cheers... [1] http://db.apache.org/derby/papers/DerbyTut/ns_intro.html [2] http://www-306.ibm.com/software/data/db2/db2connect/ On Sun, 2007-06-03 at 01:29 -0700, yarono wrote: I looked through the manuals and api guides, but was unable to find how do I close / open a db in odbc interface. Could someone please reply with a refernce to the answer? or just reply with the answer? thanks in advance, Yaron
Re: license question
Michael Segel wrote: ... Derby is licensed under the Apache license. Its pretty much open. You can do pretty much anything you want, as long as you attribute Apache somewhere in your code. (You'd have to see the requirements...) But you are free to Derive and re-license the code... Mike's answer is on target. For anyone wanting an Apache reference, see this: http://www.apache.org/foundation/licence-FAQ.html#WhatDoesItMEAN -jean
Re: can't call a stored procedure
hk wrote: I tried to call a sampe stored procedure, but I got an error message saying Error code -1, SQL state 42X51: The class 'routines_jar:store' does not exist or is inaccessible. This can happen if the class is not public. SQLSTATE: XJ001: Java exception: 'routines_jar:store: java.lang.ClassNotFoundException'. Line 3, column 1. I had made a public class and a public static method, which is called store and dropTable respectively, made a jar file, which is called Javalibrary1.jar, and installed the jar file with the sqlj.install_jar using a jar name routines_jar into a database. And, then I had createad a stored procedure with external name routines_jar:store.dropTable, which is called DROP_TABLE, and called the stored procedure Drop_TABLE with a parameter. Then, I got an error message above, which basically is saying The class 'routines_jar:store' does not exist or is inaccessible. I was trying to figure out the problem, but stiil I coudn't. What would be the problem? help me, please. This page on the wiki points to some working examples: http://wiki.apache.org/db-derby/DerbySQLroutines I wonder if one of them in particular might help -- it's a pointer to a post that shows how to drop table in a procedure [1]. If not, I suggest you post your java code, if that's possible (but don't post anything proprietary), and the SQL statements you use to create the procedure and install the jar file in the database. regards, -jean [1] http://mail-archives.apache.org/mod_mbox/db-derby-user/200510.mbox/[EMAIL PROTECTED]
Re: Derby (Java DB) vs. HSQLDB
David Van Couvering wrote: I thought you all would like to see this thread. http://www.nabble.com/HSQLDB-or-JavaDB-tf3768495.html more re h2: http://kasparov.skife.org/blog/src/java/h2-aci.html -jean
Re: wrong file path in derby tutorial
Lars Aurbakken wrote: Hi. The file path: 'cp $DERBY_INSTALL/demo/simple/SimpleApp.java .' on page: http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html isn't correct for derby version 10.2.2.0. It should be: '$DERBY_INSTALL/demo/programs/simple/SimpleApp.java .' Thanks for the correction, Lars. The change will be visible in about an hour (apache web sites sync up with the changes we make on an hourly schedule). -jean
Re: Urgent_help_How_to_start
rania sabbagh wrote: Dear all, I'm Rania Al-Sabbagh. I am trying to install derby on my computer which works according Windows XP plateform. I am totally a beginner so I do not know what to do to install it. I tried to read the manual abouthow to get started but I could not understand anything. SO can anyone tell me how to install it and where to write what?? I urgently need this for a study project and I'm running out of time. Hi, Rania, The Working With Derby and Getting Started guides might help if you haven't found those yet: http://db.apache.org/derby/docs/10.2/workingwithderby/ http://db.apache.org/derby/docs/10.2/getstart/ Also, the wiki lists a bunch of resources, including tutorials for various environments: http://wiki.apache.org/db-derby/WorkingWithDerby I hope these help. regards, -jean
Re: Is DdlUtils good for transfering data from Oracle to Derby
Peter Neu wrote: Hello, has anybody worked with DdlUtils, Derby and Oracle? I would like to transfer data from an Oracle DB to Derby is DdlUtils the right tool to use? Problem is I also have some stored procedures which I need to port to Derby. Any chance of doing this? Derby doesn't have anything like Oracle's pl/sql (if that's still what it's called these days -- I last used Oracle about 15 years ago). Derby only supports SQL procedures and functions implemented in java; more info is here: http://wiki.apache.org/db-derby/DerbySQLroutines There's a proposal for adding support for procedures implemented in SQL: http://wiki.apache.org/db-derby/SqlPsmSupport But I don't recall seeing any action on that proposal yet. -jean
Re: function in derby[beginner]
Tony Winslow wrote:
I have this class:
public class Say {
public static int say(int i) {
System.out.println(* Say: + i);
return i;
}
public static int say2(String msg) {
System.out.println(** + msg);
return 1;
}
}
and I created a function in Derby:
create function say2(msg varchar(50)) returns integer
parameter style java no sql language java
external name 'Say.say2';
but when I want to use it, error occurs:
ERROR 42X50: No method was found that matched the method call
Say.say2(java.lang
.String), tried all combinations of object and primitive types and any
possible
type conversion for any parameters the method call may have. The
method might e
xist but it is not public and/or static, or the parameter types are
not method i
nvocation convertible.
Can you show the exact SQL statements that you tried to execute and that
got error 42X50?
Also, what version of Derby are you using? This command will output
version info for all releases of derby:
java org.apache.derby.tools.sysinfo
regards,
-jean
And I created another function:
create function say(i integer) returns integer
parameter style java no sql language java
external name 'Say.say';
It works fine.
I've tried hard to figure it out but failed. Can anybody help me?
Thank you in advance!!!
Re: [n00b] Stored Procedures and SQL
John C. Turnbull wrote: I am just looking at Derby for the first time and it seems to me that although stored procedures are supported they are not written in actual SQL but rather Java statements instead. Is this correct? Yes, that's correct. More info is on the wiki here: http://wiki.apache.org/db-derby/DerbySQLroutines Are there plans to support more conventional SQL-based stored procedures in the future? A proposal has been posted to the wiki: http://wiki.apache.org/db-derby/SqlPsmSupport cheers, -jean
Re: DB design tool?
ndario wrote: Hello, I am interested in what tool (preferably free) do you use for designing derby datatabses? I am looking for a tool taht will enable me to draw tables and relationships, enter columns and datatypes and generate derby dialect of SQL with create table statements to create database. You might find some resources on these wiki pages: http://wiki.apache.org/db-derby/UsesOfDerby http://wiki.apache.org/db-derby/WorkingWithDerby regards, -jean
Re: Derby Usage
Sedillo, Derek (Mission Systems) wrote: Hello, Is there an online forum where Derby is discussed such as through Google Groups? Where can I post a question about Derby usage? Hi, Derek, Apache uses mail lists for its projects -- more info about how it works is on the derby web site [1]. At any rate, this list (derby-user@db.apache.org) is the right place to ask questions about Derby usage, so please post your questions here. cheers, -jean [1] http://db.apache.org/derby/derby_mail.html Thank you, Derek Sedillo SWAFS DBA / Software Engineer Northrop Grumman Missions Systems Tel: (719) 570-8256
Re: How to execute optimizer overrides in a java app
Daniel John Debrunner wrote: Jean T. Anderson wrote: ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB --derby-properties index=IDX1 \r order by num); Is there any feedback on using the \r ? In the back of my mind I'm thinking that won't be portable between Windows and Unix. \n is the unicode newline character in Java. There is no portability concerns here, this code is creating a newline in a Java unicode string which is then passed to Derby's unicode parser. The string constant will be stored in the class file which is platform independent. excellent, thanks. I agree with Mamta and Bernt that /* ... */ comment blocks would be nice (DERBY-1749). In the meantime, we can at least provide solid instructions. -jean
Re: How to execute optimizer overrides in a java app
Mamta Satoor wrote: Jean, what you are experiencing is the expected behavior. Hi, Mamta, Yes -- sorry I should have been more clear in my post. It's clearly documented that the derby-properties clause must come in the right place (ie. after the table name to specify the index) and that it must be at the end of the line. In my post I should have said I also showed two queries that are expected to get syntax errors. --I'm not sure that sample invalid syntax needs to be put into the docs. Is there any feedback on using the \r ? In the back of my mind I'm thinking that won't be portable between Windows and Unix. -jean In Derby, everything after the comment delimiter which is -- is considered a comment and not part of the sql. Optimizer override is just a special comment with it's own syntax rule. And the syntax rule for optimizer overrides expects propertyname=value. When a user specifies --derby-properties index=IDX1 order by num, Derby determines that is an optimizer override. index=IDX1 follows the syntax rule of optimizer override but the string order by num and hence the user will see a syntax error. A Jira issue for java example in the docs would be great. If you have any other feedback on the optimizer override doc page, please post that too. Thanks, Mamta On 3/9/07, Jean T. Anderson [EMAIL PROTECTED] wrote: I got a question today on how to do optimizer overrides in a java app and thought I would post my answer here to verify what I said was correct and see if anyone has better ideas on how to do it. The docs [1] have good examples that can be run from ij, but it wasn't clear to the user how to execute them in a java app. The main sticking poing was the optimizer override must be in a comment at the end of the line. I modified the SimpleApp.java that comes with the Derby distribution to add two indexes: s.execute(create index IDX1 on derbyDB(num)); s.execute(create index IDX2 on derbyDB(addr)); I showed two queries that work (notice how there must be a carriage return after the comment in the second query): ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB --derby-properties index=IDX1); ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB --derby-properties index=IDX1 \r order by num); The \r worked, but is there a better way to do this? I also showed two queries that get syntax errors. This query gets an error because there isn't a carriage return after the --derby-properties clause and before the order by clause: ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB --derby-properties index=IDX1 order by num); This query gets a syntax error because the --derby-properties clause must come after the table name: ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB order by num --derby-properties index=IDX1); Any suggestions/corrections? I'll open a Jira issue with a java example to add to the existing docs. thanks, -jean [1] http://db.apache.org/derby/docs/dev/tuning/ctunoptimzoverride.html
Re: How to execute optimizer overrides in a java app
Bryan Pendleton wrote: In my post I should have said I also showed two queries that are expected to get syntax errors. --I'm not sure that sample invalid syntax needs to be put into the docs. Is there any feedback on using the \r ? In the back of my mind I'm thinking that won't be portable between Windows and Unix. I've wondered about this syntax in the past, so I'm happy to see you exploring the details of its behavior. Thanks! Perhaps you could package up your various example queries as a complete test program, and then add it to the test suite, and then we'd run it on lots of different platforms. That would help us figure out if there are any platforms where it doesn't work. Having a regression test for this would also: 1) Capture the sample invalid syntax in the tests, which is maybe a better place for it to live than in the docs 2) Ensure that the documented behavior continued to work, and didn't accidentally get broken at some point in the future. I guess this is a long way to say that I think you've written a valuable new regression test, and to encourage you to contribute it to the test suite. heh, just goes to show the power of simple modifications to Derby's SimpleApp.java program. :-) Sure, I can do that. -jean
How to execute optimizer overrides in a java app
I got a question today on how to do optimizer overrides in a java app and thought I would post my answer here to verify what I said was correct and see if anyone has better ideas on how to do it. The docs [1] have good examples that can be run from ij, but it wasn't clear to the user how to execute them in a java app. The main sticking poing was the optimizer override must be in a comment at the end of the line. I modified the SimpleApp.java that comes with the Derby distribution to add two indexes: s.execute(create index IDX1 on derbyDB(num)); s.execute(create index IDX2 on derbyDB(addr)); I showed two queries that work (notice how there must be a carriage return after the comment in the second query): ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB --derby-properties index=IDX1); ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB --derby-properties index=IDX1 \r order by num); The \r worked, but is there a better way to do this? I also showed two queries that get syntax errors. This query gets an error because there isn't a carriage return after the --derby-properties clause and before the order by clause: ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB --derby-properties index=IDX1 order by num); This query gets a syntax error because the --derby-properties clause must come after the table name: ResultSet rs = s.executeQuery( SELECT num, addr FROM derbyDB order by num --derby-properties index=IDX1); Any suggestions/corrections? I'll open a Jira issue with a java example to add to the existing docs. thanks, -jean [1] http://db.apache.org/derby/docs/dev/tuning/ctunoptimzoverride.html
Re: Derby has been listed on Count From Zero
Hi, Olinga, At http://www.countfromzero.com/package/Derby ... The URL for the 10.2.2.0 download is incorrect (it's pointing to the 10.1.2.1 download). I suggest this URL so the most recent release will always be visible: http://db.apache.org/derby/derby_downloads.html Additional categories: top:databases:relational database * a summary description (two lines) Apache Derby is a relational database implemented entirely in Java. * a full description (any length) Taken from http://projects.apache.org/projects/derby.html: Apache Derby is an open source relational database implemented entirely in Java. It has a small footprint that makes it easy to embed in any Java-based application, but it also supports the more familiar client/server mode. It is based on the Java, JDBC, and SQL standards, making code developed more portable to standards-compliant databases. * software Derby depends on Java Runtime Environment (JRE) or Java Development Kit (JDK) * your real name ... Could you reference derby-user@db.apache.org instead? regards, -jean Olinga K. Abbott wrote: Hello! Your software, Derby, has been selected for inclusion in Count From Zero (CFZ, http://www.countfromzero.com). CFZ indexes libraries and tools for software engineers. You will find the data CFZ publishes for Derby at http://www.countfromzero.com/package/Derby. This data includes website: http://db.apache.org/derby/ version: 10.2.2.0 date: 2006-12-19 If someone else could respond better to this message please forward it to them and/or let me know. CFZ supports hierarchical categorization and multiple categories per software package. For example, if a user wants software for part-of-speech tagging they can find it under artificial intelligence: natural language processing: part-of-speech tagging (http://www.countfromzero.com/category/part-of-speech_tagging_POS_tagging) and a package listed there might also be found under artificial intelligence: natural language processing: shallow parsers (http://www.countfromzero.com/category/shallow_parsers) if applicable. Please examine the page at http://www.countfromzero.com/package/Derby and reply to this message with * corrections, such as new versions, improper categorization, or additional categories. * a summary description (two lines) * a full description (any length) * software Derby depends on * your real name if you feel comfortable providing it. CFZ requires your permission to release your name or email address unless under legal obligation. CFZ is beta-stage and possesses many rough edges but I hope it will already prove beneficial to you and your users. Sincerely, Olinga K. Abbott www.countfromzero.com [EMAIL PROTECTED]
Re: ODBC and Derby
Tomás Martínez Soldevilla (BBI) wrote: Hallo, I try to connect the DBDesigner with the Derby database. How is possible to access the Derby via ODBC ? This wiki page lists products that provide ODBC connectivity: http://wiki.apache.org/db-derby/UsesOfDerby Look for ODBC Drivers in the Products By Type section. regards, -jean
Re: Security in Derby
Alexander Trauzzi wrote:
...
Also, where, when and how do I use this security file?
there's a little walk through on this starting on slides 36-38 of this
presentation:
http://db.apache.org/derby/binaries/jta-WE15.pdf
hth,
-jean
Again, much of the explanation of these things in Derby seems left to the
Java spec that they conform to - which isn't always the most user friendly.
- Alex
On 2/20/07, Rick Hillegas [EMAIL PROTECTED] wrote:
Hi Alexander,
In terms of using a Java Security Manager, there will be better
out-of-the-box support for a secure network server in the next feature
release (10.3). That work is tracked by
https://issues.apache.org/jira/browse/DERBY-2196. Right now, you can
grab a generic policy file from the development codeline at
java/drda/org/apache/derby/drda/server.policy. I will mouse that file
into my reply. You will need to customize some variables in that file in
order to fit it to your particular environment. I hope this helps.
Here's the moused-in server policy file:
grant codeBase ${derby.install.url}derby.jar
{
//
// These permissions are needed for everyday, embedded Derby usage.
//
permission java.lang.RuntimePermission createClassLoader;
permission java.util.PropertyPermission derby.*, read;
permission java.io.FilePermission ${derby.system.home},read;
permission java.io.FilePermission ${derby.system.home}${/}-,
read,write,delete;
//
// This permission lets you backup and restore databases
// to and from arbitrary locations in your file system.
//
// This permission also lets you import/export data to and from
// arbitrary locations in your file system.
//
// You may want to restrict this access to specific directories.
//
permission java.io.FilePermission ALL FILES, read,write,delete;
};
grant codeBase ${derby.install.url}derbynet.jar
{
//
// This permission lets the Network Server manage connections from
clients.
//
permission java.net.SocketPermission ${derby.drda.host}:*, accept;
};
Alexander Trauzzi wrote:
Greetings to all the Derbites in mailing list land. I have a rather
simple, but potentially complicated question.
I grabbed a copy of the latest derby-bin distribution. I ran the
scripts required to run it as a network server, just as a quick little
test in the console.
The first concern I have is that anyone seems to have the ability to
connect to my server and create databases?
I did a bit of searching with Google and also within the derby site
and came up with all kinds of very complicated and confusing
recommendations to secure a server. Some were in the manual,
referring to authentication, others involved using a Java security
manager. Neither of which were explained in such a way that I could
easily absorb or put into practical use. Especially the Java security
manager.
Is there any resource that is straightforward, concise and simple that
can help me set up a derby network server that authenticates based on
username/password pairs? I'm talking MySQL-easy (anyone can set up a
MySQL server!).
Thank you to all who reply...
- Alexander Trauzzi
Re: Does anyone tested policy file usage in derby 10.2.2 ?
legolas wood wrote:
Hi
Thank you for reading my post.
Does any one tried and used derby under a security manager a a policy file?
I tried to use it under a security manager and a policy file but my
policy file never take effect.
indeed derby ignored any policy that i defined.
is there any sample policy file out there? I tries sample policy file
which is included in Derby reference? and it does not take affect.
one thing that has tripped me up in the past is I copied the sample
policy file *exactly* :
grant codeBase file://f:/derby/lib/derby.jar {
... deleted for brevity ...
}
There's no f drive on any of my systems. :-) So be sure to change that
line to specify the full path on your system.
-jean
Re: Derby fully sql-2003 compliant?
Christian Lang wrote:
Hi,
I'm trying to understand which SQL language subset Derby is using. I
...
The Derby Wiki has a page that provides details about SQL support:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures
There's also a page that provides JDBC details:
http://wiki.apache.org/db-derby/JDBCSupport
regards,
-jean
installed version 10.2.2.0 and tried to compile and execute the following
statement:
SELECT MIN(A) OVER (PARTITION BY B) FROM C;
(which seems a legal SQL-2003 statement). However, the Derby sql compiler
complains about the '(' after the 'OVER' keyword.
I looked into the sqlgrammar.jj file and could not find a partition or
over keyword at all. Is this not supported (yet)?
Or am I doing something wrong?
Thanks for clarifying,
Christian
Re: Java Stored Procedures
Tim Troup wrote: Hi, Sorry my fault I got my classpath screwed up. Sorted it and now there are no errors. Ideally I would like to store the jar file in the database and load the classes from there. I believe I can do this by setting the derby.database.classpath property. However, I see no mention of this property in the tuning derby guide: http://db.apache.org/derby/docs/dev/tuning/ctunproper22250.html Hi, Tim, The developer's guide has the information you're looking for: http://db.apache.org/derby/docs/10.2/devguide/cdevdeploy30736.html There are two separate steps: 1) install the jar http://db.apache.org/derby/docs/10.2/devguide/cdevdeploy23812.html 2)set derby.database.classpath http://db.apache.org/derby/docs/10.2/devguide/cdevdeploy21645.html The Wiki also includes an example of installing a jar and setting derby.database.classpath: http://wiki.apache.org/db-derby/DerbySQLroutines regards, -jean Thanks, Tim On 29 Jan 2007, at 22:33, Tim Troup wrote: Hi, I have created some stored procedures in Java, compiled the classes, packaged them in a jar file and added the jar file to my classpath. When I try and create a trigger which invokes the stored procedure I get a ClassNotFound error: ij CREATE PROCEDURE CALC_SCORE( IN COPUBID INTEGER ) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'uk.ac.ed.med.textmining.procedures.CalcScore.calcScore'; ij CREATE TRIGGER SCORETRIG AFTER INSERT ON COPUB REFERENCING NEW AS COPUB FOR EACH ROW MODE DB2SQL CALL CALC_SCORE(COPUB.ID); ERROR 42X51: The class 'uk.ac.ed.med.textmining.procedures.CalcScore' does not exist or is inaccessible. This can happen if the class is not public. SQLSTATE: XJ001: Java exception: 'uk.ac.ed.med.textmining.procedures.CalcScore: java.lang.ClassNotFoundException'. How do I make the Java stored procedures available to Derby? Thanks, Tim
Re: Embedded system
Guy wrote: Hi mohamad, Derby can be both: you can use it as an embedded database or you can use it as a client-server system. There is plenty of good documentation around (included in the distribution) or maybe this tutorial helps: http://db.apache.org/derby/papers/DerbyTut/index.html thanks for the reminder about this tutorial, Guy. Right now it assumes that the user has downloaded Derby 10.1.2.1. The 10.2.2.0 release will work with it as well. I'd like to point out that 10.2 adds a new derbyrun.jar, which simplifies setting up CLASSPATH and invoking tools such as ij: http://db.apache.org/derby/docs/dev/tools/rtools1003161.html http://db.apache.org/derby/docs/dev/workingwithderby/twwdactivity1.html http://db.apache.org/derby/docs/dev/workingwithderby/twwdactivity2.html When I have time I'll update the tutorial to add info about derbyrun.jar. -jean On 1/24/07, Mohamad [EMAIL PROTECTED] wrote: Hi, Is derby an embedded database system or a client-server system? where can I read about the areas of use for derby. Kindly regards Mohamad
Re: Derby Plug-in issues
Scacco, Paul (GIS Strategy and Admin) wrote: Derby group, I followed the instructions to install the derby plug-in into the eclipse home directory under plugins and when I right click on my project I do see anything related to derby or a derby nature. Can you help ? Hi, Paul, Did you add the Derby nature to your project? This might help: http://db.apache.org/derby/integrate/plugin_help/nature.html The entrypoint for that page is here -- it has a nice tutorial for doing various things with the plug-ins: http://db.apache.org/derby/integrate/plugin_help/start_toc.html I hope this helps. regards, -jean
Re: Derby Plug-in issues
Jean T. Anderson wrote: Scacco, Paul (GIS Strategy and Admin) wrote: Derby group, I followed the instructions to install the derby plug-in into the eclipse home directory under plugins and when I right click on my project I do see anything related to derby or a derby nature. Can you help ? Hi, Paul, Did you add the Derby nature to your project? This might help: http://db.apache.org/derby/integrate/plugin_help/nature.html ... and I'm looking at the instructions I posted and rereading your post . If the right-click on your project doesn't show navigation for Apache Derby - Add Apache Derby nature, you might need to stop and restart Eclipse. Also, in Eclipse 3.2, after you unzip the plug-ins to your eclipse directory, About Eclipse SDK - Plug-in Details should list Apache Derby Plug-in for Eclipse. That's another check you can do to see if Eclipse can find it. regards, -jean
Re: Database ping? ('select 1'?)
Ken Johanson wrote: This syntax: select 1 Seems to always throw a: SQLException: Syntax error: Encountered EOF at line 1, column 8. Is this table-less syntax going to be supported at some point, and what would be the next best means to do table-less select (such as for testing scalars, etc) Of course this exmaple is also common for database connection pings, in systems where the connection may timeout or FIFO.. but is there a better (and equally efficient) approach to pinging? I also tried `select values (1)`. Does this do what you need? ij values 1; 1 --- 1 1 row selected -jean
Re: Is there a Cloudview supporting BLOBs?
E. Kantorowitz wrote: Dear Apache Derby! Many thanks for the great work done at your foundation! Welcome to the Derby users list! I am a new user. I write to you because I could not find answers the two questions: 1. Is the CLOUDVIEW , the poerful grphical user interface of the old CLOUDSCAPE relational databases applicable with DERBY? Cloudview doesn't work with Derby. The Derby wiki pages have links to gui's that you might find useful. This page lists products that work with Derby: http://wiki.apache.org/db-derby/UsesOfDerby And this page lists actual resources (articles, tutorials, blogs, etc.) that show how to use a specific product with Derby: http://wiki.apache.org/db-derby/WorkingWithDerby 2. The original Cloudview did not support the BLOB (Binary Large OBjects SQL datatype. Is there a new version of CLOUDVIEW that supports BLOBs? Cloudview only works with Cloudscape 5.1 and earlier. The developerWorks forum at http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=370cat=19 can answer questions about those early Cloudscape products. regards, -jean
Re: Configuration files for JBoss using Derby
Charlie Kelly wrote: ... The three xml files listed below may help you avoid configuration management problems when you start using Derby with JBoss (the default persistence provider in JBoss is hsql). ... Thanks for posting this information, Charlie! I added a link to this post to the http://wiki.apache.org/db-derby/WorkingWithDerby wiki page. -jean
Re: Nice article on building a user community
David Van Couvering wrote: http://headrush.typepad.com/creating_passionate_users/2006/12/how_to_build_a_.html What a wonderful article! Thanks for posting it. Here's another one (a Google presentation from July 2006) -- How to Protect Your Open Source Project From Poisonous People: http://www.red-bean.com/dav/presentations/Poisonous-people.pdf -jean
Re: Replication Support
David Van Couvering wrote: ... Maybe we should have a Wiki page for replication/availability solutions for Derby... There's a Data Synchronization/Replication category in the Products By Type section of http://wiki.apache.org/db-derby/UsesOfDerby Please feel free to add any products! -jean
Re: how to migrate mysql to derby
Feng Jiang wrote: Hi, I want to use derby to write some testcases in memory. now, i have a mysql database, and dumped the schema into a script file. Here i want to execute this script file and create a identitcal database schema with that mysql database. One option might be to use DdlUtils to create the derby schema from the mysql database; a derby example is at http://db.apache.org/derby/integrate/db_ddlutils.html. It shows how to migrate between two derby databases, but it should work between any databases that DdlUtils supports. It uses the DdlUtils ant tasks to create the schema in the target database from the XML files created from the source database (all generated by DdlUtils). If you specifically want a SQL script that will work with derby, DdlUtils has a writeSchemaSqlToFile ant task [1]. Do you want to just create the schema? Or do you also want to load data? -jean [1] http://db.apache.org/ddlutils/ant-tasks.html#Subtask%3A+writeSchemaSqlToFile
Re: Testing
Paul J DeCoursey wrote: ... I just tried from my gmail account and got the same error. I found that the reason was the message body, although empty, was set to be html. If I changed the body to be plain text I had no issues. Perhaps we could put some info up on the instructions about this issue. The Apache infrastructure volunteers have been working on tweaking the SpamAssassin rules to keep subscribe/unsubscribe email from bouncing, so hopefully this will improve. Turning html off, and especially turning partial html off, will help as each rule that fires adds to the total spam score. If your total score exceeds the threshold, it will be bounced back to you with a message that looks something like this: Remote host said: 552 spam score (5.0) exceeded threshold That bounce message should include the rules that fired; some HTML rules that seem to have been a problem include: HTML_MESSAGE -- message contains html HTML_10_20 -- the message is 10% to 20% html Another good reason for turning html mail off is sometimes html-encoded posts are unreadable in the Apache mail archives at http://mail-archives.apache.org/mod_mbox/db-derby-user/ . So turning off html mail also makes it easier to read archived posts. Finally, if you're having trouble subscribing or posting you can contact the mail list moderators at list[EMAIL PROTECTED]; for derby-user, that would be [EMAIL PROTECTED] -jean
Re: Does Derby support Transaction Logging ?
Duncan Groenewald wrote: Thanks, I just read the material on the transaction logs. However I still don't see how I would be able to achieved what I want which is: 1. Set up a new derby database server on another server (server_2) 2. Restore the database from a database backup from server_1 3. Copy server_1 logs every 15 minutes and load them into server_2 The database files that make up a derby database are platform independent, so you can set up a new database based on an existing one very easily: just shut down that database on the first server and copy all the files in the database directory over to the second server. However, Derby doesn't support synchronizing multiple databases. Sequoia might support what you want (and more): http://sequoia.continuent.org/HomePage Also, in the Products by Type category on http://wiki.apache.org/db-derby/UsesOfDerby, there's a list of synchronization/replication products. I hope this helps, -jean
Re: A new derby tutorial
Laura Stewart wrote: When tutorials like this come out, is a link added from the Derby web pages to these tutorials or just announced on the lists? I added a link to it on this wiki page: http://wiki.apache.org/db-derby/WorkingWithDerby -jean On 11/8/06, Jean T. Anderson [EMAIL PROTECTED] wrote: This came out today: http://www.regdeveloper.co.uk/2006/11/08/java_database_derby/ -jean
Re: Which mapping framework
Marc Schlegel wrote: Hi again. My next question which mapping framework is best for Derby. Hibernate doesn't support it explicitely but it is supposed to work. I heard about a framework from Apache but I forgot the name. A bunch of tools are listed at the bottom of http://wiki.apache.org/db-derby/UsesOfDerby under the section titled Persistence / Object Relational Mapping (ORM) . I hope this helps, -jean
Re: Query regarding derby
Julius.Stroffek wrote: Hi Sridharsingh, Please describe more your running configuration. This kind of error may occur if you are running different instances of derby to access a same database. ... Sridharsingh Inder wrote: Hi Derby Team, We are using derby database in our application. While updating the table, we are getting A lock could not be obtained within the time requested this exception. My queries are as follows 1. Why I am getting this exception? 2. What I should do to avoid this error? 3. How the locking mechanism working in Derby Database? This faq on lock timeout errors mentions some properties that might help isolate the specific sql statement: http://db.apache.org/derby/faq.html#debug_lock_timeout -jean
A new derby tutorial
This came out today: http://www.regdeveloper.co.uk/2006/11/08/java_database_derby/ -jean
Easysoft ODBC driver verified working with Apache Derby
I posted a question to the EasySoft web site a while ago and received a detailed response this morning. Martin gave me permission to forward this to the list -- see below. -jean Original Message Subject: Re: Does the Easysoft ODBC driver work with Apache Derby / Cloudscape 10? Date: Wed, 08 Nov 2006 15:14:17 + From: www [EMAIL PROTECTED] To: [EMAIL PROTECTED] References: [EMAIL PROTECTED] Jean T. Anderson wrote: Greetings, all, A search on the Easysoft web site shows support for the earlier Cloudscape products (version 4 and 5). Have there been any plans to certify it for Cloudscape 10, which uses Apache Derby as is? We do support Cloudscape 10 and all versions of Derby. The pages you refer to on our web site were to demonstrate the difference between 4 and 5 when forming the JDBC URL. We had not realised this might confuse people into thinking we only support cloudscape 4 and 5 and I have asked web development to change this - thanks. The Derby user forum often gets questions about ODBC support -- I included a post from today down below. If Easysoft's ODBC driver works with Derby, I'd like to list it as an option, so I'd be grateful for any information you could provide. We would be happy for you to list the Easysoft ODBC-JDBC Gateway (OJG). I can confirm that we retested OJG with Cloudscape 10.1 this morning and we have customers who use OJG with Cloudscape and Apache/Derby. Here is the info we used: URL: jdbc:derby://localhost/C:\Program Files\IBM\Cloudscape_10.1\demo\databases\toursDB Class Path: c:\jars\derbyclient.jar Driver class: org.apache.derby.jdbc.ClientDriver If you need to mention a link to OJG, the correct one would be: http://www.easysoft.com/products/data_access/odbc_jdbc_gateway/index.html If you need anything more from us please to not hesitate to contact me. Thanks for bringing this to our attention. Martin -- Martin J. Evans Easysoft Limited [EMAIL PROTECTED] http://www.easysoft.com
Re: multiple webapps many embedded vs single network
Michael Segel wrote: ... Derby wasn't designed to be a central database to multiple apps. So its not efficient in that role. Note: This is in comparison to IDS, DB2, Oracle. Derby is not one of those. It lacks the features that they have to act as a centralized DB, however it does have a much smaller footprint. I disagree with this statement, but perhaps I didn't read this thread carefully and am missing some context. Derby fully supports multi-user, multi-application concurrent access, even in embedded mode. It complies with the ACID (Atomic, Consistent, Isolation, Durable) properties expected of relational databases. Olav Sandstaa's ApacheCon US 2005 performance presentation is here and includes results for Derby in both embedded and client/server modes (plus MySQL and PostgreSQL): http://wiki.apache.org/apachecon-data/attachments/Us2005OnlineSessionSlides/attachments/ApacheCon05usDerbyPerformance.pdf Slide 21 is especially interesting, which compares main-memory and disk-based databases for 1-100 clients. While Derby does not perform as well as MySQL and PostgreSQL for main-memory databases, it does perform better that MySQL for disk-based databases. Note that this presentation doesn't reflect the performance enhancements in 10.2. I don't know of any similar results for comparing Derby performance to IDS, DB2, and Oracle. If anyone knows of any such studies, please post a pointer. regards, -jean
Re: multiple webapps many embedded vs single network
Michael Segel wrote: -Original Message- From: Jean T. Anderson [mailto:[EMAIL PROTECTED] Sent: Sunday, October 29, 2006 1:32 PM To: Derby Discussion Subject: Re: multiple webapps many embedded vs single network Michael Segel wrote: ... Derby wasn't designed to be a central database to multiple apps. So its not efficient in that role. Note: This is in comparison to IDS, DB2, Oracle. Derby is not one of those. It lacks the features that they have to act as a centralized DB, however it does have a much smaller footprint. I disagree with this statement, but perhaps I didn't read this thread carefully and am missing some context. [mjs] Knowing you, you haven't really thought about what I was saying. Actually, I did think about it, but perhaps narrowly to address a common misconception I encounter (more in the next paragraph). The sentence that caught my attention was Derby wasn't designed to be a central database to multiple apps. I frequently encounter the misconception that Derby is a single user database, especially in embedded mode. For those who are confused, I'd like to make sure that they understand that even in embedded mode Derby is an ACID-compliant, multiuser database. Derby *is* designed to provide database access to multiple apps and users. -jean
Re: Unable to Install Derby
ram wrote: Hi All, I tried to install Derby and followed all the instructions given at this link:- http://svn.apache.org/repos/asf/db/derby/code/trunk/BUILDING.txt I installed all the required softwares (except the optional packages). I have setup all the environment variables also. But when I run command ant then it gives me error:- snip It is showing me ant help instead of running the command. Kindly help me in this regard. I have to install Derby very urgently. Do you need to actually build Derby? Or just install it? --I notice you're following the instructions for building it. If all you need to do is install Derby, I recommend downloading the latest 10.2 release from the downloads page: http://db.apache.org/derby/derby_downloads.html regards, -jean
Re: You can not print the page
Brown_Richard wrote: Please look at the figures. They do not print Hi, Richard, how did you generate the PDF for this section in the Derby Tutorial? Did you build it yourself with forrest and pdf's enabled? Or did you use something else? thanks, -jean
Re: Feedback papers/derby_web.html
In the following web page: http://db.apache.org/derby/papers/derby_web.html#forrest There is this step: 1. Install Forrest on your machine If you haven't installed Forrest yet, install Forrest 0.7 on your local system. Then generate a seed project, as described in the previous section, and play with it to get comfortable working with Forrest. The link to install Forrest 0.7 does not take you to the Apache Forrest site. In fact, the link is to the same page: http://db.apache.org/derby/papers/derby_web.html#forrest The link needs to be correted. Thanks for reporting the bad link, Laura. It's fixed now and the change should be visible in about an hour. -jean
ASF web sites and wikis are inaccessible
ASF infra volunteers know about the problem. If you want to monitor status, ajax is the machine to watch: http://monitoring.apache.org/status/ -jean
Re: User community role 10.2 testing of optimizer changes
Kathey Marsden wrote: In the licencing discussion, I mentioned that we really need more user feedback before we release 10.2. ... Users, please register your results at: http://wiki.apache.org/db-derby/TenTwoApplicationTesting or, alternatively, how about posting feedback to derby-user? Anyone can create a Wiki profile at http://wiki.apache.org/db-derby . But I can appreciate that those who don't already know MoinMoin wiki syntax (or similar syntax from other wiki software) might decide to add feedback later when they can find time to spin up on it. And we all know how soon later sometimes happens. :-) -jean
Re: 10.2 licensing issue
Wow! Thanks for the update, Rick. I agree that option #1 (release 10.2 without JDBC 4) is best. -jean Rick Hillegas wrote: I must report today that the restrictions imposed by the beta JDK license have not been lifted. As you know, the JDK 6 beta license requires a disclaimer that bars the use of the code for any productive use. This restriction is meant to forestall binary incompatibilities with the final, GA version of the JDK. These incompatibilities might arise due to late-breaking changes in the JDK during its beta cycle. Due to these late-breaking changes, applications compiled against earlier, beta versions of the JDK could behave erratically when run against the GA JDK. Such a disclaimer would need to appear in the NOTICES file of any Derby release built using the beta JDK's tools and libraries. This, in turn, is unacceptable for GA releases of Derby. Therefore at this time we cannot build a Derby release candidate which includes JDBC4 drivers--today those drivers can only be built using beta tools and libraries. For this reason, we, the Derby community must change our plan to ship imminently an official release of Derby that includes JDBC4. 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 guides and prune out the JDBC4-specific javadoc. 2. Delay the current 10.2 schedule until after JDK 6 goes GA. At that time we could release a version of Derby which includes JDBC4 drivers. Given the length of time since 10.1 was released, the uncertainty of the exact date of JDK 6 shipment, and the number of new features included in 10.2, I think that (1) is a better plan. Of course, this is up to the community to decide. Regards, -Rick
Re: Feedback papers/logformats.html
Shubh.Roy wrote: Hi , I have to implement the WAL(Write Ahead logging ) techniques in java.Can you send me please the code. Hi, Shubh, The Derby downloads page explains where to find the source code: http://db.apache.org/derby/derby_downloads.html#Derby+source+code There has been some discussion on derby-dev that it's kind of hard to find Derby source (code, docs, web site) so hopefully we'll improve the information sometime soon to make it easier to find. Please post any questions about the Derby source to [EMAIL PROTECTED] regards, -jean
Re: using sql statement in procedure or function
Ivan Ooi wrote: hi all, Is there anyway that i can use SQL statement to query my data in procedure or function ? Hi, Ivan, SQL functions and procedures implemented in Java can execute SQL statements. More information, and some sample functions and procedures, are on the Derby Wiki: http://wiki.apache.org/db-derby/DerbySQLroutines Will Derby going to implement that ? Why not take a look JoSQL.sf.net, good if Derby can take this library in :-) I hadn't heard about JoSQL before -- thanks for the link. -jean
Re: Database Procedures Question
[EMAIL PROTECTED] wrote: I've been trying to troubleshoot this problem with the system database producedures that don't work. I upgraded to 10.1.3.1 (no effect). I looked in the databse system tables and I can clearly see that there are entries in the aliases table for the procedures in question and that those aliases belong to the correct schemas. I also checked that the class listed in the aliases table can be loaded by using a Class.forName() call. An yet the procedures are not recognized. Obviously I'm missing something here. What else can I check? remember that a SQL function gets executed in a SQL query or with the values statement while a procedure gets executed with the call statement. More info is on the http://wiki.apache.org/db-derby/DerbySQLroutines wiki page, including a pointer to the functional tests, which might provide helpful examples: https://svn.apache.org/repos/asf/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ Please feel free to improve that Wiki page! -jean
Re: IRC chat summary: is there a way to find out column names in ij?
Thanks for the additional suggestions, Knut and Dan. I added a ListTableColumns entry to http://wiki.apache.org/db-derby/HintsAndTips summarizing all this. Anyone, feel free to add more tips -- the full URL is http://wiki.apache.org/db-derby/ListTableColumns . cheers, -jean Daniel John Debrunner wrote: Knut Anders Hatlen wrote: Jean T. Anderson [EMAIL PROTECTED] writes: A user asked this question on #derby today (and here's a summary of the chat since there are probably others on this list with the same question): Is there a way that I can find out what columns are in a table in ij? like describe tablename or something? You can't do that in ij, but that feature has been logged as DERBY-1164. Well, actually, you *can* do that in ij, but it's not very user friendly. You could write a query against the system tables. To find out what columns are in SYS.SYSCONSTRAINTS, enter this query: select columnnumber, columnname, columndatatype from sys.systables t, sys.syscolumns, sys.sysschemas s where tableid=referenceid and t.schemaid=s.schemaid and schemaname='SYS' and tablename='SYSCONSTRAINTS' order by columnnumber; Or if you just want the column names: select * from MYTABLE where 1 = 0 Dan.
IRC chat summary: is there a way to find out column names in ij?
A user asked this question on #derby today (and here's a summary of the chat since there are probably others on this list with the same question): Is there a way that I can find out what columns are in a table in ij? like describe tablename or something? You can't do that in ij, but that feature has been logged as DERBY-1164. In the meantime, dblook lets you extract the schema for a table. dblook is documented in the Derby Tools and Utilities Guide: http://db.apache.org/derby/docs/10.1/tools/ctoolsdblook.html And this page provides examples: http://db.apache.org/derby/docs/10.1/tools/rtoolsdblookexamples.html regards, -jean
Re: Using Derby within the JDK
Ray Kiddy wrote: I just saw the e-mail asking for a doc on how one uses Derby in a J2EE environment. So, Derby is going to be or is part of the JDK. How does one use it in that environment? In all the flavors of that environment? Some resources on how to use Derby are listed in these places: http://wiki.apache.org/db-derby/ http://wiki.apache.org/db-derby/WorkingWithDerby http://db.apache.org/derby/integrate/index.html Contributions are always welcome! And anyone can add pointers to more resources on the http://wiki.apache.org/db-derby/WorkingWithDerby page. -jean p.s. I use the Korn shell, which is why the tutorial at http://db.apache.org/derby/papers/DerbyTut includes Korn shell syntax.
How do you pronounce Derby?
I've been getting this question lately, so I started a Wiki page: http://wiki.apache.org/db-derby/DerbyPronunciation Feel free to add your pronunciation to it. -jean
Re: Counting subscribers
Leslie Software wrote: - Original Message From: Jean T. Anderson [EMAIL PROTECTED] snipDerby graduated last July -- time flies! -- and the user community has grown rapidly. derby-user started with 0 subscribers in August 2004, had grown to 282 when it graduated in July 2005, and today has 411. snip I am curious. How are the number of subscribers you quoted counted? I want to make sure I have done the right thing to be counted:-) Mail statistics are here: http://people.apache.org/~coar/mlists.html#db.apache.org Today derby-user has 412 subscribers (362 on the main list and 50 subscribed to the digest). cheers, -jean
Derby copyright questions (was Re: Proposal for 10.2 release schedule)
Thomas Dudziak wrote: On 6/24/06, Daniel John Debrunner [EMAIL PROTECTED] wrote: ... Btw, to which files does the COPYRIGHT containing an IBM copyright notice refer to ? A search in the Derby sources did not bring up any source copyrighted by IBM. The original contribution of Derby was from IBM, hence IBM has the copyright on all those original files. The ASF policy is not to have individiual copyright statements in each source file and the new policy (I think) is to remove the copyright statement in each source file, leaving just the reference to the Apache Licence in the source file. Yeah, sure, Apache uses a Copyright license instead of a copyright transfer. But, well, the interesting thing is that in the individual files there is always a line like: Copyright 2005 The Apache Software Foundation or its licensors, as applicable. Which basically means that there is no means to distinguish the files IBM contributed originally, and the new ones. The original Software Grant provides an ASF record of the files that were originally contributed -- as does the subversion repository itself, which provides a record of both the files that were contributed originally and the files that were added later. The convention Derby uses in the code headers came out of lengthy discussions on general@incubator.apache.org and derby-dev@db.apache.org -- see the archives at http://mail-archives.apache.org/mod_mbox in the September/October 2004 time frame. I hope this helps clarify things (at least a little), -jean
Re: Proposal for 10.2 release schedule
Daniel John Debrunner wrote: [EMAIL PROTECTED] wrote: -Original Message- From: Daniel John Debrunner [mailto:[EMAIL PROTECTED] The original contribution of Derby was from IBM, hence IBM has the copyright on all those original files. The ASF policy is not to have individiual copyright statements in each source file and the new policy (I think) is to remove the copyright statement in each source file, leaving just the reference to the Apache Licence in the source file. Dan. [mjs] That would not be a good idea, and I suggest that you have IP attorneys from IBM make a final recommendation on this. (No need for Apache to spend money if IBM has the resources and its in IBM's best interest to do something.) Here's why: legal stuff snipped Michael, you should probably check out the legal-disucss mailing list archives, I'm sure all of this was covered. It might be helpful for derby-user as a whole to understand that the Apache Incubator requires resolving any ip issues *before* a project graduates from the Incubator. Lots of information is at http://incubator.apache.org/ . A project simply won't graduate if there is a pending legal matter. After graduation, legal oversight continues by the project's PMC (Derby is a subproject of the DB PMC). Derby graduated last July -- time flies! -- and the user community has grown rapidly. derby-user started with 0 subscribers in August 2004, had grown to 282 when it graduated in July 2005, and today has 411. Here's to the next 100 users! -jean
Re: Proposal for 10.2 release schedule
Daniel John Debrunner wrote: Thomas Dudziak wrote: ... Btw, to which files does the COPYRIGHT containing an IBM copyright notice refer to ? A search in the Derby sources did not bring up any source copyrighted by IBM. The original contribution of Derby was from IBM, hence IBM has the copyright on all those original files. The ASF policy is not to have individiual copyright statements in each source file and the new policy (I think) is to remove the copyright statement in each source file, leaving just the reference to the Apache Licence in the source file. two clarifying notes ... The thread for the new policy starts at [1]. It moves only the ASF copyright to the NOTICE file [2]. Users interested in this change wrt to DERBY can track DERBY-1377 [3]. The derby NOTICE file [4] already references the IBM contribution, which ties back into Dan's point (I hope). -jean [1] http://mail-archives.apache.org/mod_mbox/www-legal-discuss/200606.mbox/[EMAIL PROTECTED] [2] http://mail-archives.apache.org/mod_mbox/www-legal-discuss/200606.mbox/[EMAIL PROTECTED] [3] http://issues.apache.org/jira/browse/DERBY-1377 [4] https://svn.apache.org/repos/asf/db/derby/code/trunk/NOTICE
Re: Self-configuring embedded Derby applications
Rick Hillegas wrote: Dear Derby users, I would like to understand if anyone thinks that they might be affected by the following issue. This issue affects customers who do the following: o Run an embedded Derby application which generates its own Derby properties on the fly. o In the same VM, run other JDBC applications. These other applications could request Connections to DB2, Oracle, Derby, or any other database. In general, we recommend against generating Derby properties on the fly. Where do we recommend against this? We document precedence of properties at http://db.apache.org/derby/docs/dev/tuning/ctunsetprop23308.html and also how to protect database-wide properties at http://db.apache.org/derby/docs/dev/tuning/ctunsetprop824533.html . I'm not spotting any general recommendation against setting Derby properties programmatically, though it might be there. If so, we might want to promote that recommendation in more places. -jean This general problem is described in DERBY-1428. However, the Derby mainline (slated to become release 10.2) expands this problem, as described in DERBY-1429. For a workaround, see the Release Note attached to DERBY-930. Here is more detail on this issue: a) With JDBC4, vendors mark their jar files to indicate the names of jdbc drivers in those jars. During the lifetime of a vm, the very first request for a Connection causes the DriverManager to look inside all of the jars and register all indicated jdbc drivers. b) When our embedded driver registers itself, it also boots the engine, using whatever derby properties are currently visible. Typically, the engine stays booted for the lifetime of the vm. This can cause a Heisenbug in the following scenario: o The customer runs two applications in the same vm: EmbeddedApp and OtherApp. o Before getting its first Connection, the EmbeddedApp hand-crafts its own derby properties to configure the engine's behavior. o OtherApp could be an application which uses the Derby client driver or some other jdbc driver. o If OtherApp runs before EmbeddedApp, then the engine will boot without the hand-crafted properties. o It may not be deterministic whether OtherApp or EmbeddedApp runs first. Sometimes you get the right engine properties and sometimes you don't. It is worth pointing out that this Heisenbug can occur today, pre-JDBC4, if OtherApp is another embedded Derby application. JDBC4-driver-autoloading broadens the family of affected scenarios. I would like to understand how much the family is broadened. Please let me know if you think this problem will affect you. Thanks, -Rick
Re: Apache Derby (in the guise of Java DB) now shipping in Sun Java SE SDK
Judes Tumuhairwe wrote: How do I vote? (it doesn't say---*it's possible that I missed it*). First, you need to login -- you can create a login at http://issues.apache.org/jira/ if you haven't already. After you login, go to http://issues.apache.org/jira/browse/DERBY-396 . On the left-hand side you should see an Operations menu with a Voting option near the bottom. regards, -jean thanks, JCD On 6/16/06, Kathey Marsden [EMAIL PROTECTED] wrote: 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. http://issues.apache.org/jira/browse/DERBY?report=com.atlassian.jira.plugin.system.project:popularissues-panel
Don't feed the troll
Every now and then Apache lists get posts with troll bait. Here's a good quote from http://en.wikipedia.org/wiki/Internet_trolls : For many people, the characterising feature of trolling is the perception of intent to disrupt a community in some way. Inflammatory, sarcastic, disruptive or humorous content is posted, meant to draw other users into engaging the troll in a fruitless confrontation. The greater the reaction from the community the more likely the user is to troll again, as the person develops beliefs that certain actions achieve his/her goal to cause chaos. This gives rise to the often repeated protocol in Internet culture: Do not feed the trolls. The Wikipedia advice is good. Don't feed trolls. Just ignore them. -jean
Re: The tutorial on migrating DB to derby
[EMAIL PROTECTED] wrote: Hi, I was just going through the tutorial at http://db.apache.org/derby/integrate/db_ddlutils.html I am having a problem checking out the ddlutils files from http://svn.apache.org/repos/asf/db/ddlutils/trunk STEP 2. It says cannot connect to the server. My internet connection is perfect and I dont understand why it does not allow me to checkout stuff. Could you please help me out with this. hmmm, I just tried and it worked for me. Try https instead: svn co https://svn.apache.org/repos/asf/db/ddlutils/trunk ddlutils Also, can you access this URL in your browser? https://svn.apache.org/repos/asf/db/ddlutils/trunk regards, -jean
Re: updating copyrights in user guides
Rick Hillegas wrote: I'm going to make some copy-editting fixes to the user guides. While I'm in there, I'd like to update the copyright notices. I'm proposing to change the following line: Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable. to Copyright 1997, 2006 The Apache Software Foundation or its licensors, as applicable. For the way things currently work, the 2005 shouldn't be dropped (see http://www.apache.org/dev/apply-license.html#new), so should be: Copyright 1997, 2005-2006 The Apache Software Foundation or its licensors, as applicable. Is there anything else I should do to the copyrights given the recent copyright decision by the Apache board? Apparently the html source that is distributed needs the same handling as the source dita files and the rest of the derby code. I'm waiting for notification to be sent to committers to see the final info, but I believe we'll need to do this: 1) Move the copyright to the NOTICE file 2) Header of each source gets the license header as shown in [1] 3) The generated html files need the same header, see [2], so the DITA build process needs to be tweaked (I'll add a note to DERBY-1377). -jean [1] http://mail-archives.apache.org/mod_mbox/www-legal-discuss/200606.mbox/[EMAIL PROTECTED] [2] http://mail-archives.apache.org/mod_mbox/www-legal-discuss/200606.mbox/[EMAIL PROTECTED]
Re: generated by default question
Michael Segel wrote: snip Having said that, Daniel already made a suggestion which is in use today by other databases The simplest solution would be to find the MAX value, rest the sequence to MAX() +1 and re-insert the row. There are other possible solutions. It's disappointing that certain people don't accept this as a bug Craig Russell wrote earlier in this thread [1]: Do you have a good solution that you can write up in detail and post to JIRA? Then someone with an itch can fix it. Do-ocracy in action. Anyone is welcome to open a Jira issue. Jira assistance is at http://db.apache.org/derby/DerbyBugGuidelines.html . -jean [1] http://mail-archives.apache.org/mod_mbox/db-derby-user/200605.mbox/[EMAIL PROTECTED]
Re: Updating Embedded Derby Db
Carol Gloyd wrote: Hi, I'm fairly new to Derby and am wondering if there is a way to update an embedded database programatically? By update, I mean adding new tables and adding columns to one or two of the existing tables. snip The Derby distribution has examples that might help you. Here's a good starting point in the binary distribution: db-derby-10.1.2.1-bin/demo/simple/SimpleApp.java It shows how to programmatically create, insert into, and drop tables. I hope this helps -- and, if it doesn't, feel free to post more questions. regards, -jean
Re: Derby Protocols
Maryam Moazeni wrote: Hi, What is the difference between this jdbc:derby://localhost:1527/ AND jdbc:derby:net://localhost:1527/ ?? jdbc:derby://localhost:1527/ is the connection URL syntax used by the derby network client driver (derbyclient.jar). Summary info is at: http://db.apache.org/derby/docs/10.1/adminguide/cadminappsclient.html jdbc:derby:net://localhost:1527/ is the connection URL for the IBM DB2 Universal driver (db2jcc.jar). Summary info is at: http://db.apache.org/derby/docs/10.1/adminguide/cadminapps810777.html There are a couple other syntax differences between the two that I have gotten tripped up on before. For example, with the db2jcc.jar driver, there's a colon after the dbname and a semicolon at the end: 'jdbc:derby:net://localhost:1527/bookstore:user=app;password=app;' The embedded and the derby network client drivers both have a semicolon after the db name and nothing at the end: Derby network client driver: 'jdbc:derby://localhost:1527/bookstore;user=app;password=app' Embedded driver: 'jdbc:derby:bookstore;user=app;password=app' I hope this helps. regards, -jean
Re: Please try the Derby 10.1.2.4 snapshot if ...
Kathey Marsden wrote: ... This is your chance to provide input *before* 10.1.3 is released in June. 10.1.3 Release Notes: http://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12310616styleName=HtmlprojectId=10594Create=Create The machine that hosts Jira was just pulled down to install more RAM, so if you find you can't access the release notes, that's why. It should be back in 2 hours according to http://monitoring.apache.org/status/ . -jean
Re: How Open Source Works (was Re: Spawning Data on Multiple Directories)
[EMAIL PROTECTED] wrote: Jean, In IBM speak, what is your value add proposition? My valued added to this thread is to clarify how the ASF works. Don't demand that others fix *your* issues. Don't demand that others take the product in *your* direction. You're welcome to become part of this community and work with others toward goals that are commonly agreed upon. We welcome any contributor. -jean snip
Re: How Open Source Works (was Re: Spawning Data on Multiple Directories)
[EMAIL PROTECTED] wrote: Jean, I sense some hostility on your part as well as a continued difficulty in comprehending the thread of posts. hostility? no. But you seem to be deliberately baiting debates and I frankly don't have time/inclination. Other things on my plate need attention. -jean snip
Re: Are Sequences(Generators) supported?
Panayiotis Vlissidis wrote: Hello all. I just found out about Derby(Java DB) and I was wondering if there is any support for sequences(generators) for automatic generation of a unique number? Derby supports automatically generated identity columns. More information is here: http://db.apache.org/derby/faq.html#identity regards, -jean
Re: Hibernate and Derby
Avin wrote: I am gettin the following error, when I try to connect to Apache Derby using Hibernate. Can anyone let me know what this might be ??? [java] Apr 29, 2006 1:48:20 PM org.hibernate.util.JDBCExceptionReporter logE xceptions [java] WARNING: SQL Error: -1, SQLState: 42Y07 [java] Apr 29, 2006 1:48:20 PM org.hibernate.util.JDBCExceptionReporter logE xceptions [java] SEVERE: Schema 'SYSTEM' does not exist [java] Apr 29, 2006 1:48:20 PM org.hibernate.util.JDBCExceptionReporter logE xceptions 42Y07 is a schema doesn't exist error. A description of why you might get a schema doesn't exist error is here: http://db.apache.org/derby/faq.html#schema_exist Here's a quote from that FAQ: However even though the current schema is set to the user name, that schema may not exist. A schema is only created by CREATE SCHEMA or creating an object (table etc.) in that schema (this is implicit schema creation). I can reproduce the problem if I connect to a database as user 'system' and try to select from a table, but no objects have been created by that user yet: $ java org.apache.derby.tools.ij ij version 10.1 ij connect 'jdbc:derby:MyTest;user=system'; ij select * from foo; ERROR 42Y07: Schema 'SYSTEM' does not exist As noted in the FAQ, the first table I create also creates the schema: ij create table foo (id int); 0 rows inserted/updated/deleted ij select * from foo; ID --- 0 rows selected I could also have created the schema first, then I would get an error that the table doesn't exist instead of the schema doesn't exist error: ij connect 'jdbc:derby:MyTest;user=system'; ij create schema system; 0 rows inserted/updated/deleted ij select * from foo; ERROR 42X05: Table 'FOO' does not exist. Also a problem was logged specifically with creating a trigger when the default schema doesn't exist; see http://issues.apache.org/jira/browse/DERBY-85 If none of this information helps you resolve your problem, feel free to post more information, including the SQL statements executed when the error occurs -- and please include the output from the command below, which shows the version of Derby you're using: java org.apache.derby.tools.sysinfo Incidently, SYSTEM isn't a Derby schema, though you might find that in other database products. To view the schemas that come with Derby, you can execute this query in your Derby database: select schemaname from sys.sysschemas; regards, -jean
[web] site structure updated
I checked in a change to the web site that partially addresses issues that Dan Debrunner and Michelle Caisse raised. You'll need to refresh pages in your browser to see these changes. Here's a summary of the basic changes: (1) The Quick Links subcategory on the home tab should autoexpand but can't. A forrest feature (FOR-339) will support this but isn't implemented yet. The resolution is to not have a Quick Links subcategory on the home tab, just a simple list. (2) A Quick Start entry on the home tab and its own tab is disconcerting. I agree and the resolution is to remove the link from the home tab -- it isn't needed because the home page also links to it. (3) Links on the home tab that are repeated on other tabs (for example, a license link was on the Download tab and an FAQs link was on the Community tab) cause a jump back to the home tab when the page is selected. I agree this behavior is jarring, but don't see a way to avoid it. The best near-term solution is to not repeat links across tabs and to choose carefully where those links should appear. I think license and FAQs both need increased visibility, so left them on the home tab. I also left Derby Wiki on the home tab because the Community tab has quite a few items. (4) Offsite links should open in a new window. I haven't figured out a way to do that in the forrest menu, but am able to in the body of a page; for example, the document links on http://db.apache.org/derby/manuals/index.html open in a new window. The best resolution for now is to remove those links, but for another reason as well: keep the number of items on the home tab few enough that people will notice what's there. Michelle also noted that on the download tab if you click on 10.1.2.1, the forrest menu collapses instead of highlighting 10.1.2.1. I haven't figured this one out yet, but suspect it has something to do with the file type (cgi). I should mention that some of the things I haven't figured out how to do might in fact be possible in forrest, but I just haven't found the right information yet. Thanks for all the feedback -- and please keep it coming. regards, -jean
Re: [Fwd: Re: Invitation to Participate in Summer of Code 2006]
David W. Van Couvering wrote: FYI, we're officially in! See http://www.google.com/soc I think that url is supposed to be ... http://code.google.com/soc/ Apache Derby isn't showing up under the ASF -- was that intentional? -jean snip
Re: [web] site structure updated
Michelle Caisse wrote: Hi Jean, I like the changes. I think the site is easier to grok now. I noticed another thing about the Download tab and the 10.1.2.1 link. If after clicking the link you then expand the list again, License appears in the navbar. The License link is not there otherwise. You get the same issues if you click the 10.1.2.1 or 10.1.1.0 links from the text of the page, so it has something to do with the cgi script serving these pages. Hi, Michelle, Those two pages get generated in a special way and I didn't generate them correctly -- I'm untangling and it should be fixed soon. thanks for the feedback, -jean
Is there a way to create auto increment columns?
Since others on derby-user might have the same question Question on #derby IRC: derby newbie here... Does anyone know if there is a way to create auto increment columns in derby like mysql? Answer given: derby supports identity columns : see http://db.apache.org/derby/docs/10.1/ref/rrefsqlj24513.html and the full info for generated ... as identity is at http://db.apache.org/derby/docs/10.1/ref/rrefsqlj37836.html
Re: [web] Derby site reorganization
Thanks for this excellent feedback, Michelle. Sorry for the delay -- I've been out of town. I'll look at this tomorrow along with Dan Debrunner feedback I didn't have time to close the loop on before leaving town. thanks, -jean On Mon, 03 Apr 2006, Michelle Caisse wrote: Hi Jean, I just noticed that Quick Start is both a tab and an entry on the Home tab. I do find this quite disconcerting. I think that consistency in how the navigational features work is important for ease of use. Having an entry jump to a new tab violates consistency. Other oddities: From the Download tab, click License. Now you're on the Home tab. From the Download tab, click 10.1.2.1. The navbar collapses, rather than highlighting 10.1.2.1. From the Community tab, click FAQs. Now you're on the Home tab again. I think it would be helpful to have consistency in how heading levels on the navbar correspond to pages in the text area. For example, each major heading level is its own page and each subhead is a jump on the text page. Or, each heading, major or minor, is a new page and jumps within a page are not shown on the navbar (not needed since they appear in the TOC at the top of the page). Finally, I think it would help the overall design to have off-site links such as the Quick Links to open a new window. BTW, I really like the new colors. -- Michelle Jean T. Anderson wrote: Stanley Bradbury wrote: Only one thing I noticed needed tweaking . The tab: Quick Start never 'highlights' (shows active) - the HOME tab is darkened when 'Quick Start' is selected (the proper page is displayed). This is a side effect of also listing the page on the Home tab. Clicking on the Click Start tab then jumps to that page on the Home tab. Since the quick start page is the only page for the Quick Start tab, I'd like to leave it associated with the contents of the Home tab, unless people feel it's too distracting. thanks for the feedback, -jean
Questions about Derby (was Re: Does Derby support ALTER TABLE DROP COLUMN?)
Dheeraj wrote: ... I want to information about alter a table !! The ALTER TABLE command is documented at http://db.apache.org/derby/docs/10.1/ref/rrefsqlj81859.html . Like change column name or increase/ decrease the size of a column !! As the link above explains, you can increase the size of column, but not decrease it. But there are some restrictions that are being addressed by DERBY-396 (http://issues.apache.org/jira/browse/DERBY-396) . I want to information about how can I see the structure of a table through a query or etc. i.e how many columns currently present in a table what their size data type !! Derby's 'dblook' utility outputs the DDL for objects in a database: http://db.apache.org/derby/docs/10.1/tools/ctoolsgenddldb.html DERBY-1164 (http://issues.apache.org/jira/browse/DERBY-1164) is a feature request to add functionality to ij to output information. Also, some of the GUI tools listed on the Wiki page below provide nice viewing of database objects: http://wiki.apache.org/db-derby/UsesOfDerby#ProductsByType Please give me list of what data type are convert to other data type !! A table that shows which types can be explicitly converted (cast) to another is in the SQL Reference Guide: http://db.apache.org/derby/docs/10.1/ref/rrefsqlj33562.html And this page summarizes the data types that can be used for comparison, sorting and ordering expressions: http://db.apache.org/derby/docs/10.1/ref/rrefsqlj58560.html ... Pls give me these information about Apache Derby !! Much of the information you are looking for is available in the Derby manuals, which you can access from the Derby web site: http://db.apache.org/derby/manuals I hope this helps. regards, -jean
Re: Pls give info !!
Please see the responses on this other thread: http://mail-archives.apache.org/mod_mbox/db-derby-user/200604.mbox/[EMAIL PROTECTED] regards, -jean Sunil Bansal wrote: Hi !! I m Dheeraj !! May u help me about problem which is occur at time of using Apache Derby !! I m using Apache Derby Data Base for my project . I want to information about alter a table !! Like change column name or increase/ decrease the size of a column !! I want to information about how can I see the structure of a table through a query or etc. i.e how many columns currently present in a table what their size data type !! Please give me list of what data type are convert to other data type !! e.g varchar to bigint are convertible or not !! bigint to varchar are convertible or not !! These kind of list !! Pls reply quickly as early as possible !! Pls give me these information about Apache Derby !! Bye !!
[web] Derby web site reorganized
I put in place the web site reorganization discussed earlier in the week. Your web browser probably caches pages, so you may need to reload pages to see the changes -- shift-reload does it for me in my browser. Please post any problems you notice. regards, -jean
Re: [web] Derby site reorganization (resend)
Craig L Russell wrote: On Mar 27, 2006, at 5:04 PM, Jean T. Anderson wrote: ... I reorganized the Derby web site and put a review copy here: http://people.apache.org/~jta/DerbyTest/ I never had an issue with the blue side bar. The background seems to be missing now. I kinda liked (+0) the old blue. Oops, almost missed this comment. The color issue came up on derby-dev, and beige seemed to be preferred over blue. So I'll go ahead and put the beige in place tomorrow unless I get lots of feedback on this list that says to keep the blue. The switch between blue and beige is very easy if we decide we don't like it -- a simple change to the forrest config file. thanks for the feedback, -jean
Computer malfunction (was Re: [WWD] Chap 3 and 4 submitted for review)
yeradis wrote: ... because it do nothing, simple dont work, my windows do what he want :-p ... i'm investigating my windows if my windows is seek ... ... It does sound like your computer might be sick (infected), Yeradis. I did a quick search for free antivirus software and came up with these: http://www.free-av.com/ http://free.grisoft.com/freeweb.php/doc/2/ Ff course, one should always be careful about downloading any free software, but it's a good idea to run antivirus software. regards, -jean p.s. The ... is like the SNIP you noticed in Stan's email. It's a way to respond to just the parts of a post you want to, and shorten the post to make it easy for everyone to quickly read.
Re: [web] Derby site reorganization (resend)
Stanley Bradbury wrote: Only one thing I noticed needed tweaking . The tab: Quick Start never 'highlights' (shows active) - the HOME tab is darkened when 'Quick Start' is selected (the proper page is displayed). This is a side effect of also listing the page on the Home tab. Clicking on the Click Start tab then jumps to that page on the Home tab. Since the quick start page is the only page for the Quick Start tab, I'd like to leave it associated with the contents of the Home tab, unless people feel it's too distracting. thanks for the feedback, -jean
Re: [web] Derby site reorganization
Dan Scott wrote: I applaud the change of Manuals to Documentation and also the switch to having the most recent documentation appear first -- that was my major (unexpressed) iritation with the old site ;) always feel free to express any irritations! It's funny, I had reordered the manuals in the nav bar on the left -- but had missed them in the body of the page. thanks for the feedback, -jean
[web] Derby site reorganization
I reorganized the Derby web site and put a review copy here: http://people.apache.org/~jta/DerbyTest/ 1) Some time ago somebody mentioned the blue menu on the left was too dark. It turned out to be easy to change it to beige in the forrest config file. Is beige an improvement? Or leave it blue? 2) Added a Quick Start page, linked to on the Home tab and the home page. 4) Added a Download tab to make downloads even easier to find. (Geronimo and XmlBeans have Download tabs.) 5) Renamed Manuals tab to Documentation. 6) Renamed Integration tab to Resources (idea from XmlBeans) Integration has always struck me as very specific and not everyone might understand what it means. do you like it? hate it? any suggestions?
[web] Derby site reorganization (resend)
I just hate it when you hit the wrong key and something gets sent before it's ready. Here's a resend. I reorganized the Derby web site and put a review copy here: http://people.apache.org/~jta/DerbyTest/ The main modifications include: 1) Added a Quick Start tab with tips for getting started. 2) Added a Download tab to make downloads easier to find. 3) Renamed Manuals tab to Documentation. I also moved the links from the left-hand navigation to the body of the page, so they can be opened in a new browser window. This will make it easier to jump between manuals; you won't have to hit the back key repeatedly to get back to the main manuals page. 4) Renamed Integration tab to Resources Integration has always struck me as very specific and not everyone might understand what it means. Do you have any suggestions? I plan on committing these changes on Thursday and will incorporate any feedback I receive before then. regards, -jean
Re: Running 2 Derby instances on 1 JVM, do system properties cut it??
Hiram Chirino wrote: Hi Matt, That sounds like it's worth a try. Got an example of how to use absolute database names? The derby wiki has some tips that might help: http://wiki.apache.org/db-derby/DatabaseNamesRelativeAbsolute -jean snipped the rest
Re: Compiere on Derby (WAS: Bug in division operator with numeric operands?)
Matthias Ohlemeyer wrote: ... One other remark: There was news that Compiere would do a Derby port on their own and that there is an agreement with some Derby developers to help them. This came after I was half way through. So far I have not seen any activity on this subject on any of the Derby lists. Is there some ongoing work I am not aware of? Quote: We're working together with the Derby development team and we'll provide a complete open source solution based on Derby and Cloudscape in six to nine months, said Jorg Janke, the company's founder and president, speaking at the Solutions Linux conference in Paris See: http://www.networkworld.com/news/2006/013106-compiere.html I don't recall anything about Compiere and don't spot anything in the Derby mail archives -- it's possible it slipped through the cracks of my email in-box. Does this ring a bell with anyone else? --It's always possible the ERP app was mentioned in a post without mentioning Compiere itself. At any rate, Derby welcomes any integration effort, so I guess the best suggestion is to point anyone with questions or issues to http://db.apache.org/derby/derby_mail.html . Matthias, thanks for taking the time to provide feedback. regards, -jean
Re: Derby logo ( was sorry)
yeradis wrote: jean thanks you very much i will write a line to the commitee for permission i was looking for the logo because i'm rebuilding a web site and one of the links is for derby and also because i'm preparing a serial of derby articles and i was lookingfor the derby logo to desing the cover here is a preview on each article will be a subtitle keeping this General title that you can see on the image i send you ;-) i'm preparing this articles on openoffice writer i know i'm not the best indicated to do this but this is a way is better for me to explote the derby functionality and with this work others ;-) will be beneficiated because is prepared by a derby dummy user ;-) ;-p for other that want to learn derby ;-) cool! writing about Derby will help you learn it -- and don't hesitate to ask questions. -jean
Re: Derby logo ( was sorry)
yeradis wrote: is there a way to express the same as hesitate word i don't know what mean :-( sorry My apologies -- I was expressing appreciation for your project (cool!), but I should not have used slang. At any rate, I'm really pleased to see you do this. And feel free to post any questions you have so the Derby community can help you understand what you need to build that information. -jean On 3/15/06, Jean T. Anderson [EMAIL PROTECTED] wrote: yeradis wrote: jean thanks you very much i will write a line to the commitee for permission i was looking for the logo because i'm rebuilding a web site and one of the links is for derby and also because i'm preparing a serial of derby articles and i was lookingfor the derby logo to desing the cover here is a preview on each article will be a subtitle keeping this General title that you can see on the image i send you ;-) i'm preparing this articles on openoffice writer i know i'm not the best indicated to do this but this is a way is better for me to explote the derby functionality and with this work others ;-) will be beneficiated because is prepared by a derby dummy user ;-) ;-p for other that want to learn derby ;-) cool! writing about Derby will help you learn it -- and don't hesitate to ask questions. -jean
Re: Accessing embedded Derby in forked Maven2 build
Randy Watler wrote: Andrew: Andrew McIntyre wrote: It sounds like you're setting up a test database using Ant's sql commands and this leaves the Derby engine running in the same VM as Ant. So, my original solution wouldn't work, as ij wouldn't be able to connect. It sounds like you may need to move the creation of the test database into another VM. You could do this by putting all of the SQL you have in your Ant sql statements into a file and running it in a forked JVM using ij. Right. This is why when I run your solution I get cannot connect messages... even if it is not forked. So how is the best way to shutdown the engine? I assume that because an engine is running, ij cannot connect. But why is that if I do not fork ij? Randy This developerWorks article provides StopDatabaseTask and StopDerbyTask Ant tasks: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0412snell/index.html If this helps resolve your problem, please let us know. -jean
Re: Using DdlUtils to Migrate Databases to Derby (MySQL-to-Derby)
Jean T. Anderson wrote: Thanks for this feedback, Thomas. I'll update Step 5 to mention reasons for tweaking the types in the generated schema xml file. Also, over on ddlutils-user Tom Dudziak mentioned that he checked in a change that addresses needing to set the database name in the schema file and I'll update Step 5 for that as well: http://mail-archives.apache.org/mod_mbox/db-ddlutils-user/200603.mbox/[EMAIL PROTECTED] I updated http://db.apache.org/derby/integrate/db_ddlutils.html to start adding notes for when you might want to edit the generated schema file and to take advantage of the new modelName flag Tom added to DdlUtils. You might need to reload the page in your browser to see the changes. regards, -jean
Re: Using DdlUtils to Migrate Databases to Derby (MySQL-to-Derby)
Thanks for this feedback, Thomas. I'll update Step 5 to mention reasons for tweaking the types in the generated schema xml file. Also, over on ddlutils-user Tom Dudziak mentioned that he checked in a change that addresses needing to set the database name in the schema file and I'll update Step 5 for that as well: http://mail-archives.apache.org/mod_mbox/db-ddlutils-user/200603.mbox/[EMAIL PROTECTED] -jean Thomas J. Taylor wrote: I was just testing out the DDLUtils program. It will be quite useful if it can handle things like this, and hopefully preserve UTF-8 characters. In the spefic case of our databases, I would much rather have the process fail then to truncate the data. Other observations about the migration: 1. The MySQL LONG VARCHAR was converted to Derby LONG VARCHAR(32700) - resulting in Data Trunctation Exception 2. Derby LONG VARCHAR cannot be used in SQL comparisons - so in our case, we use Derby VARCHAR(32700) for MySQL LONG VARCHAR, when we need to compare values, and CLOB if we need 'long text' After changing the appropriate table descriptions in 'db-schema.xml' (the XML file that contains the DDL) (change some LONGVARCHARs to CLOB, others to VARCHAR(32672)), everything went through correctly and the data appears correct - although I haven't confirmed specifically that UTF-8 characters transferred coreectly. So, in the case of MySQL to Derby Migration, it is necessary to change the 'db-schema.xml' for some LONGVARCHAR entries. - If SQL comparisons are needed, then LONGVARCHAR should be changed to VARCHAR(32672). - If long text needs to be preserved, then LONGVARCHAR should be changed to CLOB. ** With Derby's restriction on SQL comparison queries limited to VARCHAR fields, there doesn't appear to be a way to migrate LONGVARCHAR (very long text 32700) in MySQL to an equivalent Derby data type. Thomas -Original Message- From: Thomas Dudziak [mailto:[EMAIL PROTECTED] Sent: Sunday, March 12, 2006 6:32 PM To: Derby Discussion Subject: Re: Using DdlUtils to Migrate Databases to Derby (MySQL-to-Derby) On 3/13/06, Thomas J. Taylor [EMAIL PROTECTED] wrote: I tried running DDLUtils to convert one of our existing MySQL databases to Derby. It got to the point of importing data from the data.xml file but failed due to an 'Data Truncation' Exception converting from LONG VARCHAR to VARCHAR(32700). Seems you try to insert more than 32700 bytes of data. Don't know about Derby, but in MySQL you can switch the JDBC driver to warn instead of throwing an exception by adding jdbcCompliantTruncation=false to the connection URL. cheers, Tom
