please tell me it'll be back

Hi @bjeffrie,

Thanks for the nice DependencyViewerExample. I like the SQL Developer links. I was looking for an example to add an editor for a PL/SQL node and this example looked promising.

However, it works for table and view nodes but not for PL/SQL nodes such as functions, procedures and packages. I tried to change some configuration but could not figure out the right values to make it work for PL/SQL nodes.

Working

The "tab" for "Dependency Edges Query" is available for this view

Not working

"tab" "Dependency Edges Query" is missing for the package body:

Any help is very much appreciated.

Thank you.
Philipp

At the risk of sounding annoying, I am no expert at Java. I am a DevOps guy and I am planning to use this simple app to demonstrate CI/CD pipelines to a bunch of people. I would be dockerizing this application and then create a release pipeline as a demo, can you please share how exactly would you go about installing it on an Ubuntu server? Also if there are any non-standard prerequisites?

Oracle supports the load data, SQL, it is suggested that add setLocalInfileInputStream methods like mysql.

https://github.com/melin/datatunnel/blob/master/connectors/jdbc/src/main/scala/com/superior/datatunnel/plugin/jdbc/support/LoadDataSqlHelper.scala

https://github.com/oceanbase/obconnector-j/blob/master/src/main/java/com/oceanbase/jdbc/OceanBaseStatement.java

@nsundara @nigelbayliss

I should like create special XML extension for organization of DB objects for defined application.
See to screenshot :

On each DB object, user can open context menu. See following screenshot for PACKAGE.

But when I click to Edit menu item the editor is opened but without the code.
The same behavior I have on triggers, functions and procedure.

Do you have some idea how I can solved this problem ?

Folders are created as a special type and rows under the folder are generated by following SQL stmt.
Part XML extension definition is following:

<objectType connType="Oracle" id="APP_PACKAGES" requiresParent="true"> <folder> <icon RSKEY="PACKAGE_FOLDER_ICON"/> <label RSKEY="PACKAGE_LABEL"/> <queries> <query> <sql> <![CDATA[ SELECT ao.OBJECT_NAME, ao.OBJECT_NAME TABLE_OBJECT_NAME, 'PACKAGE' type from APP_OBJECT ao, app_schema_mapping asm, all_objects alt where ao.APP_NAME=:APP_NAME and asm.app_name=ao.app_name and asm.target_schema=ao.owner and ao.OBJECT_TYPE='PACKAGE' and alt.object_name=ao.object_name and alt.owner = asm.source_schema and alt.object_type=ao.object_type ]]> </sql> <columns> <column filterable="true" sortable="true" id="NAME"> <colName> <![CDATA[OBJECT_NAME]]> </colName> </column> </columns> </query> </queries> </folder> <node nodeClass="oracle.dbtools.raptor.navigator.plsql.PlSqlNode" /> </objectType>

Thanks for help.

Oracle has created a new guide to implementing continuous availability for the applications:
https://docs.oracle.com/en/database/oracle/oracle-database/19/haovw/configuring-continuous-availability-applicationsconfiguring-continuous-availability-applicatio.html

The documentation replaces the whitepaper "Application Checklist for Continuous Service for MAA Solutions."

The whitepaper now reflects the new documentation:
https://www.oracle.com/docs/tech/application-checklist-for-continuous-availability-for-maa.pdf

As part of this effort, we must add examples that help implement end-to-end high availability using Oracle Maximum Availability Architecture technologies.

Examples must include:

• A new folder, "continuous-availability," with examples and snippets common to all programming languages:
  • Services for Application Continuity and Transparent Application Continuity, with and without Clusterware
  • Explanation and connection descriptor examples for Oracle Real Application Clusters, Data Guard, Autonomous DB, in extended form and EZConnectPlus
• Code examples for each language, to be added to their respective folders
• Occasional changes to existing examples, if needed

As the changes might span over multiple pull requests, I create this issue to track the addition of the aforementioned examples to this repository.

I have a VIEW (VIEW_COUNT) that returns 1 record with the number of rows from two external tables fetched via jdbc connection.
Below the code:

