Hi All ,
I am facing a strange issue .After upgrading to the latest version my models with CSV exports are not working .I have done few checks and found that , it works only when the table reference comes without a schema name .
For ex - If we have a table country defined in Mysql (not under schema), if we do the import it works and if we have some table city (under schema Xyz) so we refer the table like Xyz.city .
It fails to work .
Same was working on the previous mode .I guess it is a bug in the current plugin .
Please let me know if some one has faced the same issue .
Discussion posts and replies are publicly visible
Hi manishk0001, We are facing the same issue now after upgrading to the latest version of Excel Tools. If you have figured out how to resolve this, could you please share the steps? Many thanks in advance!
Not buggy, however, there should be another input parameter which should take schema name in account.
This is the code snippet which build the insert query:
StringBuffer insertSql = new StringBuffer("insert into ");
insertSql.append(dbType.startQuoteSymbol).append(tableName).append(dbType.endQuoteSymbol).append(" (")
.append(columnsAsList).append(")");
So, if you try putting your table name with schema like ="yourschemaname'.'tablebname", should work.
Edit: use ` rather than '
Many thanks for the help. It enlightened me to go check the source code of the plugin. Agree this isn't a bug!
But we were trying to insert into SQL Server. So, I found how that works with SQL Server too.
MySQL`schemaName`.`tableName`
SQL Server[schemaName].[tableName]
Green colored characters in the above code snippets will be handled by the plugin. So, the 'Table Name' input should be entered in the yellow colored text format shown above.
Can you provide inputs and detailed error stack trace?