06-30-2009
Where should i write this code inside my unix script or sql file ? Also where do i put the database name ednamid.world
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Having problem in connecting my gui java program to postgreaql database. I first used setenv classpath /home/share/postgresql/java/postgresql.jar:proj1, where proj1 is my folder conatining all java and class file, to set classpath. Then javac *.java. Then java proj1.Login. It gives me... (2 Replies)
Discussion started by: uci
2 Replies
2. Shell Programming and Scripting
Hi
when i am calling the shell script with two parameter like id and date it works fine.But the same shell script is call by java application it gives the error as shown below
Thu Jan 8 04:13:22 EST 2009|The Get Segment Process Failed: SP2-0306:
Invalid option.
Usage: CONN where <logon>... (1 Reply)
Discussion started by: ravi214u
1 Replies
3. Shell Programming and Scripting
Hi friends,
I'm newbie to shell script. I wanted to create a shell script which able to write a result for all the telnet connection status. For example, from this machine I want to test the telnet connection (total 100+ servers) with this machine.
Any idea how to write this shell script?... (16 Replies)
Discussion started by: yhcheong
16 Replies
4. Shell Programming and Scripting
Hi All,
I'm new here as well as to UNIX.
I need to write a wrapper script to refresh test database with production data. A set of tables are given as well as a particular data range. The script should prompt the user for both production and test logon credentials.
Pl. help me with this.... (2 Replies)
Discussion started by: linslet
2 Replies
5. Shell Programming and Scripting
I am writing a script to do some conditional logic based on the results of a connection test. I need to capture the output of netcat, the 3 expected conditions are as follows. I need to capture the output of this command. I could write this to a file, but I would like to do it clearer if possible.... (1 Reply)
Discussion started by: princeboot
1 Replies
6. Shell Programming and Scripting
I want to test if my host can connect to any of the following 10 hosts (192.168.1.0 to 192.168.1.9)
I didnt know which command i should use, so i chose ping. (i wonder if i should use tracepath or sth else)
my code is the following:
#!/bin/bash
clear
firstPart="192.168.1"
maxNum="9"
... (2 Replies)
Discussion started by: shadow_boi
2 Replies
7. Ubuntu
Hi,
How to creating connection to mysql.I try to connect but the following error coming .How to solve it.
Could not connect to New MySQL.
Error creating SQL Model Connection connection to New MySQL. (Error: com.mysql.jdbc.Driver)
com.mysql.jdbc.Driver
Error creating JDBC Connection... (2 Replies)
Discussion started by: snallusami
2 Replies
8. UNIX for Dummies Questions & Answers
Hello,
I need to test telnet connections using port number for few hosts.
Could you please help me?
Thanks !! (1 Reply)
Discussion started by: skhichi
1 Replies
9. Shell Programming and Scripting
Hi I have a question regarding Oracle connection using the below code
${ORACLE_HOME}/bin/sqlplus -s $user/$pwd@$sid <<!EOF 1>> $v_log_dir/$v_job_log.out 2>> $v_log_dir/$v_job_log.err
/
prompt stored procedure beginning . . .
exec xx_interface_pkg.pr_xx_clms_out($datayears,$keepmonths);
... (3 Replies)
Discussion started by: smilingraja
3 Replies
10. UNIX for Dummies Questions & Answers
I have a question regarding how to connect to Oracle Database through shell script.
1. If I want call a stored procedure on Linux server as this, it works.
$sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jun 12 14:49:49 2015
Copyright (c) 1982, 2014, Oracle. All rights... (2 Replies)
Discussion started by: duke0001
2 Replies
LEARN ABOUT DEBIAN
test::database::handle
Test::Database::Handle(3pm) User Contributed Perl Documentation Test::Database::Handle(3pm)
NAME
Test::Database::Handle - A class for Test::Database handles
SYNOPSIS
use Test::Database;
my $handle = Test::Database->handle(@requests);
my $dbh = $handle->dbh();
DESCRIPTION
"Test::Database::Handle" is a very simple class for encapsulating the information about a test database handle.
"Test::Database::Handle" objects are used within a test script to obtain the necessary information about a test database handle. Handles
are obtained through the "Test::Database->handles()" or "Test::Database->handle()" methods.
METHODS
"Test::Database::Handle" provides the following methods:
new( %args )
Return a new "Test::Database::Handle" with the given parameters ("dsn", "username", "password").
The only mandatory argument is "dsn".
The following accessors are available.
dsn()
Return the Data Source Name.
username()
Return the connection username.
password()
Return the connection password.
connection_info()
Return the connection information triplet ("dsn", "username", "password").
dbh( [ $attr ] )
Return the DBI database handle obtained when connecting with the connection triplet returned by "connection_info()".
The optional parameter $attr is a reference to a hash of connection attributes, passed directly to DBI's "connect()" method.
name()
Return the database name attached to the handle.
dbd()
Return the DBI driver name, as computed from the "dsn".
driver()
Return the "Test::Database::Driver" object attached to the handle.
AUTHOR
Philippe Bruhat (BooK), "<book@cpan.org>"
COPYRIGHT
Copyright 2008-2010 Philippe Bruhat (BooK), all rights reserved.
LICENSE
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2010-11-27 Test::Database::Handle(3pm)