tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Eggers <its_toas...@yahoo.com>
Subject Re: Not supported by Basic Datasource
Date Thu, 09 Dec 2010 18:31:12 GMT
>From a quick glance it looks like you're mixing Hibernate-controlled database 
pooling with Tomcat-managed pooling.

Read this and see if that helps.

http://wiki.apache.org/tomcat/TomcatHibernate

. . . . just my two cents.

/mde/


----- Original Message ----
From: SOPANMISHRA <sopan.mishra@gmail.com>
To: users@tomcat.apache.org
Sent: Thu, December 9, 2010 9:33:02 AM
Subject: Not supported by Basic Datasource


jdk-1.6_13 Tomcat-6.0.26 Hibernate 3.2 

I'm getting the error "Not supported by BasicDataSource" while running a
project based on java-hibernate-tomcat server.
The project works fine if I use the normal jdbc process.
For configuring datasource I strictly followed the process mentioned in
Tomcat reference docs in the link:-
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
ie I'm configuring the project specific hibernate.cfg.xml,web.xml(project
specific) and context.xml(inside tomcat/conf).

hib.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC 
"-//Hibernate/Hibernate Configuration DTD 3.0//EN" 
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property
name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property
name="hibernate.connection.datasource">java:comp/env/jdbc/aardb</property>
<property name="show_sql">false</property>
<property name="connection.pool_size">10</property>
<property name="current_session_context_class">thread</property>

<mapping class="com.asas.assasa.asas." />
</session-factory>
</hibernate-configuration>



web.xml
<resource-ref>
<description>AAR DATABASE</description>
<res-ref-name>jdbc/aardb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>


context.xml
<Resource
name="jdbc/aardb"
auth="Container"
type="javax.sql.DataSource" 
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@00.000.00.000:1521:DB1"
schema="xxxx"
username="xxxx"
password="xxx"
maxActive="10"
maxIdle="2"
maxWait="5000"
validationQuery="select 1 from dual"
/>


My StackTrace in my customized html that calls web service is as follows is
as follows:- 
STATUS: 500 
<?xml version='1.0' encoding='UTF-8'?><S:Envelope
xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Body><S:Fault
xmlns:ns4="http://www.w3.org/2003/05/soap-envelope"><faultcode>S:Server</faultcode><faultstring>Not

supported by BasicDataSource</faultstring><detail><ns2:ApplicationException
xmlns:ns2="http://service.services.agentevaluation.care.xxxxxxxx.com/"><message>Not

supported by
BasicDataSource</message></ns2:ApplicationException><ns2:exception
xmlns:ns2="http://jax-ws.dev.java.net/"
class="com.xxxxxxxx.care.agentevaluation.exceptions.ApplicationException"
note="To disable this feature, set
com.sun.xml.ws.fault.SOAPFaultBuilder.disableCaptureStackTrace system
property to false"><message>Not supported by
BasicDataSource</message><ns2:stackTrace><ns2:frame
class="com.xxxxxxxx.care.agentevaluation.business.manager.xxxxxxxx"
file="xxxxxxxx.java" line="100" method="searchAgent"/><ns2:frame
class="com.xxxxxxxx.care.agentevaluation.services.service.xxxxxxxxxxxxxxxxServiceMaster"

