Re: How do I Open / Close a db using odbc interface?

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]

Re: How do I Open / Close a db using odbc interface?

. 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

Re: Java equivalent of phpmyadmin for derby?

hi, there is a derby.war package that can be deployed inside a web application server e.g. tomcat. see http://db.apache.org/derby/docs/10.1/adminguide/cadminservlet98430.html cheers... On Tue, 2007-04-17 at 15:27 -0700, Stanley Bradbury wrote: Peter Wayner wrote: Is there a Java version

Re: Users authentication - design problem

hi, a few thoughts... I don't think that any of your users have the knowledge to copy and boot the database. or the intention to change the data in your database, therefore you could just create a jar file and embed it. and when your application does not support modifications on the database then

ERROR 58009: Network protocol exception

hi, I have written a new authentication Class that implements UserAuthenticator according to [1] for my derby network server. but unfortunately i get the following error: --- ERROR 58009: Network protocol exception: DSS chained with same id at the end of same id chain parse. The connection has

LDAP groups support?

Hi, are there any plans to support LDAP groups [1] for user authentication? thanks in advance. cheers. [1] http://db.apache.org/derby/docs/dev/devguide/cdevcsecure863676.html

Re: DB design tool?

hi, IBM Rational Data Architect, even it has a few little bugs its a great piece of software. especially if you're using with IBM Rational Software Architect. cheers. On Sun, 2007-03-18 at 09:42 -0700, ndario wrote: Hello, I am interested in what tool (preferably free) do you use for

Re: renaming columns

hi, then why it's described in the reference manual http://db.apache.org/derby/docs/10.2/ref/ref-single.html#crefsqljrenamestatements btw: it doesn't work for me either... i'm using also 10.2.2.0 cheers. On Fri, 2006-12-29 at 13:22 +0100, Øystein Grøvlen wrote: Ralf Wiebicke wrote: Hi!

Re: renaming columns

sorry, my fault. i was looking at the same time the latest alpha version of the documentation that includes column renaming, but 10.2 not. http://db.apache.org/derby/docs/dev/ref/ref-single.html#crefsqljrenamestatements then why it's described in the reference manual

run script from java - w/ ij

hello, i looked in the documentation and searched the web without any luck on how to run an external sql script from inside a java program - this means without using the interactive shell ij (run '/path/to/script.sql';) since 'run' is an ij command only. i'm thinking (at least hoping) since the