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]
