Newletter Sign Up
Posts on the
Design Decomposition Blog
Iridium Satellite Collision in Space
You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
(The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
Atomicity
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
Well-Formed Business Process Diagrams
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram. To start, here are three criteria [...]
November 18, 2008
Recent Business Process Modeling Books
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good. The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There [...]
October 9, 2008
The Design Decomposition Blog
is written by Doug Barry.

The following table shows the mapping between SQL and Java data types. They are from JDBC.

SQL data type Java data type
Simply mappable Object mappable
CHARACTER   String
VARCHAR   String
LONGVARCHAR   String
NUMERIC   java.math.BigDecimal
DECIMAL   java.math.BigDecimal
BIT boolean Boolean
TINYINT byte Integer
SMALLINT short Integer
INTEGER int Integer
BIGINT long Long
REAL float Float
FLOAT double Double
DOUBLE PRECISION double Double
BINARY   byte[]
VARBINARY   byte[]
LONGVARBINARY   byte[]
DATE   java.sql.Date
TIME   java.sql.Time
TIMESTAMP   java.sql.Timestamp

Related content for: Mapping SQL and Java data types

More on the general topic: SQLJ

Read more free articles on this site

There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.

Search this site for more articles

Custom Search

Browse this site for more articles

Click on the topics below to browse the articles on this site. You can see more detail by clicking on the arrows. This highlights the location of the current article: Mapping SQL and Java data types.

Loading...

Related recent articles from Google News

Survey: NoSQL adoption driven by schema hate
GigaOm
NoSQL (or not only SQL) databases, which do not rely on the SQL query language commonly used in relational databases from Oracle, Microsoft, and IBM, got their start in webscale companies like Google and Yahoo that needed their ability to scale out ...
Flexing NoSQL: MongoDB in review Network World
all 17 news articles »
8 Feb 2012 at 8:01am
Programming Opa: Web development, reimagined
InfoWorld
JavaScript, HTML, and CSS in the browser; PHP, Python, Java, Ruby, or the like on the server; MySQL, PostgreSQL, SQL Server, MongoDB, or any of a growing list of database servers as your persistent storage back-end. With Opa, an open source Web ...
and more »
1 Feb 2012 at 5:06am
Big Data and SQL Server: Disruption or Harmony?
Redmond Developer News
By responding to potential threats with thoughtfulness, and a zeal to add value, SQL and Big Data could be big business for Redmond. By Andrew J. Brust The SQL Server relational engine matured a long time ago. There have been advances, of course, ...
and more »
31 Jan 2012 at 5:27pm
Koenig Now Offers Training on Advanced Java
PR.com (press release)
New Delhit, India, February 04, 2012 --(PR.com)-- Advanced Java is designed for those Java programmers who already have strong programming skills but want to learn the advanced features of Java SE. This Koenig course covers advanced user-interface ...
and more »
4 Feb 2012 at 2:12am
Software Engineers x 2
IRISHDEV.com
Develop Object Oriented software in Java or similar OO language. Develop unit test suites in conjunction with all software modules developed. Work with network protocols (both telecommunications and Internet). Work with database technologies – for ...
and more »
7 Feb 2012 at 2:21am
More related news on: SQL Java"

Related books at Amazon.com

Understanding SQL and Java Together: A Guide to SQLJ, JDBC, and Related Technologies (The Morgan Kaufmann Series in Data Management Systems)
Understanding SQL and Java Together: A Guide to SQLJ, JDBC, and Related Technologies (The Morgan Kaufmann Series in Data Management Systems)
by Jim Melton, Andrew Eisenberg
Description: With the growth of Java and the rise of database-powered Web applications, the need to use Java with SQL is clear. Until now, authoritative coverage of the techniques available to meet these challenges and reap their benefits-both programming and career benefits-didn't exist. Understanding SQL and Java Together examines all the standards for combining SQL and Java. It shows you ...
Beginning Java Databases: JDBC, SQL, J2EE, EJB, JSP, XML
Beginning Java Databases: JDBC, SQL, J2EE, EJB, JSP, XML
by Kevin Mukhar, Todd Lauinger, John Carnell
Description: Java has evolved into a robust, high performance programming language that is well suited to a range of different environments, be it on a middle tier Application Server or a client browser. Regardless of the architecture of your application you are using, it will almost certainly need to make use of data that is stored in some form of database. Relational databases are the data st...
Java and SQL
Java and SQL
by Malcolm Taylor
Description: The book presents the key features of both Java and SQL, with particular emphasis on building applications which use both languages. It includes sections on accessing collections and large objects as well as simple types. Packed with useful code samples as well as discussions of general principles, it provides a valuable guide for students and professionals alike. Further informati...
More related books: Search Amazon.com for SQL Java