O meu esta dando erro!!!
package br.com.caelum.jdbc;
import java.sql.Connection; import java.sql.SQLException;
import javax.sql.DataSource;
import org.hsqldb.jdbc.JDBCPool;
public class ConnectionPool {
private DataSource dataSource;
ConnectionPool(){ JDBCPool pool = new JDBCPool(); pool.setURL("jdbc:hsqldb:hsql://localhost/loja-virtual"); pool.setUser("SA"); pool.setPassword(""); this.dataSource = pool;
}
Connection getConnection() throws SQLException{
//Connection conexao = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/loja-virtual", "SA", ""); Connection conexao = dataSource.getConnection(); return conexao;
} }
import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;
public class TestaListagem {
public static void main(String[] args) throws SQLException {
Connection conexao = new ConnectionPool().getConnection();
Statement statement = conexao.createStatement(); boolean result = statement.execute("select * from Produto"); ResultSet resultSet = statement.getResultSet();
while(resultSet.next()){ int id = resultSet.getInt("id"); String nome = resultSet.getString("nome"); String descricao = resultSet.getString("descricao"); System.out.println(id + "; Nome: " + nome + "; Decricao: "+ descricao); }
resultSet.close(); statement.close();
conexao.close(); }
}
Exception in thread "main" java.lang.NullPointerException at org.hsqldb.DatabaseURL.parseURL(Unknown Source) at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) at org.hsqldb.jdbc.pool.JDBCPooledDataSource.getPooledConnection(Unknown Source) at org.hsqldb.jdbc.JDBCPool.getConnection(Unknown Source) at br.com.caelum.jdbc.ConnectionPool.getConnection(ConnectionPool.java:26) at br.com.caelum.jdbc.TestaListagem.main(TestaListagem.java:12)
