ms-sqlserver-jdbc-tester

KO | EN

gitlite — search

#hacktoberfest #react #ai #llm #golang #go #machine-learning #macos #java #windows #kubernetes #awesome-list #mcp #open-source

ms-sqlserver-jdbc-tester

(★ 11)

Command line Java app to test JDBC connection to Microsoft SQL Server Database using 9.2.0 SQL Server JDBC driver.

ms-sqlserver-jdbc-tester 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# ms-sqlserver-jdbc-tester

A simple Spring Boot command line application to test JDBC connection to SQL Server database.

[![Maven Build Status](https://github.com/aimtiaz11/ms-sqlserver-jdbc-tester/actions/workflows/maven.yml/badge.svg)](https://github.com/aimtiaz11/ms-sqlserver-jdbc-tester/actions/workflows/maven.yml)

## How to run

Download the JAR from [release](https://github.com/aimtiaz11/ms-sqlserver-jdbc-tester/releases/tag/1.0) page or alternatively checkout the code from this repository and run:

```
mvn clean package
```

Execute the JAR file. Example below:

```
java -jar target/ms-sqlserver-jdbc-1.0.jar "jdbc:sqlserver://mydatabase.db.windows.net:1433;database=My_Example_DB;user=user@example.com;password=secret123;encrypt=true;trustServerCertificate=true;loginTimeout=90;authentication=ActiveDirectoryPassword"
```

> *Security Tip*: A good practise is to read the JDBC string into a variable using the `read` command in Linux to prevent DB credentials in JDBC string to be logged in bash history.

## How it works

To test the JDBC connection, the app will attempt to connect to SQL Server and execute a single SQL query: `SELECT SUSER_SNAME()` and close connection.

## License
(The MIT License)

THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

ms-sqlserver-jdbc-tester

ms-sqlserver-jdbc-tester 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

ms-sqlserver-jdbc-tester

ms-sqlserver-jdbc-tester 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README