Q&A
db connect で問題が起きている様ですが、urlに有るサーバ名はpostgres:5432で合っておりますでしょうか？
###前提・実現したいこと
ここに質問したいことを詳細に書いてください
EclipseからDBFluteに接続したいと考えていますが、接続に失敗してしまいます。
###発生している問題・エラーメッセージ
2018-01-01 15:23:05,141 [main] INFO (TorqueJDBCTransformTask#begin():104) - +------------------------------------------+
2018-01-01 15:23:05,174 [main] INFO (TorqueJDBCTransformTask#begin():105) - | |
2018-01-01 15:23:05,175 [main] INFO (TorqueJDBCTransformTask#begin():106) - | JDBC |
2018-01-01 15:23:05,176 [main] INFO (TorqueJDBCTransformTask#begin():107) - | |
2018-01-01 15:23:05,176 [main] INFO (TorqueJDBCTransformTask#begin():108) - +------------------------------------------+
2018-01-01 15:23:05,214 [main] INFO (DfDataSourceHandler#prepare():78) - ...Preparing data source:
2018-01-01 15:23:05,214 [main] INFO (DfDataSourceHandler#prepare():79) - driver = org.postgresql.Driver
2018-01-01 15:23:05,215 [main] INFO (DfDataSourceHandler#prepare():80) - url = jdbc:postgresql://postgres:5432/postgres
2018-01-01 15:23:05,216 [main] INFO (DfDataSourceHandler#prepare():81) - user = postgres
2018-01-01 15:23:05,325 [main] INFO (DfSchemaXmlSerializer#serialize():286) -
2018-01-01 15:23:05,326 [main] INFO (DfSchemaXmlSerializer#serialize():287) - ...Starting to process JDBC to SchemaXML
2018-01-01 15:23:05,326 [main] INFO (DfSchemaXmlSerializer#doLoadPreviousSchema():1532) - ...Loading previous schema (schema diff process)
2018-01-01 15:23:05,327 [main] INFO (DfSchemaXmlSerializer#doLoadPreviousSchema():1535) - -> no previous (first time)
2018-01-01 15:23:05,348 [main] INFO (DfSchemaXmlSerializer#generateXML():360) - ...Getting DB connection
2018-01-01 15:23:05,384 [main] INFO (DfDataSourceHandler#createConnection():166) - ...Connecting to database by data source:
2018-01-01 15:23:07,726 [main] ERROR (DfDBFluteTaskUtil#logException():150) - Look! Read the message below.
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Failed to execute DBFlute Task 'JDBC'.
[Advice]
Check the exception messages and the stack traces.
-
-
-
-
-
-
-
-
- */
-
-
-
-
-
-
-
java.lang.IllegalStateException: SQL exception when serializing SchemaXml: ./schema/project-schema-springManagement.xml
at org.dbflute.logic.jdbc.schemaxml.DfSchemaXmlSerializer.serialize(DfSchemaXmlSerializer.java:323)
at org.apache.torque.task.TorqueJDBCTransformTask.doExecute(TorqueJDBCTransformTask.java:127)
at org.dbflute.task.bs.DfAbstractTask$1.callActualExecute(DfAbstractTask.java:113)
at org.dbflute.task.bs.assistant.DfTaskBasicController.doExecute(DfTaskBasicController.java:192)
at org.dbflute.task.bs.assistant.DfTaskBasicController.execute(DfTaskBasicController.java:78)
at org.dbflute.task.bs.DfAbstractTask.execute(DfAbstractTask.java:135)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
at org.apache.tools.ant.Main.runBuild(Main.java:698)
at org.apache.tools.ant.Main.startAnt(Main.java:199)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
Caused by: org.dbflute.exception.DfJDBCException: JDBC said...
/- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
[SQLException]
org.dbflute.exception.DfJDBCException
Failed to connect: url=jdbc:postgresql://postgres:5432/postgres user=postgres
[NextException]
org.postgresql.util.PSQLException
接続試行は失敗しました。
-
-
-
-
-
-
-
-
- -/
-
-
-
-
-
... 35 more -
-
2018-01-01 15:23:07,814 [main] INFO (DfDBFluteTaskUtil#logFinalMessage():139) -
//////////////////////
[Final Message]: 00m02s651ms *Abort
DBFLUTE_CLIENT: {springManagement}
database = postgresql
language = java
container = spring
package = com.Management.dbflute
DBFLUTE_ENVIRONMENT_TYPE: {}
driver = org.postgresql.Driver
url = jdbc:postgresql://postgres:5432/postgres
schema = {postgres.public as main}
user = postgres
props = {}
additionalSchema =
repsEnvType = ut
refreshProject = $$AutoDetect$$
////////// {JDBC}
###該当のソースコード
pom.xmlの設定情報
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
</project><groupId>com.example</groupId> <artifactId>springManagement</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>jar</packaging> <name>springManagement</name> <description>Demo project for Spring Boot</description> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.5.9.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding> <java.version>1.8</java.version> <dbflute.version>1.1.5</dbflute.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency> <dependency> <groupId>org.thymeleaf</groupId> <artifactId>thymeleaf-spring3</artifactId> <version>3.0.9.RELEASE</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.dbflute</groupId> <artifactId>dbflute-runtime</artifactId> <version>1.1.5</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> <plugin> <groupId>org.dbflute</groupId> <artifactId>dbflute-maven-plugin</artifactId> <version>1.1.0</version> <configuration> <clientProject>public</clientProject> <packageBase>com.Management.dbflute</packageBase> </configuration> </plugin> </plugins> </build>
###試したこと
postgresqlの接続情報をもう一度確認し、いろいろ試しましたがうまくいきません。。
###補足情報(言語/FW/ツール等のバージョンなど)
より詳細な情報
返信遅くなり申し訳ありません。postgres:5432をlocalhost:5432に変更したところ、manage.batで[2]を実行したところ、クラスの生成はできましたが、[0 : replace-schema]でエラーが発生してしまいます・・
[df-replace-schema] Failed to execute DBFlute Task 'ReplaceSchema'. [df-replace-schema] [df-replace-schema] [Advice] [df-replace-schema] Check the exception messages and the stack traces. [df-replace-schema] [df-replace-schema] [Database Product] [df-replace-schema] PostgreSQL 9.6.3 [df-replace-schema] [df-replace-schema] [JDBC Driver] [df-replace-schema] PostgreSQL Native Driver PostgreSQL 9.4.1212.jre6 for JDBC 4.0 [df-replace-schema] * * * * * * * * * */ [df-replace-schema] org.dbflute.infra.reps.exception.DfReplaceSchemaExecuteNotAllowedException: Look! Read the message below. [df-replace-schema] /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * [df-replace-schema] Your ReplaceSchema execution was not allowed. [df-replace-schema] [df-replace-schema] [Advice] [df-replace-schema] Not found SQL files for ReplaceSchema, [df-replace-schema] so your execution might be mistake...? [df-replace-schema] [df-replace-schema] [SQL Root Directory] [df-replace-schema] playsql [df-replace-schema] * * * * * * * * * */ [df-replace-schema] at org.dbflute.infra.reps.DfRepsExecuteLimitter.throwReplaceSchemaExecuteNotAllowedException(DfRepsExecuteLimitter.java:76) [df-replace-schema] at org.dbflute.infra.reps.DfRepsExecuteLimitter.checkExecutableOrNot(DfRepsExecuteLimitter.java:60) [df-replace-schema] at org.dbflute.logic.replaceschema.process.DfCreateSchemaProcess.checkBeforeInitialize(DfCreateSchemaProcess.java:152) [df-replace-schema] at org.dbflute.logic.replaceschema.process.DfCreateSchemaProcess.execute(DfCreateSchemaProcess.java:140) [df-replace-schema] at org.dbflute.task.DfReplaceSchemaTask.createSchema(DfReplaceSchemaTask.java:260) [df-replace-schema] at org.dbflute.task.DfReplaceSchemaTask.doExecuteCoreProcess(DfReplaceSchemaTask.java:242) [df-replace-schema] at org.dbflute.task.DfReplaceSchemaTask.executeCoreProcess(DfReplaceSchemaTask.java:232) [df-replace-schema] at org.dbflute.task.DfReplaceSchemaTask.processMain(DfReplaceSchemaTask.java:228) [df-replace-schema] at org.dbflute.task.DfReplaceSchemaTask.doExecute(DfReplaceSchemaTask.java:158) [df-replace-schema] at org.dbflute.task.bs.DfAbstractTexenTask$1.callActualExecute(DfAbstractTexenTask.java:129) [df-replace-schema] at org.dbflute.task.bs.assistant.DfTaskBasicController.doExecute(DfTaskBasicController.java:192) [df-replace-schema] at org.dbflute.task.bs.assistant.DfTaskBasicController.execute(DfTaskBasicController.java:78) [df-replace-schema] at org.dbflute.task.bs.DfAbstractTexenTask.execute(DfAbstractTexenTask.java:151) [df-replace-schema] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) [df-replace-schema] at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) [df-replace-schema] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [df-replace-schema] at java.lang.reflect.Method.invoke(Method.java:483) [df-replace-schema] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105) [df-replace-schema] at org.apache.tools.ant.Task.perform(Task.java:348) [df-replace-schema] at org.apache.tools.ant.Target.execute(Target.java:357) [df-replace-schema] at org.apache.tools.ant.Target.performTasks(Target.java:385) [df-replace-schema] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329) [df-replace-schema] at org.apache.tools.ant.Project.executeTarget(Project.java:1298) [df-replace-schema] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) [df-replace-schema] at org.apache.tools.ant.Project.executeTargets(Project.java:1181) [df-replace-schema] at org.apache.tools.ant.Main.runBuild(Main.java:698) [df-replace-schema] at org.apache.tools.ant.Main.startAnt(Main.java:199) [df-replace-schema] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) [df-replace-schema] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) [df-replace-schema] 2018-01-02 21:46:17,705 INFO - ...closeReally() [df-replace-schema] 2018-01-02 21:46:17,715 INFO - [df-replace-schema] _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ [df-replace-schema] [Final Message]: 00m03s039ms *Abort [df-replace-schema] [df-replace-schema] DBFLUTE_CLIENT: {springManagement} [df-replace-schema] database = postgresql (PostgreSQL 9.6.3) [df-replace-schema] language = java [df-replace-schema] container = spring [df-replace-schema] package = com.Management.dbflute [df-replace-schema] [df-replace-schema] DBFLUTE_ENVIRONMENT_TYPE: {} [df-replace-schema] driver = org.postgresql.Driver [df-replace-schema] url = jdbc:postgresql://localhost:5432/postgres [df-replace-schema] schema = {postgres.public as main} [df-replace-schema] user = postgres [df-replace-schema] props = {} [df-replace-schema] additionalSchema = [df-replace-schema] repsEnvType = ut [df-replace-schema] refreshProject = $$AutoDetect$$ [df-replace-schema] [df-replace-schema] [df-replace-schema] _/_/_/_/_/_/_/_/_/_/ {ReplaceSchema} BUILD FAILED C:\Users\kasumitajima\eclipse-workspace\springManagement\mydbflute\dbflute-1.1.5\build-torque.xml:127: org.dbflute.exception.DfDBFluteTaskFailureException: /* * * * * * * * * * * * * * * * * * * * * * * * * Failed to execute the DBFlute task: ReplaceSchema Look at the log: console or dbflute.log * * * * * * * * * */
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Failed to refresh the resources. [Project List] [springManagement] [Request URL] http://localhost:8386/ [IOExpception] ConnectException Connection refused: connect * * * * * * * * * */ 2018-01-02 21:42:37,814 [main] INFO (DfRefreshResourceProcess#show():299) - ==========/ 2018-01-02 21:42:37,826 [main] INFO (DfDBFluteTaskUtil#logFinalMessage():139) - _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ [Final Message]: 00m02s440ms DBFLUTE_CLIENT: {springManagement} database = postgresql language = java container = spring package = com.Management.dbflute DBFLUTE_ENVIRONMENT_TYPE: {} driver = org.postgresql.Driver url = jdbc:postgresql://localhost:5432/postgres schema = {postgres.public as main} user = postgres props = {} additionalSchema = repsEnvType = ut refreshProject = $$AutoDetect$$ _/_/_/_/_/_/_/_/_/_/ {Sql2Entity} 2018-01-02 21:46:14,698 [main] INFO (DfReplaceSchemaTask#begin():92) - +------------------------------------------+ 2018-01-02 21:46:14,698 [main] INFO (DfReplaceSchemaTask#begin():93) - | | 2018-01-02 21:46:14,698 [main] INFO (DfReplaceSchemaTask#begin():94) - | ReplaceSchema | 2018-01-02 21:46:14,698 [main] INFO (DfReplaceSchemaTask#begin():102) - | | 2018-01-02 21:46:14,714 [main] INFO (DfReplaceSchemaTask#begin():103) - +------------------------------------------+ 2018-01-02 21:46:14,714 [main] INFO (DfReplaceSchemaTask#waitBeforeReps():360) - ...Waiting for your GO SIGN from stdin before ReplaceSchema: 2018-01-02 21:46:17,249 [main] INFO (DfDataSourceHandler#prepare():78) - ...Preparing data source: 2018-01-02 21:46:17,250 [main] INFO (DfDataSourceHandler#prepare():79) - driver = org.postgresql.Driver 2018-01-02 21:46:17,250 [main] INFO (DfDataSourceHandler#prepare():80) - url = jdbc:postgresql://localhost:5432/postgres 2018-01-02 21:46:17,251 [main] INFO (DfDataSourceHandler#prepare():81) - user = postgres 2018-01-02 21:46:17,288 [main] INFO (DfDataSourceHandler#createConnection():166) - ...Connecting to database by data source: 2018-01-02 21:46:17,472 [main] INFO (DfDataSourceHandler#setupConnectionMetaInfo():233) - product = PostgreSQL 9.6.3 2018-01-02 21:46:17,474 [main] INFO (DfDataSourceHandler#setupConnectionMetaInfo():234) - driver = PostgreSQL Native Driver PostgreSQL 9.4.1212.jre6 for JDBC 4.0 2018-01-02 21:46:17,481 [main] INFO (DfCurrentSchemaConnector#executeCurrentSchemaSql():77) - ...Connecting to the schema 2018-01-02 21:46:17,482 [main] INFO (DfCurrentSchemaConnector#executeCurrentSchemaSql():78) - set search_path to public 2018-01-02 21:46:17,656 [main] ERROR (DfDBFluteTaskUtil#logException():150) - Look! Read the message below. /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Failed to execute DBFlute Task 'ReplaceSchema'. [Advice] Check the exception messages and the stack traces. [Database Product] PostgreSQL 9.6.3 [JDBC Driver] PostgreSQL Native Driver PostgreSQL 9.4.1212.jre6 for JDBC 4.0 * * * * * * * * * */ org.dbflute.infra.reps.exception.DfReplaceSchemaExecuteNotAllowedException: Look! Read the message below. /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Your ReplaceSchema execution was not allowed. [Advice] Not found SQL files for ReplaceSchema, so your execution might be mistake...? [SQL Root Directory] playsql * * * * * * * * * */ at org.dbflute.infra.reps.DfRepsExecuteLimitter.throwReplaceSchemaExecuteNotAllowedException(DfRepsExecuteLimitter.java:76) at org.dbflute.infra.reps.DfRepsExecuteLimitter.checkExecutableOrNot(DfRepsExecuteLimitter.java:60) at org.dbflute.logic.replaceschema.process.DfCreateSchemaProcess.checkBeforeInitialize(DfCreateSchemaProcess.java:152) at org.dbflute.logic.replaceschema.process.DfCreateSchemaProcess.execute(DfCreateSchemaProcess.java:140) at org.dbflute.task.DfReplaceSchemaTask.createSchema(DfReplaceSchemaTask.java:260) at org.dbflute.task.DfReplaceSchemaTask.doExecuteCoreProcess(DfReplaceSchemaTask.java:242) at org.dbflute.task.DfReplaceSchemaTask.executeCoreProcess(DfReplaceSchemaTask.java:232) at org.dbflute.task.DfReplaceSchemaTask.processMain(DfReplaceSchemaTask.java:228) at org.dbflute.task.DfReplaceSchemaTask.doExecute(DfReplaceSchemaTask.java:158) at org.dbflute.task.bs.DfAbstractTexenTask$1.callActualExecute(DfAbstractTexenTask.java:129) at org.dbflute.task.bs.assistant.DfTaskBasicController.doExecute(DfTaskBasicController.java:192) at org.dbflute.task.bs.assistant.DfTaskBasicController.execute(DfTaskBasicController.java:78) at org.dbflute.task.bs.DfAbstractTexenTask.execute(DfAbstractTexenTask.java:151) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329) at org.apache.tools.ant.Project.executeTarget(Project.java:1298) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1181) at org.apache.tools.ant.Main.runBuild(Main.java:698) at org.apache.tools.ant.Main.startAnt(Main.java:199) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) 2018-01-02 21:46:17,705 [main] INFO (DfDataSourceHandler#destroy():120) - ...closeReally() 2018-01-02 21:46:17,715 [main] INFO (DfDBFluteTaskUtil#logFinalMessage():139) - _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ [Final Message]: 00m03s039ms *Abort DBFLUTE_CLIENT: {springManagement} database = postgresql (PostgreSQL 9.6.3) language = java container = spring package = com.Management.dbflute DBFLUTE_ENVIRONMENT_TYPE: {} driver = org.postgresql.Driver url = jdbc:postgresql://localhost:5432/postgres schema = {postgres.public as main} user = postgres props = {} additionalSchema = repsEnvType = ut refreshProject = $$AutoDetect$$ _/_/_/_/_/_/_/_/_/_/ {ReplaceSchema}
すみませんDBFluteはわかりません。でもエラーはReplaceSchemaが見つからない事に起因している様です。環境変数のDBFLUTE_ENVIRONMENT_TYPEとそれ毎のdatabaseInfoMap.dfpropファイルを確認すると良いかも？
回答1件
0
jfluteです
jdbc:postgresql://postgres:5432/postgres user=postgres
接続URLのホスト名が「postgres」になっていますが、
これは合っていますのでしょうか？
(通常、ローカルのPostgreSQLであれば、localhostになることが多いので)
こちら参考にしてみてください:
// PostgreSQLの取扱い - データベース接続設定
http://dbflute.seasar.org/ja/manual/reference/dbway/postgresql/index.html#setting
map:{ ; driver = org.postgresql.Driver ; url = jdbc:postgresql://[host]:[port]/[dbname] ; schema = [schema] ; user = [dbuser] ; password = [dbpassword] }
map:{ ; driver = org.postgresql.Driver ; url = jdbc:postgresql://localhost:5432/exampledb ; schema = public ; user = exampledb ; password = exampledb }
投稿2018/01/12 14:07
総合スコア42
URLのホスト名はご回答いただいた通り、localhostで、DB接続はできました。
ただ、ReplaceSchemaを実行すると以下のエラーが出てしまっていて。。
SQLファイルとは、「replace-schema.sql」のことなのでしょうか？
Not found SQL files for ReplaceSchema
ReplaceSchemaのためのSQLファイルということなので、
replace-schema.sql で合っていると思います。
ReplaceSchema は...
1. 既存のDBスキーマ上のテーブルを全部削除
2. replace-schema.sqlを実行 (すべてのcreate文が入ってる想定)
3. テストデータを登録 (TSVやエクセルで用意されていれば)
という動きをします。
なので、replace-schema.sql がないと単に空っぽにするだけになってしまうので、
最低限 DDL 一つは必要です。
ということなのですが、そもそも ReplaceSchema が必要でしょうか？
ローカルDBを ReplaceSchema でいつでも再構築できるような形にするのであれば必要ですが、
すでにDBに単に接続してソースコードを自動生成するのであればReplaceSchemaは不要です。
ちょっと前提がわからないのですが、ReplaceSchemaの基本的なリソースである、
replace-schema.sql が用意されていないということなので、念のためその辺が心配になりました。
ごめんなさい、teratail を普段チェックしていないので返事が遅くなりました...m(_ _)m。
一応、早い返事が必要であれば、twitterでつぶやくか、DBFluteのMLの方が早いのですが...
こういったサイトを活用していくのも良いことなので、もうちょい使いこなしてみます。
※どうすれば自分がコメントしたチケットにコメントが来た場合にメールが飛ぶかな...
@jflute
ソースじゃなくメールが爆発して動かなくなるかもしれませんが https://teratail.com/users/setting/mail-all で設定できると思いますよ。
（ここのことだよね：回答した内容にコメントがついたとき）
> ソースじゃなくメールが爆発して動かなくなるかもしれませんが
> https://teratail.com/users/setting/mail-all で設定できると思いますよ。
@asahina1979 さん、ありがとうございます。
(twitterでもありがとうございます)
以前の状態でメール来なかったので、メール認証がずっと保留されていたからでした。
さらに、このメールの設定で調整して良い感じにメール見られるようにしますね。
あなたの回答
tips
プレビュー
