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@xxxxxxxxxx', $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.Altmann@xxxxxxxxxx > > http://www.isogmbh.de > > > > Amtsgericht Nürnberg HRB 18299 > > Geschäftsführer: Harald Goeb > > Sitz: Nürnberg > > > > Von: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Im Auftrag von Willy-Bas > Loos > Gesendet: Donnerstag, 24. März 2011 12:16 > An: Altmann, Sebastian > Cc: pgsql-general@xxxxxxxxxxxxxx > Betreff: [RMX:#] Re: 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.Altmann@xxxxxxxxxx> 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.Altmann@xxxxxxxxxx > > http://www.isogmbh.de > > > > Amtsgericht Nürnberg HRB 18299 > > Geschäftsführer: Harald Goeb > > Sitz: Nürnberg -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
