Exception ORA-01403: no data found not raised from JDBC driver
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