Skip to main content

Posts

Showing posts from October, 2019

SQL Server connection refused error

If you face sql server connection refused while connecting sqlserver to eclipse resolution steps are:- 1. Go to server configuration manager. 2. Enable TCP/IP protocol and in IP address go to IP/ALL and set dynamic value to blank and TCP/IP port to 1433 (default)

Getting started with Apache Derby

Derby is free opensource database Install derby and start using bat file startnetwork.bat. C:\Users\AnilBalwani\Downloads\db-derby-10.12.1.1-bin\db-derby-10.12.1.1-bin\lib>java -jar derbyrun.jar ij ij version 10.12 ij> connect 'jdbc:derby:booksdb;create=true'; ij> CREATE TABLE book (book_id int primary key, title varchar(64)); 0 rows inserted/updated/deleted ij> INSERT INTO book VALUES (1, 'New Test'), (2, 'Testing'), (3, 'Correct'); 3 rows inserted/updated/deleted ij> select * from book; 3 rows will get selected