Ho Ocke, In the end I found the solution to be to upgrade my JRE from 1.4 to 5.0 (1.5). It seems that pre RC snapshots were quite happy with 1.4, but the RC are not.
I am not technical enough to debate the validity of the above statement, but it did solve my problems :-) Cheers Gert > -----Original Message----- > From: Ocke Janssen [mailto:[EMAIL PROTECTED] > Sent: Thu 13 October 2005 08:00 AM > To: [email protected] > Subject: Re: [dba-users] ALTER TABLE with JDBC drivers > > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
