Guest_imported
New member
- Jan 1, 1970
- 0
hi,all I use JBuilder6 + mm.mysql , and use JdbcConnectionPool to get connect .
When I use Database.executeStatement , Exception occured. Here is my sample code and exception:
JdbcConnectionFactory jdbcConnectionFactory = new JdbcConnectionFactory();
JdbcConnectionPool pool = new JdbcConnectionPool();
jdbcConnectionFactory.setUrl("jdbc:mysql://"+strDBServer + ":" + strPort + "/" +strDBName+"?user="+strLoginName+"&password="+strPasswd) ;
jdbcConnectionFactory.setDriver("org.gjt.mm.mysql.Driver"
;
jdbcConnectionFactory.setUser(strLoginName ) ;
jdbcConnectionFactory.setPassword(strPasswd) ;
try {
pool.setConnectionFactory(jdbcConnectionFactory) ;
}catch ( Exception ex ) {
ex.printStackTrace() ;
}
Database db = new Database();
db.setJdbcConnect(pool.getConnect());
db.executementStatement("delete from table"
;
Exception occurred during event dispatching:
java.lang.NullPointerException
at com.borland.javax.sql.DelegateStatement.getUpdateCount(Unknown Source)
at com.borland.dx.sql.dataset.Database.executeStatement(Unknown Source)
...
Anybody help me?
Thanks
When I use Database.executeStatement , Exception occured. Here is my sample code and exception:
JdbcConnectionFactory jdbcConnectionFactory = new JdbcConnectionFactory();
JdbcConnectionPool pool = new JdbcConnectionPool();
jdbcConnectionFactory.setUrl("jdbc:mysql://"+strDBServer + ":" + strPort + "/" +strDBName+"?user="+strLoginName+"&password="+strPasswd) ;
jdbcConnectionFactory.setDriver("org.gjt.mm.mysql.Driver"
jdbcConnectionFactory.setUser(strLoginName ) ;
jdbcConnectionFactory.setPassword(strPasswd) ;
try {
pool.setConnectionFactory(jdbcConnectionFactory) ;
}catch ( Exception ex ) {
ex.printStackTrace() ;
}
Database db = new Database();
db.setJdbcConnect(pool.getConnect());
db.executementStatement("delete from table"
Exception occurred during event dispatching:
java.lang.NullPointerException
at com.borland.javax.sql.DelegateStatement.getUpdateCount(Unknown Source)
at com.borland.dx.sql.dataset.Database.executeStatement(Unknown Source)
...
Anybody help me?
Thanks