Maruthi wrote:
.user and .password are your mysql usernames and passwords - frm you code above, it looks like you're just logging onHello chris..
Thanks for your reply.I changed the thngs like this as per your suggestion::
In the JSP action ::
Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnectio("Jdbc:mysql://ravuri/Thesiswork","root","");
In Torque.Properties::
torque.database.default=default torque.database.default.adapter=mysql
torque.dsfactory.default.connection.driver = com.mysql.jdbc.Driver torque.dsfactory.default.connection.url =Jdbc:mysql://ravuri/Thesiswork torque.dsfactory.default.connection.user = //? torque.dsfactory.default.connection.password = // ?
as root without a password, so trying setting ...connection.user="root" connection.password="" (or maybe that should be connection.password=)
Note if you're trying to store data in the same database as Jetspeed uses, you don't need to usee
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnectio("Jdbc:mysql://ravuri/Thesiswork","root","");You can use
Connection conn = Torque.getConnection()
... later ...
Torque.closeConnection(conn)
In Project .Properties ::
database = mysql
torque.database.url = //? torque.database.driver = //? torque.database.user = //? torque.database.password = //?
But i am getting error "org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException" when i try to log in into jetspeed.I am not getting whats wrong with my settings.
Anything wrong in my project.properties file ..as per this link i just changed the database property to "mysql"( http://portals.apache.org/jetspeed-1/database.html ) in project.properties file remaining leaving as it is.
Should there be any thing in the "?" place in the above list.Please tell me whats wrong with me?.
Thank you very much for your help and patience,
Maruthi.
Flomann_Christoph <[EMAIL PROTECTED]> wrote: 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+"
"); ==============================
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]
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
This message has been scanned but we cannot guarantee that it and any attachments are free from viruses or other damaging content: you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
