UKoom

Wow, how long the title is! :) I came across one strange issue today (actually I found this last Friday, but you know weekend coming, hehehe). When using the update DQL to fill up one new column in the registered table, there are always lots of blanks appended. The root cause after doing ...

Error message - "Only TrueType fonts are supported. This is not a TrueType font." was thrown when using SQL Server Profiler. Solution： 1. Open SQL Server Profilr 2. Go to ' Tool'Menu 3. Select Options 4. Change the font name to "Arial" 5. Click OK.

set LONG 10000 select TEXT from ALL_VIEWS where view_name = 'MY_VIEW'; Line one must be at least the size of the statement used to create the view. Either pick a really ...

The error "Non SQLError Could not load class Driver_name" was thrown when using PowerDesigner to generate the hibernate mapping files. This error occurs if you enter an incorrect Driver and URL in the Database Profile.

Get the Physical Data Model 1. Menu Operation File, Reverse Engineer , Database, New Phycial Data Model 2. Connection Add a connect to the target database 3. Choose tables to generate the models Generate the Java Code 1. Menu Operation Tools , Generate Object-Oriented Model, Detail, O/R Mapping, Enable Transformations, Extended Model Definitions, O/R Mapping,      Hibernate To be continued.

how to correctly import a MySQL dumpfile through a command line. mysql -p -h DBSERVER dbname < dbname.sql

DateDiff 用法 DateDiff: SQL server函数 返回 Variant (Long) 的值，表示两个指定日期间的时间间隔数目。 语法 DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) DateDiff 函数语法中有下列命名参数： 部分 描述 interval 必要。字符串表达式，表示用来计算date1 和 date2 的时间差的时间间隔 Date1□date2 必要；Variant (Date)。计算中要用到的两个日期。 Firstdayofweek 可选。指定一个星期的第一天的常数。如果未予指定，则以星期日为第一天。 firstweekofyear 可选。指定一年的第一周的常数。如果未予指定，则以包含 1 月 1 日的星期为第一周。 设置 interval 参数的设定值如下： 设置 描述 yyyy 年 q 季 m 月 y 一年的日数 d 日 w 一周的日数 ww 周 hh 时 n 分钟 s 秒 firstdayofweek 参数的设定值如下： 常数 值 描述 vbUseSystem 0 使用 NLS API 设置。 vbSunday 1 星期日（缺省值） vbMonday 2 星期一 vbTuesday 3 ...

SQL Server JDBC Connection Errors: Error establishing socket, connection refused... java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) ...

Modifying the dmcl.ini File on the Oracle WebCenter Content Service for Documentum Host On all computers that host the Oracle WebCenter Content Service for Documentum, you can increase the max_session_count variable in the dmcl.ini file to allow for additional concurrent sessions. By default, the ...

Here are some scripts related to Session Statistics . Session I/O By User SESSION I/O BY USER NOTES: Username - Name of the Oracle process user OS User - Name of the operating system user PID - Process ID of the session SID - Session ID of the session Serial# - Serial# of the session Physical Reads - ...