亚洲色成人网站www永久,亚洲欧美人成视频一区在线,亚洲国产成人高清在线观看,亚洲精品久久久久久动漫,亚洲国产精品久久电影欧美

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>> 項目開發(fā)用的是javamail做的郵件接收和發(fā)送功能 線下測試都可以（windows),但是到了linux環(huán)境下,不能接收郵件, （在Linux環(huán)境下,寫了個小測試類可以接收,就是跑在服務(wù)里不能接收） debug信息時,小測試類會打印C:NOOP 但是服務(wù)里就不做C:NOOP操作,但是Message[]長度是1,因為有一封郵件 不知哪位大俠遇見過此種現(xiàn)象,多多指教！ 下面是部分代碼

類 MailConfig public static Properties getReceivePro(){ if(receivePro == null) { receivePro = new Properties(); } // 協(xié)議 或者使用imap協(xié)議 可以支持是否為已讀郵件之類的操作 // receivePro.setProperty("mail.store.protocol", "pop3"); // pop3服務(wù)器 公司應(yīng)該使用自己的服務(wù)器地址就ok了 receivePro.put("mail.pop3.host", getString("rec.pop.host")); // 端口 imap的端口為143 receivePro.put("mail.pop3.port", getString("rec.port")); return receivePro; } 類ReceiveMail public static Session getSession() { if(session == null) { Properties props = MailConfig.getReceivePro(); session = Session.getDefaultInstance(props); log.info("mail session==" + session); } return session; } public void receive(List res, Date lastDate) { Session session = getSession(); session.setDebug(true); Store store = null; Folder folder = null; try { store = session.getStore(); store.connect("XXXXX@XXX","XXXX"); // store.connect(MailConfig.getString("rec.pop.host") , // MailConfig.getString("fromMail") , // new String(Base64.decode(MailConfig.getString("fromMail.pwd")))); folder = store.getFolder("INBOX");//POP協(xié)議的話,這里只能是INBOX folder.open(Folder.READ_ONLY);//以只讀方式打開收件箱 parseMessages(folder.getMessages(), res, lastDate); } catch (NoSuchProviderException e) { e.printStackTrace(); } catch (MessagingException e) { e.printStackTrace(); } catch (UnsupportedEncodingException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } finally { try { folder.close(false); store.close(); } catch (MessagingException e) { e.printStackTrace(); } } } public void parseMessages(Message[] messages, List res, Date lastDate) throws MessagingException, IOException { if(messages.length < 1 || messages == null) { log.info("沒有郵件!!!!!"); } else { // String[] fileNameArray = null; // MailInfo tmp = null; log.info(""+messages.length); for(int i = 0; i < messages.length; i++) { MimeMessage each = (MimeMessage) messages[i]; log.info("------------------解析第" + each.getMessageNumber() + "封郵件-------------------- "); log.info("each.getSubject()--" + each.getSubject()); log.info("each.getSubject()--"+each.getFrom()); log.info("each.getSize()--"+each.getSize()); log.info("each.getFrom()--"+each.getFrom()); log.info("each.getSentDate()--" + each.getSentDate()); log.info("主題: " + getSubject(each)); log.info("發(fā)件人: " + getFrom(each)); log.info("收件人：" + getReceiveAddress(each, null)); log.info("發(fā)送時間：" + getSentDate(each, ReceiveMail.DEFAULT_PATTERN)); log.info("是否已讀：" + isSeen(each)); log.info("郵件優(yōu)先級：" + getPriority(each)); log.info("是否需要回執(zhí)：" + isReplySign(each)); log.info("郵件大小：" + each.getSize() + "b"); // if(each.getSentDate().getTime() - lastDate.getTime() < 0) break; boolean isContainerAttachment = isContainAttachment(each); log.info("是否包含附件：" + isContainerAttachment); if (isContainerAttachment) { saveAttachment(each, MailConfig.getString("recMailFilePath")); //保存附件 // fileNameArray = new String[fileNames.size()]; // for(int j = 0;j < fileNames.size(); j++){ // fileNameArray[j] = fileNames.get(j); // } // // tmp = new MailInfo(); // tmp.setSubject(each.getSubject()); // tmp.setContent(each.getContent().toString()); // tmp.setSendDate(each.getSentDate()); // tmp.setAttachFileNames(fileNameArray); // // res.add(tmp); } // StringBuffer content = new StringBuffer(30); // getMailTextContent(each, content); // log.info("郵件正文：" + (content.length() > 100 ? content.substring(0,100) + "..." : content)); log.info("------------------第" + each.getMessageNumber() + "封郵件解析結(jié)束-------------------- "); fileNames.clear(); } } } 到這里就不進(jìn)行了。log.info("主題: " + getSubject(each)); 因為message的subject為空 本地測試,寫的小程序都沒問題,就是部到線上就不行。

錯誤日志（小測試）：
javax.mail.Session@37a1c887 1 ???????1 δ???????1 ????????0 ???????0 DEBUG: setDebug: JavaMail version 1.4ea DEBUG: getProvider() returning javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Sun Microsystems, Inc] DEBUG POP3: connecting to host "pop.263xmail.com", port 110, isSSL false S: +OK Welcome to XMAIL POP3 Server Version 0.0.1 C: USER XXXXXXX S: +OK XMAIL POP3 C: PASS XXXXX S: +OK XMAIL POP3 C: STAT S: +OK 1 30944 C: NOOP S: +OK XMAIL POP3 ------------------??????1?????-------------------- C: TOP 1 0 S: +OK Received: from smtp.263xmail.com (localhost.localdomain [127.0.0.1]) by smtp.263xmail.com (Postfix) with ESMTP id A30201F546 for ; Wed, 1 May 2013 19:45:05 +0800 (CST) X-263anti-spam:KSV:0;

