I am not sure if this will work but try to put the following line in your
local.properties.
jdbc.datasourcename.remotelyAccessible=true
I was getting the same error and the above line worked for me. Not sure
though if that is the problem or not. Check the migration guide. It talks
about the above property.
-----Original Message-----
From: Rog�rio Garibalde Miranda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 12:45 PM
To: JRun-Talk
Subject: Error JDBC
I get a error when execute this code:
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.*" %>
<%
try {
InitialContext ic = new InitialContext();
DataSource dataSource (DataSource)ic.lookup("java:comp/env/jdbc/cfsnippets");
Connection con = dataSource.getConnection();
Statement stmt = con.createStatement();
Enumeration fieldNames = session.getAttributeNames();
String formfields = "";
String values = "";
while (fieldNames.hasMoreElements()) {
String name = (String)fieldNames.nextElement();
String key = (String)session.getAttribute(name);
String val = request.getParameter(key);
if (formfields.equals(""))
formfields = key;
else
formfields += ", " + key;
if (values.equals(""))
values = "'" + val + "'";
else
values += ", " + "'" + val + "'";
}
String sql = "INSERT INTO " + "Courses" + "(" + formfields + ") VALUES
(" + values + ")";
stmt.execute(sql);
stmt.close();
con.close();
} catch (SQLException ex) {
throw new ServletException(ex.getMessage());
}
%>
the error:
Exception thrown on line '9' from page
'E:\\Inetpub\\wwwroot\\projetosjsp\\demop\\ban_EntryAction.jsp'.
javax.naming.NameNotFoundException: cfsnippets not found
at allaire.jrun.LocalContext.lookup(../LocalContext.java:214)
at allaire.jrun.LocalContext.lookup(../LocalContext.java:236)
at allaire.jrun.LocalContext.lookup(../LocalContext.java:236)
at allaire.jrun.LocalContext.lookup(../LocalContext.java:236)
at allaire.jrun.LocalContext.lookup(../LocalContext.java:195)
at javax.naming.InitialContext.lookup(InitialContext.java:350)
at
jrun__projetosjsp__demop__ban_EntryAction2ejsp26._jspService(jrun__projetosj
sp__demop__ban_EntryAction2ejsp26.java:51)
at
allaire.jrun.jsp.HttpJSPServlet.service(../jsp/HttpJSPServlet.java:39)
at allaire.jrun.jsp.JSPServlet.service(../jsp/JSPServlet.java:228)
at allaire.jrun.jsp.JSPServlet.service(../jsp/JSPServlet.java:196)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1416)
at
allaire.jrun.session.JRunSessionService.service(../session/JRunSessionServic
e.java:1082)
at
allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:1270)
at
allaire.jrun.servlet.JRunRequestDispatcher.forward(../servlet/JRunRequestDis
patcher.java:89)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1552)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1542)
at
allaire.jrun.servlet.JvmContext.dispatch(../servlet/JvmContext.java:364)
at
allaire.jrun.jrpp.ProxyEndpoint.run(../jrpp/ProxyEndpoint.java:388)
at allaire.jrun.ThreadPool.run(../ThreadPool.java:272)
at allaire.jrun.WorkerThread.run(../WorkerThread.java:75)
but cfsnippets datasource exists.
anybody can help me?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
