Use CF Datasources outside CF

[jtdavidson83]

I need to create a JSP on the coldfusion server, and access coldfusion datasources in that JSP. Is there anyway to do this in CF6.1 or CF7.

Thanks.

[robsandeh]

I need to do that too with a ColdFusion MX7.1 Server configuration.

Here's the code for a J2EE configuration.

String sql = "SELECT trip_id, name, teaser, price FROM trip";
java.sql.Connection connection=null;
java.sql.Statement stmt=null;
java.sql.ResultSet trips=null;
javax.naming.InitialContext ctx = new javax.naming.InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)
ctx.lookup("java:comp/env/jdbc/ds-name");
connection=ds.getConnection();
stmt=connection.createStatement();
trips=stmt.executeQuery(sql);