Tuesday, November 16, 2010

Configuring database connectivity

User feedback has indicated that the DBConnectionInfo configuration element could use some documentation. DBConnectionInfo is particularly inscrutable, compared with other XML plan file elements, because it uses "constructor-arg"s that are referenced by index, instead of some type of descriptive property name. The user sees "<constructor-arg index="0"" and has no idea what that means. So I’ll detail the elements right here:
dbConnectionInfo.oracle.xml
<bean id="connectionInfo" class="org.diffkit.db.DKDBConnectionInfo">
  <constructor-arg index="0" value="oracle" />  1
  <constructor-arg index="1" value="ORACLE" />  2
  <constructor-arg index="2" value="XE" />      3
  <constructor-arg index="3" value="10.0.1.11" />       4
  <constructor-arg index="4" value="1521" />    5
  <constructor-arg index="5" value="diffkit" /> 6
  <constructor-arg index="6" value="diffkit" /> 7
</bean>
1Your name for this ConnectionInfo element. You can select an abitrary name, and it has no relationship with any real DB construct. This name is merely for presentation-- it will appear in the logs and some types of reports.
2The "Flavor" of connection. Can be any one of: H2, MYSQL, ORACLE, DB2, SQLSERVER, POSTGRES. These correspond to the constants in the Java enum org.diffkit.db.DKDBFlavor.
3The database name. This is what the vendor refers to as the database name.
4The hostname. Can also be an ip address.
5The port.
6The DB username you want to log in as.
7The DB password for username in 6.

For Java programmers

DiffKit is configured using the "core" Spring framework. The above <bean></bean> XML element simply plugs the constructor-args into the longest Constructor of the org.diffkit.db.DKDBConnectionInfo class.

16 comments:

  1. The code can be configured. It depends on how you provide the function to it.

    SEO Philippines

    ReplyDelete
  2. Thanks for explaining by line by line, surely this clearly well explained

    Top SEO Outsourcing Company

    ReplyDelete
  3. Our company sees this thing as something very important. As we all know, database is everything to a system.

    ReplyDelete
  4. Hi friends, This is Murali from Chennai. I am a technology freak. Your technical information is really useful for me to know more about this technology. Keep update your blog.
    Regards..
    Oracle Training in Chennai

    ReplyDelete
  5. Thanks for the nice information. I am sure, I will tweet this to my twitter account. This will help a lot of users.Kansas CIty SEO Search engine optimization is not an event, but rather a process.

    ReplyDelete
  6. Thanks for share this Data base connectivity string. this string are use more time connect to data base. I am SEO executive and read more time developing helpful blogs and best SEO blog because its very Informative.

    ReplyDelete
  7. Rsweb Consulting is a leading name in providing comprehensive search engine optimization services (SEO)Seo services Canada​. The experienced and professional SEOs employment. Thanks for sharing Detail.

    ReplyDelete
  8. I'am planning to join Oracle certified course. I want some expert advice whether i should go for it or not.
    oracle training in chennai|FITA Chennai complaints

    ReplyDelete
  9. Really great news!!! this information is well worth looking everyone. Good tips. I will be sharing this with all of my friends! Thank you for sharing valuable information. Google seo service share diffrent types of blogs realted SEO ,SMO linkbuilding etc. SEO blog, SEO services, seo tips, Google seo services, Top seo blog.

    ReplyDelete
  10. It's nice blog I have really enjoyed keeping up with you on this blog.This is very useful post for everyone. Thank you so much this post.


    ___________________________
    Best Link Building Company

    ReplyDelete
  11. Every weekend i used to pay a quick visit this web site, because i want enjoyment, for the reason that this this web page conations truly fastidious funny material too.
    Internet Marketing

    ReplyDelete