aspose file tools*
The moose likes JDBC and the fly likes could not connect to oracle database from struts application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "could not connect to oracle database from struts application" Watch "could not connect to oracle database from struts application" New topic
Author

could not connect to oracle database from struts application

Jitto P.Jose
Greenhorn

Joined: Sep 18, 2007
Posts: 27
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 'jdbcracle:thin:@192.168.8.202:1521rcl10'

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

Joined: Sep 18, 2007
Posts: 27
is anybody out there to help me?....please
Mladen Grabowsky
Greenhorn

Joined: Sep 19, 2007
Posts: 29
Are those jars being copied to the WEB-INF/lib folder?
If not, you should.
Jitto P.Jose
Greenhorn

Joined: Sep 18, 2007
Posts: 27
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....
Akhil kumarS
Greenhorn

Joined: Oct 16, 2007
Posts: 13
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
hw khan
Greenhorn

Joined: Oct 03, 2007
Posts: 9
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

Joined: Sep 18, 2007
Posts: 27
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

Joined: Oct 03, 2007
Posts: 9
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

Joined: Sep 18, 2007
Posts: 27
but i am using struts framework. not spring. any suggestion for struts?
thanks
jittos....
 
wood burning stoves
 
subject: could not connect to oracle database from struts application