java - How to connect oracle database through tcps on tomcat -


i using tomcat 7, jdk 7.

my db oracle 11g.

i trying connect db tcps on tomcat.

some people have adding these lines.

url="jdbc:oracle:thin:@(description=(address=(protocol=tcps)(host=db ip)(port=port number))(connect_data=(service_name=db sid))) " connectionproperties="oracle.net.ssl_cipher_suites=ssl_dh_anon_with_3des_ede_cbc_sha,ssl_dh_anon_with_rc4_128_md5,ssl_dh_anon_with_des_cbc_sha"

so config file looks :

<resource name="jdbc/jedidatasource" auth="container" driverclassname="oracle.jdbc.driver.oracledriver" type="javax.sql.datasource" maxactive="40" maxidle="20" maxwait="-1"  initialsize="1"  username="cdw_admin" password="travel" removeabandoned="true" logabandoned="true" removeabandonedtimeout="60" validationquery="select 1 dual" url="jdbc:oracle:thin:@(description=(address=(protocol=tcps)(host=db ip)(port=port num))(connect_data=(service_name=db sid)))" connectionproperties="oracle.net.ssl_cipher_suites=ssl_dh_anon_with_3des_ede_cbc_sha,ssl_dh_anon_with_rc4_128_md5,ssl_dh_anon_with_des_cbc_sha"

but when start tomcat these settings error

경고: unexpected exception resolving reference org.apache.tomcat.dbcp.dbcp.sqlnestedexception: cannot create poolableconnectionfactory (io 예외 상황: network adapter not establish connection)         @ org.apache.tomcat.dbcp.dbcp.basicdatasource.createpoolableconnectionfactory(basicdatasource.java:1549)         @ org.apache.tomcat.dbcp.dbcp.basicdatasource.createdatasource(basicdatasource.java:1388)         @ org.apache.tomcat.dbcp.dbcp.basicdatasource.getlogwriter(basicdatasource.java:1098)         @ org.apache.tomcat.dbcp.dbcp.basicdatasourcefactory.createdatasource(basicdatasourcefactory.java:350)         @ org.apache.tomcat.dbcp.dbcp.basicdatasourcefactory.getobjectinstance(basicdatasourcefactory.java:156)         @ org.apache.naming.factory.resourcefactory.getobjectinstance(resourcefactory.java:140)         @ javax.naming.spi.namingmanager.getobjectinstance(namingmanager.java:321)         @ org.apache.naming.namingcontext.lookup(namingcontext.java:793)         @ org.apache.naming.namingcontext.lookup(namingcontext.java:140)         @ org.apache.naming.namingcontext.lookup(namingcontext.java:781)         @ org.apache.naming.namingcontext.lookup(namingcontext.java:153)         @ org.apache.catalina.core.namingcontextlistener.addresource(namingcontextlistener.java:1020)         @ org.apache.catalina.core.namingcontextlistener.createnamingcontext(namingcontextlistener.java:629)         @ org.apache.catalina.core.namingcontextlistener.lifecycleevent(namingcontextlistener.java:237)         @ org.apache.catalina.util.lifecyclesupport.firelifecycleevent(lifecyclesupport.java:119)         @ org.apache.catalina.core.standardcontext.start(standardcontext.java:4540)         @ org.apache.catalina.core.containerbase.addchildinternal(containerbase.java:791)         @ org.apache.catalina.core.containerbase.addchild(containerbase.java:771)         @ org.apache.catalina.core.standardhost.addchild(standardhost.java:546)         @ org.apache.catalina.startup.hostconfig.deploydescriptor(hostconfig.java:637)         @ org.apache.catalina.startup.hostconfig.deploydescriptors(hostconfig.java:563)         @ org.apache.catalina.startup.hostconfig.deployapps(hostconfig.java:498)         @ org.apache.catalina.startup.hostconfig.start(hostconfig.java:1277)         @ org.apache.catalina.startup.hostconfig.lifecycleevent(hostconfig.java:321)         @ org.apache.catalina.util.lifecyclesupport.firelifecycleevent(lifecyclesupport.java:119)         @ org.apache.catalina.core.containerbase.start(containerbase.java:1053)         @ org.apache.catalina.core.standardhost.start(standardhost.java:785)         @ org.apache.catalina.core.containerbase.start(containerbase.java:1045)         @ org.apache.catalina.core.standardengine.start(standardengine.java:445)         @ org.apache.catalina.core.standardservice.start(standardservice.java:519)         @ org.apache.catalina.core.standardserver.start(standardserver.java:710)         @ org.apache.catalina.startup.catalina.start(catalina.java:581)         @ sun.reflect.nativemethodaccessorimpl.invoke0(native method)         @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62)         @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43)         @ java.lang.reflect.method.invoke(method.java:498)         @ org.apache.catalina.startup.bootstrap.start(bootstrap.java:289)         @ org.apache.catalina.startup.bootstrap.main(bootstrap.java:414) caused by: java.sql.sqlexception: io 예외 상황: network adapter not establish connection         @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:111)         @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:145)         @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:254)         @ oracle.jdbc.driver.t4cconnection.logon(t4cconnection.java:386)         @ oracle.jdbc.driver.physicalconnection.<init>(physicalconnection.java:413)         @ oracle.jdbc.driver.t4cconnection.<init>(t4cconnection.java:164)         @ oracle.jdbc.driver.t4cdriverextension.getconnection(t4cdriverextension.java:34)         @ oracle.jdbc.driver.oracledriver.connect(oracledriver.java:752)         @ org.apache.tomcat.dbcp.dbcp.driverconnectionfactory.createconnection(driverconnectionfactory.java:38)         @ org.apache.tomcat.dbcp.dbcp.poolableconnectionfactory.makeobject(poolableconnectionfactory.java:582)         @ org.apache.tomcat.dbcp.dbcp.basicdatasource.validateconnectionfactory(basicdatasource.java:1556)         @ org.apache.tomcat.dbcp.dbcp.basicdatasource.createpoolableconnectionfactory(basicdatasource.java:1545)         ... 37 more  8월 18, 2017 11:16:46 오전 org.apache.catalina.core.namingcontextlistener addresource 경고: failed register in jmx: javax.naming.namingexception: cannot create poolableconnectionfactory (io 예외 상황: network adapter not establish connection) webinitializer instanciated.

