[Seasar-user:12911] mysqlのjdbc設定について質問

布施雄一 [E-MAIL ADDRESS DELETED]
2008年 2月 17日 (日) 19:02:43 JST 

初めまして。
こちらのメーリングリストでは初メールとなります 1/5というものです。

jdbcの設定について質問です。
WEB-DB PRESS vol41の記事を参考にしつつ、自宅の環境で動かそうと環境を設定してるのですが
jdbcの設定のことで質問があります。
環境としては、自宅LANにてDBサーバとして用意してある 192.168.1.13 の上に
mysqlのversion: 5.0.27-standard を準備して
開発端末側のJDBCドライバとして、mysql-connector-java-5.0.8-bin.jar を用意してあります。

seasar2のdbfluteを利用して、デモを動かそうとしているのですが
「/seasardemo/dbflute_demo/replace-schema.bat」を実行すると
下記に引用しているLOGのエラーが発生して、成功しません。
どこから見直せばよいか、助言をいただけませんか？

/seasardemo/dbflute_demo/dfprop/databaseInfoMap.dfprop には下記の設定を入れてあります。
map:{
	; driver		= com.mysql.jdbc.Driver
	; url			= jdbc:mysql://192.168.1.13:3306/dbflutedemo
	; schema		= root
	; user			= root
	; password		= aaaaa
}

2008-02-17 15:53:40,062 [main] DEBUG
(DfAntTaskUtil#getBuildProperties():62) - Using contextProperties
file: C:\Documents and
Settings\ｙ\workspace\seasardemo\mydbflute\dbflute-0.6.3\build.properties
2008-02-17 15:53:40,062 [main] DEBUG
(DfAntTaskUtil#getBuildProperties():90) - [Properties]: size=7
2008-02-17 15:53:40,062 [main] DEBUG
(DfAntTaskUtil#getBuildProperties():94) -     torque.packageBase =
sample.dbflute
2008-02-17 15:53:40,062 [main] DEBUG
(DfAntTaskUtil#getBuildProperties():94) -     torque.database = h2
2008-02-17 15:53:40,062 [main] DEBUG
(DfAntTaskUtil#getBuildProperties():94) -     torque.s2daoVersion =
1.0.47
2008-02-17 15:53:40,062 [main] DEBUG
(DfAntTaskUtil#getBuildProperties():94) -     torque.targetLanguage =
java
2008-02-17 15:53:40,062 [main] DEBUG
(DfAntTaskUtil#getBuildProperties():94) -     torque.project = demo
2008-02-17 15:53:40,062 [main] DEBUG
(DfAntTaskUtil#getBuildProperties():94) -
torque.daoSqlFileEncoding = UTF-8
2008-02-17 15:53:40,062 [main] DEBUG
(DfAntTaskUtil#getBuildProperties():94) -
torque.jdbcToJavaNativeMap =
map:{TINYINT=java.lang.Integer;SMALLINT=java.lang.Integer;INTEGER=java.lang.Integer;BIGINT=java.lang.Long}
2008-02-17 15:53:40,093 [main] INFO
(DfSimpleDataSourceCreator#create():101) - ...create()
2008-02-17 15:53:40,093 [main] INFO
(DfReplaceSchemaTask#doExecute():72) - * * * * * * * * * * *
2008-02-17 15:53:40,093 [main] INFO
(DfReplaceSchemaProperties#getReplaceSchemaDefinitionMap():31) -
...Initializing replaceSchemaDefinitionMap: {}
2008-02-17 15:53:40,093 [main] INFO
(DfReplaceSchemaTask#doExecute():73) - environmentType: ut
2008-02-17 15:53:40,093 [main] INFO
(DfReplaceSchemaTask#doExecute():74) - * * * * * * * * * * *
2008-02-17 15:53:40,093 [main] INFO
(DfReplaceSchemaTask#doExecute():75) - isReplaceSchemaAutoCommit    =
true
2008-02-17 15:53:40,093 [main] INFO
(DfReplaceSchemaTask#doExecute():76) - isReplaceSchemaRollbackOnly  =
false
2008-02-17 15:53:40,093 [main] INFO
(DfReplaceSchemaTask#doExecute():77) - isReplaceSchemaErrorContinue =
true
2008-02-17 15:53:40,218 [main] ERROR (DfAbstractTask#execute():74) -
execute() threw the exception!
Driver#connect() threw the exception:
_url=jdbc:mysql://192.168.1.13:3306/dbflutedemo
	at org.seasar.dbflute.helper.jdbc.connection.DfSimpleDataSourceCreator.newConnection(DfSimpleDataSourceCreator.java:193)
	at org.seasar.dbflute.helper.jdbc.connection.DfSimpleDataSourceCreator.getConnection(DfSimpleDataSourceCreator.java:179)
	at org.seasar.dbflute.helper.jdbc.connection.DfSimpleDataSourceCreator$DfSimpleDataSource.getConnection(DfSimpleDataSourceCreator.java:153)
	at org.seasar.dbflute.helper.jdbc.schemainitializer.DfSchemaInitializerJdbc.callbackTruncateTableByJdbc(DfSchemaInitializerJdbc.java:61)
	at org.seasar.dbflute.helper.jdbc.schemainitializer.DfSchemaInitializerJdbc.truncateTableIfPossible(DfSchemaInitializerJdbc.java:50)
	at org.seasar.dbflute.helper.jdbc.schemainitializer.DfSchemaInitializerJdbc.initializeSchema(DfSchemaInitializerJdbc.java:37)
	at org.seasar.dbflute.task.DfReplaceSchemaTask.initializeSchema(DfReplaceSchemaTask.java:110)
	at org.seasar.dbflute.task.DfReplaceSchemaTask.doExecute(DfReplaceSchemaTask.java:79)
	at org.seasar.dbflute.task.bs.DfAbstractTask.execute(DfAbstractTask.java:69)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
	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:585)
	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: java.sql.SQLException: null,  message from server: "Host
'192.168.1.14' is not allowed to connect to this MySQL server"
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:997)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at org.seasar.dbflute.helper.jdbc.connection.DfSimpleDataSourceCreator.newConnection(DfSimpleDataSourceCreator.java:191)
	... 25 more

Seasar-user メーリングリストの案内