郁闷哦

Question

郁闷哦，怕不是连接超时的问题， 
同样的配置和设置，同样的程序， 
在jbuilderx里面可以连接本机和远程的数据库，就是简单的jdbc连接， 
但是到了neatbean里面就只可以连接本地，远程就不行，这什么问题哦，就连jbuilderx自带的jdbc测试都可以连接远程啊"com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:   ** BEGIN NESTED EXCEPTION **   java.net.SocketException MESSAGE: java.net.ConnectException: Connection timed out: connect  STACKTRACE:  java.net.SocketException: java.net.ConnectException: Connection timed out: connect
  at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
  at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
  at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641)
  at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
  at java.sql.DriverManager.getConnection(DriverManager.java:582)
  at java.sql.DriverManager.getConnection(DriverManager.java:185)
  at cardmanage.DgGame.init(DgGame.java:25)
  at cardmanage.CardManageView.<init>(CardManageView.java:29)
  at cardmanage.CardManageApp.startup(CardManageApp.java:19)
  at org.jdesktop.application.Application$1.run(Application.java:171)
  at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
  at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
  at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
   ** END NESTED EXCEPTION **    Last packet sent to the server was 0 ms ago."

Answer 1

没有问题啊，同样的程序同样的参数jbuilderx搞过去就正常，就只有在neatbean里面，测试远程有问题，而且neatbean里面测试本机都没问题。
但是我现在用neatbean写的界面，不能因为这个放弃吧。

Answer 2

数据库是mysql，关于mysql的用户设置都是设置对了的。真是奇怪了，难道是1.6做远程的jdbc有问题？只有怀疑这个，因为其他的设置和环境都是一模一样而且测试成功。

Answer 3

没错，根本没有什么配置文件，就是在程序里面写一下变量，  public static String mysqlDriver = "com.mysql.jdbc.Driver"; //数据库驱动
  public static String mysqlUrl = "jdbc:mysql://234.23.432.122:3306/adf"; //数据库连接字串
  public static String mysqlUser = "aa"; //数据库用户名
  public static String mysqlPsw = "aa";就这么一个配置，错不了啊。

Answer 4

有点见鬼的感觉，我怀疑是neatbean的问题。或者neatbean搞远程连接的时候被限制了。

Answer 5

网上搜索了一下，感觉这个人遇到的问题跟我一样。各位网友，最近在试用netbeans6.0时发现一个很奇怪的问题，描述如下：
os: winxp sp2
jdk:1.5 or 1.6（我是了各种不同的.15和1.6的版本）
dbms:oracle9i,10g,mysql5,pgsql8（结果都一样）
使用netbeans的向导生成一个desktop  database crud项目，发现在配置netbeans的jdbc service时链接本地和远程数据库都没有问题，当数据库是本地的是没有问题，程序可以跑起来，但是当数据库是远程的时，就跑不起来了，报出如下错误：[TopLink Finest]: 2008.01.21 08:05:29.093--ServerSession(13676443)--Thread(Thread[AWT-EventQueue-0,6,main])--end deploying Persistence Unit jdbc:oracle:thin:@150.20.8.66:1521:szwPU; state Deployed; factoryCount 1
2008-1-21 20:05:29 org.jdesktop.application.Application$1 run
严重: Application class emailformapp.EmailFormApp failed to launch
Local Exception Stack: 
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
Error Code: 17002
        at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
        at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:102)
        at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:184)
        at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:582)
        at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:280)
        at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:229)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:93)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:126)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:120)
        at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:91)
        at emailformapp.EmailFormView.initComponents(EmailFormView.java:265)
        at emailformapp.EmailFormView.<init>(EmailFormView.java:35)
        at emailformapp.EmailFormApp.startup(EmailFormApp.java:19)
        at org.jdesktop.application.Application$1.run(Application.java:171)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:100)
        ... 20 more
Exception in thread "AWT-EventQueue-0" java.lang.Error: Application class emailformapp.EmailFormApp failed to launch
        at org.jdesktop.application.Application$1.run(Application.java:177)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
Error Code: 17002
        at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
        at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:102)
        at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:184)
        at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:582)
        at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:280)
        at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:229)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:93)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:126)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:120)
        at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:91)
        at emailformapp.EmailFormView.initComponents(EmailFormView.java:265)
        at emailformapp.EmailFormView.<init>(EmailFormView.java:35)
        at emailformapp.EmailFormApp.startup(EmailFormApp.java:19)
        at org.jdesktop.application.Application$1.run(Application.java:171)
        ... 8 more
Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:100)
        ... 20 more开始我以为是jdbc驱动问题，换了10g或9i的都不行，jdk换了几个版本也不行，把jpa实现换为openjpa也不行。但是有趣的是，同一个程序（与winxp下完全相同）如果在linux下却完全没有类似问题，即本地和远程数据库都可以连接。这是问什麽呢？怀疑应该是jpa实现和jdbc的不兼容造成的。请各位网友帮忙分析一下