Yes m8 this is the first solution that i had checked before... but couldnt achieve my goal...still it throws ejbexception...At last i decided to use usual jdbc connection by getting the datasource in this way:
[i][b]@Resource(name="jdbc/columbusDS")
private DataSource dataSource;[/b][/i]
then get a connection and execute my query...But still there is a problem with this... :( which is i have to learn how to control transactions in usual jdbc :(....
[Message sent by forum member 'ilitheblack' (ilitheblack)]
http://forums.java.net/jive/thread.jspa?messageID=359128