Skip to main content

How to Create fresh Database with setup data

By

In agile software development process  Database schema is changed time to time. Most of the enterprise software applications have 'system defined data sets'  (Configurations, constants etc  )  in the Database.In case of a new release, new client,  testing etc. we need an empty Database structure with system defined data sets . This can be achieved by cleaning data-set, but sometimes this can be time consuming and error prone.

An empty Database structure can be created by modern DBMS. Setup data can also be exported from Database tables. Large applications may have complex relationships with tables and data extraction may be painful.        

I have used Jailer (Database Subsetting Tool) to extract system defined data sets.

Jailer is a Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML

Amazingly tool that is immensely useful (after some time spent on getting to know it properly).


Labels:

Comments

Post a Comment

Popular posts from this blog

About virtual thread in java

By
In this blog post, I will introduce you to the concept of virtual threads in Java and how they can improve the performance and scalability of your applications that rely on networking I/O. Virtual threads are lightweight threads that reduce the effort of writing, maintaining, and debugging high-throughput concurrent applications. They are instances of java.lang.Thread that are not tied to a specific operating system (OS) thread, but rather run on a small number of OS threads managed by the Java runtime. This allows the Java runtime to suspend and resume virtual threads when they perform blocking I/O operations, freeing up the OS threads for other tasks. Virtual threads typically have a shallow call stack and perform as few as a single HTTP client call or a single JDBC query. They are suitable for tasks that spend most of their time waiting for I/O, but not for long-running CPU-intensive tasks. Virtual threads are supported by the Java Platform since Java SE 21. They are part of Project...
Post a Comment
Read more

Angular 2 Typescript without node or npm

By
To getting start with angular2 app, we need to setup some bunch of  tool and boilerplate codes. Fortunately there are many easy getting-start projects available for angular2. Those are  angular-cli , angual2-seed etc. Anyway we need to rely on node and npm, that would need for real angular2 projects. But sometimes we need to test  angular2 features  and share demo codes with others. Installing large node modules and setting-up not worth for this kind of task. However for small task you can use angular2 without npm.     have a look at github repository -  https://github.com/ishara/angular2-without-npm happy coding.
1 comment
Read more

is not a JMX compliant Standard MBean

By
I got the fallowing exception and issue solved. If your are using MBean , MBean Interface and Implementation should be in same package, Otherwise use MXBean. javax.management.NotCompliantMBeanException: MBean class comlanka.rest.controller.DataManagerController does not implement DynamicMBean, and neither follows the Standard MBean conventions (javax.management.NotCompliantMBeanException: Class comlanka.rest.controller.DataManagerController is not a JMX compliant Standard MBean) nor the MXBean conventions (javax.management.NotCompliantMBeanException: comlanka.rest.controller.DataManagerController: Class comlanka.rest.controller.DataManagerController is not a JMX compliant MXBean)         at com.sun.jmx.mbeanserver.Introspector.checkCompliance(Introspector.java:176)         at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:317)         at com.sun.jmx.mbeanserver.Jmx...
Post a Comment
Read more