asked on

How to Connect Oracle 9i by using Struts

i am using Tomcat 4.1.27 as my web server and i have set classes12.jar to my CLASSPATH, and put the jar file in the library of tomcat, but i can't still get a connection to Oracle 9i

Help me plz..........................

i want to know the following answers
1. How to configure the environment in Tomcat and Window xp when i make
connection to Oracle 9i by using struts
2. What is the coding to make the connection( giving a example code would be
better)

Additional Question (option to answer)
3. Where can find sample code of struts except Oracle and Apache Website

P.S.
i am using eclipse as my tools to programming
Thank You for your help.........................

ASKER CERTIFIED SOLUTION

CEHJ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

f_98

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ronancheung

ASKER

i use a library like common-dbcp 1.1, but it throws a exception of "no suitable driver", but i have put the driver (classes12.jar) in WEB-INF/lib folder. but i don't know why?

Help me plz.......................

CEHJ

Have you restarted the container since?

ronancheung

ASKER

yes i have retarted the container

CEHJ

Make sure that particular driver class *is in* the jar you put into WEB-INF/lib

ronancheung

ASKER

Thank you for your reply
yes, i have done that
but it still throw a exception of "No suitable Driver"
Help me plz......................
i really want to do that

f_98

try removing all other classes.12 jar in your classpath
like in common/lib, etc.

there's this nasty little "problem/feature" in tomcat about jars being loaded by different classloaders.

f_98

also try removing other instances of dbcp jar in the classpath , just put it in web-inf/lib

ronancheung

ASKER

Now there are no more exception thrown
but i don't know that it really have connected Oralce
Anyone have some sample code
Thank you for all reply!!!!