数据库连接的问题
我的代码是这样写的
<Context path= "/gjgl " crossContext= "true " reloadable= "true " docBase= "D:\apache-tomcat-5.5.23\webapps\gjgl " workDir= "D:\apache-tomcat-5.5.23\webapps\gjgl\work ">
<Resource name= "jdbc/gjgl " auth= "Container " type= "javax.sql.DataSource "
maxActive= "100 " maxIdle= "30 " maxWait= "10000 "
username= "root " password= " " driverClassName= "com.mysql.jdbc.Driver "
url= "jdbc:mysql://localhost:3306/gjgl?autoReconnect=true "/>
<Resource name= "jdbc/jsb " auth= "Container " type= "javax.sql.DataSource "
maxActive= "100 " maxIdle= "30 " maxWait= "-1 "
factory= "org.apache.commons.dbcp.BasicDataSourceFactory "
username= "sa " password= " " driverClassName= "com.microsoft.jdbc.sqlserver.SQLServerDriver "
url= "jdbc:microsoft:sqlserver://10.0.0.28:1433;DatabaseName=jsb " />
</Context>
现在的问题是连接不上,出现了错误提示,
服务器端发生错误:Name jdbc is not bound in this Context
错误原因为:javax.naming.NameNotFoundException: Name jdbc is not bound in this Context at org.apache.naming.NamingContext.lookup(NamingContext.java:770) at org.apache.naming.NamingContext.lookup(NamingContext.java:140) at org.apache.naming.NamingContext.lookup(NamingContext.java:781) at org.apache.naming.NamingContext.lookup(NamingContext.java:140) at org.apache.naming.NamingContext.lookup(NamingContext.java:781) at org.apache.naming.NamingContext.lookup
这是两个数据库的连接,一个是MYSQL 一个是SQL2000
[解决办法]
如果你用的是tomcat,可将jdbc驱动拷到common/lib下.