[seasar-dotnet:2437] SQLServer2005の接続方法
志水正幸
[E-MAIL ADDRESS DELETED]
2015年 3月 17日 (火) 19:06:07 JST
志水です。
超お世話になっております。
事情がありまして、WindowsXPにインストールされている
SQLServer2005でDBの生成をしたく実行したのですが
下記のエラーとなりました。
こんな古いやつに接続したことがないので弱ってます。
SQLServer2014では接続できるのですが・・・
DBFLUTEの実行クライアント:Windows764bit
DB:WindwosXP SQLServer2005
接続文字列もちょっと怪しいのですが
エラー内容が
「Java ランタイム環境 (JRE) Version 1.6 は、このドライバーではサポートされていません」
となっているのですが
これはドライバ、接続文字列というよりJavaバージョンが怪しいのでしょうか?
お分かりになる方おりませんか?
ご教示お願い致します。
map:{
; driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
; url = jdbc:sqlserver://192.168.1.82:1433;databaseName=XXXX;
; schema = XXXX
; user = XXXX
; password = XXXX
; propertiesMap = map:{includeSynonyms=true}
; variousMap = map:{
; objectTypeTargetList=list:{TABLE;VIEW;SYNONYM}
; tableExceptList = list:{prefix:MLOG$_}
}
}
2015-03-17 18:48:13,659 [main] INFO (DfDBFluteTaskUtil#logFinalMessage():150) -
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
[Final Message]: 00m00s547ms *Abort
DBFLUTE_CLIENT: {sichokyodb}
database = sqlserver
language = csharp
container = seasar
package = SiChokyo.DBFlute
DBFLUTE_ENVIRONMENT_TYPE: {}
driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
url = jdbc:sqlserver://192.168.1.82:1433;databaseName=RENGO10
schema = {RENGO10.RENGO10 as main}
user = RENGO10
props = {includeSynonyms=true}
additionalSchema =
repsEnvType = ut
refreshProject =
_/_/_/_/_/_/_/_/_/_/ {JDBC}
2015-03-17 18:48:43,732 [main] INFO (DfReplaceSchemaTask#begin():87) - +------------------------------------------+
2015-03-17 18:48:43,732 [main] INFO (DfReplaceSchemaTask#begin():88) - | |
2015-03-17 18:48:43,732 [main] INFO (DfReplaceSchemaTask#begin():89) - | ReplaceSchema |
2015-03-17 18:48:43,763 [main] INFO (DfReplaceSchemaTask#begin():97) - | |
2015-03-17 18:48:43,763 [main] INFO (DfReplaceSchemaTask#begin():98) - +------------------------------------------+
2015-03-17 18:48:43,763 [main] INFO (DfReplaceSchemaTask#waitBeforeReps():329) - ...Waiting for your GO SIGN from stdin before ReplaceSchema:
2015-03-17 18:49:17,721 [main] INFO (DfReplaceSchemaTask#begin():87) - +------------------------------------------+
2015-03-17 18:49:17,721 [main] INFO (DfReplaceSchemaTask#begin():88) - | |
2015-03-17 18:49:17,721 [main] INFO (DfReplaceSchemaTask#begin():89) - | ReplaceSchema |
2015-03-17 18:49:17,752 [main] INFO (DfReplaceSchemaTask#begin():97) - | |
2015-03-17 18:49:17,752 [main] INFO (DfReplaceSchemaTask#begin():98) - +------------------------------------------+
2015-03-17 18:49:17,752 [main] INFO (DfReplaceSchemaTask#waitBeforeReps():329) - ...Waiting for your GO SIGN from stdin before ReplaceSchema:
2015-03-17 18:49:20,239 [main] INFO (DfDataSourceHandler#prepare():78) - ...Preparing data source:
2015-03-17 18:49:20,239 [main] INFO (DfDataSourceHandler#prepare():79) - driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
2015-03-17 18:49:20,239 [main] INFO (DfDataSourceHandler#prepare():80) - url = jdbc:sqlserver://192.168.1.82:1433;databaseName=RENGO10
2015-03-17 18:49:20,239 [main] INFO (DfDataSourceHandler#prepare():81) - user = RENGO10
2015-03-17 18:49:20,291 [main] INFO (DfDataSourceHandler#createConnection():168) - ...Connecting to database by data source:
2015-03-17 18:49:20,308 [main] ERROR (DfDBFluteTaskUtil#logException():161) - Look! Read the message below.
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Failed to execute DBFlute Task 'ReplaceSchema'.
[Advice]
Check the exception messages and the stack traces.
* * * * * * * * * */
java.lang.UnsupportedOperationException: Java ランタイム環境 (JRE) Version 1.6 は、このドライバーではサポートされていません。sqljdbc4.jar クラス ライブラリを使用してください。このライブラリでは、JDBC 4.0 がサポートされています。
at com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011)
at org.seasar.dbflute.helper.jdbc.connection.DfDataSourceHandler.createConnection(DfDataSourceHandler.java:169)
at org.seasar.dbflute.helper.jdbc.connection.DfDataSourceHandler.processCachedConnection(DfDataSourceHandler.java:156)
at org.seasar.dbflute.helper.jdbc.connection.DfDataSourceHandler.getConnection(DfDataSourceHandler.java:139)
at org.seasar.dbflute.helper.jdbc.connection.DfFittingDataSource.getConnection(DfFittingDataSource.java:35)
at org.seasar.dbflute.helper.jdbc.context.DfSchemaSource.getConnection(DfSchemaSource.java:88)
at org.seasar.dbflute.task.DfReplaceSchemaTask.setupDataSource(DfReplaceSchemaTask.java:125)
at org.seasar.dbflute.task.bs.DfAbstractTexenTask$1.callSetupDataSource(DfAbstractTexenTask.java:115)
at org.seasar.dbflute.task.bs.assistant.DfTaskBasicController.setupDataSource(DfTaskBasicController.java:165)
at org.seasar.dbflute.task.bs.assistant.DfTaskBasicController.execute(DfTaskBasicController.java:74)
at org.seasar.dbflute.task.bs.DfAbstractTexenTask.execute(DfAbstractTexenTask.java:153)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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)
2015-03-17 18:49:20,342 [main] INFO (DfDBFluteTaskUtil#logFinalMessage():150) -
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
[Final Message]: 00m02s621ms *Abort
DBFLUTE_CLIENT: {sichokyodb}
database = sqlserver
language = csharp
container = seasar
package = SiChokyo.DBFlute
DBFLUTE_ENVIRONMENT_TYPE: {}
driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
url = jdbc:sqlserver://192.168.1.82:1433;databaseName=RENGO10
schema = {RENGO10.RENGO10 as main}
user = RENGO10
props = {includeSynonyms=true}
additionalSchema =
repsEnvType = ut
refreshProject =
_/_/_/_/_/_/_/_/_/_/ {ReplaceSchema}
seasar-dotnet メーリングリストの案内