Hi guys , Im trying to get data from an external DB on a 2012 sql server environment I know that this module only caters for ms 2005 and 2008 Is there any way i can manipulate the execute query to parse the schema and get my data into my app this is query thats fails becasue it does not have the schema attached : SELECT [mainTable].[ReplyID] AS [ReplyID] , [mainTable].[EventID] AS [EventID] , [mainTable].[InsertDate] AS [InsertDate] , [mainTable].[ReceivedDateTime] AS [ReceivedDateTime] , [mainTable].[NumFrom] AS [NumFrom] , [mainTable].[UpdateDate] AS [UpdateDate] , [mainTable].[ReceivedData] AS [ReceivedData] , [mainTable].[SentCustomerID] AS [SentCustomerID] , [mainTable].[SentID] AS [SenAtID] , [mainTable].[SMSPortalUser] AS [SMSPortalUser] FROM [SMSReply] AS [mainTable] return invalid object SmsReply The query should be like this SELECT [mainTable].[ReplyID] AS [ReplyID] , [mainTable].[EventID] AS [EventID] , [mainTable].[InsertDate] AS [InsertDate] , [mainTable].[ReceivedDateTime] AS [ReceivedDateTime] , [mainTable].[NumFrom] AS [NumFrom] , [mainTable].[UpdateDate] AS [UpdateDate] , [mainTable].[ReceivedData] AS [ReceivedData] , [mainTable].[SentCustomerID] AS [SentCustomerID] , [mainTable].[SentID] AS [SenAtID] , [mainTable].[SMSPortalUser] AS [SMSPortalUser] FROM [api].[SMSReply] AS [mainTable] note 'API' schema Any ideas?
asked
Slade Augustine
1 answers
0
You can dive into the java code and modify the getObjectNameForSyntax or processTableName from DatabaseConnector.java.