public class JavaExternalDb
{
  public static int getTableCountRecord (String tabName) throws SQLException
  {
	Connection conn = DriverManager.getConnection("jdbc:oracle:thin:USER/PWD@HOST:PORT:SID");
        String sql = "SELECT count(*) FROM " + tabName;
	Statement stmt = conn.createStatement();
	ResultSet rset = stmt.executeQuery(sql);
        int rows = 0;
	while (rset.next())
	{
	     rows = rset.getInt(1);
	}
	rset.close();
	stmt.close();
        return rows;
  }
}

CREATE OR REPLACE FUNCTION FUNC_COUNT (tab_name VARCHAR2)
   RETURN NUMBER AS LANGUAGE JAVA
   NAME 'JavaExternalDb.getTableCountRecord(java.lang.String) return int';
/

CREATE OR REPLACE FORCE VIEW VIEW_COUNT ("COUNT_TAB1", "COUNT_TAB2") AS 
  select FUNC_COUNT('tab1name'), FUNC_COUNT('tab2name') from dual;
/

How can I, likewise, create a VIEW that returns all the contents of an external table via jdbc?

Thanks for the info

The following link to setup the environment does not work: https://github.com/oracle/oracle-db-examples/blob/master/sqldeveloper/setup.md

Been using this plugin without issue for a month or so but now encounter the following:

java.lang.NullPointerException

Here is my command that accepts parameters:

"C:\Program Files (x86)\Common Files\Oracle\Java\javapath\java" -jar C:\sqldeveloper\sqldeveloper\extensions\oracle.db.example.sqldeveloper.extension.connectionHelper\lib\ConnectionHelperClient.jar -%2@%1=%2/%3@%4:1521/%1

Some of the JDBC samples appear to have outdated documentation and references to old versions and/or discontinued products like Exadata Express:

• https://github.com/oracle/oracle-db-examples/blob/master/java/jdbc/Readme.md
• https://github.com/oracle/oracle-db-examples/blob/master/java/jdbc/BasicSamples/Readme.md
• https://github.com/oracle/oracle-db-examples/blob/master/java/jdbc/Tomcat_Servlet/Readme.md
• https://github.com/oracle/oracle-db-examples/blob/master/java/jdbc/WebLogicServer_Servlet/Readme.md

We should scan through the samples, establish whether they are still useful and update them accordingly.

Please add one or two sentences to the description how to uninstall / deactivate "DependencyExample". Thanks

Please change the installing sequence (jar dependency) and
actualize version no. to orajsoda-1.0.5.jar in SODA.md ::

(ii) Load the latest javax.json-1.0.4.jar
loadjava -r -v -u hr/hr javax.json-1.0.4.jar

(iii) Upload orasoda.jar in your database schema
loadjava -r -v -u hr/hr orajsoda-1.0.5.jar

Works great 👍

When an error occurs using the connection helper client, only the first line of the error text is displayed. It should display whatever the server sends back.

I am using this bellow properties:
SpingBoot
LInux

application.properties:
spring.datasource.url=jdbc:oracle:thin:@jdb202004261321_high??TNS_ADMIN=/home/manikanta/Downloads/Wallet_DB202004261321/
spring.datasource.username=ADMIN
spring.datasource.password=******
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver

Added this in POM :

com.oracle.ojdbc
ojdbc8
19.3.0.0

