本文将带您了解关于将ORACLETRIGGER插入``的新内容，同时我们还将为您解释SELECT*``的相关知识，另外，我们还将为您提供关于com.google.android.exoplayer2.

本文将带您了解关于将ORACLE TRIGGER插入``的新内容，同时我们还将为您解释SELECT *``的相关知识，另外，我们还将为您提供关于com.google.android.exoplayer2.trackselection.MappingTrackSelector.SelectionOverride的实例源码、Couldn''t retrieve trigger: No record found for selection of Trigger with key: ''DEFAULT.MT_dafhib9gccqrc''、jboss6.x – 无法将oracle.jdbc.driver.T4CConnection强制转换为oracle.jdbc.OracleConnection、MySQL的trigger和oracle的trigger的区别的实用信息。

• 将ORACLE TRIGGER插入``（SELECT *``）（oracle trigger insert）
• com.google.android.exoplayer2.trackselection.MappingTrackSelector.SelectionOverride的实例源码
• Couldn''t retrieve trigger: No record found for selection of Trigger with key: ''DEFAULT.MT_dafhib9gccqrc''
• jboss6.x – 无法将oracle.jdbc.driver.T4CConnection强制转换为oracle.jdbc.OracleConnection
• MySQL的trigger和oracle的trigger的区别

将ORACLE TRIGGER插入``（SELECT *``）（oracle trigger insert）

使用插入到触发（选择* …）

我正在尝试。

INSERT INTO T_ USERS SELECT * FROM USERS WHERE ID = :new.ID;

不起作用…

这项工作。

INSERT INTO T_USERS(ID) VALUES(:new.ID);

Trigger

create or replace trigger "TRI_USER"AFTERinsert on "USER"for each rowbeginINSERT INTO T_USER SELECT * FROM USER WHERE ID = :new.ID;end;​

答案1

这项工作。

INSERT INTO T_USERS(ID) VALUES(:new.ID);

因此，如果适合您，请尝试以下操作：

INSERT INTO T_USER(ID) SELECT ID FROM USER WHERE ID = :new.ID;

如果要从另一张表中选择一个或多个行，则必须使用以下语法：

insert into <table>(<col1>,<col2>,...,<coln>)select <col1>,<col2>,...,<coln>from ...;

com.google.android.exoplayer2.trackselection.MappingTrackSelector.SelectionOverride的实例源码

private static int[] getTracksRemoving(SelectionOverride override,int removedTrack) {
  int[] tracks = new int[override.length - 1];
  int trackCount = 0;
  for (int i = 0; i < tracks.length + 1; i++) {
    int track = override.tracks[i];
    if (track != removedTrack) {
      tracks[trackCount++] = track;
    }
  }
  return tracks;
}

private static int[] getTracksRemoving(SelectionOverride override,int removedTrack) {
    int[] tracks = new int[override.length - 1];
    int trackCount = 0;
    for (int i = 0; i < tracks.length + 1; i++) {
        int track = override.tracks[i];
        if (track != removedTrack) {
            tracks[trackCount++] = track;
        }
    }
    return tracks;
}

private static int[] getTracksRemoving(SelectionOverride override,int removedTrack) {
  int[] tracks = new int[override.length - 1];
  int trackCount = 0;
  for (int i = 0; i < tracks.length + 1; i++) {
    int track = override.tracks[i];
    if (track != removedTrack) {
      tracks[trackCount++] = track;
    }
  }
  return tracks;
}

private static int[] getTracksRemoving(SelectionOverride override,int removedTrack) {
  int[] tracks = new int[override.length - 1];
  int trackCount = 0;
  for (int i = 0; i < tracks.length + 1; i++) {
    int track = override.tracks[i];
    if (track != removedTrack) {
      tracks[trackCount++] = track;
    }
  }
  return tracks;
}

private void setoverride(int group,int[] tracks,boolean enableRandomAdaptation) {
  TrackSelection.Factory factory = tracks.length == 1 ? FIXED_FACTORY
      : (enableRandomAdaptation ? RANDOM_FACTORY : adaptiveVideoTrackSelectionFactory);
  override = new SelectionOverride(factory,group,tracks);
}

private static int[] getTracksAdding(SelectionOverride override,int addedTrack) {
  int[] tracks = override.tracks;
  tracks = Arrays.copyOf(tracks,tracks.length + 1);
  tracks[tracks.length - 1] = addedTrack;
  return tracks;
}

private void setoverride(int group,boolean enableRandomAdaptation) {
    TrackSelection.Factory factory = tracks.length == 1 ? FIXED_FACTORY
            : (enableRandomAdaptation ? RANDOM_FACTORY : adaptiveVideoTrackSelectionFactory);
    override = new SelectionOverride(factory,tracks);
}

private static int[] getTracksAdding(SelectionOverride override,int addedTrack) {
    int[] tracks = override.tracks;
    tracks = Arrays.copyOf(tracks,tracks.length + 1);
    tracks[tracks.length - 1] = addedTrack;
    return tracks;
}

private void setoverride(int group,tracks);
}

private static int[] getTracksAdding(SelectionOverride override,tracks.length + 1);
  tracks[tracks.length - 1] = addedTrack;
  return tracks;
}

