[jboss-user] [JBoss Seam] - Re: Persistence - Switching DB to Postgres - Schema Export f

[tkrah]

Ok resolved the classloader issue, removed the jar from WEB-INF/lib and copyed it do server/default/lib from jboss install.

Works now except:


  | Caused by: org.postgresql.util.PSQLException: FEHLER: Wert zu lang fuer Typ character varying(1024)
  | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
  |         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
  |         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
  |         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
  |         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:332)
  |         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:324)
  |         at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:82)
  |         at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:252)
  |         ... 165 more
  | 
  | 

How can i find out which table, column and which dataset goind to insert causes this?
And how to fix this? The schema mapping might be little bit wrong, if it maps a column to varchar(1024) but examples being inserted are bigger, so how to find out whre exactly this exception raises and where can i fix the mapping to allow verchar(4096) or anything else?

kind regards


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3958875#3958875

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3958875