Marilyn Miers
|
| Posted: 03/11/2002, 11:33 PM |
|
How do I use Codecharge to connect to a database using JDBC drivers which
require DriverManager creation of objects? For example, Thin drivers.
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@172.31.61.2:1526:test", "tech", "tech");
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 03/12/2002, 2:41 AM |
|
You can do this in Modules "Custom connection" event ,
or obtain generated code in common even and modify code as needed.
--
Alex
CodeCharge Developer
"Marilyn Miers" <mimaclit69@hotmail.com> wrote in message
news:a6kb05$tbi$1@news.codecharge.com...
> How do I use Codecharge to connect to a database using JDBC drivers which
> require DriverManager creation of objects? For example, Thin drivers.
>
> DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
> Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:@172.31.61.2:1526:test", "tech", "tech");
>
>
>
|
|
|
|
Stephens
|
| Posted: 03/23/2002, 11:13 AM |
|
Hi, To use the Oracle JDBC thin driver....
From CC Properties-Database....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
Hope this helps!
Rogers
Marilyn Miers wrote:
> How do I use Codecharge to connect to a database using JDBC drivers which
> require DriverManager creation of objects? For example, Thin drivers.
>
> DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
> Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:@172.31.61.2:1526:test", "tech", "tech");
|
|
|
|
|
