Sun-microsystems eWay JDBC/ODBC Adapter Manual de usuario Pagina 123
- Pagina / 133
- Tabla de contenidos
- SOLUCIÓN DE PROBLEMAS
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Appendix A Section A.4
JDBC/ODBC Drivers PostgreSQL Driver
JDBC/ODBC eWay Adapter User’s Guide 123 Sun Microsystems, Inc.
A.4.2 Environment Properties
Use Table 31 to configure the environment properties for the specified JDBC/ODBC
driver.
Note: It is not mandatory to enter driver properties in the Outbound JDBC eWay
Environment properties for PostgreSQL.
URL Connection String jdbc:postgresql://<server-name>:<server-port>/<database-
name>
Note: NOTE: Default server port is 5432.
User Name Login name of the account used to access the database.
Password Password associated with the login account name used to
connect to the database.
Table 31 PostgreSQL Driver Environment Properties
Parameter Value
Description JDBC Connection Pool Datasource
ClassName org.postgresql.jdbc3.Jdbc3ConnectionPool
ClassNamefor
OtherInterfaces
ServerName Server name of the machine hosting the database.
PortNumber <server-port>
Note: NOTE: Default server port is 5432.
DatabaseName <database-name>
User Login name of the account used to access the database.
Password Password associated with the login account name used to
connect to the database.
DriverProperties
Delimiter The default is #.
DataSourceName
MinPoolSize The default is 0.
MaxPoolSize The default is 10.
MaxIdleTime The default is 0.
Table 30 PostgreSQL Driver Connection Information (Continued)
Parameter Value
- USER’S GUIDE 1
- Contents 3
- Using JDBC/ODBC Operations 57 4
- JDBC/ODBC Drivers 117 6
- Index 131 6
- Chapter 1 7
- JDBC Drivers 7
- Type I: JDBC-ODBC Bridge 8
- Type One Driver 8
- Type II: Partial Java driver 9
- Type Two Driver 9
- Type Three Driver 10
- Chapter 1 Section 1.1 11
- About the JDBC/ODBC eWay 13
- What’s New in This Release 13
- About This Document 14
- Related Documents 15
- Documentation Feedback 16
- Installing the JDBC/ODBC eWay 17
- Platform Suite Installation 18
- After Installation 19
- Chapter 2 Section 2.2 20
- Chapter 2 Section 2.3 21
- Viewing Alert Codes 22
- Note: Confirm with the 23
- Administration Guide 24
- Chapter 3 25
- Outbound JDBC eWay 26
- Outbound JDBC XA eWay 26
- Chapter 3 Section 3.2 27
- Inbound JDBC eWay 29
- Chapter 3 Section 3.4 30
- Properties 31
- Inbound JDBC eWay Properties 32
- Outbound JDBC eWay Properties 32
- JDBC Connector Settings 33
- Connection Retry Settings 34
- Chapter 3 Section 3.5 36
- About the Database OTD Wizard 41
- Creating a New JDBC OTD 41
- Select Wizard Type 42
- Connect To Database 42
- Select Database Objects 43
- Select Tables/Views/Aliases 44
- Chapter 4 Section 4.2 45
- Select Procedures 48
- Figure 21 Edit Resultset 51
- Add Prepared Statement 52
- Specify the OTD Name 55
- Review Selections 55
- Chapter 4 Section 4.3 56
- Using JDBC/ODBC Operations 57
- Chapter 5 Section 5.1 58
- Chapter 5 Section 5.2 59
- The Table 60
- The Insert Operation 61
- The Update Operation 62
- The Stored Procedure 63
- Executing Stored Procedures 64
- Procedure 65
- Prepared Statement 67
- Batch Operations 67
- Statements 68
- Sample Projects 69
- Chapter 6 Section 6.1 70
- Sample Project Data 71
- Running the Sample Projects 72
- Running the SQL Script 73
- Importing a Sample Project 73
- Chapter 6 Section 6.5 74
- Creating a Project 75
- Creating the OTDs 75
- Creating a Connectivity Map 76
- Running the Sample 94
- Creating the Business Process 97
- Chapter 6 Section 6.6 100
- Creating the Connectivity Map 107
- Binding the eWay Components 108
- Creating an Environment 109
- Configuring the eWays 110
- Running the Sample Project 115
- JDBC/ODBC Drivers 117
- AS/400 Toolbox Driver 118
- Attunity Driver 119
- Environment Properties 120
- MySQL Connector/J Driver 121
- PostgreSQL Driver 122
- SyBase JConnect Driver 124
- Appendix A Section A.6 125
- Teradata Driver 128
- Installing JDBC/ODBC Drivers 129
- Troubleshooting 130
Relacionado con productos y manuales para Hardware Sun-microsystems eWay JDBC/ODBC Adapter
Hardware Sun-microsystems 1.0 Manual de usuario
(182 paginas)
(182 paginas)
Hardware Sun-microsystems 4500/3 Manual de usuario
(82 paginas)
(82 paginas)
Hardware Sun-microsystems SOLARIS 10 Manual de usuario
(121 paginas)
(121 paginas)
© 2020, manymanuals.es. Todos los derechos reservados | 0.068 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales