Hi Gert,
the problem that OOo crashes was fixed in version RC2. By the way you
restart OOo and the quickstarter after setting the JDBC driver class?
Could please write issues for the other problems and send them to msc.
(Our QA)
Best regards,
Ocke
Gert Blij wrote:
Hi Ocke,
-----Original Message-----
From: Ocke Janssen [mailto:[EMAIL PROTECTED]
Sent: Wed 12 October 2005 09:01 AM
To: [email protected]
Subject: Re: [dba-users] ALTER TABLE with JDBC drivers
Hi Roger,
the problem in making the general JDBC driver "ALTER TABLE"
capable is that the alter table statement is not standardized.
So every database has his own format :-(
I think there is more to it than that.
Between RC1 and RC2 there is some weird behaviour creeping in to Base.
I am on WinXP and also use MySQL as my database engine and connect via the
JDBC driver. This is my history this week.
I loaded RC2 and the result was that Base could not find the JDBC driver at
all. The Options|Java|Classpath was set up correctly.
I then uninstalled RC2 and reinstalled RC1.
This caused for one of my databases to be completely unmodifyable. I make
changes to a row, go to the next row and the previous row snaps back to the
original data. I can't delete any rows, nothing. IOW, exactly the same
behaviour as described by Roger in his original post. (below)
Another database worked fine, until I created a new table using MySQL Query
Browser. Now Base behaves the same on that database as well. Can not change
any data.
Also note that on the [EMAIL PROTECTED] list there was a post yesterday of
someone
who had the same problem that Base could not find the JDBC driver. I am not
quite sure which release he used.
Apart from all that, I was using Base this morning to do some heavy data
modifying and it crashed all over the place, something it had not done in
pre-RC1 for a long time.
I really hope that the developers are aware of this, because it is quite a
step backwards and I would hate for this to be a real problem that is
carried into 2.0 release proper.
Cheers
Gert
Hi,
I've noticed that in Base 2.0rc2 (and also earlier
versions) that when
you use the JDBC bridge OOo will not let you modify any of the
columns. This seems to be the case regardless of the actual JDBC
driver used and its capabilities.
E.g. if you create a "JDBC" database with the mysql jdbc driver you
cannot alter the columns, but if you use the "Mysql (JDBC)"
driver you
can. Presumable the latter is just a thin wrapper around the JDBC
driver which does something special.
Couldn't the JDBC bridge be written to allow column modifications?
Roger
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Sachsenfeld 4 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Sachsenfeld 4 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
