Remove SQL Server database from single-user mode

Turn off the single-user mode of the database by the following statement:

ALTER DATABASE [db_name] SET MULTI_USER WITH NO_WAIT

OR

exec sp_dboption 'db_user', 'single user', 'FALSE'
 
If the process is deadlocked, please kill the processed by:
 
select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame
from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid where d.name = 'jasper_db_sit'
go

kill spid


留言

張貼留言

這個網誌中的熱門文章

Disable ionic's sidemenu content drag to toggle menu

Disable ionic's sidemenu content drag to toggle menu  Associate the state with a controller: $stateProvider . state ( 'app' , { url : "/app" , abstract : true , templateUrl : "pages/menu.html" , controller : 'MenuController' }) Run the config when the view is completelly loaded: . controller ( 'MenuController' , function ($scope, $ionicSideMenuDelegate){ $scope. $on ( '$ionicView.loaded' , function (){ $ionicSideMenuDelegate.canDragContent( false ); }); })
閱讀完整內容

Multiple writable mappings exist for the field. Only one may be defined as writable, all others must be specified read-only.

In entity bean, the foreign key usually replaced by the referential relationship such as : public class Status implements Serializable {     /**      *      */     private static final long serialVersionUID = 1L;     @Column(name="creation_datetime", nullable = false)     private Timestamp creationDatetime;     @Id     @Column(name="seq_no", nullable = false)     @GeneratedValue(strategy=GenerationType.IDENTITY)     private Integer seqNo;     @Column(name="status", nullable = false)     private String status;     @Column(name="car_id", nullable = false, insertable=false, updatable=false)     private String carId;     @ManyToOne     @JoinColumn(name = "car_id")     private Transaction transaction;     public Status() {     }     public Status(Timestamp creation_datetime,                           Transaction transaction,                           Integer seqNo, String status, String carId) {         this.creationDatetime = creati
閱讀完整內容

java.lang.NoClassDefFoundError: org/apache/xerces/jaxp/datatype/XMLGregorianCalendarImpl$Parser

When you encounter the following error that related to web service. java.lang.NoClassDefFoundError: org/apache/xerces/jaxp/datatype/XMLGregorianCalendarImpl$Parser Solution 1: Ensure no xercesImpl.jar in your classpath since the implementation of xerce is built-in wiht JAVA SE 1.6. Solution 2: Use XmlJavaTypeAdapter [ @XmlJavaTypeAdapter(JaxbDateAdapter.class)] to convert XMLGregorianCalendar type to Date type. XMLGregorianCalendar is the built-in Java data type for JAXB mapping with datetime. Example: Binding.xjb <?xml version="1.0" encoding="UTF-8"?> <bindings xmlns="http://java.sun.com/xml/ns/jaxb"                 xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance"                 xmlns:xjc="http://java.sun.com/xml/ns/jaxb/xjc"                 xmlns:xsd="http://www.w3.org/2001/XMLSchema"                 xsi:schemaLocation=" http://java.sun.com/xml/ns/jaxb http://java.sun.com/xml/ns/jaxb/binding
閱讀完整內容