Oracle 12c jdbc connect string for PDB

Ref:  h t t p s:// forums.oracle.com/thread/2566804
1 . link string in code

#<!--指定连接数据库用的驱动ojdbc6.jar-->
database.driver=oracle.jdbc.OracleDriver
#// oracle.jdbc.driver.OracleDriver is deprecated and replaced with oracle.jdbc.OracleDriver.
#h t tp://download.oracle.com/otn_hosted_doc/jdeveloper/905/jdbc-javadoc/oracle/jdbc/OracleDriver.html
#<!--指定连接数据库的路径-->
# for oracle 11g
database.url=jdbc:oracle:thin:@localhost:1521:orcl
# for oracle 12c1
database.url=jdbc:oracle:thin:@//127.0.0.1:1522/pdborcl
or
database.url=jdbc:oracle:thin:@127.0.0.1:1522/pdborcl

#<!--指定连接数据库的用户名-->
database.username=test
#<!--指定连接数据库的密码-->
database.password=test
<!--指定数据库使用的SQL-->
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
#org.hibernate.dialect.OracleDialect
#Oracle10gDialect
#<!--当show_sql属性为true时表示在程序运行时在控制台输出SQL语句，默认为false-->
hibernate.show_sql=false

oracle.maxConnection=100
oracle.expireTime=2400000
oracle.updateTime=600000

2. link DB by using sqlplus
need to add a tns name with SERVICE_NAME in tnsnames.ora

--tnsnames.ora
test1_tnsname =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
     
      (SERVICE_NAME = orcl.domain.test.com)
    )
  )


-> Sqlplus test_user/test_pwd@test1_tnsname
 



Ref:
-- 1.   h t t p s:// forums.oracle.com/thread/2566804

Connection conn = DriverManager.getConnection
     ("jdbc:oracle:thin:@//localhost:1521/v112", "scott", "tiger");
                        // @//machineName:port/SID,   userid,  password

See pages 2-8 and 2-9 of the JDBC Dev Guide for examples
http ://docs.oracle.com/cd/E16655_01/java.121/e17657.pdf

-- 2. h t t p://joinxin.blogspot.ca/2013/08/connecting-to-12c-database-instance.html
    h t t p s : / / b l o g s .oracle.com/oracle_maps_blog/entry/connecting_to_a_12c_database

评论

发表评论

此博客中的热门博文

XML, XSL, HTML

The code in this section is that an XSLT transform is used to translate XML input data to HTML output. Ref: https://docs.oracle.com/javase/tutorial/jaxp/xslt/transformingXML.html Note - The article1a.xsl , which is from in XSLT examples . The following code is for joy.  import java.awt.Desktop; import java.io.*; import java.net.URISyntaxException; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.parsers.ParserConfigurationException; import javax.xml.transform.Transformer; import javax.xml.transform.TransformerConfigurationException; import javax.xml.transform.TransformerException; import javax.xml.transform.TransformerFactory; import javax.xml.transform.dom.DOMSource; import javax.xml.transform.stream.StreamResult; import javax.xml.transform.stream.StreamSource; // For write operation import org.w3c.dom.Document; import org.w3c.dom.Element; import org.xml.sax.SAXException; public class Stylizer { ...
阅读全文

Input in element.eleme.io

Input Input data using mouse or keyboard. Input is a controlled component, it always shows Vue binding value . Under normal circumstances, input event should be handled. Its handler should update component's binding value (or use v-model ). Otherwise, input box's value will not change. Do not support v-model modifiers. ¶ Basic usage < el-input placeholder = "Please input" v-model = "input" > </ el-input > < script > export default { data() { return { input : '' } } } </ script > Hide ¶ Disabled Disable the Input with the disabled attribute. < el-input placeholder = "Please input" v-model = "input" :disabled = "true" > </ el-input > < script > export default { data() { return { input : '' } } } </ script > ¶ Clearable Make the Input clearable with the...
阅读全文

Data URI是由RFC 2397 ACE

https://www.rfc-editor.org/rfc/rfc2397 http://codingpy.com/article/how-to-turn-your-browser-into-code-editor/ https://ace.c9.io/build/kitchen-sink.html https://c9.io/ https://angular-ui.github.io/ The "data" URL scheme Status of this Memo This document specifies an Internet standards track protocol for the Internet community, and requests discussion and suggestions for improvements. Please refer to the current edition of the "Internet Official Protocol Standards" (STD 1) for the standardization state and status of this protocol. Distribution of this memo is unlimited. Copyright Notice Copyright (C) The Internet Society (1998). All Rights Reserved. 1 . Abstract A new URL scheme, "data", is defined. It allows inclusion of small data items as "immediate" data, as if it had been included externally. 2 . Description Some applications that use URLs also have a need to embed (small...
阅读全文