I Have Problem with this Timestamp

[Melvin Zamora]

Hi MySql Community,

I put up a default null value TIMESTAMP on field type TIMESTAMP. Now I enter to 
the database as '-00-00 00:00:00' default for null value. From this on, I 
mapped it using hibernate with mysql-connector-java-3.1.6-bin.jar driver. I 
extract it but error occurred:

Caused by: java.sql.SQLException: Cannot convert value '-00-00 00:00:00' 
from column 9 to TIMESTAMP.

What did I done wrong? Is there a problem with the driver? Or should I use 
DATETIME instead? Some says the format is supposed to be  '-00-00 00.00.00' 
instead, if so this would be a database problem, is this a some kind of 
unresovled bug? Lastly, any remedy for the meantime for this?

Thanks a lot.
Melvin R. Zamora



-
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates 
starting at 1¢/min.

RE: I have problem

[J.R. Bullington]

You need to set a user in MySQL with privileges to that database. From the
mysql console:

mysql> GRANT  ON .* TO @'217.219.201.2'
IDENTIFIED BY 'password' USING GRANT OPTION;

J.R.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

I have problem

[shaaban taheri]

I install (mysql  control center) over the w2k server when I try connect the mysql  
this message is show

 

[EMAIL PROTECTED]:3306] ERROR 1130: Host '217.219.201.2' is not allowed to connect to 
this MySQL server”

 

please help me.

 

Thank you



-
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.

Re: I have problem with a Cyrillic

[Victoria Reznichenko]

Anelia,
Thursday, June 06, 2002, 12:25:25 AM, you wrote:

AT> Description:
AT> I have problem with a Cyrillic when I use clauses "ORDER BY" 
AT> and "LIKE". 
AT> They didn't work correctly. 

What character set do you use? Change you charset to cp1251 or win1251 or koi8_ru.





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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

I have problem with a Cyrillic

[Anelia Taneva]

Description:
I have problem with a Cyrillic when I use clauses "ORDER BY" 
and "LIKE". 
They didn't work correctly. 



Synopsis:   
Submitter-Id:   
Originator: Anelia Taneva
Organization:   
MySQL support:   email support 
Severity:serious 
Priority:   high 
Category:   mysqld
Class:  [ sw-bug | doc-bug | change-request | support ]
Release:mysql-3.23.49

Exectutable:mysqld-nt 
Environment:   
System:WinXP
Compiler:  VC++ 6.0
Architecture:  i
__
12MB-POP3-WAP-SMS---TOBA-E-mail.bG
--

" Ako uckame u Bue agpec B mail.bg 
ugeme myk: http://www.mail.bg/new/ "


-
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: I have problem With mysqlGUI

[Sinisa Milivojevic]

Hi!=20
i use mysql for windown version and i have this problem,
as i know the mysqlGUI is a graphical tool to help you to make tables =
fields and other thinks for your database.
I can change the password ,give sql commands but from the menu =
commands->tables it doesn't work create table, edit table , and drop =
table.
i have one more problem i can't find the file mysqlgui.help in =
www.mysql.com site.If you can send me the url.
Thanks you very much Nikos Tzelvenzis.


Hi!

Create and alter table are on TODO, while edit is in the works
(although I can not find time for it). 

DROP table is something I could add very fast. Thanks for the idea !


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
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

I have problem With mysqlGUI

[Nick Tze]

Hi! 
i use mysql for windown version and i have this problem,
as i know the mysqlGUI is a graphical tool to help you to make tables fields and other 
thinks for your database.
I can change the password ,give sql commands but from the menu commands->tables it 
doesn't work create table, edit table , and drop table.
i have one more problem i can't find the file mysqlgui.help in www.mysql.com site.If 
you can send me the url.
Thanks you very much Nikos Tzelvenzis.