線上日志
2013-05-02 07:41:49,123 INFO [com.dhgate.logistics.mail.ReceiveMail] mail session==javax.mail.Session@17f7be7b Loading javamail.default.providers from jar:file:/usr/local/project/dhgate-logistics-service/dhgate-logistics-impl-1.0-SNAPSHOT/lib/mail-1.4.jar!/META-INF/javamail.default.providers DEBUG: loading new provider protocol=imap, className=com.sun.mail.imap.IMAPStore, vendor=Sun Microsystems, Inc, version=null DEBUG: loading new provider protocol=imaps, className=com.sun.mail.imap.IMAPSSLStore, vendor=Sun Microsystems, Inc, version=null DEBUG: loading new provider protocol=smtp, className=com.sun.mail.smtp.SMTPTransport, vendor=Sun Microsystems, Inc, version=null DEBUG: loading new provider protocol=smtps, className=com.sun.mail.smtp.SMTPSSLTransport, vendor=Sun Microsystems, Inc, version=null DEBUG: loading new provider protocol=pop3, className=com.sun.mail.pop3.POP3Store, vendor=Sun Microsystems, Inc, version=null DEBUG: loading new provider protocol=pop3s, className=com.sun.mail.pop3.POP3SSLStore, vendor=Sun Microsystems, Inc, version=null DEBUG: getProvider() returning provider protocol=pop3; type=javax.mail.Provider$Type@21e30857; class=com.sun.mail.pop3.POP3Store; vendor=Sun Microsystems, Inc DEBUG POP3: connecting to host "pop.263xmail.com", port 110, isSSL false S: +OK Welcome to XMAIL POP3 Server Version 0.0.1 C: USER XXXXX@XXXXX S: +OK XMAIL POP3 C: PASS XXXXXX S: +OK XMAIL POP3 C: STAT S: +OK 1 30944 2013-05-02 07:41:49,328 INFO [com.dhgate.logistics.mail.ReceiveMail] 1 2013-05-02 07:41:49,329 INFO [com.dhgate.logistics.mail.ReceiveMail] null 2013-05-02 07:41:49,330 INFO [com.dhgate.logistics.mail.ReceiveMail] ------------------解析第1封郵件-------------------- 2013-05-02 07:41:49,330 INFO [com.dhgate.logistics.mail.ReceiveMail] C: QUIT S: +OK XMAIL POP3 java.lang.NullPointerException at javax.mail.internet.MimeUtility.decodeText(MimeUtility.java:124) at com.dhgate.logistics.mail.ReceiveMail.getSubject(ReceiveMail.java:467) at com.dhgate.logistics.mail.ReceiveMail.parseMessages(ReceiveMail.java:170) at com.dhgate.logistics.mail.ReceiveMail.receive(ReceiveMail.java:132) at com.dhgate.logistics.job.MailJob.receiveMail(MailJob.java:268) at com.dhgate.logistics.impl.MailJobServiceImpl.doJob(MailJobServiceImpl.java:26) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.dhgate.apsaras.rpc.jbossremoting.JBossRemotingRPCServer$WrapperHandler.invoke(JBossRemotingRPCServer.java:188) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:809) at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:608) at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:406) at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:173) 2013-05-02 07:41:49,358 INFO [com.dhgate.logistics.impl.MailJobServiceImpl] remote invoke ReceiveMailJob end

