Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Java mysql show table status

 
   Database Help (Home) -> mySQL RSS
Next:  Datediff function  
Author Message
400PM

External


Since: Feb 17, 2005
Posts: 6



(Msg. 1) Posted: Thu Feb 17, 2005 3:11 pm
Post subject: Java mysql show table status
Archived from groups: mailing>database>mysql (more info?)

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.....

 >> Stay informed about: Java mysql show table status 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
newbie: loading image into MySQL table - Hello, How can I load image to MySQL table? I need a solution for Windows and Linux. I tried LOAD_FILE() but it returns me NULL. Thanks in advance.

filter show processlist - Is there a way to filter 'show processlist'? like show processlist where Host rlike "abc" Thanks, Sam

PLS HELP! - show databases and tables and columns - Hi, I just wonder if someone can help me with this: I need to create a sql script which will run when user installs/upgrades my app. User may already have the database and tables tructure setup on the server, or may not. The script needs to..

Tuning Mysql 4.1.10 - I have a freebsd box with 1 gig of memory for mysql/php, I was wondering what my my.cnf should look like, I am doing alot of searches and writes on ISAM tables, I currently have the following: [client] port=3306 socket=/tmp/mysql.sock [mysqld]..

Mysql InnoDB PHP - i have a strange problem : MySQL 4.0.21 innodb and php 4.3.9-1 all tables are in innodb type. For a simple select statement, sometimes i get result and sometimes nothing (i.e mysql_num_rows()>0 or mysql_num_rows()==0). It's a random behaviour. If my....
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]