Soulinger
|
| Posted: 03/11/2002, 6:42 AM |
|
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?
|
|
|
 |
Stephens
|
| Posted: 03/23/2002, 10:59 AM |
|
Hi,
To connect to Oracle (on any remove platform) via JSP using the Oracle JDBC
thin-driver:
- open the database tab in the properties section in code charge
- in the "design" section (which is the connection to the database when using
code charge to design site) use the Oracle ODBC driver installed on your
windows box to point to your database (select the DSN setup for your database
as specified in Windows-Control Panel-ODBC).
- in the "server" section specify the Oracle JDBC thin driver settings as:
- connection string =
jdbc:oracle:thin:scott/tiger@localhost:1521:instanceSID
(where scott is the user id, tiger is password, localhost is the host
where oracle resides, 1521 is the port the oracle listener is listening on, and
instanceSID is your SID for the db which might be optional.)
- Login and Password = I leave these blank b/c they are in the connection
string
- Database Driver = oracle.jdbc.driver.OracleDriver
- Use the oracle join style
Hope this helps!
Rogers
Soulinger wrote:
> 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?
|
|
|
|
Stephens
|
| Posted: 03/23/2002, 11:00 AM |
|
Hi,
To connect to Oracle (on any remove platform) via JSP using the Oracle JDBC
thin-driver:
- open the database tab in the properties section in code charge
- in the "design" section (which is the connection to the database when using
code charge to design site) use the Oracle ODBC driver installed on your
windows box to point to your database (select the DSN setup for your database
as specified in Windows-Control Panel-ODBC).
- in the "server" section specify the Oracle JDBC thin driver settings as:
- connection string =
jdbc:oracle:thin:scott/tiger@localhost:1521:instanceSID
(where scott is the user id, tiger is password, localhost is the host
where oracle resides, 1521 is the port the oracle listener is listening on, and
instanceSID is your SID for the db which might be optional.)
- Login and Password = I leave these blank b/c they are in the connection
string
- Database Driver = oracle.jdbc.driver.OracleDriver
- Use the oracle join style
Hope this helps!
Rogers
Soulinger wrote:
> 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?
|
|
|
|
Stephens
|
| Posted: 03/23/2002, 11:01 AM |
|
Hi,
To connect to Oracle (on any remove platform) via JSP using the Oracle JDBC
thin-driver:
- open the database tab in the properties section in code charge
- in the "design" section (which is the connection to the database when using
code charge to design site) use the Oracle ODBC driver installed on your
windows box to point to your database (select the DSN setup for your database
as specified in Windows-Control Panel-ODBC).
- in the "server" section specify the Oracle JDBC thin driver settings as:
- connection string =
jdbc:oracle:thin:scott/tiger@localhost:1521:instanceSID
(where scott is the user id, tiger is password, localhost is the host
where oracle resides, 1521 is the port the oracle listener is listening on, and
instanceSID is your SID for the db which might be optional.)
- Login and Password = I leave these blank b/c they are in the connection
string
- Database Driver = oracle.jdbc.driver.OracleDriver
- Use the oracle join style
Hope this helps!
Rogers
Soulinger wrote:
> 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?
|
|
|
|
Stephens
|
| Posted: 03/23/2002, 11:02 AM |
|
Hi,
To connect to Oracle (on any remove platform) via JSP using the Oracle JDBC
thin-driver:
- open the database tab in the properties section in code charge
- in the "design" section (which is the connection to the database when using
code charge to design site) use the Oracle ODBC driver installed on your
windows box to point to your database (select the DSN setup for your database
as specified in Windows-Control Panel-ODBC).
- in the "server" section specify the Oracle JDBC thin driver settings as:
- connection string =
jdbc:oracle:thin:scott/tiger@localhost:1521:instanceSID
(where scott is the user id, tiger is password, localhost is the host
where oracle resides, 1521 is the port the oracle listener is listening on, and
instanceSID is your SID for the db which might be optional.)
- Login and Password = I leave these blank b/c they are in the connection
string
- Database Driver = oracle.jdbc.driver.OracleDriver
- Use the oracle join style
Hope this helps!
Rogers
Soulinger wrote:
> 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?
|
|
|
|
Stephens
|
| Posted: 03/23/2002, 11:03 AM |
|
Hi,
To connect to Oracle (on any remove platform) via JSP using the Oracle JDBC
thin-driver:
- open the database tab in the properties section in code charge
- in the "design" section (which is the connection to the database when using
code charge to design site) use the Oracle ODBC driver installed on your
windows box to point to your database (select the DSN setup for your database
as specified in Windows-Control Panel-ODBC).
- in the "server" section specify the Oracle JDBC thin driver settings as:
- connection string =
jdbc:oracle:thin:scott/tiger@localhost:1521:instanceSID
(where scott is the user id, tiger is password, localhost is the host
where oracle resides, 1521 is the port the oracle listener is listening on, and
instanceSID is your SID for the db which might be optional.)
- Login and Password = I leave these blank b/c they are in the connection
string
- Database Driver = oracle.jdbc.driver.OracleDriver
- Use the oracle join style
Hope this helps!
Rogers
Soulinger wrote:
> 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?
|
|
|
|
Stephens
|
| Posted: 03/23/2002, 11:04 AM |
|
sorry for multiple posts.....had a email configuration problem...
Stephens wrote:
> Hi,
>
> To connect to Oracle (on any remove platform) via JSP using the Oracle JDBC
> thin-driver:
>
> - open the database tab in the properties section in code charge
> - in the "design" section (which is the connection to the database when using
> code charge to design site) use the Oracle ODBC driver installed on your
> windows box to point to your database (select the DSN setup for your database
> as specified in Windows-Control Panel-ODBC).
> - in the "server" section specify the Oracle JDBC thin driver settings as:
> - connection string =
> jdbc:oracle:thin:scott/tiger@localhost:1521:instanceSID
> (where scott is the user id, tiger is password, localhost is the host
> where oracle resides, 1521 is the port the oracle listener is listening on, and
> instanceSID is your SID for the db which might be optional.)
> - Login and Password = I leave these blank b/c they are in the connection
> string
> - Database Driver = oracle.jdbc.driver.OracleDriver
> - Use the oracle join style
>
> Hope this helps!
> Rogers
>
> Soulinger wrote:
>
> > 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?
|
|
|
|
|
