是否可以从外部连接到Oracle APEX应用程序中的数据库? [英] Is it possible to connect to DB in Oracle APEX application externally?

问题描述

我正在尝试从外部(使用Java)查询存储在Oracle APEX应用程序中的表.但是，我不太确定能否实现这一目标.因为在APEX内部，我能够使用dblink访问外部数据库.但是，另一种方式使我感到困惑.它从应该是连接字符串的地方开始，会有主机&端口详细信息等.

I am trying to query the table stored in Oracle APEX application externally (using Java). But, i am quite not sure on achieving it. Because, inside APEX i was able to access external databases using dblink. But, the other way around is puzzling me. It starts from what should be the connect string, will there be host & port details etc.,.

在oracle docs和其他dba论坛上进行的搜索没有涵盖这种情况.如果有人可以对此提供指导，那将是一个很大的帮助.

Search on oracle docs and other dba forums didn't cover this scenario. It would be a great help if someone can give a pointer on this.

推荐答案

根据注释，您尝试从外部访问apex.oracle.com数据库-这是不可能的. 从oracle访问在线演示工作区中的数据库的唯一有效方法是通过SQL Workshop或APEX应用程序. 如果需要从外部访问数据，我强烈建议使用APEX的RESTfull服务.无法通过JDBC直接连接.

According to the comments you're trying to access the apex.oracle.com Database externally - which isn't possible. The only valid way to access your database in the online demo workspaces from oracle is via the SQL Workshop or your APEX applications. If there's a need for accessing the data from outside i highly suggest using the RESTfull services from APEX. A direct connection via JDBC isn't possible.

这篇关于是否可以从外部连接到Oracle APEX应用程序中的数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！