一个连接数据库出错的问题...

badbadjing 2003-10-18 03:18:25

一个连接数据库出错的问题...
编辑时出现如下错误:
Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial

程序如下:
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
public class testsql {
public testsql() {
try{
String ODBCName = "java:comp/env/jdbc/sqlserver";
Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup(ODBCName);
Connection con = ds.getConnection();
Statement sqlStmt = con.createStatement();
}catch (Exception e)
{
System.out.println("" + e.getMessage());
}
}
public static void main(String[] args) {
testsql testsql1 = new testsql();
}
}

...全文

50 12 打赏收藏转发到动态举报

写回复

用AI写文章

12 条回复

切换为时间正序

请发表友善的回复…

发表回复

badbadjing 2003-11-29

打赏
举报

没人会啊？？？？

hoasem 2003-11-26

打赏
举报

badbadjing 2003-11-25

打赏
举报

<Host name="www.test.com" debug="5" appBase="e:\testweb" unpackWARs="true" autoDeploy="true">
<Context path="" docBase="" debug="5" reloadable="true" crossContext="true">
<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" prefix="cust1_access_log." suffix=".txt" pattern="common" resolveHosts="false"/>

<Resource name="jdbc/sqlserver" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/sqlserver">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>

<parameter>
<name>maxActive</name>
<value>30</value>
</parameter>

<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>

<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>test</value>
</parameter>
<parameter>
<name>password</name>
<value>test</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=Test</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=Test</value>
</parameter>

<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>

<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
</ResourceParams>
</Context>
</Host>

badbadjing 2003-11-25

打赏
举报

import java.sql.*;
import javax.sql.*;
import javax.naming.*;
public class testsql {
public testsql() {
try{
String ODBCName = "java:comp/env/jdbc/sqlserver";
Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup(ODBCName);
Connection con = ds.getConnection();
Statement sqlStmt = con.createStatement();
ResultSet rs=sqlstmt.executeQuery("select * from pubt ");
}catch (Exception e)
{
System.out.println("" + e.getMessage());
}
}
public static void main(String[] args) {
testsql testsql1 = new testsql();
}
}

badbadjing 2003-11-12