I am getting this error :
java.sql.SQLRecoverableException: IO Error: Unknown host specified
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117) ~[HikariCP-2.7.8.jar:na]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:123) ~[HikariCP-2.7.8.jar:na]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) ~[HikariCP-2.7.8.jar:na]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:194) ~[HikariCP-2.7.8.jar:na]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:460) [HikariCP-2.7.8.jar:na]
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:534) [HikariCP-2.7.8.jar:na]
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) [HikariCP-2.7.8.jar:na]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-2.7.8.jar:na]
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:259) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:233) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:242) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:861) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:888) [hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57) [spring-orm-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [spring-orm-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:388) [spring-orm-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377) [spring-orm-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) [spring-orm-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1769) [spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1706) [spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:583) [spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502) [spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312) [spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) ~[spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310) [spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) [spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1085) ~[spring-context-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:858) ~[spring-context-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) ~[spring-context-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.0.0.RELEASE.jar:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752) ~[spring-boot-2.0.0.RELEASE.jar:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:388) ~[spring-boot-2.0.0.RELEASE.jar:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) ~[spring-boot-2.0.0.RELEASE.jar:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1246) ~[spring-boot-2.0.0.RELEASE.jar:2.0.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1234) ~[spring-boot-2.0.0.RELEASE.jar:2.0.0.RELEASE]
at com.manikanta.AppMain.main(AppMain.java:11) ~[classes/:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_252]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_252]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_252]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_252]
at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) ~[spring-boot-devtools-2.0.0.RELEASE.jar:2.0.0.RELEASE]
Caused by: oracle.net.ns.NetException: Unknown host specified
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:211) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:143) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:510) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:309) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
... 56 common frames omitted

I'm testing your Spring boot sample with Oracle Cloud, ATP.
To run it, all paramenters(url, user and password) is configured well in HelloAppConfig.xml.
But, it couldn't find SSO keystore in my wallet.

And recently it is removed in this repository. Does it not work or will you release new one?

My full stacktrace is as below

java.lang.IllegalStateException: Failed to execute CommandLineRunner
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:787)
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:768)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:322)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215)
at HelloApplication.main(HelloApplication.java:18)
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:371)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:462)
at EmpJDBCTemplate.displayEmpList(EmpJDBCTemplate.java:24)
at HelloApplication.lambda$commandLineRunner$0(HelloApplication.java:26)
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:784)
... 5 more
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)
at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:928)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1961)
at oracle.ucp.jdbc.PoolDataSourceImpl.access$400(PoolDataSourceImpl.java:201)
at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4279)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1917)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1880)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1865)
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
... 11 more
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59)
at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:134)
at oracle.ucp.common.Database.createPooledConnection(Database.java:256)
at oracle.ucp.common.Topology.start(Topology.java:247)
at oracle.ucp.common.Core.start(Core.java:2313)
at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:685)
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129)
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:924)
... 20 more
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:858)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:406)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:291)
at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1683)
at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1669)
at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:103)
... 26 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:571)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:548)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:309)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1600)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:592)
... 34 more
Caused by: oracle.net.ns.NetException: Unable to initialize ssl context.
at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:346)
at oracle.net.nt.CustomSSLSocketFactory.getSSLContext(CustomSSLSocketFactory.java:307)
at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketEngine(CustomSSLSocketFactory.java:273)
at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:174)
at oracle.net.nt.ConnOption.connect(ConnOption.java:174)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:510)
... 39 more
Caused by: oracle.net.ns.NetException: Unable to initialize the key store.
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:619)
at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:324)
... 44 more
Caused by: java.security.KeyStoreException: SSO not found
at java.base/java.security.KeyStore.getInstance(KeyStore.java:878)
at oracle.net.nt.CustomSSLSocketFactory.getKeyStoreInstance(CustomSSLSocketFactory.java:767)
at oracle.net.nt.CustomSSLSocketFactory.loadKeyStore(CustomSSLSocketFactory.java:902)
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:610)
... 45 more
Caused by: java.security.NoSuchAlgorithmException: SSO KeyStore not available
at java.base/sun.security.jca.GetInstance.getInstance(GetInstance.java:159)
at java.base/java.security.Security.getImpl(Security.java:700)
at java.base/java.security.KeyStore.getInstance(KeyStore.java:875)
... 48 more

ref forum post: https://community.oracle.com/thread/4035454

Hello,

glad to read of the Connection Helper from @bjeffrie because it will be VERY useful for my team.

We have some problem using it with because SQL Developer doesn't seem to properly manage the request when the service name contains a dot (maybe it treats it as a SID?)

if i do:

java -jar ConnectionHelperClient.jar -Bubba=hr@localhost:1521/orcl

