Hi Maruthi,
instead of Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
you could use Class.forName("com.mysql.jdbc.Driver");
and
Connection con =
DriverManager.getConnection("Jdbc:mysql://ravuri/Thesiswork","root","");
I guess this is another thing you got to to fix. You don't use any user in your
Torque.properties.
HTH
Chris
-----Original Message-----
From: Maruthi [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 6:41 PM
To: [EMAIL PROTECTED]
Subject: ***SPAM*** Anything wrong in mysql Database configuration?..
Hello Everybody,
Can anybody check my whether there is anything wrong in my MYSQL configuration.I am
using MYSQL 3.51 Driver to connect JDBC to mySQL .My DSN name is ravuri....and my
Database Name is "Thesiswork".I populated the SQL scripts in the source.
Please see below for my configuration. If anything is missing..please suggest me what
i have to change?.Any help in this regard will allow me to step forward a bit after
many days digging around.
Thank you,
Maruthi.
=============================
Coding in JSP Action Class ::
=============================
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("Jdbc:odbc:ravuri");
Statement st=con.createStatement();
String str="INSERT into Thesiswork.registration VALUES
('"+userid+"','"+password+"','"+fname+"','"+lname+"','"+dob+"','"+education+"','"+sex+"','"+email+"',"+telhome+","+telmob+",'"+street
+"','"+city+"',"+zip+",'"+country+"')";
int i=st.executeUpdate(str);
System.out.println("Number of Rows inserted:" +i+"<br>");
==============================
Torque.Properties::
==============================
torque.database.default=default
torque.database.default.adapter=mysql
torque.dsfactory.default.connection.driver = sun.jdbc.odbc.JdbcOdbcDriver
torque.dsfactory.default.connection.url = Jdbc:odbc:ravuri
torque.dsfactory.default.connection.user =
torque.dsfactory.default.connection.password =
===========================================
Project.Properties
============================================
database = mysql
#targetPackage = org.apache.jetspeed.om.torque
torque.retrievableInterface = org.apache.fulcrum.intake.Retrievable
torque.database.url = sun.jdbc.odbc.JdbcOdbcDriver
torque.database.driver = Jdbc:odbc:ravuri
torque.database.user =
torque.database.password =
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
