You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Maruthi <ma...@yahoo.com> on 2004/06/18 18:41:28 UTC

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.