RAD 链接数据库
我的java应用程序为
package com;
import java.sql.Connection;
import java.util.Hashtable;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class conn {
public static void main(String[] args) throws Exception {
InitialContext initialContext = getInitialContext();
javax.sql.DataSource ds = (DataSource)initialContext.lookup("jdbc/msSql");
Connection cn = ds.getConnection("sa","uoon");
if(cn != null)
System.out.println ("Connection ok");
}
public static InitialContext getInitialContext() throws NamingException {
Hashtable env = new Hashtable();
env.put(Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
env.put(Context.PROVIDER_URL,"iiop://localhost:2809"); //iiop是协议
InitialContext context = new InitialContext(env);
return context;
}
}
web.xml代码为
<resource-ref id="ResourceRef_1242548482171">
<description>
</description>
<res-ref-name>WebSphere embedded ConnectJDBC for SQL Server DataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
ibm-web-bnd.xmi代码为
<?xml version="1.0" encoding="UTF-8"?>
<webappbnd:WebAppBinding xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:webappbnd="webappbnd.xmi" xmi:id="WebAppBinding_1242542052640" virtualHostName="default_host">
<webapp href="WEB-INF/web.xml#WebApp_ID"/>
<resRefBindings xmi:id="ResourceRefBinding_1242548482171" jndiName="jdbc/msSql">
<bindingResourceRef href="WEB-INF/web.xml#ResourceRef_1242548482171"/>
</resRefBindings>
</webappbnd:WebAppBinding>
我在webShere6.1的服务器数据源test链接
成功 jndi名字为jdbc/msSql
可是依然报异常,死活链接数据库失败!
2009-5-18 7:50:12 com.ibm.ws.util.ImplFactory
WARNING: WSVR0073W
Exception in thread "P=211562:O=0:CT" javax.naming.NamingException: Failed to initialize the ORB [Root exception is org.omg.CORBA.INITIALIZE: Unable to init plugins vmcid: IBM minor code: 504 completed: No]
at com.ibm.ws.naming.util.Helpers.getOrb(Helpers.java:318)
at com.ibm.ws.naming.util.WsnInitCtxFactory.getInitialContextInternal(WsnInitCtxFactory.java:392)
at com.ibm.ws.naming.util.WsnInitCtx.getContext(WsnInitCtx.java:117)
at com.ibm.ws.naming.util.WsnInitCtx.getContextIfNull(WsnInitCtx.java:712)
at com.ibm.ws.naming.util.WsnInitCtx.lookup(WsnInitCtx.java:171)
at javax.naming.InitialContext.lookup(InitialContext.java:363)
at com.conn.main(conn.java:18)
Caused by: org.omg.CORBA.INITIALIZE: Unable to init plugins vmcid: IBM minor code: 504 completed: No
at com.ibm.rmi.corba.PluginRegistry.initPlugin(PluginRegistry.java:229)
at com.ibm.rmi.corba.PluginRegistry.initPlugins(PluginRegistry.java:210)
at com.ibm.rmi.corba.PluginRegistry.initPlugins(PluginRegistry.java:216)
at com.ibm.rmi.corba.ORB.initializePlugins(ORB.java:571)
at com.ibm.rmi.corba.ORB.orbParameters(ORB.java:1319)
at com.ibm.rmi.corba.ORB.set_parameters(ORB.java:1206)
at com.ibm.CORBA.iiop.ORB.set_parameters(ORB.java:1662)
at org.omg.CORBA.ORB.init(ORB.java:364)
at com.ibm.ws.orb.GlobalORBFactory.init(GlobalORBFactory.java:86)
at com.ibm.ejs.oa.EJSORBImpl.initializeORB(EJSORBImpl.java:179)
at com.ibm.ejs.oa.EJSClientORBImpl.<init>(EJSClientORBImpl.java:83)
at com.ibm.ejs.oa.EJSClientORBImpl.<init>(EJSClientORBImpl.java:59)
at com.ibm.ejs.oa.EJSORB.init(EJSORB.java:102)
at com.ibm.ws.naming.util.Helpers.getOrb(Helpers.java:309)
... 6 more
Caused by: java.lang.NoClassDefFoundError: Invalid Implementation Key, com.ibm.CORBA.iiop.WLMPlugin
at com.ibm.ws.util.ImplFactory.loadClassFromKey(ImplFactory.java:363)
at com.ibm.ws.util.ImplFactory.loadClassFromKey(ImplFactory.java:354)
at com.ibm.ws.wlm.Factory$2.run(Factory.java:98)
at java.security.AccessController.doPrivileged(AccessController.java:241)
at com.ibm.ws.wlm.Factory.loadClass(Factory.java:96)
at com.ibm.ws.wlm.client.WLMClient.init(WLMClient.java:130)
at com.ibm.rmi.corba.PluginRegistry.initPlugin(PluginRegistry.java:224)
... 19 more