SQL Developer open a dialog asking for the password

if I do:
java -jar ConnectionHelperClient.jar -Bubba=hr@localhost:1521/orcl.oracle.com

The CLI prints "Request Submitted" but i don't see any dialog in SQL Developer

This prevents us to use the extension because we have service names with dots, I tried to look at the source code but it seems out of sync.

TIA
M

https://community.oracle.com/message/14331188#14331188
From oracle10 version, the function "setStringForClob" has been added in the JDBC for CLOB type.
oracle.jdbc.OraclePreparedStatement.setStringForClob(int i, String s)
this show: oracle support the CLOB type is String in the code
but i use this to batch update the clob type's data, but ORA-22275 error occur

Can't find the bag.

Hi Team,

Unable to connect to ATP using intellij database feature .

Please refer the pic in url:

.

error:

[08006][17002] IO Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target, connect lapse 78 ms., Authentication lapse 0 ms. sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

Thx
Regards

I am setting below properties under application.properties file and added required jars.

spring.datasource.url=jdbc:oracle:thin:@test_high?TNS_ADMIN=Wallet_Test
spring.datasource.username=admin
spring.datasource.password=admin
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.Oracle10gDialect
spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.type=oracle.jdbc.pool.OracleDataSource

Dependencies added to pom.xml
ojdbc8.jar
ons.jar
oraclepki.jar
osdt_cert.jar
osdt_core.jar
ucp.jar

I am facing could not resolve the connect identifier "test_high" exception while running my spring boot application. Any help is appreciated..

Full stack trace

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2019-11-14 21:23:45.600 ERROR 9720 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection for DDL execution
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1778) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1105) ~[spring-context-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) ~[spring-context-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) ~[spring-context-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:744) [spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:391) [spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:312) [spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) [spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1204) [spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
	at com.deals.warangaldeals.WarangaldealsApplication.main(WarangaldealsApplication.java:18) [classes/:na]
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection for DDL execution
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:402) ~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377) ~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1837) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1774) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	... 16 common frames omitted
Caused by: org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection for DDL execution
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:69) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.tool.schema.internal.exec.ImprovedExtractionContextImpl.getJdbcConnection(ImprovedExtractionContextImpl.java:60) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.tool.schema.extract.internal.SequenceInformationExtractorLegacyImpl.extractMetadata(SequenceInformationExtractorLegacyImpl.java:40) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.initializeSequences(DatabaseInformationImpl.java:65) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.<init>(DatabaseInformationImpl.java:59) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.tool.schema.internal.Helper.buildDatabaseInformation(Helper.java:132) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:96) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57) ~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390) ~[spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
	... 20 common frames omitted
Caused by: java.sql.SQLRecoverableException: IO Error: could not resolve the connect identifier  "rampquik_high"
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:801) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:782) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:390) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:279) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:202) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:180) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	at org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:43) ~[hibernate-core-5.3.11.Final.jar:5.3.11.Final]
	... 34 common frames omitted
Caused by: oracle.net.ns.NetException: could not resolve the connect identifier  "rampquik_high"
	at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:180) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:490) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:660) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:287) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1481) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:540) ~[ojdbc8-12.2.0.1.jar:18.3.0.0.0]
	... 44 common frames omitted

I am using Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
I have an error at these lines

import oracle.jdbc.pool.OracleDataSource;
import oracle.jdbc.OracleConnection;

https://github.com/oracle/oracle-db-examples/blob/master/java/jdbc/ConnectionSamples/DataSourceSample.java#L34

Where to find missing JAR file?

Nice samples!

However I use occi to select sth from GEOMETRY is further faster than JDBC.
I think I got a wrong way.
c++: in 500ms

and the GEOMETRY type was parsed into oracle.sql.STRUCT and needs cast into JGeometry ...(it takes me too much time ...)
Java: more than 4000ms

I wish there be some samples about Oracle Spatial.
Thanks:pray:

The file https://github.com/oracle-samples/oracle-db-examples/blob/main/java/jdbc/Tomcat_Servlet/META-INF/context.xml is missing a closing quote on line 21.

