 public void setMaxFieldSize(int max)

Sets the max field size. Since the execution is local, this has no direct effect on the execution of the statement.

Overrides:: setMaxFieldSize in class RTStatementWrapper

o getMaxRows

 public int getMaxRows()

Returns the value set in the last call to setMaxRows size, or 0 by default.

Overrides:: getMaxRows in class RTStatementWrapper

o setMaxRows

 public void setMaxRows(int max)

Sets the max rows. Since the execution is local, this has no direct effect on the execution of the statement.

Overrides:: setMaxRows in class RTStatementWrapper

o getQueryTimeout

 public int getQueryTimeout()

Returns the value set in the last call to setQueryTimeout size, or 0 by default.

Overrides:: getQueryTimeout in class RTStatementWrapper

o setQueryTimeout

 public void setQueryTimeout(int seconds)

Sets the query timeout. Since the execution is local, this has no direct effect on the execution of the statement.

Overrides:: setQueryTimeout in class RTStatementWrapper

o executeComplete

 public void executeComplete()

This is a no-op since the statement is local. There is no state to clean up.

Overrides:: executeComplete in class RTStatementWrapper

o cancel

 public void cancel()

Local statements do nt require cancellation. This call is a no-op.

Overrides:: cancel in class RTStatementWrapper

o getWarnings

 public SQLWarning getWarnings()

Local statements do not produce warnings.

Returns:: null
Overrides:: getWarnings in class RTStatementWrapper

o clearWarnings

 public void clearWarnings()

Since local statements have no warnings, this operation is a no-op

Overrides:: clearWarnings in class RTStatementWrapper

Class sqlj.runtime.profile.ref.ParamRegProfile

java.lang.Object
   |
   +----sqlj.runtime.profile.ref.ProfileWrapper
           |
           +----sqlj.runtime.profile.ref.DynamicProfileWrapper
                   |
                   +----sqlj.runtime.profile.ref.ParamRegProfile

public class ParamRegProfile
extends DynamicProfileWrapper

A ParamRegProfile is a dynamic connected profile that registers the out parameters of any statements with statement type CALLABLE before returning them to the caller.

Constructor Index

o ParamRegProfile(DynamicProfile): Creates a new object which operates on the passed profile data using the passed connection.

Method Index

o getStatement(int): Creates a statement using the underlying dynamic profile.

Constructors

o ParamRegProfile

 public ParamRegProfile(DynamicProfile profile)

Creates a new object which operates on the passed profile data using the passed connection.

Parameters:: conn - the JDBC connection from which to create statements; profileData - the profile data with which to operate
See Also:: getConnectedProfile

Methods

o getStatement

 public RTStatement getStatement(int ndx) throws SQLException

Creates a statement using the underlying dynamic profile. If the statementType is CALLABLE, then out-parameters of the statement are registered using registerOutParameter of the RTCallableStatement befoer it is returned.

Throws: SQLException: if an error occurs in the underlying profile, or while registering pameters
Overrides:: getStatement in class ProfileWrapper
See Also:: getStatementType, getParamInfo, getMode, getSQLType

Class sqlj.runtime.profile.ref.PositionedProfile

java.lang.Object
   |
   +----sqlj.runtime.profile.ref.ProfileWrapper
           |
           +----sqlj.runtime.profile.ref.DynamicProfileWrapper
                   |
                   +----sqlj.runtime.profile.ref.PositionedProfile

public class PositionedProfile
extends DynamicProfileWrapper

A positioned profile is a connected profile wrapper which augments the functionality of the statement creation methods by intercepting any entries with role of POSITIONED, and handling execute of such an entry by creating a new sql operation dynamically with the runtime name of the cursor replacing the ? in the original CURRENT OF ? expression.

Entries with role of POSITIONED have a sql operation that includes the text WHERE CURRENT OF ?. For example, UPDATE TAB SET COL1=? WHERE CURRENT OF ?. The JDBC specification indicates that portable handling of CURRENT OF statements involves passing the name of the current-of-cursor as part of the sql operation rather than as a bind variable. Thus, in the above case, if the cursor name were "CURS", then the text of the new operation created at runtime would be UPDATE TAB SET COL1=? WHERE CURRENT OF CURS. To facilitate construction of the proper sql operation, the entry descriptor for POSITIONED entries is an Integer that describes which passed parameter represents the cursor.

If the operation also includes bind variables, these are stored in an internal cache until the new statement is created, and are then bound to the statement once it has been prepared. We assume that POSITIONED entries only occur with an executeType of EXECUTE_UPDATE and statementType of PREPARED_STATEMENT.

See Also:: POSITIONED

