import java.sql.*;public class conn
{
public static void main(String[] args)
throws SQLException, ClassNotFoundException
{
String username="sysdba";
String password="masterkey";
String url = "jdbc:firebirdsql:localhost/3050:D:\\works\\java\\database\\testdata.gdb";
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection myConnection = DriverManager.getConnection(url,username,password);
Statement myOperation = myConnection.createStatement();
System.out.println("Access OK");
myOperation.close();
myConnection.close();
}
}
============================================================================
java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at webapps.conn.main(conn.java:16)
Exception in thread "main" 请各位高手赐教,,
{
public static void main(String[] args)
throws SQLException, ClassNotFoundException
{
String username="sysdba";
String password="masterkey";
String url = "jdbc:firebirdsql:localhost/3050:D:\\works\\java\\database\\testdata.gdb";
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection myConnection = DriverManager.getConnection(url,username,password);
Statement myOperation = myConnection.createStatement();
System.out.println("Access OK");
myOperation.close();
myConnection.close();
}
}
============================================================================
java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at webapps.conn.main(conn.java:16)
Exception in thread "main" 请各位高手赐教,,
请把你的数据库的jdbc发过来,我帮你解决。
my eMail: [email protected]
你用的web服务器是什么?
只有把这些告诉我,才能帮你解决问题。
如果是作为bean运行,如果是tomcat的服务器,就把含有数据库驱动的jar包拷贝到tomcat\common\lib下,其他的服务器类似
如果是作为bean运行,如果是tomcat的服务器,就把含有数据库驱动的jar包拷贝到tomcat\common\lib下,其他的服务器类似
Web服务器 Apache2.0 & Tomcat4.01
但是如果是作为一个Application是如何做法,,JSP的又是如何??
有了,
<head>
<title>
Jdbc Setup Test
</title>
</head>
<body>
<h1>
Jdbc setup test
</h1>
<%
java.sql.Connection cn;
Class.forName("org.firebirdsql.jdbc.FBDriver");
cn = DriverManager.getConnection("jdbc:firebirdsql://localhost:3050/KlSite/123.gdb", "sysdba", "masterkey");cn.close();
%>
<p>
if this message displays in the browser,<br>
your jdbc connenction is set up properly.
</p>
<br>
</body>
</html>
====================================================================
这是JSP的代码,,已经把含有数据库驱动的jar包拷贝到tomcat\common\lib下,,可是依然出错,,
Reason: Unable to complete network request to host "localhost".
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:536)
at org.apache.jsp.fb_jsp._jspService(fb_jsp.java:69)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:263)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:562)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)
难道你的数据库不是在本机上的?
有的话,他的帮助文档里会有详细介绍!
另外,Firebird 的话最好用Delphi的DBExpress
不过,Delphi在Web方面实在是.........
另外你看看可不可以用ODBC-JDBC桥接
localhost前面有两个//, 被注释掉了。
改为来机的IP试试看。
出错提示
localhost前面有两个//, 被注释掉了。
改为来机的IP试试看。
==============================================================================
都试过,,两个字"不行"
Unable to complete network request to host "localhost"
这个错误我实在是没碰到过
上google搜索了一下,解决方案大都是让修改windows的hosts
Windows NT:
\winnt\system32\drivers\etc\hosts
Windows 95: \windows\hosts ########################
# HOSTS file example
#
# This file allows an InterBase Client resolve a
# Server by its 'host_name' or 'IP' address.
#
# Format:
#
# IP address hostname.domain Description 127.0.0.1 localhost #Common to all TCP祝你好运!