在線抓狂等！

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
目前使用的是 1.55的android-javamail,登陸是IMAP,調(diào)用的是Folder的AddMessageCountListener,下面上代碼
final IdleManager idleManager = new IdleManager(mSession, mEs); Folder folder = mStore.getFolder("INBOX"); folder.open(Folder.READ_WRITE); folder.addMessageCountListener(new MessageCountAdapter() { public void messagesAdded(MessageCountEvent ev) { Folder folder = (Folder)ev.getSource(); Message[] msgs = ev.getMessages(); System.out.println("Folder: " + folder + " got " + msgs.length + " new messages"); try { // process new messages idleManager.watch(folder); // keep watching for new messages } catch (MessagingException mex) { // handle exception related to the Folder } } }); idleManager.watch(folder);

然后在log中會看到這些log
W/System.err: javax.mail.MessagingException: Folder is not using SocketChannels W/System.err: at com.sun.mail.imap.IdleManager.watch(IdleManager.java:203) W/System.err: at com.ram.testdemo.mail.RMail.listenerFolder(RMail.java:411) W/System.err: at com.ram.testdemo.MailActivity$6.run(MailActivity.java:174) W/System.err: at java.lang.Thread.run(Thread.java:818)
報錯的地方是,這一句
idleManager.watch(folder);

請問有什么解決方案？

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>> 最近使用JavaMail做了一個Web的郵件收發(fā)系統(tǒng),還要求可以刪除郵件服務(wù)器上的郵件,使用了POP3協(xié)議,測試一下網(wǎng)易郵件可以刪除,QQ郵件不可以,不知道大神門有什么解決方案？

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
@紅薯 你好,想跟你請教個問題：
rt,因為供應(yīng)商不慎合作的緣故我要去自己研究,然而只是找到了它html文件,
其中圖片的標(biāo)記是這樣的
網(wǎng)上找了一圈發(fā)現(xiàn)你8年前回了這樣一段話:
"這個東西在附件里都有相應(yīng)標(biāo)識的圖片,你需要程序?qū)@些標(biāo)識進(jìn)行轉(zhuǎn)換,首先把圖片保存到本地,然后把cid這串內(nèi)容替換成圖片的路徑。"
求解,如何根據(jù)這些標(biāo)識轉(zhuǎn)換還原成圖片 代碼民工一枚,有空的話還請?zhí)创a 跪求

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
寫了一個工具類mail,在Test類中的main方法中測試通過,郵件發(fā)送完全ok,但是在項目中用,代碼報錯：
Unable to locate provider for protocol: smtp,說是jar包沖突的問題,但是我測試沒問題的啊,哪位高手碰到過這種問題來幫忙解決下啊

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
項目使用的 Springdata RedisTemplate 操作redis 使用 Jackson2JsonRedisSerializer序列化數(shù)據(jù)
數(shù)據(jù)庫持久層使用jpa,Product與ProductCategory是關(guān)聯(lián)關(guān)系
上圖是序列化后在redis中存儲的數(shù)據(jù)
有的數(shù)據(jù)序列化后 是 ProductCategory_$$_javassist_66 有的是 ProductCategory_$$_javassist_67
我直接操作redis將_$$_javassist_66 改為67后 應(yīng)用程序訪問數(shù)據(jù)就沒有問題了,不然會報錯
javassist和jackson序列化不是很懂,所以我想問知道原理之后,該如何解決這個問題呢

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
jackson 版本：2.8.0
現(xiàn)在有個需求,想把一個對象轉(zhuǎn)成json的時候,把一個字段里面的關(guān)鍵字進(jìn)行替換,比如說
利息 替換成 紅包
然后,我就自定義了一個注解 @JsonSerialize(using = KeywordFilterSerializer.class) @Target({ElementType.ANNOTATION_TYPE, ElementType.FIELD}) @Retention(RetentionPolicy.RUNTIME) @JacksonAnnotationsInside public @interface KeywordFilterSerialize { /** * 需要過濾的關(guān)鍵字 * * @return */ String from(); /** * 顯示成的字符串 * * @return */ String to(); }
public class KeywordFilterSerializer extends JsonSerializer { private String from = "利息"; private String to = "紅包"; @Override public void serialize(String value, JsonGenerator gen, SerializerProvider serializers) throws IOException { gen.writeString(value == null ? null : value.replace(keyword, to)); } }

現(xiàn)在的問題是：如何在KeywordFilterSerializer類里面,拿到注解里面定義的from , to參數(shù)。然后進(jìn)行替換

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
服務(wù)器返回的json格式,比常見的多了一個Tag節(jié)點(diǎn) { 'tags': [{ 'Tag': { 'id': 'red', 'name': 'red' } }, { 'Tag': { 'id': 'cool', 'name': 'cool' } }, { 'Tag': { 'id': 'shoe', 'name': 'shoe' } } ] }
jackson jsonToBean方法
public static T fromJson(String json,Class clazz, boolean withRoot) throws Exception{ if(StringUtils.isBlank(json)){ return clazz.newInstance(); } ObjectMapper mapper = new ObjectMapper(); mapper.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES,false); JsonNode jsonNode = mapper.readTree(json); if(withRoot){ JsonRootName jsonRootName = clazz.getAnnotation(JsonRootName.class); if(jsonRootName!=null){ String rootName = jsonRootName.value(); jsonNode = jsonNode.path(rootName); } } T t = mapper.readValue(jsonNode.toString(), clazz); return t; }

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>> Exception javax.servlet.ServletException: Servlet.init() for servlet [seckillDispatcher] threw exception org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) java.lang.Thread.run(Thread.java:745) Root Cause org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter': Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: com/fasterxml/jackson/databind/exc/InvalidDefinitionException org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1231) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1130) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502) org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312) org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310) org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:756) org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868) org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:676) org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:642) org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:690) org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:558) org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:499) org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:172) javax.servlet.GenericServlet.init(GenericServlet.java:158) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) java.lang.Thread.run(Thread.java:745) Root Cause org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: com/fasterxml/jackson/databind/exc/InvalidDefinitionException org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:175) org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:88) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1223) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1130) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502) org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312) org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310) org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:756) org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868) org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:676) org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:642) org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:690) org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:558) org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:499) org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:172) javax.servlet.GenericServlet.init(GenericServlet.java:158) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) java.lang.Thread.run(Thread.java:745) Root Cause java.lang.NoClassDefFoundError: com/fasterxml/jackson/databind/exc/InvalidDefinitionException org.springframework.http.converter.support.AllEncompassingFormHttpMessageConverter.(AllEncompassingFormHttpMessageConverter.java:67) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.(RequestMappingHandlerAdapter.java:190) sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:422) org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:163) org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:88) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1223) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1130) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502) org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312) org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310) org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:756) org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868) org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:676) org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:642) org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:690) org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:558) org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:499) org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:172) javax.servlet.GenericServlet.init(GenericServlet.java:158) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) java.lang.Thread.run(Thread.java:745) Root Cause java.lang.ClassNotFoundException: com.fasterxml.jackson.databind.exc.InvalidDefinitionException org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1291) org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119) org.springframework.http.converter.support.AllEncompassingFormHttpMessageConverter.(AllEncompassingFormHttpMessageConverter.java:67) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.(RequestMappingHandlerAdapter.java:190) sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:422) org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:163) org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:88) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1223) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1130) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502) org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312) org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310) org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:756) org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868) org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:676) org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:642) org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:690) org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:558) org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:499) org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:172) javax.servlet.GenericServlet.init(GenericServlet.java:158) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) java.lang.Thread.run(Thread.java:745)

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
exception is com.fasterxml.jackson.core.JsonParseException: Unexpected character ('i' (code 105)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')
無論我提交的是雙引號,如下,還是單引號都報上面的異常
var params = {"id":"123","name":"zj"};
然后我改了配置 application/json;charset=UTF-8

public class CustomObjectMapper extends ObjectMapper{ public CustomObjectMapper(){ super(); this.configure(JsonParser.Feature.ALLOW_SINGLE_QUOTES,true); } }
就算我換成默認(rèn)的


并且提交的數(shù)據(jù)也是雙引號,問題依舊！

what the fuck? 大神求救?。。。。。。。。。。。。?！

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
在回復(fù)微信公眾號的圖文消息時,jackson解析出的xml格式出現(xiàn)錯誤,錯誤結(jié)果如下：
怎么才能 讓item標(biāo)簽出現(xiàn)一層 就可以。實體類的代碼如下： @JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.NONE) public class item { @JacksonXmlProperty private String Title; @JacksonXmlProperty private String Description; @JacksonXmlProperty private String PicUrl; @JacksonXmlProperty private String Url; public item(String title, String description, String picUrl, String url) { Title = title; Description = description; PicUrl = picUrl; Url = url; } } @JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.NONE) @JsonRootName("Articles") public class Articles { @JacksonXmlProperty private List item; public Articles(List item) { this.item = item; } } /** * Created by WangShiXiang on 2017/3/9. * 圖文消息 */ @JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.NONE) @JsonRootName("xml") public class NewsRespMessage { @JacksonXmlProperty private String ToUserName; @JacksonXmlProperty private String FromUserName; @JacksonXmlProperty private int CreateTime; @JacksonXmlProperty private String MsgType; @JacksonXmlProperty private int ArticleCont; @JacksonXmlProperty private Articles Articles; public NewsRespMessage(String toUserName, String fromUserName, int createTime, String msgType, int articleCont, com.example.entity.media.Articles articles) { ToUserName = toUserName; FromUserName = fromUserName; CreateTime = createTime; MsgType = msgType; ArticleCont = articleCont; Articles = articles; } }

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
原本使用@ResponseBody返回json數(shù)據(jù),但由于需要使用jackson-dataformat-xml包（該包還依賴jackson-module-jaxb-annotations）,結(jié)果所有response都變成了xml。只要去掉這2個包,就正常了。
看了一下RequestMappingHandlerAdapter源碼
以下是默認(rèn)的構(gòu)造函數(shù),添加了 幾個 默認(rèn)的converter public RequestMappingHandlerAdapter() { StringHttpMessageConverter stringHttpMessageConverter = new StringHttpMessageConverter(); stringHttpMessageConverter.setWriteAcceptCharset(false); // see SPR-7316 this.messageConverters = new ArrayList>(4); this.messageConverters.add(new ByteArrayHttpMessageConverter()); this.messageConverters.add(stringHttpMessageConverter); this.messageConverters.add(new SourceHttpMessageConverter()); this.messageConverters.add(new AllEncompassingFormHttpMessageConverter()); }
最后一行內(nèi)部如下：根據(jù)項目情況,jaxb2Present==true,jackson2Present=true,jackson2XmlPresent=true,gsonPresent=false public AllEncompassingFormHttpMessageConverter() { addPartConverter(new SourceHttpMessageConverter()); if (jaxb2Present && !jackson2Present) { addPartConverter(new Jaxb2RootElementHttpMessageConverter()); } if (jackson2Present) { addPartConverter(new MappingJackson2HttpMessageConverter()); } else if (gsonPresent) { addPartConverter(new GsonHttpMessageConverter()); } if (jackson2XmlPresent) { addPartConverter(new MappingJackson2XmlHttpMessageConverter()); } }


所以,看樣子是MappingJackson2HttpMessageConverter和MappingJackson2XmlHttpMessageConverter同時都有了。但怎么能禁止xml視圖,只返回json呢？
以下是spring配置文件中的內(nèi)容 < annotation-driven /> application/json;charset=UTF-8 text/plain;charset=UTF-8

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>> public class CustomExport { private String query; private String queryFilter; private String[] selectedColumns; private String[] selectedAttrs; private List customColumnList; public class CustomColumn { /*自定義列ID*/ private String columnId; /*自定義列名*/ private String columnName; /*篩選方式*/ private String filterType; /*篩選字段*/ private List filterField; /*關(guān)鍵字,篩選方式為關(guān)鍵字時用到*/ private String keywords; /*表達(dá)式,篩選方式為表達(dá)式時用到*/ private String regex;

CustomExport customExport = objectMapper.readValue( , javaType);

如何將獲取到的json直接轉(zhuǎn)化成類CustomExport的對象 不知如何構(gòu)建這種javaType

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
【統(tǒng)計】請問大家現(xiàn)在是Jackson1.x的多還是Jackson2.x的多？
剛剛研究了一下Jackson1.9.11版本的,結(jié)果發(fā)現(xiàn)Jackson都已經(jīng)出來2.x的版本了,搜索網(wǎng)上很多教程都還是1.x的,請問大家現(xiàn)在使用的什么版本,使用2.x的童鞋比1.x有那些好處？
2.x的版本能支持springmvc ajax文件上傳@responseBody 返回中的contentType=“text/html”嗎（之前1.X）的版本ajax文件上傳返回的json IE瀏覽器不認(rèn)“application/json”,只好手動轉(zhuǎn)化json之后加入contentType="text/html"才行。

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
原本使用@ResponseBody返回json數(shù)據(jù),但由于需要使用jackson-dataformat-xml包（該包還依賴jackson-module-jaxb-annotations）,結(jié)果所有response都變成了xml。只要去掉這2個包,就正常了。
看了一下RequestMappingHandlerAdapter源碼
以下是默認(rèn)的構(gòu)造函數(shù),添加了 幾個 默認(rèn)的converter public RequestMappingHandlerAdapter() { StringHttpMessageConverter stringHttpMessageConverter = new StringHttpMessageConverter(); stringHttpMessageConverter.setWriteAcceptCharset(false); // see SPR-7316 this.messageConverters = new ArrayList>(4); this.messageConverters.add(new ByteArrayHttpMessageConverter()); this.messageConverters.add(stringHttpMessageConverter); this.messageConverters.add(new SourceHttpMessageConverter()); this.messageConverters.add(new AllEncompassingFormHttpMessageConverter()); }
最后一行內(nèi)部如下：根據(jù)項目情況,jaxb2Present ==true,jackson2Present=true,jackson2XmlPresent=true,gsonPresent=false public AllEncompassingFormHttpMessageConverter() { addPartConverter(new SourceHttpMessageConverter()); if (jaxb2Present && !jackson2Present) { addPartConverter(new Jaxb2RootElementHttpMessageConverter()); } if (jackson2Present) { addPartConverter(new MappingJackson2HttpMessageConverter()); } else if (gsonPresent) { addPartConverter(new GsonHttpMessageConverter()); } if (jackson2XmlPresent) { addPartConverter(new MappingJackson2XmlHttpMessageConverter()); } }


所以,看樣子是MappingJackson2HttpMessageConverter和MappingJackson2XmlHttpMessageConverter同時都有了。但怎么能禁止xml視圖,只返回json呢？
以下是spring配置文件中的內(nèi)容 < annotation-driven /> application/json;charset=UTF-8 text/plain;charset=UTF-8

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
前臺使用的是Jquery發(fā)送一個請求給后臺的SpringMVC的Controller方法,傳遞一個參數(shù)： $(function(){ $("#usid").click(function(){ var value=$("#usids").val(); $.ajax({ Type:"GET", url:"lianxirens/cx1.do?method="+value, dataType:"json", success:function(data){ alert(data); }, error:function(){ alert("NO"); } }); }); });

后臺使用的是SpringMVC,Controller方法中根據(jù)傳過來的id查詢出集合并返回,這里我使用了@responsebody注解,以及使用jackson的包自動將集合轉(zhuǎn)化成json并寫入輸出流：（該方法已測試,list有值,查詢沒問題）@RequestMapping("cx1") @ResponseBody public List getLianxiren(@RequestParam(required=false,value="method")String usid, HttpServletResponse response) throws IOException{ List list=imp.getByUsid(Integer.parseInt(usid)); System.out.println(list.size()); return list; }
我彈出來的結(jié)果怎么是這樣：
為什么呢？？？？？？

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
先貼代碼
ObjectMapper objectMapper = new ObjectMapper();
Object v2 = objectMapper.writeValueAsString(new int []{1,2,3,4});
Map map = new HashMap<>();
map.put("k1", "v1");
map.put("k2", v2);
System.out.println(objectMapper.writeValueAsString(map));
輸出值為：{"k1":"v1","k2":"[1,2,3,4]"}
我想要的輸出值為： {"k1":"v1","k2":[1,2,3,4]}
因為v2可以直接解析出json格式,下游而不是轉(zhuǎn)義字符串,在進(jìn)行解析,這個問題該怎么破,
知道解決方法的求告知。
不要告訴我,將v2直接替換成 new int []{1,2,3,4} ,這是封裝好的方法,v2是參數(shù)傳進(jìn)來的,只能用object來接收

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
求教～～
代碼如下 try { XmlMapper xmlMapper = new XmlMapper(); return xmlMapper.writeValueAsString(object); } catch(JsonProcessingException e) { e.printStackTrace(); return null; }
在Tomcat下正常,在WildFly下報錯 16:05:40,231 ERROR [stderr] (ServerService Thread Pool -- 28) Caused by: java.lang.NoSuchMethodError: com.fasterxml.jackson.databind.SerializationConfig.withDefaultPrettyPrinter(Lcom/fasterxml/jackson/core/PrettyPrinter;)Lcom/fasterxml/jackson/databind/SerializationConfig; 16:05:40,231 ERROR [stderr] (ServerService Thread Pool -- 28) at com.fasterxml.jackson.dataformat.xml.XmlMapper.(XmlMapper.java:86) 16:05:40,231 ERROR [stderr] (ServerService Thread Pool -- 28) at com.fasterxml.jackson.dataformat.xml.XmlMapper.(XmlMapper.java:67) 16:05:40,231 ERROR [stderr] (ServerService Thread Pool -- 28) at com.fasterxml.jackson.dataformat.xml.XmlMapper.(XmlMapper.java:49) 16:05:40,231 ERROR [stderr] (ServerService Thread Pool -- 28) at cn.sel.cap_demo.plugin.XmlViewer1.(XmlViewer1.java:10)

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
springboot連接sqlserver
測試數(shù)據(jù)庫是通的,連接地址里含有SQLEXPRESS,編譯打包時報錯,怎么辦

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
運(yùn)用python批量更新sql sever數(shù)據(jù)庫代碼如下： import pymssql conn = pymssql.connect('WIN-HNJVLQK', 'sa', '123456', 'test3') cursor = conn.cursor() b = [(0.6339473553468321, 43628.0), (0.6128462794465829, 43604.0), (0.4889203748589221, 43600.0), (0.4162643710139807, 43602.0), (0.4098517090899294, 43658.0), (0.36492885266125263, 43595.0), ] j=0 while j出錯信息：ProgrammingError: (207, b"Invalid column name 'RSSID_new'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
開發(fā)服務(wù)器上的數(shù)據(jù)庫由原來的SQL SERVER 2008 切換到了SQL SERVER 2014 發(fā)現(xiàn)后臺的查詢比較慢。日志中打印出查詢語句,返回結(jié)果都需要7-8秒左右等待。
從哪個方面入手去查看這個問題。

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
是這樣的,這是一個薪酬管理系統(tǒng),如圖的藍(lán)色方框的表由幾個紅色方框的表連表計算出來的,是一個結(jié)果表。我想問的是那紅色表應(yīng)該與其他表連上關(guān)系線嗎？

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
代碼如下：
import java.sql.*; public class ShowSql { public static void main(String[] args) { String url = "jdbc:sqlserver://localhost:1433;DatabaseName=hah"; Connection conn=null; Statement st = null; ResultSet rs = null; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); System.out.println("loading success!"); conn = DriverManager.getConnection(url,"sa","admin"); System.out.println("conn success!"); st = conn.createStatement(); rs=st.executeQuery("select top 10 * from Group2"); while(rs.next()){ System.out.println(rs.getString("name")); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } }
報錯如下：

"C:\Program Files\Java\jdk-9.0.1\bin\java" "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar=11045:C:\Program Files\JetBrains\IntelliJ IDEA 2017.2.5\bin" -Dfile.encoding=UTF-8 -classpath "D:\Iproject\TestWeb\web\WEB-INF\classes;D:\JAVA\apache-tomcat-9.0.2\lib\servlet-api.jar;E:\SQL\jdbc\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\chs\jre8\sqljdbc42.jar" ShowSql
loading success!
Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4098)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3160)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:43)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3123)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1981)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:678)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:229)
at ShowSql.main(ShowSql.java:12)
Caused by: java.lang.ClassNotFoundException: javax.xml.bind.DatatypeConverter
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:582)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:185)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:496)
... 14 more
Process finished with exit code 1

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
SqlServer數(shù)據(jù)庫如果當(dāng)記錄不存在時insert,當(dāng)記錄存在時update語句怎么寫,

