Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem With Sybase XA JDBC 2 Driver and WAS 6

 
Nick Bhatt
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
We are migrating an appln from WAS5 to WAS6 and facing a weird problem. We are using the Sybase XA JDBC 2 driver with WAS 6.1.0.11. We have a simple query like "select A as B from db..table_name where C=123". The error we get when we try to execute the query is "java.sql.SQLException: S0022: Invalid column name A". When we remove the "as B" part from the query it works fine but we need to have the data returned mapped to B as we have a lot of java code banking on that particular name to process business data. Any suggestions as to what could be a good solution for this?

TIA,
Kayn
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65111
89
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"kayn", please check your private messages for an important administrative matter.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic