Hi all,
Just tried ddlutils today. The XML it generates from database looks greate.
But I have problem with reading XML.
When I was trying to read the XML file generated back to an empty
database(SQL Server), there are exceptions which say: The column nr 5 in
table XXX has no type. However, the XML file really had type attribute and
value for all the columns.
What's the problem there? How could I fix it?
Another problem, I also tied to read a database into model and then write to
an empty database. The exceptions are as follow.
Exception in thread "main" *org.apache.ddlutils.DynaSqlException*: Error
while executing SQL CREATE TABLE "EventSource"
(
"EventSourceID" NUMERIC(9,0) NOT NULL,
"EventSourceTypeFK" NUMERIC(9,0) NOT NULL,
"Name" VARCHAR(100) NOT NULL,
"LoggedBy" VARCHAR(50) DEFAULT 'N'iCMS'' NOT NULL,
"LicenseeFK" NUMERIC(8,0) NOT NULL,
PRIMARY KEY ("EventSourceID")
)
at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(*
PlatformImplBase.java:218*)
at org.apache.ddlutils.platform.PlatformImplBase.createTables(*
PlatformImplBase.java:311*)
at org.apache.ddlutils.platform.PlatformImplBase.createTables(*
PlatformImplBase.java:296*)
at Engine.db2xmlEngine.writeXMLToDatabase(*db2xmlEngine.java:71*)
at Engine.db2xmlEngine.main(*db2xmlEngine.java:42*)
Caused by: *java.sql.SQLException*: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Line 6: Incorrect syntax near 'iCMS'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdate(Unknown Source)
at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(*
PlatformImplBase.java:202*)
... 4 more
Can anyone give me some confidence that ddlutils really works on SQL Server.
I mean can create tables, insert records from reading XML file which
generated from other databases.