file="xxxxxxxxxxxxxxxxServiceMaster.java" line="78"
method="searchAgent"/><ns2:frame
class="sun.reflect.NativeMethodAccessorImpl"
file="NativeMethodAccessorImpl.java" line="native"
method="invoke0"/><ns2:frame class="sun.reflect.NativeMethodAccessorImpl"
file="NativeMethodAccessorImpl.java" line="39" method="invoke"/><ns2:frame
class="sun.reflect.DelegatingMethodAccessorImpl"
file="DelegatingMethodAccessorImpl.java" line="25"
method="invoke"/><ns2:frame class="java.lang.reflect.Method"
file="Method.java" line="597" method="invoke"/><ns2:frame
class="com.sun.xml.ws.api.server.InstanceResolver$1"
file="InstanceResolver.java" line="246" method="invoke"/><ns2:frame
class="com.sun.xml.ws.server.InvokerTube$2" file="InvokerTube.java"
line="146" method="invoke"/><ns2:frame
class="com.sun.xml.ws.server.sei.EndpointMethodHandler"
file="EndpointMethodHandler.java" line="257" method="invoke"/><ns2:frame
class="com.sun.xml.ws.server.sei.SEIInvokerTube" file="SEIInvokerTube.java"
line="93" method="processRequest"/><ns2:frame
class="com.sun.xml.ws.api.pipe.Fiber" file="Fiber.java" line="598"
method="__doRun"/><ns2:frame class="com.sun.xml.ws.api.pipe.Fiber"
file="Fiber.java" line="557" method="_doRun"/><ns2:frame
class="com.sun.xml.ws.api.pipe.Fiber" file="Fiber.java" line="542"
method="doRun"/><ns2:frame class="com.sun.xml.ws.api.pipe.Fiber"
file="Fiber.java" line="439" method="runSync"/><ns2:frame
class="com.sun.xml.ws.server.WSEndpointImpl$2" file="WSEndpointImpl.java"
line="243" method="process"/><ns2:frame
class="com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit"
file="HttpAdapter.java" line="471" method="handle"/><ns2:frame
class="com.sun.xml.ws.transport.http.HttpAdapter" file="HttpAdapter.java"
line="244" method="handle"/><ns2:frame
class="com.sun.xml.ws.transport.http.servlet.ServletAdapter"
file="ServletAdapter.java" line="135" method="handle"/><ns2:frame
class="com.sun.xml.ws.transport.http.servlet.WSServletDelegate"
file="WSServletDelegate.java" line="129" method="doGet"/><ns2:frame
class="com.sun.xml.ws.transport.http.servlet.WSServletDelegate"
file="WSServletDelegate.java" line="160" method="doPost"/><ns2:frame
class="com.sun.xml.ws.transport.http.servlet.WSServlet"
file="WSServlet.java" line="75" method="doPost"/><ns2:frame
class="javax.servlet.http.HttpServlet" file="HttpServlet.java" line="637"
method="service"/><ns2:frame class="javax.servlet.http.HttpServlet"
file="HttpServlet.java" line="717" method="service"/><ns2:frame
class="org.apache.catalina.core.ApplicationFilterChain"
file="ApplicationFilterChain.java" line="290"
method="internalDoFilter"/><ns2:frame
class="org.apache.catalina.core.ApplicationFilterChain"
file="ApplicationFilterChain.java" line="206" method="doFilter"/><ns2:frame
class="org.apache.catalina.core.StandardWrapperValve"
file="StandardWrapperValve.java" line="233" method="invoke"/><ns2:frame
class="org.apache.catalina.core.StandardContextValve"
file="StandardContextValve.java" line="191" method="invoke"/><ns2:frame
class="org.apache.catalina.core.StandardHostValve"
file="StandardHostValve.java" line="128" method="invoke"/><ns2:frame
class="org.apache.catalina.valves.ErrorReportValve"
file="ErrorReportValve.java" line="102" method="invoke"/><ns2:frame
class="org.apache.catalina.core.StandardEngineValve"
file="StandardEngineValve.java" line="109" method="invoke"/><ns2:frame
class="org.apache.catalina.connector.CoyoteAdapter"
file="CoyoteAdapter.java" line="293" method="service"/><ns2:frame
class="org.apache.coyote.http11.Http11Processor" file="Http11Processor.java"
line="849" method="process"/><ns2:frame
class="org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler"
file="Http11Protocol.java" line="583" method="process"/><ns2:frame
class="org.apache.tomcat.util.net.JIoEndpoint$Worker"
file="JIoEndpoint.java" line="454" method="run"/><ns2:frame
class="java.lang.Thread" file="Thread.java" line="619"
method="run"/></ns2:stackTrace></ns2:exception></detail></S:Fault></S:Body></S:Envelope>
 

The print stack trace in tomcat catalina.log:- 
Dec 9, 2010 9:40:06 PM
com.xxxxxxxx.xxxxxxxx.agentevaluation.services.service.xxxxxxxx searchAgent 
INFO: Web Service called. 
Dec 9, 2010 9:40:06 PM
com.xxxxxxxx.xxxxxxxx.agentevaluation.services.service.xxxxxxxx searchAgent 
INFO: Translation of Service to Business object completed. 
Dec 9, 2010 9:40:06 PM com.xxxxxxxx.xxxxxxxx.agentevaluation.db.dao.xxxxxxxx
getAgentDetails 
INFO: Query:SELECT coalesce(M.iataNo,' ') AS iataNo,coalesce(M.pcc,' ') AS
pcc FROM xxxxxxxx AS M WHERE M.pcc IN (:lst) ORDER BY M.iataNo,M.pcc 
Dec 9, 2010 9:40:06 PM com.xxxxxxxx.xxxxxxxx.agentevaluation.db.dao.xxxxxxxx
getAgentDetails 
WARNING: Exception occured in method:getAgentDetails:Message:Not supported
by BasicDataSource 
Dec 9, 2010 9:40:07 PM
com.xxxxxxxx.xxxxxxxx.agentevaluation.business.manager.xxxxxxxxManager
searchAgent 
WARNING: Exception occured in method:searchAgent:Message:Not supported by
BasicDataSource 
Dec 9, 2010 9:40:07 PM
com.xxxxxxxx.xxxxxxxx.agentevaluation.services.service.xxxxxxxx searchAgent 
WARNING: Exception occured in method:searchAgent:Message:Not supported by
BasicDataSource 

