Newbie needs help to start

B

Bomber_Lord

New Member
[FONT=&quot]Good day everybody

I am requested to start a Java application using JDBC. My application already reads information from a database in SQL Server 2005 but my clients has one database set in Progress.

Since Progress is complete new for me, I would like to know any information that may haste my research. The program already does everything the client "needs", which is basically only doing queries in the database and graphing the results. All I need to know to move on is:[/FONT]

  • [FONT=&quot]Where can I find JDBC drivers for a particular database in Progress?[/FONT]
  • [FONT=&quot]How can I set up my own Progress Database and/or backup an existing one? mainly to test my program[/FONT]
  • [FONT=&quot]How can I connect to a Progress Database using JDBC (if the URL used to connect to the database has a particular syntax)[/FONT]
  • [FONT=&quot]The syntax for doing Queries in progress (if there anything specific about it)[/FONT]
[FONT=&quot]Any answer to these questions by links, comments or any information that can help me will be greatly appreciated. :)[/FONT]
 
Drivers depend on the Progress version. V9 and below they are bundled with Client Networking or SQL Client licenses. OE10 and up they are a free download, although you need someone with a ESD login to get it.

On PSDN, you will also find SQL Reference and SQL Development manuals for your Progress version. That will answer your question about syntax usage, allowable verbs, etc. Nothing really special about the SQL, although you may find yourself missing some favorite bits.

Those manuals should also include the URL syntax.
 
[FONT=&quot]Thank you very much tamhas :)[/FONT][FONT=&quot]

Luckily my researches are "done" so that I can start working. If anybody had a similar problem, here are the answers to the questions I made [/FONT]:awink:

  • [FONT=&quot]Where can I find JDBC drivers for a particular database in Progress?[/FONT]
[FONT=&quot]http://developers.sun.com/product/jdbc/drivers

Your browser may send you a different page, from that page just look for JDBC drivers (CTRL+F) and you may find the link to that place.
As far I know the JDBC driver from Java is supported for all versions of Progress but you may find out in that page[/FONT]

  • [FONT=&quot]How can I set up my own Progress Database and/or backup an existing one? mainly to test my program[/FONT]
[FONT=&quot]I found this document http://www.kiphs.com/Client/Documents/Server - New Install.doc. It explains how to setup your Progress Database and everything you need to know to install it. Once again this is for a particular version of Progress, each version may have its own way to install it but the process may be pretty similar or the instructions may be found for each version.[/FONT]

  • [FONT=&quot]How can I connect to a Progress Database using JDBC (if the URL used to connect to the database has a particular syntax)[/FONT]
[FONT=&quot]From the manual I've found ([/FONT][FONT=&quot]http://www.psdn.com/library/entry.js...ategoryID=1344[/FONT][FONT=&quot] ) the information to connect to the database using JDBC is:

Driver:

[/FONT][FONT=&quot]Class.forName(“com.progress.sql.jdbc.JdbcProgressDriver”);

Connection:
[/FONT][FONT=&quot]jdbc:jdbcprogress:T:host-name:port|service-name:database-name

An example to connect to a particular database is:

[/FONT]String url =“jdbc:jdbcprogress:T:myhost:6718:sports2000”;
String id= “jones“;
String password = “secret“;
Connection con =DriverManager.getConnection(url,id,password);

  • [FONT=&quot]The syntax for doing Queries in progress (if there anything specific about it)[/FONT]
[FONT=&quot]Thanks to tamhas, I've found this: http://www.psdn.com/library/entry.jspa?externalID=1141&categoryID=310
which I think should more than enough to start working on queries.

That answers all of my questions [/FONT];)[FONT=&quot]
I hope this information may be useful for everybody as it has been for me[/FONT]
 
I have to say that it is nice when someone who seems to have a fairly good-sized task ahead of them leaps so quickly to such a complete solution and manages to do it largely through their own effort ... and then shares the results for everyone else! I wish that happened around here more often!
 
You must log in or register to reply here.
Back
Top