File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC fails with Tomcat

 
O. Ziggy
Ranch Hand
Posts: 430
Android Debian VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to send an array to a pl/sql module but for some reason i am unable to get the connection object.

Here is the line of code that fails



Here is the stack trace



And here is my connection config

Struts Web.xml file



Metainf/context.xml


[ September 26, 2008: Message edited by: O. Ziggy ]
[ September 26, 2008: Message edited by: Bear Bibeault ]
 
Scott Selikoff
author
Saloon Keeper
Posts: 3890
15
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For starters, Oracle and your driver are the culprit, not JDBC. This is one of the reasons I strongly recommend against Oracle-specific implementations of JDBC. You should be using interface classes like Statement/Callable, and not relying on Oracle classes lest you never want to be able to port your code to a new database.

As for the error, since you're getting a ClassCastException exception its most likely your class path. Are you 100% its not failing on this line? The exception makes more sense if this is the bad line:

 
Scott Selikoff
author
Saloon Keeper
Posts: 3890
15
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Btw thanks O Ziggy, you helped inspired #4 in my recent blog post 5 Tips to be a Good JDBC Programmer
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic