java.sql.SQLException: ERROR: Relation 'site' does not exist

Oracle Community | 807553 | 1 decade ago
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Postgres JDBC

    Oracle Community | 1 decade ago | 807553
    java.sql.SQLException: ERROR: Relation 'site' does not exist
  2. 0

    JBoss Community / Mailing Lists | 1 year ago
    java.sql.SQLException: ERROR: pg_aclcheck: class "nuke_news_comments_comment_id_s" not found
  3. 0

    java.sql.SQLException: No value specified for parameter 1解决办法_IT知识问答_希赛网 | 2 years ago
    java.sql.SQLException: No value specified for parameter 1 代码如下 public boolean login(UserInfo user)throws Exception{ //用户登录 boolean flag=false; int userNo=Integer.parseInt(user.getUserNo()); String password=user.getPassword(); //测试是否从现在的user对象中取到了值 System.out.println(userNo+"我是USER对象的userNo"); System.out.println(password+"我是USER对象的password"); DatabaseConnection dbc=new DatabaseConnection();//取得数据库连接和关闭对象; try{ String sql="SELECT userNo FROM userInfo where userNo= and password= "; this.conn=dbc.getConnection(); this.pst=conn.prepareStatement(sql); //this.pst.setInt(1, userNo);//给sql中参数赋值 this.pst.setLong(1, userNo); this.pst.setString(2, password); ResultSet rs=pst.executeQuery(); if({//传入用户账号和对应的密码都存在时为真 flag=true; System.out.println(rs.getString(userNo)+"我是从数据库里取出来的"); System.out.print(flag+"测试flag");//测试flag,看是否进入了if里面,true则进入了 rs.close(); } }catch(Exception e){ e.printStackTrace(); }finally{ if(this.pst!=null){ this.pst.close(); } this.conn.close(); } return flag; } 报的错误信息如:
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: No suitable driver - Toolbox for IT Groups | 8 months ago
    java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager .java:545) at java.sql.DriverManager.getConnection(DriverManager .java:171) at ateConnection( at Connection( at at at at
  6. 0

    1 more error - Java Programming Help - | 2 years ago
    java.sql.SQLException: Protocol violation at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava:1160) at oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.j ava:149) at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protoco at oracle.jdbc.driver.OracleConnection.rollback(Oracl at net.sf.hibernate.transaction.JDBCTransaction.rollb ack( at til.doSessionWork( at til.doSessionWork( at til.get( at ession.get( at nent.taskCompleted( 54) at nent.onTaskEvent( ) at

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ERROR: Relation 'site' does not exist

      at org.postgresql.Connection.ExecSQL()
    2. PostgreSQL JDBC Driver
      1. org.postgresql.Connection.ExecSQL(
      2. org.postgresql.jdbc2.Statement.execute(
      3. org.postgresql.jdbc2.Statement.executeQuery(
      3 frames
    3. or.kernel.api
      1. or.kernel.api.base.reloadalldata(
      2. or.kernel.api.base.reloadalldata(
      3. or.kernel.api.base.initialize(
      3 frames
    4. or.webor
      1. or.webor.main.init(
      1 frame
    5. sun.servlet
      1. sun.servlet.ServletLoader.loadServlet(
      1 frame
    6. sun.servlet.http
      1. sun.servlet.http.HttpServer.getServlet(
      2. sun.servlet.http.HttpServerHandler.sendResponse(
      3. sun.servlet.http.HttpServerHandler.handleConnection(
      4 frames
    7. Java RT
      1 frame