Java DatBase Connectivity help

[rock pora]

Notepad will be fine for compiling a single file project. For anything more than this you will need an IDE or at least integrate with ant instead of java compiler.

bt I watched a tutorial,it's using notepad..
my class also used notepad

 

[CoolMan88]

machan programming waladi aulak awoth google karala balapan. godak prashna walata answers thiyenawa. me link eka balapan. umbe answer eka thiyenawa.

http://stackoverflow.com/questions/4233049/java-lang-classnotfoundexception-com-mysql-jdbc-driver

 

[rock pora]

ehenam oya dena compile command eka weradi ati.

javac -cp .;mysql_driver_name.jar FileName.java

mn mehema dunne bn
javac -cp .;mysql-connector-java-5.1.29-bin.jar TestDriver.java

ethakota compile venava

java TestDriver dunnama connection fail kiyala enne

 

[MihiCherub]

e kohomda bn mysql-connector-java-5.1.29-bin.jar ekath ekka compile karanne..

Javac TestDrive.java
java -cp mysql-connector-java-5.1.29-bin.jar TestDrive

මේ file එක බල bat එක run කරල බපලන්. connection works කියල එන්නෙ. bat file එකේ edit වලින් ගිහින් බලපන් කරල තියෙන හැටි..

http://www.mediafire.com/download/udjmvsn3v7a4329/TestDriver.rar

 

[rock pora]

Javac TestDrive.java
java -cp mysql-connector-java-5.1.29-bin.jar TestDrive

http://www.mediafire.com/download/egpnw0hnc4etvur/TestDriver.rar

mn java karanna patan aran thavama sathiyak vage venne

oya dipu file 1e bat 1 run kalama virtual machin 1k hadanna ba kiyanavane tharinduvoooo

 

[MihiCherub]

mn java karanna patan aran thavama sathiyak vage venne

oya dipu file 1e bat 1 run kalama virtual machin 1k hadanna ba kiyanavane tharinduvoooo

mama linkuwa update kala.. ayith bala balapan..

 

[sanoka]

1. machan first complie da file normal way javac ekka
2 . den run with Jar file using cp.

 

[DJvodka]

mn mehema dunne bn
javac -cp .;mysql-connector-java-5.1.29-bin.jar TestDriver.java

ethakota compile venava

java TestDriver dunnama connection fail kiyala enne

Den run karanna :

java -cp .;mysql-connector-java-5.1.29-bin.jar TestDriver

 

[rock pora]

mama linkuwa update kala.. ayith bala balapan..

elakiri bn dannam vada..
eke thiyena vidiyata cmd kalama vada nane bn

1. machan first complie da file normal way javac ekka
2 . den run with Jar file using cp.

macho cp dala run kala bn,ethakota kiyanava cp internal & external command not recognized kiyala

Den run karanna :

java -cp .;mysql-connector-java-5.1.29-bin.jar TestDriver

macho mehema dammama,

ethakota ohoma enava bn

 

[rock pora]

vade hari..
cp dala full path ekama denna one jar eka tiyena..

eth e vidiya hari yanne na bn

me source code ekata aye connect venna ba kiyanavane bn

import java.sql.*;
public class ConnectToDB {
public static void main(String[] args) {
Connection conn = null;
try {
String userName = "mmcmillan";
String password = null;
String url = "jdbc:mysql://localhost/test";
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url, userName, password);
System.out.println("Database connection successful.");
}
catch (Exception e) {
System.out.println("Cannot connect to database.");
}
finally {
if (conn != null) {
try {
conn.close();
System.out.println("Database connection closed.");
}
catch (Exception e) {
System.out.println("Database connection cannot be closed.");
}
}
}
}
}

 

[Saul Goodman]

datbase or database ?

 

[rock pora]

machan programming waladi aulak awoth google karala balapan. godak prashna walata answers thiyenawa. me link eka balapan. umbe answer eka thiyenawa.

http://stackoverflow.com/questions/4233049/java-lang-classnotfoundexception-com-mysql-jdbc-driver

macho mn mek ahoyanne iye indan bn..
mn ambaneta google kala,youtube videos patta gahuva..

evage godak evage netbeans,eclips dala karana ev abn thiyenne

