无情修罗 发表于 2015-6-21 23:56:21

jdbc的小问题

import java.sql.*;



public class TestProc {

        public static void main(String[] args) throws Exception {
                Class.forName("oracle.jdbc.driver.OracleDriver");
                Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "scott", "tiger");
               
                CallableStatement cstmt = conn.prepareCall(" {call p(?, ?, ?, ?)} ");
               
                cstmt.registerOutParameter(3, Types.INTEGER);
                cstmt.registerOutParameter(4, Types.INTEGER);
               
                cstmt.setInt(1, 3);
                cstmt.setInt(2, 4);
                cstmt.setInt(4, 5);
               
                cstmt.execute();
               
                System.out.println(cstmt.getInt(3));
                System.out.println(cstmt.getInt(4));
               
                cstmt.close();
                conn.close();
               
               
               
        }
}



运行时出现的问题

Exception in thread "main" java.lang.NullPointerException
        at oracle.jdbc.ttc7.TTCAdapter.newTTCType(TTCAdapter.java:270)
        at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCColumnArray(TTCAdapter.java:256)
        at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCDataSet(TTCAdapter.java:231)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1435)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2076)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1986)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2697)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:531)
        at TestProc.main(TestProc.java:20)


请问是怎么回事？

青玄 发表于 2015-7-4 10:43:45

空指针异常，打log调试一下看哪儿空了

JfPy 发表于 2017-5-11 17:30:29

说的很明确，空指针异常。打桩调试下就行了。

mandala 发表于 2017-5-16 09:31:00

它说代码第20行报错了，其他不知道，打个断点慢慢调试咯{:10_249:}
页: [1]
查看完整版本: jdbc的小问题