can you please tell me what is with your "menagerie" in your url? i saw that it is your database..but can you tell me where can i find my database name?i get an exception Unknown database. Thanks.
Actually I have used MySQL for database connectivity here... The database in my case is menagerie....u can use MS Access also for the same... u must properly make a database and then carefully follow the steps as explained in the video....
@09:53 in the url the derby is because of *Driver Name* field. If you change "Java DB (Network)" to "MySQL (Connector/J driver)" from the list, the derby will change to mysql in the URL.
thanks a ton :D this is the most clear and easy understandable video tutorial for mysql database connectivty ... i tried every step but did not connect it showed some symbol pointing to import java.sql.*; line when i change that to import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
it ran successfully but showed error in connectivity after pressing fetch data button ..please help
MoreOver u hav to import all the four database connection entities....that are connection,Statement,ResultSet,DriverManager.........
Other problem I may figure out is may be u shud download the MySQL Connector/J again and then add it in ur library of the project...OK......The link is there in the Description.........and the coding given in the description is also genuine.......So .....Gud luck ,,,if u again get any problem......ask me....anytime.....
hi,
can you please tell me what is with your "menagerie" in your url? i saw that it is your database..but can you tell me where can i find my database name?i get an exception Unknown database. Thanks.
babadochiamusic 1 month ago
@babadochiamusic
Actually I have used MySQL for database connectivity here... The database in my case is menagerie....u can use MS Access also for the same... u must properly make a database and then carefully follow the steps as explained in the video....
further to make a database
type in the MySQL console...
create database menagerie
then u can make some tables in it ...
After that connect it with Java Netbeans.....
If u won't succeed in ur attempt ask me here
05psvalent 1 month ago
@05psvalent works!!thank you so much
babadochiamusic 1 month ago
thaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaanks
veeeeeeeeeeeeeeeeeeeeeery much
princespirit999 3 months ago
@09:53 in the url the derby is because of *Driver Name* field. If you change "Java DB (Network)" to "MySQL (Connector/J driver)" from the list, the derby will change to mysql in the URL.
vuguysv2 4 months ago
Thanks, this was very helpful!
gunslinger2002 7 months ago
thanks a ton :D this is the most clear and easy understandable video tutorial for mysql database connectivty ... i tried every step but did not connect it showed some symbol pointing to import java.sql.*; line when i change that to import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
it ran successfully but showed error in connectivity after pressing fetch data button ..please help
afsar786100 8 months ago
@afsar786100
OK ,So Afsar ...Do one thing .....write there Class.forName("com.mysql.jdbc.Driver"); in place of Class.forName("java.sql.Driver");
05psvalent 8 months ago
@afsar786100
MoreOver u hav to import all the four database connection entities....that are connection,Statement,ResultSet,DriverManager.........
Other problem I may figure out is may be u shud download the MySQL Connector/J again and then add it in ur library of the project...OK......The link is there in the Description.........and the coding given in the description is also genuine.......So .....Gud luck ,,,if u again get any problem......ask me....anytime.....
05psvalent 8 months ago
thanx it helped a lot!
shobhik1 8 months ago
@shobhik1 Anytime dear
05psvalent 8 months ago