2009年1月6日 星期二

2007年5月16日 星期三

How to check Oracle's character set

you can use this sql statement to get related information
select * from NLS_DATABASE_PARAMETERS;

you can find out the character set information from this column: NLS_CHARACTERSET

2007年3月18日 星期日

Ten Common Database Design Mistakes

the list:
  1. Poor design/planning
  2. Ignoring normalization
  3. Poor naming standards
  4. Lack of documentation
  5. One table to hold all domain values
  6. Using identity/guid columns as your only key
  7. Not using SQL facilities to protect data integrity
  8. Not using stored procedures to access data
  9. Trying to build generic objects
  1. Lack of testing
http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

Spring + Hibernate Cache Implementation

If you do not configure the xml file, then you will get some warning message just like this:
Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.

If you are interested this topic, you can check this link:
http://community.csdn.net/Expert/TopicView3.asp?id=4685637

ORA-12519, TNS:no appropriate service handler found

Scenario

My application will throw the ORA-12519, TNS:no appropriate service handler found error message, as the application is working for awhile. The complete exception message is as belows:

javax.servlet.ServletException: Hibernate operation: Cannot open connection; uncategorizedSQLException for SQL [???]; SQL state [null]; error code [0]; Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
localhost:1521:XE
; nested exception is java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
localhost:1521:XE

Solution

Go to modify the init.ora this script file. Modify job_queue_processes this value.
###########################################
# Job Queues
###########################################
job_queue_processes=200

As you finish it, you HAVE to restart the oracle service.
You can use this sql statement to check if your configuration is in effect or not.
select value from v$parameter where name = 'processes';

2007年3月8日 星期四

Oracle JDBC FAQ

This document contains answers to the most frequently asked questions about Oracle's JDBC drivers. Note that these address specific technical questions only and are used to document solutions to frequent customer questions as well as any known problems. The server docs (including JDBC doc) are also available online.

Note that this FAQ contains information about all released versions of the Oracle JDBC drivers. Anything that is not described as pertaining only to certain versions should pertain to all the versions. Or to the current version. At the time the question was asked.


http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm