[
https://issues.apache.org/jira/browse/DDLUTILS-183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brian Devaney updated DDLUTILS-183:
-----------------------------------
Attachment: HandleSpaces.patch
This patch affects the JdbcModelReader class only. The
determineAutoIncrementFromResultSetMetaData method generates an sql command.
Each column will be examined for a space and if one is found, the column is
altered to add [ ] around the column name. Similarly, if the table name has a
space in it, the table name will have [ ] placed around it.
> Spaces in column names or table names cause an exception
> --------------------------------------------------------
>
> Key: DDLUTILS-183
> URL: https://issues.apache.org/jira/browse/DDLUTILS-183
> Project: DdlUtils
> Issue Type: Bug
> Components: Core (No specific database)
> Environment: Discovered in MSS SQL Server
> Reporter: Brian Devaney
> Assignee: Thomas Dudziak
> Attachments: HandleSpaces.patch
>
>
> A database table with spaces in the column name or a table name with spaces
> in it will cause an exception to be thrown when and alter script is run on
> that database. This exception was generated when a table named 'flow queue
> 08-31-07' was discovered.
> java.sql.SQLException: Incorrect syntax near 'queue'.
> at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
> at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2778)
> at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2214)
> at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:597)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:343)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1184)
> at
> org.apache.ddlutils.platform.JdbcModelReader.determineAutoIncrementFromResultSetMetaData(JdbcModelReader.java:1068)
> at
> org.apache.ddlutils.platform.mssql.MSSqlModelReader.readTable(MSSqlModelReader.java:105)
> at
> org.apache.ddlutils.platform.JdbcModelReader.readTables(JdbcModelReader.java:516)
> at
> org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:472)
> at
> org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:432)
> at
> org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1962)
> Surrounding the table or the column with [ ] will solve the problem.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
