脚印

1, 安装jdk# mkdir /usr/lib/jvm# tar zxvf jdk-8u5-linux-i586.gz -C /usr/lib/jvm/ 一般是解压到/usr/lib下，可以在该目录下创建jvm，然后解压到既定目录，该目录下已经有一个ubuntu自带的jdk-6-openjdk了，而jdk1.8.0_05就是命令解压来的2ls配置jdk使其生效# nano /etc/profile在文件最末尾添加如下所示内容，c...

CREATE USERPurposeUse the CREATE USER statement to create and configure a database user, which is an account through which you can log in to the database, and to establish the means by which

17 Introduction to the Multitenant ArchitectureThis chapter contains information specific to the Oracle Multitenant option, and contains the following topics:About the Multitenant Architec

创建数据库连接·       Open oracle sql developer·        CTRL+N -> Database Connection  -> filling info as below pic·        Note: Make sure SID is right, click test beforeclick connect.·        C

You need an XADataSource if you want to execute a Distributed Transaction. You should use XADataSource instead of DataSource if the application 1. Uses the Java Transaction API (JTA) 2. Includes

JPQL就是一种查询语言，具有与 SQL 相类似的特征， JPQL 是完全面向对象的，具备继承、多态和关联等特性，和hibernate HQL很相似。查询语句的参数JPQL 语句支持两种方式的参数定义方式 : 命名参数和位置参数 。 。在同一个查询语句中只允许使用一种参数定义方式。命令参数的格式为：“ : + 参数名”例：Query query = em.creat

Solution: Run regedit as the AdministratorExpand HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App PathsAdd a new Key to App Paths called sqldeveloper.exeSet the (Default) value t

JPQL主要用于JPA查询数据，和SQL语句的语法大同小异；最基本的查询：SELECT pFROM Player p查询出所有的player,包括其子类，也可以写成这样From Player as p去除重复的元素SELECT DISTINCT pFROM Player pWHERE p.position = ?1关键字DISTINCT去除了重复的元素，

Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. Character set conversion may cause unexpected results. Note: you can set the client character set through the N

