web application test tool
Hi, I have completed a web-based application using java servlet with mysql as the backend database and tomcat as the server. I try to test my application performance using a free test tool. i found one called Microsoft Web Application Stress tool) it is free. but it's test script is used by AsP. I am not quite sure if there is any web test tool using java servlet? Thank you bin __ Post your ad for free now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems about get access to mysql in other machine.
Hello, I am trying to help my friend to solver her problem. but failed. I need your help. Thanks in advance. I have a mysql database on my machine. the version is 3.23.49. My friend is trying to get access to the database in my computer. She is working on another machine with tomcat server 4.0. She is writting some application which need to get access to the database in my computer. but when she try to connect to the database she got error message. ClassNotFound Exception. Unable to load driver org.gjt.mm.mysql.Driver .. She installed jdbc driver mm.mysql.jdbc-1.2b in her computer and set up it in the classpath. Any help will be really appreciated. bin __ Movies, Music, Sports, Games! http://entertainment.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to make stress test , mysql
hi, I have finished an application about online exam using java servlet and tomcat and mysql. I am trying to write a testing script to simulate 180 students to take the exam during the period of one hour. so far i have no idea how to start. I didn't find anything talking about that. I just found some stress test software but they not free. so i am trying to write a simple testing script. Any help will be appreciated very much. bin __ Movies, Music, Sports, Games! http://entertainment.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
set connection as instance variable ( servlet and mysql)
Hi, My application is about online exam with java servlet as tool, tomcat 3.2.3 as server solution , mysql 3.49 as the backend. considering 180 students take the exam at same time within 50 minutes, there are a lot of transactions with database. what i did right now is to define connection in local variable(within doGet or doPost method), every time this servlet is called, new connection is created. after transaction is done, this connection is closed. I am worrying the speed.(it will comsume a lot connection and time for open new connection). so I am thinking to define connection as instance variable in every servlet, so it can save sometime to open new connection. However, I am not sure if it will cause multi-thread problem? How and when i can close the connection. __ Find, Connect, Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
upload file through servlet ,mysql
Hello, I am afraid to ask some questions. They seem a little bit long. please forgive me.thanks in advanced first. I am working an application which is help user to create questions for exams. I have finish this part but I think i should modify it. I use mysql as the backend and java servlet to generate html pages and tocat as the server. In the creating question page I set the following input forms. one text areas for question body; Four text boxes for the multiple choice of this question. (the multiple choices are plots which drawn by microsoft excel). So what the user should do is to type the question body in html format in the textarea and url addresses of those plots(excel plotXX.xls) into input four boxes then the system will load this question into QUESTIONTable into mysql database. The QUESTIONTABLE has the following fields. qnumber,questionbody,choiceA,choiceB,choiceC,choiceD. So these are my questions: 1. in order to let the server know where these plots are, the user should load these plots first into server from their own computer and then put the url into QUESTIONTABLE in database. Could anyone tell me where i can find some intruction to do upload file to server and also make a browser explorer to let user to browse through the relating directories in server? 2. Are their some free software(image covertion) i can download and integrate into my application. so i can convert the plots from xls(excel)format to jpg format automatically when system wants to fetech the plots. 3. my application is deal with mathematical questions. so there are many mathematical symbols. the html has some limitation to deal with that. what i did is to make those symbols into image(gif or jpg) and add them into html. but it is painful. Is is possible to covert tex file into html? tex file is good at mathematical stuff. __ Post your ad for FREE! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
browse explorer in the server, mysql
Hello, I am afraid to ask some questions. They seem a little bit long. please forgive me.thanks in advanced first. I am working an application which is help user to create questions for exams. I have finish this part but I think i should modify it. I use mysql as the backend and java servlet to generate html pages and tocat as the server. In the creating question page I set the following input forms. one text areas for question body; Four text boxes for the multiple choice of this question. (the multiple choices are plots which drawn by microsoft excel). So what the user should do is to type the question body in html format in the textarea and url addresses of those plots(excel plotXX.xls) into input four boxes then the system will load this question into QUESTIONTable into mysql database. The QUESTIONTABLE has the following fields. qnumber,questionbody,choiceA,choiceB,choiceC,choiceD. So these are my questions: 1. in order to let the server know where these plots are, the user should load these plots first into server from their own computer and then put the url into QUESTIONTABLE in database. Could anyone tell me where i can find some intruction to do upload file to server and also make a browser explorer to let user to browse through the relating directories in server? 2. Are their some free software(image covertion) i can download and integrate into my application. so i can convert the plots from xls(excel)format to jpg format automatically when system wants to fetech the plots. 3. my application is deal with mathematical questions. so there are many mathematical symbols. the html has some limitation to deal with that. what i did is to make those symbols into image(gif or jpg) and add them into html. but it is painful. Is is possible to covert tex file into html? tex file is good at mathematical stuff. __ Post your ad for FREE! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
browse explorer in the server, mysql
Hello, I am afraid to ask some questions. They seem a little bit long. please forgive me.thanks in advanced first. I am working an application which is help user to create questions for exams. I have finish this part but I think i should modify it. I use mysql as the backend and java servlet to generate html pages and tocat as the server. In the creating question page I set the following input forms. one text areas for question body; Four text boxes for the multiple choice of this question. (the multiple choices are plots which drawn by microsoft excel). So what the user should do is to type the question body in html format in the textarea and url addresses of those plots(excel plotXX.xls) into input four boxes then the system will load this question into QUESTIONTable into mysql database. The QUESTIONTABLE has the following fields. qnumber,questionbody,choiceA,choiceB,choiceC,choiceD. So these are my questions: 1. in order to let the server know where these plots are, the user should load these plots first into server from their own computer and then put the url into QUESTIONTABLE in database. Could anyone tell me where i can find some intruction to do upload file to server and also make a browser explorer to let user to browse through the relating directories in server? 2. Are their some free software(image covertion) i can download and integrate into my application. so i can convert the plots from xls(excel)format to jpg format automatically when system wants to fetech the plots. 3. my application is deal with mathematical questions. so there are many mathematical symbols. the html has some limitation to deal with that. what i did is to make those symbols into image(gif or jpg) and add them into html. but it is painful. Is is possible to covert tex file into html? tex file is good at mathematical stuff. __ Post your ad for FREE! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
foreign key on update cascade in mysql doesn't work
Hello, I create innoDB tables database in mysql3.23.49. i create foreign key constraints(On UPdate cascade) in one table. but it seems doesn't work. the system just refused to update. I am wondering the innodb in mysql doesn't support the feature like on update cascade or on delete cascade? thanks bin __ Find, Connect Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
conn.setAutoCommit(false) can't work
Hi, currently i got a problem which i am afraid to ask your help. I am using javaservlet and mysql 3.23.49 with innoDB table type . the code conn.setAutoCommit(false) doesn't work giving me error message(can't disable auto_commit); I am stuck here. anyone can give me some hint i will really appreciated bin __ Find, Connect Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't init my database for innoDB in mysql
Hi, currently i got one problem really need your help. I removed mysql3.23.41 version and install mysql 3.23.49. and it works fine with myisam table. Now i am trying to create innobd tables. so i edit my.cnf file like that( window 2000): [mysqld] basedir=F:/mysql #bind-address=129.128.207.59 datadir=F:/mysql/data #language=F:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # i add these lines innodb_data_home_dir = F:/mysql/ibdata innodb_data_file_path =/ibdata/ibdata1:100M:autoextend:max:2000M set-variable = innodb_buffer_pool_size=150M set-variable = innodb_additional_mem_pool_size=20M innodb_log_group_home_dir = F:/mysql/iblogs innodb_log_arch_dir = F:/mysql/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 #end bincai add [WinMySQLadmin] Server=F:/mysql/bin/mysqld-nt.exe user=system password=password but i when i run mysqld --standalone --console in DOS prompt it give me such error message: InnoDB: syntax error in innodb_data_file_path,020416, can't init databases. I will really appreciate any help. Thanks in advance bin __ Find, Connect Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: update question number in mysql
Hi, Steven and christopher, Thanks a lot for your help. I think i have to store the question number in table. my talbe questionbank store the questions related more than one course. every course has six question sets. so i use question set id and question number as primary key. There is one problem is every time i delete one question for example delete question 5, i have to update all the question numbers after question 5 in this question set.(for example if there is 10 question in this set, i delete question 5 i have to update question numbers for question 6,7 8 9,10 to 5,6,7,8,9) it will take some time. but i think this is for administrator so maybe speed is not very serious issue. Thanks steven for his recommendation for the transactional table i will take a look at it. This is great mailing list. Thanks again bin cai --- Steven Hajducko [EMAIL PROTECTED] wrote: On Fri, 2002-04-12 at 13:52, Christopher Thompson wrote: You shouldn't be storing the questio number at all. You have denormalised your database and this is why you are experiencing this problem. Maybe I don't understand bin's problem, but storing the question # wouldn't seem to be de-normalizing. It would only matter on how he plans on storing it. It would seem to matter on a few things - 1) Is he planning on storing more than 1 exam? 2) Can an exam really have the same question #, twice? If yes, then - Are the questions split upon sections of the exam? Are the questions the same, but have subsections? ( 1a, 1b ? ) From the looks of it, he doesn't seem to want to store more than 1 exam anyways. If he did, he could use a 2 field primary key of exam name and question number. There just isn't enough information on what he wants to do. Instead, store a unique identifier with each one (an 'id' field, autonumbering) and then, when you pull back all the questions, order it by this ID field. Your questions won't have numbers assigned to them but you can do that in whatever app uses the questions. Why not use the question number? It's unique per exam. (Or should be?). I can see the case of doing this would help in his problem of the first and second query, but what if someone enters questions out of order? If he deletes a question, then tries to re-insert it, it would end up being the last question in the exam. You might want to look into using a transactional table bin. Then, you could BEGIN the change, then after your two queries are both completed, commit the change. Therefore, if your computer crashed in the middle of the query, the table would revert to the old form. Of course, the truth is that you _can_ do what you want just using SQL. But trust me, you don't want to. It would be at least O(n^2), I think, and would be a pain to write. On Friday 12 April 2002 2:38 pm, bin cai wrote: Hello, verybody, I am afraid to send my question again. i created a table in mysql database system to store exam questions which has the following column fields: questionnumber(integer),questionbody(String), answers (String) and etc. My problem is if i delete one row(question record) how can iupdate the questionnumber in the easiest way which means mysql can do for me. Is it possible? or i have to write a method to update questionnumber. if In second case i got another worry. for example, i wrote two querys,one is to delete this question record another query is to update the questionnumber,that is , all records whose questionnumbers are greater than the questionnumber of the deleted question should deducted by 1. if at the time After the first query is executed successfully and the second query is being executed, the computer is crashed. the second query will be rolled back. so the question is deleted but the questionnumber is not updated. this will result in a mess. If anybody can give me some hint i will appreicate very much Have a good weekend bin __ Music, Movies, Sports, Games! http://entertainment.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try
does mysql support multi table update?
Hi, everyone, does mysql latest version support multi tables update? Thanks a lot __ Find, Connect Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto update number in mysql
Hello, verybody, currently i got one question. i create a table in mysql database to store questions which have following column fields: questionnumber, questionbody, answers and etc. My problem is if i delete one row(question) how can i update the questionnumber in the easiest way which means mysql can do for me. Is it possible? or i have to write a method to update questionnumber. Any help will be much appreciated. bin __ Music, Movies, Sports, Games! http://entertainment.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update question number in mysql
Hello, verybody, I am afraid to send my question again. i created a table in mysql database system to store exam questions which has the following column fields: questionnumber(integer),questionbody(String), answers (String) and etc. My problem is if i delete one row(question record) how can iupdate the questionnumber in the easiest way which means mysql can do for me. Is it possible? or i have to write a method to update questionnumber. if In second case i got another worry. for example, i wrote two querys,one is to delete this question record another query is to update the questionnumber,that is , all records whose questionnumbers are greater than the questionnumber of the deleted question should deducted by 1. if at the time After the first query is executed successfully and the second query is being executed, the computer is crashed. the second query will be rolled back. so the question is deleted but the questionnumber is not updated. this will result in a mess. If anybody can give me some hint i will appreicate very much Have a good weekend bin __ Music, Movies, Sports, Games! http://entertainment.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
put jtable in session
Hi,listers, I am using java servlet and mysql to develpe a application. i am wondering can i put jtable in session? Thanks in advance bin __ Find, Connect, Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
foreign key doesn't work
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign key (cid) references course on Update cascade , primary key (sid, cid,labsection,year)); cid in takelabexam references cid in table courses. so if i update the cid in courses table. the records in table takelabexam which references to courses should be updated automatically. but it doesn't work. Could any one can help me out. i will appreciate very much bin __ Find, Connect, Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
foreign key doesn't work with mysql
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign key (cid) references course on Update cascade , primary key (sid, cid,labsection,year)); cid in takelabexam references cid in table courses. so if i update the cid in courses table. the records in table takelabexam which references to courses should be updated automatically. but it doesn't work. Could any one can help me out. i will appreciate very much bin __ Find, Connect, Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
foreign key doesn't work with mysql
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign key (cid) references course on Update cascade , primary key (sid, cid,labsection,year)); cid in takelabexam references cid in table courses. so if i update the cid in courses table. the records in table takelabexam which references to courses should be updated automatically. but it doesn't work. Could any one can help me out. i will appreciate very much bin __ Find, Connect, Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table lock
Hi, I have one concern about multithread. I am building online exam system. many students can get access to one table in one time. Should i use table lock every time when one student get access to the table. As i know, mysql is multithread,that means it already incorporate the table lock feature? Thank you bin __ Web-hosting solutions for home and business! http://website.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
store and display image with java
Hi, could you tell me how to store image in mysql database and display on web using java. urgently Thank you very much bin cai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php