Exception while creating a SQL Connection

[Former Member]

Hi,

Can anybody tell me why this exception is coming while establishing and getting a connnection from the database?

java.lang.ClassNotFoundException: com.sap.xxx.xxxx.xxx.SQLServerDriver -

---

Loader Info -

---

ClassLoader name: [local/Image] Parent loader name: [Frame ClassLoader] References: common:service:http;service:servlet_jsp service:ejb common:service:iiop;service:naming;service:p4;service:ts service:jmsconnector library:jsse library:servlet common:library:IAIKSecurity;library:activation;library:mail;library:tc_secssl library:ejb20 library:j2eeca library:jms library:opensql common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:adminadapter;service:basicadmin;service:com.sap.security.core.ume.service;service:configuration;service:connector;service:dbpool;service:deploy;service:jmx;service:jmx_notification;service:keystore;service:security;service:userstore interface:resourcecontext_api interface:webservices interface:cross interface:ejbserialization sap.com/tc_wddispwda sap.com/tc_wdcorecomp service:webdynpro service:sld library:tc_ddicddicservices library:com.sap.aii.proxy.framework library:tc_graphicsigs library:com.sap.mw.jco library:com.sap.lcr.api.cimclient library:sapxmltoolkit library:com.sap.aii.util.rb library:com.sap.util.monitor.jarm library:tc_ddicddicruntime library:com.sap.aii.util.xml library:com.sap.aii.util.misc library:tc~cmi Resources: D:\usr\sap\J4S\JC01\j2ee\cluster\server0\apps\local\Image\webdynpro\public\lib\app.jar Loading model: {parent,references,local} -

---

Thanks in Advance

Naveen

[Former Member]

Hi,

Have checked whether the that particular driver is running in the Application Server.

You can check it in the nwa as

1.http://<host-name>:<portNo>/nwa

2. Go to configuration management

3. Go to Infrastructure --> Application Resources

Regards,

Srinivasan Subbiah

[Former Member]

Hi,

Have you properly created the datasource for your db?

Check whether your DBDriver is running in NWAdministrator? If not so start it using NWA

You can refer to this blog for datasource creation.

/people/sampath.gunda8/blog/2008/02/21/connecting-an-application-to-an-external-database-in-sap-nw-ce-71

Regards,

Srinivasan Subbiah

[Former Member]

Hi,

I am not using the DataSource, directly using the code to create connection as class.forName(".... ")... etc.,

and

where will be the mdm4.jar files in the project

and I didn't added any external jar files in the project

so please check once again

Thanks in advance,

naveen

[Former Member]

Hi Naveen..

Refer this thread..

U can get some idea,,

GS

Edited by: Sathishkumar GS on Apr 21, 2008 11:33 AM

[Former Member]

Hi Satish,

the link u given is not proper check once

Naveen

[Former Member]

Hi Naveen,,

Sorry for the inconvenience...

It seems like you are using some Jar files in the coding, if you have not added the jar files in the build path then you should get compilation errors.

But i guess that is not the problem.

You have to add library refrences also, as application nee the jars at runtime also.

e.g. if you are using mdm4j jar fileyou have to add 'sap.com/com.sap.mdm.tech.mdm4j' in the library refrences.

To add in library refrences : Right click the project -> Properties ->WebDynpro Refrences -> Library Refrences.

This was the reply in tht thread...

GS