Table fields contain "#" sign, please help!

[xinxin2]

I am using WSAD5.0, and some database tables' fields contain "#" at the end. When I using these tables from WSAD, I got an error message "The column name, XXX#, is not a valid identifier".
I am not able to change the column name, does anyone know how to solve this problem?

Thanks you all so much!

[xinxin2]

Hi, thanks for replying.

I use these tables to generate Entity Beans in WSAD5.0, after I created entity
beans (CMP), tried to deploy them, they will give me an error message said
"Column name XXX# is not a valid identifier". Do you think this can be solved without changing the database table names?

Thanks a lot!

[super_jack]

try:
select XXX# as column_alias_name1,YYY# as column_alias_name2,.... from ...where ...

then get the value use the alias:
resultset.getString(column_alias_name1),....

[xinxin2]

Hi,

I created a view for the table which contains pound sign (#) column, but I do not know how to generate entity bean for that view, does anyone know how to do it?

Thanks