Exception ORA-01403: no data found not raised from JDBC driver

From: Salvador <salvador.richter_at_in-gmbh.de>
Date: 25 Apr 2003 05:16:42 -0700
Message-ID: <3fdfd506.0304250416.4a7e710_at_posting.google.com>


Hy there I have a problem receiving exceptions from oracle jdbc driver.

I have the following exception stack if i call insert on a view using an instead of trigger.

 ORA-01403: no data found
 ...
 ORA-04088: error during execution of trigger  'MYUSER.MY_VIEW_INSERT' if I do the insert by sql worksheet

if I do same insert using the following driver dbDriver = new intersolv.jdbc.sequelink.SequeLinkDriver(); I will receive this exception:
java.sql.SQLException: [INTERSOLV][SequeLink JDBC Driver][ORACLE]ORA-01403: Keine Daten gefunden

Now if I do same thing using oracle driver: dbDriver = new oracle.jdbc.driver.OracleDriver();

there will no exception be raised!

here is my code:

public static void main( String[] args )
{

  Frame myFrame = new Frame();
  DbPflege dbPanel = new DbPflege();
  Driver dbDriver = null;
  String connectString = null;
  try
  {
    if( args.length != 0 )
    {

      System.out.println( "main: use sequelink!" );
      connectString = "jdbc:sequelink://myServer:4003/[Oracle]";
      dbDriver = new intersolv.jdbc.sequelink.SequeLinkDriver();
    }
    else
    {
      System.out.println( "main: use oracle!" );
      connectString = "jdbc:oracle:thin:_at_myServer:1521:idb";
      dbDriver = new oracle.jdbc.driver.OracleDriver();
    }
    DriverManager.registerDriver( dbDriver );     dbPanel.con = DriverManager.getConnection(connectString, "user", "pwd" );
  }
  catch( Exception ex )
  {
    System.out.println( "main: ERROR: " + ex );     ex.printStackTrace();
  }
}

void jBtnExecute_actionPerformed(java.awt.event.ActionEvent event)
{

  Statement stmt = null;
  int updateCount = -1;
  int colCount = -1;
  ResultSet rs = null;
  ResultSetMetaData rsMeta = null;           

try
{

  stmt = con.createStatement();
  stmt.execute( textAreaInput.getText() ); }
catch( Exception ex )
{

  textAreaOutput.append( ex.toString() ); }  

}

thanks for your help!!!! Received on Fri Apr 25 2003 - 14:16:42 CEST

Original text of this message