Create custom annotation on attributes of generated Hibernate code

/0 Comments/in /by

tomcat-thumbAnnotations in Java allow developers to define additional metadata information into their source code. Those annotation can be used as instructions to the compiler, compile-time instructor and also as the runtime instruction to the Java VM. Visual Paradigm support generate hibernate source code generation using Java Persistence Annotations (JPA) approach. Besides you can also define custom annotations in model and generate them along with your hibernate source code. This article shows you how to define custom annotations for attributes in generated hibernate source code. Read more

Personalize Database Connection Settings to Aid in Team Development

/1 Comment/in , /by

When a development team is developing a system that requires accessing a database, it is a common practice to setup local databases on each of the development environment and populate them with all the required schema of the system so that developers can develop and test the function they implement with test data in their own database, rather than working with actual data with production database.

Read more

Solving SQL Server Connection Problem

/3 Comments/in , , , /by

SQL ServerUpon database modeling with Visual Paradigm, you always need to connect to the database server to perform generation of your database and reverse engineering of your ER model. However, you may encounter problem in connecting to the Microsoft SQL Server, which is a great obstruction to your modeling. In this article, we will provide ways to help you to check whether your configurations for connecting to SQL Server are correct.
Read more

How to Define Sequence for your ID Generator in ERD

/0 Comments/in , /by

coverIn relational database, records are identified by a unique value. We call this value the primary key. Some databases allow to control how this unique value is being generated by defining the sequence. In this article, we will show you how to model the sequence with Visual Paradigm and use as the ID Generator for your database tables.

 

Read more

Comparison of Query Performance when Working with ORM

/48 Comments/in /by

Using Object-Relational Mapping (ORM) approach is very popular in developing modern database applications. ORM allows you to handle relational data in a pure object-oriented approach, which is more natural to developers and also the modern programming language they are using (i.e. Java, .NET).

Read more

How to Use Customized Type in Object Relational Mapping

/1 Comment/in , /by

When defining class model for your persistent layer, a class is defined as part of the static data model instead of controller or user interface items. And the class is directly mapped to table(s) in your database. As the class is mapped to tables, its attributes is also mapped to columns in table. In order to make the mapping work, you have to model attributes with primitive types like integer, boolean, String, etc. You cannot model the attribute as any other types which are not compatible with database.

To overcome this, you can make use of ORM User Type to define customized datatype for attributes, and persistent its value into database. This article will teach you how to use ORM User Type. Read more