• 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

could not connect to oracle database from struts application

 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i am trying to develop a small struts application which connects to oracle database. i added the necessary parts in datasourse element of the struts-config.xml. but when the server starts the following error displayed at the console
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'jdbc:oracle:thin:@192.168.8.202:1521:orcl10'

in set the following jar files in the build path. i am using eclipse ide
ojdbc14.jar,
classes111.jar

could you please help me to resolve my problem.
thanks
jittos....
 
Jitto P.Jose
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
is anybody out there to help me?....please
 
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Are those jars being copied to the WEB-INF/lib folder?
If not, you should.
 
Jitto P.Jose
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i set it in the build path of application. and also copied to the lib directory manually. but it didn't work.
is there any other jar files specially for oracle. in ordinary java application this connection strings worked with out any problem. but in struts application it creates problem. any more idea about it?
thanks
jittos....
 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Me too have the same problem
what are main reasons for "HTTP Status 404 - Servlet action is not available"
to occur in struts while using < datasource > tag.....I am using eclipse 3.2 and oracle 10g...i have configured the build path with
jdbc driver ojdbc14.jar,c
ommons-pool-1.3.jar,
commons-dbcp-1.2.2.jar,
commons-collections-3.2.jar...

when i comment <datasources> tag in struts-config.xml it works properly.....Otherwise it throws the above pblm......help me
 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Iam also very new to struts , my application is working fine with oracle connectivity , maybe you should try and add spring-jdbc.jar into the path.
Hope this would be of some help.
 
Jitto P.Jose
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
could you please sent the data-source part of the struts-config file where you put the driver details. also could you please send me the list of jar files that you added in the build path.
thank you.
jittos....
 
hw khan
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
For spring framework, you have to include following jar files:

1. spring.jar
2. spring-aop.jar
3. spring-bean.jar
4. spring-core.jar
5. spring-context.jar
6. spring-dao.jar
7. spring-hibernate.jar
8. spring-mock.jar
9. spring-jdbc.jar
10. spring-orm.jar
11. spring-remoting.jar
12. spring-support.jar
13. spring-web.jar
14. spring-webmvc.jar
For Hibernate support, you have to include following jar files into the path of server.
And path for the jar file is C:\Program Files\MyEclipse 5.1.0 GA\eclipse\plugins\com.genuitec.org.hibernate.eclipse_5.1.0\myeclipse-data\3.0\lib

1.antlr-2.7.5H3.jar
2.asm.jar
3.asm-attrs.jar
4.c3p0-0.8.5.2.jar
5.cglib-2.1.jar
6.cleanimports.jar
7.commons-collections-2.1.1.jar
8.commons-logging-1.0.4.jar
9.concurrent-1.3.2.jar
10. connector.jar
11. dom4j-1.6.jar

13. hibernate3.jar
14. jaas.jar
15. jacc-1_0-fr.jar
16. jaxen-1.1-beta-4.jar
17. jdbc2_0-stdext.jar
18. jgroups-2.2.7.jar
19. jta.jar
20. log4j-1.2.9.jar
21. oscache-2.1.jar
22. proxool-0.8.3.jar
23. swarmcache-1.0rc2.jar
24. xerces-2.6.2.jar
25. xml-apis.jar


For log4j implementation, you have to include following jar files in the server�s path

1.log4j-1.2.8.jar
2.log4j-1.2.9.jar
 
Jitto P.Jose
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
but i am using struts framework. not spring. any suggestion for struts?
thanks
jittos....
 
today's feeble attempt to support the empire
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic