Unexpected end of input stream-mm.mysql driver related problem*****URGENT*****

2002-04-09 Thread Ramaraju.R.V
Hi, I am geeting an error Unexpected Exception: java.io.IOException message given: Unexpected end of input stream Is there any limitation on the length of the query string (In mm.mysql driver?)? Can any one help me out to avoid this error. LOG: SELECT

HEAP TABLES SUDDENLY DISAPPEARS****VERY URGENT**

2002-03-20 Thread Ramaraju.R.V
Hi, Application uses Jboss server with mysql backend. IMDB tables (Heap tables) are created by the app. Things work on fine. Suddenly we miss Heap tables. We are not able to reproduce this at any particular event. It happens randomly. We could not make out the reason for this. We set

What is ROWNUM of oracle in mysql

2002-02-05 Thread Ramaraju.R.V
Hi, What is the alternative in mysql for ROWNUM of Oracle? Thanks, Rama Raju - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: Join Query Help

2002-01-07 Thread Ramaraju.R.V
Hi, The better way of storage is to normalize it. Hope this way it will help you out. SQL DESC EVENTS Name Null?Type - EVENTID

RE: LOCK TABLES issue

2002-01-07 Thread Ramaraju.R.V
You are using InnoDB or MyISAM??? If u r going for InnoDB, Refer to InnoDB Engine manual for the version 3.23.47 at www.innodb.com. Here you details of different LOCK types. You can select the appropriate lock type at row level for different possibilities. Hope this works!! Cheers :) Rama

RE: How to run commands written in a file

2002-01-07 Thread Ramaraju.R.V
In the script file add the first statement as 'use db_name;' Mysql/binmysql file_name.sql Thanks, Rama Raju -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 4:01 PM To: [EMAIL PROTECTED] Subject: How to run commands written in a file I have