Re: AW: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-08-17 Thread Ocke Janssen

Hi Micha,

Michael Strobel wrote:

Hi Ocke,

  

I'm back :-)



That's great news, at least me ;-) Hope you had a good vacation.
  

Yes, Indeed I became a father. So less sleep. :-)
  

First of all I have to clarify that default values which you enter
in the table design window are never propagated to the driver.
These default values are only UI values which will be shown when
you open the table to add data.
What may me confuse is the fact that your alter command is called.
Normally I would argue that some props of the column type has
changed. May be the problem is databasemetadata::getColumns for
that table (type nfo of the column), but that is only a guess.



What could be the problem with properties of the column type
exactly? If it is because of a difference between the result of
getTypeInfo() and getColumns() this is likely a fault in our JDBC
driver, which explains why the problem does not appear with MySQL
and the SDBC-JDBC bridge, but as far as I could see the problem is
independent of the column type. I'll check that and the results of
the both methods.
  
I only thought that this could be the problem of the alter statement. 
The table design checks if any changes happen. The best place to look at 
is :DoSave in TableController.cxx in dbacces or alterColumns.


- oj

Best regards,
Micha

  



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
  



--
Ocke Janssen  Tel: +49 40 23646 661, x1
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg   http://www.sun.com/staroffice

Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, 
D-85551 Kirchheim-Heimstetten

Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



AW: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-08-17 Thread Michael Strobel
Hi Ocke,

> I'm back :-)

That's great news, at least me ;-) Hope you had a good vacation.

> First of all I have to clarify that default values which you enter
> in the table design window are never propagated to the driver.
> These default values are only UI values which will be shown when
> you open the table to add data.
> What may me confuse is the fact that your alter command is called.
> Normally I would argue that some props of the column type has
> changed. May be the problem is databasemetadata::getColumns for
> that table (type nfo of the column), but that is only a guess.

What could be the problem with properties of the column type
exactly? If it is because of a difference between the result of
getTypeInfo() and getColumns() this is likely a fault in our JDBC
driver, which explains why the problem does not appear with MySQL
and the SDBC-JDBC bridge, but as far as I could see the problem is
independent of the column type. I'll check that and the results of
the both methods.

Best regards,
Micha

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]