http://community.csdn.net/Expert/TopicView1.asp?id=5227752
同样的问题
解决两贴一并给分,谢谢!!
weblogic 是8.1
jboss 3.2.3
打开连接池的代码
public Connection getConnection() {
try {
// 使用JBOSS的连接池,只需以下几行即可
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:/MSSQLXADS_myweb");
Connection conn = null;
conn = ds.getConnection();
if (conn==null) {
System.out.println("myweb 数据库:采用连接池--------连接串没有得到。");
} else{
return conn;
}
文件:C:\jboss-3.2.3\docs\examples\jca\mssql-xa-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<xa-datasource>
<jndi-name>MSSQLXADS_myweb</jndi-name>
<xa-datasource-class>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</xa-datasource-class>
<xa-datasource-property name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property name="DatabaseName">webtest</xa-datasource-property>
<xa-datasource-property name="SelectMethod">cursor</xa-datasource-property>
<!-- not sure if these should be here-->
<user-name>sa</user-name>
<password>sa</password>
</xa-datasource>
</datasources>
打开web页面报错
java.lang.NullPointerException
at myweb.admin.module.ModuleBean.getAllModuleList(ModuleBean.java:35)是打开数据库连接时候报错
同样的问题
解决两贴一并给分,谢谢!!
weblogic 是8.1
jboss 3.2.3
打开连接池的代码
public Connection getConnection() {
try {
// 使用JBOSS的连接池,只需以下几行即可
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:/MSSQLXADS_myweb");
Connection conn = null;
conn = ds.getConnection();
if (conn==null) {
System.out.println("myweb 数据库:采用连接池--------连接串没有得到。");
} else{
return conn;
}
文件:C:\jboss-3.2.3\docs\examples\jca\mssql-xa-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<xa-datasource>
<jndi-name>MSSQLXADS_myweb</jndi-name>
<xa-datasource-class>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</xa-datasource-class>
<xa-datasource-property name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property name="DatabaseName">webtest</xa-datasource-property>
<xa-datasource-property name="SelectMethod">cursor</xa-datasource-property>
<!-- not sure if these should be here-->
<user-name>sa</user-name>
<password>sa</password>
</xa-datasource>
</datasources>
打开web页面报错
java.lang.NullPointerException
at myweb.admin.module.ModuleBean.getAllModuleList(ModuleBean.java:35)是打开数据库连接时候报错
解决方案 »
- 求大侠帮忙 Exception sending context initialized event to listener instance of class
- 求助!关于struts2的权限控制问题!
- 用SmartUpload下载文件,能不能把源文件压缩成".zip"文件下载?
- tomcat问题
- java
- ssh--用Struts上传图片的问题总是有BeanUtils.populate错误
- html文本框的问题
- 第一个Hebernate程序,请高手指教错误
- [必读]用java编程的人进来看看!!!!
- jbdctemplate.query结果有问题,请指教
- jsf怎么在tomcat下运行?
- 关于Session的延时问题
贴下这个罗
空指针啊
Context envCtx = (Context) initCtx.lookup("java:comp/env");
//所有配置好的资源都放在“java:comp/env”中
学习
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("oracle/conn");
conn=ds.getConnection();
DBPool m_DBPool = new DBPool(m_servletContext, m_req);
//conn = m_DBPool.getConnection();
Connection conn = null;
ConnectionPoolByODBC cmss = new ConnectionPoolByODBC();
conn=cmss.getConnection();
PreparedStatement pstmt = null;
ResultSet rs = null;
String sSQL = null;
sSQL = "select CAST(ID AS VARCHAR(10)) AS 'ID',MODULE_NAME,MODULE_DESC,TEMPLATE_NAME ,DISPLAY,POSITION,CAST(USERS_ID AS VARCHAR(10)) AS 'USERS_ID',CONVERT(VARCHAR(10),CREATETIME,101) AS 'CREATETIME',MEMO from MAINMODULE ORDER BY cast(ID as int) DESC";
Vector v = new Vector();
try {
//conn = m_DBPool.getConnection(); ConnectionPoolByODBC cmss = new ConnectionPoolByODBC();conn=cmss.getConnection();
pstmt = conn.prepareStatement(sSQL);///////////////////////////////////报错行,第35行
rs = pstmt.executeQuery();
String tempStr ;
while (rs.next()) {
ModuleItem mi = new ModuleItem();
tempStr = rs.getString(1);
mi.setId(tempStr);
tempStr = rs.getString(2);
mi.setModuleName(tempStr);
tempStr = rs.getString(3);
mi.setModuleDesc(tempStr);
tempStr = rs.getString(4);
mi.setTemplateName(tempStr);
tempStr = rs.getString(5);
mi.setDisplay(tempStr);
tempStr = rs.getString(6);
mi.setPosition(tempStr);
tempStr = rs.getString(7);
mi.setUserId(tempStr);
tempStr = rs.getString(8);
mi.setCreatetime(tempStr);
tempStr = rs.getString(9);
mi.setMemo(tempStr);
v.add(mi);
}
v.toArray();
v.trimToSize();
return v;
}
catch(SQLException ex) {
System.out.println("error:".concat(String.valueOf(String.valueOf(ex.getMessage()))));
}
finally { Common.close(rs, pstmt, conn);
}
return null;
}