notepad seen eka thiyena eva echchara thibbe na,evage karapuva okkoma karala thiyenne.eth venne na bn..

uba dan dipu link ek ethiyena code eka gahuvamath connect venne na bn..

google karala hoya gatthama thamanta eken loku danumak enava,eth hamba une nathnam mole kachal venava bn..

hoyala hoyala barima thana thama thread 1k damme..


dan mata java epa vegena yana thathvayak udavegenai ennee

 

[rock pora]

datbase or database ?

database
itz a mistake

 

[MihiCherub]

elakiri bn dannam vada..
eke thiyena vidiyata cmd kalama vada nane bn

uba nam rata harakek ban.. උබ කොහෙන්ද ජාව ඉගෙන ගන්නෙ. අබ සරණයි.. ඕයි මුලින්ම ඔය නෝට් පෑඩ් මගුල අතඇරපන් db වලට යනව නම්.. පිලිවෙලකට ඉගෙන ගනින්.. hello world ගහන්නත් කලින් DB connection ගහන්න යනව මගුල..

notepad වලින් මුලින්ම hello world, ඊලගට loops ඊලගට තරු රටා.. වගේ ඒව ගහපන්. පස්සෙ ටික ටික තියරි කරපන්. methods, classes, threads, exception handling, etc.. ඊට පස්සෙ තම IDE වලට යන්නෙ. එතනදි තමා ඔය db, libraries වලින් වැඩ ගන්න එවට යන්නෙ. මොන හරකද නෝට පෑඩ් වලින් libraries use කරකර java කරන්නෙ කියන්නෙ.

 

[rock pora]

uba nam rata harakek ban.. උබ කොහෙන්ද ජාව ඉගෙන ගන්නෙ. අබ සරණයි.. ඕයි මුලින්ම ඔය නෝට් පෑඩ් මගුල අතඇරපන් db වලට යනව නම්.. පිලිවෙලකට ඉගෙන ගනින්.. hello world ගහන්නත් කලින් DB connection ගහන්න යනව මගුල..

notepad වලින් මුලින්ම hello world, ඊලගට loops ඊලගට තරු රටා.. වගේ ඒව ගහපන්. පස්සෙ ටික ටික තියරි කරපන්. methods, classes, threads, exception handling, etc.. ඊට පස්සෙ තම IDE වලට යන්නෙ. එතනදි තමා ඔය db, libraries වලින් වැඩ ගන්න එවට යන්නෙ. මොන හරකද නෝට පෑඩ් වලින් libraries use කරකර java කරන්නෙ කියන්නෙ.

macho mn uba kivva pilivelata thama karagena ave bn..
issellama para igena ganna ekata kalin igena gena inna ekek karana vada karanna bane bn,anika javane bn me.
Intergrated Development Environment passe bariya dan me tika karagena inna onene

anika bn me comment 1n uba kohomda mn rata harakek kiyanne

elakiri bn dannam vada..
eke thiyena vidiyata cmd kalama vada nane bn

mn java karanna patan aran thama sathiyak vage venne,echcharath nadda mnda bn...
http://www.google.lk/url?sa=t&rct=j...4q_DmV7NnnkIxNZIw&sig2=Ld4QQ6lSN0zUbbu8TScRNg

 

[sanoka]

machan first COMPILE the file normal way - javac yourfile.java
java -cp mysql-connector-java-5.1.29-bin.jar yourfile

 

[rock pora]

adooooo dan eka hari dooo,mn hoya gattha.ubala nikan kindi part danna epa hariya


mata udav karapu hama kenektama bohoma pin,fattetama erila unne.dan vade set una..notepad ekenma karanna puluvan..
elakiri..
thread eke comment karapu hamotama rep++ dunna

 

[rock pora]

java -cp mysql-connector-java-5.1.29-bin.jar yourfile

this is not work machoo..must add full path of source file,and already save jar file that folder

java -cp C:\java\mysql-connector-java-5.1.29-bin.jar; ConnectToDB

now fixed this problem,so thanx for ur help machoo...

 

[Saul Goodman]

Thanks rock pora.

 

[romero2005]

aiyo salath..danne natho