I would like to create a custom context menu option/item in sql developer
which would show a right-click menu option which would show the size of a table.

So something like this:

I am not sure HOW to show the result.

I assume it would be via a "confirmation" window/popup, but again, I do NOT know HOW to show the query result. (in this case the size of the table via the alias "MEGABYTES" column)

Can someone help me with this?

Every time I have end of work this fu..... tool takes minutes to close (if at all) and has cost me a lot of life time. Please deliver your excellent software in the future with this batch script. Thanks.

taskkill /f /im "sqldeveloper64W.exe"

(Issue posted from Oracle forum at request of Jeff Smith).
I am developing an extension.

I am currently using SQL Developer 20.4 (and Eclipse).

Given a SQL Developer connection name, I am retrieving a java.sql.Connection as follows:

Connection conn = Connections.getInstance().getConnection(this.connectionName,true);

When I try to use this connection to create a Struct object I get the following error.

"Fail to convert to internal representation...".

(I am using the JGeometry.storeJS method from the Oracle Spatial sdoapi.jar)

If I replace the connection with the following:

Connection conn = (Connection)DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:GISDB12", "username", "password");

The creation of the Struct now works.

Obviously the latter solution is not sustainable: all connection information is with SQL Developer.

Can anyone identify what I am doing wrong and suggest a solution?

Simon

EDIT: Note that I can create a Struct (not STRUCT) from a SELECT query (that is 98% of what my code does).

What I can't do is create a struct for writing back to the database.

That is what JGeometry.storeJS is supposed to do.

If I try to Connection.createStruct() I also get the same Struct creation error that JGeometry.storeJS throws.

Anyone encountered this issue?

Couldn't get I/O for the connection to PC-name/x.x.x.x:51521

I am able to connect manually but only having issues with connections initiated by the ConnectionHelper.

Given that Exadata Express does no longer exist, we should either generalize the examples or perhaps retire them if they have no more value add.

Is it possible to access the Run Script button in a Worksheet from an extension?

This is being considered to be able to disable/enable the button during extension processing.

Please advise if additional details are needed. Keeping it short and simple to start.

On Part - 5 I keep getting this error:

With this URL: http://192.168.0.25:1234/api/employees?limit=5
::ffff:192.168.0.10 - - [04/Mar/2019:05:53:41 +0000] "GET /api/employees?limit=5 HTTP/1.1" 500 175 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.119 Safari/537.36" Error: ORA-00933: SQL command not properly ended

Or any URL: http://192.168.0.25:1234/api/employees
::ffff:192.168.0.10 - - [04/Mar/2019:05:54:54 +0000] "GET /api/employees HTTP/1.1" 500 175 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.119 Safari/537.36" Error: ORA-00933: SQL command not properly ended

This is with the vanilla code cloned from the repository.

While following Dan's Blog https://jsao.io/2018/08/creating-a-rest-api-manual-pagination-sorting-and-filtering/ I noticed it started right after adding pagination. Hence I cloned the repository and tested but got the same result.

thank you

Hi

Using exadata cloud at customer 22.1
I was wondering, is there an actual tutorials , how can I configure real time insight.

I am well aware of these, but these link, but these are not actual tutorials, these are very laconic, and not much help.
https://github.com/oracle-samples/oracle-db-examples/tree/main/exadata/insight/dashboard_grafana_prometheus
https://blogs.oracle.com/exadata/post/exadata-real-time-insight

Regards
Raul

I tried it with SQL Dev. 21.4 and a table which has only one dependency. The arrowhead seem to be wrong when starting and turns weird around when moving the areas - see screen-cast in attachment.
Bug or Feature?

I'd like to create an extension that could receive input from text selected in a query worksheet.

Usage-case:

