Click here to Skip to main content
15,868,014 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Sir my straight fo5rward qwestion.... how do java connects to sql server....
It uses its own defined function to connect to sql server or oracle...
does these databases provide java the interface or the function to connect and communicate to it.
Or...
Nothing is p;rovided by these databases to java...
do you have any idea how these softwares communicate ...

What I have tried:

Sir told me to study and learn. but what should i learn....the .net framework.....the designs of software programming.....pros and cons of dbms database....the networking...the O.S Architecture...and etc....
what should i do...from where should i start....is it possible....!!!
May be from the begining of my membership I have disturbed you all by asking questions completely might be irrelevent....but i need to know the programming system in as better way as i can...please help...me
Posted
Updated 10-Apr-22 5:59am
Comments
Dave Kreskowiak 11-Apr-22 8:16am    
Since your other "question" (rant) was closed, the last connection type you forgot is "shared memory."

But, recreating the entire SqlConnection class is pointless as it already exists, AND you would have to create all of the classes you want to use to retrieve and write data to the database.

Why you want to recreate the SqlConnection class in your own image is anyone's guess, but I can't think of a single reason why I would ever do it. It's a years worth of work reinventing what already exists, for no real benefit.
Member 12712527 11-Apr-22 9:56am    
surely it is a benefit....Like microsoft sqlconnection class there is a seperate class for java, its JDBCODBC connection.
As such there are classes for other scripting language or languages. The moto of these class is same-- to connect to sql express...
if someone develops another package then will he rely on sqlconnection class of microsoft or classes of java...!!! why..? he will make his own class whose moto will be to connect sql server
if you say why ? then i would say why java has seperate class for connecting to sql server. it could have taken help of microsoft's sqlconnection class....

:sigh:
In the same way that C# code does: it's framework provides library services which you call to send SQL commands to the DB engine and get the results back.

And before you ask, so does PHP, Python, C++, C, Cobol, Fortran, Algol, Delphi, and every other high level language ...

You say you are trying to write a generic report generator, but you clearly don't understand how to use frameworks at all - and that's basic stuff. What did you do, learn to write C# by guessing and seeing if it worked? Or worse, YouTube videos? Because if you did, that at least explains why you have no idea how to code ...
 
Share this answer
 
Comments
Member 12712527 10-Apr-22 10:52am    
Your guessing is bit wrong. Nothing like that....
Three softwares I'm working with....
1. ReportBuilder
2. MLM software
3. Most Important of all is Creation of a ORDBMS software....
Note not onl;y this will be surely launched world wide in recent years
In addition to everything Griff said, you can look at Hibernate/JPA for database connectivity.

Your relational data. Objectively. - Hibernate ORM[^]
What is JPA? Introduction to the Java Persistence API | InfoWorld[^]

It really does sound like you have a lack of base understanding of programming and how to use libraries. For Java you're going to want to look into either Maven or Gradle for dependency management. Aside from that, look at the documentation pages and learn how to use them.

Also your statement of "Nothing is p;rovided by these databases to java" is completely incorrect. Pretty much every database provider has Java implementations of database connectors, in this case they would be JDBC connectors, as proven by this Microsoft SQL JDBC connector[^]
 
Share this answer
 
As we all keep telling you: stop making assumptions based on nothing, and study the real features that are available: Trail: JDBC Database Access (The Java™ Tutorials)[^].
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900