Hi,
I am facing a problem in oracle database connection with Entity Bean
Example eb .
When I run Client program ,the following error occurs at prompt from where
EJBServer is running:
JOnAS Server, version 2.1.1, running on rmi.
Mapping datasource jdbc:oracle:thin:@130.1.3.11:1521:bhi151 on jdbc_1
EJBHome:eb.JOnASAccountExplHome for AccountExpl available
EJBHome:eb.JOnASAccountImplHome for AccountImpl available
EJBServer is ready
Could not get Connection on jdbc:oracle:thin:@130.1.3.11:1521:bhi151 for
pay/pay
I have copied classess111.zip(database driver zip file) file in
\usr\local\lib and specify path in config_env.bat file also.
I am sending u this zip file.
<<classes111>>
Contents of Oracle1.property file are:
datasource.name jdbc_1
datasource.url jdbc:oracle:thin:@130.1.3.11:1521:bhi151
datasource.classname oracle.jdbc.driver.OracleDriver
datasource.username pay
datasource.password pay
# -------------------------------------------------------------
# JDBC Connection Pool Configuration
# -------------------------------------------------------------
# JDBC connection checking level.
# 0 = no special checking
# 1 = check physical connection is still open before reusing it
# 2 = try every connection before reusing it
jdbc.connchecklevel 1
# max age for jdbc connections
# nb of minutes a connection can be kept in the pool
jdbc.connmaxage 30
# max concurrent threads on same tx/connection
jdbc.connmaxthreads 4
# max wait time if more than connmaxthreads threads request conn
# value is in seconds
jdbc.connexcltimeout 30
# test statement
jdbc.connteststmt select * from dual
Contents of config_env.bat file are:
Set the Objectweb ORB value with RMI or JEREMIE
Set OBJECTWEB_ORB=RMI
Rem Set those generated values according to your paths.
Set JNDI_HOME=C:\usr\local
Set
JNDI_CLASSES=%JNDI_HOME%\lib\jndi.jar;%JNDI_HOME%\lib\providerutil.jar;%JNDI
_HOME%\lib\rmiregistry.jar
Set IDB_HOME=C:\usr\local
Set IDB_CLASSES=%IDB_HOME%\lib\idb.jar;%IDB_HOME%\lib\idbexmpl.jar
Set
ORACLE_CLASSES=C:\usr\local\lib\jdbc2_0-stdext.jar;C:\usr\local\lib\classes.
jar;C:\usr\local\lib\classes111.zip;
Set JDBC_CLASSES=%IDB_CLASSES%;%ORACLE_CLASSES%
Set JONAS_CLASSES=c:\jonas-2-1-1\lib\%OBJECTWEB_ORB%_jonas.jar
Rem Set JONAS_CLASSES=%JONAS_ROOT%\lib\%OBJECTWEB_ORB%_jonas.jar
Rem All these variables refer to classes or interfaces that will be
included
Rem in your CLASSPATH, either to compile, or to run jonas servers.
Set CLASSPATH=%JONAS_CLASSES%
Set CLASSPATH=%JNDI_CLASSES%;%CLASSPATH%
Set CLASSPATH=%JDBC_CLASSES%;%CLASSPATH%
Rem jonas root for jndi.properties file
Rem Set CLASSPATH=%JONAS_ROOT%;%CLASSPATH%
Set CLASSPATH=c:\jonas-2-1-1;%CLASSPATH%
Rem You can update the classpath with your own bean classes
Rem or set a XTRA_CLASSPATH in your environment
Rem Set CLASSPATH=%JONAS_ROOT%\examples\classes;%CLASSPATH%
Set CLASSPATH=c:\jonas-2-1-1\examples\classes;%CLASSPATH%
Set CLASSPATH=%XTRA_CLASSPATH%;%CLASSPATH%
Is there any more change required to connect to database.....
Looking forward for your reply...
Regards
Seema
classes111