• a table name is selected; the extension is invoked via a context menu; the selected text is passed to the extension; the text is assigned to an argument (e.g. #0#); the extension processes another query (e.g. SELECT ... FROM ... WHERE table_name = '#0#') and returns a grid of values

Does the JDeveloper-SDK extension offer this level of control? If so, is there an example of this usage case?

I used the sample below to connect to a cloud database on Oracle Cloud. When I use ojdbc8, JDK 1.8 I am getting the response and when I switch to ojdbc6, JDK7 (jdk1.7.0_80), getting the error at OracleConnection.CONNECTION_PROPERTY_TNS_ADMIN (CONNECTION_PROPERTY_TNS_ADMIN cannot be resolved or is not a field). How can I connect to oracle cloud with ojdbc6, jdk1.7.0_80.

https://github.com/oracle/oracle-db-examples/blob/master/java/jdbc/ConnectionSamples/DataSourceForJKS.java

Hi,

Is it possible to add "User Defined Extensions" or code templates to SQL Developer through a packaged extension bundle ?

Thanks

I am trying to use the Connection Helper plugin to script opening a connection over a secure tunnel. I have the plugin installed and configured to allow transient connections but not to persist them.

The problem is, if a connection exists (even an old (closed), transient one) then it tries to open that, without updating it's settings (specifically the port).

E.g.

1. Open a connection via Connection Helper using -Foo=me@localhost:12345/foo. It creates a transient connection and connects successfully.
2. Then close that connection but do not close SQL Developer
3. Create a new connection using -Foo=you@localhost:9999/foo
4. Actual: It opens the connection "Foo" - but the user is still me and the port is still 12345
   Expected: It either opens the connection "Foo" with user you and port 9999 - or at the very least shows an error if it can't

My use case is that I am writing a script to automate opening a connection over a secure tunnel to our server farm. The script creates a tunnel to the specified server and then opens SQL Developer. I am using a random local port for the tunnel, to avoid having to maintain a mapping of port->server

I would expect that for a closed (disconnected) transient connection it should just over-write the values in SQL Developer with those from the connection helper. I can see that if it was still connected, that's different (I would expect an error in that case) and that a permanent connection would also be different (maybe also an error - or at least a question).

If I close SQL Developer it works, as the transient connections are deleted. Manually deleing the connection before reconnecting also works, but it's far from ideal.

Hello,

I am trying to write a very basic spring boot app that connects to an Oracle Database(The database is located on a different machine, to be able to access it I am using a VPN to have access) but I keep getting an exception.
I am able to connect from my local machine to may remote oracle database via sqlDeveloper being on VPN.
If I am not connected to VPN I got the same error in sqlDeveloper.

This is the error when running mvn spring-boot:run command from my Intelij IDE terminal:

2021-05-11 02:23:16.904 INFO 7878 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2021-05-11 02:23:18.396 ERROR 7878 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.

java.sql.SQLRecoverableException: IO Error: Unknown host specified
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0]
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0]
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0]
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0]
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136) ~[HikariCP-3.2.0.jar:na]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) ~[HikariCP-3.2.0.jar:na]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) ~[HikariCP-3.2.0.jar:na]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) [HikariCP-3.2.0.jar:na]
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) [HikariCP-3.2.0.jar:na]
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) [HikariCP-3.2.0.jar:na]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-3.2.0.jar:na]
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157) [spring-jdbc-5.1.6.RELEASE.jar:5.1.6.RELEASE]
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) [spring-jdbc-5.1.6.RELEASE.jar:5.1.6.RELEASE]
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) [spring-jdbc-5.1.6.RELEASE.jar:5.1.6.RELEASE]
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:319) [spring-jdbc-5.1.6.RELEASE.jar:5.1.6.RELEASE]
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:356) [spring-jdbc-5.1.6.RELEASE.jar:5.1.6.RELEASE]
at org.springframework.boot.autoconfigure.jooq.SqlDialectLookup.getDialect(SqlDialectLookup.java:52) [spring-boot-autoconfigure-2.1.4.RELEASE.jar:2.1.4.RELEASE]

I am using the following dependency for the oracle jdbc driver in my pom.xml file:

    <dependency>
        <groupId>com.oracle.database.jdbc</groupId>
        <artifactId>ojdbc8</artifactId>
        <version>12.2.0.1</version>
        <scope>runtime</scope>
    </dependency>

