problem with data source

Question

Hi,I wanna get data from database so I am using DataSource.now I wanna select one row . When I check * to get all columns I see this data only in preview. When I run this step I cant see any data just in Data Log I see: "Got 1 rows" When I check all columns it work but I have a lot of columns so I wanna use *. and another problem when I want certain column it use ... as ... and this sequence has over 30 characters so it thrown this exception: ORA-00972: identifier is too longCan you help me ?

rjanecek · Answer

so nobody know ?!? I really need help why when I use this select: select * from table  I didint see any of column but in Data Log I see "Got 1 rows in .. ms" . It works only if choose certainly column: select something as something from ... but this I cant use because this thrown exception ORA-00972

smartbear_suppo · Answer

Hi,hm... you will at least need to defined properties in the DataSource corresponding to each column, have you done that?Regarding the "identifier too long" error it seems to be a limitation in the JDBC driver, you might need to explicitly select that column with a specified name..Hope this helps!regards,/OleSmartBear Stockholm

rjanecek · Answer

yes I need to rename all 100+properties which was created by wizard because they have bad name,but I dont know how to solve when 2 database have the same name

smartbear_suppo · Answer

Hi,you would have to explicitly give the overlapping columns different names in the select statement..regards,/OleSmartBear Stockholm

rjanecek · Answer

datasource wizard is bugged. I have column name aaaaaa and then aaaaaab, aaaaaac, aaaaaad. When I check to get these elements it create bad sql request. I have to chose aaaaaa then OK and then another column

Forum Discussion

problem with data source

6 Replies

Recent Discussions

Unable to authenticate license in Ready API Login button unresponsive

Assertions Panel issue to update assertions since update 3.63

ReadyAPI websocket plugin issue

Related Content

in sources control problem

problem with link

data source Loop