Information Systems:Using JDBC - Revision history

Norwinu: /* JTOpen */

2021-06-04T23:35:35Z

JTOpen

Norwinu: Add important note regarding JTOpen version

2021-06-04T23:19:10Z

Add important note regarding JTOpen version

Norwinu: Remove HikariCP info

2021-06-03T20:16:15Z

Remove HikariCP info

Norwinu at 20:37, 27 May 2021

2021-05-27T20:37:25Z

Norwinu: Created page with "JDBC is what allows Java to access databases. It is a part of the standard JDK (java.sql). Resources for learning JDBC are abundant. This page discusses usage of JDBC at uniPH..."

2021-05-27T20:36:24Z

Created page with "JDBC is what allows Java to access databases. It is a part of the standard JDK (java.sql). Resources for learning JDBC are abundant. This page discusses usage of JDBC at uniPH..."

New page

JDBC is what allows Java to access databases. It is a part of the standard JDK (java.sql). Resources for learning JDBC are abundant. This page discusses usage of JDBC at uniPHARM.

==UWDDBConnection==
Found in <code>com.unipharm.uwd.utils</code> ([[Information Systems:com.unipharm.uwd (Java Integrations)|(UWD Java Integrations]]).

This class was created to be a connection manager of sorts i.e. to provide convenience methods. The current state is that it requires massive improvement. For one, it should be converted to use connection pooling.

==Connection Pooling==
Using a connection pool is important to prevent the opening and closing of DB connections (worst case scenario is one connection open/close per DB operation), which is an "expensive" process. The JDBC API provides the facilities to implement a connection pooling mechanism from scratch, but there are established libraries that already do this for you. The one in use for the UWD Integrations project is HikariCP.

Integrator itself

==JTOpen==
The database facilities in [[Information Systems:IBM Toolbox for Java|JTOpen]] extend JDBC classes. For example, the AS400JDBCConnection class extends <code>java.sql.Connection</code>

[[Category: Iptor Integrator]]
[[Category: Programming/Development]]

← Older revision		Revision as of 23:35, 4 June 2021
Line 12:		Line 12:
	The database facilities in [[Information Systems:IBM Toolbox for Java\|JTOpen]] extend JDBC classes. For example, the AS400JDBCConnection class extends <code>java.sql.Connection</code>.		The database facilities in [[Information Systems:IBM Toolbox for Java\|JTOpen]] extend JDBC classes. For example, the AS400JDBCConnection class extends <code>java.sql.Connection</code>.

−	As of June 2021, JTOpen is at version 10.6, but ''version 9.4 or below'' must be used. Trying to connect using >9.4 will yield a "Connection unexpectedly dropped error". This is most likely due to the fact that the i is at version 7.2. ~~''Edit this section when the i is upgraded and this no longer applies.''~~	+	As of June 2021, JTOpen is at version 10.6, but '''version 9.4 or below''' must be used, as the JDBC driver in later releases is incompatible. Trying to connect using >9.4 will first yield a "Unable to load driver" error, but even when that's fixed, you'll get a "Connection unexpectedly dropped error". This is most likely due to the fact that the i is at version 7.2.
		+
		+	''Edit this section when the i is upgraded and this no longer applies.''

← Older revision		Revision as of 23:19, 4 June 2021
Line 10:		Line 10:

	==JTOpen==		==JTOpen==
−	The database facilities in [[Information Systems:IBM Toolbox for Java\|JTOpen]] extend JDBC classes. For example, the AS400JDBCConnection class extends <code>java.sql.Connection</code>	+	The database facilities in [[Information Systems:IBM Toolbox for Java\|JTOpen]] extend JDBC classes. For example, the AS400JDBCConnection class extends <code>java.sql.Connection</code>.
		+
		+	As of June 2021, JTOpen is at version 10.6, but ''version 9.4 or below'' must be used. Trying to connect using >9.4 will yield a "Connection unexpectedly dropped error". This is most likely due to the fact that the i is at version 7.2. ''Edit this section when the i is upgraded and this no longer applies.''

@@ Line 7: / Line 7: @@
 ==Connection Pooling==
-Using a connection pool is important to prevent the opening and closing of DB connections (worst case scenario is one connection open/close per DB operation), which is an "expensive" process. The JDBC API provides the facilities to implement a connection pooling mechanism from scratch, but there are established libraries that already do this for you. The one in use for the UWD Integrations project is HikariCP.
+Using a connection pool is important to prevent the opening and closing of DB connections (worst case scenario is one connection open/close per DB operation), which is an "expensive" process. Integrator provides connection pooling as one of the core features, but using it will require further training.
 ==JTOpen==

@@ Line 2: / Line 2: @@
 ==UWDDBConnection==
-Found in <code>com.unipharm.uwd.utils</code> ([[Information Systems:com.unipharm.uwd (Java Integrations)|(UWD Java Integrations]]).
+Found in <code>com.unipharm.uwd.utils</code> ([[Information Systems:com.unipharm.uwd (Java integrations project)|UWD Java Integrations)]].
 This class was created to be a connection manager of sorts i.e. to provide convenience methods. The current state is that it requires massive improvement. For one, it should be converted to use connection pooling.