各位帮帮看一下这个错误: 在deploy 时说无法找到 oraPool26:E:\weblogic>set PATH=.\bin;F:\Oracle8i\818\bin;F:\Oracle8i\818\Apache\Perl\5.005 03\bin\mswin32-x86;D:\Program Files\Oracle\jre\1.1.7\bin;D:\jdk1.3\bin;e:\Borlan d\AppServer\bin;D:\WINNT\system32;D:\WINNT;D:\WINNT\System32\Wbem;;"g:\query";"g :\query"E:\weblogic>set PATH=E:\weblogic\bin;C:\bea\jdk131\bin;.\bin;F:\Oracle8i\818\bin ;F:\Oracle8i\818\Apache\Perl\5.00503\bin\mswin32-x86;D:\Program Files\Oracle\jre \1.1.7\bin;D:\jdk1.3\bin;e:\Borland\AppServer\bin;D:\WINNT\system32;D:\WINNT;D:WINNT\System32\Wbem;;"g:\query";"g:\query"E:\weblogic>set CLASSPATH=C:\bea\jdk131\lib\tools.jar;E:\weblogic\lib\weblogic_s p.jar;E:\weblogic\lib\weblogic.jar;E:\weblogic\lib\classes12.zip;E:\weblogic\lib \nls_charset12.zipE:\weblogic>echo off CLASSPATH=C:\bea\jdk131\lib\tools.jar;E:\weblogic\lib\weblogic_sp.jar;E:\weblogi c\lib\weblogic.jar;E:\weblogic\lib\classes12.zip;E:\weblogic\lib\nls_charset12.z ip*************************************************** * To start WebLogic Server, use the password * * assigned to the system user. The system * * username and password must also be used to * * access the WebLogic Server console from a web * * browser. * ***************************************************E:\weblogic>"C:\bea\jdk131\bin\java" -hotspot -ms64m -mx64m -classpath C:\bea\jd k131\lib\tools.jar;E:\weblogic\lib\weblogic_sp.jar;E:\weblogic\lib\weblogic.jar; E:\weblogic\lib\classes12.zip;E:\weblogic\lib\nls_charset12.zip -Dweblogic.Domai n=wuyong -Dweblogic.Name=wuyong "-Dbea.home=C:\bea" -Dweblogic.management.passwo rd=microwin -Dweblogic.ProductionModeEnabled=true "-Djava.security.policy==E:\we blogic/lib/weblogic.policy" weblogic.Server Starting WebLogic Server .... <2001-9-18 下午04时18分16秒> <Notice> <Management> <Loading configuration file . \config\wuyong\config.xml ...> <2001-9-18 下午04时18分20秒> <Notice> <WebLogicServer> <Starting WebLogic Admin Server "wuyong" for domain "wuyong"> <2001-9-18 下午04时18分23秒> <Notice> <Management> <Starting discovery of Manage d Server... This feature is on by default, you may turn this off by passing -Dwe blogic.management.discover=false> <2001-9-18 下午04时18分28秒> <Notice> <Management> <Application Poller not start ed for production server.> <2001-9-18 下午04时18分52秒> <Notice> <WebLogicServer> <SSLListenThread listenin g on port 7002> <2001-9-18 下午04时18分52秒> <Notice> <WebLogicServer> <ListenThread listening o n port 7001> <2001-9-18 下午04时18分53秒> <Notice> <WebLogicServer> <Started WebLogic Admin S erver "wuyong" for domain "wuyong" running in Production Mode> <2001-9-18 下午04时19分18秒> <Error> <J2EE> <Error deploying application ora:Unable to deploy EJB: TZbxx from ora.jar:The pool oraPool26 could not be found. Please make sure it is declared in your c onfig.xml.> <2001-9-18 下午04时19分18秒> <Error> <Management> <Error deploying application . \config\wuyong\applications\ora.jar: java.lang.reflect.UndeclaredThrowableExcept ion> config.xml<?xml version="1.0" encoding="UTF-8"?> <!--If your domain is active, please do not edit the config.xml file. Any changes made to that file while the domain is active will not have any effect on the domain's configuration and are likely to be lost. If your domain is inactive, you may edit this file with an XML editor. If you do so, please refer to the BEA Weblogic Server Configuration Reference documentation available from http://edocs.bea.com/wls/docs61/reference.html. In general, we recommend that changes to your configuration file be made through the Administration Console.--> <Domain Name="wuyong"> <Server ListenPort="7001" Name="wuyong" NativeIOEnabled="true" TransactionLogFilePrefix="config/wuyong/logs/"> <ExecuteQueue Name="default" ThreadCount="15"/> <KernelDebug Name="wuyong"/> <SSL Enabled="true" ListenPort="7002" Name="wuyong" ServerCertificateChainFileName="config/wuyong/ca.pem" ServerCertificateFileName="config/wuyong/democert.pem" ServerKeyFileName="config/wuyong/demokey.pem"/> <ServerStart Name="wuyong"/> <WebServer DefaultWebApp="DefaultWebApp" LogFileName="./config/wuyong/logs/access.log" LoggingEnabled="true" Name="wuyong"/> <Log FileName="config/wuyong/logs/weblogic.log" Name="wuyong"/> <ServerDebug Name="wuyong"/> </Server> <FileRealm Name="wl_default_file_realm"/> <CustomRealm ConfigurationData="user.filter=(&(cn=%u)(objectclass=person));user.dn=ou=people, o=example.com;server.principal=cn=admin, o=example.com;membership.filter=(&(member=%M)(objectclass=groupofuniquenames));group.filter=(&(cn=%g)(objectclass=groupofuniquenames));server.host=ldapserver.example.com;server.ssl=true;group.dn=ou=groups, o=example.com" Name="defaultLDAPRealmForNovellDirectoryServices" Notes="This is provided as an example. Before enabling this Realm, you must edit the configuration parameters as appropriate for your environment." Password="{3DES}pXb3iCN2GItJ0tiUV3n+lQ==" RealmClassName="weblogic.security.ldaprealmv2.LDAPRealm"/> <CustomRealm ConfigurationData="user.filter=(&(uid=%u)(objectclass=person));user.dn=ou=people, o=beasys.com;server.principal=uid=admin, ou=Administrators, ou=TopologyManagement, o=NetscapeRoot;membership.filter=(&(uniquemember=%M)(objectclass=groupofuniquenames));group.filter=(&(cn=%g)(objectclass=groupofuniquenames));server.host=ldapserver.example.com;group.dn=ou=groups, o=beasys.com" Name="defaultLDAPRealmForNetscapeDirectoryServer" Notes="This is provided as an example. Before enabling this Realm, you must edit the configuration parameters as appropriate for your environment." Password="{3DES}pXb3iCN2GItJ0tiUV3n+lQ==" RealmClassName="weblogic.security.ldaprealmv2.LDAPRealm"/> <PasswordPolicy Name="wl_default_password_policy"/> <Application Deployed="true" Name="ejbsec" Path=".\config\wuyong\applications"> <EJBComponent Name="ejbsec" URI="ejbsec.jar"/> </Application> <SNMPAgent Name="wuyong"/> <CustomRealm ConfigurationData="user.filter=(&(uid=%u)(objectclass=person));user.dn=ou=people, dc=example, dc=com;server.principal=cn=Manager, dc=example, dc=com;membership.filter=(&(uniquemember=%M)(objectclass=groupofuniquenames));group.filter=(&(cn=%g)(objectclass=groupofuniquenames));server.host=ldapserver.example.com;group.dn=ou=groups, dc=example, c=com" Name="defaultLDAPRealmForOpenLDAPDirectoryServices" Notes="This is provided as an example. Before enabling this Realm, you must edit the configuration parameters as appropriate for your environment." Password="{3DES}pXb3iCN2GItJ0tiUV3n+lQ==" RealmClassName="weblogic.security.ldaprealmv2.LDAPRealm"/> <CustomRealm ConfigurationData="server.host=ldapserver.example.com;membership.scope.depth=1;microsoft.membership.scope=sub;membership.filter=(|(&(memberobject=%M)(objectclass=memberof))(&(groupobject=%M)(objectclass=groupmemberof)));group.dn=ou=Groups, o=ExampleMembershipDir;group.filter=(&(cn=%g)(objectclass=mgroup));server.principal=cn=Administrator, ou=Members, o=ExampleMembershipDir;user.dn=ou=Members, o=ExampleMembershipDir;user.filter=(&(cn=%u)(objectclass=member))" Name="defaultLDAPRealmForMicrosoftSiteServer" Notes="This is provided as an example. Before enabling this Realm, you must edit the configuration parameters as appropriate for your environment." Password="{3DES}pXb3iCN2GItJ0tiUV3n+lQ==" RealmClassName="weblogic.security.ldaprealmv2.LDAPRealm"/> <JTA Name="wuyong"/> <Log FileName="config/wuyong/logs/wl-domain.log" Name="wuyong"/> <Application Deployed="true" Name="certificate" Path=".\config\wuyong\applications"> <WebAppComponent Name="certificate" Targets="wuyong" URI="certificate.war"/> </Application> <Application Deployed="true" Name="sayhello" Path=".\config\wuyong\applications"> <EJBComponent Name="sayhello" Targets="wuyong" URI="sayhello.jar"/> </Application> <Security GuestDisabled="false" Name="wuyong" PasswordPolicy="wl_default_password_policy" Realm="wl_default_realm"/> <Application Deployed="true" Name="bookshop" Path=".\config\wuyong\applications"> <EJBComponent Name="bookshop" URI="bookshop.jar"/> </Application> <JDBCConnectionPool CapacityIncrement="1" DriverName="oracle.jdbc.driver.OracleDriver" Name="oraPool26" Properties="user=stga;password=stga;dll=ocijdbc8;protocol=thin" Targets="wuyong,wuyong" URL="jdbc:oracle:thin:@192.168.1.26:1521:ORA8"/> <Realm FileRealm="wl_default_file_realm" Name="wl_default_realm"/> <JDBCDataSource JNDIName="jdbc.hnisi" Name="stga" PoolName="oraPool26" Targets="wuyong"/> <Application Name="ora" Path=".\config\wuyong\applications"> <EJBComponent Name="ora" URI="ora.jar"/> </Application> <ApplicationManager Name="wuyong"/> <Application Deployed="true" Name="DefaultWebApp" Path=".\config\wuyong\applications"> <WebAppComponent Name="DefaultWebApp" Targets="wuyong" URI="DefaultWebApp"/> </Application> </Domain>
去oracle下载。weblogic的驱动对jdbc2支持的很差注意不要用select * from aa, 要把需要的字段都列出来。此外,要用TYPE_SCROLL_INSENSITIVE;好像TYPE_SCROLL_SENSITIVE也会出问题
weblogic.jdbc20.oci.Driver驱动!
weblogic自己有!
原来那个采用weblogic.jdbc.oci.Driver的连接池却可以正常启动。请问weblogic.jdbc20.oci.Driver的系统配置与weblogic.jdbc.oci.Driver有什么不同??
原来那个采用weblogic.jdbc.oci.Driver的连接池却可以正常启动。请问weblogic.jdbc20.oci.Driver的系统配置与weblogic.jdbc.oci.Driver有什么不同??
Statement stmt = conn.createStatement();
依旧可以使用jdbc2.0的特性!详细见:http://e-docs.bea.com/wls/docs61/oracle/advanced.html#1158515你看看行不行!
在deploy 时说无法找到 oraPool26:E:\weblogic>set PATH=.\bin;F:\Oracle8i\818\bin;F:\Oracle8i\818\Apache\Perl\5.005
03\bin\mswin32-x86;D:\Program Files\Oracle\jre\1.1.7\bin;D:\jdk1.3\bin;e:\Borlan
d\AppServer\bin;D:\WINNT\system32;D:\WINNT;D:\WINNT\System32\Wbem;;"g:\query";"g
:\query"E:\weblogic>set PATH=E:\weblogic\bin;C:\bea\jdk131\bin;.\bin;F:\Oracle8i\818\bin
;F:\Oracle8i\818\Apache\Perl\5.00503\bin\mswin32-x86;D:\Program Files\Oracle\jre
\1.1.7\bin;D:\jdk1.3\bin;e:\Borland\AppServer\bin;D:\WINNT\system32;D:\WINNT;D:WINNT\System32\Wbem;;"g:\query";"g:\query"E:\weblogic>set CLASSPATH=C:\bea\jdk131\lib\tools.jar;E:\weblogic\lib\weblogic_s
p.jar;E:\weblogic\lib\weblogic.jar;E:\weblogic\lib\classes12.zip;E:\weblogic\lib
\nls_charset12.zipE:\weblogic>echo off
CLASSPATH=C:\bea\jdk131\lib\tools.jar;E:\weblogic\lib\weblogic_sp.jar;E:\weblogi
c\lib\weblogic.jar;E:\weblogic\lib\classes12.zip;E:\weblogic\lib\nls_charset12.z
ip***************************************************
* To start WebLogic Server, use the password *
* assigned to the system user. The system *
* username and password must also be used to *
* access the WebLogic Server console from a web *
* browser. *
***************************************************E:\weblogic>"C:\bea\jdk131\bin\java" -hotspot -ms64m -mx64m -classpath C:\bea\jd
k131\lib\tools.jar;E:\weblogic\lib\weblogic_sp.jar;E:\weblogic\lib\weblogic.jar;
E:\weblogic\lib\classes12.zip;E:\weblogic\lib\nls_charset12.zip -Dweblogic.Domai
n=wuyong -Dweblogic.Name=wuyong "-Dbea.home=C:\bea" -Dweblogic.management.passwo
rd=microwin -Dweblogic.ProductionModeEnabled=true "-Djava.security.policy==E:\we
blogic/lib/weblogic.policy" weblogic.Server
Starting WebLogic Server ....
<2001-9-18 下午04时18分16秒> <Notice> <Management> <Loading configuration file .
\config\wuyong\config.xml ...>
<2001-9-18 下午04时18分20秒> <Notice> <WebLogicServer> <Starting WebLogic Admin
Server "wuyong" for domain "wuyong">
<2001-9-18 下午04时18分23秒> <Notice> <Management> <Starting discovery of Manage
d Server... This feature is on by default, you may turn this off by passing -Dwe
blogic.management.discover=false>
<2001-9-18 下午04时18分28秒> <Notice> <Management> <Application Poller not start
ed for production server.>
<2001-9-18 下午04时18分52秒> <Notice> <WebLogicServer> <SSLListenThread listenin
g on port 7002>
<2001-9-18 下午04时18分52秒> <Notice> <WebLogicServer> <ListenThread listening o
n port 7001>
<2001-9-18 下午04时18分53秒> <Notice> <WebLogicServer> <Started WebLogic Admin S
erver "wuyong" for domain "wuyong" running in Production Mode>
<2001-9-18 下午04时19分18秒> <Error> <J2EE> <Error deploying application ora:Unable to deploy EJB: TZbxx from ora.jar:The pool oraPool26 could not be found. Please make sure it is declared in your c
onfig.xml.>
<2001-9-18 下午04时19分18秒> <Error> <Management> <Error deploying application .
\config\wuyong\applications\ora.jar: java.lang.reflect.UndeclaredThrowableExcept
ion>
config.xml<?xml version="1.0" encoding="UTF-8"?>
<!--If your domain is active, please do not edit the config.xml file. Any changes made to that file while the domain is active will not have any effect on the domain's configuration and are likely to be lost. If your domain is inactive, you may edit this file with an XML editor. If you do so, please refer to the BEA Weblogic Server Configuration Reference documentation available from http://edocs.bea.com/wls/docs61/reference.html. In general, we recommend that changes to your configuration file be made through the Administration Console.-->
<Domain Name="wuyong">
<Server ListenPort="7001" Name="wuyong" NativeIOEnabled="true" TransactionLogFilePrefix="config/wuyong/logs/">
<ExecuteQueue Name="default" ThreadCount="15"/>
<KernelDebug Name="wuyong"/>
<SSL Enabled="true" ListenPort="7002" Name="wuyong"
ServerCertificateChainFileName="config/wuyong/ca.pem"
ServerCertificateFileName="config/wuyong/democert.pem" ServerKeyFileName="config/wuyong/demokey.pem"/>
<ServerStart Name="wuyong"/>
<WebServer DefaultWebApp="DefaultWebApp"
LogFileName="./config/wuyong/logs/access.log"
LoggingEnabled="true" Name="wuyong"/>
<Log FileName="config/wuyong/logs/weblogic.log" Name="wuyong"/>
<ServerDebug Name="wuyong"/>
</Server>
<FileRealm Name="wl_default_file_realm"/>
<CustomRealm
ConfigurationData="user.filter=(&(cn=%u)(objectclass=person));user.dn=ou=people, o=example.com;server.principal=cn=admin, o=example.com;membership.filter=(&(member=%M)(objectclass=groupofuniquenames));group.filter=(&(cn=%g)(objectclass=groupofuniquenames));server.host=ldapserver.example.com;server.ssl=true;group.dn=ou=groups, o=example.com"
Name="defaultLDAPRealmForNovellDirectoryServices"
Notes="This is provided as an example. Before enabling this Realm, you must edit the configuration parameters as appropriate for your environment."
Password="{3DES}pXb3iCN2GItJ0tiUV3n+lQ==" RealmClassName="weblogic.security.ldaprealmv2.LDAPRealm"/>
<CustomRealm
ConfigurationData="user.filter=(&(uid=%u)(objectclass=person));user.dn=ou=people, o=beasys.com;server.principal=uid=admin, ou=Administrators, ou=TopologyManagement, o=NetscapeRoot;membership.filter=(&(uniquemember=%M)(objectclass=groupofuniquenames));group.filter=(&(cn=%g)(objectclass=groupofuniquenames));server.host=ldapserver.example.com;group.dn=ou=groups, o=beasys.com"
Name="defaultLDAPRealmForNetscapeDirectoryServer"
Notes="This is provided as an example. Before enabling this Realm, you must edit the configuration parameters as appropriate for your environment."
Password="{3DES}pXb3iCN2GItJ0tiUV3n+lQ==" RealmClassName="weblogic.security.ldaprealmv2.LDAPRealm"/>
<PasswordPolicy Name="wl_default_password_policy"/>
<Application Deployed="true" Name="ejbsec" Path=".\config\wuyong\applications">
<EJBComponent Name="ejbsec" URI="ejbsec.jar"/>
</Application>
<SNMPAgent Name="wuyong"/>
<CustomRealm
ConfigurationData="user.filter=(&(uid=%u)(objectclass=person));user.dn=ou=people, dc=example, dc=com;server.principal=cn=Manager, dc=example, dc=com;membership.filter=(&(uniquemember=%M)(objectclass=groupofuniquenames));group.filter=(&(cn=%g)(objectclass=groupofuniquenames));server.host=ldapserver.example.com;group.dn=ou=groups, dc=example, c=com"
Name="defaultLDAPRealmForOpenLDAPDirectoryServices"
Notes="This is provided as an example. Before enabling this Realm, you must edit the configuration parameters as appropriate for your environment."
Password="{3DES}pXb3iCN2GItJ0tiUV3n+lQ==" RealmClassName="weblogic.security.ldaprealmv2.LDAPRealm"/>
<CustomRealm
ConfigurationData="server.host=ldapserver.example.com;membership.scope.depth=1;microsoft.membership.scope=sub;membership.filter=(|(&(memberobject=%M)(objectclass=memberof))(&(groupobject=%M)(objectclass=groupmemberof)));group.dn=ou=Groups, o=ExampleMembershipDir;group.filter=(&(cn=%g)(objectclass=mgroup));server.principal=cn=Administrator, ou=Members, o=ExampleMembershipDir;user.dn=ou=Members, o=ExampleMembershipDir;user.filter=(&(cn=%u)(objectclass=member))"
Name="defaultLDAPRealmForMicrosoftSiteServer"
Notes="This is provided as an example. Before enabling this Realm, you must edit the configuration parameters as appropriate for your environment."
Password="{3DES}pXb3iCN2GItJ0tiUV3n+lQ==" RealmClassName="weblogic.security.ldaprealmv2.LDAPRealm"/>
<JTA Name="wuyong"/>
<Log FileName="config/wuyong/logs/wl-domain.log" Name="wuyong"/>
<Application Deployed="true" Name="certificate" Path=".\config\wuyong\applications">
<WebAppComponent Name="certificate" Targets="wuyong" URI="certificate.war"/>
</Application>
<Application Deployed="true" Name="sayhello" Path=".\config\wuyong\applications">
<EJBComponent Name="sayhello" Targets="wuyong" URI="sayhello.jar"/>
</Application>
<Security GuestDisabled="false" Name="wuyong"
PasswordPolicy="wl_default_password_policy" Realm="wl_default_realm"/>
<Application Deployed="true" Name="bookshop" Path=".\config\wuyong\applications">
<EJBComponent Name="bookshop" URI="bookshop.jar"/>
</Application>
<JDBCConnectionPool CapacityIncrement="1"
DriverName="oracle.jdbc.driver.OracleDriver" Name="oraPool26"
Properties="user=stga;password=stga;dll=ocijdbc8;protocol=thin"
Targets="wuyong,wuyong" URL="jdbc:oracle:thin:@192.168.1.26:1521:ORA8"/>
<Realm FileRealm="wl_default_file_realm" Name="wl_default_realm"/>
<JDBCDataSource JNDIName="jdbc.hnisi" Name="stga"
PoolName="oraPool26" Targets="wuyong"/>
<Application Name="ora" Path=".\config\wuyong\applications">
<EJBComponent Name="ora" URI="ora.jar"/>
</Application>
<ApplicationManager Name="wuyong"/>
<Application Deployed="true" Name="DefaultWebApp" Path=".\config\wuyong\applications">
<WebAppComponent Name="DefaultWebApp" Targets="wuyong" URI="DefaultWebApp"/>
</Application>
</Domain>
我的连接池设置如下:
url:jdbc:oracle:oci8:@orasrv
Driver Classname:oracle.jdbc.driver.OracleDriver连接语句:
myDriver = (Driver) Class.forName("weblogic.jdbc.pool.Driver").newInstance();
conn = myDriver.connect("jdbc:weblogic:pool:OraclePool", null);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);