Java & MySQL show table status command

From: 400PM (send2kb_at_yahoo.com)
Date: 02/17/05 

Date: 17 Feb 2005 14:16:43 -0800

Hi,

I am using java to retrieve a resultset with "show table status" mysql
command. I am having problem reading the [name] and [engine] column.
In the metadata object it is showing as VARCHAR but when I do
getString() it is returning me the object string (e.g. "[B@1e3e7d2")and
not the actual database value. I am using Mysql 4.1 and jdbc driver
3.1. I tried getB/Clob, getBytes, getCharacterStream() and none of
them is working. Any assistance will be appreciated.

thank you in advance.....

Relevant Pages

  • Re: MySQL
    ... Then you can use it from inside MySQL or on the commandline ... it is crying out for a script wrapper to make it more flexible. ... you have the option to use a csv engine. ... So you can now select from your dbase files into a csv file. ...
    (alt.os.linux.suse)
  • Re: unordered word search
    ... > I've built a search engine that queries a MySQL database. ... > if I enter "foo bar", the engine will search for that phrase exactly, ... that is just SQL syntax, ...
    (comp.lang.php)
  • Re: Generalized user-friendly constraint enforcement
    ... the standard does let you name constraints. ... But neither engine I ... For example, under MySQL 5, I create the following table: ... Likewise, SQLite allows you to name CONSTRAINTS, but doesn't report the ...
    (comp.databases)
  • Re: A free tool like Erwin
    ... MySQL ... support foreign keys. ... property "Storage engine" for the tables etc). ...
    (comp.lang.java.databases)
  • Re: problems with mysql database
    ... ISM files are from the old ISAM table engine. ... As detailed in the upgrade documentation for MySQL 5, ... ALTER TABLE table_name TYPE MyISAM; ... before upgrading to MySQL 5. ...
    (freebsd-questions)