derby.jar Classpath

2012-07-17 Thread Peter Davis
Hi I've been using derby db for a while now and have until now been willing to work around a problem with classpath. It appears that I have to explicitly place derby.jar on the class path using one of the standard mechanisms. e.g. -cp or in the manifest of the running jar. Unfortunately my

Re: derby.jar Classpath

2012-07-17 Thread Rick Hillegas
On 7/17/12 3:23 AM, Peter Davis wrote: Hi I've been using derby db for a while now and have until now been willing to work around a problem with classpath. It appears that I have to explicitly place derby.jar on the class path using one of the standard mechanisms. e.g. -cp or in the

Re: derby.jar Classpath

2012-07-17 Thread Tim Watts
On Tue, 2012-07-17 at 05:56 -0700, Rick Hillegas wrote: On 7/17/12 3:23 AM, Peter Davis wrote: Hi I've been using derby db for a while now and have until now been willing to work around a problem with classpath. It appears that I have to explicitly place derby.jar on the class path

schema-questions

2012-07-17 Thread Malte.Kempff
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

Re: schema-questions

2012-07-17 Thread Rick Hillegas
Hi Malta, One general issue: I see that you are trying to use BUILTIN authentication. Note that BUILTIN authentication is not production-quality. It is appropriate only for testing/development purposes. In 10.9.1 we introduced NATIVE authentication, a production-quality replacement for

Re: schema-questions

2012-07-17 Thread Tim Watts
On Tue, 2012-07-17 at 16:44 +0200, malte.kem...@de.equens.com wrote: Another thing I am wondreing is, that it seems not to matter using a user or not using following derby.properties, though: derby.stream.error.logSeverityLevel=0 derby.database.fullAccessUsers=tech

AW: schema-questions

2012-07-17 Thread Malte.Kempff
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

2012-07-17 Thread Malte.Kempff
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

Re: AW: schema-questions

2012-07-17 Thread Rick Hillegas
On 7/17/12 9:15 AM, malte.kem...@de.equens.com wrote: 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

Re: AW: schema-questions

2012-07-17 Thread Tim Watts
On Tue, 2012-07-17 at 18:13 +0200, malte.kem...@de.equens.com wrote: I start tomcat (version 6) with ist startup batch file only OK. What displays when you type echo %JAVA_OPTS% at the command prompt? To verify whether it's being passed through to Tomcat try saving the following to

Updating Autoincrement values

2012-07-17 Thread Matthew Hauck
I have an old database that I need to import into apache derby. This seemed to be a pretty easy thing to do, except when I realized that my autogenerated ID column is stuck thinking the next autoincrement value is 1. i.e. since my import statements from the old database included IDs (which are

Re: Updating Autoincrement values

2012-07-17 Thread Matthew Hauck
Okay, I finally found this: http://db.apache.org/derby/docs/10.6/ref/rrefsqlj81859.html ALTER TABLE tauto ALTER COLUMN i RESTART WITH 6 -- Matt Hauck From: Matthew Hauck/San Francisco/IBM@IBMUS To: derby-user@db.apache.org, Date: 07/17/2012 05:23 PM Subject:Updating