Win a copy of Machine Learning with R: Expert techniques for predictive modeling this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

Getting invalid column specification error while upgraded the websphere server from 6.1 to 7 version

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We upgarded our environment to websphere 7 from 6.1 version. Some of the page are throwing sqlsyntax exception invalid table.column specification error. but when deployed to websphere 6.1 the application is running fine.

So I tried testing by calling as standalone from junit testcase. While calling from Junit there is no sqlexception thrown.

We upgraded the websphere server to 7 and also we have placed the ojdbc6.jar in the classpath of the server.

Mainly the error is thrown from Update query. which is used to update the flat value. First we are inserting 0.0 values in the insert statement and after that sql query is runned and the values from that is used to update the table. when i directly execute the procedure from toad it's running fine.

Anybody can help me in resolving this issue
 
You've gotta fight it! Don't give in! Read this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!