seam-gen: NumberFormatException

[definitiverant]

Hello,

I'm using seam-gen to generate an application from an existing Postgres database (http://docs.jboss.org/seam/latest/en-US/html/gettingstarted.html). I can create and run the application and log in OK using admin. However, I am getting the following error when I try and edit any of the data contained within the tables existing in the d/b via the application:

java.lang.NumberFormatException: For input string: 131,096
     at java.lang.NumberFormatException.forInputString(Unknown Source)
     at java.lang.Integer.parseInt(Unknown Source)
     at java.lang.Integer.valueOf(Unknown Source)
     at org.jboss.el.lang.ELSupport.coerceToNumber(ELSupport.java:281)
     at org.jboss.el.lang.ELSupport.coerceToNumber(ELSupport.java:259)
     at org.jboss.el.lang.ELSupport.coerceToType(ELSupport.java:331)
     at org.jboss.el.ExpressionFactoryImpl.coerceToType(ExpressionFactoryImpl.java:46)
     at org.jboss.seam.el.SeamExpressionFactory.coerceToType(SeamExpressionFactory.java:70)
...

I am using Seam 2.2.0.GA, Eclipse Galileo and JBoss 5.1.

Thanks for any assistance.

[definitiverant]

Fixed: primary column field in postgres database was of type numeric. Changed to integer and it worked OK.

[definitiverant]

I am still experiencing this problem: http://seamframework.org/Community/SeamgenTestNGFailing

[lvdberg]

Hi,

if you don't send in additional information and/or code nobody can help you. With I assume is that the column field in the database is not of the same type as the value you want to persist. You error states 131,096. If you're in the US and you want to persist onehundredthirthy one thousand and ninty six, that's ok, but if you want to store a Float it's not; you need a point separator (or nothing). It all depends on the conversion needed between the screen value and you definition in the DB.

Leo