On Wed, 11 Oct 2000, Aaron Mulder wrote:
> On Wed, 11 Oct 2000, Daniel Schulze wrote:
> > Well, and when you do a user query over dozens of tables?!
> > I dont see the point that his has to be a heavy operation!
> > My query only returns 0 or 1 row with 5 columns!!!
>
> Unfortunately, it seems like Oracle constructs a DBMD with all the
> metadata up front. So perhaps it isn't the greatest implementation.
So I was right with *unprofessional* ...
>
> > I dont know either. I just said TransactionManager.begin ()
> > before store.init (), which creates a Transaction with status=active
> > and after return of store.init() I check the Transaction state again:
> > state=marked as rollback ?!
>
> Okay, as soon as I get a chance I'll look into this.
I had a look. Minerva catches the SQL exception, calls setError () and
... (didnt want to follow all the path down, but I think it is) and
then throws the SQL exception.
> I have
> PostgreSQL installed (RedHat did it for me), but no idea how to use it.
> Can you give me a 30-second overview of creating a DB and user and then
> I'll try this out. I think I should use PostgreSQL because you can't roll
> back a table create in Oracle...
I m not familiar with RH so I dont know, where it installs the commands.
You need:
as user postgres call: initdb -D <db-dir>
(maybe the install script did that. Have a look if the $PGDATA points
to an empty directory or not)
as user postgres call: createuser
(this creates a new user, if you want to change the password, I think
you have to do it via sql (one of the systemtables pg_user?))
as user postgres or if you selected it as dbuser call: createdb <dbname>
(creates the database you can use then like:
jdbc:postgresql://localhost:5432/<dbname>
JDBSUser is then you user you ve created)
use psql to connect to postgres on the console
HTH
> > Why, when it even works with Hypersonic, InstantDB, Postgres,...
>
> Because all together those database products have what, 5% market
> share? And that's probably being generous. If our product doesn't work
> with Oracle, it doesn't work.
>
You are right - my English :-(
I wanted to say that if even the drivers for these Databases support the
MetaData I actually expected that products like Oracle would do this
at least as same as good. You know what I mean? :-|
I currently test the transaction stuff in the Comands
itself, like Dan said. If I get it working properly, we can do it then
this way and keep the opportunity to move back.
But before I would really like to see some real life performance datas,
because the MetaData way is defnitely the more straightforward solution.
bye Daniel