Constructor Index

o PositionedProfile(DynamicProfile): Creates a new positioned profile that augments the functionality of the passed connected profile.

Method Index

o getStatement(int): Returns an executable statement object representing the statement at index "ndx" in the profile, where "ndx" is 0 based.

Constructors

o PositionedProfile

 public PositionedProfile(DynamicProfile profile)

Creates a new positioned profile that augments the functionality of the passed connected profile. Note that since the sql operation will be created at runtime, the passed profile must support dynamic operations.

Parameters:: profile - the dynamic connected profile to wrap

Methods

o getStatement

 public RTStatement getStatement(int ndx) throws SQLException

Returns an executable statement object representing the statement at index "ndx" in the profile, where "ndx" is 0 based. If the role of the entry at the given index is not POSITIONED, the statement is created using the prepareStatement method of the underlying dynamic profile. If the role is POSITIONED, the object returned is a statement that, when executed, dynamically prepares and executes a new statement with the text of the original statement, but the dynamic name of the cursor substituted in place of the '?'. All bound inputs are cached and transferred to the newly created statement before execution.

It is assumed that POSITIONED statements are always handled with PREPARED statements via the executeUpdate method. If the entry info describes otherwise, this method will raise an exception.

Parameters:: the - index of the statement to return, 0 based.
Throws: SQLException: if an error occurs preparing the statement.
Overrides:: getStatement in class ProfileWrapper
See Also:: getRole, POSITIONED, getStatementType, getExecuteType

Class sqlj.runtime.profile.ref.ProfileDataImpl

java.lang.Object
   |
   +----sqlj.runtime.profile.ProfileData
           |
           +----sqlj.runtime.profile.ref.ProfileDataImpl

public class ProfileDataImpl
extends ProfileData

The profile data impl class provides a concrete implementation of the profile data class. It manages a collection of profile entries, where each entry describes a static sql operation. A profile data object represents the sql resources of a particular connection context defined within an application module.

Constructor Index

o ProfileDataImpl(EntryInfo[], Profile, String): Creates a new profile data object.

Method Index

o getEntryInfo(int)
o getProfile()
o getSourceFile(): Returns the name of the source file from which this profile was generated, or null if not available.
o size()

Constructors

o ProfileDataImpl

 public ProfileDataImpl(EntryInfo entries[],
                        Profile profile,
                        String sourceFile)

Cr Antigua
Aruba
Barbados

more...

Hawaiian Islands

Big Island
Kauai
Lanai

more...

South Pacific Islands

Bora-Bora
Cook Islands
Fiji

more...

Micronesia Islands

Guam
Marshall Islands
Yap Island

more...

Home » Bora Bora

Bora Bora

Marked by the geographical coordinates of 16�26'40?S, 151�45'5?W, Bora Bora is an island in the Leeward group of the Society Islands of French Polynesia, which in turn is an overseas territory of France in the Pacific Ocean.

The island is located northwest of Papeete, the French Polynesian capital, at a distance of about 260 km from it and is surrounded by a lagoon and a fringing reef. An extinct volcano's debris occupies the centre of the island consisting of twin peaks of Mt. Pahia, and the highest point, Mount Otemanu, reaching 727 meters (2,385 ft.).

The island falls under the administration of the commune (municipality) of Bora-Bora, which is a part of the administrative subdivision of the Leeward Islands.

Total population of the island, as per 2002 census was about 7,250 people.

Travour is an online travelogue offering you every single piece of information about the fabulous international island vacations and holidays as a part of its endeavor to provide solutions for all your international travel needs. Click on the links given below to find everything you need to know about your next travel destination.

Bora Bora Accommodation

Bora Bora Cruises

Bora Bora Ferry

Honeymoon in Bora Bora

Tourist Attractions in Bora Bora

Things to Do in Bora Bora

Weather in Bora Bora

Bora Bora Vacation Packages

Log on to Travour.com for all the information you need to know about Bora Bora, Bora Bora Accommodation, Bora Bora Island Cruises, Bora Bora Island Ferry, Honeymoon in Bora Bora, Tourist Attractions in Bora Bora, Things to Do in Bora Bora, Weather in Bora Bora, Bora Bora Vacation Packages. For more information on Bora Bora and other Islands worldwide, keep clicking through Travour.

South Pacific Islands
» Bora-Bora Islands » Cook Islands » Fiji Islands » Marquesas Islands » New Caledonia Islands	» Papua New Guinea Islands » Samoa Islands » Solomon Islands » Tahiti Islands » Tierra del Fuego Islands

Site designed, developed and maintained by: Compare Infobase Ltd.