I just want to enquire wether the coalesce query that i have written is
supported by basic data source or there is some other error 

I'm referring to the tomcat link
=http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html 

Sorry for not giving these vital info beforehand 





I used the "javax.sql.ConnectionPoolDataSource" but it is giving the error
:- 

INFO: Server startup in 2925 ms 
Dec 9, 2010 9:59:21 PM
com.xxxxxxxx.care.agentevaluation.services.service.xxxxxxxx searchAgent 
INFO: Web Service called. 
Dec 9, 2010 9:59:21 PM
com.xxxxxxxx.care.agentevaluation.services.service.xxxxxxxx searchAgent 
INFO: Translation of Service to Business object completed. 
Dec 9, 2010 9:59:22 PM
com.xxxxxxxx.care.agentevaluation.db.dao.HibernateUtil <clinit> 
WARNING: Exception building SessionFactory 
Dec 9, 2010 9:59:22 PM com.sun.xml.ws.server.sei.EndpointMethodHandler
invoke 
SEVERE: null 
java.lang.ExceptionInInitializerError 
at
com.xxxxxxxx.care.agentevaluation.db.dao.xxxxxxxx.getAgentDetails(xxxxxxxx.java:98)
 
at
com.xxxxxxxx.care.agentevaluation.business.manager.xxxxxxxx.searchAgent(xxxxxxxx.java:63)
 
at
com.xxxxxxxx.care.agentevaluation.services.service.xxxxxxxx.searchAgent(xxxxxxxx.java:78)
 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 
at java.lang.reflect.Method.invoke(Method.java:597) 
at
com.sun.xml.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:246) 
at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146) 
at
com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
 
at
com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:93) 
at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:598) 
at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:557) 
at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:542) 
at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:439) 
at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:243) 
at
com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:471)
 
at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244) 
at
com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:135)
 
at
com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:129)
 
at
com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:160)
 
at com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:75) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) 
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) 
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) 
at java.lang.Thread.run(Thread.java:619) 
Caused by: java.lang.RuntimeException: Exception building SessionFactory:
Could not find datasource 
at
com.xxxxxxxx.care.agentevaluation.db.dao.HibernateUtil.<clinit>(HibernateUtil.java:50)
 
... 36 more 


My sriptlet 

try { 

sessionAar = HibernateUtil.currentAARSession(); 

// Forming the Array containing the Search Key Values 
str = new ArrayList<String>(); 
str.add("");// adding a default value 
str.addAll(agencyInformation.getSearchCriteria() 
.getSearchKeyValues().getSearchKeyValue()); 

// Fetching the Required Fields and Order By sequence 
retStr = formReqFieldStr(agencyInformation.getRequiredFields()); 
if (Validation.validate(retStr)) { 
// Required Fields 
reqFieldStr = retStr[0]; 

// Order By sequence 
orderByStr = retStr[1]; 
} 

// Forming the query 
searchKey =
Validation.valid(agencyInformation.getSearchCriteria().getSearchKey()); 

tempQuery = new StringBuilder(); 
tempQuery.append("SELECT " + reqFieldStr 
+ " FROM AgencyRegistrar AS M WHERE M." 
+ representorMap.get(searchKey) + " IN (:lst) ORDER BY " 
+ orderByStr); 

LOGGER.info("Query:" + tempQuery.toString()); 

query = sessionAar.createSQLQuery(tempQuery.toString()); 
query.setParameterList("lst", str); 

tempList = query.setResultTransformer( 
Transformers.aliasToBean(AgencyRegistrar.class)).list(); 

} catch (Exception ex) { 
ex.printStackTrace(); 
LOGGER.warning("Exception occured in method:getAgentDetails:Message:" 
+ ex.getMessage()); 
ApplicationException apEx = new ApplicationException(); 
apEx.setMessage(ex.getMessage()); 
throw apEx; 
} finally { 
if (Validation.validate(sessionAar)) { 
sessionAar.close(); 
} 
} 
return tempList; 
}




Thanx a lot beforehand.Hope I can get my query resolved .



-- 
View this message in context: 
http://old.nabble.com/Not-supported-by-Basic-Datasource-tp30418811p30418811.html
Sent from the Tomcat - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


      

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message