Best Database

[cunhao]

I`m working with EntityBeans to manage persistent structures. Until now, I have used JBoss with de default database HypersonicSQL to make simple operations. But now I need another tool, because with this I can´t, for example, access to the contents to the database. Could anybody tell me a database supported by JBoss with a graphical interface or any way to access to its contents (see it or change it)? Where could I obtain the drivers?

I would thank any help very much

[umabush]

Have tried downloading TOAD from QWEST. I love it

[davidjencks]

Last I knew, TOAD (originally at least Tool for Oracle Application Developers) was Oracle and Windows only. Has this changed?

Hsqldb has a viewer included in hslqdb.jar. There have been some very recent posts on how to use it.

[dfuse]

I'm using Eclipse to develop, and the Quantum plugin to look at the data inside the Hypersonic db.

[dfuse]

I'm using Eclipse to develop, and the Quantum plugin to look at the data inside the Hypersonic db.

[jonmartin]

Both mySQL and PostgreSQL works. On Windows mySQL almost outperforms Oracle (ref test in eWeek). Also many other databases should work, just look in jboss\docs\examples\jca to find a number of supported databases. I suppose you should go for version 4.0.12 or later if you use mySQL, to get transactions and stuff.