Client/Server Web N-Tier PowerBuilder 8.0 PowerBuilder 8.0 IDE Client/Server Web PowerBuilder / Web-based IT IDE PowerBuilder PowerBuilder 8.0 PowerBuilder 8.0 PowerBuilder 8.0 PowerBuilder Sybase PowerBuilder Sybase Sybase User Conference TechWave 2000 Sybase PowerBuilder 8.0 PowerBuilder 9.0 PowerBuilder PowerBuilder 8.0 Web PowerBuilder 8.0 PowerBuilder 8.0 Workspace Target System Tree Clip Output Source Editor Workspace PowerBuilder 8.0 Workspace Target Target Target PowerScript Target Web Target PowerBuilder 1 Target 1
Target Target PowerScript Target Application PowerScript Target Template Applation PowerScript Target Existing Application PowerScript Target EAServer Component PowerScript Target COM/MTS Component PowerScript Target Automation Server PowerBuilder Application PowerBuilder Application PowerBuilder PowerBuilder Nonvisual User Object Jaguar Server PB NVO Nonvisual User Object MTS COM PowerBuilder Automation Server Web Target Dynamo Web Site PowerDynamo Web Site Web Target Web Site Web Site Web Target Migrate PowerSit 7.1 Project(s) PowerSite Project Web Target Source Controlled Web Target 1 PowerBuilder Target PowerBuilder 1 PowerBuilder 8.0 System Tree Workspace Target PowerBuilder Web Workspace Page Language Components 2 2
1 PowerBuilder 8.0 Workspace Page Language Components Workspace targets libraries component HTML client server (objects properities methods events) JavaScript DynaScript VBScript PowerBuilder ActiveX controls Plugins Java Applets JavaBeans EAServer components 2 System Tree Clip Clip Output PowerBuilder migration builds deployment Toolbars Skip Stop Next Error Previous Error Output Workspace Target 7 2 3 3
2 1 Incremental Build Workspace 2 Full Build Workspace 3 Workspace 4 Build/Deploy/Search 5 Build/Deploy/Search 6 Target Debug 7 Target 3 PowerBuilder 8.0 Sybase PowerSite Web DataWindow Web DataWindow PowerScript DataWindow Web PowerBuilder 8.0 Web Target PowerBuilder 8.0 3 Page Source Preview Sybase PowerSite Front Page DreamWeaver PowerSite (VBScript JavaScript) Server (ASP PowerDynamo) System Tree ActiveX Java Applet EAServer HTML PowerBuilder 8.0 Client/Server Web 4
3 PowerBuilder Web Web DataWindow PowerBuilder PowerBuilder DataWindow DataWindow (WYSIWYG) Visual Basic Delphi Developer 2000 DataWindow PowerBuilder DataWindow Client/Server PowerBuilder 7.0 DataWindow Web Sybase PowerBuilder 7.0 Web DataWindow PowerBuilder Web DataWindow HTML Internet Web DataWindow DataWindow ASP Web DataWindow PowerBuilder Web DataWindow DataWindow Web DataWindow 5 6 5
4 Web DataWindow Web DataWindow Web Client/Server PowerBuilder DataWindow Web DataWindow PowerBuilder 7.0 20 DataWindow PowerBuilder 8.0 100 PowerScript GetRow() GetItemString() Web DataWindow PowerScript DataWindow EAServer Web Web Enterprise Application Server EAServer Sybase CORBA PowerBuilder NVO ActiveX C/C++ Java/EJB CORBA 2 phase commit (load balance) (fail over) (high availability) EAServer J2EE PowerBuilder 7.0 PowerBuilder EAServer PowerBuilder 8.0 EAServer 6
EAServer PowerBuilder 8.0 EAServer Component Wizard (custom user object) EAServer PowerScript Java EAServer PowerBuilder Java C/C++ PowerBuilder PowerBuilder EJB Java J2EE(Java 2 Enterpirse Edition) Java EJB(Enterprise Java Bean) PowerBuilder 8.0 PowerBuilder Jaguar Server PowerBuilder EJB( entity bean session bean) EJB PowerBuilder EJB session bean 1. // 2. //Connection myconnect 3. CartHome MyCartHome // EJB's home interface 4. Cart MyShoppingCart // EJB's remote interface 5. long ll_result 6. // home interface 7. ll_result = myconnect.lookup(mycarthome, "Shopping/Cart", "com.myorg.myproj.shopping.carthome")) 8. // EJB 9. MyShoppingCart = MyCartHome.Create() 10. // EJB 11. MyShoppingCart.AddItem(66) 7
N-Tier (transaction) EAServer PowerBuilder PowerBuilder EAServer CORBACurrent EAServer Transaction Coordinator OTS/XA Transactions EAServer Wizard Transaction Support OTS Style CORBACurrent GetContextService() PowerBuilder PowerBuilder 7.0 PowerBuilder ODBC JDBC OLE DB Sybase Oracle Informix Microsoft SQL Server PowerBuilder 8.0 JDBC JDM(for Microsoft VM) JDS(for Sun VM) JDB JDM JDS JDBC 1.0 JDK/JRE 1.1 JDB JDBC 2.0 Java 2(JDK/JRE 1.2) Sybase ASE 12.0 ASE Failover Java Oracle PowerBuilder 8.0 Oracle 8i Failover DataWindow MicroSoft SQL Server SQL Server 7.0 SQL Server 2000 PowerBuilder 8.0 ANSI outer join SQL JDBC JDB Sybase ASE SYC DirectConnect DIR INFORMIX ODBC Microsoft SQL Server MSS PowerBuilder 8
PowerBuilder 8.0 (Exception handling) PowerBuilder PowerBuilder 8.0 Java PowerBuilder 8.0 Throwable RuntimeError Exception 4 Throwable Nonvisualobject RuntimeError Exception RuntimeError Throwable Corbasystemexception 29 dividebyzeroerror dwruntimeerror nullobjecterror oleruntimeerror Exception Throwable corbauserexception 4 Throwable RuntimeError corbasystemexception EAServer PowerBuilder 29 PowerBuilder 8.0 THROW CATCH THROW THROW THROW exception THROW Exception Exception (Standard Class) (Custom) Exception 9
TRY CATCH FINALLY 1. TRY statementclauset 2. { 3. CATCH ( ThrowableType exidentifier ) 4. statementclausec 5. } 6. {... } 7. { 8. FINALLY 9. statementclausef 10. } 11. END TRY EAServer PowerBuilder EAServer EAServer PowerBuilder Exception EAServer EAServer Exception PowerBuilder CATCH 29 AutoScript PowerBuilder 8.0 PowerBuilder 5 10
AutoScript ChangeDirectory CreateDirectory DirectoryExists FileCopy FileMove? GetCurrentDirectory RemoveDirectory PrintGetPrinter PrintGetPrinters PrintSetPrinter PrintSetupPrinter 5 PowerBuilder 8.0 AutoScript Design->Option AutoScript 5 5 11
PowerBuilder 8.0 (command line) DOS Window ( -> ) PowerBuilder 6 /workspace /target target /deploy /fullbuild /incrementalbuild target PowerBuilder Fullbuild PowerBuilder Incrementalbuild PowerBuilder /output 6 PowerBuilder PB Native PowerBuilder 8.0 Workspace Target PowerBuilder PB Native Workspace Target Server PowerBuilder PowerBuilder System Tree ( ) 7 Client Server Server ( ) ( ) 12
7 PB Native 8 PB Native Get Latest Version Check Out Check In Undo Check Out Server Server Server Server Client Server Server Check Out Check Out Add to Source Control Client Server Remove from Source Control Refresh Status Advanced Options Show Differences Server Check In Server Server Client Microsoft WinDiff utility Server Client Advanced Options 8 PB Native PowerBuilder 8.0 EAServer PowerBuilder 8.0 Distributed PowerBuilder Web.PB Distributed PowerBuilder PowerBuilder 8.0 13
PowerBuilder 8.0 JavaBeans proxy generator Web.PB generator Proxy library project transport structure connectioninfo application connectionbegin connectionend connection getserverinfo() remotestopconnection() remotestoplistening() connection connectstring trace PowerBuilder 8.0 PowerBuilder 8.0 Source Editor Project EAServer SSL EAServer Profile Web DataWindow Container PowerBuilder 8.0 IDE Client/Server Web PowerBuilder PowerBuilder EAServer J2EE 24x7 PowerBuilder 8.0 ( PowerBuilder 8.0 ) 14