Soulinger
|
| Posted: 03/11/2002, 9:40 PM |
|
Can anybody recommendd what connection string to use when I need to use JSP
and Oracle on LINUX operating system? In that case, I don't think Microsoft
drivers can be used.
Currently i'm using
<%@ page import = "java.sql.*" %>
<%
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:oci8:@" ,"abc",
"def");
Statement stmt = conn.createStatement ();
%>
But I have no idea how to use this on CodeCharge to connect to a database.
I tried using oracle.jdbc.driver.OracleDriver() and it can't work. What's
the proper way to use the connection string?
I've tried reading websites but none of them tell me how to use CodeCharge
to use the above connection string or any connection string that is
DNS-less. So this is my last resrouce for any hopes of a solution. Please
help if possible!
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 03/12/2002, 2:20 AM |
|
you better specify the connection not in the code but in
Site/Properitews/Database ,
although it can sure be done in open event. this is not a cc issue , CC
simply generates
a code and connects where you tell him to. all connection parameters
including
driver name can be specified in the above tab. connection string depends on
oracle driver type. you may use standard oracle driver provided with jdk and
see docs about oracle drivers. cc is just a container.
--
Alex
CodeCharge Developer
"Soulinger" <mimaclit69@hotmail.com> wrote in message
news:a6k4cq$i07$1@news.codecharge.com...
> Can anybody recommendd what connection string to use when I need to use
JSP
> and Oracle on LINUX operating system? In that case, I don't think
Microsoft
> drivers can be used.
>
> Currently i'm using
> <%@ page import = "java.sql.*" %>
> <%
> DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> Connection conn = DriverManager.getConnection("jdbc:oracle:oci8:@" ,"abc",
> "def");
> Statement stmt = conn.createStatement ();
> %>
>
> But I have no idea how to use this on CodeCharge to connect to a database.
> I tried using oracle.jdbc.driver.OracleDriver() and it can't work. What's
> the proper way to use the connection string?
>
> I've tried reading websites but none of them tell me how to use CodeCharge
> to use the above connection string or any connection string that is
> DNS-less. So this is my last resrouce for any hopes of a solution. Please
> help if possible!
>
>
|
|
|
|
|
