MaxDB Database Access problem!!!

[nikhil_bose]

I am trying to access a new datasource other than the default one. But when I do a simple select query application, it gives SQLException.

here below the exception caught. Can anyone figure out what could be the reason? I restarted J2EE server already.

ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://server21/TST [Restart required].

thanks in advance

nikhil

[Former Member · Accepted solution]

hi,

pl go through

regards

Ayyapparaj

[nikhil_bose · Accepted solution]

But I got following No Class Exception exception:

com.sap.dbtech.jdbc.DriverSapDB -

---

Loader Info -

---

ClassLoader name: [com.architectsap/accessdb] 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\<SID>\JC<nr>\j2ee\cluster\server0\apps\com.architectsap\accessdb\webdynpro\public\lib\app.jar Loading model: {parent,references,local}

plz tell how to resolve?

nikhil

[nikhil_bose]

Actually it was problem with datasource created. I mistook jdbc:sapdb://host/SID?timeout=value parameter for database URL.

It is working with jdbc:sapdb://host/<DatabaseName>?timeout=value

thanks for reply ayyapparaj