Open Menu
Close Menu
Apple
Shopping Bag
Apple
Mac
iPad
iPhone
Watch
TV
Music
Support
Search apple.com
Shopping Bag
Lists
Open Menu
Close Menu
Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists
MySQL EOModeler connection problems
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
MySQL EOModeler connection problems
Subject
:
MySQL EOModeler connection problems
From: "Александр Трофимчук" <
email@hidden
>
Date: Fri, 07 Apr 2006 20:58:20 +0400
Hello!
I'm trying to connect to MySQL 4.1 with my EOModeler (WO5.2.1) and get following error:
Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)
I know there is a problem with versions of connector/j, but I've installed connector/j-2.0.14
and I also have changed my password with old_password() function.
Before this changing error was "Communication failure during handshake. Is there a server running on localhost:3306?"
What should I do now?
You can see my current configuration in text below:
"winXP sp2"
java: c:\program files\java\j2re-1.4.2_10
c:\j2sdk1.4.2_10
webobjects 5.2.1 c:\apple
thirdpartyjars:
activation.jar,clutil.jar,ejb-1.0.jar,jaas_1.0.jar,jca_1.0.jar - in folder: c:\local\library\webobjects\extensions
jta_1.0.1.jar, jdbc2_0-stdext.jar, jconn2.jar - in folder c:\apple\library\java
then? I have
eclipse3.2+wolips c:\eclipse
mysql4.1 c:\program files\mysql\mysql server 4.1\
connector/j 3.1 c:\Apple\Local\Library\Webobjects\Extensions\mysql-connector-java-3.1.12-bin.jar
connector/j 2.0.14 c:\apple\library\java\mysql-connector-java-2.0.14-bin.jar
environment variables:
java_home = "C:\j2sdk1.4.2_10"
class_path = "."
path = "%SystemRoot%\system32; %SystemRoot%; %SystemRoot%\System32\Wbem; C:\j2sdk1.4.2_10\bin; C:\Program Files\apache-ant-1.6.5\bin; C:\J2SDK1~1.2_1\bin; C:\Program Files\Microsoft SQL Server\80\Tools\Binn\; C:\Program Files\Microsoft SQL Server\90\Tools\binn\; C:\Program Files\Microsoft SQL Server\90\DTS\Binn\; C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\; C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\; %NEXT_ROOT%\Library\Executables; %NEXT_ROOT%\bin; %NEXT_ROOT%\Library\JDK\bin; C:\Program Files\MySQL\MySQL Server 4.1\bin"
next_root = "C:/Apple"
WEBOBJECTS_JAVA_EXTENSIONS = "C:/PROGRA~1/Java/J2RE14~1.2_1/lib/ext" ??? why not: $NEXT_ROOT/Local/Library/Java ???
WEBOBJECTS_JAVA_HOME = "C:/J2SDK1~1.2_1"
listing of c:\apple\library\java\JavaConfig.plist
{
Vendor = sun;
sun = {
VM = "$NEXT_ROOT/Library/JDK/bin/java.exe";
DefaultClasspath = "$HOME/Library/Java;$NEXT_ROOT/Local/Library/Java;$NEXT_ROOT/Library/Java;$NEXT_ROOT/Library/JDK/lib/classes.zip;$NEXT_ROOT/Library/Frameworks/JavaVM.framework/Classes/awt.jar;$NEXT_ROOT/Library/JDK/lib/swingall.jar;$NEXT_ROOT/Library/Java/mysql-connector-java-2.0.14-bin.jar;$NEXT_ROOT/Library/Java/jta_1.0.1.jar;$NEXT_ROOT/Library/Java/jconn2.jar;$NEXT_ROOT/Library/Java/jdbc2_0-stdext.jar";
DefaultBeanpath = "$HOME/Library/JavaBeans;$NEXT_ROOT/Local/Library/JavaBeans;$NEXT_ROOT/Library/JavaBeans";
Compiler = "$NEXT_ROOT/Library/JDK/bin/javac.exe";
Headers = "$NEXT_ROOT/Library/JDK/include $NEXT_ROOT/Library/JDK/include/winnt";
Library = "$NEXT_ROOT/Library/JDK/lib/javai.lib";
DebugLibrary = "$NEXT_ROOT/Library/JDK/lib/javai_g.lib";
};
}
that is what I use to connect in EOModeler
login: root
password: password
url: jdbc:mysql://localhost/authors
driver: <empty field>
plugin: <empty field>
there is no difference if I use "com.webobjects.jdbcadaptor.MySQLPlugIn" as a plugin name
and no difference if I use variable "WEBOBJECTS_JAVA_EXTENSIONS = $NEXT_ROOT/Local/Library/Java"
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
Follow-Ups
:
Re: MySQL EOModeler connection problems
From:
Dev WO <email@hidden>
Prev by Date:
Re: New java class
Next by Date:
Re: New java class
Previous by thread:
Re: Call from WO
Next by thread:
Re: MySQL EOModeler connection problems
Index(es):
Date
Thread