[cobalt-users] Firebird/ Mysql JDBC install on a raq 550 (tomcat)

["Richard Drent \(Drent IT BV\)" <info@xxxxxxxxxx>]

Hi

Can so body help me out, I would like to install some JDBC on the tomcat
server on a raq 550.

I placed the firebirdSQL.jar as written in the FAQ
	/virtual-site/WEB-INF/lib
and I tried
	/usr/java/Jakarta-tomcat/lib

and I did some restaring of the tomcat and rebooting of the server.
I chmod to +x or 777

I tested with this connecting string

Class.forName("org.firebirdsql.jdbc.FBDriver");

Connection conn = DriverManager.getConnection
("jdbc:firebirdsql://192.168.0.115[:3050] /home/firebird/data/database.fdb",
"sysdba", "pass");

(is an external database server)

and he is still giving this error, copy at the bottom of this msg.


Question 
- what did I do wrong,
- and how to fix.





Thnx for some help
 
 
Richard Drent
 
Drent IT BV

###########################################################################
Error msg
##########################################################################
Error: 500
Location: /connect.jsp
Internal Servlet Error:

javax.servlet.ServletException: access denied (java.io.FilePermission
/home/.sites/28/site1/web/WEB-INF/classes read)
	at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:459)
	at
_0002fconnect_0002ejspconnect_jsp_1._jspService(_0002fconnect_0002ejspconnec
t_jsp_1.java:75)
	at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja
va:130)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:282)
	at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81
2)
	at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
	at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:166)
	at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:484)

Root cause: 
java.security.AccessControlException: access denied (java.io.FilePermission
/home/.sites/28/site1/web/WEB-INF/classes read)
	at
java.security.AccessControlContext.checkPermission(AccessControlContext.java
:272)
	at
java.security.AccessController.checkPermission(AccessController.java:399)
	at
java.lang.SecurityManager.checkPermission(SecurityManager.java:545)
	at java.lang.SecurityManager.checkRead(SecurityManager.java:890)
	at java.io.File.isDirectory(File.java:564)
	at
org.apache.tomcat.loader.AdaptiveClassLoader.loadClass(AdaptiveClassLoader.j
ava:481)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
	at
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:136)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
	at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:120)
	at
_0002fconnect_0002ejspconnect_jsp_1._jspService(_0002fconnect_0002ejspconnec
t_jsp_1.java:62)
	at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja
va:130)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:282)
	at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81
2)
	at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
	at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:166)
	at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:484)