Project Installation

[next hornet]

Hello, I'm trying to run the following project: https://github.com/Ajaysinh1290/College-Management-System-In-Java

I managed to import the project but it doesn't connect to the database and gives the following error:

[oak socket]

⌛ This post has been reserved for your question.

Hey @next hornet! Please use /close or the Close Post button above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

[next hornet]

@long fern if you can help, let me know 💛

I ran server.java and it gave me that:

[next hornet]

But when I run loginframe.java it gives that:

[long fern]

It seems you are using SSL/TLS for the communication between the database and the application

check whether the certificates/algorithms match

[next hornet]

how to

[next hornet]

hey @long fern

I realized something

The author added connector j with the version 5

maybe that could be making it not work right?

I tried changing it to 8 but it didn't really accept it

[long fern]

I think that's for MySQL 5

if you use a MySQL 8 server, you would need to use 8

[next hornet]

I know but when I tried to insert a connector j file with version 8

it didn't recognize it

let me show you

[long fern]

where exactly is the code for getting the connection?

Does that part here throw the exception? https://github.com/Ajaysinh1290/College-Management-System-In-Java/blob/master/src/collegeapplication/common/DataBaseConnection.java#L20-L41

[oak socket]

	public static Connection getConnection()
	{
		if(con!=null)
		{
			return con;
		}
		else
		{
			try
			{
				
				Class.forName("com.mysql.jdbc.Driver");
				con=DriverManager.getConnection(url,uname,password);
				return con;
			}
			catch(Exception exp)
			{
				exp.printStackTrace();
				return con;
			}
		}
	}

[long fern]

remove the Class.forName("com.mysql.jdbc.Driver"); from the file I linked

[next hornet]

Alright

But let me clarify couple of things

On mysql there is installation of connector j

Which I have done and it's installed

as connector j 8.0.33

and I took that same file

[long fern]

Did you add the MySQL Connector/J JAR?

[next hornet]

And wrote it on "classpath"

[long fern]

yes

[next hornet]

And added it to "jar files"

[next hornet]

But it gives me that, it doesn't recognize it

I just thought to clarify

[long fern]

the Class.forName("com.mysql.jdbc.Driver"); was for older versions

[next hornet]

alright, sec will remove it

[long fern]

it isn't really a thing any more

[next hornet]

Class.forName("com.mysql.jdbc.Driver");

Remove only that line ?

or the entire code

like from 20 to 41 lines

@long fern

[long fern]

only that one line

[next hornet]

still

Noting, I'm using java version 8 @long fern

like 1.8

Since I think I saw he is using that too

[long fern]

oh you need to remove the same line from checkconnection() as well

I guess

[next hornet]

here @long fern

[long fern]

looks like the MySQL Connector/J JAR isn't on the classpath

check your project structure

[next hornet]

<?xml version="1.0" encoding="UTF-8"?>
<classpath>
<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/JavaSE-1.8"/>
<classpathentry kind="src" path="src"/>
<classpathentry kind="lib" path="jar files/mysql-connector-j-8.0.33.jar"/>
<classpathentry kind="lib" path="jar files/rs2xml.jar"/>
<classpathentry kind="output" path="bin"/>
</classpath>

[next hornet]

yea, it was like having it missing

one moment

finally

thank you mate 💛 💛 💛

[oak socket]

If you are finished with your post, please close it.
If you are not, please ignore this message.
Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.

[next hornet]

Don't remove it

I will need it to note for later

❤️

[long fern]

closing doesn't remove it, it just makes the post less visible (i.e. lower down the list which would happen anyways when the post is inactive)

but it can still happen that we do restructuring at some point - we don't plan to do anything removing previous posts (we also still have an archive of the channels from the old help system) but I can't promise anything

[next hornet]

yea, I will note it today, dw

[next hornet]

do you know how I can know which file is responsible for each element? @long fern

like for example which file is responsible for changing the behavior of the button

[long fern]

well I guess FacultyMain and FacultyPanel are responsible for the faculties thing

[oak socket]

💤 Post marked as dormant

This post has been inactive for over 300 minutes, thus, it has been archived.
If your question was not answered yet, feel free to re-open this post or create a new one.
In case your post is not getting any attention, you can try to use /help ping.
Warning: abusing this will result in moderative actions taken against you.

[next hornet]

hey @long fern

if you are free, can you explain to me how the project works and what's each file is for, just shortly, in steps how did he manage to make it and all that

and I mean creating not setting it up like we been doing

[long fern]

Ask the maintainers of that project

I don't know that project

but in most cases, the files purpose is typically related to the name of the file