Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    19

    Smile Unanswered: client sqllite and server db2

    hi Experts

    since i m new to sql lite i have some doubt ....

    i want to make an standalone dektop application package exe format where client can download the application and while downloading or installing the package their will lcoal databse creation using sqllite .And the table data comes from db2 which resides in server .

    here comes my problem

    can anyone tell me how sqllite communicate with db2 over tcp/ip .do i need to write java socket programming suing some connection driver of sql lite and db2 ( including sqlite jar file ) how to do that. i m not understaning the whole concept how it will works,
    i have some idea but that not able to implement guys...please help

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    in the info center
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows
    there are many pages about client connectivity and java
    also the application development guide
    or look in samples below sqllib directory if any db2 client/server installed
    or download a free db2 client/server from IBM
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2009
    Posts
    19

    Red face client sqllite and server db2

    Quote Originally Posted by przytula_guy View Post
    in the info center
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows
    there are many pages about client connectivity and java
    also the application development guide
    or look in samples below sqllib directory if any db2 client/server installed
    or download a free db2 client/server from IBM
    hi thanks for replying

    but i am talking about what is the java code to connect two database.means insert or select the data from db2 databse(remote) and insert into sqlite(remote)

    sorry I am not understanding .please put me more clear picture.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •