SQL Server provides a method of retrieving data from more than one table using joins. A join can be defined as an operation that includes the retrieval of data from more than one table at a time.
A join is implemented using the SELECT statement, in which the SELECT list contains the name of the columns [...]
If we change SQL Server machine’s computer name, the new name doesn’t take to effect immediately to SQL server. This article will solve this problem.
Cause :
The database is in Restricted Mode, Usually database will be put in restricted mode while taking backup. While in restricted mode users with Restricted access will have access to database. Normal users will be able to access database.
Identification :
You can identify the current login mode of the database using the query
SQL> select logins from [...]
The following table compares the maximum sizes and numbers of various objects defined in SQL Server 7.0, SQL Server 2000 and SQL Server 2005 databases or referenced in Transact-SQL statements. The table does not include Microsoft SQL Server 2000 Windows CE Edition and Microsoft SQL Server 2005 Windows CE Edition. The table has the technical [...]
Tags: SQL Server, sql server 2000, SQL Server 2005, SQL Server 7.0, SQL Server Comparison
Introduction
This is a java class file for sending mails using java APIs. It requires two jar files to be set in the class path. Also Java J2SDK is required to compile or run this code. A valid SMTP server ip is required and that should be authenticated by a valid user id and password.
Limitations [...]
Problem Description: Server not coming up after restart. (You will find error in log like: “Could not acquire lock on ldap … already in use …”)
Possible causes: Server did not shutdown properly though in console you will see the status as SHUTDOWN / UNKNOWN
Solution:
Logon to UNIX box.
Switch user to the user owning the domain
Run “/usr/ucb/ps [...]
Tags: boot identity is not valid, Could not acquire lock on ldap already in use, java Weblogic Server, Weblog not starting in Unix, Weblogic Not Starting in Windows, Weblogic Server Administration
Problem Description: Execute Thread Count Full
Solution/Workaround:
Open WebLogic Admin Console
Go to the server for which the Default Execute Thread filled up
Go to “Monitor all Execute Queue”
Check for “Idle threads” count
If it is showing “Zero”, and application is running slow and the IdleThread count is “Zero” forlong (say 5 min)
Only option is to restart the server instance. [...]
This Article is intended for Weblogic Administrators as a quick reference to known issues and their solution or workarounds. This will help in fast and effective resolution of problems
Problem Description: Heap Space Utilization too high (>=95% say) Solution/Workaround:
Log on to WebLogic Admin Console
Go to the server instance for which the heap space [...]
Introduction
Commons-Email provides an API for sending email. It is built on top of the Java Mail API, which it aims to simplify. Some of the mail classes that are provided are as follows:
SimpleEmail – This class is used to send basic text based emails.
MultiPartEmail – This class is used to send multipart messages. [...]
Tags: Java API, Java Commons API, Java Email API, Java Opensource Email API
Introduction
Voice based solutions are needed when there is a legal requirement to play back an already recorded statement, recording and playing back the telephony conversations, speech recognition systems, visually impaired people, for training customer support representations and so on. Voice based solutions can be implemented using J2SE Java Sound API or Java Media Framework (JMF). [...]
Tags: Java API, Java Sound, Voice Based Solution
