ssh整合问题

Question

HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot create PoolableConnectionFactory (java.net.ConnectException：连接到端口 1527 上的服务器 localhost 时出错，消息为 Connection refused: connect。); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException：连接到端口 1527 上的服务器 localhost 时出错，消息为 Connection refused: connect。)
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot create PoolableConnectionFactory (java.net.ConnectException：连接到端口 1527 上的服务器 localhost 时出错，消息为 Connection refused: connect。); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException：连接到端口 1527 上的服务器 localhost 时出错，消息为 Connection refused: connect。)

root cause org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException：连接到端口 1527 上的服务器 localhost 时出错，消息为 Connection refused: connect。)

root cause java.sql.SQLException: java.net.ConnectException：连接到端口 1527 上的服务器 localhost 时出错，消息为 Connection refused: connect。

root cause org.apache.derby.client.am.DisconnectException: java.net.ConnectException：连接到端口 1527 上的服务器 localhost 时出错，消息为 Connection refused: connect。

root cause java.net.ConnectException: Connection refused: connect
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.PlainSocketImpl.doConnect(Unknown Source)
java.net.PlainSocketImpl.connectToAddress(Unknown Source)
java.net.PlainSocketImpl.connect(Unknown Source)
java.net.SocksSocketImpl.connect(Unknown Source)
java.net.Socket.connect(Unknown Source)
java.net.Socket.connect(Unknown Source)
java.net.Socket.<init>(Unknown Source)
java.net.Socket.<init>(Unknown Source)
org.apache.derby.client.net.OpenSocketAction.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
org.apache.derby.client.net.NetAgent.<init>(Unknown Source)
org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source)
org.apache.derby.client.am.Connection.<init>(Unknown Source)
org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source)
org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
org.hibernate.loader.Loader.doQuery(Loader.java:661)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.loadEntity(Loader.java:1785)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:47)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:41)
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2730)
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:365)
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:346)
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:177)
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)
org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:862)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:799)
org.springframework.orm.hibernate3.HibernateTemplate$2.doInHibernate(HibernateTemplate.java:489)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:483)
org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:477)
com.neusoft.hibernate.UserDAO.findById(UserDAO.java:57)
com.neusoft.service.MyLoginService.myLogin(MyLoginService.java:10)
com.neusoft.struts.MyLoginAction.execute(MyLoginAction.java:46)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

Answer 1

这是applicationConte.xml相关的配置信息 <bean id="mysql" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="org.apache.derby.jdbc.ClientDriver">
</property>
<property name="url"
value="jdbc:derby://localhost:1527/myeclipse">
</property>
<property name="username" value="classiccars"></property>
<property name="password" value="myeclipse"></property>
</bean>
<bean id="sf"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="mysql" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.DerbyDialect
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/neusoft/hibernate/Log.hbm.xml</value>
<value>com/neusoft/hibernate/User.hbm.xml</value></list>
</property>


</bean>

Answer 2

<property name="url"
value="jdbc:derby://localhost:1527/myeclipse">
</property>
你用的是什么数据库？这个连接字符串我好像没见过

Answer 3

myeclipse 连接上有这样 一个选项，能不能不知道，测试了一下 连接失败

Answer 4

derby数据库用的自己的jre。 你要把$DERBY_HOME/bin下的一个批处理文件执行一下，以打开数据库啊。

Answer 5

如果你用的是MyEclipse自带的derby的话，你大概要谷歌一下了。 楼上我说的是，自己安装derby的情形。

Answer 6

我用的是mysql,我试过换mysql的url了,但是也不行.觉得好像不是这个问题,因为这些都是添加框架的时候自动生成的,就是不知道是什么问题.