SQLException in tomcat with mysql-connector-java-3.1.7
Hi , I have the following problem. I run tomcat with mysql-connector-java-3.1.7 for connecting to mysql server 4.1.10a-standard.When server just a little loaded I see a lot of exceptions in tomcat log: java.sql.SQLException: ResultSet is from UPDATE. No Data. at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236) When I changed to older jdbc driver mysql-connector-java-3.0.16-ga there was no exceptions. If you know something about this please tell me. -- www.FetchBook.Info Find the lowest price - Compare more than a hundred book stores in a click -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Slow access Apache + PHP + MySQL
It could be a DNS problem, but you must give us more details. Santino At 10:47 -0500 26-03-2005, Andre Matos wrote: Hi List, I have 4 web based systems developed using PHP4 and MySQL accessed for 10 users. The Web Server and Database Server were running ok on a Mac OS X 10.3 G4 dual. However, since we move to a new server, the access becomes very slow. This was not expected since we move to a 64 bits high performance machine. Now, we are using MySQL version 4.1.9 with Apache 2.0.52 and PHP 4.3.10, all compiled and running on a Linux Fedora X86_64. My first thought was the systems, but since I have not changed 3 of the 4 systems, I start to look to the database. I monitored the MySQL using MySQL Administrator, but I couldn't identify any problem. It looks ok, but not completely sure if really is. The system administrator told me that could be the PHP session, but again, he also was not complete sure about this. It is a big problem since I need to check in 3 places: MySQL, Apache, or PHP. Does anyone had this kind of problem or has any suggestion or direction to help me to identify and solve this issue? Any help will be appreciated!!! Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Character Set problem
Hi there, I'm on mysql 4.1.10a on Windows 2003 Server. I'm getting : File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file when some PHP applications try accessing their database. I know this is classified as Bug number 312 (http://bugs.mysql.com/bug.php?id=312). I've read through all the supposed fixes and other posts all over the place, but, to be honest, I'm confused. I'm not really sure what the fix is. Is there actually a fix? If there is a fix, would someone be kind enough to give me an idiots guide on what to do please? Regards Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help coverting MDB SQL
I have been using SQLyog for quite some time now to import data from Access and SQL Server database. www.webyog.com Regards, Karam --- Ricky Groleau [EMAIL PROTECTED] wrote: Hello, I have tried and i have failed. I am trying to help out a non-profit site in their move. The old site had a forum run by MDB and in the transfer as you know...it wont work. I have used PHPBB and I like it and want to use it. We need to convert the MDB to SQL. I have DL 2 converters...and MySql..again I have failed. The database is almost 9 meg. I need someone that can convert this for me and then explain how to upload since it is so big. I have read you cannot to it thru the web/mysql? Any help...guidancePLEASE! Regards, RickyG __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database access
I run SuSE 9.1 with mysql 4.0.18. I have two databases plus the two created by my sql. I working on a new security program for one of the databases where the user will login to a webpage for information. The program is presently running on localhost. When I added the necessary user id and password for the program I noticed it shows up in all of the database priveliges. Is there a way to limit it to one database and specifically on table? Connection code: actual user and password are in code. Only SELECT authority is on the database $conn = mysql_connect(localhost, username, password) or die(mysql_error()); mysql_select_db(Lions,$conn) or die(mysql_error()); This works. But I don't want someone to beable to read the other databases or tables in the Lions database. Any help would be appreciated!!! -- Russ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help coverting MDB SQL
IM imagine you mean mdb mysql ? navicat from premium soft can´t be beat in my opinion, it has a 30day trial and does the conversion without any errors - Original Message - From: Rhino To: Ricky Groleau ; mysql@lists.mysql.com Sent: Saturday, March 26, 2005 2:28 PM Subject: Re: Need help coverting MDB SQL Sorry, I don't know how to help you with this; I've never really worked with MDB files or ASPs. I have no experience with the tools that you are using to extract data from the MDB files so I can't answer your questions about IP addresses either. Maybe someone else on this list can help you, although it isn't usually very active on weekends, especially holiday weekends. You could also try posting to one of the many Microsoft newsgroups; I believe there are newsgroups covering ASPs. Another possibility for you is to review the Microsoft manuals. There must be some documentation on how to use MDB files and get data from them. Rhino - Original Message - From: Ricky Groleau To: Rhino ; Ricky Groleau ; mysql@lists.mysql.com Sent: Saturday, March 26, 2005 10:35 AM Subject: Re: Need help coverting MDB SQL Microsofts Acesss that makes ASP pages. The databsae is saved as MDB. Yes, it does have a uplink, my problem is lack of experience with SQL. It asks for localhost, but of course that i smy computer and I dont have any SQL or anything on it. I tried to send it to my sever, but I am lost..is it the IP or web address? Where is SQL hidden on a linux/apache server? ---Original Message--- From: Rhino [EMAIL PROTECTED] Subject: Re: Need help coverting MDB SQL Sent: Mar 26 2005 10:26:58 - Original Message - From: Ricky Groleau [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, March 26, 2005 10:13 AM Subject: Need help coverting MDB SQL Hello, I have tried and i have failed. I am trying to help out a non-profit site in their move. The old site had a forum run by MDB and in the transfer as you know...it won't work. I have used PHPBB and I like it and want to use it. We need to convert the MDB to SQL. I have DL 2 converters...and MySql..again I have failed. The database is almost 9 meg. I need someone that can convert this for me and then explain how to upload since it is so big. I have read you cannot o it thru the web/mysql? Any help...guidancePLEASE! I'm not familiar with MDB but I'm assuming that it is some kind of database, like DB2 or Oracle. Does MDB have any kind of export facility? All of the good databases - and even a lot of lousy ones - have some way to convert the database format into one or more text files. There might be a single file for all of the data or a separate file for each table in the database. If MDB has such a facility, you can almost certainly use MySQLs import facilities to convert the export files from MDB into MySQL tables. Does MDB have some kind of export capability? If you don't know, can you point me to where the MDB documentation is located online and perhaps I can figure it out for you. Rhino -- No virus found in this outgoing message. Checked by AVG AntiVirus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] ---Original Message--- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
show duplicate entries
mysql select count(*) - count(distinct username,email) as 'duplicate names' from users; +-+ | duplicate names | +-+ | 2 | +-+ 1 row in set (0.00 sec) I got this select syntax to count how many duplicate entries i have. But i dont know how to show the duplicate entries i have on that table. Pls help! -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: show duplicate entries
On Sunday, March 27, 2005 19:48, Louie Miranda wrote: mysql select count(*) - count(distinct username,email) as 'duplicate names' from users; +-+ duplicate names | +-+ 2 | +-+ 1 row in set (0.00 sec) I got this select syntax to count how many duplicate entries i have. But i dont know how to show the duplicate entries i have on that table. SELECT username, email, COUNT(*) as n FROM users GROUP BY username, email HAVING n 1 Pls help! -- Louie Miranda http://www.axishift.com -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlimport blocks all access to database
I have been trying to use mysqlimport to load a primarily read only database with data at regular intervals. My problem occurs when my tables are myisam. In this case all access to the database and the tables blocks until mysqlimport completes. The -lock-tables=false parameter does not help. Is this the normal operation? If not how can I still have concurrent read access to the database while mysqlimport is running?
Re: mysqlimport blocks all access to database
Hi Joseph, I have been trying to use mysqlimport to load a primarily read only database with data at regular intervals. My problem occurs when my tables are myisam. In this case all access to the database and the tables blocks until mysqlimport completes. The -lock-tables=false parameter does not help. Is this the normal operation? If not how can I still have concurrent read access to the database while mysqlimport is running? Correct me if I am wrong, but the write request has privilege. So ANY read request is queued until the write request finishes. Otherwise you would get inconsistent read results. Am I correct assuming that you are appending the imported data to the existing data in the database ? Best regards Nils Valentin Tokyo / Japan www.be-known-online.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to import data from Dbase3?
BG Mahesh wrote: Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL. Yap, it is posible to dump the file in a linux machine but you must import it first into a windows mysql and later you dump it to a linux macine mysql. - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Ehrwin Mina [EMAIL PROTECTED] Subject: Re: How to import data from Dbase3? Date: Wed, 23 Mar 2005 02:21:48 -0600 Ehrin, If you have dBase III or later, Clipper or FoxPro, you can export the data comma-separated, then use a free csv-to-mysql utility eg http://sourceforge.net/projects/csv-mysql/ to get it into mysql. If you don't have an xbase executable, it's a little harder, but not much provided there's no memo file. A dbase data file is an ASCII file with a binary header. You can read the header in any file viewer, observe the header size, and find the field names lengths. The data is entirely ASCII, padded to exact col lengths, thus simple to parse with a perl or php script. If there's a memo file, you need an xbase executable. PB - Ehrwin Mina wrote: BG Mahesh wrote: hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ BG, There are tools you can use to migrate it to mysql, i use it before that i get it in the forum. You can search some forum indicating the migration tools for DB3, Foxpro, access. thanks, -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ -- *Ehrwin C. Mina* */Chikka Asia, Inc. /* *9/F RCBC Plaza Tower 2 6819 Ayala Avenue Makati City, Philippines hp1: +639189304383 hp2: +639178452102* *tel: +63-2-757-2630 fax: +63-2-757-2633 email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *URL: **http://www.chikka.com* mailto:[EMAIL PROTECTED] *This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith.* -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
access-trouble using root
Over on http://forums.mysql.com/read.php?10,20058,20058#msg-20058 I posted a msg connected to me having trouble to login to my MySQL database handler. I might save some space here in your email by asking you to go to the above forum-thread, and my last post in the thread goes; Ok, so I did the following; 1. Stop mysqld and restart it with the --skip-grant-tables option as described earlier. 2. Connect to the mysqld server with this command: shell mysql -u root 3. Issue the following statements in the mysql client: mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') - WHERE User='root'; mysql FLUSH PRIVILEGES; Replace ``newpwd'' with the actual root password that you want to use. 4. You should be able to connect using the new password. I got the following result; mysql UPDATE mysql.user SET Password=PASSWORD('my_password') WHERE User='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 5 Changed: 0 Warnings: 0 mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) The thing is that this doesn't work, and I suspect that somehow, webmin and my browser happened to remove some privileges of thr root user while changing password through mentioned webmin. I can't login to mysql neither via the shell as root using mysql -u root -p (without the -p it works, but then I don't seem to be able to do anything), neither can I login via webmin's interface using root as my password and my assigned password. My follow-up question is; where are these settings stored, and how can I change back so that root has full access-rights again??? Thanks in advance!!! N.P -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
General substring update query required
Hi, I want to replace every occurence of a string with another. The following query works fine (appears to anyway) update tbl_websitepages set page_content=replace (page_content,'develop','bucket'); But is there any way to get any Regexp into the substitution? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]