If the sequence does not work in ejb, then try to change the id data type to Long firstly, then add the following code upon the id field. @Id @SequenceGenerator(name="COMMANDITEM_COMMANDID_GENERATO

Android ORM DB使用心得前言ORM ( Object Relational Mapping )，透過直接操作物件的方式就能夠對DB執行新增、修改、刪除、搜尋的功能，大大簡化RD在開發過程中繁瑣的工作。使用心得目前使用過下列幾種Github上熱門的專案– greenDAO 過程太過繁瑣我就不介紹了– sugar Github上雖然一直有更新

Java Type Java DB, Derby, CloudScape Oracle DB2 Sybase MS-SQL Server MySQL Server boolean,java.lang.BooleanSMALLINTNUMBER(1)SMALLINT

The ORDER clause is a performance killer for sequences in Oracle RAC. This clause will guarantee that the NEXTVAL is in order from the previous value no matter which instance is asking for the next

http://stackoverflow.com/questions/11296361/how-to-create-id-with-auto-increment-on-oracle    第一, 如果不是primary key id duplicated，那么只能说这个记录确实已经存在了；第二，如果是主键冲突，那么情况就多了：主键是String类型的， 这个必然

问题1： swap大小通不过Createa swap file commandType thefollowing command to create a 2GB swap file on Ubuntu:# dd if=/dev/zero of=/swapfile bs=1G count=2Sample outputs:2+0 records in2+0 records

12c: ORA-65049: creation of local user or role is not allowed in CDB$ROOT此问题已回答。kc-runner 2013-6-26 下午12:32Last night I installed Oracle 12C on OEL 6.4. See Installing Oracle Spa

COMMON USER VS. LOCAL USER – 12C EDITIONJune 29, 2013 · by curtisbl · in DatabaseWithin Oracle Database 12c, there is new terminology being used for user accounts.  Oracle has come up wi

Hibernate or JPA or JDBC or?4down vote favorite 1share [g+]share [fb] share [tw] I am developing a Java Desktop Application but have some confusions in choosing a tec

摘自----《Oracle备份与恢复》 -----------------------------------------------------------------------------------------------------------------一个名叫Sid的男人，狂热地爱好拍摄、保存和整理照片。Sid的妻子名叫Debbie，他们有三个儿子Logan、Archie

该文转自guty O-R Mapping J2EE的标准是CMP Entity Bean，而实际应用中受到诟病最多的也是它。我们化了整整半年时间研究CMP2.0的开发方法，目前总算能够将代码量减少到70%，并且有希望减少到 90%。我曾经很满足现有的成绩，但是当我真正地阅读了hibernate后，对CMP2.0的信心彻底动摇了。hibernate至少比CMP2.0有以下

PerformancePerformance and scalability are like the good life. Everyone wants a lot of it, but what are you willing to give to get it? Therefore, when looking at performance figures for each of the

From Wikipedia, the free encyclopediaJump to: navigation,searchProgramming language comparisonsGeneral comparisonBasic syntaxBasic instructionsArraysAssociative arraysString oper

为了建立冗余较小、结构合理的数据库，设计数据库时必须遵循一定的规则。在关系型数据库中这种规则就称为范式。范式是符合某一种设计要求的总结。要想设计一个结构合理的关系型数据库，必须满足一定的范式。AD：为了建立冗余较小、结构合理的数据库，设计数据库时必须遵循一定的规则。在关系型数据库中这种规则就称为范式。范式是符合某一种设计要求的总结。要想设计一个结构合理的关系型数据库，必须满足一定的范式

Suppose you have a database and you want each entry to be identifiedby a unique number. You can do this easily in mysql by specifying"auto_increment" for your number, but Oracle makes you work a littl

1. Start the installer ‘Setup.exe’. Wait till ask about the path;2. Do not press next. Open with Windows Explorer the folder like this:C:\Users\\AppData\Local\Temp{60712028-B7B0-4EC3-9C28-663111EC

1) Download the SQLite drivers from: [1].The actual zip file with the driver is at [2]. Expand the zip somewhere locally and note the location.下载链接 [2].中的zig包，解压到本地硬盘。2) Put the sqlite

大部分是因为字符集不兼容造成的，解决办法就是修改mysql client和server的字符集， 修改字符集的办法之一是修改C:\Program Files (x86)\MySQL\MySQL Server 6.0\my.ini中client和server的字符集都设成gb2312    即 default-character-set=gb2312。 然后重启mysql service和cli

Error:ORA-01033 ORACLE initialization or shutdown inprogressORA-00313:无法打开日志组1(线程 1)的成员_ORA-00312 我的oracle10g启动的时候，登录sql/plus scott/tiger 报如下错误Error: ORA-01033ORACLE initialization or shutdown

H:\IT-TOOLS\EnterpriseDevTools>java_ee_sdk-7-windows-ml.exe -j "C:\Program Files\Java\jre7"H:\IT-TOOLS\EnterpriseDevTools>java -jar wls1211_generic.jarExtracting 0%...............

导出数据库：进入cmd窗：c:\>exp system/passwd@xe file=c:\milkrun0917.dmp owner=someuser导入时：进入cmd窗：imp system/siemens@xe file=c:\milkrun1022.dmp full=y然后到SQL Developer 下执行如下脚本d

JAP1.0移植到JAP2.0时 其中涉及到Date,TimeStamp的需要在相关field上面添加@Temporal(TemporalType.DATE)@Temporal(TemporalType.DATE) @Column(name = "TO_LSP_DATE", length = 7) public Date getToLspDate() { return this.

上篇文章讲到了Java  Persistence API（Java 数据持久化API），hibernate作为JPA的一种实现，是一个数据持久化组件。所谓对象持久化(Object Persistence)，就是把数据保存在永久存储介质中（数据库）。1.为什么要持久化:a.内存是暂时存储设备,断电后数据易丢失b.网络传输无法传输内存中的对象，需要将对象外化c.内存中数据查询,组织不方