###Knowledge の データベース接続先をpostgresqlに変更したいが、接続エラーになる
Knowledgeを使用しています。
データベースの接続先を組み込みDBからpostgresqlに変更したいのですが、いつもエラーになります。
postgresql、javaには不慣れなため、設定方法をご存知の方、是非、ご教示ください。
###環境
- OS: Ubuntu 16.04
- Tomcat: 8.5.4
- Java: 1.8.0_101
- Postgresql: 9.5.4
- JDBC: postgresql-9.3-1103.jdbc41.jar
JDBCは、Tomcatのlib/
にそのままの名前で入れてあります。
###エラーメッセージ
ERROR 2016-08-28 00:43:18,520 [ConnectionPoolImpl(127)] Can't create a new connection for jdbc://postgresql://localhost:5432/klgdb java.sql.SQLException: No suitable driver found for jdbc://postgresql://localhost:5432/klgdb at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.support.project.ormapping.connection.ConnectionPoolImpl.newConnection(ConnectionPoolImpl.java:123) at org.support.project.ormapping.connection.ConnectionPoolImpl.getCon(ConnectionPoolImpl.java:105) at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:66) at org.support.project.ormapping.connection.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:60) at org.support.project.ormapping.connection.ConnectionManager.checkConnectionConfig(ConnectionManager.java:100) at org.support.project.knowledge.control.admin.DatabaseControl.custom_save(DatabaseControl.java:210) at org.support.project.common.util.ObjectUtils.invoke(ObjectUtils.java:132) at org.support.project.web.common.InvokeTarget.invoke(InvokeTarget.java:106) at org.support.project.web.filter.ControlManagerFilter.doInvoke(ControlManagerFilter.java:360) at org.support.project.web.filter.ControlFilter.invoke(ControlFilter.java:31) at org.support.project.web.filter.ControlManagerFilter.doFilter(ControlManagerFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.support.project.web.filter.MultipartFilter.doFilter(MultipartFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.support.project.web.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:302) at org.support.project.knowledge.listener.CloseAbleAuthenticationFilter.doFilter(CloseAbleAuthenticationFilter.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.support.project.web.filter.LoggingFilter.doFilter(LoggingFilter.java:62) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.support.project.web.filter.EncodingFilter.doFilter(EncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:780) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:785) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1425) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
###Postgresqlの準備
Knowledgeデータベースを作成するRoleを作りました。
回答1件
あなたの回答
tips
プレビュー