naveenkumar jnaveenkumarj.hashnode.net·Jun 23, 2022How to connect with SQL database using java?(JDBC connectivity)prerequisites: 1) WAMPSERVER 2) Eclipse/Apache NetBeans IDE The Java Database Connectivity (JDBC) API: Java Database Connectivity (JDBC) is an application programming interface (API) which defines how a client may access a database. JDBC is like a b...Discuss·10 likes·83 readsJava
Yahaya Yusufomolluabii.hashnode.net·Jun 11, 2022How to use Prepared Statement In JDBCHello and welcome to yet another article. This article serves as a continuation and completion of part-1. If you have no knowledge of JDBC I do advise you read part-1 first then come back to learn to use prepared statement. Prepared statement general...Discuss·7 likes·38 readsJava
Gaurav Sharmajavaexpert.hashnode.net·Feb 18, 2023Prepared Statement in JDBCprerequisites How to create a connection object and establish a connection between a java application and a database. Core Java basics(concept of inheritance,interface,exception handling) Jdbc basics What is a Prepared Statement? It is an interf...Discuss·2 likes·87 readsJava
Kai Niemikni.hashnode.net·Apr 11, 2023Create a Ledger Utilizing CockroachDB - Part II - DeploymentIn this second part of a series about RoachBank, a full-stack financial accounting ledger running on CockroachDB, we will look at how to deploy the bank against a global, multi-regional CockroachDB cluster. Cloud Deployment The ledger provides a few ...DiscussAccounting Ledger for CockroachDBdistributed ledger
Kai Niemikni.hashnode.net·Apr 8, 2023Enhancing the CockroachDB JDBC Driver with Batch Rewrites for Improved PerformanceThe CockroachDB JDBC driver wraps the PostgreSQL driver and thereby offers some performance optimization opportunities transparent towards applications. From an application standpoint, you either use the standard JDBC API or an ORM or abstraction lay...DiscussJDBC Driver for CockroachDBcockroachdb
Kai Niemikni.hashnode.net·Apr 7, 2023Introduction to Spring Data CockroachDBThe Spring Data CockroachDB project aims to provide a familiar and consistent Spring-based programming model for CockroachDB as a SQL database. The primary goal of the Spring Data project is to make it easier to build Spring-powered applications that...DiscussJDBC Driver for CockroachDBSpring Data Jpa
Kai Niemikni.hashnode.net·Apr 6, 2023CockroachDB JDBC Driver: Part II - Design and implementation DetailsIn this second article, we'll take a closer look at the design and implementation of the custom-made CockroachDB JDBC driver. See Part I for an introduction to the driver. Overview The CockroachDB JDBC driver wraps the PostgreSQL JDBC driver (pgjdbc)...DiscussJDBC Driver for CockroachDBJDBC
Kai Niemikni.hashnode.net·Apr 5, 2023CockroachDB JDBC Driver: Part I - A Beginner’s GuideIntroduction This article describes the recently released open-source JDBC Type-4 driver for CockroachDB. It wraps the PostgreSQL JDBC driver (pgjdbc) which in turn communicates in the PostgreSQL native network wire (v3.0) protocol with CockroachDB. ...DiscussJDBC Driver for CockroachDBJDBC
Kai Niemikni.hashnode.net·Apr 3, 2023Introduction to Roach DataRoach Data is a collection of small demos using different Java data access frameworks and ORMs with CockroachDB. The demo projects include: JDBC - using Spring Data JDBC which is just a simpler wrapper around JDBC JDBC (plain) - using plain JDBC wi...DiscussJDBC
Malalakshmi Amalalakshmi.hashnode.net·Apr 1, 2023JDBC: Batch Update Using PreparedStatementBefore getting into Batch Update, first we can discuss about Statement and PreparedStatement approach. Statement approach: In statement approach, one statement object can be used to execute multiple queries. Lets calculate time required to execute o...DiscussJDBC
Malalakshmi Amalalakshmi.hashnode.net·Mar 30, 2023JDBC: Callable Statement and Stored ProcedureCallable Statement: if we want to execute the Stored Procedure then we can use CallableStatement. so first we can learn what is Stored procedure then we can understand how Callable Statement will work. What is the Stored Procedure? In programming, if...DiscussJDBC
Gaurav Sharmajavaexpert.hashnode.net·Feb 20, 2023Stored Procedure In SQLWhat is Stored Procedure? A set of SQL queries is called a stored procedure. Whenever we need one set of SQL statements to use again and again in our database program, then we write those SQL statements together and store them inside a procedure(call...Discuss·64 readsJava
Gaurav Sharmajavaexpert.hashnode.net·Feb 19, 2023Life Cycle Of a Query ExecutionIntro Just like a java code compiles and executes a java program, the same thing happens with a SQL query on the database side. A query also compiles and executes and for compiling and executing it goes under several processes. As we know, JVM compil...Discuss·1 like·35 readsJava
