Can't resolve Oracle driver from servlet

[duraace]

Getting java.sql.SQLException: No suitable driver executing the following code from a servlet in eclipse:

dbPsext = DriverManager.getConnection(
"jdbc:oracle:thin:@buxhrrpt.bctel.com:1521:orav8q",
"psext", "psext");

oracle_80520.jar works in other eclipse Java projects, but not from JBoss within eclipse. I've tried configuring every classpath, and putting the .jar in every conceivable place. What's the scoop? Thanks in advance.

[duraace]

forgot to check "Notify me". Please respond to this one.

[luc.texier]

Have you tried to drop the lib into /server/xxx/lib?

[darranl]

Do you have a line in your code anywhere to initialise the driver such as a Class.forName("driver class")?

Alternatively have you considered setting it up as a datasource and allowing JBoss to manage your connections?

[duraace]

BINGO! Your suggestion made me think I'd forgotten to do something prior to the connection attempt. Namely:

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

I did a copy/paste from another project without thinking it through. Thanks again!