我们的技术难题列表

1、pb使用oracle的olap服务的方法
2、pb中动态为sql语句加入参数
3、动态生成pb的dw
4、动态查询和组合tooltips
5、工作流程的处理方式,是否向内网集成
6、一维报表的查询和统计放入电子征管助手应该好好理解电子征管助手
7、多维的报表如何分类(功能模块树)
8、怎样将查询结果给dropdownlist

阅读更多

技术难题

05-19

Microsoft Windows XP [版本 5.1.2600]rn(C) 版权所有 1985-2001 Microsoft Corp.rnrnC:\Documents and Settings\Administrator>D:\RealOA\bin\StartTomcat.batrnrnC:\Documents and Settings\Administrator>"D:\RealOA\jdk1.4\bin\java.exe" -Xms512mrn -Xmx1024m -XX:MaxPermSize=512m -jar -Duser.dir="d:\RealOA" -Droot="d:\RealOA\hrnome" "d:\RealOA\bin\bootstrap.jar" startrnStarting service Tomcat-StandalonernApache Tomcat/4.0.4rnrnAn unexpected exception has been detected in native code outside the VM.rnUnexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x6D0636BErnFunction=Java_sun_print_Win32PrintJob_printRawData+0x739rnLibrary=D:\RealOA\jdk1.4\jre\bin\awt.dllrnrnCurrent Java thread:rn at sun.awt.windows.Win32OffScreenSurfaceData.initDDraw(Native Method)rn at sun.awt.windows.Win32OffScreenSurfaceData.(Win32OffScreenSurfrnaceData.java:116)rn at sun.awt.Win32GraphicsDevice.(Win32GraphicsDevice.java:59)rn at sun.awt.Win32GraphicsEnvironment.makeScreenDevice(Win32GraphicsEnvirornnment.java:168)rn at sun.java2d.SunGraphicsEnvironment.getScreenDevices(SunGraphicsEnvironrnment.java:240)rn - locked <02B0D090> (a sun.awt.Win32GraphicsEnvironment)rn at sun.awt.Win32GraphicsEnvironment.getDefaultScreenDevice(Win32GraphicsrnEnvironment.java:61)rn at java.awt.Window.init(Window.java:223)rn at java.awt.Window.(Window.java:267)rn at java.awt.Frame.(Frame.java:398)rn at java.awt.Frame.(Frame.java:363)rn at javax.swing.SwingUtilities$1.(SwingUtilities.java:1623)rn at javax.swing.SwingUtilities.getSharedOwnerFrame(SwingUtilities.java:16rn19)rn at javax.swing.JDialog.(JDialog.java:211)rn at javax.swing.JDialog.(JDialog.java:162)rn at javax.swing.JDialog.(JDialog.java:122)rn at com.gzrealmap.user.user.User.(User.java:51)rn at com.gzrealmap.user.user.User.getInstance(User.java:68)rn at org.apache.jsp.index$jsp._jspService(index$jsp.java:65)rn at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)rn at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspSerrnvlet.java:201)rn at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3rn81)rn at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplrnicationFilterChain.java:247)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFrnilterChain.java:193)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVrnalve.java:243)rn at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelinern.java:566)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.javrna:472)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)rnrn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVrnalve.java:190)rn at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelinern.java:566)rn at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticarntorBase.java:531)rn at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelinern.java:564)rn at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValvern.java:246)rn at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelinern.java:564)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.javrna:472)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)rnrn at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:rn2347)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jrnava:180)rn at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelinern.java:566)rn at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatchernrValve.java:170)rn at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelinern.java:564)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jrnava:170)rn at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelinern.java:564)rn at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:rn468)rn at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelinern.java:564)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.javrna:472)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)rnrn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValrnve.java:174)rn at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipelinern.java:566)rn at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.javrna:472)rn at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)rnrn at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessornr.java:1027)rn at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.jarnva:1125)rn at java.lang.Thread.run(Thread.java:536)rnrnDynamic libraries:rn0x00400000 - 0x00406000 D:\RealOA\jdk1.4\bin\java.exern0x7C920000 - 0x7C9B6000 C:\WINDOWS\system32\ntdll.dllrn0x7C800000 - 0x7C91E000 C:\WINDOWS\system32\kernel32.dllrn0x77DA0000 - 0x77E49000 C:\WINDOWS\system32\ADVAPI32.dllrn0x77E50000 - 0x77EE3000 C:\WINDOWS\system32\RPCRT4.dllrn0x77FC0000 - 0x77FD1000 C:\WINDOWS\system32\Secur32.dllrn0x77BE0000 - 0x77C38000 C:\WINDOWS\system32\MSVCRT.dllrn0x6D330000 - 0x6D45A000 D:\RealOA\jdk1.4\jre\bin\client\jvm.dllrn0x77D10000 - 0x77DA0000 C:\WINDOWS\system32\USER32.dllrn0x77EF0000 - 0x77F39000 C:\WINDOWS\system32\GDI32.dllrn0x76B10000 - 0x76B3A000 C:\WINDOWS\system32\WINMM.dllrn0x76300000 - 0x7631D000 C:\WINDOWS\system32\IMM32.DLLrn0x62C20000 - 0x62C29000 C:\WINDOWS\system32\LPK.DLLrn0x73FA0000 - 0x7400B000 C:\WINDOWS\system32\USP10.dllrn0x6D1D0000 - 0x6D1D7000 D:\RealOA\jdk1.4\jre\bin\hpi.dllrn0x6D300000 - 0x6D30D000 D:\RealOA\jdk1.4\jre\bin\verify.dllrn0x6D210000 - 0x6D229000 D:\RealOA\jdk1.4\jre\bin\java.dllrn0x6D320000 - 0x6D32D000 D:\RealOA\jdk1.4\jre\bin\zip.dllrn0x6D2D0000 - 0x6D2DE000 D:\RealOA\jdk1.4\jre\bin\net.dllrn0x71A40000 - 0x71A4B000 C:\WINDOWS\system32\WSOCK32.dllrn0x71A20000 - 0x71A37000 C:\WINDOWS\system32\WS2_32.dllrn0x71A10000 - 0x71A18000 C:\WINDOWS\system32\WS2HELP.dllrn0x719C0000 - 0x719FE000 C:\WINDOWS\system32\mswsock.dllrn0x638A0000 - 0x638F5000 C:\WINDOWS\system32\hnetcfg.dllrn0x71A00000 - 0x71A08000 C:\WINDOWS\System32\wshtcpip.dllrn0x76EF0000 - 0x76F17000 C:\WINDOWS\system32\DNSAPI.dllrn0x76D30000 - 0x76D48000 C:\WINDOWS\system32\iphlpapi.dllrn0x76F80000 - 0x76F88000 C:\WINDOWS\System32\winrnr.dllrn0x76F30000 - 0x76F5C000 C:\WINDOWS\system32\WLDAP32.dllrn0x76F90000 - 0x76F96000 C:\WINDOWS\system32\rasadhlp.dllrn0x6D000000 - 0x6D0FB000 D:\RealOA\jdk1.4\jre\bin\awt.dllrn0x72F70000 - 0x72F96000 C:\WINDOWS\system32\WINSPOOL.DRVrn0x76990000 - 0x76ACE000 C:\WINDOWS\system32\ole32.dllrn0x65510000 - 0x65547000 C:\WINDOWS\system32\uxtheme.dllrn0x6D180000 - 0x6D1D0000 D:\RealOA\jdk1.4\jre\bin\fontmanager.dllrn0x736D0000 - 0x7371B000 C:\WINDOWS\system32\ddraw.dllrn0x73B30000 - 0x73B36000 C:\WINDOWS\system32\DCIMAN32.dllrn0x6DCA0000 - 0x6DD11000 C:\WINDOWS\system32\D3DIM.DLLrn0x76C60000 - 0x76C88000 C:\WINDOWS\system32\imagehlp.dllrn0x68D60000 - 0x68E01000 C:\WINDOWS\system32\DBGHELP.dllrn0x77BD0000 - 0x77BD8000 C:\WINDOWS\system32\VERSION.dllrn0x76BC0000 - 0x76BCB000 C:\WINDOWS\system32\PSAPI.DLLrnrnLocal Time = Thu May 19 13:54:07 2011rnElapsed Time = 34rn#rn# The exception above was detected in native code outside the VMrn#rn# Java VM: Java HotSpot(TM) Client VM (1.4.1_01-b01 mixed mode)rn#rn# An error report file has been saved as hs_err_pid5972.log.rn# Please refer to the file for further information.rn#rnrnC:\Documents and Settings\Administrator>

