使用SAP BO系统CMC(中央管理控制)平台新建OLAP连接问题

我根据《SAP BusinessObjects Analysis(OLAP版)管理员指南》里边的指导步骤进行设置,成功安装了ODBC驱动程序,创建了Oracle OLAP驱动程序数据源名称(DSN),使用tomcat安装了oracle olap数据提供者并进行了相关文件的配置,也按照指南进行测试Web、XMLA服务,测试都成功。然后登陆中央管理控制台的OLAP连接部分,进行新建OLAP连接。
将相关信息与服务器信息填写后,在点击连接到服务器以选择多维数据集的连接按钮后,弹出小窗口需要填写登陆到数据源用户名和密码,于是按照之前创建的Oracle OLAP驱动程序数据源名称中的信息来登陆,但出现红色警告信息,“ 未能使用会话区域设置[Chinese(China)]为连接[http:localhost:8080/M4OxmlaWebServices/services/XmlaWebService]获取连接 。”请连接相关内容的人员帮我指导一下,问题是可能出现在哪里?

1个回答

新建OLAP的文档可不可以给分享一份,我试试

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
linux上导入1个G的dmp,导出来只有不到5M
在centos7的oracle上创建新用户后,导入了一个1G多的dmp文件,再将这个用户导出时只有几个M ``` [oracle@oracle-test ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK[oracle@oracle-test ~]$ exp isc/isc@192.168.157.132:1521/orcl file=/disk3/expisc/tisc.dmp owner=isc Export: Release 11.2.0.1.0 - Production on Tue Jan 14 12:36:23 2020 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user ISC . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user ISC About to export ISC's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export ISC's tables via Conventional Path ... . . exporting table HR_ORG_BASIC_INFO 0 rows exported . . exporting table HR_ORG_BASIC_INFO_TEMP 0 rows exported . . exporting table HR_POST_BASIC_INFO 0 rows exported . . exporting table HR_USER_BASIC_INFO 0 rows exported . . exporting table ISC_ACCOUNT 4 rows exported . . exporting table ISC_ACCOUNT_EXT_PROP 0 rows exported . . exporting table ISC_ACTOR_ROLE_R 4362 rows exported . . exporting table ISC_APPLICATION 3 rows exported . . exporting table ISC_APPSHOW_CONF 1 rows exported . . exporting table ISC_APP_CODE_CONF 0 rows exported . . exporting table ISC_APP_CODE_FIELD_EXT 0 rows exported . . exporting table ISC_APP_DATARESOUCE_R 3 rows exported . . exporting table ISC_AUTHORIZE_COMMIT 0 rows exported . . exporting table ISC_BASEORG 8801 rows exported . . exporting table ISC_BASEORG_EXT_PROP 0 rows exported . . exporting table ISC_BASEORG_SPORG_UNIT_R 0 rows exported . . exporting table ISC_COMMON_CONST 196 rows exported . . exporting table ISC_DEPLOY 2 rows exported . . exporting table ISC_DIM 0 rows exported . . exporting table ISC_DUTY 0 rows exported . . exporting table ISC_LOGIN_LOCK 36 rows exported . . exporting table ISC_MAIL_CONF 0 rows exported . . exporting table ISC_MAIL_TEMPLATE_CONF 0 rows exported . . exporting table ISC_MDMORG_SPORG_UNIT_R 0 rows exported . . exporting table ISC_MDM_ORG 0 rows exported . . exporting table ISC_MSG_RESOURCE 0 rows exported . . exporting table ISC_NODE 3 rows exported . . exporting table ISC_NODE_DEPLOY_R 2 rows exported . . exporting table ISC_ORG_ATTRIBUTE 11 rows exported . . exporting table ISC_ORG_SYS_DIM_R 0 rows exported . . exporting table ISC_ORG_UNIT_DIM_R 0 rows exported . . exporting table ISC_RESOURCE 642 rows exported . . exporting table ISC_RESOURCE_EXT_PROPERTY 172 rows exported . . exporting table ISC_RESOURCE_EXT_PROPERTY_ETL 0 rows exported . . exporting table ISC_RESOURCE_TYPE 15 rows exported . . exporting table ISC_RESOURC_TYPE_APPLICATION_R 0 rows exported . . exporting table ISC_RES_EXT_VALUE 3230 rows exported . . exporting table ISC_RES_RES_R 638 rows exported . . exporting table ISC_ROLEGROUP 8 rows exported . . exporting table ISC_ROLE_LAYER_BY_ORG 67 rows exported . . exporting table ISC_ROLE_RES_R 2947 rows exported . . exporting table ISC_SECURE_CONF 2 rows exported . . exporting table ISC_SPECIALORG_UNIT 9 rows exported . . exporting table ISC_SPECIALORG_UNIT_BAK 0 rows exported . . exporting table ISC_SPORG_EXTPROP 0 rows exported . . exporting table ISC_SPORG_EXTPROPVAL 0 rows exported . . exporting table ISC_SPORG_EXTPROP_ATTR_R 0 rows exported . . exporting table ISC_SPROLE 81 rows exported . . exporting table ISC_SPROLE_EXT 0 rows exported . . exporting table ISC_SPROLE_EXT_VALUE 0 rows exported . . exporting table ISC_SPROLE_R 0 rows exported . . exporting table ISC_SP_DOMAIN 3 rows exported . . exporting table ISC_SP_DOMAIN_CODE_RELATION 15 rows exported . . exporting table ISC_SP_ORG_SYSTEM 3 rows exported . . exporting table ISC_STRATEGY_BASEORG_R 0 rows exported . . exporting table ISC_STRATEGY_CONF 0 rows exported . . exporting table ISC_STRATEGY_SESSION 0 rows exported . . exporting table ISC_STRATEGY_USER 0 rows exported . . exporting table ISC_SYNC_LOG 0 rows exported . . exporting table ISC_SYNC_PROCESS 0 rows exported . . exporting table ISC_SYSTEM_START_CONFIG 1 rows exported . . exporting table ISC_TEMP_ACTOR_ROLE_TBL 0 rows exported . . exporting table ISC_TEMP_USER 0 rows exported . . exporting table ISC_TEMP_USER_TBL 0 rows exported . . exporting table ISC_UNIT 27 rows exported . . exporting table ISC_USER 1947 rows exported . . exporting table ISC_USER_CFCA_CONN 0 rows exported . . exporting table ISC_USER_DUTY 0 rows exported . . exporting table ISC_USER_EXT 0 rows exported . . exporting table ISC_USER_EXT_PROPERTY 0 rows exported . . exporting table ISC_USER_EXT_PROP_ERP 0 rows exported . . exporting table ISC_USER_EXT_PROP_VALUE_ERP 0 rows exported . . exporting table ISC_USER_PASSWORDUSEFULDAY 54 rows exported . . exporting table ISC_USER_PASSWORD_REPETITIONS 20 rows exported . . exporting table ISC_USER_SPORG 1557 rows exported . . exporting table ISC_WO_ACCOUNTAPPLY 0 rows exported . . exporting table ISC_WO_ACCOUNT_CHANGE 0 rows exported . . exporting table ISC_WO_APPCONF_CHANGE 0 rows exported . . exporting table ISC_WO_APPROVAL_COMMENTS 0 rows exported . . exporting table ISC_WO_APP_REGISTER 0 rows exported . . exporting table ISC_WO_ORDER 0 rows exported . . exporting table ISC_WO_ROLELIST 0 rows exported . . exporting table ISC_WO_ROLES 0 rows exported . . exporting table OPERATE_OBJ 81 rows exported . . exporting table OPERATE_TYPE 419 rows exported . . exporting table RESOURCE_DEFAULT_PROPERTY 43 rows exported . . exporting table SAS_REPORT_FILES_LOG 0 rows exported . . exporting table SAS_STANDARD_DB_LOG_201301 0 rows exported . . exporting table SAS_STANDARD_LOG_TYPE 5 rows exported . . exporting table SAS_STATISTICAL_RULES 0 rows exported . . exporting table SAS_STATISTICS_DAY_LOGIN_COUNT 44 rows exported . . exporting table SAS_STATISTICS_DAY_LOGIN_USERS 53 rows exported . . exporting table SAS_STATISTICS_SP_VISIT_COUNT 1 rows exported . . exporting table USER_VERIFY 6 rows exported . exporting synonyms . exporting views . exporting stored procedures . exporting operators . exporting referential integrity constraints . exporting triggers . exporting indextypes . exporting bitmap, functional and extensible indexes . exporting posttables actions . exporting materialized views . exporting snapshot logs . exporting job queues . exporting refresh groups and children . exporting dimensions . exporting post-schema procedural objects and actions . exporting statistics Export terminated successfully without warnings. ``` 请问为什么会这样子?
连接bw系统olap4j无法设置参数
使用Olap4j(比较慢,求推荐好用的olap连接工具)连接sap的BW系统查找数据,单使用mdx语句会报参数未设置错误。 用fidler捕捉request发现parameter并未设置: ``` <?xml version="1.0" encoding="UTF-8"?> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <soapenv:Body> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"> <Command> <Statement> <![CDATA[ SELECT NON EMPTY { [0SALES_DIST__0CUST_GRP2].[LEVEL01].Members } ON COLUMNS, NON EMPTY { [0CALMONTH].[LEVEL01].Members } ON ROWS FROM [ZQD_C28/ZQD_C28_Q0001] WHERE [0CALMONTH].[201503]]]> </Statement> </Command> <Properties> <PropertyList> <Catalog>ZBF_C51</Catalog> <DataSourceInfo>SAP_BW</DataSourceInfo> <Format>Multidimensional</Format> <AxisFormat>TupleFormat</AxisFormat> </PropertyList> </Properties> <Parameters> <Parameter> </Parameter> </Parameters></Execute> </soapenv:Body> </soapenv:Envelope> ``` 用OLAP4J怎样设置参数?
oracle自动关闭服务,然后手动stratup启动,又能正常使用!
Thu Dec 05 09:37:05 2019 System state dump requested by (instance=1, osid=44223 (DBW0)), summary=[abnormal instance termination]. System State dumped to trace file /oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_44215_20191205093705.trc Instance terminated by DBW0, pid = 44223 Thu Dec 05 09:47:25 2019 Adjusting the default value of parameter parallel_max_servers from 320 to 120 due to the value of parameter processes (150) Starting ORACLE instance (normal) ************************ Large Pages Information ******************* Per process system memlock (soft) limit = 64 KB Total Shared Global Region in Large Pages = 0 KB (0%) Large Pages used by this instance: 0 (0 KB) Large Pages unused system wide = 0 (0 KB) Large Pages configured system wide = 0 (0 KB) Large Page size = 2048 KB RECOMMENDATION: Total System Global Area size is 9634 MB. For optimal performance, prior to the next instance restart: 1. Increase the number of unused large pages by at least 4817 (page size 2048 KB, total size 9634 MB) system wide to get 100% of the System Global Area allocated with large pages 2. Large pages are automatically locked into physical memory. Increase the per process memlock (soft) limit to at least 9642 MB to lock 100% System Global Area's large pages into physical memory ******************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 8 Number of processor cores in the system is 8 Number of processor sockets in the system is 1 CELL communication is configured to use 0 interface(s): CELL IP affinity details: NUMA status: non-NUMA system cellaffinity.ora status: N/A CELL communication will use 1 IP group(s): Grp 0: Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =27 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1 System name: Linux Node name: easdatabase Release: 2.6.32-642.el6.x86_64 Version: #1 SMP Tue May 10 17:27:01 UTC 2016 Machine: x86_64 Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora System parameters with non-default values: processes = 150 sga_target = 9632M control_files = "/oracle/app/oracle/oradata/orcl/control01.ctl" control_files = "/oracle/app/oracle/fast_recovery_area/orcl/control02.ctl" db_block_size = 8192 compatible = "11.2.0.4.0" log_archive_dest_1 = "location=/mnt1/archivelog" db_recovery_file_dest = "/oracle/app/oracle/fast_recovery_area" db_recovery_file_dest_size= 35G undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "/oracle/app/oracle/admin/orcl/adump" audit_trail = "DB" db_name = "orcl" open_cursors = 300 _b_tree_bitmap_plans = FALSE _no_or_expansion = TRUE optimizer_index_cost_adj = 50 optimizer_index_caching = 90 pga_aggregate_target = 3210M diagnostic_dest = "/oracle/app/oracle" Thu Dec 05 09:47:26 2019 PMON started with pid=2, OS id=47601 Thu Dec 05 09:47:26 2019 PSP0 started with pid=3, OS id=47603 Thu Dec 05 09:47:28 2019 VKTM started with pid=4, OS id=47607 at elevated priority VKTM running at (1)millisec precision with DBRM quantum (100)ms Thu Dec 05 09:47:28 2019 GEN0 started with pid=5, OS id=47611 Thu Dec 05 09:47:28 2019 DIAG started with pid=6, OS id=47613 Thu Dec 05 09:47:28 2019 DBRM started with pid=7, OS id=47615 Thu Dec 05 09:47:28 2019 DIA0 started with pid=8, OS id=47617 Thu Dec 05 09:47:28 2019 MMAN started with pid=9, OS id=47619 Thu Dec 05 09:47:28 2019 DBW0 started with pid=10, OS id=47621 Thu Dec 05 09:47:28 2019 LGWR started with pid=11, OS id=47623 Thu Dec 05 09:47:28 2019 CKPT started with pid=12, OS id=47625 Thu Dec 05 09:47:28 2019 SMON started with pid=13, OS id=47627 Thu Dec 05 09:47:28 2019 RECO started with pid=14, OS id=47629 Thu Dec 05 09:47:28 2019 MMON started with pid=15, OS id=47631 Thu Dec 05 09:47:28 2019 MMNL started with pid=16, OS id=47634 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE from environment = /oracle/app/oracle Thu Dec 05 09:47:28 2019 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 1553952944 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Thu Dec 05 09:47:33 2019 ALTER DATABASE OPEN Beginning crash recovery of 1 threads parallel recovery started with 7 processes Started redo scan Completed redo scan read 10546 KB redo, 1690 data blocks need recovery Started redo application at Thread 1: logseq 47164, block 39943 Recovery of Online Redo Log: Thread 1 Group 3 Seq 47164 Reading mem 0 Mem# 0: /oracle/app/oracle/oradata/orcl/redo03.log Recovery of Online Redo Log: Thread 1 Group 2 Seq 47165 Reading mem 0 Mem# 0: /oracle/app/oracle/oradata/orcl/redo02.log Completed redo application of 5.86MB Completed crash recovery at Thread 1: logseq 47165, block 4932, scn 500814159 1690 data blocks read, 1688 data blocks written, 10546 redo k-bytes read Thu Dec 05 09:47:40 2019 LGWR: STARTING ARCH PROCESSES Thu Dec 05 09:47:40 2019 ARC0 started with pid=27, OS id=47696 ARC0: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC0: STARTING ARCH PROCESSES Thu Dec 05 09:47:41 2019 ARC1 started with pid=28, OS id=47711 Thu Dec 05 09:47:41 2019 ARC2 started with pid=30, OS id=47713 Thu Dec 05 09:47:41 2019 ARC3 started with pid=29, OS id=47715 ARC1: Archival started ARC2: Archival started ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH ARC2: Becoming the heartbeat ARCH Thread 1 advanced to log sequence 47166 (thread open) Thread 1 opened at log sequence 47166 Current log# 1 seq# 47166 mem# 0: /oracle/app/oracle/oradata/orcl/redo01.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Thu Dec 05 09:47:41 2019 SMON: enabling cache recovery Archived Log entry 44784 added for thread 1 sequence 47165 ID 0x58d8a86f dest 1: [47655] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:1111127512 end:1111127762 diff:250 (2 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed SMON: enabling tx recovery Database Characterset is AL32UTF8 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Thu Dec 05 09:47:43 2019 Starting background process QMNC Thu Dec 05 09:47:43 2019 QMNC started with pid=31, OS id=47739 ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Thu Dec 05 09:47:44 2019 db_recovery_file_dest_size of 35840 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Completed: ALTER DATABASE OPEN Thu Dec 05 09:47:45 2019 Starting background process CJQ0 Thu Dec 05 09:47:45 2019 CJQ0 started with pid=32, OS id=47753 Thu Dec 05 09:48:03 2019 Starting background process SMCO Thu Dec 05 09:48:03 2019 SMCO started with pid=47, OS id=47850
关于olap4j的连接参数
参照该文章尝试olap4j的连接,但是第二步第二行server和catalog这两个地方的参数应该输入什么? [参照代码](http://www.cnblogs.com/tianshansoft/archive/2012/04/02/2429769.html "参照代码") 查看了olap4j的官方说明好像也没有啊...求大神 [olap4j官方下载及相关说明](https://sourceforge.net/projects/olap4j/files/olap4j/olap4j-1.1.0/ "olap4j官方下载及相关说明")
Oracle恢复dmp文件报错问题,请大神帮忙看一下。
C:\Users\Administrator>imp system/snp201@P201_SN file=F:\p201\p201_2019_09_18_0_00.dmp log=F:\p201\logs.log full=y ignore=y 报错: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export file created by EXPORT:V10.02.01 via conventional path import done in ZHS16GBK character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) . importing SYSTEM's objects into SYSTEM IMP-00017: following statement failed with ORACLE error 1119: "CREATE UNDO TABLESPACE "RBSG_SPC" BLOCKSIZE 8192 DATAFILE '/oradata/P201/d" "ata/undotbs01.dbf' SIZE 2048M EXTENT MANAGEMENT LOCAL " IMP-00003: ORACLE error 1119 encountered ORA-01119: error in creating database file '/oradata/P201/data/undotbs01.dbf' ORA-27040: file create error, unable to create file OSD-04002: 无法打开文件 O/S-Error: (OS 3) 系统找不到指定的路径。 IMP-00017: following statement failed with ORACLE error 1119: "CREATE TEMPORARY TABLESPACE "TEMP_SPC" BLOCKSIZE 8192 TEMPFILE '/oradata/P" "201/data/temp01.dbf' SIZE 1073741824 AUTOEXTEND ON NEXT 655360 MAXSI" "ZE 32767M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576" IMP-00003: ORACLE error 1119 encountered ORA-01119: error in creating database file '/oradata/P201/data/temp01.dbf' ORA-27040: file create error, unable to create file OSD-04002: 无法打开文件 O/S-Error: (OS 3) 系统找不到指定的路径。 IMP-00017: following statement failed with ORACLE error 1119: "CREATE TABLESPACE "DATA_SPC" BLOCKSIZE 8192 DATAFILE '/oradata/P201/data/u" "sers01.dbf' SIZE 2048M , '/oradata/P201/data/users02.dbf' SIZE 2048M " " , '/oradata/P201/data/users03.dbf' SIZE 2048M , '/oradata/P201/dat" "a/users04.dbf' SIZE 2048M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLI" "NE PERMANENT SEGMENT SPACE MANAGEMENT AUTO" IMP-00003: ORACLE error 1119 encountered ORA-01119: error in creating database file '/oradata/P201/data/users01.dbf' ORA-27040: file create error, unable to create file OSD-04002: 无法打开文件 O/S-Error: (OS 3) 系统找不到指定的路径。 IMP-00017: following statement failed with ORACLE error 1119: "CREATE TABLESPACE "INDX_SPC" BLOCKSIZE 8192 DATAFILE '/oradata/P201/data/i" "ndex01.dbf' SIZE 2048M , '/oradata/P201/data/index02.dbf' SIZE 2048M " " , '/oradata/P201/data/index03.dbf' SIZE 2048M EXTENT MANAGEMENT L" "OCAL AUTOALLOCATE ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO" IMP-00003: ORACLE error 1119 encountered ORA-01119: error in creating database file '/oradata/P201/data/index01.dbf' ORA-27040: file create error, unable to create file OSD-04002: 无法打开文件 O/S-Error: (OS 3) 系统找不到指定的路径。 IMP-00017: following statement failed with ORACLE error 1119: "CREATE TABLESPACE "TOOLS_SPC" BLOCKSIZE 8192 DATAFILE '/oradata/P201/data/" "tools01.dbf' SIZE 104857600 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ON" "LINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO" IMP-00003: ORACLE error 1119 encountered ORA-01119: error in creating database file '/oradata/P201/data/tools01.dbf' ORA-27040: file create error, unable to create file OSD-04002: 无法打开文件 O/S-Error: (OS 3) 系统找不到指定的路径。 IMP-00017: following statement failed with ORACLE error 959: "ALTER USER "SYS" IDENTIFIED BY VALUES '34032A6EB9AF81F0' TEMPORARY TABLESPA" "CE "TEMP_SPC"" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'TEMP_SPC' does not exist IMP-00017: following statement failed with ORACLE error 959: "ALTER USER "SYSTEM" IDENTIFIED BY VALUES '6EB432A935A0D818' TEMPORARY TABLE" "SPACE "TEMP_SPC"" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'TEMP_SPC' does not exist IMP-00017: following statement failed with ORACLE error 959: "CREATE USER "TSMSYS" IDENTIFIED BY VALUES '3DF26A8B17D0F29F' TEMPORARY TABL" "ESPACE "TEMP_SPC" PASSWORD EXPIRE ACCOUNT LOCK" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'TEMP_SPC' does not exist IMP-00017: following statement failed with ORACLE error 959: "CREATE USER "DBUSRPOS" IDENTIFIED BY VALUES '3244CCDF3EC51372' DEFAULT TABL" "ESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC"" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'DATA_SPC' does not exist IMP-00017: following statement failed with ORACLE error 959: "CREATE USER "FTPOSERP" IDENTIFIED BY VALUES '19FBBB1DDD7819F1' DEFAULT TABL" "ESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC"" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'DATA_SPC' does not exist IMP-00017: following statement failed with ORACLE error 959: "CREATE USER "FTERPAPP" IDENTIFIED BY VALUES '36A05437E3347110' DEFAULT TABL" "ESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC"" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'DATA_SPC' does not exist IMP-00017: following statement failed with ORACLE error 959: "CREATE USER "DBLINKUSR" IDENTIFIED BY VALUES 'F7891792EC2D1261' DEFAULT TAB" "LESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC"" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'DATA_SPC' does not exist IMP-00017: following statement failed with ORACLE error 959: "CREATE USER "DBUSR" IDENTIFIED BY VALUES '684F707940FBD9C7' DEFAULT TABLESP" "ACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC"" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'DATA_SPC' does not exist IMP-00017: following statement failed with ORACLE error 959: "CREATE USER "DBUSRCARDNEW" IDENTIFIED BY VALUES 'CA675BF2681710F2' DEFAULT " "TABLESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC"" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'DATA_SPC' does not exist IMP-00017: following statement failed with ORACLE error 959: "CREATE USER "DBUSRSELECT" IDENTIFIED BY VALUES 'EB2868029BF741C0' DEFAULT T" "ABLESPACE "DATA_SPC" TEMPORARY TABLESPACE "TEMP_SPC"" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'DATA_SPC' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT UNLIMITED TABLESPACE TO "TSMSYS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'TSMSYS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT UNLIMITED TABLESPACE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT CREATE ANY INDEX TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT CREATE ANY SEQUENCE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT CREATE ANY TABLE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT CREATE USER TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT DELETE ANY TABLE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT DROP ANY INDEX TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT DROP ANY SEQUENCE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT DROP ANY TABLE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT DROP USER TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT EXECUTE ANY PROCEDURE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT GRANT ANY ROLE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT INSERT ANY TABLE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ANY SEQUENCE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ANY TABLE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT UPDATE ANY TABLE TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT UNLIMITED TABLESPACE TO "DBUSR"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSR' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT UNLIMITED TABLESPACE TO "DBUSRCARDNEW"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRCARDNEW' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT CREATE SESSION TO "DBUSRSELECT"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRSELECT' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT ALTER SESSION TO "DBUSRSELECT"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRSELECT' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ANY DICTIONARY TO "DBUSRSELECT"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRSELECT' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT "RESOURCE" TO "TSMSYS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'TSMSYS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT "DBA" TO "DBUSRPOS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT "ROLE_APPPOSERP" TO "FTPOSERP"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'FTPOSERP' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT "CONNECT" TO "FTERPAPP"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'FTERPAPP' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT "ROLE_APPPOSERP" TO "DBLINKUSR"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBLINKUSR' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT "DBA" TO "DBUSR"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSR' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT "DBA" TO "DBUSRCARDNEW"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBUSRCARDNEW' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT "ROLE_DBPOSERP" TO "DBLINKUSR"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'DBLINKUSR' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "DBUSRSELECT" DEFAULT ROLE ALL" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'DBUSRSELECT' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "DBUSRCARDNEW" DEFAULT ROLE ALL" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'DBUSRCARDNEW' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "DBUSR" DEFAULT ROLE ALL" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'DBUSR' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "DBLINKUSR" DEFAULT ROLE ALL" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'DBLINKUSR' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "FTERPAPP" DEFAULT ROLE ALL" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'FTERPAPP' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "FTPOSERP" DEFAULT ROLE ALL" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'FTPOSERP' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "DBUSRPOS" DEFAULT ROLE ALL" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'DBUSRPOS' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "TSMSYS" DEFAULT ROLE ALL" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'TSMSYS' does not exist . importing SYSMAN's objects into SYSMAN . importing DBUSRPOS's objects into DBUSRPOS "ALTER SESSION SET CURRENT_SCHEMA= "DBUSRPOS"" IMP-00003: ORACLE error 1435 encountered ORA-01435: user does not exist IMP-00000: Import terminated unsuccessfully
oracle触发器导致ORA-03113错误
场景:使用dblink加触发器同步两个库的数据,源数据库使用11g(11.2.0.1.0),目标数据库使用11g(11.2.0.1.0)。向源数据库中插入记录时,数据无法同步至目标库。并抛出ORA-03113异常。当源数据库使用12c时,一切正常,数据可能同步。 ``` -- 创建dblink CREATE PUBLIC DATABASE LINK datasync CONNECT TO kxmadmin IDENTIFIED BY "123456" USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.100.92)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = kxm)))'; -- 创建同义词 create public synonym T_STATISTICS_ATTR_WEEK_HK for T_STATISTICS_ATTR_WEEK @DATASYNC; -- 创建触发器 CREATE OR REPLACE TRIGGER TEMP_trigger BEFORE INSERT ON T_STATISTICS_ATTR_WEEK FOR EACH ROW BEGIN IF INSERTING THEN INSERT INTO T_STATISTICS_ATTR_WEEK_HK ( ATTR, TIMEFLAG, COUNT, CREATETIME ) VALUES ( : NEW .ATTR, : NEW .TIMEFLAG, : NEW . COUNT, : NEW .CREATETIME ) ; END IF; END ; ``` ![图片说明](https://img-ask.csdn.net/upload/201908/16/1565937474_797263.png) oracle日志如下: ``` Trace file e:\app\administrator\diag\rdbms\kxm\kxm\trace\kxm_ora_6856.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Windows NT Version V6.2 CPU : 12 - type 8664, 6 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:7791M/16213M, Ph+PgF:20654M/32597M Instance name: kxm Redo thread mounted by this instance: 1 Oracle process number: 41 Windows thread id: 6856, image: ORACLE.EXE (SHAD) *** 2019-08-16 14:36:23.310 *** SESSION ID:(110.677) 2019-08-16 14:36:23.310 *** CLIENT ID:() 2019-08-16 14:36:23.310 *** SERVICE NAME:(kxm) 2019-08-16 14:36:23.310 *** MODULE NAME:(navicat.exe) 2019-08-16 14:36:23.310 *** ACTION NAME:() 2019-08-16 14:36:23.310 --------Dumping Sorted Master Trigger List -------- Trigger Owner : KXMADMIN Trigger Name : HDS_TEMP_TRIGGER --------Dumping Trigger Sublists -------- trigger sublist 0 : trigger sublist 1 : trigger sublist 2 : trigger sublist 3 : Trigger Owner : KXMADMIN Trigger Name : HDS_TEMP_TRIGGER trigger sublist 4 : Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xA] [PC:0xAD7DF32, pevm_BIND()+258] Incident 20729 created, dump file: e:\app\administrator\diag\rdbms\kxm\kxm\incident\incdir_20729\kxm_ora_6856_i20729.trc ORA-07445: exception encountered: core dump [pevm_BIND()+258] [ACCESS_VIOLATION] [ADDR:0xA] [PC:0xAD7DF32] [UNABLE_TO_READ] [] ```
olap数据挖掘,数据库是Sql2008,通过mdx语句查询数据在前台WEB显示。
现在通过MDX语句查询到的是 cellSet 数据集合 因为刚接触,想请教一个思路, 项目功能大致是 指定某个数据库,能对改数据库的数据进行数据挖掘。因为数据库不固定,所以层次和结构都不明确,有大神能给个解决方向吗?
pentaho,Kylin, Mondrian, Saiku之间到底是什么样的关系?
pentaho,Kylin, Mondrian, Saiku之间到底是什么样的关系?感觉开源的东西名字好乱。 百度查到: pentaho是一个BI平台,集成了 ◆ ETL工具:Enhydra/Kettle也可以其他 ◆ OLAP Server:Mondrian也可以其他 ◆ OLAP展示:JPivot也可以其他 ◆ 数据挖掘组件:Weka也可以其他 百度Saiku查到: Saiku成立于2008年,由Tom Barber和Paul Stoellberger研发。最初叫做Pentaho分析工具,起初是基于OLAP4J库用GWT包装的一个前端分析工具。经过多年的演化、重写之后,于2010年,改名为Saiku。 那么我就可以认为Saiku是pentaho的最新版,所以好了,我可以不用理会 pentaho了,Saiku是pentaho的最新版那么应该包含: ◆ ETL工具:Enhydra/Kettle也可以其他 ◆ OLAP Server:Mondrian也可以其他 ◆ OLAP展示:JPivot也可以其他 ◆ 数据挖掘组件:Weka也可以其他 百度:Apache Kylin查到: Apache Kylin™是一个开源的分布式分析引擎,提供Hadoop之上的SQL查询接口及多维分析(OLAP)能力以支持超大规模数据,最初由eBay Inc. 开发并贡献至开源社区。它能在亚秒内查询巨大的Hive表。 那么我是否可以认为Apache Kylin和Mondrian同样是OLAP引擎,只不过Apache Kylin比Mondrian强大,是分布式的而且主要为大数据生态的Hadoop和hive而生? 然后我网上查发现有这么个组合: 《Saiku+Kylin构建多维分析OLAP平台》: 使用Saiku+Kylin构建多维分析OLAP平台 - zoubf的专栏 - CSDN博客 困惑1,Saiku 不是已经包含了OLAP引擎了:Mondrian(也可以其他)了吗?这个组合的意思是把Saiku的默认OLAP引擎换成更强大的Kylin的意思? 再查资料,又看到: 《Kylin, Mondrian, Saiku系统的整合》:Kylin, Mondrian, Saiku系统的整合 Kylin和Mondrian都属于OLAP引擎,Saiku也自己含OLPA引擎,这个组合是什么意思? 是只Saiku的其他部件不变,OLAP变成Kylin+Mondrian双引擎? Saiku原装的◆ ETL工具、OLAP Server:Mondrian、OLAP、展示、数据挖掘组件分别是什么? 挺困惑的。 另外我觉得这些开源的BI的展示不够美观,也不是中文,可否修改源码使其变成中文,并将展示的图换成Echart呢? 有没有教程或者实际案例呢?
OLAP做数据分析的时候,jpivot 这个页面显示的 导航tab怎么删除
OLAP做数据分析的时候,jpivot 这个页面显示的 导航tab怎么删除,比如删除 那个OLAP导航 ,显示MDX编辑器等,在线等···
oracle使用imp导入数据库出问题IMP-00009
** imp导入数据库中途出错**:(:IMP-00009、IMP-00027、IMP-00003、ORA-01013:);dmp文件大小500G **emp导出日志(部分)**: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user SHDUCHA . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user SHDUCHA About to export SHDUCHA's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export SHDUCHA's tables via Conventional Path ... **imp导出日志(部分)**: Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export file created by EXPORT:V10.02.01 via conventional path import done in ZHS16GBK character set and AL16UTF16 NCHAR character set . . . . importing table "TB_I_G_3_106_82_97" 72632 rows imported . . importing table "TB_I_G_3_106_83_101" IMP-00009: abnormal end of export file IMP-00027: failed to rollback partial import of previous table IMP-00003: ORACLE error 1013 encountered ORA-01013: user requested cancel of current operation IMP-00000: Import terminated unsuccessfully
olap分析引擎mondrian开源项目整合web
我在用多维数据分析引擎mondrian开源工具整合springmvc时,出现如下错误:空指针异常,但是经调试代码,对象不为空,求教各位大神到底问题在哪? java.lang.NullPointerException at java.util.regex.Matcher.getTextLength(Matcher.java:1234) at java.util.regex.Matcher.reset(Matcher.java:308) at java.util.regex.Matcher.<init>(Matcher.java:228) at java.util.regex.Pattern.matcher(Pattern.java:1088) at org.springframework.security.web.firewall.FirewalledResponse.sendRedirect(FirewalledResponse.java:22) at javax.servlet.http.HttpServletResponseWrapper.sendRedirect(HttpServletResponseWrapper.java:137) at org.springframework.security.web.context.SaveContextOnUpdateOrErrorResponseWrapper.sendRedirect(SaveContextOnUpdateOrErrorResponseWrapper.java:74) at org.apache.jsp.WEB_002dINF.queries.tezz_jsp._jspService(tezz_jsp.java:108) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:604) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:543) at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:62) at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:163) at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:116) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:369) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at com.ntimes.dam.common.security.AccountFilterSecurityInterceptor.invoke(AccountFilterSecurityInterceptor.java:60) at com.ntimes.dam.common.security.AccountFilterSecurityInterceptor.doFilter(AccountFilterSecurityInterceptor.java:53) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:119) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:168) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) 下面是调用到rd.include(pageContext.getRequest(), pageContext.getResponse())这一行代码报错所在的类: public class IncludeTag extends TagSupport { String httpParam = "include"; String prefix = "/WEB-INF/"; String suffix = ".jsp"; private static Logger logger = Logger.getLogger(IncludeTag.class); public String getHttpParam() { return httpParam; } public void setHttpParam(String httpParam) { this.httpParam = httpParam; } public int doStartTag() throws JspException { try { logger.info("enter"); HttpServletRequest hsr = (HttpServletRequest) pageContext.getRequest(); String name = hsr.getParameter(httpParam); if (name != null) { // the parameter was specified, now we include the jsp String uri = prefix + name + suffix; logger.info("including " + uri); RequestDispatcher rd = pageContext.getRequest().getRequestDispatcher(uri); System.out.println(rd==null); System.out.println(pageContext.getRequest()==null); System.out.println(pageContext.getResponse()==null); rd.include(pageContext.getRequest(), pageContext.getResponse()); } logger.info("leave"); return SKIP_BODY; } catch (ServletException e) { logger.error("exception caught", e); throw new JspException(e); } catch (IOException e) { logger.error("exception caught", e); throw new JspException(e); } }
用toad导入dmp文件,提示 IMP-00010: 不是有效的导出文件, 标头验证失败
Import: Release 11.2.0.1.0 - Production on 星期日 5月 10 13:55:14 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options IMP-00010: 不是有效的导出文件, 标头验证失败 IMP-00000: 未成功终止导入
java连接SSAS类型不匹配问题
用类jdbc的olap4j.jar尝试进行连接,但是按照参照代码录入eclipse之后,一直报错,报错代码如下: OlapConnection olapConnection =connection.unwrap(OlapConnection.class);//报错内容为,类型不匹配:不能从 Object 转换为 OlapConnection [参照代码](http://www.cnblogs.com/tianshansoft/archive/2012/04/02/2429769.html "") 求大神解救 jar包已导入并加入到classpath中
关于java连接SSAS的问题
查到了要用olap4j的包,但是按照说明输入的代码在eclipse里是报错的: 源码如下(我还没写执行语句,只是想先测试连接是否成功): ``` import java.sql.*; import org.olap4j.*; public class JavaSSAS { public static void main(String[] args) { // TODO 自动生成的方法存根 Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver"); Connection connection =DriverManager.getConnection("jdbc:xmla:"+ "Server=http://example.com:8080/mondrian/xmla"); System.out.println(connection); OlapConnection olapConnection = connection.unwrap(OlapConnection.class);//该行报错,报错内容为类型不匹配,不能从Object转换为OlapConnection类型 OlapStatement stmt = olapConnection.createStatement(); } } ``` 已经将olap4j下的几个jar包都导入了,classpath也已设定.....求解答.....
oracle 11g ORA-00445:每个月数据库都会死,pl/sql登录不上
每个月数据库都会无缘无故的死掉,重启数据库又正常了,下面是alert_orcl.log里面的日志,window服务器内存8G ,oracle版本11gR2,这个是什么原因导致的呢 Tue Oct 28 20:18:25 2014 Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_2628.trc (incident=65106): ORA-00445: background process "J000" did not start after 120 seconds Incident details in: d:\oracle\diag\rdbms\orcl\orcl\incident\incdir_65106\orcl_cjq0_2628_i65106.trc kkjcre1p: unable to spawn jobq slave process Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_2628.trc: Tue Oct 28 20:18:28 2014 Trace dumping is performing id=[cdmp_20141028201828] Tue Oct 28 20:20:16 2014 Thread 1 cannot allocate new log, sequence 6830 Private strand flush not complete Current log# 1 seq# 6829 mem# 0: D:\ORACLE\ORADATA\orcl\REDO01.LOG Thread 1 advanced to log sequence 6830 (LGWR switch) Current log# 2 seq# 6830 mem# 0: D:\ORACLE\ORADATA\orcl\REDO02.LOG 下面是重启的参数: Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Using parameter settings in server-side spfile D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEorcl.ORA System parameters with non-default values: processes = 1000 sga_max_size = 3104M memory_target = 3504M memory_max_target = 3504M control_files = "D:\ORACLE\ORADATA\orcl\CONTROL01.CTL" control_files = "D:\ORACLE\FLASH_RECOVERY_AREA\orcl\CONTROL02.CTL" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "D:\oracle\flash_recovery_area" db_recovery_file_dest_size= 3912M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "D:\ORACLE\ADMIN\orcl\ADUMP" audit_trail = "DB" db_name = "orcl" open_cursors = 300 diagnostic_dest = "D:\ORACLE" Tue Oct 28 20:50:40 2014
新手:oracle数据库导出时报错,用的是toad for oracle软件导出整个数据库
Export: Release 10.2.0.1.0 - Production on 星期一, 17 3月, 2014 14:01:39 Copyright (c) 2003, 2005, Oracle. All rights reserved. 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options ORA-39002: 操作无效 ORA-39070: 无法打开日志文件。 ORA-29283: 文件操作无效 ORA-06512: 在 "SYS.UTL_FILE", line 475 ORA-29283: 文件操作无效 注:导出时是使用软件,工具栏上的数据库-》导出-》数据导出向导,根据提示一步一步下来的
【求助】oracle 11G 自动建立的实例名称无法使用
近期在redhat linux 5.8 oracle 11.2.0.4.0 上创建实例,创建完后发现无法使用实例名登陆,尝试着手动建立一个仅是把服务名改了,就可以正常登陆了,很无语,请各位大侠帮忙分析一下,谢谢! 自动建立的tnsnames.ora 中配置: SYSIT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sysit) ) ) 尝试使用: sqlplus admin/admin12@sysit QL*Plus: Release 11.2.0.4.0 Production on Mon Aug 24 14:05:55 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA Enter user-name: 手动复制后改完服务名后: ISYSIT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sysit) ) ) 尝试使用: sqlplus admin/admin12@isysit SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 24 14:16:52 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
Oracle数据泵导入设置table_exists_action=replace 依然报错
数据泵导入时, 设置table_exists_action=replace意思是:存在该表的话,先drop再插入数据, 所以有我要执行的表的话应该是正常情况吧,但是为什么会报错呢。 执行语句为: ``` impdp atomic/******** directory=DATA_PUMP_DIR dumpfile=EXPDP_SIT20190315.dmp schemas=atomic table_exists_action=replace logfile=EXPDP_SIT20190315.log ``` 但是该错误不影响结果,数据成功导入了。 部分日志如下: import: Release 11.2.0.4.0 - Production on Fri Mar 22 09:23:12 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ;;; Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "ATOMIC"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded Starting "ATOMIC"."SYS_IMPORT_SCHEMA_01": atomic/******** directory=DATA_PUMP_DIR dumpfile=EXPDP_SIT20190315.dmp schemas=atomic table_exists_action=replace logfile=EXPDP_SIT20190315.log Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"ATOMIC" already exists Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC ORA-31684: Object type TYPE:"ATOMIC"."FSI_ADJUST_AMORT_TYPE_OBJ" already exists ORA-31684: Object type TYPE:"ATOMIC"."FSI_ADJUST_AMORT_TYPE_TYPE" already exists Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE ORA-31684: Object type SEQUENCE:"ATOMIC"."FSI_GEN_ACCOUNT_SKEY" already exists ORA-31684: Object type SEQUENCE:"ATOMIC"."FSI_OBJECT_DEN_SEQ_NUM" already exists ORA-31684: Object type SEQUENCE:"ATOMIC"."FSI_IDENTITY_SEQ" already exists ORA-31684: Object type SEQUENCE:"ATOMIC"."PROCESS_NODE_MAP_ID_SEQ" already exists Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "ATOMIC"."FSI_D_CASA" 838.6 MB 2087267 rows . . imported "ATOMIC"."FSI_D_TERM_DEPOSITS" 448.7 MB 1197937 rows . . imported "ATOMIC"."FSI_D_LOAN_CONTRACTS" 32.07 MB 73974 rows . . imported "ATOMIC"."SYS_EXPORT_SCHEMA_01" 27.68 MB 6882 rows . . imported "ATOMIC"."SYS_EXPORT_SCHEMA_02" 27.71 MB 6520 rows . . imported "ATOMIC"."STG_PAYMENT_SCHEDULE" 14.24 MB 378694 rows . . imported "ATOMIC"."FSI_IRC_RATE_HIST" 10.99 MB 296220 rows . . imported "ATOMIC"."REV_TAB_COLUMNS_MLS" 2.316 MB 15650 rows . . imported "ATOMIC"."FSI_D_LEDGER_STAT_INSTRUMENT" 1.488 MB 4733 rows . . imported "ATOMIC"."REV_TAB_COLUMNS" 822.8 KB 15650 rows . . imported "ATOMIC"."FSI_RESULT_QUEUE" 641.2 KB 12332 rows . . imported "ATOMIC"."FSI_D_INVESTMENTS" 591.7 KB 1296 rows . . imported "ATOMIC"."DIM_COUNTRY_B" 11.18 KB 71 rows . . imported "ATOMIC"."DIM_COUNTRY_TL" 11.45 KB 71 rows ..... Job "ATOMIC"."SYS_IMPORT_SCHEMA_01" completed with 127 error(s) at Fri Mar 22 09:27:12 2019 elapsed 0 00:03:55
win7 安装Oracle 11g 卡在85% 不动了。
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export file created by EXPORT:V11.02.00 via conventional path About to import transportable tablespace(s) metadata... import done in AL32UTF8 character set and AL16UTF16 NCHAR character set import server uses US7ASCII character set (possible charset conversion) export client uses US7ASCII character set (possible charset conversion) . importing SYS's objects into SYS . importing SYS's objects into SYS . importing HR's objects into HR . . importing table "REGIONS" . . importing table "COUNTRIES" . . importing table "LOCATIONS" . . importing table "DEPARTMENTS" . . importing table "JOBS" . . importing table "EMPLOYEES" . . importing table "JOB_HISTORY" . importing OE's objects into OE . . importing table "CUSTOMERS" . . importing table "WAREHOUSES" . . importing table "ORDER_ITEMS" . . importing table "ORDERS" . . importing table "INVENTORIES" . . importing table "PRODUCT_INFORMATION" . . importing table "PRODUCT_DESCRIPTIONS" . . importing table "PROMOTIONS" . importing PM's objects into PM . . importing table "ONLINE_MEDIA" . . importing table "PRINT_MEDIA" . importing IX's objects into IX . . importing table "ORDERS_QUEUETABLE" . . importing table "AQ$_ORDERS_QUEUETABLE_S" . . importing table "AQ$_ORDERS_QUEUETABLE_T" . . importing table "AQ$_ORDERS_QUEUETABLE_H" . . importing table "AQ$_ORDERS_QUEUETABLE_L" . . importing table "AQ$_ORDERS_QUEUETABLE_G" . . importing table "AQ$_ORDERS_QUEUETABLE_I" . . importing table "STREAMS_QUEUE_TABLE" . . importing table "AQ$_STREAMS_QUEUE_TABLE_S" . . importing table "AQ$_STREAMS_QUEUE_TABLE_T" . . importing table "AQ$_STREAMS_QUEUE_TABLE_H" . . importing table "AQ$_STREAMS_QUEUE_TABLE_L" . . importing table "AQ$_STREAMS_QUEUE_TABLE_G" . . importing table "AQ$_STREAMS_QUEUE_TABLE_I" . . importing table "AQ$_STREAMS_QUEUE_TABLE_C" . importing SH's objects into SH . . importing table "SALES" . . importing table "COSTS" . . importing table "TIMES" . . importing table "PRODUCTS" . . importing table "CHANNELS" . . importing table "PROMOTIONS" . . importing table "CUSTOMERS" . . importing table "COUNTRIES" . . importing table "SUPPLEMENTARY_DEMOGRAPHICS" . . importing table "CAL_MONTH_SALES_MV" . . importing table "FWEEK_PSCAT_SALES_MV" . importing HR's objects into HR . importing OE's objects into OE . importing PM's objects into PM . importing SH's objects into SH . importing OE's objects into OE . importing PM's objects into PM . importing IX's objects into IX . importing SH's objects into SH . . importing table "DR$SUP_TEXT_IDX$I" . . importing table "DR$SUP_TEXT_IDX$K" . . importing table "DR$SUP_TEXT_IDX$R" . . importing table "DR$SUP_TEXT_IDX$N" . importing OE's objects into OE . importing IX's objects into IX . importing HR's objects into HR About to enable constraints... . importing OE's objects into OE . importing SYS's objects into SYS Import terminated successfully without warnings.
相见恨晚的超实用网站
相见恨晚的超实用网站 持续更新中。。。
Java学习的正确打开方式
在博主认为,对于入门级学习java的最佳学习方法莫过于视频+博客+书籍+总结,前三者博主将淋漓尽致地挥毫于这篇博客文章中,至于总结在于个人,实际上越到后面你会发现学习的最好方式就是阅读参考官方文档其次就是国内的书籍,博客次之,这又是一个层次了,这里暂时不提后面再谈。博主将为各位入门java保驾护航,各位只管冲鸭!!!上天是公平的,只要不辜负时间,时间自然不会辜负你。 何谓学习?博主所理解的学习,它是一个过程,是一个不断累积、不断沉淀、不断总结、善于传达自己的个人见解以及乐于分享的过程。
程序员必须掌握的核心算法有哪些?
由于我之前一直强调数据结构以及算法学习的重要性,所以就有一些读者经常问我,数据结构与算法应该要学习到哪个程度呢?,说实话,这个问题我不知道要怎么回答你,主要取决于你想学习到哪些程度,不过针对这个问题,我稍微总结一下我学过的算法知识点,以及我觉得值得学习的算法。这些算法与数据结构的学习大多数是零散的,并没有一本把他们全部覆盖的书籍。下面是我觉得值得学习的一些算法以及数据结构,当然,我也会整理一些看过...
大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了
大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、电子书搜索 对于大部分程序员...
linux系列之常用运维命令整理笔录
本博客记录工作中需要的linux运维命令,大学时候开始接触linux,会一些基本操作,可是都没有整理起来,加上是做开发,不做运维,有些命令忘记了,所以现在整理成博客,当然vi,文件操作等就不介绍了,慢慢积累一些其它拓展的命令,博客不定时更新 free -m 其中:m表示兆,也可以用g,注意都要小写 Men:表示物理内存统计 total:表示物理内存总数(total=used+free) use...
比特币原理详解
一、什么是比特币 比特币是一种电子货币,是一种基于密码学的货币,在2008年11月1日由中本聪发表比特币白皮书,文中提出了一种去中心化的电子记账系统,我们平时的电子现金是银行来记账,因为银行的背后是国家信用。去中心化电子记账系统是参与者共同记账。比特币可以防止主权危机、信用风险。其好处不多做赘述,这一层面介绍的文章很多,本文主要从更深层的技术原理角度进行介绍。 二、问题引入 假设现有4个人...
python 简易微信实现(注册登录+数据库存储+聊天+GUI+文件传输)
socket+tkinter详解+简易微信实现 历经多天的努力,查阅了许多大佬的博客后终于实现了一个简易的微信O(∩_∩)O~~ 简易数据库的实现 使用pands+CSV实现数据库框架搭建 import socket import threading from pandas import * import pymysql import csv # 创建DataFrame对象 # 存储用户数据的表(...
程序员接私活怎样防止做完了不给钱?
首先跟大家说明一点,我们做 IT 类的外包开发,是非标品开发,所以很有可能在开发过程中会有这样那样的需求修改,而这种需求修改很容易造成扯皮,进而影响到费用支付,甚至出现做完了项目收不到钱的情况。 那么,怎么保证自己的薪酬安全呢? 我们在开工前,一定要做好一些证据方面的准备(也就是“讨薪”的理论依据),这其中最重要的就是需求文档和验收标准。一定要让需求方提供这两个文档资料作为开发的基础。之后开发...
网页实现一个简单的音乐播放器(大佬别看。(⊙﹏⊙))
今天闲着无事,就想写点东西。然后听了下歌,就打算写个播放器。 于是乎用h5 audio的加上js简单的播放器完工了。 演示地点演示 html代码如下` music 这个年纪 七月的风 音乐 ` 然后就是css`*{ margin: 0; padding: 0; text-decoration: none; list-...
Python十大装B语法
Python 是一种代表简单思想的语言,其语法相对简单,很容易上手。不过,如果就此小视 Python 语法的精妙和深邃,那就大错特错了。本文精心筛选了最能展现 Python 语法之精妙的十个知识点,并附上详细的实例代码。如能在实战中融会贯通、灵活使用,必将使代码更为精炼、高效,同时也会极大提升代码B格,使之看上去更老练,读起来更优雅。
数据库优化 - SQL优化
以实际SQL入手,带你一步一步走上SQL优化之路!
2019年11月中国大陆编程语言排行榜
2019年11月2日,我统计了某招聘网站,获得有效程序员招聘数据9万条。针对招聘信息,提取编程语言关键字,并统计如下: 编程语言比例 rank pl_ percentage 1 java 33.62% 2 cpp 16.42% 3 c_sharp 12.82% 4 javascript 12.31% 5 python 7.93% 6 go 7.25% 7 p...
通俗易懂地给女朋友讲:线程池的内部原理
餐盘在灯光的照耀下格外晶莹洁白,女朋友拿起红酒杯轻轻地抿了一小口,对我说:“经常听你说线程池,到底线程池到底是个什么原理?”
《奇巧淫技》系列-python!!每天早上八点自动发送天气预报邮件到QQ邮箱
将代码部署服务器,每日早上定时获取到天气数据,并发送到邮箱。 也可以说是一个小型人工智障。 知识可以运用在不同地方,不一定非是天气预报。
经典算法(5)杨辉三角
杨辉三角 是经典算法,这篇博客对它的算法思想进行了讲解,并有完整的代码实现。
腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹?
昨天,有网友私信我,说去阿里面试,彻底的被打击到了。问了为什么网上大量使用ThreadLocal的源码都会加上private static?他被难住了,因为他从来都没有考虑过这个问题。无独有偶,今天笔者又发现有网友吐槽了一道腾讯的面试题,我们一起来看看。 腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹? 在互联网职场论坛,一名程序员发帖求助到。二面腾讯,其中一个算法题:64匹...
面试官:你连RESTful都不知道我怎么敢要你?
干货,2019 RESTful最贱实践
刷了几千道算法题,这些我私藏的刷题网站都在这里了!
遥想当年,机缘巧合入了 ACM 的坑,周边巨擘林立,从此过上了"天天被虐似死狗"的生活… 然而我是谁,我可是死狗中的战斗鸡,智力不够那刷题来凑,开始了夜以继日哼哧哼哧刷题的日子,从此"读题与提交齐飞, AC 与 WA 一色 ",我惊喜的发现被题虐既刺激又有快感,那一刻我泪流满面。这么好的事儿作为一个正直的人绝不能自己独享,经过激烈的颅内斗争,我决定把我私藏的十几个 T 的,阿不,十几个刷题网...
JavaScript 为什么能活到现在?
作者 | 司徒正美 责编 |郭芮 出品 | CSDN(ID:CSDNnews) JavaScript能发展到现在的程度已经经历不少的坎坷,早产带来的某些缺陷是永久性的,因此浏览器才有禁用JavaScript的选项。甚至在jQuery时代有人问出这样的问题,jQuery与JavaScript哪个快?在Babel.js出来之前,发明一门全新的语言代码代替JavaScript...
项目中的if else太多了,该怎么重构?
介绍 最近跟着公司的大佬开发了一款IM系统,类似QQ和微信哈,就是聊天软件。我们有一部分业务逻辑是这样的 if (msgType = "文本") { // dosomething } else if(msgType = "图片") { // doshomething } else if(msgType = "视频") { // doshomething } else { // doshom...
Nginx 原理和架构
Nginx 是一个免费的,开源的,高性能的 HTTP 服务器和反向代理,以及 IMAP / POP3 代理服务器。Nginx 以其高性能,稳定性,丰富的功能,简单的配置和低资源消耗而闻名。 Nginx 的整体架构 Nginx 里有一个 master 进程和多个 worker 进程。master 进程并不处理网络请求,主要负责调度工作进程:加载配置、启动工作进程及非停升级。worker 进程负责处...
致 Python 初学者
欢迎来到“Python进阶”专栏!来到这里的每一位同学,应该大致上学习了很多 Python 的基础知识,正在努力成长的过程中。在此期间,一定遇到了很多的困惑,对未来的学习方向感到迷茫。我非常理解你们所面临的处境。我从2007年开始接触 python 这门编程语言,从2009年开始单一使用 python 应对所有的开发工作,直至今天。回顾自己的学习过程,也曾经遇到过无数的困难,也曾经迷茫过、困惑过。开办这个专栏,正是为了帮助像我当年一样困惑的 Python 初学者走出困境、快速成长。希望我的经验能真正帮到你
Python 编程开发 实用经验和技巧
Python是一门很灵活的语言,也有很多实用的方法,有时候实现一个功能可以用多种方法实现,我这里总结了一些常用的方法和技巧,包括小数保留指定位小数、判断变量的数据类型、类方法@classmethod、制表符中文对齐、遍历字典、datetime.timedelta的使用等,会持续更新......
吐血推荐珍藏的Visual Studio Code插件
作为一名Java工程师,由于工作需要,最近一个月一直在写NodeJS,这种经历可以说是一部辛酸史了。好在有神器Visual Studio Code陪伴,让我的这段经历没有更加困难。眼看这段经历要告一段落了,今天就来给大家分享一下我常用的一些VSC的插件。 VSC的插件安装方法很简单,只需要点击左侧最下方的插件栏选项,然后就可以搜索你想要的插件了。 下面我们进入正题 Material Theme ...
“狗屁不通文章生成器”登顶GitHub热榜,分分钟写出万字形式主义大作
一、垃圾文字生成器介绍 最近在浏览GitHub的时候,发现了这样一个骨骼清奇的雷人项目,而且热度还特别高。 项目中文名:狗屁不通文章生成器 项目英文名:BullshitGenerator 根据作者的介绍,他是偶尔需要一些中文文字用于GUI开发时测试文本渲染,因此开发了这个废话生成器。但由于生成的废话实在是太过富于哲理,所以最近已经被小伙伴们给玩坏了。 他的文风可能是这样的: 你发现,...
程序员:我终于知道post和get的区别
是一个老生常谈的话题,然而随着不断的学习,对于以前的认识有很多误区,所以还是需要不断地总结的,学而时习之,不亦说乎
《程序人生》系列-这个程序员只用了20行代码就拿了冠军
你知道的越多,你不知道的越多 点赞再看,养成习惯GitHub上已经开源https://github.com/JavaFamily,有一线大厂面试点脑图,欢迎Star和完善 前言 这一期不算《吊打面试官》系列的,所有没前言我直接开始。 絮叨 本来应该是没有这期的,看过我上期的小伙伴应该是知道的嘛,双十一比较忙嘛,要值班又要去帮忙拍摄年会的视频素材,还得搞个程序员一天的Vlog,还要写BU...
开源并不是你认为的那些事
点击上方蓝字 关注我们开源之道导读所以 ————想要理清开源是什么?先要厘清开源不是什么,名正言顺是句中国的古代成语,概念本身的理解非常之重要。大部分生物多样性的起源,...
加快推动区块链技术和产业创新发展,2019可信区块链峰会在京召开
11月8日,由中国信息通信研究院、中国通信标准化协会、中国互联网协会、可信区块链推进计划联合主办,科技行者协办的2019可信区块链峰会将在北京悠唐皇冠假日酒店开幕。   区块链技术被认为是继蒸汽机、电力、互联网之后,下一代颠覆性的核心技术。如果说蒸汽机释放了人类的生产力,电力解决了人类基本的生活需求,互联网彻底改变了信息传递的方式,区块链作为构造信任的技术有重要的价值。   1...
Python 植物大战僵尸代码实现(2):植物卡片选择和种植
这篇文章要介绍的是: - 上方植物卡片栏的实现。 - 点击植物卡片,鼠标切换为植物图片。 - 鼠标移动时,判断当前在哪个方格中,并显示半透明的植物作为提示。
相关热词 c#中dns类 c#合并的excel c# implicit c#怎么保留3个小数点 c# 串口通信、 网络调试助手c# c# 泛型比较大小 c#解压分卷问题 c#启动居中 c# 逻辑或运算符
立即提问