API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2018
171
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.56 KB | None | 0 0
raw download clone embed print report
  1. �E�� 03, 2018 3:07:15 �U�� com.google.cloud.sql.mysql.SocketFactory connect
  2. ��T: Using GAE Unix Sockets
  3. 2018-09-03 15:07:15.529:WARN:oejs.ServletHandler:qtp341878976-22:
  4. org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: <|### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: java.lang.UnsatisfiedLinkError: ??@??��<|### The error may exist in com/cypro/sqlMap/commonSqlMap.xml<|### The error may involve commonSqlMap.getCharaName<|### The error occurred while executing a query<|### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: java.lang.UnsatisfiedLinkError: ??@??��
  5. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
  6. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
  7. at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
  8. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  9. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  10. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848)
  11. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1772)
  12. at com.google.appengine.tools.development.ResponseRewriterFilter.doFilter(ResponseRewriterFilter.java:134)
  13. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
  14. at com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:34)
  15. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
  16. at com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:63)
  17. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
  18. at com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:48)
  19. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
  20. at com.google.appengine.tools.development.jetty9.StaticFileFilter.doFilter(StaticFileFilter.java:123)
  21. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
  22. at com.google.appengine.tools.development.DevAppServerModulesFilter.doDirectRequest(DevAppServerModulesFilter.java:366)
  23. at com.google.appengine.tools.development.DevAppServerModulesFilter.doDirectModuleRequest(DevAppServerModulesFilter.java:349)
  24. at com.google.appengine.tools.development.DevAppServerModulesFilter.doFilter(DevAppServerModulesFilter.java:116)
  25. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
  26. at com.google.appengine.tools.development.DevAppServerRequestLogFilter.doFilter(DevAppServerRequestLogFilter.java:44)
  27. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1751)
  28. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:582)
  29. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  30. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)
  31. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
  32. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
  33. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:512)
  34. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  35. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
  36. at com.google.appengine.tools.development.jetty9.DevAppEngineWebAppContext.doScope(DevAppEngineWebAppContext.java:94)
  37. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  38. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
  39. at com.google.appengine.tools.development.jetty9.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:601)
  40. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
  41. at org.eclipse.jetty.server.Server.handle(Server.java:534)
  42. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)
  43. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
  44. at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
  45. at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
  46. at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
  47. at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
  48. at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
  49. at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
  50. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
  51. at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
  52. at java.lang.Thread.run(Unknown Source)
  53.  
  54. <?xml version="1.0" encoding="UTF-8"?>
  55. <beans xmlns="http://www.springframework.org/schema/beans"
  56. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  57. xmlns:mvc="http://www.springframework.org/schema/mvc"
  58. xmlns:context="http://www.springframework.org/schema/context"
  59. xsi:schemaLocation="http://www.springframework.org/schema/beans
  60. http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
  61. http://www.springframework.org/schema/mvc
  62. http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd
  63. http://www.springframework.org/schema/context
  64. http://www.springframework.org/schema/context/spring-context-4.1.xsd">
  65. <context:component-scan base-package="com.cypro" />
  66.  
  67. <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  68. <property name="prefix" value="/WEB-INF/page/" />
  69. <property name="suffix" value=".jsp" />
  70. <property name="order" value="1" />
  71. </bean>
  72.  
  73. <!-- sqlSessionFactory -->
  74. <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  75. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  76. <property name="url" value="jdbc:mysql://google/myDatabase?useSSL=false&cloudSqlInstance=myInstanceUrl&socketFactory=com.google.cloud.sql.mysql.SocketFactory" /><!--use this will error-->
  77. <!-- <property name="url" value="jdbc:mysql://localhost:3306/myDatabase?useUnicode=true&characterEncoding=UTF-8" /> --><!--use this works fine-->
  78. <property name="username" value="myUserName" />
  79. <property name="password" value="myPassword" />
  80. </bean>
  81. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  82. <property name="dataSource" ref="dataSource" />
  83. <property name="configLocation" value="/WEB-INF/config/SqlMapConfig.xml" />
  84. </bean>
  85. <bean id="commonDao" class="com.cypro.dao.CommonDao">
  86. <property name="sqlSessionFactory" ref="sqlSessionFactory" />
  87. </bean>
  88. </beans>
  89.  
  90. <?xml version="1.0" encoding="UTF-8"?>
  91. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  92. "http://mybatis.org/dtd/mybatis-3-config.dtd">
  93.  
  94. <configuration>
  95. <mappers>
  96. <mapper resource="com/cypro/sqlMap/commonSqlMap.xml" />
  97. </mappers>
  98. </configuration>
  99.  
  100. <?xml version="1.0" encoding="utf-8"?>
  101. <appengine-web-app xmlns="http://appengine.google.com/ns/1.0">
  102. <threadsafe>true</threadsafe>
  103. <sessions-enabled>false</sessions-enabled>
  104. <runtime>java8</runtime>
  105.  
  106. <use-google-connector-j>true</use-google-connector-j>
  107. <service>cloudsql</service>
  108.  
  109. <system-properties>
  110. <property name="java.util.logging.config.file" value="WEB- INF/logging.properties"/>
  111. </system-properties>
  112. </appengine-web-app>
  113.  
  114. <?xml version="1.0" encoding="utf-8"?>
  115. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  116. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  117. xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
  118. version="3.1">
  119. <servlet>
  120. <servlet-name>SpringServlet</servlet-name>
  121. <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  122. <init-param>
  123. <param-name>contextConfigLocation</param-name>
  124. <param-value>/WEB-INF/config/SpringConfig.xml</param-value>
  125. </init-param>
  126. <load-on-startup>1</load-on-startup>
  127. </servlet>
  128. <servlet-mapping>
  129. <servlet-name>SpringServlet</servlet-name>
  130. <url-pattern>/</url-pattern>
  131. </servlet-mapping>
  132. </web-app>
  133.  
  134. <?xml version="1.0" encoding="UTF-8"?>
  135. <project xmlns="http://maven.apache.org/POM/4.0.0"
  136. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  137. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  138.  
  139. <modelVersion>4.0.0</modelVersion>
  140. <packaging>war</packaging>
  141. <version>0.1.0-SNAPSHOT</version>
  142.  
  143. <groupId>com.cypro</groupId>
  144. <artifactId>CyproWeb</artifactId>
  145.  
  146. <properties>
  147. <appengine.maven.plugin.version>1.3.2</appengine.maven.plugin.version>
  148. <appengine.api.sdk.version>1.9.64</appengine.api.sdk.version>
  149. <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  150. <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  151. <maven.compiler.source>1.8</maven.compiler.source>
  152. <maven.compiler.target>1.8</maven.compiler.target>
  153. <maven.compiler.showDeprecation>true</maven.compiler.showDeprecation>
  154. </properties>
  155.  
  156. <dependencyManagement>
  157. <dependencies>
  158. <dependency>
  159. <groupId>com.google.cloud</groupId>
  160. <artifactId>google-cloud-bom</artifactId>
  161. <version>0.60.0-alpha</version>
  162. <type>pom</type>
  163. <scope>import</scope>
  164. </dependency>
  165. </dependencies>
  166. </dependencyManagement>
  167.  
  168. <dependencies>
  169. <!-- Compile/runtime dependencies -->
  170. <dependency>
  171. <groupId>javax.servlet</groupId>
  172. <artifactId>javax.servlet-api</artifactId>
  173. <version>3.1.0</version>
  174. <scope>provided</scope>
  175. </dependency>
  176. <dependency>
  177. <groupId>javax.servlet.jsp</groupId>
  178. <artifactId>javax.servlet.jsp-api</artifactId>
  179. <version>2.3.1</version>
  180. <scope>provided</scope>
  181. </dependency>
  182. <dependency>
  183. <groupId>jstl</groupId>
  184. <artifactId>jstl</artifactId>
  185. <version>1.2</version>
  186. </dependency>
  187.  
  188. <!-- Test Dependencies -->
  189. <dependency>
  190. <groupId>junit</groupId>
  191. <artifactId>junit</artifactId>
  192. <version>4.12</version>
  193. <scope>test</scope>
  194. </dependency>
  195.  
  196. <!-- Spring -->
  197. <dependency>
  198. <groupId>org.springframework</groupId>
  199. <artifactId>spring-context-support</artifactId>
  200. <version>4.1.6.RELEASE</version>
  201. </dependency>
  202. <dependency>
  203. <groupId>org.springframework</groupId>
  204. <artifactId>spring-webmvc</artifactId>
  205. <version>4.1.6.RELEASE</version>
  206. </dependency>
  207.  
  208. <!-- com.mysql.jdbc.Driver -->
  209. <dependency> <!-- Only used locally -->
  210. <groupId>mysql</groupId>
  211. <artifactId>mysql-connector-java</artifactId>
  212. <version>5.1.42</version>
  213. </dependency>
  214. <!-- google cloudSQL Driver -->
  215. <dependency>
  216. <groupId>com.google.cloud.sql</groupId>
  217. <artifactId>mysql-socket-factory</artifactId>
  218. <version>1.0.9</version>
  219. </dependency>
  220.  
  221. <!-- mybatis -->
  222. <dependency>
  223. <groupId>org.mybatis</groupId>
  224. <artifactId>mybatis</artifactId>
  225. <version>3.1.1</version>
  226. </dependency>
  227. <dependency>
  228. <groupId>org.mybatis</groupId>
  229. <artifactId>mybatis-spring</artifactId>
  230. <version>1.1.1</version>
  231. </dependency>
  232. </dependencies>
  233.  
  234. <build>
  235. <!-- for hot reload of the web application -->
  236. <outputDirectory>${project.build.directory}/${project.build.finalName}/WEB-INF/classes</outputDirectory>
  237. <plugins>
  238. <plugin>
  239. <groupId>org.codehaus.mojo</groupId>
  240. <artifactId>versions-maven-plugin</artifactId>
  241. <version>2.3</version>
  242. <executions>
  243. <execution>
  244. <phase>compile</phase>
  245. <goals>
  246. <goal>display-dependency-updates</goal>
  247. <goal>display-plugin-updates</goal>
  248. </goals>
  249. </execution>
  250. </executions>
  251. </plugin>
  252.  
  253. <plugin>
  254. <groupId>com.google.cloud.tools</groupId>
  255. <artifactId>appengine-maven-plugin</artifactId>
  256. <version>${appengine.maven.plugin.version}</version>
  257. <configuration>
  258. <deploy.promote>true</deploy.promote>
  259. <deploy.stopPreviousVersion>true</deploy.stopPreviousVersion>
  260. </configuration>
  261. </plugin>
  262.  
  263. <plugin>
  264. <groupId>org.apache.maven.plugins</groupId>
  265. <artifactId>maven-war-plugin</artifactId>
  266. <version>3.0.0</version>
  267. <configuration>
  268. <webResources>
  269. <!-- in order to interpolate version from pom into appengine-web.xml -->
  270. <resource>
  271. <directory>${basedir}/src/main/webapp/WEB-INF</directory>
  272. <filtering>true</filtering>
  273. <targetPath>WEB-INF</targetPath>
  274. </resource>
  275. </webResources>
  276. </configuration>
  277. </plugin>
  278.  
  279. </plugins>
  280. </build>
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!