Re: MySQL EOModeler connection problems
Re: MySQL EOModeler connection problems
- Subject: Re: MySQL EOModeler connection problems
- From: Dev WO <email@hidden>
- Date: Sat, 8 Apr 2006 09:22:17 +0200
Hi,
I don't think your issue is coming from the connection dictionary.
2 things I'd try:
-make sure MySQL is configured to accept network connection (I don't
remember where to look at)
-make sure localhost resolve to your machine
Hope this help,
Xavier
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:
40anazys.com
This email sent to email@hidden
_______________________________________________
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