Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Thu, 06 Apr 2006 19:35:52 +0200
From: "Bernt M. Johnsen" <Bernt.Johnsen@Sun.COM>
Subject: Re: [jira] Commented: (DERBY-1164) 'show tables' and 'describe'
 commands in ij
In-reply-to: <524596594.1144344343168.JavaMail.jira@ajax>
To: "Daniel John Debrunner (JIRA)" <derby-dev@db.apache.org>
Message-id: <20060406173552.GA7927@localhost.localdomain>
Organization: Sun Microsystems
MIME-version: 1.0
Content-type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature"; boundary=AqsLC8rIMeq19msA
Content-disposition: inline
User-Agent: Mutt/1.5.9i
References: <1962252478.1143640343803.JavaMail.jira@ajax>
 <524596594.1144344343168.JavaMail.jira@ajax>


--AqsLC8rIMeq19msA
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

>>>>>>>>>>>> Daniel John Debrunner (JIRA) wrote (2006-04-06 18:25:43):
> ij is intended as a fairly neutral JDBC client that works against
> any database engine. While it may be ok to tailor ij for Derby,=20

Actually, I think should be an requrement that even if ij is somewhat
tailored to Derby, it should remain database independent. That's one
of the really nice features of ij.

> having to need a specific version of ij to talk to a specific
> version of Derby will cause problems.=20

Agree! When testing/experimenting I often find myself having two
connections in ij, one to a db from trunk and another which is 10.1. I
would consider vetoing an ij tie in to specific Derby versions.

> It would be interesting for you to provide a patch that uses the
> DatabaseMetData methods directly and displays the resultant
> ResultSets using the standard ij code. The we could think about the
> "nice layout", what's nice to you maybe horrible to someone else.

JDBC should provide enough metadata for this.=20

--=20
Bernt Marius Johnsen, Database Technology Group,=20
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

--AqsLC8rIMeq19msA
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFENVF4lFBD9TXBAPARAvsbAJ4qWhpfOjYPUJZoKiToQUx9EQhsSwCfbXvV
ddvjnhdsatGjVHzyU60jdcI=
=ciBR
-----END PGP SIGNATURE-----

--AqsLC8rIMeq19msA--