--import data to DB from file (Sybase)
$SYBASE/bin/bcp tempdb..tmpTbl in $DIR/data.txt -b 1000  -c -S GFISVCS_NY_PROD -U munisa -P$PASSWD -I $INTERFACE

--export data to file from DB (Sybase)
$SYBASE/bin/bcp tempdb..tmpTbl out $RPT_DIR/data.txt -b 1000 -c -t'|' -S$PROD_SERVER -U$USER -P$PASSWD -I$INTERFACE

-- WebLogic 8.1 VS Hiberante3
Need parameter for <property name="hibernateProperties">
<prop key="hibernate.query.factory_class">
 org.hibernate.hql.classic.ClassicQueryTranslatorFactory
</prop>
or there wil be exception: ClassNotFoundException: org.hibernate.hql.ast.HqlToken

--Sybase
view sp: sp_helptext sp_name
view table property: sp_help tbl_name
execute sp: execute sp_name [parameters list]

发表于 @ 2007年06月28日　20:27:00 | 评论( loading... ) | 编辑| 举报| 收藏

旧一篇:Spring配置文件中SessionFactory引用Hibernate配置产生问题的思考 | 新一篇:线程安全及其他