File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes Problem With Sybase XA JDBC 2 Driver and WAS 6 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Problem With Sybase XA JDBC 2 Driver and WAS 6" Watch "Problem With Sybase XA JDBC 2 Driver and WAS 6" New topic
Author

Problem With Sybase XA JDBC 2 Driver and WAS 6

Nick Bhatt
Greenhorn

Joined: May 14, 2008
Posts: 6
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

Joined: Jan 10, 2002
Posts: 61092
    
  66

"kayn", please check your private messages for an important administrative matter.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem With Sybase XA JDBC 2 Driver and WAS 6