03-10-2018
Yes, in general you must shutdown the application service (tomcat) first, so it can flush data to the DB.
Then shutdown or restart the DB server.
10 More Discussions You Might Find Interesting
1. Solaris
Hi
I have changed my timezone using the command
export TZ='Asia/Calcutta"
but teh affect is taking place only in teh shell where I am logged in. If I export teh variable when I open the new session, things are fine.
Can I affetct the change universally, without restarting the server.
... (2 Replies)
Discussion started by: krishan
2 Replies
2. Solaris
As the title. Thanks (1 Reply)
Discussion started by: eddsos
1 Replies
3. Solaris
Dear guys,
Pls help me this case. I telnet normally to Solaris. After restarting it manually, I can only console, cannot telnet from my latop although I can ping it. I checked
/etc/default/login
/usr/sbin/in.telnetd
/etc/inet/inetd.conf
All these files are the same.
I don't see telnet... (2 Replies)
Discussion started by: wipi
2 Replies
4. Solaris
Hi,
I am working with a company where some times i need to start/stop cron jobs on need basis.
I have one option to kill cron daemon.Is it right?
Please correct me.
Waiting for your reply.
Thanks in advance.. (2 Replies)
Discussion started by: varaprasadu
2 Replies
5. Solaris
Hello people,
My solaris server is rebooting, not sure how!!! Which log should I look in to? I checked /var/adm/messages and dmesg also. How do I check older dmesg logs? I checked lastlog and also ran the last command. Nothing useful pointing to why server rebooted.
Also when server reboots I... (4 Replies)
Discussion started by: rcmrulzz
4 Replies
6. Solaris
Hello All
I just want to know how to Shut Down the Solaris Machines( Servers ) for Maintainance and then Start Up the Machines ( Servers ) .
I think I will have to Log In as root to do that .
Also how do i Check if all the services running on that server before shut down are running... (6 Replies)
Discussion started by: supercops
6 Replies
7. UNIX for Dummies Questions & Answers
I'm trying to power on our SUN m4000 server after a recent shutdown. When I try to connect to the xscf console I'm getting prompted for a password. The system is not asking for a login just a password. Below is the output from the xscf console.
Anyone know how I can safely get back to the... (0 Replies)
Discussion started by: orahi001
0 Replies
8. UNIX for Advanced & Expert Users
Hi
I want a program of employee database locking with mendatory & record locking using client server architecture .there are two type of clients one which has all permissions of read/write called supervisor & another can only read the file.employee data base should contain
1) name
2)ID
3)BU... (1 Reply)
Discussion started by: rluha
1 Replies
9. Solaris
If I want to restart sysedge on a solaris box and it does not want to come up. It gets stucked. How can I check where the sysedge pid file so I can delete it and try to start sysedge again?
What can cause sysedge to not come up?
Thanks, (0 Replies)
Discussion started by: Pouchie1
0 Replies
10. Shell Programming and Scripting
Hi,
I need to create a shell script for automated server patching, with the following scenario:
I have two Linux servers Primary and secondary.
Server patching should start on Primary 1st and then secondary.
1st check both servers are up and running.
Then stop primary and patching will... (1 Reply)
Discussion started by: rcroyal88
1 Replies
LEARN ABOUT PHP
pdo_sqlsrv-dsn
PDO_SQLSRV-DSN(3) 1 PDO_SQLSRV-DSN(3)
PDO_SQLSRV DSN - Connecting to MS SQL Server and SQL Azure databases
The PDO_SQLSRV Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is sqlsrv:.
o APP - The application name used in tracing.
o ConnectionPooling - Specifies whether the connection is assigned from a connection pool (1 or TRUE) or not (0 or FALSE).
o Database - The name of the database.
o Encrypt - Specifies whether the communication with SQL Server is encrypted (1 or TRUE) or unencrypted (0 or FALSE).
o Failover_Partner - Specifies the server and instance of the database's mirror (if enabled and configured) to use when the primary
server is unavailable.
o LoginTimeout - Specifies the number of seconds to wait before failing the connection attempt.
o MultipleActiveResultSets - Disables or explicitly enables support for multiple active Result sets (MARS).
o QuotedId - Specifies whether to use SQL-92 rules for quoted identifiers (1 or TRUE) or to use legacy Transact-SQL rules (0 or
false).
o Server - The name of the database server.
o TraceFile - Specifies the path for the file used for trace data.
o TraceOn - Specifies whether ODBC tracing is enabled (1 or TRUE) or disabled (0 or FALSE) for the connection being established.
o TransactionIsolation - Specifies the transaction isolation level. The accepted values for this option are PDO::SQL-
SRV_TXN_READ_UNCOMMITTED, PDO::SQLSRV_TXN_READ_COMMITTED, PDO::SQLSRV_TXN_REPEATABLE_READ, PDO::SQLSRV_TXN_SNAPSHOT, and PDO::SQL-
SRV_TXN_SERIALIZABLE.
o TrustServerCertificate - Specifies whether the client should trust (1 or TRUE) or reject (0 or FALSE) a self-signed server cer-
tificate.
o WSID - Specifies the name of the computer for tracing.
Example #1
PDO_SQLSRV DSN examples
The following example shows how to connecto to a specified MS SQL Server database:
$c = new PDO("sqlsrv:Server=localhost;Database=testdb", "UserName", "Password");
The following example shows how to connect to a MS SQL Server database on a specified port:
$c = new PDO("sqlsrv:Server=localhost,1521;Database=testdb", "UserName", "Password");
The following example shows how to connecto to a SQL Azure database with server ID 12345abcde. Note that when you connect to SQL
Azure with PDO, your username will be UserName@12345abcde (UserName@ServerId).
$c = new PDO("sqlsrv:Server=12345abcde.database.windows.net;Database=testdb", "UserName@12345abcde", "Password");
PHP Documentation Group PDO_SQLSRV-DSN(3)