[ajug-members] jdbc error help

[Barnes, Mike]

I am attempting to update a materialized view on oracle and get a
ORA-00900 error. I can not seem to figure out how I need to call the
refresh statement.

 

Below is the code that I am calling, any help would be appreciated.

 

            try {

                  LOG.info("\t" +
this.storedProcedure.getStoredProcedureName() + " --> " +
storedProcedure.shouldDownloadOnce());

                  PreparedStatement stmt = null;

                  OracleConnection connection =
ConnectionManager.oracleConnection(market);

 

                  if ( null == connection )

                        LOG.error("Problem getting Connection");

 
LOG.info(storedProcedure.getTableConfiguration().get(0));

                  stmt =
connection.prepareStatement(ProcessProcedure.MVIEWEXEC);

//                stmt.setString(1,
storedProcedure.getTableConfiguration().get(0).getTableName());

                  stmt.setString(1, "MARKET");

                  stmt.setString(2, "C");

                  stmt.executeQuery();

            } catch (SQLException e) {

                  // TODO Auto-generated catch block

                  LOG.error("### --->>",e);

            }

 

      private final static String MVIEWEXEC = "execute
DBMS_MVIEW.REFRESH(?,?)";

 

 

Thanks

Mike Barnes

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.ajug.org/pipermail/ajug-members/attachments/20070215/0e5fb231/attachment.html