How to config JSEE server to connect Oracle?

Hello.

I''m going into this tutorial

http://developer.java.sun.com/developer/onlineTraining/EJBIntro/exercises/DeployingJ2EERI/help.html

I set

set CLASSPATH=D:\oracle\ora81\jdbc\lib\classes12.zip;%CLASSPATH%

in J2EE_HOME/bin/j2ee.bat

jdbc.drivers=oracle.jdbc.driver.OracleDriver

jdbc.datasources=jdbc/MusicStore|jdbc:oracle:thin:@sv001:1521:mars;create=false

in defaultpropaties

after I start j2ee server ,deplytool

chose bean,click entity,click Deployment Setting and

click Generate SQL Now

Error message appear

ERROR while generatin SQL.java.rmi.ServerException.RemoteException occusred in serrver thread;nested exception is:

java.rim.Remote.Exception Erro connecting to database;nested xception is:

java.sql.SQLException :No sutable driver

Plese make sure the database name/user/password is valid

and the J2EE server and database are running

[970 byte] By [tarotsukamoto] at [2007-9-26 1:15:41]

# 1

Mine is working, I have:jdbc.datasources=jdbc:oracle:thin:user/pass@hostname:1521:dbname;create=true

swatdba at 2007-6-29 0:42:27 >

# 2

Try adding D:\oracle\ora81\jdbc\lib\classes12.zip to the setting for the variable CPATH in %J2EE_HOME%/bin/setenv.bat

neville_sequeira at 2007-6-29 0:42:27 >

# 3

You need to set the Oracle drivers (D:\oracle\ora81\jdbc\lib\classes12.zip in your case) in the J2EE_CLASSPATH variable

shirish_wagh at 2007-6-29 0:42:27 >

Enterprise & Remote Computing New Topic