My application.yaml file looks like this:

spring:
datasource:
url: jdbc:oracle:thin:@//HOSTNAME:1521/SERVICENAME
username: USERNAME
password: PASSWORD
driver-class-name: oracle.jdbc.OracleDriver

Please tell me if any of the configuration is wrong or suggest what to change in order to be able to access my remote oracle database via a spring boot app.

Hi,
I am trying to develop an extension on SQL developer.
Extension content will try to connect to the TEST database automatically with 30 users. Once connected, I will run certain scripts. But I could not connect to TEST database by changing user. I need to use the connection on SQLDeveloper. Each computer will have different users and connections.
I'm putting the sample code block below.
How do I make changes to fixed connections here?

`
package connectioncontrol;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.text.DateFormat;
import java.text.SimpleDateFormat;

import java.util.Date;
import java.util.List;

import oracle.dbtools.raptor.utils.Connections;

import oracle.ide.log.LogManager;

import oracle.javatools.db.DBException;

public class test {
List usernameList;

private static final void LogMessage(String level, String msg) {
    DateFormat dateFormat = new SimpleDateFormat("HH:mm:ss");
    LogManager.getLogManager()
              .getMsgPage()
              .log("CC: [" + dateFormat.format(new Date()) + "] " + level + ": " + msg + "\n");
}

public void run() {
    Connections conns = Connections.getInstance();
    try {
        String[] l = conns.getConnNames();
        for (String connectionName : l) {
            String displayConnectionName = connectionName;
            if (displayConnectionName.contains("%23")) {
                displayConnectionName = connectionName.substring(connectionName.indexOf("%23") + 3);
            }
            for (String username : usernameList) {
                //conns  change user and password
                //
                //
                Statement sqlStatement = null;
                try {
                    sqlStatement = Connections.getInstance()
                                              .getConnection(connectionName)
                                              .createStatement();
                    String QueryString = "SELECT 1 FROM DUAL";
                    ResultSet rs = sqlStatement.executeQuery(QueryString);
                    while (rs.next()) {
                        LogMessage("DEBUG", "query returned: " + rs.getString("SYSDATE"));
                    }
                } catch (SQLException e) {
                    LogMessage("ERROR", displayConnectionName + " " + e.toString());

                } catch (DBException e) {
                    LogMessage("ERROR", displayConnectionName + " " + e.toString());

                } finally {
                    if (sqlStatement != null) {
                        try {
                            sqlStatement.close();
                        } catch (SQLException e) {
                            LogMessage("ERROR", displayConnectionName + " " + e.toString());
                        }
                    }
                }
            }
        }
    } catch (Exception e) {
        LogMessage("ERROR", "GLOBAL:  " + e.toString());
    }
}

}

`

Hi.

I'm trying to use this API but I keep on getting this error: "ORA-00904: "EMPLOYEE_ID": invalid identifier"

I just used the same code so I guess that the problem is in my DB table.

I read guide at https://docs.oracle.com/database/121/COMSC/installation.htm#COMSC00005 . But the guide did not guide me how to enter connection string.

My question also at here: https://stackoverflow.com/questions/74529518/how-to-enter-connection-string-when-install-hr-sample-schema

Node-oracledb should be updated to the latest release in the javascript/rest-api apps.

The dashboards for Exadata's real-time insights looks great, however, how are these metrics being consumed by Prometheus?

I'd love to see the scrape_configs in prometheus.yml for your Exadata targets. Is this being scraped directly using the API or is there a bridge in between?

Jeff Smith sent me here.
Is it possible to create a sql developer extension for the package_parent (function, procedure)? It should provide a way inserting code into an existing and/or new code page (sql worksheet, new package, new function etc.).
Because this is not possible with templates (inserting comments, date and user) i'd like to create an extension for this issue. I did not find an example for this or any further information about this.
Could someone give me a hint on this ? If possible, i'd like to create this extension only with xml.

Just to let folks know I'm updating the examples to be compatible with today's 18.1 release.