Download JDBC Driver Microsoft SQL Server includes a popular command-line utility named bcp for quickly bulk copying large files into tables or views in SQL Server databases. The SQLServer Bulk Copy class allows you to write code solutions in Java that provide similar functionality. There are other ways to load data into a SQL Server table ( INSERT statements, for example) but SQLServer Bulk Copy offers a significant performance advantage over them. The SQLServer Bulk Copy class can be used to write data only to SQL Server tables. But the data source is not limited to SQL Server; any data source can be used, as long as the data can be read with a Result Set, Row Set, or ISQLServer Bulk Record implementation. Using the SQLServer Bulk Copy class, you can perform: A single bulk copy operation Multiple bulk copy operations A bulk copy operation with a transaction Note When using the Microsoft JDBC Driver 4.1 for SQL Server or earlier (which does not support the SQLServer Bulk Copy class you can execute the SQL Server Transact- SQL BULK INSERT statement instead. The SQLServer Bulk Copy class can be used to write data only to SQL Server tables. The code samples shown in this topic use the SQL Server sample database, Adventure Works. To avoid altering the existing tables code samples write data to tables that you must create first. The Bulk Copy Demo Matching Columns and Bulk Copy Demo Different Columns tables are both based on the Adventure Works Production. Products table. In code samples that use these tables, data is added from the Production. Products table to one of these sample tables. The Bulk Copy Demo Different Columns table is used when the sample illustrates how to map columns from the source data to the destination table; Bulk Copy Demo Matching Columns is used for most other samples. A few of the code samples demonstrate how to use one SQLServer Bulk Copy class to write to multiple tables. For these.
The following sections describe how to configure and use the Type 4 JDBC SQL Server driver: The Type 4 JDBC MS SQL Server driver (the “ SQL Server driver”) supports the following database management system versions: Microsoft SQL Server 2005 Microsoft SQL Server 2000 Microsoft SQL Server 2000 Desktop Engine ( MSDE 2000) Microsoft SQL Server 2000 Enterprise Edition (64-bit) Microsoft SQL Server 7.0 To use JDBC distributed transactions through JTA, you must install stored procedures for Microsoft SQL Server. See Installing Stored Procedures for JTA for details. The driver class for the Type 4 JDBC MS SQL Server driver is weblogic.jdbc.sqlserver. SQLServer Driver. This is a non- XA driver. To connect to a Microsoft SQL Server database, use the following URL format: jdbc:bea:[;.] where: hostname is the TCP/ IP address or TCP/ IP host name of the server to which you are connecting. See Using IP Addresses for details on using IP addresses. Note: Untrusted applets cannot open a socket to a machine other than the originating host. port is the number of the TCP/ IP port. property=value specifies connection properties. For a list of connection properties and their valid values, see SQL Server Connection Properties. For example: jdbc:bea: See Connecting to Named Instances for instructions on connecting to named instances. Microsoft SQL Server and Microsoft SQL Server 2005 support multiple instances of a SQL Server database running concurrently on the same server. An instance is identified by an instance name. To connect to a named instance using a connection URL, use the following URL format: jdbc:bea: Note: The first back slash character (\) in \instance_name is an escape character. where: server_name is the IP address or hostname of the server.
Download Now