![]() If it's a remote database, be attention to personal firewall settings, and I recommended to test connection. The target database may be hosted on both local or remote. If using SQL Authentication, this step is so easy. Set connection properties Set connection properties required the target database. (figure 4, figure 5 and figure 6) figure 4 - Specify a Driver (incomplete) igure 5 - Select suitable JDBC driver figure 6 - Specify a Driver (complete) Step 4. Thus I needed to replace it to suitable JDBC drivers, e.g. Choose suitable JDBC driver In the default, it uses 'sqljdbc.jar' that is legacy JDBC driver. Figure 3 - Specify a Driver Template Step 3. So I chose 'Microsoft SQL Server 2008' instead of them. Tell the truth, 'Microsoft SQL Server 2012 JDBC Driver' and 'Microsoft SQL Server 2014 JDBC Driver' are not worked however their are listed. There is not for SQL Server 2016 so need to choose alternate one. (figure 2) igure 2 - New Driver Definition - Create New It's required both a driver type (template) and a driver name (definition name). Specify a Driver definition Create a driver definition based on one of prepared templates. (see figure 1) igure 1 - Choose Connection Profile Type Step 2. In this case, I set it 'SQL Server 2016' because of connection to SQL Server 2016. It's required to set 'Name' as the description. Create a new Connection Profile for SQL Server 2016 Create a new connection then choose 'SQL Server' from the list of Connection Profile Types. Microsoft JDBC Driver 4.0 or later (the latest version is 6.0), installed the same host with Eclipse 2. ![]() ![]() Java’s JDBC technology lets you access information in SQL databases. Java database FAQ: How do I connect to a SQL database with Java and JDBC? If you’re interested in connecting your Java applications to standard SQL databases like Oracle, MySQL, SQL Server, and others, JDBC is what you need.
0 Comments
Leave a Reply. |