Question about MySQL ... - TranceAddict Forums

TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Question about MySQL ...

Posted by LeopoldStotch on May-13-2005 07:50:

Question about MySQL ...

hey guys .. this is a question for the database geeks and computer nerds who use MySQL .. it would be great if someone knows about JDBC and it's connections to MySQL ..

anyways, i was running into problems with the dumb database .. it wasn't taking aliases for tables when i was querying the tables .. such as :

"select a.att1, a.att2
from table a, table2 b";

typing the query at the prompt would give me no problems, but however, when i run it on the net, SQLExceptions get thrown like hell, and tell me that the database cannot find the table .a or .b .. i am like what the hell??? they are f'n aliases .. not the actual table names... hahhahahahahaha ...

i was thinking that it is the way i am creating my 'statements' to create resultSet queries ... this is how i am writing them ...

m_stmt = m_connect.getConnection().prepareStatement(sqlString, ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE );

where m_stmt is declared as PreparedStatement, m_connect.getConnection() gets me a natural java.sql.Connection .. and the TYPE_SCROLL_SENSITIVE and CONCUR_UPDATABLE help me roll back my result sets when i am reading them .. that's pretty awesome .. can you roll resultSets back to the beginning in php ??? .. just wondering ..

but if anyone has any thoughts, and experiences where MySQL thinks the aliases are the actual table names, then speak out, or hold your peace .. hahhahahaa...

Posted by vrahnos on May-13-2005 08:00:

i never used command line....
try this

Posted by vrahnos on May-13-2005 08:46:

quote:
Originally posted by Nou

anyways... i duh know... im tired caz i created a problem that wasnt a problem to begin with and spent an hour trying to solve it only to realize that it wasnt a problem...

i know exactly what you mean....

Posted by LeopoldStotch on May-13-2005 19:05:

quote:
Originally posted by vrahnos
i never used command line....
try this

yeah i got the adminstrator too .. it works fine there too ..
i got the problem fixed anyways ..

[me b!tchin' like some emo crazed haven maniac ]

then i ran into more problems later when i put all my data i put into MySQL into simple INSERT statements, so i can transport the data to Oracle ..

i run the web fine with MySQL ... then i run into more db problems with Oracle .. i am like what the hell??? .. it keeps throwing errors that i have too many processes open, or too many cursors open .. i am like son of a b!tch .. so i had to go back into my code and implement OracleConnectionPooling with my database connections to stop it from opening a single process for each query call i make .. that sucks monkey balls ... so it is finally working, and can enjoy the summer vacation the next week or so .. projects suck ass... hhahahahahahaha ....

[/me b!tchin' like some emo crazed haven maniac ]

Posted by CGRumler on May-13-2005 19:55:

I just got done taking my CPT 272 Database Fundamentals class for this semester. I got down all of the basics pretty damn quick. We did nothing but MySQL. I might be looking into making a career out of this in the near future. I should be getting my Associate's Degree in the mail next week.