JDBC - oracle - prepareStatement

[Cyril Franko]

problem sa vyriesi ak sa v Connection do oraclu nastavi
conn.setAutoCommit(true);

> problem nastane pri inserte:
> 
>         PreparedStatement ps = null;
>         String sql, rid;
>         ResultSet rs;
>         long ret=0;
> 
>         rid = "343423";
> 
>         sql = "INSERT INTO cf1 (rid) VALUES (?)";
>          System.out.println(sql);
>         try {
>             ps = conn.prepareStatement( sql );
>             ps.setString(1,rid);
> 
>              ps.execute();
>             ps.execute("commit");
>         } catch (SQLException ex) { // error
>             throw ex;
>         }
> 
> vyhodi to nasledujucu hlasku:
> java.sql.SQLException: ORA-01006: bind variable does not exist
>