Joe,
1. I modified those 3 xml files (using diffkit 0.8.3 version) with the
database connection information to execute the following command
java -jar diffkit-app.jar -test flavors=SQLSERVER
it says
"can't connect to database for connectioninfo->DKDBConnectionInfo[Sql
Server<flavor=SQLSERVER,database=.....>], skipping. couldn't validate
flavor->SQLSERVER, skipping."
2. I try modifying plan file, lhs and rhs files with the database
connection information to execute
java -jar ..\diffkit-app.jar -planfiles test18.plan.xml,
test18.lhs.dbConnectionInfo.sqlserver.xml,
test18.rhs.dbConnectionInfo.sqlserver.xml
I get the following error message
DiffKit home->C:\Documents and Settings\My Documents\App folder
\DiffKit 0
.8.3\DiffKit
planfile(s)->test18.plan.xml
ERROR[05:55:27.248]{main}(DKApplication.main:130)-null
java.lang.RuntimeException: java.lang.RuntimeException: Could not
resolve automa
tically; need rule for dependency-
>Dependency[(DKPassthroughPlan,null)]
at
org.diffkit.diff.conf.DKMagicPlan.getBuiltPlan(DKMagicPlan.java:290)
[diffkit-app.jar:na]
at
org.diffkit.diff.conf.DKMagicPlan.getLhsSource(DKMagicPlan.java:267)
[diffkit-app.jar:na]
at
org.diffkit.diff.conf.DKApplication.runPlan(DKApplication.java:162) [
diffkit-app.jar:na]
at org.diffkit.diff.conf.DKApplication.main(DKApplication.java:
110) [dif
fkit-app.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[na:1.6.0
_17]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
[na:1.6.0
_17]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source) [na:1
.6.0_17]
at java.lang.reflect.Method.invoke(Unknown Source) [na:
1.6.0_17]
at
com.jdotsoft.jarloader.JarClassLoader.invokeMain(JarClassLoader.java:
520) [diffkit-app.jar:na]
at org.diffkit.diff.conf.DKLauncher.main(DKLauncher.java:26)
[diffkit-ap
p.jar:na]
Caused by: java.lang.RuntimeException: Could not resolve
automatically; need rul
e for dependency->Dependency[(DKPassthroughPlan,null)]
at
org.diffkit.diff.conf.DKMagicPlanBuilder.resolve(DKMagicPlanBuilder.j
ava:110) [diffkit-app.jar:na]
at
org.diffkit.diff.conf.DKMagicPlanBuilder.build(DKMagicPlanBuilder.jav
a:56) [diffkit-app.jar:na]
at
org.diffkit.diff.conf.DKMagicPlan.getBuiltPlan(DKMagicPlan.java:287)
[diffkit-app.jar:na]
... 9 common frames omitted
Caused by: java.lang.RuntimeException: Could not resolve
automatically; need rul
e for dependency-
>Dependency[DKPassthroughPlan(DKDBSource,lhsSource_)]
at
org.diffkit.diff.conf.DKMagicPlanBuilder.resolve(DKMagicPlanBuilder.j
ava:102) [diffkit-app.jar:na]
... 11 common frames omitted
Caused by: java.lang.RuntimeException: Could not resolve
automatically; need rul
e for dependency-
>Dependency[DKPassthroughPlan(DKDBSource,lhsSource_)]
at
org.diffkit.diff.conf.DKMagicPlanBuilder.resolve(DKMagicPlanBuilder.j
ava:110) [diffkit-app.jar:na]
at
org.diffkit.diff.conf.DKMagicPlanBuilder.resolve(DKMagicPlanBuilder.j
ava:82) [diffkit-app.jar:na]
at
org.diffkit.diff.conf.DKMagicPlanBuilder.resolve(DKMagicPlanBuilder.j
ava:99) [diffkit-app.jar:na]
... 11 common frames omitted
Caused by: java.lang.reflect.InvocationTargetException: null
at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[na:1.6.0_17]
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[na:1.6.0_17]
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce) [na:1.6.0_17]
at java.lang.reflect.Constructor.newInstance(Unknown Source)
[na:1.6.0_1
7]
at
org.diffkit.diff.conf.DKMagicDependency.resolve(DKMagicDependency.jav
a:165) [diffkit-app.jar:na]
at
org.diffkit.diff.conf.DKMagicPlanBuilder.resolve(DKMagicPlanBuilder.j
ava:107) [diffkit-app.jar:na]
... 13 common frames omitted
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP
connectio
n to the host <..hostname..>, port 1433 has failed. Error: "connect
ti
med out. Verify the connection properties, check that an instance of
SQL Server
is running on the host and accepting TCP/IP connections at the port,
and that no
firewall is blocking TCP connections to the port.".
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(S
QLServerException.java:171) [diffkit-app.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLSer
verConnection.java:1033) [diffkit-app.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConne
ction.java:817) [diffkit-app.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerCon
nection.java:700) [diffkit-app.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.
java:842) [diffkit-app.jar:na]
at java.sql.DriverManager.getConnection(Unknown Source) [na:
1.6.0_17]
at java.sql.DriverManager.getConnection(Unknown Source) [na:
1.6.0_17]
at org.diffkit.db.DKDatabase.getConnection(DKDatabase.java:75)
[diffkit-
app.jar:na]
at
org.diffkit.db.DKDBTableDataAccess.getConnection(DKDBTableDataAccess.
java:244) [diffkit-app.jar:na]
at
org.diffkit.db.DKDBTableDataAccess.getTables(DKDBTableDataAccess.java
:101) [diffkit-app.jar:na]
at
org.diffkit.db.DKDBTableDataAccess.getTable(DKDBTableDataAccess.java:
88) [diffkit-app.jar:na]
at
org.diffkit.db.DKDBTableDataAccess.getTable(DKDBTableDataAccess.java:
76) [diffkit-app.jar:na]
at org.diffkit.diff.sns.DKDBSource.getTable(DKDBSource.java:
239) [diffki
t-app.jar:na]
at org.diffkit.diff.sns.DKDBSource.<init>(DKDBSource.java:98)
[diffkit-a
pp.jar:na]
... 19 common frames omitted
I verified the connection string by opening connection from code. It
works absolutely fine. Here it fails though..Kindly help in resolving
this. Also let me know if I need to try out some other command to
understand where it fails. I get similar errors for ORACLE as well
(for both commands)
Thanks & Regards,
Vinu