[jsp게시판 만들기] ds가 왜 null 값인지 봐주실 수 있으실까요?

Question

jsp게시판 만들기 실습 중인뎁,,, DataSource가 계속 null로 나오는데 코드를 어떻게 고쳐도 계속 오류가 나서 코드에 잘 못된 부분이 있는지 알려주심 감사하겠습니다 ㅜ_ㅜpackage common; import java.sql.Connection; import java.sql.SQLException; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; public class JdbcUtil { private static JdbcUtil instance = new JdbcUtil(); private static DataSource ds; static { try { Class.forName("oracle.jdbc.OracleDriver"); System.out.println("드라이브 로딩 성공"); InitialContext ctx = new InitialContext(); System.out.println(ctx); ds = (DataSource) ctx.lookup("java:comp/env/jdbc/myOracle"); // 왜 null이지,,, System.out.println("Connection Pool생성완료 "); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (NamingException e) { e.printStackTrace(); } } private JdbcUtil() { } public static JdbcUtil getInstance() { return instance; } public Connection getConnection() throws SQLException { return ds.getConnection();// 풀에서 커넥션 반환 } } package board; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.Date; import java.util.List; import common.JdbcUtil; public class BoardDAO { private JdbcUtil jUtil; public BoardDAO() { jUtil = JdbcUtil.getInstance(); } // insert(C) public int insert(BoardVo vo) { Connection conn = null; PreparedStatement psmt = null; String sql = "INSERT INTO \"board\" (\"num\", \"title\", \"writer\", \"content\", \"regdate\", \"cnt\") " + "VALUES (\"board_seq\".nextval, ?, ?, ?,sysdate, 0)"; int result = -1; try { conn = jUtil.getConnection(); psmt = conn.prepareStatement(sql); psmt.setString(1, vo.getTitle()); psmt.setString(2, vo.getWriter()); psmt.setString(3, vo.getContent()); result = psmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { if (psmt != null) { try { psmt.close(); } catch (SQLException e) { e.printStackTrace(); } } } return result; } // select(R) public List selectAll() { Connection conn = null; Statement stmt = null; ResultSet rs = null; String sql = "SELECT \"num\",\"title\",\"writer\",\"content\",\"regdate\",\"cnt\" FROM \"board\""; ArrayList ls = new ArrayList(); try { conn = jUtil.getConnection(); stmt = conn.createStatement(); stmt.executeQuery(sql); rs = stmt.executeQuery(sql); while (rs.next()) { BoardVo vo = new BoardVo(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), new Date(rs.getDate(5).getTime()), rs.getInt(6)); ls.add(vo); } } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } if (stmt != null) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } } return ls; } public BoardVo selectOne(int num) { Connection conn = null; PreparedStatement psmt = null; ResultSet rs = null; String sql = "SELECT \"num\",\"title\",\"writer\",\"content\",\"regdate\",\"cnt\" FROM \"board\" WHERE \"num\"=?"; BoardVo vo = null; try { ; conn = jUtil.getConnection(); psmt = conn.prepareStatement(sql); psmt.setInt(1, num); rs = psmt.executeQuery(); if (rs.next()) { vo = new BoardVo(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), new Date(rs.getDate(5).getTime()), rs.getInt(6)); } } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } if (psmt != null) { try { psmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } } return vo; } }

Clickin · Answer

톰캣에서 데이터소스 설정 정확하게 됐는지 확인해보시기 바랍니다.java:comp/env/jdbc/myOracle 로 찾아올 수 있는 형태인지 정확하게 확인하셔야합니다.

[jsp게시판 만들기] ds가 왜 null 값인지 봐주실 수 있으실까요?

1개의 답변

#getconnection 목록