Hi all,
I'm new to Oracle 10g XE. I wrote a sample code in coldfusion to connect with
Oracle without using the CFM admin panel (DSN-less). However, I get an error
message :

Exception d'E/S: The Network Adapter could not establish the connection


The error occurred in D:\wwwroot\ColdFusion
www\discovery-4\includes\connection.cfm: line 14
12 : class.forName(driver);
13 : dm = createObject("java","java.sql.DriverManager");
14 : con = dm..getConnection("jdbc:oracle:thin:@//beckers.desrep.com:1521",
"Discovery", "discovery");
15 : st = con.createStatement();
16 : resultSet = st.executeQuery(sql);

When I connect through CFM admin, it's working great. Anyway, I need to
automate DB connections. This means connecting directly to Oracle without using
CFM admin.
My code is :

<CFFUNCTION NAME="connectOracle" DESCRITPION="DSN-less Oracle connection">
<CFARGUMENT NAME="JDBC_URL" REQUIRED="yes" HINT="URL of the Oracle server to
connect to.">
<CFARGUMENT NAME="username" REQUIRED="yes" HINT="Oracle username">
<CFARGUMENT NAME="password" REQUIRED="yes" HINT="Oracle password">
<CFARGUMENT NAME="sql" REQUIRED="yes" HINT="SQL to process">
<CFARGUMENT NAME="oraclePort" DEFAULT="1521" HINT="Port where to connect to
the Oracle server (default: 1521)">
<CFARGUMENT NAME="queryName" DEFAULT="recordset" HINT="Name of the query
results (optional); Defaulted to 'recordset'">
<CFARGUMENT NAME="driver" DEFAULT="oracle.jdbc.OracleDriver" HINT="Driver to
use when connecting to server (optional)">

<CFSCRIPT>
class = createObject("java", "java.lang.Class");
class.forName(driver);
dm = createObject("java","java.sql.DriverManager");
con = dm..getConnection("jdbc:oracle:thin:@//beckers.desrep.com:1521:XE",
"Discovery", "discovery");
st = con.createStatement();
resultSet = st.executeQuery(sql);
"#queryName#" = CreateObject("java",
"coldfusion.sql.QueryTable").init(resultSet);
resultSet.close();
st.close();
con.close();
return "#queryName#";
</CFSCRIPT>
</CFFUNCTION>

Can someone help me?

Thanks,

Fr?d?ric