Mika,
I have also had similar problems in the past... I could swear that the
problem I had was related to the CLASSPATH or JAVA_HOME settings. for
reference, since mine is working fine right now...
CLASSPATH=C:\Program Files\Witango\Dev Studio
5.5\BeanHandler.jar;C:\Program Files\Witango\Dev Studio
5.5\oracle.jar;C:\Program Files\Witango\Dev Studio 5.5\mysql.jar
JAVA_HOME=C:\Program Files\Java\jdk1.5.0
Your dsn, class and url all look fine to me. What's funny is that my
classpath doesn't have the wdjdbc50.jar file...
I wish i could help you more, but It was a while ago that I had the
problem, and I can't remember what fixed it... I may have reinstalled
the dev studio and or reinstalled the jdk to make it work.
/John
Mika Nyman wrote:
Hi
Can anyone please help me with the following problem!
I'm unable to create a functioning JDBC connection to a MySQL database. It
is possible to run stand alone Java-code that connects to MySQL, so the JDBC
driver (Connector/J) seems to be configured correctly and working right.
I'm using the following parameters to configure the JDBC connection in
Witango Studio:
Data Source Name: jyu_kirkot
Driver Class: com.mysql.jdbc.Driver
URL: jdbc:mysql://127.0.0.1:3306/jyu_kirkot
Properties:
user root
password some_pw
When I try to close the connection I get the following error message in a
pop-up window: "Init JAVE Error!". After submiting the name and password in
the action window I get the error message "Could'nt connect to the data
source 'jyu_kirkot'. Check the user name and password on the data source
configuration."
Please let me know if you have encountered something similar or have a hint
how to solve this problem.
The CLASSPATH is .;D:\ServletDevel;C:\Program Files\Witango\Dev Studio
5.5\wdjdbc50.jar;C:\Program
Files\MySQL\mysql-connector-java-3.1.10\mysql-connector-java-3.1.10-bin.jar;
C:\JBoss\jboss-4.0.2\server\default\lib\javax.servlet.jar;
Regards,
Mika Nyman
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
