Database Testing - System Testing @ OneStopTesting - System Testing @ OneStopTesting - Types Of Software Testing @ OneStopTesting

Author

Message

swatitanguturi
Newbie
Newbie

Joined: 02Jan2008
Online Status: Offline
Posts: 1

Topic: Database Testing
Posted: 02Jan2008 at 11:24pm

How to do the testing of stored procedures

Post Resume: Click here to Upload your Resume & Apply for Jobs

IP Logged

reddysborra
Newbie
Newbie

Joined: 11Feb2008
Location: India
Online Status: Offline
Posts: 1

Posted: 11Feb2008 at 8:27am

Hi,

This is srinivas reddy working in IBM Bangalore. I have 4+ years experience in tesing in manual and performance testing. Send your updated resume if you are looking for a job in testing side

Thanks & Regards

Srinivasulu Reddy

IP Logged

itsshantha
Newbie
Newbie

Joined: 25Mar2008
Location: United Kingdom
Online Status: Offline
Posts: 1

Posted: 07May2008 at 12:25am

hi srini,

i`m shanthakumar working as a software test engineer.i need ur mail id

thax

its shantha

IP Logged

chandu2556557
Newbie
Newbie

Joined: 14May2008
Location: India
Online Status: Offline
Posts: 1

Posted: 15May2008 at 2:58am

using toad tool u can do database testing if u need u can go for open source DBMonster tool

IP Logged

getzephyr
Groupie
Groupie

Joined: 25Jan2008
Online Status: Offline
Posts: 47

Posted: 30Jul2008 at 3:40am

Database tests are supported via ODBC using the following functions:
SQLOpen, SQLClose, SQLError, SQLRetrieve, SQLRetrieveToFile, SQLExecQuery, SQLGetSchema and SQLRequest.

IP Logged

AJAX123
Newbie
Newbie

Joined: 08Jan2009
Location: United States
Online Status: Offline
Posts: 1

Posted: 08Jan2009 at 12:28am

Can i know What is Toad tool ?..

Where it wil be use?...

IP Logged

tossy
Groupie
Groupie

Joined: 20Aug2008
Online Status: Offline
Posts: 99

Posted: 09Feb2009 at 4:06am

DbUnit works best as a database seeding framework. If you’d like to test a stored proc, then use DbUnit to seed the database with a known set of data, then call the stored proc via your test case and assert that returns the desired result.
You may need to use the combination of DBUnit[to simulate different database states] with sqlunit[for testing stored procedures..http://sqlunit.sourceforge.net]

IP Logged


One Stop Testing Forum : Types Of Software Testing @ OneStopTesting : System Testing @ OneStopTesting

Author	Message
swatitanguturi Newbie Joined: 02Jan2008 Online Status: Offline Posts: 1	Topic: Database Testing Posted: 02Jan2008 at 11:24pm
	How to do the testing of stored procedures Post Resume: Click here to Upload your Resume & Apply for Jobs

	IP Logged

reddysborra Newbie Joined: 11Feb2008 Location: India Online Status: Offline Posts: 1	Posted: 11Feb2008 at 8:27am
	Hi, This is srinivas reddy working in IBM Bangalore. I have 4+ years experience in tesing in manual and performance testing. Send your updated resume if you are looking for a job in testing side Thanks & Regards Srinivasulu Reddy
	IP Logged

itsshantha Newbie Joined: 25Mar2008 Location: United Kingdom Online Status: Offline Posts: 1	Posted: 07May2008 at 12:25am
	hi srini, i`m shanthakumar working as a software test engineer.i need ur mail id thax its shantha
	IP Logged

chandu2556557 Newbie Joined: 14May2008 Location: India Online Status: Offline Posts: 1	Posted: 15May2008 at 2:58am
	using toad tool u can do database testing if u need u can go for open source DBMonster tool
	IP Logged

getzephyr Groupie Joined: 25Jan2008 Online Status: Offline Posts: 47	Posted: 30Jul2008 at 3:40am
	Database tests are supported via ODBC using the following functions: SQLOpen, SQLClose, SQLError, SQLRetrieve, SQLRetrieveToFile, SQLExecQuery, SQLGetSchema and SQLRequest.
	IP Logged

AJAX123 Newbie Joined: 08Jan2009 Location: United States Online Status: Offline Posts: 1	Posted: 08Jan2009 at 12:28am
	Can i know What is Toad tool ?.. Where it wil be use?...
	IP Logged

tossy Groupie Joined: 20Aug2008 Online Status: Offline Posts: 99	Posted: 09Feb2009 at 4:06am
	DbUnit works best as a database seeding framework. If you’d like to test a stored proc, then use DbUnit to seed the database with a known set of data, then call the stored proc via your test case and assert that returns the desired result. You may need to use the combination of DBUnit[to simulate different database states] with sqlunit[for testing stored procedures..http://sqlunit.sourceforge.net]

	IP Logged