API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 30th, 2017
288
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.80 KB | None | 0 0
raw download clone embed print report
  1. org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  2. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)
  3. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  4. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  5. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  6. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:102)
  7. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:129)
  8. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getConnectionForTransactionManagement(LogicalConnectionManagedImpl.java:247)
  9. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.begin(LogicalConnectionManagedImpl.java:254)
  10. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.begin(JdbcResourceLocalTransactionCoordinatorImpl.java:203)
  11. at org.hibernate.engine.transaction.internal.TransactionImpl.begin(TransactionImpl.java:56)
  12. at org.hibernate.internal.AbstractSharedSessionContract.beginTransaction(AbstractSharedSessionContract.java:397)
  13. at com.dao.episode.EpisodeDAOImpl.addEpisode(EpisodeDAOImpl.java:51)
  14. at com.dao.episode.EpisodeServiceImpl.addEpisode(EpisodeServiceImpl.java:16)
  15. at com.bascon.HelloController.addEpisodeAction(HelloController.java:133)
  16. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  17. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  18. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  19. at java.lang.reflect.Method.invoke(Unknown Source)
  20. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  21. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
  22. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
  23. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
  24. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
  25. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  26. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
  27. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
  28. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  29. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
  30. at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  31. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  32. at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  33. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  34. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  35. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  36. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  37. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  38. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
  39. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  40. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
  41. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  42. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  43. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
  44. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  45. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
  46. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
  47. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  48. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:745)
  49. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1437)
  50. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  51. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  52. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  53. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  54. at java.lang.Thread.run(Unknown Source)
  55. Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  56.  
  57. The last packet successfully received from the server was 90 830 milliseconds ago. The last packet sent successfully to the server was 14 milliseconds ago.
  58. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  59. at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  60. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  61. at java.lang.reflect.Constructor.newInstance(Unknown Source)
  62. at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
  63. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988)
  64. at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3552)
  65. at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3452)
  66. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3893)
  67. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
  68. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
  69. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
  70. at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4842)
  71. at org.hibernate.engine.jdbc.connections.internal.PooledConnections.poll(PooledConnections.java:84)
  72. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:186)
  73. at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
  74. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:99)
  75. ... 48 more
  76. Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
  77. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3004)
  78. at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3462)
  79. ... 58 more
  80.  
  81. <?xml version="1.0" encoding="UTF-8"?>
  82. <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  83. "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
  84. <hibernate-configuration>
  85. <session-factory name="session">
  86. <property name="hibernate.connection.charSet">utf8</property>
  87. <property name="hibernate.connection.characterEncoding">utf8</property>
  88. <property name="hibernate.connection.useUnicode">true</property>
  89. <property name="hibernate.enable_lazy_load_no_trans">true</property>
  90. <property name="hibernate.current_session_context_class">thread</property>
  91. <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  92. <property name="hibernate.connection.password">ac8c4d10</property>
  93. <property name="hibernate.connection.url">jdbc:mysql://us-cdbr-iron-east-03.cleardb.net/heroku_7975f769758d9fa?reconnect=true?UseUnicode=yes&characterEncoding=utf8</property>
  94. <property name="hibernate.connection.username">bf529a773566a9</property>
  95. <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  96. <property name="show_sql">true</property>
  97. <property name="hibernate.id.new_generator_mappings">false</property>
  98. <mapping class="com.model.Comment"/>
  99. <mapping class="com.model.Image"/>
  100. <mapping class="com.model.Episode"/>
  101. </session-factory>
  102. </hibernate-configuration>
  103.  
  104. package com.dao.episode;
  105.  
  106. import java.util.ArrayList;
  107. import java.util.List;
  108.  
  109. import javax.persistence.Query;
  110.  
  111. import org.hibernate.Session;
  112. import org.hibernate.SessionFactory;
  113. import org.hibernate.Transaction;
  114. import org.hibernate.cfg.Configuration;
  115.  
  116. import com.model.Comment;
  117. import com.model.Episode;
  118.  
  119. public class EpisodeDAOImpl implements EpisodesDAO {
  120.  
  121. SessionFactory sessionFactory = new Configuration().configure("hibernate.cfg.xml").addAnnotatedClass(Episode.class).buildSessionFactory();
  122.  
  123. public List<Episode> getAllEpisodes(int page) {
  124.  
  125. int first = 0;
  126.  
  127. for (int i=1;i<page;i++) {
  128. first = first + 10;
  129. }
  130.  
  131. Session sess = sessionFactory.openSession();
  132. Transaction tx = null;
  133. List<Episode> eps = new ArrayList<Episode>();
  134. try {
  135. tx = sess.beginTransaction();
  136. Query query = sess.createQuery("FROM Episode");
  137. query.setFirstResult(first);
  138. query.setMaxResults(10);
  139. eps = query.getResultList();
  140. } catch (Exception e) {
  141. tx.rollback();
  142. e.printStackTrace();
  143. } finally {
  144. sess.close();
  145. }
  146. return eps;
  147. }
  148.  
  149. public void addEpisode(Episode episode) {
  150. Session sess = sessionFactory.openSession();
  151. Transaction tx = null;
  152.  
  153. try {
  154. tx = sess.beginTransaction();
  155. sess.save(episode);
  156. tx.commit();
  157. } catch (Exception e) {
  158. e.printStackTrace();
  159. } finally {
  160. sess.close();
  161. }
  162.  
  163. }
  164.  
  165. public void deleteEpisode(int id) {
  166. Session sess = sessionFactory.openSession();
  167. Transaction tx = null;
  168.  
  169. try {
  170. tx = sess.beginTransaction();
  171. Episode com = sess.load(Episode.class, id);
  172. if (null != com) {
  173. sess.delete(com);
  174. }
  175. } catch (Exception e) {
  176. e.printStackTrace();
  177. tx.rollback();
  178. } finally {
  179. sess.close();
  180. }
  181. }
  182.  
  183. public Episode getEpisode(int id) {
  184.  
  185. Episode eps = null;
  186. Session sess = sessionFactory.openSession();
  187. Transaction tx = null;
  188. try {
  189. tx = sess.beginTransaction();
  190. eps = sess.load(Episode.class, id);
  191. } catch (Exception e) {
  192. tx.rollback();
  193. e.printStackTrace();
  194. } finally {
  195. sess.close();
  196. }
  197.  
  198. return eps;
  199. }
  200.  
  201. public long getCount() {
  202. Session sess = sessionFactory.openSession();
  203. Transaction tx = null;
  204. long i = 0;
  205. try {
  206. tx = sess.beginTransaction();
  207. i = (Long) sess.createQuery("select count(*) from Episode").uniqueResult();
  208. } catch (Exception e) {
  209. e.printStackTrace();
  210. } finally {
  211. sess.close();
  212. }
  213. return i;
  214. }
  215.  
  216. }
  217.  
  218. package com.model;
  219.  
  220. import java.util.Date;
  221.  
  222. import javax.persistence.Column;
  223. import javax.persistence.Entity;
  224. import javax.persistence.GeneratedValue;
  225. import javax.persistence.Id;
  226. import javax.persistence.Table;
  227. import javax.validation.constraints.Max;
  228. import javax.validation.constraints.Min;
  229. import javax.validation.constraints.NotNull;
  230. import javax.validation.constraints.Size;
  231.  
  232. @Entity
  233. @Table(name = "episodes_table")
  234. public class Episode {
  235.  
  236. @Id
  237. @GeneratedValue
  238. @Column(name = "episode_id")
  239. private int id;
  240.  
  241. @Column(name = "episode_title")
  242. @NotNull
  243. @Size(min = 5, max = 30)
  244. private String title;
  245.  
  246. @Column(name = "episode_link")
  247. @NotNull
  248. @Size(max = 100)
  249. private String link;
  250.  
  251. @Column(name = "episode_desc")
  252. @NotNull
  253. @Size(min = 5, max = 300)
  254. private String desc;
  255.  
  256. @Column(name = "upload_data")
  257. private Date date;
  258.  
  259. public int getId() {
  260. return id;
  261. }
  262. public void setId(int id) {
  263. this.id = id;
  264. }
  265. public String getTitle() {
  266. return title;
  267. }
  268. public void setTitle(String title) {
  269. this.title = title;
  270. }
  271. public String getLink() {
  272. return link;
  273. }
  274. public void setLink(String link) {
  275. this.link = link;
  276. }
  277. public Date getDate() {
  278. return date;
  279. }
  280. public void setDate(Date date) {
  281. this.date = date;
  282. }
  283.  
  284. public Episode(String title, String link,String desc, Date date) {
  285. this.title = title;
  286. this.link = link;
  287. this.desc = desc;
  288. this.date = date;
  289. }
  290.  
  291. public Episode() {
  292. this.date = new Date();
  293. }
  294. public String getDesc() {
  295. return desc;
  296. }
  297. public void setDesc(String desc) {
  298. this.desc = desc;
  299. }
  300.  
  301.  
  302.  
  303. }
  304.  
  305. package com.bascon;
  306.  
  307. import java.io.File;
  308. import java.io.IOException;
  309. import java.io.UnsupportedEncodingException;
  310. import java.sql.Blob;
  311. import java.util.ArrayList;
  312. import java.util.Date;
  313. import java.util.List;
  314.  
  315. import javax.servlet.ServletContext;
  316.  
  317. import org.apache.log4j.Logger;
  318. import org.hibernate.Hibernate;
  319. import org.jboss.logging.Param;
  320. import org.springframework.beans.factory.annotation.Autowired;
  321. import org.springframework.beans.support.PagedListHolder;
  322. import org.springframework.stereotype.Controller;
  323. import org.springframework.ui.ModelMap;
  324. import org.springframework.util.FileCopyUtils;
  325. import org.springframework.validation.BindingResult;
  326. import org.springframework.validation.annotation.Validated;
  327. import org.springframework.web.bind.annotation.GetMapping;
  328. import org.springframework.web.bind.annotation.ModelAttribute;
  329. import org.springframework.web.bind.annotation.PathVariable;
  330. import org.springframework.web.bind.annotation.PostMapping;
  331. import org.springframework.web.bind.annotation.RequestAttribute;
  332. import org.springframework.web.bind.annotation.RequestMapping;
  333. import org.springframework.web.bind.annotation.RequestMethod;
  334. import org.springframework.web.bind.annotation.RequestParam;
  335. import org.springframework.web.multipart.MultipartFile;
  336. import org.springframework.web.servlet.ModelAndView;
  337.  
  338. import com.dao.comment.CommentService;
  339. import com.dao.comment.CommentServiceImpl;
  340. import com.dao.episode.EpisodeServiceImpl;
  341. import com.dao.image.ImageServiceImpl;
  342. import com.model.Comment;
  343. import com.model.Episode;
  344. import com.model.Image;
  345. import com.validation.EpisodeValidation;
  346.  
  347. @Controller
  348. public class HelloController {
  349.  
  350. @Autowired
  351. ServletContext context;
  352.  
  353. @Autowired
  354. EpisodeValidation epsiodeValidator;
  355.  
  356. private static final Logger logger = Logger.getLogger(HelloController.class);
  357.  
  358. //Три сервиса для работы с базой данных
  359. CommentServiceImpl commentService = new CommentServiceImpl();
  360. EpisodeServiceImpl episodeService = new EpisodeServiceImpl();
  361. ImageServiceImpl imageService = new ImageServiceImpl();
  362.  
  363. //Приветственная страница
  364. @RequestMapping(value = "/", method = RequestMethod.GET)
  365. public ModelAndView Welcome(){
  366. ModelAndView md = new ModelAndView("Hello");
  367.  
  368. String rick = "https://www.youtube.com/embed/AqT-MJnbePM";
  369. String title = "Добро пожаловать на мой сайт о Madness Combat";
  370. md.addObject("title", title);
  371. md.addObject("rick",rick);
  372.  
  373. return md;
  374. }
  375.  
  376. //Игра в Project Nexus
  377. @RequestMapping(value = "/playNexus", method = RequestMethod.GET)
  378. public ModelAndView PlayNexus(){
  379. ModelAndView md = new ModelAndView("Nexus");
  380.  
  381. Comment come = new Comment();
  382.  
  383. String title = "Здесь вы можеть сыграть в Madness Project Nexus";
  384. String link = "http://www.newgrounds.com/portal/view/592473";
  385.  
  386. md.addObject("title", title);
  387. md.addObject("link",link);
  388.  
  389. return md;
  390. }
  391.  
  392. //Форма с добавлением эпизодов
  393. @RequestMapping(value = "/addEpisode", method = RequestMethod.GET)
  394. public ModelAndView AddEpisode(){
  395. ModelAndView md = new ModelAndView("AddEpisode");
  396. String title = "Добавить новый эпизод";
  397. String but = "Загрузить";
  398.  
  399.  
  400. String titlePlac = "Напишите название файла здесь";
  401. String linkPlac = "Ссылка должна содержать https://www.youtube.com/embed/";
  402. String descPlac = "Введите описание здесь";
  403.  
  404. Episode episode = new Episode();
  405.  
  406. md.addObject("episode",episode);
  407. md.addObject("title",title);
  408. md.addObject("titlePlac", titlePlac);
  409. md.addObject("linkPlac", linkPlac);
  410. md.addObject("descPlac", descPlac);
  411. md.addObject("butto",but);
  412.  
  413. return md;
  414. }
  415.  
  416. //Метод POST, добавляющий эпизод
  417. @RequestMapping(value = "/addEpisodeAction", method = RequestMethod.POST)
  418. public String addEpisodeAction(@Validated @ModelAttribute("episode") Episode episode, BindingResult result ,ModelMap map) throws UnsupportedEncodingException{
  419.  
  420. map.addAttribute("title", episode.getTitle());
  421. map.addAttribute("link",episode.getLink());
  422. map.addAttribute("desc",episode.getDesc());
  423.  
  424. /*epsiodeValidator.validate(episode, result);
  425. if(result.hasErrors()){
  426. return "redirect:/addEpisode";
  427. } else {}*/
  428.  
  429. String mel = new String(episode.getTitle().getBytes("ISO-8859-1"), "UTF-8");
  430. String mec = new String(episode.getLink().getBytes("ISO-8859-1"), "UTF-8");
  431. String mev = new String(episode.getDesc().getBytes("ISO-8859-1"), "UTF-8");
  432.  
  433. episode.setTitle(mel);
  434. episode.setLink(mec);
  435. episode.setDesc(mev);
  436.  
  437. episodeService.addEpisode(episode);
  438.  
  439. return "redirect:/getSeries/1";
  440.  
  441. }
  442.  
  443. //Список эпизодов
  444. @RequestMapping(value = "/getSeries/{id}")
  445. public ModelAndView GetSeries(@PathVariable int id){
  446. ModelAndView md = new ModelAndView("AllEpisodes");
  447. String title = "Вы можеть смотреть сериал Madness Combat здесь";
  448.  
  449. long count = episodeService.getCount();
  450.  
  451. long pages = count / 10 + 1;
  452.  
  453. List<Episode> eps = episodeService.listEpisode(id);
  454.  
  455. for (Episode ep : eps) {
  456. System.out.println(ep.getTitle());
  457. }
  458.  
  459. System.out.println("https://www.youtube.com/embed/DrtlTO5eD0U".length() );
  460.  
  461. md.addObject("pages",pages);
  462. md.addObject("episodes",eps);
  463. md.addObject("title",title);
  464.  
  465. return md;
  466. }
  467.  
  468. //Просмотр эпизодов
  469. @RequestMapping(path = "/watchEpisode/{id}")
  470. public ModelAndView watchEpisode(@PathVariable int id){
  471. ModelAndView md = new ModelAndView("WatchEpisode");
  472.  
  473. Episode eps = episodeService.getEpisode(id);
  474. String title = eps.getTitle();
  475.  
  476. md.addObject("title",title);
  477. md.addObject("episode",eps);
  478.  
  479. return md;
  480. }
  481.  
  482. //Метод POST добавления комметариев
  483. @RequestMapping(value = "/addComment", method = RequestMethod.POST)
  484. public String addComment(@Validated @ModelAttribute("comment") Comment comment, BindingResult result, ModelMap model ) throws UnsupportedEncodingException{
  485.  
  486. model.addAttribute("author", comment.getAuthor());
  487. model.addAttribute("content", comment.getContent());
  488.  
  489. String mel = new String(comment.getAuthor().getBytes("ISO-8859-1"), "UTF-8");
  490. String mec = new String(comment.getContent().getBytes("ISO-8859-1"), "UTF-8");
  491. comment.setAuthor(mel);
  492. comment.setContent(mec);
  493.  
  494. commentService.addComment(comment);
  495.  
  496. return "redirect:/comments/1";
  497. }
  498.  
  499. //Список комметариев
  500. @RequestMapping(value = "/comments/{id}")
  501. public ModelAndView Commentaries(@PathVariable int id){
  502. ModelAndView md = new ModelAndView("Comments");
  503. String title = "Оставьте отзыв";
  504. String post = "Отправить";
  505.  
  506. long count = commentService.getCount();
  507. long pages = count / 5 + 1;
  508.  
  509. List<Comment> coms = commentService.listComments(id);
  510.  
  511. Comment comment = new Comment();
  512.  
  513. md.addObject("comment", comment);
  514. md.addObject("comments",coms);
  515. md.addObject("title",title);
  516. md.addObject("Post",post);
  517. md.addObject("pages", pages);
  518.  
  519. return md;
  520. }
  521.  
  522. //Доступ к галерее (В разработке)
  523. @RequestMapping(value = "/galery/{id}")
  524. public ModelAndView Gallery(@PathVariable int id){
  525. ModelAndView md = new ModelAndView("Gallery");
  526.  
  527. Image image = new Image();
  528.  
  529. long count = commentService.getCount();
  530. long pages = count / 20 + 1;
  531.  
  532. List<Image> images = new ArrayList<Image>();
  533.  
  534. images = imageService.getGallery(id);
  535.  
  536. String title2 = "Посмотрите галерею";
  537. String butto = "Загрузить картинку";
  538.  
  539.  
  540. md.addObject("butto", butto);
  541. md.addObject("title2",title2);
  542. md.addObject("image",image);
  543. md.addObject("images",images);
  544. md.addObject("pages",pages);
  545.  
  546. return md;
  547. }
  548.  
  549. //Добавление изображений (В разработке)
  550. @RequestMapping(value = "/addImage", method = RequestMethod.POST)
  551. public String addImage(@Validated @ModelAttribute("image") Image image, ModelMap map, BindingResult result ) throws IOException{
  552.  
  553. map.addAttribute("title", image.getTitle());
  554. map.addAttribute("file", image.getFile());
  555.  
  556. String mel = new String(image.getTitle().getBytes("ISO-8859-1"), "UTF-8");
  557.  
  558. image.setTitle(mel);
  559.  
  560. imageService.addImage(image);
  561. return "redirect:/galery/1";
  562. }
  563. }
  564.  
  565. <?xml version="1.0" encoding="UTF-8"?>
  566. <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  567. "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
  568. <hibernate-configuration>
  569. <session-factory name="session">
  570. <property name="hibernate.connection.charSet">utf8</property>
  571. <property name="hibernate.connection.characterEncoding">utf8</property>
  572. <property name="hibernate.connection.useUnicode">true</property>
  573. <property name="hibernate.connection.autoReconnect">true</property>
  574. <property name="hibernate.connection.pool_size">3</property>
  575. <property name="hibernate.current_session_context_class">thread</property>
  576. <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  577. <property name="hibernate.enable_lazy_load_no_trans">true</property>
  578. <property name="hibernate.connection.username">bf529a773566a9</property>
  579. <property name="hibernate.connection.password">ac8c4d10</property>
  580. <property name="hibernate.connection.url">jdbc:mysql://us-cdbr-iron-east-03.cleardb.net:3306/heroku_7975f769758d9fa?reconnect=true?UseUnicode=yes&characterEncoding=utf8</property>
  581. <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  582. <property name="hibernate.show_sql">true</property>
  583. <property name="hibernate.c3p0.acquire_increment">1</property>
  584. <property name="hibernate.c3p0.min_size">1</property>
  585. <property name="hibernate.c3p0.max_size">5</property>
  586. <property name="hibernate.c3p0.timeout">120</property>
  587. <property name="hibernate.c3p0.max_statements">50</property>
  588. <property name="hibernate.c3p0.idle_test_period">60</property>
  589. <property name="hibernate.c3p0.validate">true</property>
  590. <mapping class="com.model.Comment"/>
  591. <mapping class="com.model.Image"/>
  592. <mapping class="com.model.Episode"/>
  593. </session-factory>
  594. </hibernate-configuration>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!