message d'erreur "connection refused: connect"

**apoca** · 04/05/2007, 14h27

salut tt le monde ,
j'ai longtemps hesité avant de poster ce message vu les messages similaires postés precedemment
bon j'essaye de tester eclipse et hibernate pour les utiliser dans mon projet
j'ai suivi le tutorial "defaut.developpez.com/tutoriel/java/eclipse/hibernate" à la lettre
mais quand j'essaie de creer le fichier de mapping hibernate, precisement quand je clique sur refresh il me donne l'erreur suivante :
"Error establishing connection
connection refused: connect "

voila les info que j'ai rentré dans le fichier de configuration

jdbc:jtds:sqlserver://127.0.0.1:1433/mabase
net.sourceforge.jtds.jdbc.Driver
user
password

N.B: j'ai refait le meme exemple sur un autre PC et ca a marché

merci pour votre aide

**apoca** · 05/05/2007, 13h37

bonjour
j'ai quand meme crée le ficher de mapping manuellement (en fait je l'ai copié)
et lorsque j'ai executé ca ma donné :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
 
5 mai 2007 11:21:11 net.sf.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Transaction strategy: net.sf.hibernate.transaction.JDBCTransactionFactory
5 mai 2007 11:21:11 net.sf.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
5 mai 2007 11:21:12 net.sf.hibernate.cfg.SettingsFactory buildSettings
ATTENTION: Could not obtain connection metadata
java.sql.SQLException: Connection refused: connect
	at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:181)
	at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:160)
	at net.sourceforge.jtds.jdbc.TdsConnection.<init>(TdsConnection.java:182)
	at net.sourceforge.jtds.jdbc.TdsConnectionJDBC3.<init>(TdsConnectionJDBC3.java:53)
	at net.sourceforge.jtds.jdbc.Driver.getConnection(Driver.java:102)
	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:85)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)
	at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1155)
	at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:789)
	at com.minosis.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:15)
	at Test.ajout(Test.java:17)
	at Test.<init>(Test.java:11)
	at Test.main(Test.java:60)
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at net.sourceforge.jtds.jdbc.TdsSocket.<init>(TdsSocket.java:182)
	at net.sourceforge.jtds.jdbc.TdsConnection.<init>(TdsConnection.java:178)
	... 13 more
5 mai 2007 11:21:12 net.sf.hibernate.cfg.SettingsFactory buildSettings
INFO: Use scrollable result sets: false
5 mai 2007 11:21:12 net.sf.hibernate.cfg.SettingsFactory buildSettings
INFO: Use JDBC3 getGeneratedKeys(): false
5 mai 2007 11:21:12 net.sf.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: false
5 mai 2007 11:21:12 net.sf.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
5 mai 2007 11:21:12 net.sf.hibernate.cfg.SettingsFactory buildSettings
INFO: cache provider: net.sf.hibernate.cache.EhCacheProvider
5 mai 2007 11:21:12 net.sf.hibernate.cfg.Configuration configureCaches
INFO: instantiating and configuring caches
5 mai 2007 11:21:13 net.sf.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
5 mai 2007 11:21:13 net.sf.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
5 mai 2007 11:21:14 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
ATTENTION: SQL Error: 0, SQLState: 08004
5 mai 2007 11:21:14 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: Connection refused: connect
5 mai 2007 11:21:14 net.sf.hibernate.JDBCException <init>
GRAVE: Cannot open connection
java.sql.SQLException: Connection refused: connect
	at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:181)
	at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:160)
	at net.sourceforge.jtds.jdbc.TdsConnection.<init>(TdsConnection.java:182)
	at net.sourceforge.jtds.jdbc.TdsConnectionJDBC3.<init>(TdsConnectionJDBC3.java:53)
	at net.sourceforge.jtds.jdbc.Driver.getConnection(Driver.java:102)
	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:85)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286)
	at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
	at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
	at net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
	at net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
	at net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2231)
	at Test.ajout(Test.java:18)
	at Test.<init>(Test.java:11)
	at Test.main(Test.java:60)
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at net.sourceforge.jtds.jdbc.TdsSocket.<init>(TdsSocket.java:182)
	at net.sourceforge.jtds.jdbc.TdsConnection.<init>(TdsConnection.java:178)
	... 15 more
Exception in thread "main" net.sf.hibernate.JDBCException: Cannot open connection
	at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:289)
	at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
	at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
	at net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
	at net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
	at net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2231)
	at Test.ajout(Test.java:18)
	at Test.<init>(Test.java:11)
	at Test.main(Test.java:60)
Caused by: java.sql.SQLException: Connection refused: connect
	at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:181)
	at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:160)
	at net.sourceforge.jtds.jdbc.TdsConnection.<init>(TdsConnection.java:182)
	at net.sourceforge.jtds.jdbc.TdsConnectionJDBC3.<init>(TdsConnectionJDBC3.java:53)
	at net.sourceforge.jtds.jdbc.Driver.getConnection(Driver.java:102)
	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:85)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286)
	... 8 more
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at net.sourceforge.jtds.jdbc.TdsSocket.<init>(TdsSocket.java:182)
	at net.sourceforge.jtds.jdbc.TdsConnection.<init>(TdsConnection.java:178)
	... 15 more

est ce quelqu'un a une idée de l'origine de l'erreur ??

**ferrero** · 07/05/2007, 18h34

essaie de vérifier sur quel port ecoute ton serveur ..

voila un lien qui pourra t'aider

http://msdn2.microsoft.com/fr-fr/library/ms165724.aspx

**apoca** · 07/05/2007, 19h09

ok je vais me documenter là dessus et je te tienderai au courant

**apoca** · 08/05/2007, 11h02

bonjour
en fait t'avais raison ferrero
le port n'etait pas sur ecoute et cela est dû a windows XP SP2
il suffisait d'installer le service pack 4 de sql server pour mettre à les composants
merci pour ton aide

**ferrero** · 08/05/2007, 12h56

content de l'apprendre, bonne continuation

message d'erreur "connection refused: connect"

Eclipse Java

Vue hybride

Discussions similaires

Partager

Partager