"It is not working" won't get you many answers.
Post the errors, try server/default/server.log
Where did you copy mysite-service.xml from?
Could not derefence object
Sorry I missed putting the error in the message
its working now
I was using java:/comp/env/jdbc/mycustomds what you are suppose to use is java:/mycustomds took an EXTREME amount of searching to find that one out.
Thanks for responding!