java - Not able to connect to Database with oci8 -


i have below configuration connect db through spring-hibernate. have commons-dbcp-1.4.jar,commons-pool-1.6.jar,classes12.jar,ojdbc14.jar

<bean id="datasource" destroy-method="close" class="org.apache.commons.dbcp.basicdatasource" lazy-init="true">             <property name="driverclassname" value="oracle.jdbc.driver.oracledriver"/>             <property name="url" value="jdbc:oracle:oci8:@dbschemaname"/>             <property name="maxwait" value="1000"/>             <property name="maxactive" value="10"/>             <property name="maxidle" value="1"/>                     <property name="removeabandoned" value="true"/>             <property name="removeabandonedtimeout" value="30"/>             <property name="logabandoned" value="true"/>             </bean>

i using dbcp connection pooling.i tried changing url 

<property name="url" value="jdbc:oracle:oci8:/@dbschemaname"/>

still no success. getting below error

org.hibernate.util.jdbcexceptionreporter - cannot create poolableconnectionfactory (ora-12154: tns:could not resolve connect identifier specified org.hibernate.util.jdbcexceptionreporter - cannot create poolableconnectionfactory (ora-12154: tns:could not resolve connect identifier specified org.hibernate.cfg.settingsfactory - not obtain connection metadata org.apache.commons.dbcp.sqlnestedexception: cannot create poolableconnectionfactory (ora-12154: tns:could not resolve connect identifier specified @ org.apache.commons.dbcp.basicdatasource.createpoolableconnectionfactory(basicdatasource.java:1549) @ org.apache.commons.dbcp.basicdatasource.createdatasource(basicdatasource.java:1388) @ org.apache.commons.dbcp.basicdatasource.getconnection(basicdatasource.java:1044) @ org.springframework.orm.hibernate3.localdatasourceconnectionprovider.getconnection(localdatasourceconnectionprovider.java:82) @ org.hibernate.cfg.settingsfactory.buildsettings(settingsfactory.java:84) @ org.hibernate.cfg.configuration.buildsettings(configuration.java:2009) @ org.hibernate.cfg.configuration.buildsessionfactory(configuration.java:1292) @ org.springframework.orm.hibernate3.localsessionfactorybean.newsessionfactory(localsessionfactorybean.java:814) @ org.springframework.orm.hibernate3.localsessionfactorybean.buildsessionfactory(localsessionfactorybean.java:732) @ org.springframework.orm.hibernate3.abstractsessionfactorybean.afterpropertiesset(abstractsessionfactorybean.java:211) @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeinitmethods(abstractautowirecapablebeanfactory.java:1368) @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1334) @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:473) @ org.springframework.beans.factory.support.abstractautowirecapablebeanfactory$1.run(abstractautowirecapablebeanfactory.java:409) @ java.security.accesscontroller.doprivileged(native method)

can me understand issue?


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

jquery - How would i go about shortening this code? And to cancel the previous click on click of new section? -

my code below changes image people in team sector, can see theres alot of repeated code; there way shorten it? also currently, allows click on sections without turning off clicked one; assume toggle() function, couldn't work other way! still quite new jquery coding, grand!! cheers in advance! $("#team_client_services").click(function () { if ($(".team_client_services").hasclass("team_hide")) { $(".team_client_services").toggleclass("team_hide"); $(".team_client_services2").toggleclass("team_show"); } else { $(".team_client_services").toggleclass("team_hide"); $(".team_client_services2").toggleclass("team_show"); }; }); $("#team_management").click(function () { if ($(".team_management").hasclass("team_hide")) { $(".team_management").toggleclass("team_hide"); $(".team_management2...
Read more