i have got a issue in connecting my project and the data base i can't download SQLite so i have used db browser so now by using db browser how to connect it to my project
Why do I still get the error like at 14:08? When I run the first login interface, it also shows "java.lang.ClassNotFoundException: org.sqlite, JDBC", when I click on the signup button it still shows up, when finished creating The account cannot be created but still appears, it shows: "java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null.
hey there ,its giving option(not error)that "java.lang.ClassNotFoundException:org.sqlite.JDBC & its not asking for main class????plzzz reply me fast,i have to submit my project as soon as possible
i had connected a jar file v056, xctly d way u did, but aftr clckng d run button itz shwng the message "java.sql.SQLException:No suitable driver for jdbc".. please reply as fast as possible
Sir,though the signup page's field is empty but if i click on create button,an empty row has been created in database.......but i want that if any field is empty and i click on create button an error message will be shown.....how to solve this plz respond...Thanx in advance
give if else statement that if{ jTextField1.getText==""; { JOptionPane.showMessageDilaog(null, "Please fill all the Fields"); } else{ code of create button } }
In javaconnect.java class replace this part of code. Connection conn = DriverManager.getConnection("jdbc:sqlite: followed by your path); Try this it would work
i am connect a jar file v056 ,but after run the application . this show " java.sql.SQLException:NO suitable driver for jdbc" please solve this problem.
have you added sqlite jdbc driver in the Libraries. if not go the link and download it and add it to your project libraries www.java2s.com/Code/Jar/s/Downloadsqlitejdbcv056jar.htm
java.sql.SQLException:No suitable driver found for jdbc.sqlite:C:\Users\MyraB\Documents\NetBeansProjects\Library Management System\LibraryNew.sqlite (this is my error too)
After Clicking on run button ,i am not getting that option that which we have to chose as the main menu and also its showing build successful but the app is not opened like where i could try and check it like the one you showed me in this video. Plzzz plzzz plzzz solve my problem as soon as possible
I got some error while running the forms No suitable driver found for jdbc.sqlite.D:.....AND java.lang.NullPointerException. Please, help me to find and solve them Best regard!!
See firstly as i said in the tutorial that please add the preferred JDBC driver and then please initialize all the values like int a=0 or anything; not int a; hope this will work for you.
Hello Ram Brother!! ab ne jo sqlite jdbc 056 add ki hai na library may meri wahan pay issue a rha hai wo kahta hai " NO suitable driver found" please help kijiye ????
java.sql.sqlexception no suitable driver ..... this the problem i got and i done exactly what in the tutorial and the two before it ... i need help please ??
Hi, I'm getting Java.sql.SQLException:out of memory dialog msg after every click on forgot password and other buttons click.What should i have to do to resolve this. Thanks!!
you can make library files download. Then library files add to netbeans libraries folder inside. besides "you need to make sure that the library files are downloaded correctly?"
ps.setString(3, jTextField3.getText()); how is it possible.. this is not a textField.. this is a passwordField and data type is int so how can i use "String" and "textField"?
i have downloaded the sqlite manager and it is showing also in customize but now it is not displaying in my mozilla firefox in the costomize.......... what can i do ??
this will showing like this when i go to dowloading it for next time , On the top of window it is written there (this add-on is not compatible with your version of firefox) ,what can i do ?
your keeping User as primary key so it is taking value 1 for default. thats why when we insert into table, it is showing null pointer exception because User already have 1 in it. how to remove that? so that we can remove java.nullpointerexception error and can insert data PS copy that query and execute in your sql manager and check whether the query is working or not before writing the query directly into that java file, once run the query in sql and then copy that query and paste here. then you will all know whether error is in java code or in sql query. in here its in query. kindly explain how to remove that
Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db"); // here "test" is db filename THIS ALSO WORKS FINE.:-)
It's showing a message java.lang.ClassNotFoundException:org.sqlite.JDBC please solve my error and the output is showing sign up instead of login im done up to your tutorial 3 when you execute the login section it will login but for its showing a message as described above and output of sign up is opening instead of login
i found the error n i solve dat..but now there is another error during creation of new account..a message came.."java.lang.ArrayIndexOutOfBoundsException:0"..please help me to solve this
"NO SUITABLE DRIVER"Guys I also came across with the same error: Not suitable driver ... I killed 2 hours to find a mistake, it was a syntax error. Everything that is shown in the video is truly correct. 056 you can download here: sourceforge.net/projects/phycluster/files/Packages%20needed/sqlitejdbc-v056.jar/download
my program is run successfully but in new account when i click create button it shown this error java.sql.SQlException: near"in":syntex error please help me to solve this error brother ..thanks
I think you have not added action listener. double click the button or right click on the button and select event and then select actionPerformed and pur the code on it am sure it will work.
I also select event. Please check the link, i upload screenshot. 1. prnt.sc/dh0yhb 2. prnt.sc/dh0yw4 3. prnt.sc/dh0z2h when i click on Run button, there has no popup of the program. I want to why my program is not run like as you?
If anyone is having error driver not found..then install sql workbench. ..and install it.... Now click Database and click connect database Now create a new database by clicking Database -> new database Name it LibraryNew And then in the left pane right click on LibraryNew and create a new table Account If you are having any doubt regarding mysql workbench you can watch video of telusko learning of mysql.... I watched it from there Nd change code in Javaconnect file public class Javaconnect { public static Connection ConnecrDb() { try { String url = "jdbc:mysql://localhost:3306/LibraryNew"; String uname = "root"; String pass = "password"; Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection(url, uname, pass); return null; }catch(Exception e) { Same...... } } } """"""REMEMBER""""" root and password is the username and password you give while installing mysql workbench if anyone is having error in conn = javaconnect.ConnecrDb(); Then change "javaconnect" to "Javaconnect" --- conn = Javaconnect.ConnecrDb() Rest is same..... Mine worked hope it helps....
Please bro, i need a hel. when im trying to register a new account I have this error: how to fix java.sql.SQLException: no such table: Account . how can i fix this? please help!!!!
i still get java.lang.NullPointerException when i try to search username from the database even after trying all the options you mentioned to the comments
hello i added the driver as u give in this rar file but when i run the program a pop will come with an error message the message is java sql SQLException No Suitable driver found for jdbc sqlite i added driver reply me asap
after i hit on create account it says "Java.Lang.UnsupportedException , Not supported for now". Please help me to fix this error. Thanks Please see ur email too
Thanks a lot.
If anyone has any problem in setting with the database.Kindly comment or mail me.I found that solved.Thanks again .
it was very helpful
Thanks for helping
Shariful Islam I have an problem please help me
i have got a issue in connecting my project and the data base i can't download SQLite so i have used db browser so now by using db browser how to connect it to my project
I face a problem... when i am hit create button why show null.pointer Exception?
Why do I still get the error like at 14:08? When I run the first login interface, it also shows "java.lang.ClassNotFoundException: org.sqlite, JDBC", when I click on the signup button it still shows up, when finished creating The account cannot be created but still appears, it shows: "java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null.
Finally I found the error.
Thank you!!
How did you find your error?
Thank you so much Ram. Really helpful series.Appreciate your efforts. Keep uploading such amazing videos.
Thank you for your graceful LOVE.
i have done everything as you told in the video
at 11:03 sec listen this video using headphones
what?
hey there ,its giving option(not error)that "java.lang.ClassNotFoundException:org.sqlite.JDBC
& its not asking for main class????plzzz reply me fast,i have to submit my project as soon as possible
jdbc has been corrected,but new error is occuring that "table account has no column Sec_Q".
plzzz guide me....
If you have issue regarding the code, visit my github youll get the code there. www.github.com/codehax41
I can not use the SQLite Manager from Google it has been changed. Do you have any suggestion ?
hey there is some error showing in the signup.java source code ,
i have also send a mail regarding this
i had connected a jar file v056, xctly d way u did, but aftr clckng d run button itz shwng the message "java.sql.SQLException:No suitable driver for jdbc".. please reply as fast as possible
same error plz rply as soon as possible ?
can you provide me the link for the jar file v056 ???please
bro, when i clicked signup button during run, it show up java.sql.SQLException: constraint failed.... how to solve it? i really like your project
connect again
Sir,though the signup page's field is empty but if i click on create button,an empty row has been created in database.......but i want that if any field is empty and i click on create button an error message will be shown.....how to solve this plz respond...Thanx in advance
give if else statement that
if{
jTextField1.getText=="";
{
JOptionPane.showMessageDilaog(null, "Please fill all the Fields");
}
else{
code of create button
}
}
please explain in details
In javaconnect.java class replace this part of code.
Connection conn = DriverManager.getConnection("jdbc:sqlite: followed by your path);
Try this it would work
Thank You.
thank u bro
which path is to written here could u please ans asap ???
thanks
im already added path..although errror occured ???
i am connect a jar file v056 ,but after run the application . this show " java.sql.SQLException:NO suitable driver for jdbc" please solve this problem.
Works. Thank you!
9:00 Here I get an error saying that it is password string type but in database int type. Please help me.
Hi,
Is there any chance I can use SQL server Management system as a database rather than SQLite.
Please reply ASAP.
Yeah I want to ask the same? Please reply
bro i am getting some error while running the program ( java.sql.SQLException: No suitable driver found for jdbc:sqlite) plz tell me how to resolve it
have you added sqlite jdbc driver in the Libraries. if not go the link and download it and add it to your project libraries
www.java2s.com/Code/Jar/s/Downloadsqlitejdbcv056jar.htm
java.sql.SQLException:No suitable driver found for jdbc.sqlite:C:\Users\MyraB\Documents\NetBeansProjects\Library Management System\LibraryNew.sqlite
(this is my error too)
allready download and use v056 driver on my library
+ralp dexter please add driver in your project by adding in the Library
i already add the driver just like what you did on your video , i don't know why mine doesn't work. :|
hii
i had imported the sqllite jdbc v056
but the same error is running that java.lang.classnotfoundexception:org.sqllite.JDBC
Bro just re-watch the tutorial i think you missing some codes.
I watched it twice. Still getting same error. Please help
Same Here
After Clicking on run button ,i am not getting that option that which we have to chose as the main menu and also its showing build successful but the app is not opened like where i could try and check it like the one you showed me in this video.
Plzzz plzzz plzzz solve my problem as soon as possible
@Tech Entertaining Could you put project's class diagram? Is it project designed on OOP(object oriented programming) concept?
Thank you
You've really helped me Thanks alot!
my pleasure
I got some error while running the forms No suitable driver found for jdbc.sqlite.D:.....AND java.lang.NullPointerException.
Please, help me to find and solve them
Best regard!!
See firstly as i said in the tutorial that please add the preferred JDBC driver and then please initialize all the values like int a=0 or anything; not int a; hope this will work for you.
int a=o???? sry but can u explain where should i initialize the value??
where to initialize??
Where To initialize the value
Hello Ram Brother!! ab ne jo sqlite jdbc 056 add ki hai na library may meri wahan pay issue a rha hai wo kahta hai " NO suitable driver found" please help kijiye ????
bhai uska method har page pe call karo thik ho jayegi
java.sql.sqlexception no suitable driver ..... this the problem i got and i done exactly what in the tutorial and the two before it ... i need help please ??
conn=javaconnect.ConnecrDb();
make sure you written this line in every frame.
in everey frame i added but it seeing No suitable driver found help me bro?
i cannot download the require JAR file, may I know where to get it and what type JAR file required for the "SignUp"
Hi,
I'm getting Java.sql.SQLException:out of memory dialog msg after every click on forgot password and other buttons click.What should i have to do to resolve this.
Thanks!!
make the default value to 0
Hey the jdbc version 056 is not available so is it okay if w use jdbc 054
you can make library files download. Then library files add to netbeans libraries folder inside.
besides "you need to make sure that the library files are downloaded correctly?"
"sqlite-jdbc-3.6.20.1.jar " ı downloaded this file any a web sites
either you can download db browser
ps.setString(3, jTextField3.getText());
how is it possible..
this is not a textField..
this is a passwordField and data type is int
so how can i use "String" and "textField"?
Use this code:String password = String.valueOf(jPasswordField.getPassword());
Guys.. If u r getting a nullpointer exception, write "return conn; " , erase "return null; " in javaconnect program
i have downloaded the sqlite manager and it is showing also in customize but now it is not displaying in my mozilla firefox in the costomize.......... what can i do ??
this will showing like this when i go to dowloading it for next time , On the top of window it is written there (this add-on is not compatible with your version of firefox) ,what can i do ?
download db browser else
I am using Xampp and have already created the login page,later i have added "signup " page and when i click on Signup button nothing happens :(
Solve ho gaya tha ????
your keeping User as primary key so it is taking value 1 for default.
thats why when we insert into table, it is showing null pointer exception because User already have 1 in it.
how to remove that? so that we can remove java.nullpointerexception error and can insert data
PS copy that query and execute in your sql manager and check whether the query is working or not
before writing the query directly into that java file, once run the query in sql and then copy that query and paste here.
then you will all know whether error is in java code or in sql query.
in here its in query.
kindly explain how to remove that
ramsundar.1238@gmail.com this is my mail send me some screen shot so i can help you
why we use super keyword in public signup method ? 4:30
for title
This add-on is not compatible with your version of Firefox. Any other options?
please download the old of version of firefox(56.0.2)support.mozilla.org/en-US/kb/install-older-version-of-firefox
V38
I hav done all steps correctly but not getting the message "new account created" after clicking on create button in sign up. Please help...
so whats the error is
+Tech Entertaining I also have the same issue
Bro, can u give me the link to download Sqlite Manager that u r using?
addons.thunderbird.net/en-us/firefox/addon/sqlite-manager/?src=cb-dl-popular
On clicking create button I get Awt event queue java null pointer exception... What I would do?
Class.forName("org.sqlite.JDBC");
Connection conn =
DriverManager.getConnection("jdbc:sqlite:test.db"); // here "test" is db filename
THIS ALSO WORKS FINE.:-)
Thanks for your advice bro @Sougata Mal
Showing ClassNotFoundException: org.sqlit.JDBC
What's the problem bro?
It's showing a message java.lang.ClassNotFoundException:org.sqlite.JDBC please solve my error and the output is showing sign up instead of login im done up to your tutorial 3 when you execute the login section it will login but for its showing a message as described above and output of sign up is opening instead of login
Suitable drive not found is showing. I have done everything you showed.. Can you plzz upload this project.. I have tried my best..
make sure your javaconnect class have no error.
no errors in my javaconnect class
Yes I have same problem but my java connect class has error is main class not found
when i am hit create button why show null.pointer Exception?
Table named Account has no column named Username.... How to fix this?? When i insert and press create.. It pop-ups like this!!
so whatever the name is create as your wish
i found the error n i solve dat..but now there is another error during creation of new account..a message came.."java.lang.ArrayIndexOutOfBoundsException:0"..please help me to solve this
May I know how you have solved java.sqlException:NO suitable driver found for jdbc error?? As soon as possible?
its saying "java.sql.SQLRxception: no suitable driver found for jdbs:sqlite:(location)
i also added the driver //plz help i am makig my project :/
+Rocker Sabbier please review the tutorials brother.
i need the same project which has 10 classes in only eclipse not going beyond that can you help making it?
"NO SUITABLE DRIVER"Guys I also came across with the same error: Not suitable driver ... I killed 2 hours to find a mistake, it was a syntax error. Everything that is shown in the video is truly correct. 056 you can download here: sourceforge.net/projects/phycluster/files/Packages%20needed/sqlitejdbc-v056.jar/download
From where can I download latest sqlite jdbc 056 jar, the link mentioned here is no more working, kindly help.
It will work just download it from google by searching it.
Bro i found an error... ; java. Lang.unsupportedoperationexception.not support yet....... Can you help me.?
You can download from here www.github.com/codehax41
I am getting this error when i run the signup page
java.lang.classnotfoundexception org.sqlite.jdbc
pls help me asap
sir please correct the code in javaconnect class.
okay sir
thanks for the assisstance
sir the sqlite is not working for newer versions of firefox
can u please provide me with your email id and watsapp no.
In this video you didn't create any method for setvisible.help me how to add the setvisible method
It does not work in the new version of SQLite. What shall I do?
download db browser
my program is run successfully but in new account when i click create button it shown this error java.sql.SQlException: near"in":syntex error please help me to solve this error brother ..thanks
+Darshan Patel check i think some spelling may be incorrect..
i have checked but still same problem wat can i do now
I am getting an error saying: "java.sql.SQLException:near"Question": syntax error... How to fix it?
general syntax error
everytime when i click the create button it is giving nullpoint exception , i have checked everything is correct
Spelling mistake may be in db
i did everything you did in the end i get an error that says java.land.NullPointerException .......
please help me
Dear Zubair this error is generally caused by missing some code or spelling error please re check it out.
Thanking You.
i checked it is still the same
Exception : no such table Account ; can anyone help me with that ?
I created the database over 10 times, and it's still showing me the same thing!
When I click on create button it gives an error java.sql.SQLException:near"NO":syntax error
This error happens when you have spelling mistakes or special symbols.
Sqlite jdbc 056 is not downloading now... What should I do instead of that... My code is not running
Google it you may found some ideas about the website
I already done everything but when i click on run button it's not working. Can you help me?
I think you have not added action listener. double click the button or right click on the button and select event and then select actionPerformed and pur the code on it am sure it will work.
I also select event. Please check the link, i upload screenshot.
1. prnt.sc/dh0yhb
2. prnt.sc/dh0yw4
3. prnt.sc/dh0z2h
when i click on Run button, there has no popup of the program. I want to why my program is not run like as you?
+Saif Uddin have you created the main class of this frame.
+Saif Uddin or please re start with my first tutorial cause i cant know the error in your programming.
Check this. I also create main class of this frame.
prnt.sc/dh6n0i
Bro I have downloaded the sqlite jdbc jar file and installed it but while i run programme it say driver missing what shoul I do? please help me man
Create the class file also with name javaconnect.
I am getting an error java.sql.SQLException : constraint failed.. Please help me to fix it.
Bro I have a doubt kii yah super("forgot password ") iska kya use hai ismai????
why are you writing some code like this super("login").where it goes to process?
+vanitha govindhan this code used for headlines of frame.
ERROR
as shown in the video
Have u clear this error bro
sqlite jdbc 056 i can not found this you can help me plase
If anyone is having error driver not found..then install sql workbench. ..and install it....
Now click Database and click connect database
Now create a new database by clicking Database -> new database
Name it LibraryNew
And then in the left pane right click on LibraryNew and create a new table Account
If you are having any doubt regarding mysql workbench you can watch video of telusko learning of mysql.... I watched it from there
Nd change code in Javaconnect file
public class Javaconnect
{
public static Connection ConnecrDb()
{
try
{
String url = "jdbc:mysql://localhost:3306/LibraryNew";
String uname = "root";
String pass = "password";
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, uname, pass);
return null;
}catch(Exception e)
{
Same......
}
}
}
""""""REMEMBER"""""
root and password is the username and password you give while installing mysql workbench
if anyone is having error in
conn = javaconnect.ConnecrDb();
Then change "javaconnect" to "Javaconnect" ---
conn = Javaconnect.ConnecrDb()
Rest is same.....
Mine worked hope it helps....
i am getting java.lang.nullpointer Exception. how can i solve it?
this error only happen when you have not initialized any value like int a; the correct will be int a=2; hope this will work for you
Even I am facing the same problem. How did you solve it?
m facing the same problem as well
where should i use int=a?
hi,
i have done everything how you showed ,but it's saying no such table:Account
+nayeem jorge make sure that name of table which you maded in database both name should be same.
I have done all Code correctly and alredy creat database but messege shows "Incorrect Username and Password" please help.....
When click the Login page this messege shows
My Password and Username is correct in table but this messege shows when Login
Hallo sir, when i am click on create button then it shows lang.nullpointerexception.
may have some syntax error
sir please make a video ,how we can use mysql or zamp with this project, its urgent sir
Can anyone fix this error?
java.sql.SQLException:no such table: Account
I am getting Java.Lang.NullPointerException Whenever I am trying to put data inside the database.
Please help me in it
my javaconnect.class is asking for main method ,how to resolve that?
Make a new project start it again with new one and set login page as main class
when run the signup code it shows numerous errors while i copy same as you did
Please rewatch the video or show me the error so i can identify.
Tech Entertaining thank you for the reply but i corrected my mistake
Please bro, i need a hel. when im trying to register a new account I
have this error: how to fix java.sql.SQLException: no such table:
Account . how can i fix this? please help!!!!
Hey i am getting d same error..how to solve it
Hi this is Kolla Sai kumar.I want to know how to add main class code.
just create a class and then while running the program you need to set the main class just set it
i still get java.lang.NullPointerException when i try to search username from the database even after trying all the options you mentioned to the comments
when i run project the one who comes up is forgot password not login. please help. how can i do the same in tutorial?
make login page as main page.
whenever i try to signup, it shows java.lang.UnsupportedOperationException:Not supported yet, can anyone help me with this?
Will you please show me the signup code here.
hello i added the driver as u give in this rar file but when i run the program a pop will come with an error message the message is
java sql SQLException No Suitable driver found for jdbc sqlite i added driver reply me asap
kindly add the driver in libraries and make the class file
Tech Entertaining
How i did same as u did in video bro
Same problem
I cannot download SQL manager? What am i going to do?
download db browser instead
@@TechEntertaining thanks 💕
i am getting the error "java.lang.NullPointerException." can any one suggest me ,what to do ? it's urgent bro.....
This happened when the pathway wasnt put properly for. Just check ur pathway syntax.
please help me to find my error in my project ..
my error is something in sqlite JDBC
Please add the SQLITE Driver and after that re-watch the tutorials.
Thank You.
I hv also same problem
On your given site the driver has not download
i downloaded this project but unabl;e to execute it ... please give me the information how to execute that file
+Harshal Shende review the tutorials brother
after i hit on create account it says "Java.Lang.UnsupportedException , Not supported for now".
Please help me to fix this error. Thanks Please see ur email too
make sure your query and code is correct as i showed
java.sql.SQLException: No suitable driver found for jdbc:sqlite) its not solve by this driver added
+david khan sorry sir but this error is generally occurs due to drivermissing.
ok.bro i solve my problem
itz a url mistke
im already checked but till my problem is not resolved help me?
validations not working on login button manh!!!!reply asap broh
please bro watch the video again
m getting some problems related to the database..
How can i find my suitable driver for jdbc.sqlite please?
Can you creat a Sample library management program On Foxpro? Thank you.
brother i can't find the sqlite jdbc driver .. plzzz snd me link plzzzz
Source code couldn't open?
sure mail me I'll share zip ramsundar.1238@gmail.com
i cant download the stuffs on the links
Brother sqlite kaise kare bhai
Nahi mil reha hai
Actually driver add krne bad bhi exception error aa rha hai
Plez help
Any one can provide me the link for sqlite jdbc 056?? .please......
I already attached the full video
But,when i am going for downloading this from your link given in the description bellow then it is throwing error .