J2EE and SQL2000 Database Connection.......Very urgent.....
843829Oct 21 2002 — edited Mar 18 2006I am trying to connect SQL2000 through j2ee server and I am getting the following errors....
********************************************************************
MY ERROR********************************
javax.ejb.CreateException: No suitable driver
at EJBBean.ejbCreate(Unknown Source)
at EJBBean_RemoteHomeImpl.create(EJBBean_RemoteHomeImpl.java:22)
at EJBBeanRemoteHomeImpl_Tie._invoke(Unknown Source)
at com.sun.corba.ee.internal.POA.GenericPOAServerSC.dispatchToServant(GenericPOAServerSC.java:520)
at com.sun.corba.ee.internal.POA.GenericPOAServerSC.internalDispatch(GenericPOAServerSC.java:210)
at com.sun.corba.ee.internal.POA.GenericPOAServerSC.dispatch(GenericPOAServerSC.java:112)
at com.sun.corba.ee.internal.iiop.ORB.process(ORB.java:255)
at com.sun.corba.ee.internal.iiop.RequestProcessor.processRequestProcessor.java:84)
at com.sun.corba.ee.internal.orbutil.ThreadPool$PooledThread.runThreadPool.java:99)
*****************************************************************
My OS : win2000
***************************************************************
I tried with following ................
1.In default.properties I have tired to add 2 lines according to few documents which I found on net...
jdbc.drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc.datasources=jdbc:microsoft:sqlserver://nachi:1433;user=user;password=password;databasename=Test
2.My resource properties looks like this.............
jdbcDataSource.0.name=jdbc/Cloudscape
jdbcDataSource.0.url=jdbc\:cloudscape\:rmi\:CloudscapeDB;create\=true
jdbcDataSource.1.name=jdbc/DB1
jdbcDataSource.1.url=jdbc\:cloudscape\:rmi\:CloudscapeDB;create\=true
jdbcDataSource.2.name=jdbc/DB2
jdbcDataSource.2.url=jdbc\:cloudscape\:rmi\:CloudscapeDB;create\=true
jdbcDataSource.3.name=jdbc/EstoreDB
jdbcDataSource.3.url=jdbc\:cloudscape\:rmi\:CloudscapeDB;create\=true
jdbcDataSource.4.name=jdbc/InventoryDB
jdbcDataSource.4.url=jdbc\:cloudscape\:rmi\:CloudscapeDB;create\=true
jdbcDataSource.1.name=jdbc/sqlserver
jdbcDataSource.1.url=jdbc.microsoft.sqlserver\://nachi\:1433,user\=nachi,password\=nachi,databasename\=Test
jdbcDriver.1.name=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbcXADataSource.0.name=jdbc/XACloudscape
jdbcXADataSource.0.classname=COM.cloudscape.core.RemoteXaDataSource
jdbcXADataSource.0.dbpassword=
jdbcXADataSource.0.dbuser=
jdbcXADataSource.0.prop.createDatabase=create
jdbcXADataSource.0.prop.databaseName=CloudscapeDB
jdbcXADataSource.0.prop.remoteDataSourceProtocol=rmi
jmsCnxFactory.0.name=QueueConnectionFactory
jmsCnxFactory.0.isQueue=true
jmsCnxFactory.1.name=TopicConnectionFactory
jmsCnxFactory.1.isQueue=false
jmsCnxFactory.2.name=jms/QueueConnectionFactory
jmsCnxFactory.2.isQueue=true
jmsCnxFactory.3.name=jms/TopicConnectionFactory
jmsCnxFactory.3.isQueue=false
jmsDestination.0.name=jms/Queue
jmsDestination.0.isQueue=true
jmsDestination.1.name=jms/Topic
jmsDestination.1.isQueue=false
*********************************************************************
I have done proper setting of classpath.......here the following ouput I getting through %J2ee_home%/log/out/myhome/j2ee/j2ee/out.txt file
Logging for J2EE Server Version: 1.3.1-b17 started at: Mon Oct 21 12:15:38 BST 2002..
Using the Java HotSpot(TM) Client VM and the version number 1.4.0 from Sun Microsystems Inc..
VM is using the classpath: C:\j2sdkee1.3.1\lib\system\cloudscape.jar;C:\j2sdkee1.3.1\lib\system\tools.jar;C:\j2sdkee1.3.1\lib\cloudscape\RmiJdbc.jar;C:\j2sdkee1.3.1\lib\cloudscape\cloudclient.jar;C:\j2sdkee1.3.1\lib\classes;C:\j2sdkee1.3.1\classes;C:\j2sdkee1.3.1\lib\j2ee.jar;C:\j2sdkee1.3.1\lib\toolclasses;C:\j2sdkee1.3.1\lib\j2eetools.jar;C:\j2sdkee1.3.1\lib\locale;C:\j2sdkee1.3.1\lib\system\msbase.jar;C:\j2sdkee1.3.1\lib\system\mssqlserver.jar;C:\j2sdkee1.3.1\lib\system\msutil.jar;C:\j2sdk1.4.0\lib\tools.jar;C:\j2sdkee1.3.1\lib\jhall.jar .
J2EE Home Directory has been set to: C:\j2sdkee1.3.1.
*******************************************************************
I have sucessfully connected to cloudscape database..........
I have tested same driver(typ4) with simple java application It works fine without any problems.........
I am really strugling figure out the problem ...........
please anyone could help.......my many many thanks in advance.........
I watching for ur kind replys............
Nachi