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 from [...]
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 are [...]
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.

Related recent articles from Google News

Java on Google App Engine requires different approach
SearchSOA
"It's also true that you have to stick with JPA, JDO or plain SQL to store data." Most Java developers should at least be familiar with the Java Persistence ...
and more »
9 Mar 2010 at 9:49am
Mayday - Integrative analytics for expression data
7thSpace Interactive (press release)
Extensive manual data analysis can be done using an inbuilt R terminal and an integrated SQL querying interface. Our visualization framework has become more ...

9 Mar 2010 at 10:12am
Genuitec Readies New Release of MyEclipse IDE
IT Jungle
Rounding out the release are UML 2 upgrades, a JavaScript debugger for IE, a visual SQL builder, and the capability to deactivate unused features through ...

8 Mar 2010 at 11:34pm
SQL Server JDBC Driver 3.0 Community Technology Preview (CTP) Live
Softpedia
A preview of the upcoming Java Database Connectivity (JDBC) driver is currently up for grabs via the Microsoft Download Center. SQL Server JDBC Driver 3.0 ...

3 Mar 2010 at 4:17am
IBM and Eclipse efforts focus on OSGi modularity
NetworkWorld.com
OSGi, which is intended to provide modularity for Java, is the focus of efforts afoot at IBM and the Eclipse Foundation, ...
and more »
4 Mar 2010 at 11:33pm
More related news on: SQL Java"

Related books at Amazon.com

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
Average Customer Review: 4 stars based on 7 reviews.
Customer Review: I'm using this book as my text book for my independent study of database programming with Java. This book is the tops! The primary focus is programming with the Cloudscape database, but it does give you code snippets to use if you're using Oracle or one of the Microsoft databases (like SQL Server). What impresses me about the book is...
Visual Developer SQL Database Programming with Java: Creating Fast, Efficient Database Applications for the Web
Visual Developer SQL Database Programming with Java: Creating Fast, Efficient Database Applications for the Web
by Bill McCarty, Bill McCarthy
Average Customer Review: 3 stars based on 10 reviews.
Customer Review: I found this book to be extremely useful. It is extremely good at explaining things, and has great code examples. A word of caution: it assumes you'll be using Microsoft Access. It's hard for me to assess how much you would get out of it if you're using a different configuration. It should probably have been called "JDBC programming...
ISO/IEC 9075-13:2003, Information technology - Database languages - SQL - Part 13: SQL Routines and Types Using the Java TM Programming Language (SQL/JRT)
ISO/IEC 9075-13:2003, Information technology - Database languages - SQL - Part 13: SQL Routines and Types Using the Java TM Programming Language (SQL/JRT)
by ISO/IEC/JTC 1/SC 32
Publisher: Multiple. Distributed through American National Standards Institute (ANSI)
Publication Date: August 2007
Java and SQL
Java and SQL
by Malcolm Taylor
Publisher: Malcolm Taylor
Publication Date: October 2007
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
Average Customer Review: 3 stars based on 4 reviews.
Customer Review: In the pletoria of books on Java and databases, this is the one book that just must be read. It gives a thourough enough introduction to JDBC 1.0 and 2.0 and SQLJ Parts 0-2. Very readable! Covers the subjects to just the right level for developers and database experts.
More related books: Search Amazon.com for SQL Java