private void setoverride(int group,boolean enableRandomAdaptation) {
  TrackSelection.Factory factory = tracks.length == 1 ? FIXED_FACTORY
      : (enableRandomAdaptation ? RANDOM_FACTORY : adaptiveTrackSelectionFactory);
  override = new SelectionOverride(factory,tracks);
}

private static int[] getTracksAdding(SelectionOverride override,tracks.length + 1);
  tracks[tracks.length - 1] = addedTrack;
  return tracks;
}

Couldn''t retrieve trigger: No record found for selection of Trigger with key: ''DEFAULT.MT_dafhib9gccqrc''

2019-05-30 13:37:54.309  INFO 4973 --- [_MisfireHandler] o.s.s.quartz.LocalDataSourceJobStore     : Handling 1 trigger(s) that missed their scheduled fire-time.
2019-05-30 13:37:54.312 ERROR 4973 --- [_MisfireHandler] o.s.s.quartz.LocalDataSourceJobStore     : MisfireHandler: Error handling misfires: Couldn''t retrieve trigger: No record found for selection of Trigger with key: ''DEFAULT.MT_dafhib9gccqrc'' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = ''RASScheduler'' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?

org.quartz.JobPersistenceException: Couldn''t retrieve trigger: No record found for selection of Trigger with key: ''DEFAULT.MT_dafhib9gccqrc'' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = ''RASScheduler'' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1538) ~[quartz-2.3.0.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:984) ~[quartz-2.3.0.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3249) ~[quartz-2.3.0.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3997) [quartz-2.3.0.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:4018) [quartz-2.3.0.jar:na]
Caused by: java.lang.IllegalStateException: No record found for selection of Trigger with key: ''DEFAULT.MT_dafhib9gccqrc'' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = ''RASScheduler'' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?
    at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.loadExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:110) ~[quartz-2.3.0.jar:na]
    at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1819) ~[quartz-2.3.0.jar:na]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1536) ~[quartz-2.3.0.jar:na]
    ... 4 common frames omitted

jboss6.x – 无法将oracle.jdbc.driver.T4CConnection强制转换为oracle.jdbc.OracleConnection

WrappedConnectionJDK6 wrapped = (WrappedConnectionJDK6) dbStrategy.getConnection();
            Connection underlyingConn = wrapped.getUnderlyingConnection();
            OracleConnection oracleConn = (OracleConnection)underlyingConn;

> ERROR
> [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/web].[resteasy-servlet]]
> (http-/0.0.0.0:8080-1) Servlet.service() for servlet resteasy-servlet
> threw exception: org.jboss.resteasy.spi.UnhandledException:
> java.lang.classCastException: oracle.jdbc.driver.T4CConnection cannot
> be cast to oracle.jdbc.OracleConnection

MySQL的trigger和oracle的trigger的区别

MySQL的trigger是仅仅statement激活，不能对同一table的同一个event写两个trigger, 同一个event是指create trigger 中的trigger_

MySQL的trigger是仅仅statement激活，，不能对同一table的同一个event写两个trigger, 同一个event是指create trigger 中的trigger_time+trigger_event. trigger不会因为某些表的改变而被激活，这些表的改变是通过API修改的，这些API不发送语句给mysql server.

1. mysql只能对每一行触发一次，而Oracle可以对每一行整个表触发一次。
2. mysql只能是表的行激活触发器，但oracle可以做到对列触发。

oracle里面触发器的定义语句：

CREATE
[OR REPLACE] trigger_name trigger_time trigger_event of column
ON tbl_name referencing old as old_value
new as new_value
FOR EACH ROW trigger_stmt

mysql中触发器的定义语句：
CREATE
[DEFINER = { user | CURRENT_USER }]
TRIGGER trigger_name trigger_time trigger_event
ON tbl_name FOR EACH ROW trigger_stmt

简单测试如下：

mysql> delimiter |
mysql> CREATE TRIGGER test_a BEFORE INSERT ON a
    ->   FOR EACH ROW BEGIN
    ->     INSERT INTO abc SET id = NEW.id;
    ->
    ->   END;
    -> |
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql>
mysql>
mysql> delimiter |
mysql> CREATE TRIGGER test_b BEFORE INSERT ON a
    ->   FOR EACH ROW BEGIN
    ->     INSERT INTO abc SET name = NEW.name;
    ->
    ->   END;
    -> |
ERROR 1235 (42000): This version of MySQL doesn''t yet support ''multiple triggers with the same action time and event for one table''
mysql> delimiter ;
mysql>
mysql>
mysql> delimiter |
mysql> CREATE TRIGGER test_b AFTER INSERT ON a
    ->   FOR EACH ROW BEGIN
    ->     INSERT INTO abc SET name = NEW.name;
    ->
    ->   END;
    -> |
Query OK, 0 rows affected (0.00 sec)

关于将ORACLE TRIGGER插入``和SELECT *``的问题就给大家分享到这里，感谢你花时间阅读本站内容，更多关于com.google.android.exoplayer2.trackselection.MappingTrackSelector.SelectionOverride的实例源码、Couldn''t retrieve trigger: No record found for selection of Trigger with key: ''DEFAULT.MT_dafhib9gccqrc''、jboss6.x – 无法将oracle.jdbc.driver.T4CConnection强制转换为oracle.jdbc.OracleConnection、MySQL的trigger和oracle的trigger的区别等相关知识的信息别忘了在本站进行查找喔。