表名inst如果字段name不存在就插入一條數(shù)據(jù)（name=jhon price=12.36 date=2017-04-10 09:30:21）,如果存在就更新price和date兩個字段, ----------------菜鳥求助


JDBC連接數(shù)據(jù)庫

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
最近需要將Excel文件中3000多條數(shù)據(jù)中的幾列導(dǎo)入到SqlServer數(shù)據(jù)庫,由于以前沒做過,所以請教各位大神

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
環(huán)境 maven＋spring + mybatis3.2.6 + activiti5.21.0 ＋sqlserver2005
public void test() { ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine(); Deployment deployment = processEngine.getRepositoryService() .createDeployment() .name("helloworld入門程序") .addClasspathResource("repository/TestProcess.bpmn") .addClasspathResource("repository/TestProcess.png") .deploy(); }


環(huán)境沒問題,都能運(yùn)行：用戶、組、Task 都能操作,我嘗試部署流程的時候數(shù)據(jù)庫插入出錯
意思好像是參數(shù)設(shè)置出錯,為什么呀,要怎么辦,是數(shù)據(jù)庫不支持嗎,還是mybatis版本問題,或者是activiti版本太新了。
DEBUG - ==> Preparing: INSERT INTO ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_) VALUES (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) DEBUG - ==> Parameters: 27502(String), repository/TestProcess.png(String), java.io.ByteArrayInputStream@7ffc6e23(ByteArrayInputStream), 27501(String), false(Boolean), 27503(String), repository/TestProcess.bpmn(String), java.io.ByteArrayInputStream@15a2fd7a(ByteArrayInputStream), 27501(String), false(Boolean) DEBUG - Error while closing command context org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: ',' 附近有語法錯誤。 ### The error may involve org.activiti.engine.impl.persistence.entity.ResourceEntity.bulkInsertResource-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_) VALUES (?, 1, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?) ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: ',' 附近有語法錯誤。 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:154) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:141) at org.activiti.engine.impl.db.DbSqlSession.flushBulkInsert(DbSqlSession.java:850) at org.activiti.engine.impl.db.DbSqlSession.flushPersistentObjects(DbSqlSession.java:820) at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:797) at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:618) at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:212) at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:138) at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66) at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133) at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45) at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35) at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:79) at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:156) at test.Test.test(Test.java:36) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at org.junit.runner.JUnitCore.run(JUnitCore.java:160) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69) at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:234) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:74) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: ',' 附近有語法錯誤。 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:62) at com.sun.proxy.$Proxy32.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152) … 44 more


