# Integration testing

**URL:** <https://www.ruby-forum.com/t/integration-testing/181469>\
**Category:** Rails\
**Created:** [January 12, 2010, 2:17pm UTC](https://www.ruby-forum.com/t/integration-testing/181469 "2010-01-12T14:17:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hemantborole](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/b782af/32.png) [@hemantborole](https://www.ruby-forum.com/u/hemantborole)\
**Post date:** [January 12, 2010, 2:17pm UTC](https://www.ruby-forum.com/t/integration-testing/181469/1 "2010-01-12T14:17:01Z")

</div>

Hi Champs,  
Actually i am writing integration tests for my application. I am working  
on the test environment. I am checking out that -

- Are all the pages accessible to admin by creating a session ?
- The same way are the same pages are not accessible to normal user?

I have defined a module and running a simple get request to it as like

def test\_access\_pages\_admin  
get “employees”  
assert\_response :success  
assert\_template “employees/login\_page”  
end

But i am getting error over here. Error is-  
“ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your  
SQL syntax; check the manual that corresponds to your MySQL server  
version for the right syntax to use near ‘RELEASE SAVEPOINT  
active\_record\_1’ at line 1: RELEASE SAVEPOINT active\_record\_1”

Can someone light me the right direction. Waiting for every possible  
answer.

---

<div class="post-metadata">

**Author:** ![hemantborole](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/b782af/32.png) [@hemantborole](https://www.ruby-forum.com/u/hemantborole)\
**Post date:** [January 12, 2010, 5:44pm UTC](https://www.ruby-forum.com/t/integration-testing/181469/2 "2010-01-12T17:44:57Z")

</div>

Hemant B. wrote:

> Hi Champs,  
> Actually i am writing integration tests for my application.

Why are you doing that? Use Cucumber instead. It does the same job,  
but it’s much easier to work with.

Best,  
–Â  
Marnen Laibow-Koser  
[http://www.marnen.org](http://www.marnen.org)  
removed\_email\_address@domain.invalid