IBATIS problem with '#' sign

[mcasanket]

Hi All ,
I am new to this community. In one requirement I'm using IBATIS first time. In one query I have to search one string that is having '#' in it. For Example "TYBX#".

SELECT * FROM test WHERE to_code = 'TYBX#';

When I put the above query and start the server the IBATIS starts showing errors....!

My other problem is some tables column names are having '#' sign in it. So again it is showing errors on console.

Please please help...!

Thanking you in advance!

[mcasanket]

Hi have got one solution for the time being...

I am passing the map, that is having the column name, and other values that is having '#' in it. It is working fine. But if there is any other solutions then please let me know...

Thanking you!