求大神們給點(diǎn)意見。數(shù)據(jù)庫應(yīng)該不能換了,公司用的。

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
比如我有一些1-1000的數(shù)字,分別是1,6,7,8,14,15,20。。。。。等等
現(xiàn)在想統(tǒng)計數(shù)字差值在5以內(nèi)的有多少個,比如1和6差別在5以內(nèi),有2個,6和7,8差別在5以內(nèi),再增加兩個,14和15差別在5以內(nèi)有兩個,再統(tǒng)計兩個等等
實際的業(yè)務(wù)需求就是：一個用戶一天登錄的次數(shù)可能有幾十次,每次登錄都會有一個'YYYY-MM-DD HH????ss'格式的時間,現(xiàn)在想統(tǒng)計每個用戶在5分鐘內(nèi)連續(xù)的行為有多少次以及所有登錄次數(shù)中,有多少個是同一個用戶在連續(xù)5分鐘內(nèi)登錄的

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
兩個進(jìn)程,每個進(jìn)程中有一個線程往SQL Server的表A中insert記錄,但要求整張表A中的字段a是順序遞增的
也就是1、2、3、4、5、6……
有什么辦法能在盡可能少用鎖,盡可能不過分影響性能的情況下解決這個需求？
用了identity關(guān)鍵字建表,在單線程的情況下OK,但在并發(fā)情況下并不能保證嚴(yán)格順序遞增！

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
對于sql, 多個表進(jìn)行連接(外連接和內(nèi)連接), 是先進(jìn)行篩選出每個表中需要的內(nèi)容, 再將這些篩選出的表進(jìn)行外連接比較好,還是先直接將幾個表進(jìn)行連接,最后在where里面進(jìn)行條件篩選比較好呢?
舉例A
selet a.*,b.* from tab1 a,tab2 b where a.Id = b.ReferenceID a.name = "apple" andb.name="banana" 舉例B
select a.* ,b.* from ( select * from tab1 where name='apple' ) a, (select * from tab2 where name='banana') b on a.ID = b.referenceID

