Re: AW: [enhydra] How set null value to integer or long DB field in DODS

[João Paulo Ribeiro <jp@xxxxxxxxxxxx>]

Hi!

Alfred was talking about using DODs.
If you use a PreparedStatement to do it there is no doubt that it will work.
If i understood correctly that wasnt the ideia.

Best regards.
João Paulo Ribeiro




Steve Riley wrote:

That's not quite true. The following code will set specific BigInt
fields to NULL. It's a workaround.


DBConnection dbc = Enhydra.getDatabaseManager().allocateConnection();

dbc.setAutoCommit(false);

// For bid or salesorder, need some integer fields to be null
PreparedStatement ps2 = ((EstimateDO)eiDO).getInsertStatement(dbc);
if (order.isBid())
    ps2.setNull(3,Types.BIGINT);    //salesordid
else
ps2.setNull(2,Types.BIGINT);    //bidid
ps2.executeUpdate();

...
dbc.commit()

On Fri, 2005-08-05 at 18:11 +0200, Madl Alfred - Together AT wrote:
  

Hi !

This is a rather old DODS issue. You simply can not set datatypes to
NULL that are mapped to Java primitive types...I think we should address
this issue in one of the next DODS releases...

Greetings.

Alfred

-----Ursprüngliche Nachricht-----
Von: Daniel Guryca [mailto:daniel.guryca@xxxxxxxxxx] 
Bereitgestellt: Freitag, 05. August 2005 13:56
Bereitgestellt in: Enhydra
Unterhaltung: [enhydra] How set null value to integer or long DB field
in DODS
Betreff: [enhydra] How set null value to integer or long DB field in
DODS


I have a problem with setting DB field which is of type INTEGER or
BIGINT.

It is imposible to set this field with DO object to null value. (0 is 
saved instead of null) - because it accepts java int (long) types only.
It is also imposible to get null value from this field. (0 is return) - 
because it gets java int (long) types only.

So is there a way how to set or get a value of null for DB fields of 
type INTEGER or BIGINT?

Thank you for your help.

    

--
You receive this message as a subscriber of the enhydra@xxxxxxxxxxxxx mailing list.
To unsubscribe: mailto:enhydra-unsubscribe@xxxxxxxxxxxxx
For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
  

-- 
João Paulo Ribeiro | Senior Software Engineer
jp@xxxxxxxxxxxx

PHONE: + 351 253 305 250 
FAX  : + 351 253 305 250
www.mobicomp.com
 
________________________________________________________________

About Solutions | Wireless World

CONFIDENTIALITY NOTICE: This message, as well as existing attached files, is confidential and intended exclusively for the individual(s) named as addressees. If you are not the intended recipient, you are kindly requested not to make any use whatsoever of its contents and to proceed to the destruction of the message, thereby notifying the sender. 
DISCLAIMER: The sender of this message can not ensure the security of its electronic transmission and consequently does not accept liability for any fact which may interfere with the integrity of its content.