换一批

webservices技术难题

09-02

严重: Servlet.service() for servlet AddBookServlet threw exceptionrnjava.lang.NoClassDefFoundError: org/apache/commons/httpclient/Credentialsrn at java.lang.Class.getDeclaredConstructors0(Native Method)rn at java.lang.Class.privateGetDeclaredConstructors(Unknown Source)rn at java.lang.Class.getConstructor0(Unknown Source)rn at java.lang.Class.getConstructor(Unknown Source)rn at org.codehaus.xfire.transport.http.HttpChannel.sendViaClient(HttpChannel.java:108)rn at org.codehaus.xfire.transport.http.XFireServletChannel.send(XFireServletChannel.java:48)rn at org.codehaus.xfire.handler.OutMessageSender.invoke(OutMessageSender.java:26)rn at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131)rn at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:79)rn at org.codehaus.xfire.client.Invocation.invoke(Invocation.java:114)rn at org.codehaus.xfire.client.Client.invoke(Client.java:336)rn at org.codehaus.xfire.client.XFireProxy.handleRequest(XFireProxy.java:77)rn at org.codehaus.xfire.client.XFireProxy.invoke(XFireProxy.java:57)rn at $Proxy0.saveBook(Unknown Source)rn at com.aptech.owerHome.servlet.AddBookServlet.doGet(AddBookServlet.java:74)rn at com.aptech.owerHome.servlet.AddBookServlet.doPost(AddBookServlet.java:87)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)rn at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)rn at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)rn at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)rn at java.lang.Thread.run(Unknown Source)

