Dave Tolls wrote:Both SQL Server (the target DB) and Oracle have a max column limit of 1000 (well, I think it's 1024).
Which possibly leaves an issue with the driver?
Ok,
Following scenarios troubleshooting
Lets say Table in Target DB is MY_CUST in MSSQL
- Is there any issue source Oracle DB [ Synonym/ Table]
Created a dummy table with 103 coums [ Table, and Synonym was working fine]
- The Problem is only with a synonym created for table@ DBLink , unable to trouble shoot is it Hibernate / Env
Can you guide ,what else can be troubleshooted