• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JDBC connection in Oracle Application Server 10g

 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi guys,

I have a war file with a simple JDBC connection. I didnt use DATA SOURCE coz im only using one table. I have my application developed using myeclipse and apache tomcat
which is perfectly connecting to Oracle 10g Database. But when i uploaded the war file in the application server and tried to run the web app, it seems
like its not selecting/updating/inserting into the table. I checked the logs but did not found any significant JDBC error. I used ojdbc14.jar in my
web app.


Please help.


thanks,
yan
 
yan yan
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
this is now ok.

MyEclipse tomcat is allowing the executeQuery on insert/update statements. But doesnt have any error raised on Oracle Application Server release 3.
I tried to deploy it on OC4J standalone and found the error "SQL string is not Query".

unfortunately,there was one statement in my code that uses ExecuteQuery on update statement.




Many thanks.



 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic