AW: AW: Pivoting tables?

Hi John, It sounds to me that your first solution could work flexible enough, while the other might have lecks of flexibility, haven't they? I am not sure how much you like to studdy and translate it in derby and Java procedures in the example of the page from last answer.

AW: Pivoting tables?

Hi John, I think a smart SQL-Statement schould do. OK that would probably a bit inflxible, since you have a lot of changes concerning users and products. But you could may be write a SQL-Generating routine that takes care of it. I googled a bit and found examples (for other database-systems)

AW: Getting transitive closure?

Hi John, Well I would prefer a structure, that I could put into a Nasi-Schneidermann-Diagramm. So instead of using while (true) and fleeing out of it like hell with a break or a return I would do something like this: PreparedStatement stat; try { stat = connection.prepareStatement(

WG: for looking up Schema-Version

Hi to all, I have following situation and like to know if there is any best practice, since it seems to me a common one: I have a data-Base wanting to grading up the schema. My curren version of my application finds already out if the schma needs to be put into the database using sql state

AW: Using Identity Colums with or without Sequences derby 10.8.1.2

Hi José, Thanks a lot for the hints, by the way are those identity-values cycled, so it does not come to crash if there a is a roll over, unless there is a defined constrained that says not unique? Malte Von: José Ventura [mailto:st.ne...@gmail.com]

AW: Using Identity Columns with or without Sequences derby 10.8.1.2

Hi John, Thanks a lot for your code example that helps me a lot saveing some time :-) Malte Von: John I. Moore, Jr. [mailto:softmo...@att.net] Gesendet: Montag, 1. Oktober 2012 15:54 An: 'Derby Discussion' Betreff: RE: Using Identity Columns with or without

AW: schema-questions

Hi to all, I tried to find something on the internet belongig to my question: what is to do for connecting with a user to a different schema than the username or APP. Actually I found 2 hints 1. use SET CURRENT SCHEMA 2. Make your own custom authentication Source of

AW: AW: schema-questions

Hi Rick, I am not sure if wrapping datasource is really a good place, because as far I understand the datasource is produced by the ApplicationServer. The hint I got was producing an own authentication by implementing org.apache.derby.authentication.UserAuthenticator interface If I do that, how

AW: AW: schema-questions

Hi Kristian, You mean th qualifier for the tables, right. like in my case select * from user_stuff.users Malte Von: Kristian Waagan [mailto:kristian.waa...@oracle.com] Gesendet: Montag, 23. Juli 2012 16:32 An: derby-user@db.apache.org Betreff: Re: AW:

AW: AW: schema-questions

Hi José, It might be a bit theoreticly thining of my own, but my motivation is here that the application code should not necessaryly know about the schema name, as well it does not know anything about user and password. On the other hand, I researched a bit further what oracle got in this

AW: AW: AW: AW: schema-questions

Hi Tim and Kristian, Thanks to that hint, and it is korrect I focus on web-client technology, but I just was wondering and curious about those parameters. I have set values on the log and trace parameter within the network client via the web-app of Derby and found resonable results :-)

schema-questions

Somehow I ask now myself, how I can connect to another schema than the username. Currently I have a user tech that is suppose to connect to the schema user_stuff via DataSource I tried now this but obviously ist not correct becides the password is still ignored also the schema seems not to be

AW: AW: AW: schema-questions

Hi Tim Thanks for the given hints... Did you try invoking test.jsp from my last post? That would tell you if the running instance of Tomcat had a JAVA_OPTS and derby.system.home passed through to it. Yes I did something very similar, I copied the particular lines of your jsp, into my

AW: AW: schema-questions

Hi Tim My JAVA_OPS look like that, when I use set command: JAVA_OPTS=-Dderby.system.home=c:\derby-dbs I suppose that the JAVA_OPTS are recognized by derby in my particular case. Otherweise I would not understand why derby produces and writes and reads from the given directory. It is a bit of

schema-questions

hi to all, I am using derby (10.8) with tomcat and used following side helping me seitting them up: http://www.zetcode.com/db/apachederbytutorial/tomcat/ Trying to build up a simple web-application where you could register as user etc. I have following schema CREATE SCHEMA USER_STUFF; CREATE

AW: schema-questions

I start tomcat (version 6) with ist startup batch file only -Ursprüngliche Nachricht- Von: Tim Watts [mailto:t...@cliftonfarm.org] Gesendet: Dienstag, 17. Juli 2012 18:08 An: Derby Discussion Betreff: Re: schema-questions On Tue, 2012-07-17 at 16:44 +0200, malte.kem...@de.equens.com

AW: schema-questions

Hi Rick, Thanks a lot for you fast answer. Right now I am just trying to practice some web-application programming, so it does not matter much to me using BUILTIN, even though it has no productive quality. But thanks for the hint with NATIVE. Using the configuration right now lets use Tomcat

Does derby ned allways a rollback or commt?

Hi, I have an application using embedded derby (10.8.1.2). In the program I use a little routine that ends with rollback, commit or nothing at all, by using a parameter. In a certain mode I just do a select, so As far I concern I don't need to do neither rollback nor commit, since it is just

AW: Does derby ned allways a rollback or commt?

