need help in sql stored procedure and java

[andy davis]

Hi I am making an application for taking backup in sql automatically so i have created a dts package which is called by a stored procedure.
Now the problem is that how to call that stored procedure in a Java program so that after running my java program i get my database backup

[PLA]

Hi I am making an application for taking backup in sql automatically so i have created a dts package which is called by a stored procedure.
Now the problem is that how to call that stored procedure in a Java program so that after running my java program i get my database backup

sometyhing like this

    
try
    {
      tConn = xxxx.getDataSource().getConnection();
      tConn.setAutoCommit(false);
      tCall = tConn.prepareCall("{CALL MY_PROC(?,?)}");
      tCall.setInt(1, my1stVar);
      tCall.setInt(2, my2dVar);
      ResultSet tRs = tCall.executeQuery();

      if (tRs.next())
      {
        /* do something */      }
      tCall.clearParameters();
      tRs.close();
      tConn.commit();
    }

may it helps!

[andy davis]

Thanks very much..... i'll try n let u know....