Re: [RMX:#] Re: Strange loss of data during INSERT

On Thursday, March 24, 2011 4:26:30 am Altmann, Sebastian wrote:
> Thanks for your answer.
>
>
>
> I'm not sure if the Password is NULL or a empty string,
>
> I will check this in the evening, I have no access no...

I thought you saw the passwords in the log file which would seem to indicate NOT
NULL or not empty string.

>
>
>
>
>
> If I run the INSERT statement from pgAdmin it works fine!

Are you sure your JEE app and pgAdmin are both pointing at the same database?

>
>
>
> Here is the statement from the log file (with original personal data,
> after this are just my dummy entries for development):
>
>
>
> BEGIN
>
> insert into player (birthdate, eMail, firstname, lastname, password,
> username, id) values ($1, $2, $3, $4, $5, $6, $7)
>
>
> Parameter: $1 = '3885-08-14 00:00:00', $2 = 'alt(at)isogmbh(dot)de', $3 =
> 'Sebastian', $4 = 'Altmann', $5 = 'alt.iso', $6 = 'alt', $7 = '54'
>
>
> COMMIT
>
>
>
>
>
>
>
>
>
> Sebastian Altmann
>
> ________________________________
>
>
>
> ISO Software Systeme GmbH
>
> Eichendorffstrasse 29
>
> 90491 Nürnberg
>
>
>
> Tel.: +49/(911) - 99594-0
>
> Fax: +49/(911) - 99594-129
>
>
>
> mailto:Sebastian(dot)Altmann(at)isogmbh(dot)de
>
> http://www.isogmbh.de
>
>
>
> Amtsgericht Nürnberg HRB 18299
>
> Geschäftsführer: Harald Goeb
>
> Sitz: Nürnberg
>
>
>
> Von: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] Im Auftrag von Willy-Bas
> Loos
> Gesendet: Donnerstag, 24. März 2011 12:16
> An: Altmann, Sebastian
> Cc: pgsql-general(at)postgresql(dot)org
> Betreff: [RMX:#] Re: [GENERAL] Strange loss of data during INSERT
>
>
>
> Are you sure the password is NULL? Some fields are not shown in pgAdmin
> if they are too long, but that seems improbable to me for passwords.
>
> pgAdmin also has an option "Show NULL values as <NULL>" (in
> file|options|query).
>
>
>
> If you take the SQL from the log, can you reproduce this in postgres?
>
> If so, please email the code (i hope it's work with personal data
> scrambled ?).
>
>
>
> cheers,
>
>
>
> WBL
>
> On Thu, Mar 24, 2011 at 12:01 PM, Altmann, Sebastian
> <Sebastian(dot)Altmann(at)isogmbh(dot)de> wrote:
>
> Hi everybody,
>
>
>
> i'm having a very strange Problem:
>
>
>
> My JEE Application initially persists Users at startup.
>
>
>
> The problem is that the passwords are not stored,
>
> while other data with the same datatype on this table are stored
> correctly!?!
>
>
>
> If I turn log_statement to 'all' in config I can see the INSERT
> statement including the correct password(!!!) in log file,
>
> but if I take a look with pgAdmin all password fields are empty...
>
>
>
> When I try to execute the insert statement in pgAdmin it works fine.
>
>
>
> By the way: If I switch the DB to OracleXE, it works fine
>
> (But actually I don't want to user Oracle... )
>
>
>
>
>
> Thanks for any ideas
>
>
>
>
>
> Sebastian Altmann
>
> ________________________________
>
>
>
> ISO Software Systeme GmbH
>
> Eichendorffstrasse 29
>
> 90491 Nürnberg
>
>
>
> Tel.: +49/(911) - 99594-0 <tel:%2B49%2F%28911%29%20-%2099594-0>
>
> Fax: +49/(911) - 99594-129 <tel:%2B49%2F%28911%29%20-%2099594-129>
>
>
>
> mailto:Sebastian(dot)Altmann(at)isogmbh(dot)de
>
> http://www.isogmbh.de
>
>
>
> Amtsgericht Nürnberg HRB 18299
>
> Geschäftsführer: Harald Goeb
>
> Sitz: Nürnberg

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com