Server configuration denies access to data source
hi. I had installed mysql on redhat-7.0 I have a java program that inserts, deletes from mysql. It used to work fine. I had to reinstall linux and hence mysql. Now the same program doesnt work. I get the error: "Server configuration denies access to data source" I can access the databases from the mysql prompt, but not from the java program. Also the db, columns_priv, tables_priv tables in "mysql" database are empty even though there are 3 users and 3 non empty databases. Is this normal? Please help. -sagar __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.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
newbie question on variable length records.
Hi, I am a newbie to Mysql. I would like to know how to create a table with variable length records? i have an object with following variables: varchar v, int a, int b, int c. and i want to store variable number of such objects into the rows. varchar v is the primary key. the entries in the table would look like: v11,a11,b11,c11,a12,b12,c12,a1,b13,c13 v21,a21,b21,c21,a22,b22,c22 Can you please help me with my problem? Thanx in advance. -Sagar __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.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
Re: Query Question
Hi, Since you have over 10,000 member ids it depends on the exact appln that you have. If the length of the SQL query increases above a certain length (i am not sure abt the exact figure), an error is thrown saying "query too complex". such wont be the case in your former method. but, if there are n member ids to be updated, the former update query will have to be executed n number of times, giving n disk accesses from your VB program, while the later query would need just 1. So if you can guarentee that the query string will not become too long, then the later update statement is good. If you are not sure, its better to go for the former update stmt and forget abt disk write time(at least ur program wont crash). -Sagar __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.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
Is it possible?
hi, I was reading the manual for the full-text search. It is really interesting to have a search engine embedded into the database itself!!!. Mysql uses the criterias defined by the mysql developers. Is it possible for the user to specify the the criteria in his/her program and mysql rank the results accordingly. If not, is anything like that on the mysql developer's agenda? This would of course need a highly plug and play architechture. This would ease off the work of people(like me) who are working on search engines. -Sagar A. Tamhane __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.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
Re: column count doesn't match and updating 2 tables
Hi Suzanne, When you say: insert into table_2 select * from table_1 alls fine. All the records and fields will get copied. But when you say: insert into table_2 select fieldname_1 from table_1 you are just selecting fieldname_1 from table_1 while table_2 consists of fieldname_2 also. So the correct sql statement will be: insert into table_2(fieldname_1) select fieldname_1 from table_1; The fieldname_2 will get its default value and if it is an autoincrement field then the value will be incremented and auotmatically inserted. Hope this will clear your doubt. -Sagar A. Tamhane __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.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
