If an oracle data source cannot be in oracle tnsnames. Ora file definition, and want to in the parameter file (ini) or are extracted from the data in the table the IP, SID information, such as how to dynamically generate oracle connection string or using other methods to connect to the oracle? Please your comment, thanks!

CodePudding user response:

Using the JDBC connect

CodePudding user response:

Agree to use JDBC connection

CodePudding user response:

Look at the trouble: http://topic.csdn.net/u/20080325/17/16a4b5ba-0a69-4ba3-9926-a183e7fa4b94.html
Another: Oralce10 PB9 how to use the JDBC links:
The SQLCA. DBMS="JDBC"
The SQLCA. LogPass="123"
The SQLCA. LogId="system"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="Driver='... The oracle JDBC Driver OracleDriver ', URL='JDBC: oracle: thin: @ 192.168.0.1:1521: wouldn'"
Connect using the sqlca;
Always tip: Count not load class. Oracle. JDBC driver. OracleDriver
Also need any driver files?
To refer to a bright way, super urgent

CodePudding user response:

Give you stick a source

//configuration data
//Profile BDJXPG
The SQLCA. DBMS="O90 Oracle9i (9.0.1)"
The SQLCA. LogPass="DB4S. SERVER"//"DB4S. 114
"The SQLCA. ServerName="DB4S"
The SQLCA. LogId="test"
The SQLCA. The AutoCommit=False
SQLCA. DBParm="PBCatalogOwner=test, TableCriteria='test,"
Connect using the sqlca;
Guo_sound=CREATE uo_command
//validate whether the database connection is successful
IF the SQLCA. SQLCODE=0 THEN
//open bulletin window
//open (w_ggl)
//initialize the environment variable array
F_checkprocinvalid ()
Coding gs_envparameter []={" unit ", ""," name ", ""," actual number ", ""," outnumbered ", ""," operator ", ""," system date ", ""," system time ", ""," client IP ", ""," host name ", ""," user role ", ""," user type ", ""," user name ", ""}
//create user permissions object
Iuo_getright=create uo_getright
Open (w_login)
//OPEN (w_chose1)
The ELSE
MessageBox (" system information ", "cannot connect to the database, please cooperate with the administrator check the network status!
")Return
END the IF

CodePudding user response:

Lz want?