Connection to Oracle DB
818 views
Skip to first unread message
Gary
Feb 28, 2012, 12:57:24 PM2/28/12
to dbfit
I can't even get the HelloWorld app to work...
I keep getting a connection refused error...
Can someone give me the syntax for a connect string to an oracle DB.
I am using this as my HellowWorld text:
!path lib/*.jar
!|dbfit.OracleTest|
!|Connect|(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=red-
devl.test.test.com)(PORT=1522))
(CONNECT_DATA=(SERVICE_NAME=test.world)))| testun | testpw |
!|Query| select 'test' as x from dual|
|x|
|test|
I keep getting a connection refused error...
Can someone give me the syntax for a connect string to an oracle DB.
I am using this as my HellowWorld text:
!path lib/*.jar
!|dbfit.OracleTest|
!|Connect|(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=red-
devl.test.test.com)(PORT=1522))
(CONNECT_DATA=(SERVICE_NAME=test.world)))| testun | testpw |
!|Query| select 'test' as x from dual|
|x|
|test|
Gojko Adzic
Mar 2, 2012, 5:32:10 AM3/2/12
to dbfit
the connection string really depends on the driver you use. if you're
using the thin java driver, you might need to use the full TNS Name,
not the inline connection description as in the example below.
gojko
using the thin java driver, you might need to use the full TNS Name,
not the inline connection description as in the example below.
gojko
MatMan
Mar 2, 2012, 5:47:56 AM3/2/12
to dbfit
For Oracle / JDBC connections using the thin driver I use this for
flow mode: -
|dbfit.OracleTest|
|Connect|MyPcName:1521|dftest|dftest|XE|
This is for the Oracle XE instance running on my PC on port 1521.
Mark
flow mode: -
|dbfit.OracleTest|
|Connect|MyPcName:1521|dftest|dftest|XE|
This is for the Oracle XE instance running on my PC on port 1521.
Mark
Reply all
Reply to author
Forward
0 new messages