error connecting to server localhost on port 1527 with message connection timed out

Question

enter image description here I was trying to create a database in Netbeans, I have followed all the steps by starting the server and writing the username and passwords, but when it comes to creating the database, this message occurs:

error

What's the issue here?

here's the path: java DB instalation:

C:\Program Files\Java\jdk1.7.0_45\db database location: C:\Users\Admin.netbeans-derby

what db server are you using? If it is sql server are you trying to connect to the default instance or a named instance? — Gavin, Apr 27 '14 at 12:35
@Alladinsaoudi : show us how you want to create the database. Also you can look here and create it via service . [embedded-database](http://stackoverflow.com/questions/16759252/querying-embedded-database-in-netbeans-using-derby/16764522#16764522) — moskito-x, Apr 27 '14 at 15:51
@moskito I created it using the simple steps shown in this article.. everything is clear there. — Alladin, Apr 27 '14 at 16:49
@moskito-x checkout the steps i showed in the image posted in the question :)) — Alladin, Apr 27 '14 at 17:23
actually i get this: Mon Apr 28 02:22:01 SGT 2014 : Security manager installed using the Basic server security policy. Mon Apr 28 02:22:01 SGT 2014 : Apache Derby Network Server - 10.8.3.0 - (1405108) started and ready to accept connections on port 1527 — Alladin, Apr 27 '14 at 18:25
@moskito-x this notification pops up: Cannot establish a connection to jdbc:derby://localhost:1527/sample using org.apache.derby.jdbc.ClientDriver (java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection timed out: connect.) — Alladin, Apr 27 '14 at 18:51
@Alladinsaoudi : In your posted Picture you tell us it is in `C:\Users\Admin\.netbeans-derby` Are you Admin ? — moskito-x, Apr 27 '14 at 19:52
@Alladinsaoudi : And now what folder are in `C:\Users\Admin\.netbeans-derby` ??? — moskito-x, Apr 27 '14 at 20:01
@Alladinsaoudi : Have you read + write rights in that folder ? test it , create an `xyz` folder. — moskito-x, Apr 27 '14 at 20:07
@Alladinsaoudi : and now in my answer look at `Java DB Properties` The two properties `Java DB Installation` and `Database Location` pointing to the right folder ? — moskito-x, Apr 27 '14 at 20:19
@moskito-x no they don't.. should i put both of them in the same path? — Alladin, Apr 27 '14 at 20:27
@Alladinsaoudi : No, you should browse to the correct folders. One for the DB Installation folder. and the other to the Database folder. — moskito-x, Apr 27 '14 at 20:30
@moskito-x u mean i should just leave them like that?? and how i can solve my problem?? it's really an urgent matter — Alladin, Apr 27 '14 at 20:40
@Alladinsaoudi : you don't understand. Please put into your question the values of the 2 fields. — moskito-x, Apr 27 '14 at 20:48
@moskito-x ok you can check my question now.. i have put the paths of both of them — Alladin, Apr 27 '14 at 20:53
@Alladinsaoudi : look at your database location : really this : `C:\Users\Admin.netbeans-derby` or a typo ? — moskito-x, Apr 27 '14 at 20:55
@Alladinsaoudi : So it's wrong must be `C:\Users\Admin\.netbeans-derby` !!! — moskito-x, Apr 27 '14 at 20:59
@moskito-x !!! it's the one you wrote just now in your comment C:\Users\Admin\.netbeans-derby — Alladin, Apr 27 '14 at 21:02
@moskito-x ohhhhh yeah u'r right i'm really sorry..the path in the question is wrong — Alladin, Apr 27 '14 at 21:08

moskito-x · Answer 1 · 2014-04-27T19:17:41.457

1

Can you right click on sample Database -> Properties

looks like this ?

enter image description here

and after stop and start the server you get : look for port 1527

enter image description here

can you test the following

enter image description here

and new connection wizzard

enter image description here

Browse to your Database folder and look if there exists sample

enter image description here

edited Apr 27 '14 at 19:17

answered Apr 27 '14 at 17:57

moskito-x

11,832
5
47
60

score 1 · Answer 2 · answered Jun 29 '15 at 13:58

1

After double clicking on sample DB, having successfully connected to the sample DB, I have got the app deployed successfully. I think it is some bug or a 'feature'. I think it may help somebody.

answered Jun 29 '15 at 13:58

ddsultan

2,027
1
19
19

error connecting to server localhost on port 1527 with message connection timed out

2 Answers2