From PowerBuilder NVOs, you can access data using either JDBC data sources or Sybase native data sources.
Accessing JDBC data sources in NVOs
To set up a JDBC data source in an NVO, use this PowerScript™ code:
sqlca.dbms = “JDBC” sqlca.dbparm = “CacheName=’DefaultDS’” connect; // check error code ... // use embedded SQL or DataStore disconnect; // check error code
Using your application server facilities, define a JDBC data source and assign a JNDI name to it.
Edit %PB_SERVER_HOME%\config\pb-server-<serverName>.xml, and map the value of the PowerBuilder CacheName to an application server data source JNDI name.
Re-run the configure command—see “Configuring the server plug-in”.
The server plug-in supports five native data source types: Sybase, Oracle, Oracle Unicode, ODBC, and ODBC Unicode. These data source types create their connections using C/C++ code. The connections are managed using Java objects, which provide a JDBC API.
Accessing Sybase native data sources in NVOs
The following PowerScript code sets the DBMS to Sybase native, and the cache name to the Sybase_JCM cache:
sqlca.dbms = “SYJ” sqlca.dbparm = “CacheName=’Sybase_JCM’” ...
To use a cache other than “Sybase_JCM,” set CacheName to the value of a data source that is defined in %PB_SERVER_HOME%\config\pb-server-<serverName>.xml.
In your application server interface, set the driver class and database URL data source properties, replacing dbName, userName, and password with the appropriate values.
Data source type |
Driver class |
Database connection URL |
---|---|---|
Sybase_JCM |
com.sybase.jaguar.jcm.sybase.SybaseDriver |
jdbc:sybase:jcm:sybase:databaseName= db-name;user=userName; password=password |
Oracle_JCM |
com.sybase.jaguar.jcm.oracle.OracleDriver |
jdbc:sybase:jcm:oracle:databaseName= db-name;user=userName; password=password |
Oracle_Unicode |
com.sybase.jaguar.jcm.oracle.OracleuDriver |
jdbc:sybase:jcm:oracle:databaseName= db-name;user=userName; password=password |
Odbc_JCM |
com.sybase.jaguar.jcm.odbc.OdbcDriver |
jdbc:sybase:jcm:odbc:databaseName= db-name;user=userName; password=password |
Odbc_Unicode |
com.sybase.jaguar.jcm.odbc.OdbcuDriver |
jdbc:sybase:jcm:odbc:databaseName= db-name;user=userName; password=password |
Sybase_JCM data source type. The server plug-in uses different names for Open Client™ libraries. Copy the libraries from the Open Client dll directory to %PB_SERVER_HOME%\lib, changing the library names as appropriate—the Open Client library names begin with “lib” and the PowerBuilder library names begin with “libj.”
Open Client libraries |
PowerBuilder libraries |
---|---|
libcs.dll |
libjcs.dll |
libct.dll |
libjct.dll |