my database set tcps settings, want connect tomcat , database through tcps.

could me fix error? thanks


Comments

Post a Comment

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

i'm using class based views in django , never specify url in ajax calls , omit action parameter in form because know these requests go through post method of class based view. notice view - profile page make many requests depending on user updating on page - post method become convoluted , if/else mess example: def post(self, request, *args, **kwargs): # handle user changing available date if request.post.get('availabledate') != none: self.updateavailabledate(request) return jsonresponse({'result':'success'}) if request.post.get('newprojectname') != none: creative_user = creativeuserprofile.objects.get(id = request.user.id) project = project.create_project(creative_user, request.post['newprojectname']) project.save() return jsonresponse({'projectid': project.id }) if request.post.get('projectimage') != none , request.files['file']: proj...
Read more

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

i'm doing micro-optimization on performance critical part of code , came across sequence of instructions (in at&t syntax): add %rax, %rbx mov %rdx, %rax mov %rbx, %rdx i thought had use case xchg allow me shave instruction , write: add %rbx, %rax xchg %rax, %rdx however, dimay found agner fog's instruction tables , xchg 3 micro-op instruction 2 cycle latency on sandy bridge, ivy bridge, broadwell, haswell , skylake. 3 whole micro-ops , 2 cycles of latency! 3 micro-ops throws off 4-1-1-1 cadence , 2 cycle latency makes worse original in best case since last 2 instructions in original might execute in parallel. now... cpu might breaking instruction micro-ops equivalent to: mov %rax, %tmp mov %rdx, %rax mov %tmp, %rdx where tmp anonymous internal register , suppose last 2 micro-ops run in parallel latency 2 cycles. given register renaming occurs on these micro-architectures, though, doesn't make sense me done way. why wouldn't register renamer ...
Read more

c# - Asp.net web api : redirect unauthorized requst to forbidden page -

im trying redirect unauthorized request forbidden page instead i'm getting forbidden page in response body , how can fix ? here's startup class : app.createperowincontext(storecontext.create); app.createperowincontext<applicationusermanager>(applicationusermanager.create); app.createperowincontext<applicationsigninmanager>(applicationsigninmanager.create); app.usecookieauthentication(new cookieauthenticationoptions { authenticationtype = defaultauthenticationtypes.applicationcookie, expiretimespan = timespan.fromdays(30), }); app.useexternalsignincookie(defaultauthenticationtypes.externalcookie); app.usetwofactorsignincookie(defaultauthenticationtypes.twofactorcookie, timespan.fromminutes(5)); app.usetwofactorrememberbrowsercookie(defaultauthenticationtypes.twofactorrememberbrowsercookie); the method im trying reach : [httpget] [authorize(roles = "admin")] public string getcurrentusername() { return userman...
Read more