Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Malformed reply from SOCKS server

843859Sep 30 2007
Hi,
I created java application and I used wizard in NetBeans with data binding (database application). It works fine on my developer PC, but if I load this jar to the client PC, I got this error

//////////////////////////////////////////////////////////////////////////////////////////////////////////

org.jdesktop.application.Application$1 run
SEVERE: Application class singleplan.SinglePlanApp failed to launch
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build b36-rc)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.SocketException: Malformed reply from SOCKS server

STACKTRACE:

java.net.SocketException: java.net.SocketException: Malformed reply from SOCKS server
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1765)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:85)
at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:537)
at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:212)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:111)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:105)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
at singleplan.SinglePlanView.initComponents(SinglePlanView.java:519)
at singleplan.SinglePlanView.<init>(SinglePlanView.java:59)
at singleplan.SinglePlanApp.startup(SinglePlanApp.java:38)
at org.jdesktop.application.Application$1.run(Application.java:174)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)


////////////////////////////////////////////////////////////////////////////////////////////////////////////

I changed in client's jar the persistence.xml (it is in META-INF) directory to

////////////////////////////////////////////////////////////////////////////////////////////////////////////

<?xml version="1.0" encoding="UTF-8" ?>
- <persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
- <persistence-unit name="myDatabase?characterEncoding=Cp1250PU" transaction-type="RESOURCE_LOCAL">
<provider>oracle.toplink.essentials.PersistenceProvider</provider>
<class>singleplan.MyMainClass</class>
- <properties>
<property name="toplink.jdbc.user" value="root" />
<property name="toplink.jdbc.password" value="password" />
<property name="toplink.jdbc.url" value="jdbc:mysql://xxx.xxx.xxx.xxx:3306/myDatabase?characterEncoding=Cp1250" />
<property name="toplink.jdbc.driver" value="com.mysql.jdbc.Driver" />
</properties>
</persistence-unit>
</persistence>


////////////////////////////////////////////////////////////////////////////////////////////////////////////

Database run on Windows 2003 server, user name, IP adress and password is valid, I can connect to windows server from another application with this value.

I find and read many web pages with this problem on google, but I cann't resolve it.

Thank you for your help me.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2007
Added on Sep 30 2007
0 comments
1,362 views