openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josef Eisele (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-627) Write-error with large VARCHAR-Fields and PostgreSQL
Date Fri, 06 Jun 2008 11:48:45 GMT
Write-error with large VARCHAR-Fields and PostgreSQL
----------------------------------------------------

                 Key: OPENJPA-627
                 URL: https://issues.apache.org/jira/browse/OPENJPA-627
             Project: OpenJPA
          Issue Type: Bug
    Affects Versions: 1.0.2
         Environment: Geronimo 2.1.1 with Postgres (Driver postgresql-8.2-508.jdbc3.jar) on
Ubuntu-Linux
            Reporter: Josef Eisele


I receive Errors when I try to persist Data:

public class PasswortregelPAO implements Serializable {
	....
	@Column(name="passwort_aufbau")
	private String passwortAufbau;
        ....
...
		entityManager.persist(pao);
...

on DB-Fields with Definitions >= VARCHAR(170)

ALTER TABLE vesuv.passwortregel DROP COLUMN passwort_aufbau;
ALTER TABLE vesuv.passwortregel ADD COLUMN paswort_aufbau varchar(170);
ALTER TABLE vesuv.passwortregel ALTER COLUMN passwort_aufbau SET STORAGE EXTEND;


LOG:
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: FEHLER: Wert zu lang fr Typ
character varying(120) {prepstmnt 32613590 INSERT INTO vesuv.protokoll_info (id, attribut,
entitaet_id, entitaetstyp, wert_alt, wert_neu, protokoll_eintrag_fk) VALUES (?, ?, ?, ?, ?,
?, ?) [params=(long) 239, (String) passwort_aufbau, (long) 24, (String) PASSWORTREGEL, (String)
, (String) dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd..., (long)
128]} [code=0, state=22001]

With any size bigger than 170, I got the same error "FEHLER: Wert zu lang fr Typ character
varying(120) ". 

VARCHAR-Values up to 160 work without any problem.

In addition I have to say, reading of VARCHAR-Data > 170 Char. works without problem.


=> I tried to change the database-Definition from VARCHAR(170) to TEXT and to define the
PAO @Column(length=200 ...) , but nothing helped.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message