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/21 11:10:03 UTC
hello christoph...Anything wrong in mysql Database configuration?..
Hello 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 = // ?
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.
Flo�mann_Christoph <Ch...@volke-muc.de> 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:maruthibabu_2k@yahoo.com]
Sent: Friday, June 18, 2004 6:41 PM
To: jetspeed-user@jakarta.apache.org
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: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
Re: hello christoph...Anything wrong in mysql Database configuration?..
Posted by Stefan Rennick Egglestone <sr...@Cs.Nott.AC.UK>.
Maruthi wrote:
>Hello 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 = // ?
>
>
>
.user and .password are your mysql usernames and passwords - frm you
code above, it looks like you're just logging on
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 <Ch...@volke-muc.de> 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:maruthibabu_2k@yahoo.com]
>Sent: Friday, June 18, 2004 6:41 PM
>To: jetspeed-user@jakarta.apache.org
>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: jetspeed-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
>
>---------------------------------
>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: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org