各位:
我再补充一下:报错提示为:没有找到数据源 javax.naming.NameNotFoundException: MSSQLDS not bound
我的配置步聚发下:
1.在C:\JBOSS4.0\server\default\deploy\mssql-ds.xml
mssql-ds.xml内容如下:
<datasources>
<local-tx-datasource>
<jndi-name>MSSQLDS</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://192.168.0.160:1433;DatabaseName=shark</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>zl</password>
</local-tx-datasource>
</datasources>
jndi名称为MSSQLDS
2.我的WEB-INF/lib/有sqlserver2000 jdbc驱动程序:msbase.jar mssqlserver.jar msutil.jar
3.我在客户端jsp调用代码如下:
javax.naming.InitialContext init=null;
try
{
init=new javax.naming.InitialContext();
javax.sql.DataSource ds=(javax.sql.DataSource)init.lookup("java:/MSSQLDS");
try
{ java.sql.Connection conn=ds.getConnection();
java.sql.Statement stm=conn.createStatement();
String sql="select Id from Activities";
java.sql.ResultSet rst=stm.executeQuery(sql);
while (rst.next() )
{
out.println(rst.getString("Id"));
} }catch(Exception er)
{
System.out.println("erors"+er.toString());
} }catch(Exception er)
{
out.print("没有找到数据源"+er.toString() );
} finally{
try
{
if (init != null ) init.close();
} catch(Exception er)
{
out.print(er.toString() );
}
}
我再补充一下:报错提示为:没有找到数据源 javax.naming.NameNotFoundException: MSSQLDS not bound
我的配置步聚发下:
1.在C:\JBOSS4.0\server\default\deploy\mssql-ds.xml
mssql-ds.xml内容如下:
<datasources>
<local-tx-datasource>
<jndi-name>MSSQLDS</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://192.168.0.160:1433;DatabaseName=shark</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>zl</password>
</local-tx-datasource>
</datasources>
jndi名称为MSSQLDS
2.我的WEB-INF/lib/有sqlserver2000 jdbc驱动程序:msbase.jar mssqlserver.jar msutil.jar
3.我在客户端jsp调用代码如下:
javax.naming.InitialContext init=null;
try
{
init=new javax.naming.InitialContext();
javax.sql.DataSource ds=(javax.sql.DataSource)init.lookup("java:/MSSQLDS");
try
{ java.sql.Connection conn=ds.getConnection();
java.sql.Statement stm=conn.createStatement();
String sql="select Id from Activities";
java.sql.ResultSet rst=stm.executeQuery(sql);
while (rst.next() )
{
out.println(rst.getString("Id"));
} }catch(Exception er)
{
System.out.println("erors"+er.toString());
} }catch(Exception er)
{
out.print("没有找到数据源"+er.toString() );
} finally{
try
{
if (init != null ) init.close();
} catch(Exception er)
{
out.print(er.toString() );
}
}
哪位老兄帮我搞定,分不多可以再给!
不是放在这里的啦
不是放在这里的啦 而是直接放在LIB里
这位老兄能不能讲具体一点!我都是按照网上jboss4.0配置大全步骤配置都不行!总是报javax.naming.NameNotFoundException: MSSQLDS not bound
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
而且,你的驱动程序因该放在/lib下。java.sql.Connection conn=ds.getConnection();
没有制定数据库和密码。
你可以拷贝到 default 下的 lib 目录里.
我的c:\jboss4.0\server\default\lib有msbase.jar,mssqlserver.jar,msutil.jar三个sqlserver2000驱动程序,并且我都是按照网上jboss4.0配置大全步骤配置都不行!总是报javax.naming.NameNotFoundException: MSSQLDS not bound,
是不是jndi绑定数据源有问题,有谁解决此问题我再加100分!谢谢!
我按照网上jboss4.0配置大全步骤配置搞了我的几个通宵,搞技术累拉!因为我在jboss3.12+jdk1.41搞定,现在换为jboss4.0+jdk1.426反而不行了,你能提供jboss4.0与sqlserver2000连接池详细配置步骤吗?谢谢!
2.连接池的配置文件:<datasources>
<local-tx-datasource>
<jndi-name>MSSQLDS</jndi-name>
<connectionurl>jdbc:microsoft:sqlserver://192.168.0.160:1433;DatabaseName=shark</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>..</user-name>
<password></password>
</local-tx-datasource>
</datasources>
3.写连接bean
你的3.写连接bean是不是如下代码:
<%
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:/MSSQLDS");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM titles");
while ( rs.next() ) {
out.println( "a:"+rs.getString("title") + "<br>");
out.println( "b:"+rs.getString("type") + "<br>");}
conn.close();
%>
我按照你的方法试一下,还是报如下提示(你的3.写连接bean):
javax.servlet.ServletException: MSSQLDS not bound
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.jbosspool_jsp._jspService(jbosspool_jsp.java:82)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause javax.naming.NameNotFoundException: MSSQLDS not bound
org.jnp.server.NamingServer.getBinding(NamingServer.java:495)
org.jnp.server.NamingServer.getBinding(NamingServer.java:503)
org.jnp.server.NamingServer.getObject(NamingServer.java:509)
org.jnp.server.NamingServer.lookup(NamingServer.java:282)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:529)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:508)
javax.naming.InitialContext.lookup(InitialContext.java:347)
org.apache.jsp.jbosspool_jsp._jspService(jbosspool_jsp.java:60)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)