Please someone help me, how to configure Oracle or SQL Server with J2EE Application Server Resource.
I tried but got the error: class resource error.
Also for Derby database, the error is with the user name and password.
Thanks in advance for the unknown's immediate help..
- Xavi
Hi,
Please see the following doc which is relevant for Sun Java System Application Server 8.1. It contains the configuratoin information for setting up the JDBC connections with Oracle and SQL Server:
http://docs.sun.com/source/817-6087/dgjdbc.html
(Note that if you are using a different version of app server this doc may not be relevant, but you should be able to find the correct doc at http://docs.sun.com/app/docs/prod/sjs.asse#hic)
If you are getting Class not found errors it may be due to you not having the JDBC driver in your classpath. Please make sure that you have the correct drivers and that they are in your classpath. You can ensure that they are picked up by putting the relevant jar files into domain_dir/lib/ext and restarting the server.
If you are still having problems please copy the exact error that you are getting in the log files into your post, and also please tell us which version of App Server that you are using.
Hope this helps
