Oracle 连接 URL 中的默认架构

2021-12-06 00:00:00 oracle jdbc connection-string

我想在 Oracle Connection URL

jdbc:oracle:thin:@<server>:<port1521>:<sid>

我的示例 SQL 语句:

My sample SQL statement:

select monkey_name from animals.monkey

我需要查询没有模式前缀animals.的数据库，即当我运行这个语句时

I need to query database without schema prefix animals. i.e. when I run this statement

select monkey_name from monkey

默认使用animals模式.

我需要在上面的连接URL中指定什么才能达到这种效果?

What do I need to specify in connection URL above get such effect?

谢谢.

推荐答案

您不能在连接 URL 中放置任何内容.

You can't put anything in the connection URL.

在 Oracle 中，每个用户都有自己的架构(即使不包含任何对象)，这是他们的默认架构.登录/连接后，他们可以使用

In Oracle each user has their own schema (even if doesn't contain any objects) and that is their default schema. Once logged in/connected, they can change their default schema with an

ALTER SESSION SET CURRENT_SCHEMA=animals

所以你需要在连接后做额外的声明.可以在用户和/或数据库上设置一个登录触发器，在他们登录时运行该触发器.我个人更喜欢在应用程序连接时使用显式语句.

So you'd need to do the extra statement after connecting. It is possible to have a logon trigger on the user and/or database that will run this when they log in. I'd personally prefer an explicit statement when an application connects.

相关文章