So what would be the best practice using a rollback or a commit when just reading a database? Malte Von: florin.herin...@sungard.com [mailto:florin.herin...@sungard.com] Gesendet: Dienstag, 22. November 2011 12:14 An: derby-user@db.apache.org Betreff: AW:

How to use procedures in ij?

Hi to all, i was looking for a possibility to write out results of querreis into a a CSV-file and found a procedure for that (SYSCS_UTIL.SYSCS_EXPORT_QUERY) But how can I use it within IJ? Is there a possibility? Thanks a lot in advance for any hint Malte

AW: How to use procedures in ij?

Ahh ok I found it, call is the magic word, I was missing in the output of ij's help command. So never mind :-) Von: malte.kem...@de.equens.com [mailto:malte.kem...@de.equens.com] Gesendet: Montag, 30. Mai 2011 11:44 An: derby-user@db.apache.org Betreff:

AW: Inaccuracies in H2's claims: Autocounter/Sequqnce-Numbers

May be the Article used an older version of derby. T's a pity that they don't say what version were used for comparison. -Ursprüngliche Nachricht- Von: Rick Hillegas [mailto:rick.hille...@oracle.com] Gesendet: Dienstag, 24. Mai 2011 20:12 An: Derby Discussion Betreff: Inaccuracies in

Autocounter/Sequqnce-Numbers

Hi to all, in http://www.h2database.com/html/features.html#feature_list I found this particular statement to above topic: Sequence and autoincrement columns, computed columns (can be used for function based indexes) Later on is a matrix that shows some RDBMs in releation to some features

IJ-tool getting cursor-keys work on Solaris (bash)

Hi to all, I am using ij-tool just for look up. It works great on windows. When I use it on a bash-shell (Solaris) the cursor-keys do not work, but I get some strange letters typed like this: ij select ^[[A^[[B^[[C^[[D It seems that those keys are not defined in some way. They work with in the

AW: IJ-tool getting cursor-keys work on Solaris (bash)

I am using *ij-tool* just for look up. It works great on windows. When I use it on a bash-shell (Solaris) the *cursor-keys* do not work, but I get some strange letters typed like this: *ij select ^[[A^[[B^[[C^[[D* It seems that those keys are not defined in some way. They work with in the

funny behavior

Hi to all, I am using derby as embedded DataBase using just one simple table. Several update and delete statements are defined though, in a certan way I use my program it is just executing a select statement. But now there is the funny thing: derby puts out 25001 error. Obviously it wants a

AW: AW: Performance question, Closing Prepared statements

Hii Matt, Thank you very much for that blog it is really awesome and helps me a lot. Best Regards Malte -Ursprüngliche Nachricht- Von: Matt Pouttu-Clarke [mailto:matt.pouttu-cla...@icrossing.com] Gesendet: Mittwoch, 9. März 2011 16:52 An: Derby Discussion Betreff: Re: AW: Performance

AW: Performance question, Closing Prepared statements

Hi bryan, Thanks a lot for your hints. I am using derby embedded in my application and it is just one table. I first thought of doing just one commit for a load, but I guess that is probably not so well, since for the initial load there are 101004 records each 514 bytes long to be filled. Is

Performance question, Closing Prepared statements

Hi to all, I'd like to do huge manipulation on a single table. Jowning there is a routine within derby to do bulk imports though, I cannot really use it, snce there are updates inserts and deletes to be done interpreting some command field with in each record. I am not quite sure if it is state

AW: Derby memory consumption with many databases

Hi to all who know more about Derby In this particular situation mentioned below, is it possible to work with views that are able to use the certain table of the particular schema of the user that is loged in. It is just a thought that may be then the db abstraction layer Cayenne provides still

AW: primary key constraint violation on autoincrement id

Hi Stuart, I think you should write logs then you may are able to analyse it this is a problem of your program or not. May be the ID you are using as primary key is not as unique as you think. Good luck and best regards Malte -Ursprüngliche Nachricht- Von:

AW: AW: AW: OOM with millions of weakly-referenced Derby objects

Hi Dag, The problem in my case is, that I don't have access to any AIX-Computer, and that is really a pity, because I cannot reconstruct the scenario on my own and watch it with my own eyes. That all happened on a production system and the provider denies trying it out again. But attached you

AW: AW: OOM with millions of weakly-referenced Derby objects

Yes this is the API I am reffering to. Well actually it says that, but in my case it did not do it. It needed a long time, several minutes. Reason as it turned later out, after getting the output in a file a lot of IOExcceptions. I never got those on windows nor on Solaris. Thr original logic of

AW: OOM with millions of weakly-referenced Derby objects

Hi to all again, I could analyse and solve the problem. Originally I thought that if ij findes something phony it would give a return code as its signature suggests it. Actually after finding out that the trouble stays somehow within ij after minutes of processing and that I have to set

AW: Information for derby-user@db.apache.org

Hi, I have a little routine, that is supposed to delete some records after a certain due date. It looks like the following: public void reorganize(long defermentPeriod) { m_strBuf.delete(0, m_strBuf.length());

AW: Information for derby-user@db.apache.org

Hi to all, Well I found the trouble. I was doing something weird on Freiday evening, and was not able to see it today as well being a bit blind. So never mind ... Malte -Ursprüngliche Nachricht- Von: malte.kem...@de.equens.com [mailto:malte.kem...@de.equens.com] Gesendet: Montag,