I have created the following stored procedure in SQL Server 2008
Calculate the processinfected @ Concerned Int'l Out AS @infected = COUNT (*) Choose from userInfo where user id is not (select user id with deleted infoines); Follow my Java code as is
infected with callbelt = con.prepareCall ("exec countInfected ()"); Infected.registerOutParameter (1, java.sql.Types.INTEGER); Infected.execute (); System.out.println ("infected" + infected.getINT (1)); but it generates the following error
java.lang.NullPointerException on core.dtable.Dbase.stored (Dbase.java:51)
Please guide me where I am wrong
try {Conn = DBC connection. SQLDB Conn.setAutoCommit (wrong); Callable Stattement CS = Faucet; Cs = conn.prepareCall ("call {dbo.xxCount (?)}"); Cs.registerOutParameter (1, java.sql.Types.INTEGER); Cs.execute (); System.out.println ("INFECTED" + cs.getInt (1)); } Hold (exception mistake) { Put the parameter in your stored proc in your phone
No comments:
Post a Comment