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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
