Well, I don't you use an project.properties file. But I'm quite sure that you have got to mention the user there too: In Torque Properties: torque.dsfactory.default.connection.user = root In Project Properties: torque.database.user = root There is still something else missing: torque.database.default=Thesiswork And in the following entries of torque.properties you replace dsfactory by Thesiswork, eg torque.Thesiswork.default.connection.driver = com.mysql.jdbc.Driver
-----Original Message----- From: Maruthi [mailto:[EMAIL PROTECTED] Sent: Monday, June 21, 2004 11:10 AM To: Jetspeed Users List Subject: ***SPAM*** 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 <[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! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
