6.0的要通过改config.xml你可以看看config/examples目录下的config.xml,里面有配置jdbcpool的
你把那些拷到config/mydomain下的config.xml里面,改一改就行了

解决方案 »

  1.   

    里面没有配置oracle数据源的啊,好象只有访问本地的,没有配置网络的,请小溪再指教
      

  2.   

    你可以看看oracle的document嘛,里面有专门讲jdbc的
    象我的设置是这样的
    <JDBCConnectionPool DriverName="oracle.jdbc.driver.OracleDriver"
            Name="myPool"
            Properties="user=cscadm;password=cscadm"
            Targets="myserver" TestConnectionsOnRelease="false"
            TestConnectionsOnReserve="false" TestTableName="" URL="jdbc:oracle:thin:@100.100.100.1:1521:CSCSH"/>
      

  3.   

    还有如果你想加一个DataSource的话,还要加这几句
    <JDBCDataSource JNDIName="myDataSource" Name="myDataSource"
            PoolName="myPool" Targets="myserver"/>
      

  4.   

    非常感谢小溪的耐心指教,不过我照做了之后在jbuilder5里还是出错
    config.xml配置
         
        <JDBCConnectionPool DriverName="oracle.jdbc.driver.OracleDriver"
            Name="myPool"
            Properties="user=1234;password=1234"
            Targets="myserver" TestConnectionsOnRelease="false"
            TestConnectionsOnReserve="false" TestTableName="" URL="jdbc:oracle:thin:@192.168.0.1:1521:oracl"/> 
       
        <JDBCDataSource JNDIName="cxw" Name="cxw"
            PoolName="myPool" Targets="myserver"/> 
        <JTA Name="mydomain"/>调用程序:
      public Dataconn()
           {
             Hashtable ht = new Hashtable();
              ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
              ht.put(Context.PROVIDER_URL,"t3://localhost");
      
              ctx = new InitialContext(ht);
                  GetConn();              }                //连接数据库
         public Connection getConn() throws Exception
           {
                
              if(conn!=null)  return conn;
              javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup ("myPool");
              conn = ds.getConnection();
                    return conn;
           }报如下错误:
       javax.naming.NameNotFoundException: Unable to resolve myPool. Resolved: '' Unresolved:'myPool' ; remaining name '' at weblogic.rmi.internal.AbstractOutboundRequest.sendReceive(AbstractOutboundRequest.java:90) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:247) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:225) at weblogic.jndi.internal.ServerNamingNode_WLStub.lookup(ServerNamingNode_WLStub.java:121) at weblogic.jndi.internal.WLContextImpl.lookup(WLContextImpl.java:323) at javax.naming.InitialContext.lookup(InitialContext.java:350) at Dataconn.Dataconn.getConn(Dataconn.java:57) at Dataconn.Dataconn.selectSql(Dataconn.java:66) at Dataconn.Applet1.paint(Applet1.java:20) at sun.awt.RepaintArea.paint(RepaintArea.java:298) at sun.awt.windows.WComponentPeer.handleEvent(WComponentPeer.java:199) at java.awt.Component.dispatchEventImpl(Component.java:2665) at java.awt.Container.dispatchEventImpl(Container.java:1216) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.EventQueue.dispatchEvent(EventQueue.java:336) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:134) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:96) at java.awt.EventDispatchThread.run(EventDispatchThread.java:88)Exception occurred during event dispatching:java.lang.NullPointerException at Dataconn.Applet1.paint(Applet1.java:24) at sun.awt.RepaintArea.paint(RepaintArea.java:298) at sun.awt.windows.WComponentPeer.handleEvent(WComponentPeer.java:199) at java.awt.Component.dispatchEventImpl(Component.java:2665) at java.awt.Container.dispatchEventImpl(Container.java:1216) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.EventQueue.dispatchEvent(EventQueue.java:336) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:134) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:96) at java.awt.EventDispatchThread.run(EventDispatchThread.java:88)麻烦了!
      

  5.   

    找不到"myPool",很可能是dataSource设置不对为什么要取名为myPool呢,这不和连接池名字一样嘛,改成别的名字再试试
      

  6.   

    你需要在console中设置data source,jndi名称使用建立data source中的jndi名称。
    这样就可以了。
    建议最好使用6.1,6.0的bug太多了!
      

  7.   

    试了多次,又出现
    java.sql.SQLException: weblogic.common.ResourceException: No resources available
    没找到数据源,但我在config.xml里配置了啊,检查了url也没错,不过小酋长说要在console里配置data source,这应该跟在config.xml里配置没区别吧
      

  8.   

    你把oracle的jdbc包加到weblogic的类路径里了吗?
      

  9.   

    我把oracle jdbc放到 bea\wlserver6.0\lib下,原来的问题可能解决了,但是又出现以下错误
    2001-12-7 下午04时21分17秒> <Info> <ConnectionManager> <Bootstrap unable to get a direct: 'Protocol: 't3''connection to: '0S:127.0.0.1:[7001,-1,-1,-1,-1,-1,-1]' on port: '7001'java.rmi.ConnectException: Destination unreachable; nested exception is: 
    java.net.ConnectException: Connection refused: connectjava.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:323) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:136) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:123) at java.net.Socket.<init>(Socket.java:273) at java.net.Socket.<init>(Socket.java:127) at weblogic.rjvm.t3.T3JVMConnection.newSocket(T3JVMConnection.java:324) at weblogic.rjvm.t3.T3JVMConnection.newSocketWithRetry(T3JVMConnection.java:312) at weblogic.rjvm.t3.T3JVMConnection.connect(T3JVMConnection.java:74) at weblogic.rjvm.t3.T3JVMConnection.createConnection(T3JVMConnection.java:148) at weblogic.rjvm.Protocol.createConnection(Protocol.java:201) at weblogic.rjvm.ConnectionManager.findOrCreateConnection(ConnectionManager.java:1077) at weblogic.rjvm.ConnectionManager.bootstrap(ConnectionManager.java:365) at weblogic.rjvm.ConnectionManager.bootstrap(ConnectionManager.java:330) at weblogic.rjvm.RJVMManager.findOrCreateRemoteInternal(RJVMManager.java:228) at weblogic.rjvm.RJVMManager.findOrCreate(RJVMManager.java:188) at weblogic.rjvm.RJVMFinder.findOrCreateRemoteServer(RJVMFinder.java:180) at weblogic.rjvm.RJVMFinder.findOrCreate(RJVMFinder.java:149) at weblogic.rjvm.ServerURL.findOrCreateRJVM(ServerURL.java:207) at weblogic.jndi.WLInitialContextFactoryDelegate.getInitialContext(WLInitialContextFactoryDelegate.java:235) at weblogic.jndi.WLInitialContextFactoryDelegate.getInitialContext(WLInitialContextFactoryDelegate.java:176) at weblogic.jndi.WLInitialContextFactory.getInitialContext(WLInitialContextFactory.java:123) at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:668) at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:246) at javax.naming.InitialContext.init(InitialContext.java:222) at javax.naming.InitialContext.<init>(InitialContext.java:198) at Dataconn.Dataconn.getConn(Dataconn.java:55) at Dataconn.Dataconn.selectSql(Dataconn.java:67) at Dataconn.Applet1.paint(Applet1.java:20) at sun.awt.RepaintArea.paint(RepaintArea.java:298) at sun.awt.windows.WComponentPeer.handleEvent(WComponentPeer.java:199) at java.awt.Component.dispatchEventImpl(Component.java:2665) at java.awt.Container.dispatchEventImpl(Container.java:1216) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.EventQueue.dispatchEvent(EventQueue.java:336) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:134) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:96) at java.awt.EventDispatchThread.run(EventDispatchThread.java:88)> <2001-12-7 下午04时21分17秒> <Info> <ConnectionManager> <Bootstrap unable to get a routed: 'Protocol: 't3'' connection to: '0S:127.0.0.1:[7001,-1,-1,-1,-1,-1,-1]' on port: '7001'java.rmi.ConnectException: No available router to destination at weblogic.rjvm.ConnectionManager.findOrCreateRouter(ConnectionManager.java:1167) at weblogic.rjvm.ConnectionManager.bootstrap(ConnectionManager.java:378) at weblogic.rjvm.ConnectionManager.bootstrap(ConnectionManager.java:330) at weblogic.rjvm.RJVMManager.findOrCreateRemoteInternal(RJVMManager.java:228) at weblogic.rjvm.RJVMManager.findOrCreate(RJVMManager.java:188) at weblogic.rjvm.RJVMFinder.findOrCreateRemoteServer(RJVMFinder.java:180) at weblogic.rjvm.RJVMFinder.findOrCreate(RJVMFinder.java:149) at weblogic.rjvm.ServerURL.findOrCreateRJVM(ServerURL.java:207) at weblogic.jndi.WLInitialContextFactoryDelegate.getInitialContext(WLInitialContextFactoryDelegate.java:235) at weblogic.jndi.WLInitialContextFactoryDelegate.getInitialContext(WLInitialContextFactoryDelegate.java:176) at weblogic.jndi.WLInitialContextFactory.getInitialContext(WLInitialContextFactory.java:123) at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:668) at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:246) at javax.naming.InitialContext.init(InitialContext.java:222) at javax.naming.InitialContext.<init>(InitialContext.java:198) at Dataconn.Dataconn.getConn(Dataconn.java:55) at Dataconn.Dataconn.selectSql(Dataconn.java:67) at Dataconn.Applet1.paint(Applet1.java:20) at sun.awt.RepaintArea.paint(RepaintArea.java:298) at sun.awt.windows.WComponentPeer.handleEvent(WComponentPeer.java:199) at java.awt.Component.dispatchEventImpl(Component.java:2665) at java.awt.Container.dispatchEventImpl(Container.java:1216) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.EventQueue.dispatchEvent(EventQueue.java:336) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:134) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:96) at java.awt.EventDispatchThread.run(EventDispatchThread.java:88)> 出错信息......javax.naming.CommunicationException.  Root exception is java.net.ConnectException: No server found at T3://localhost:7001 at weblogic.rjvm.RJVMFinder.findOrCreate(RJVMFinder.java:155) at weblogic.rjvm.ServerURL.findOrCreateRJVM(ServerURL.java:207) at weblogic.jndi.WLInitialContextFactoryDelegate.getInitialContext(WLInitialContextFactoryDelegate.java:235) at weblogic.jndi.WLInitialContextFactoryDelegate.getInitialContext(WLInitialContextFactoryDelegate.java:176) at weblogic.jndi.WLInitialContextFactory.getInitialContext(WLInitialContextFactory.java:123) at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:668) at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:246) at javax.naming.InitialContext.init(InitialContext.java:222) at javax.naming.InitialContext.<init>(InitialContext.java:198) at Dataconn.Dataconn.getConn(Dataconn.java:55) at Dataconn.Dataconn.selectSql(Dataconn.java:67) at Dataconn.Applet1.paint(Applet1.java:20) at sun.awt.RepaintArea.paint(RepaintArea.java:298) at sun.awt.windows.WComponentPeer.handleEvent(WComponentPeer.java:199) at java.awt.Component.dispatchEventImpl(Component.java:2665) at java.awt.Container.dispatchEventImpl(Container.java:1216) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.EventQueue.dispatchEvent(EventQueue.java:336) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:134) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:96) at java.awt.EventDispatchThread.run(EventDispatchThread.java:88)Exception occurred during event dispatching:java.lang.NullPointerException at Dataconn.Applet1.paint(Applet1.java:24) at sun.awt.RepaintArea.paint(RepaintArea.java:298) at sun.awt.windows.WComponentPeer.handleEvent(WComponentPeer.java:199) at java.awt.Component.dispatchEventImpl(Component.java:2665) at java.awt.Container.dispatchEventImpl(Container.java:1216) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.EventQueue.dispatchEvent(EventQueue.java:336) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:134) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:96) at java.awt.EventDispatchThread.run(EventDispatchThread.java:88)
      

  10.   

    你这样加类路径还是不行的,你最好在lib下建一个比如叫oracle的目录,再把那个文件烤到这个目录下,然后在startWebLogic.cmd里把类路径加进去。还有一点做为参考,我以前把oracle和weblogic都装在一台机器上会出错,装在不同的机器上就没问题了。
      

  11.   

    你能用qq吗?qq里说好了:24668285
      

  12.   

    why not use administrator console to config?BTW:wl6没有必要另加oracle driver,自带