大家见过这种报错吗?
这个报错是什么意思?
javax.naming.NamingException: Exception creating DataSource: tyrex/jdbc/xa/EnabledDataSource
我的datasource没配置好?
我的server.xml中的核心代码:
<!-- Tomcat Root Context -->
<Context path="" docBase="ROOT" debug="0" reloadable="true">
<Resource name="jdbc/informixDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/informixDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.informix.jdbc.IfxDriver</value>
</parameter>
<parameter>
<name>url</name> <value>jdbc:informix-sqli://132.**.***.**:****;databaseName=test</value>
</parameter>
<parameter>
<name>username</name>
<value>xyw</value>
</parameter>
<parameter>
<name>password</name>
<value>xyw</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>50</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
配置的连接数据库的类db.java
package install;
import java.io.*;
import java.sql.*;
import javax.naming.*;
import java.util.*;
public class db {
public ResultSet executeQuery(String sql) {
try {
// javax.sql.DataSource ds = null;
Connection conn = null;
Statement stmt = null;
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");//获取连接池对象
Object obj=(Object)envContext.lookup("jdbc/informixDB");//类型转换
javax.sql.DataSource ds=(javax.sql.DataSource)obj;
conn = ds.getConnection();
stmt = conn.createStatement();
ResultSet rs = null;
rs = stmt.executeQuery(sql);
return rs;
}
catch (SQLException e) {
e.printStackTrace();
return null;
}
catch (Exception ex) {
ex.printStackTrace();
return null;
}
}
}