Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

J2EE and SQL2000 Database Connection.......Very urgent.....

843829Oct 21 2002 — edited Mar 18 2006
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2006
Added on Oct 21 2002
16 comments
243 views