Sponsored Content
Full Discussion: using jdbc:thin in bash
Top Forums Shell Programming and Scripting using jdbc:thin in bash Post 302488371 by gdan2000 on Monday 17th of January 2011 02:19:34 AM
Old 01-17-2011
using jdbc:thin in bash

Hi

I want to include in my script a test for DB connection with jdbc:thin connection string(not using tnsnames.ora)

For example:
Code:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=dsu1a)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ODS)(FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(RETRIES=20)(DELAY=5))))

Thanks

Last edited by Franklin52; 01-17-2011 at 04:30 AM.. Reason: Please use code tags
 

8 More Discussions You Might Find Interesting

1. Linux

configuring same /bash for 4 computer which is thin client

i m doing project on LAN TELEPHONY in Red Hat linux i have files as datbase to store the user name and passeord an all other information. Now i have thin client at my college. so to access /dev/dsp for audio is not possible on server. So i have written code which run on /base since it has... (0 Replies)
Discussion started by: niravuchat
0 Replies

2. SCO

Please help.Thin clients connecting to SCO.

Hi thank you for your help in advance, I am running SCO 5.0.6 with 75 user license And I have thin clients connected (around 50 no.) to it through a terminal server.The problem is that when the thin clients are terminated abnormally it takes a lot of time for me to conect to the SERVER again and... (1 Reply)
Discussion started by: Chaitu.a
1 Replies

3. SuSE

postgresql-jdbc on Suse

Hi, I am writing a Java Swing application and want to add Embedded SQL to it. The application should interact with a PostgreSQL database running on my local machine. The compiler complains that it cannot find the org.postgresql package included in the code. I'm guessing the problem is that... (0 Replies)
Discussion started by: marina
0 Replies

4. Linux

BOOTP on HP Thin clients

Please m new around here! Can anyone take me thru implementing bootp on my thin clients via my central server? Preciate ur assistance. Thanks folks! (2 Replies)
Discussion started by: chuk_uka
2 Replies

5. Shell Programming and Scripting

Unix to Sql Server via JDBC

I am trying to connect SQL SERVER VIA JDCB. Following is something I tried and will appreciate any help what I am doing wrong Here's what I did, I tried several variations, but I keep getting this error: Exception in thread "main" java.sql.SQLException: Unable to connect. Invalid URL I... (1 Reply)
Discussion started by: cqldba
1 Replies

6. Ubuntu

JDBC Connection

Hi, I am using ubuntu os.I need some information about JDBC connection. 1.how to connect eclipse with apache tomcat server 2.I am using mysql database,how to to find the database location 3.How to set the classpath 4.How to connect Mysql with java using eclipse.I need step by step procedure... (1 Reply)
Discussion started by: snallusami
1 Replies

7. AIX

Thin clients for AIX desktop

Hello, I've been on Sun gear for years, using Sun Rays. With the news that Sun Ray is to be discontinued, I've taken an interest in researching other thin client solutions. I'm interested in using the thin clients on Solaris/SPARC, but also in future, quite possibly on AIX. So, what simple thin... (8 Replies)
Discussion started by: thegman
8 Replies

8. Linux

Converct fat pc to thin client

I have old pc with 1gb ram and i wont to convert him to thin clint to connect rdp windos With software i need to install on my computer? I am new in linux.. Sent from my SM-J5108 using Tapatalk (10 Replies)
Discussion started by: popcoern
10 Replies
asadmin-ping-connection-pool(1AS)				   User Commands				 asadmin-ping-connection-pool(1AS)

NAME
asadmin-ping-connection-pool, ping-connection-pool - tests that a connection pool is usable SYNOPSIS
ping-connection-pool --user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename] [--terse=false] [--echo=false] [--interactive=true] pool_name Tests that a connection pool is usable for both JDBC connection pools and connector connection pools. For example, if you create a new JDBC connection pool for use with an application that is expected to be deployed, before deploying the application, the previously created pool is tested with this command. This command is supported in remote mode only. OPTIONS
--user authorized domain application server administrative username. --password password to administer the domain application server. --host machine name where the domain application server is running. --port port number of the domain application server listening for administration requests. --secure if true, uses SSL/TLS to communicate with the domain application server. --passwordfile file containing the domain application server password. --terse indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well- formatted data for consumption by a script. Default is false. --echo setting to true will echo the command line statement on the standard output. Default is false. --interactive if set to true (default), only the required password options are prompted. OPERANDS
poolname name of the connection pool to be tested. Example 1: Using ping-connection-pool Before you can ping a connection pool, you must: o Create a connection pool with authentication. o Make sure the Enterprise Information Server (can be the database) is started. asadmin> ping-connection-pool --user admin1 --password adminadmin1 --host pigeon --port 5001 sampleConnectionPool Command ping-connection-pool executed successfully EXIT STATUS
0 command executed successfully 1 error in executing the command asadmin-create-connector-connection-pool(1AS), asadmin-delete-connector-connection-pool(1AS), asadmin-list-connector-connection-pool(1AS), asadmin-create-jdbc-connection-pool(1AS), asadmin-delete--jdbc-connection-pool(1AS)asadmin- list--jdbc-connection-pools(1AS) J2EE 1.4 SDK March 2004 asadmin-ping-connection-pool(1AS)
All times are GMT -4. The time now is 06:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy