高手请解决WebSphere启动时报创建数据源失败,谢谢
开发环境:xp系统,tomcat5.5,jdk1.5,MyEclipse6.6,DB2V9.1
生产环境:AIX5.3,WebSphere6.1,jdk1.5,DB2V9.1
项目是SSH架构,在开发环境上运行一切正常,但发布到生产环境上却报创建数据源错误,异常如下:
[3/26/10 17:06:54:450 GMT+08:00] 000000ba SystemOut O - Building new Hibernate SessionFactory
[3/26/10 17:06:55:184 GMT+08:00] 000000ba SystemOut O - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
[3/26/10 17:06:55:322 GMT+08:00] 000000ba SystemOut O - Destroying singletons in factory {org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [CommunicateDataSource,CommunicateSessionFactory,CommunicateTransactionManager,CommunicateBaseTxProxy,mobileBankSessionFactory,mobileBankTransactionManager,mobileBankbaseTxProxy,_getdicnamedao,_getdicnameservice,getDicName,_fmuserdao,_fmuserservice,fmmgr,_fmuserroledao,_fmuserroleservice,fmmgrrole,_fmmenubuttondao,_fmmenubuttonservice,fmbservice,_fmaddmenubuttondao,_fmaddmenubuttonservice,fmaddmenubuttonservice,_userinfodao,_userinfoservice,userinfo,_msgcountdao,_msgcountservice,msgcount,_useraccountdao,_useraccountservice,useraccount,_userbilldao,_userbillservice,userbill,_ffuncchgrecdao,_ffuncChgRecService,ffuncChgRecService,_jgmcombine,_jgmCombineSerivce,jgmCombineService,_operoffinfo,_operOffInfoService,operOffInfoService,_fcwksqkinfosdao,_fcwksqkInfosService,fcwksqkinfosService,_fcwksqrecdao,_fcwksqrecservice,fcwksqRecService,_facctchgrecdao,_facctChgRecService,facctchgrecservice,_facctverifydao,_facctVerifyService,facctverifyservice,_fpwdwrgrecdao,_fpwdWrgRecService,fpwdwrgrecservice,_frptlostrecdao,_frptlostrecservice,frptlostrec,_finqdao,_finqservice,finq,_transumdao,_transumservice,transum,_transerrordao,_transerrorservice,transerror,_systranserrordao,_systranserrorservice,systranserror,_fmdicdao,_fmdicservice,fmdic,_sysversionupdatedao,_sysversionupdateservice,sysversionupdate,_userctldao,_userctlservice,userctl,_translogdao,_translogservice,translog,_transinfodao,_transinfoservice,transinfo,_transinfodoubtdao,_transinfodoubtservice,transinfodoubt,_fbilltypeopenquerydao,_billopenqueryservice,fbilltypeopenquery,_loanrecdao,_loanrecservice,loanrec,_fdktzdao,_fDKTZService,fdktz,_loancheckdao,_loancheckservice,loancheck,_loancheckhstdao,_loancheckhstservice,loancheckhst,_chargerecdao,_chargerecservice,chargerec,_fmlogdao,_fmlogservice,fmlog,_transloghstdao,_transloghstservice,transloghst,_transinfohstdao,_transinfohstservice,transinfohst,_loanrechstdao,_loanrechstservice,loanrechst,_chargerechstdao,_chargerechstservice,chargerechst,_finqhstdao,_finqhstservice,finqhst,_fmbchgrecdao,_fmbchgrecservice,fmbchgrec,_fpwdchgrecdao,_fpwdchgrecservice,fpwdchgrec,_chargereportdao,_chargereportservice,chargereport,_transamtorderreportdao,_transamtorderreportservice,transamtorderreport,_transFeeReportDao,_transFeeReportService,transFeeReport,_transcntorderreportdao,_transcntorderreportservice,transcntorderreport,_transinforeportdao,_transinforeportservice,transinforeport,_usercntreportdao,_usercntreportservice,usercntreport,_fklreportdao,_fklreportservice,fklreport,_jgmctldao,_jgmctlservice,jgmctl,_mobilebankexpdatadao,_mobilebankexpdataservice,mobilebankexpdata,_syspwhdao,_syspwhservice,syspwh,_syspwhdeptdao,_syspwhdeptservice,syspwhdept,_sysparadevelopdao,_sysparadevelopservice,sysparadevelop,_mobileregdao,_mobileregservice,mobilereg,_fchargesetquerydao,_fchargesetqueryservice,fchargesetquery,_fbilltypedao,_fbilltypeservice,fbilltype,_fholidaydao,_fholidayservice,fholiday,_ftranstypedao,_ftransTypeservice,ftranstype,_fblacklistdao,_fblackListservice,fblacklist,_ffunctypedao,_ffuncTypeservice,ffunctype,_fbanfuncdao,_fbanFuncservice,fbanfunc,_lostrecdao,_lostrecservice,lostrec,_smsmbnumdao,_smsmbnumservice,smsmbnum,_ftypedao,_ftypeservice,ffunctypeservice,_fmauthdao,_fmauthservice,fmauthservice,_fhmhbdzdao,_fhmhbdzservice,fhmhbdz,_fstdparadeptdao,_fstdparadeptservice,fstdparadeptservice,_ffuncdeptdetaildao,_ffuncdeptdetailservice,ffuncdeptdetailservice,_ywsendinfodao,_ywsendinfoservice,ywsendinfo,_alltransdao,_alltransservice,alltrans,_realtimelinemonitordao,_realtimelinemonitorservice,realtimelinemonitor,_makecardkeydao,_makecardkeyservice,makecardkey,_fdivpercentdao,_fdivpercentservice,fdivpercentService,_sysmsyspwhdeptdao,_sysmsyspwhdeptservice,sysmsyspwhdept,_fchargeschemedao,_fchargeschemeservice,fchargescheme,_ftransfeesetdao,_ftransfeesetservice,ftransfeesetservice,_fempcardnumberdao,_fempcardnumberservice,fempcardnumber,_favoruableDao,_favoruableService,favoruable,_cardFavoruableDao,_cardfavoruableService,cardfavoruable,CommunicateLoginDao,CommunicateLoginService,CommunicateLogin,_smslogdao,_smsuserdao,MobileBankLoginDao,MobileBankLoginService,MobileBankLogin,MobileBankLogoutService,MobileBankLogout,CommunicateLogoutService,CommunicateLogout,_smsstaysenddao,_smsstaysendservice,smsstaysend,_smsalreadysenddao,_smsalreadysendservice,smsalreadysend,_smsrespdao,_smsrespservice,smsresp,_smsuserservice,smsuser,_sendinfodao,_sendinfoservice,sendinfo,_smslogservice,smslog,_communicateexpdatadao,_communicateexpdataservice,communicateexpdata,_smsalreadysendhstdao,_smsalreadysendhstservice,smsalreadysendhst,_smsresphstdao,_smsresphstservice,smsresphst]; root of BeanFactory hierarchy}
[3/26/10 17:06:55:556 GMT+08:00] 000000ba SystemOut O - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'CommunicateSessionFactory' defined in ServletContext resource [/WEB-INF/config/applicationContext.xml]: Initialization of bean failed; nested exception is java.lang.VerifyError: class loading constraint violated (class: com/ibm/db2/jcc/b/bb method: prepareSQLJStatement(Ljava/lang/String;ILcom/ibm/db2/jcc/SQLJSection;Lcom/ibm/db2/jcc/SQLJColumnMetaData;Lcom/ibm/db2/jcc/SQLJColumnMetaData;ZZIIII)Lcom/ibm/db2/jcc/SQLJPreparedStatement;) at pc: 0
java.lang.VerifyError: class loading constraint violated (class: com/ibm/db2/jcc/b/bb method: prepareSQLJStatement(Ljava/lang/String;ILcom/ibm/db2/jcc/SQLJSection;Lcom/ibm/db2/jcc/SQLJColumnMetaData;Lcom/ibm/db2/jcc/SQLJColumnMetaData;ZZIIII)Lcom/ibm/db2/jcc/SQLJPreparedStatement;) at pc: 0
at java.lang.J9VMInternals.verifyImpl(Native Method)
at java.lang.J9VMInternals.verify(J9VMInternals.java:59)
at java.lang.J9VMInternals.verify(J9VMInternals.java:57)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:120)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:166)
at java.sql.DriverManager.getConnection(DriverManager.java:562)
at java.sql.DriverManager.getConnection(DriverManager.java:155)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:277)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:241)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
[解决办法]
一直没有看你配置文件,Tomcat下连接数据库和WebSphere下连接数据库的方式是不一样的,在WebSphere下,你需要建一个叫JNDI,指向相应的数据库,这些配置工作可以通过登录WebSphere控制台来做