技术难题

06-21

[code=SQL]rnselect comm_createdby,count(day(comm_createddate)) as ccount,month(comm_createddate) as cmonth,day(comm_createddate)as cdate rnfrom communication where comm_deleted is null rngroup by day(comm_createddate),month(comm_createddate),comm_createdby rn[/code]rnrn[code=HTML]rn我用上面的代码已查出的数据结果是: rncomm_createdby ccount cmonth cdate rn 294 42 4 1 rn 309 80 4 1 rn 177 3 4 1 rn 192 1 4 2 rn ... ... ... ... rnrn意思就是说某人在某天与客户沟通的总次数.rnrn(注:comm_createdby在communication表里,comm_createdby与另一个users表的 rnrnuser_userid有关联,并且每一个comm_createdby(创建人)在users里都有一个user_rolecode角色, rnrn如:comm_createdby是294,它在users表中有一个user_rolecode,值是",AAAB,AAAE,AAAEDD" rnrn comm_createdby是309,它在users表中有一个user_rolecode,值是",AAASS,AAAEE,AAADD" rnrn comm_createdby是177,它在users表中有一个user_rolecode,值是",AABSS,AABEE,AABDD" rnrn comm_createdby是192,它在users表中有一个user_rolecode,值是",AABS,AABE,AAB" rnrn现在规定:凡是user_rolecode里有包含'AAA' 就属于AAA部门了。 rnrn 同理:凡是user_rolecode里有包含'AAB' 就属于AAB部门了。 rnrn 那么294和309就属于AAA部门,177和192就属于AAB部门... rn) rnrn现在我有一个问题:在这面这些代码的基础上,要具体到某个部门在某天与客户沟通的次数. rnrn例如:上面所说的294,309属于AAA部门,这个部门在4月1日与客户沟通的次数为122次. rnrn具体格式为: rn部门 ccount cmonth cday rnAAA部门 122 4 1 rnAAB部门 4 4 1 rn... ... ... ... rnrnrn如何用代码去实现???谢谢rn[/code]

没有更多推荐了,返回首页