SQL Developer 3 - Connecting to SQL Server Using Third Party Drivers

Here's a Quick How To Connect SQL Devleoper 3 to SQL Server or MySQL

Note that you can use "Check For Updates" to locate the available drivers.
  1. Click Help->Check For Updates
  2. Then check the boxes to enable Oracle Extensions and Third Party SQL Devleoper Extensions
  3. In the list scroll down to JTDS JDBC Driver 11.1.58.17
  4. or directly download the JTDS JDBC Driver
  5. Restart SQL Developer 
  6. And then Click Tools->Preferences->Database->Third Party Drivers
  7. Add the JTDS driver.
  8. Now if you get a message that says java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. You are missing a DLL.
  9. Go to SourceForge and download jtds-version-dist.zip and find the missing DLL called ntlmauth.dll
  10. Put that anywhere in your path and restart SQL Developer.

留言

張貼留言

這個網誌中的熱門文章

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
閱讀完整內容