這兩種查詢方式 哪種比較好呢? 考慮到數(shù)據(jù)很多的時候, 哪種比較省時間?

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>>
剛安裝的sql server2012,有一些navicat連接問題。
目前通過localhost\sqlexpress這個ip可以連接,而直接用localhost則不可以連接
然后在程序(mybatis整合spring)中就不知道怎么配置jdbcUrl了,試了下
jdbc:sqlserver://localhost:1433;DatabaseName=testdb
jdbc:sqlserver://localhost\sqlexpress:1433;DatabaseName= testdb

jdbc:sqlserver://localhost:1433;DatabaseName= testdb :instanceName=sqlexpress
都連接不上,這問現(xiàn)在改怎么解決？
如何才能將實例名省略？或者該如何配置實例到url上？

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>> 有一站表content內(nèi)容表,表里有個release_date 發(fā)布時間字段,現(xiàn)在想要查出一周內(nèi)和一個月內(nèi)發(fā)布的content記錄要怎么寫,求大神搭救

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>> 今年剛剛畢業(yè),進(jìn)入公司開始學(xué)數(shù)據(jù)庫,基本上做的都是提數(shù)和維護(hù)數(shù)據(jù)庫的事。其他部門沒提需求的話就有些不知道該學(xué)些什么。我想請教一下要在數(shù)據(jù)庫這方面更精通的話,該怎么學(xué)習(xí)？

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>> 一年Java開發(fā)經(jīng)驗,做過一些小型項目,Java基礎(chǔ)比較扎實。現(xiàn)在工作遇到瓶頸,想要學(xué)習(xí)關(guān)于數(shù)據(jù)結(jié)構(gòu)方面的知識,但是這方面的書籍眾多,不知道哪一種書籍對學(xué)習(xí)更為有利。

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>> java取sqlserver中的大字段image,拿到它的byte的數(shù)組,然后用文件流輸入到txt,txt亂碼,為什么會亂碼？怎么解決亂碼？

HDC調(diào)試需求開發(fā)（15萬預(yù)算）,能者速來！>>> android studio新建一個項目運(yùn)行是沒報錯,但添加了sqljdbc.jar驅(qū)動包后就報錯了？？Failure[INSTALL_PARSE_FAILED_NO_CERTIFICATES], 網(wǎng)上查是簽名錯誤我也手動添加簽名了但還是沒用。