Build an ODS data platform test environment this few days, and the platform can integrate other application systems. Altogether are 8 systems. Platform login using the single sign-on plus platform app. Each time the platform war is launched during deployment, it is reported that a could not get database metadata cannot get the metadata.
Wrong original:
[ -- One- - A: the: -:248CST]00000092SystemOut O .- One- - A: the: -,247[Webcontainer:1]
ERROR o.h.tool.hbm2ddl.schemaupdate Schemaupdate#execute [Schemaupdate.java:175] Could notGetdatabase metadatacom.ibm.db2.jcc.am.SqlSyntaxErrorException:DB2 SQL error:sqlcode=-204, sqlstate=42704, Sqlerrmc=market. All_sequences, driver=3.62. AboutAt com.ibm.db2.jcc.am.fd.a (Fd.java:676) ~[Db2jcc.jar:na] at COM.IBM.DB2.JCC.AM.FD.A (Fd.java: -) ~[Db2jcc.jar:na] at COM.IBM.DB2.JCC.AM.FD.A (Fd.java:127) ~[Db2jcc.jar:na] at COM.IBM.DB2.JCC.AM.JN.C (Jn.java:2614) ~[Db2jcc.jar:na] at COM.IBM.DB2.JCC.AM.JN.D (Jn.java:2602) ~[Db2jcc.jar:na] at Com.ibm.db2.jcc.am.jn.a (Jn.java:2094) ~[Db2jcc.jar:na] at COM.IBM.DB2.JCC.T4.CB.G (Cb.java:141) ~[Db2jcc.jar:na] at COM.IBM.DB2.JCC.T4.CB.A (Cb.java: A) ~[Db2jcc.jar:na] at COM.IBM.DB2.JCC.T4.Q.A (Q.java: +) ~[Db2jcc.jar:na] at COM.IBM.DB2.JCC.T4.RB.I (Rb.java:135) ~[Db2jcc.jar:na] at COM.IBM.DB2.JCC.AM.JN.GB (Jn.java:2064) ~[Db2jcc.jar:na] at Com.ibm.db2.jcc.am.jn.a (Jn.java:3089) ~[Db2jcc.jar:na] at Com.ibm.db2.jcc.am.jn.a (Jn.java:679) ~[Db2jcc.jar:na] at Com.ibm.db2.jcc.am.jn.executeQuery (Jn.java:663) ~[db2jcc.jar:na]
Platform Webinf cfg.db.deploy.properties configuration:
# for db2database.driver=com.ibm.db2.jcc.DB2Driverdatabase.url=jdbc:db2:// 172.16.87.59:50003/appdb:currentschema=market; Database.username=marketdatabase.password=market
Ssocas.properties configuration:
# for db2db.driverclassname=com.ibm.db2.jcc.DB2Driverdb.url=jdbc:db2:// 172.16.87.59:50003/appdb:currentschema=market; #:tracelevel=3;d rivertype=4; currentschema=faldb;db.username=market Db.password=market
According to the above, I am analyzing this.
1, check whether the market users have DB connection and operation Rights, as well as to view the rights of market users;
2. Check that the firewall of the connected DB2 server is closed and the firewall needs to be shut down to connect to the remote database.
3,-204 42704 There is no defined object name, check db2admin this schema, whether there is all_sequences this table;
WebSphere Container initiates JDBC Connection exception, DB2 error:sqlcode=-204, sqlstate=42704, Sqlerrmc=market. All_sequences, driver=3.62.56