This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Primary Key contains "#" sign

 
xin wen
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi friends,
I am using WSAD4.0.2, and some database tables' primary key 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!
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
create a view on that table with different column names.
 
xin wen
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Simon for replying,
Is this the only way to do it? 'Cause I have a lot of tables have that kind of fields, do we have another way to solve it? By the way, I use these tables to generate entity beans (CMP).
Thanks a lot!
[ April 16, 2003: Message edited by: xin wen ]
 
xin wen
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, we create a view for that table, but I do not know how to generate entity bean using that view. Does anyone know how to do it?
Thanks a lot!
 
M Dollenkamp
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hmm I though mapping entity beans to views was not supported in wsad 4.02.
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
running out of options...
 
xin wen
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for helping!
Is it supported on WSAD5.0? Can I map a CMP entity to a View in WSAD5.0?
Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic