Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase specific packages

4 posts in General Discussion (old) Last posting was on 2000-02-23 20:58:23.0Z
Steve Fennessey Posted on 2000-02-23 20:35:18.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 23 Feb 2000 14:35:18 -0600
From: Steve Fennessey <fennessm@maritz.com>
X-Mailer: Mozilla 4.61 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Sybase specific packages
Content-Type: multipart/alternative; boundary="------------A1845989723A316D39D76D48"
Lines: 386
NNTP-Posting-Host: maritzfw01.maritz.com 207.239.112.18
Message-ID: <347_38B44486.6538B5D7@maritz.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28020
Article PK: 159922

Hello,
 I was wondering if the Sybase specific packages used in the following
EJB (created using the PowerJ wizards) is needed for the bean to run in Jaguar
and if so is there another way to code it without being tied to Sybase specific
packages that will work with Jaguar?

If I requested a connection from a bean
on Jaguar will the container give me a connection
from the cache or will it serve up a new connection?

package com.tcfengrupjag1.mypackage;
 

// custom imports for MyBeanBean
// add your custom import statements here
 

public class MyBeanBean extends java.lang.Object implements javax.ejb.SessionBean
{
    protected boolean create() throws java.lang.Exception
    {
        // Connection source: Jaguar cache
        transaction_1.setTraceToLog( true );
        transaction_1.setRegisterName( true );
        transaction_1.setName( "MyBeanBean.transaction_1" );
        transaction_1.setConnectionSource( new powersoft.powerj.db.JaguarConnectionSource( "GupDev1_jConnect", com.sybase.jaguar.jcm.JCMCache.JCM_WAIT, false ) );
        transaction_1.setUseInitialSettings( true );
        transaction_1.setLoginTimeout( 10 );
        transaction_1.setOwner( this );
        transaction_1.setRestoreInitialSettings( false );
        query_1.setTraceToLog( false );
        query_1.setName( "MyBeanBean.query_1" );
        query_1.setTransactionObject( transaction_1 );
        query_1.setOwner( this );
 
 

        query_1.setAutoEdit(true);
        query_1.setAllowUpdates(true);
        query_1.setUpdateConnectionMode( powersoft.powerj.db.Query.NO_AUTOCONNECT );
        query_1.setUpdateMode( powersoft.powerj.db.Query.IMMEDIATE_UPDATES );
        query_1.setUpdateType( powersoft.powerj.db.Query.KEYS_ONLY );
        query_1.setKeyUpdate( powersoft.powerj.db.Query.USE_UPDATE );
        query_1.setBindUpdates(false);
        query_1.setQueryTimeout( 0 );
        query_1.setSQL( "exec dbo.WebCheckinLastNameSearch @LASTNAME='CO%', @PROGRAMID=15968" );
        query_1.setStatementReturns( powersoft.powerj.db.Query.STATEMENT_RETURNS_MIXED );

        return true;
    }

    public MyBeanBean()
    {   // EJB constructors don't have a server context.
    }
    private void unhandledEvent( String listenerName, String methodName, java.lang.Object event )
    {

    }
    // method for interface javax.ejb.SessionBean
    public void setSessionContext( javax.ejb.SessionContext parm0 ) throws java.rmi.RemoteException
    {
        this._sessionContext = parm0;  // generated helper code
        // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbRemove() throws java.rmi.RemoteException
    {
  transaction_1.disconnect();
        // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbActivate() throws java.rmi.RemoteException
    {
        transaction_1.connect();
  // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbPassivate() throws java.rmi.RemoteException
    {
        transaction_1.disconnect();
  // To Do
    }
    /**
     * Session Context of this EJB.
     * Set in 'setSessionContext()' before any 'ejbCreate()' is executed.
     */
    private javax.ejb.SessionContext _sessionContext;
    /**
     * ejbCreate Method
     */

    public void ejbCreate() throws java.rmi.RemoteException, javax.ejb.CreateException
    {
        // The following was generated when this method was created.
        // You can freely modify this.
        try {
            create();   // This 'create()' is used for internal initialization.
   transaction_1.connect();
        }
        catch( java.lang.Exception __e) {
            System.err.println( __e.toString() + " " + __e.getMessage() );
        }
        // TODO: implement
    }
    /**
     * retrieve Method
     */

    public TabularResults.ResultSet retrieve() throws java.rmi.RemoteException
    {
        System.err.println( "Entering Retrieve Method" );
  java.sql.ResultSet resultSet;
  TabularResults.ResultSet tabularResultSet;
  // Execute query
  if( !query_1.open() ) {
   System.err.println(
    "Unable to execute retrieve" );
   return null;
  }
  // Get resultset object from query
  // and cast to java.sql.ResultSet object
  resultSet = (java.sql.ResultSet)
   (query_1.getResultSetObject());
  System.err.println( "resultSet = " + resultSet);
  // Convert java.sql.ResultSet object to a
  // TabularResults.ResultSet object.
  try{
   tabularResultSet =
    com.sybase.CORBA.jdbc11.IDL.getResultSet(
    resultSet );
   System.err.println( "tabularResultSet = " + tabularResultSet);
  }
  catch ( java.sql.SQLException se )
  {
   System.err.println(
    "Error converting to tabular result set" );
    return null;
  }
  // Return the result set.
  return tabularResultSet;
  // TODO: implement
    }
    /****************************************
     * data members
     ****************************************/

    protected powersoft.powerj.db.java_sql.Transaction  transaction_1 = new powersoft.powerj.db.java_sql.Transaction();
    protected powersoft.powerj.db.java_sql.Query  query_1 = new powersoft.powerj.db.java_sql.Query();

    // add your data members here
}

Thanks,

Steven M. Fennessey
 


Dave Wolf [Sybase] Posted on 2000-02-23 20:37:52.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: Sybase specific packages
Date: Wed, 23 Feb 2000 15:37:52 -0500
Lines: 450
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0195_01BF7E13.F24638F0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: dwolf-nt.sybase.com 157.133.41.127
Message-ID: <347_qlS4e5jf$GA.265@forums.sybase.com>
References: <347_38B44486.6538B5D7@maritz.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28019
Article PK: 159919

In the next release we will support JNDI lookups for connection caches which will mean you would need no Sybase specific code for an EJB.  However PowerJ does use Sybase classes.  If you want no Sybase classes, you should avoid any PowerJ objects.

Dave Wolf
Internet Applications Division
 
"Steve Fennessey" <fennessm@maritz.com> wrote in message news:38B44486.6538B5D7@maritz.com...
Hello,
 I was wondering if the Sybase specific packages used in the following
EJB (created using the PowerJ wizards) is needed for the bean to run in Jaguar
and if so is there another way to code it without being tied to Sybase specific
packages that will work with Jaguar?

If I requested a connection from a bean
on Jaguar will the container give me a connection
from the cache or will it serve up a new connection?

package com.tcfengrupjag1.mypackage;
 

// custom imports for MyBeanBean
// add your custom import statements here
 

public class MyBeanBean extends java.lang.Object implements javax.ejb.SessionBean
{
    protected boolean create() throws java.lang.Exception
    {
        // Connection source: Jaguar cache
        transaction_1.setTraceToLog( true );
        transaction_1.setRegisterName( true );
        transaction_1.setName( "MyBeanBean.transaction_1" );
        transaction_1.setConnectionSource( new powersoft.powerj.db.JaguarConnectionSource( "GupDev1_jConnect", com.sybase.jaguar.jcm.JCMCache.JCM_WAIT, false ) );
        transaction_1.setUseInitialSettings( true );
        transaction_1.setLoginTimeout( 10 );
        transaction_1.setOwner( this );
        transaction_1.setRestoreInitialSettings( false );
        query_1.setTraceToLog( false );
        query_1.setName( "MyBeanBean.query_1" );
        query_1.setTransactionObject( transaction_1 );
        query_1.setOwner( this );
 
 

        query_1.setAutoEdit(true);
        query_1.setAllowUpdates(true);
        query_1.setUpdateConnectionMode( powersoft.powerj.db.Query.NO_AUTOCONNECT );
        query_1.setUpdateMode( powersoft.powerj.db.Query.IMMEDIATE_UPDATES );
        query_1.setUpdateType( powersoft.powerj.db.Query.KEYS_ONLY );
        query_1.setKeyUpdate( powersoft.powerj.db.Query.USE_UPDATE );
        query_1.setBindUpdates(false);
        query_1.setQueryTimeout( 0 );
        query_1.setSQL( "exec dbo.WebCheckinLastNameSearch @LASTNAME='CO%', @PROGRAMID=15968" );
        query_1.setStatementReturns( powersoft.powerj.db.Query.STATEMENT_RETURNS_MIXED );

        return true;
    }

    public MyBeanBean()
    {   // EJB constructors don't have a server context.
    }
    private void unhandledEvent( String listenerName, String methodName, java.lang.Object event )
    {

    }
    // method for interface javax.ejb.SessionBean
    public void setSessionContext( javax.ejb.SessionContext parm0 ) throws java.rmi.RemoteException
    {
        this._sessionContext = parm0;  // generated helper code
        // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbRemove() throws java.rmi.RemoteException
    {
  transaction_1.disconnect();
        // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbActivate() throws java.rmi.RemoteException
    {
        transaction_1.connect();
  // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbPassivate() throws java.rmi.RemoteException
    {
        transaction_1.disconnect();
  // To Do
    }
    /**
     * Session Context of this EJB.
     * Set in 'setSessionContext()' before any 'ejbCreate()' is executed.
     */
    private javax.ejb.SessionContext _sessionContext;
    /**
     * ejbCreate Method
     */

    public void ejbCreate() throws java.rmi.RemoteException, javax.ejb.CreateException
    {
        // The following was generated when this method was created.
        // You can freely modify this.
        try {
            create();   // This 'create()' is used for internal initialization.
   transaction_1.connect();
        }
        catch( java.lang.Exception __e) {
            System.err.println( __e.toString() + " " + __e.getMessage() );
        }
        // TODO: implement
    }
    /**
     * retrieve Method
     */

    public TabularResults.ResultSet retrieve() throws java.rmi.RemoteException
    {
        System.err.println( "Entering Retrieve Method" );
  java.sql.ResultSet resultSet;
  TabularResults.ResultSet tabularResultSet;
  // Execute query
  if( !query_1.open() ) {
   System.err.println(
    "Unable to execute retrieve" );
   return null;
  }
  // Get resultset object from query
  // and cast to java.sql.ResultSet object
  resultSet = (java.sql.ResultSet)
   (query_1.getResultSetObject());
  System.err.println( "resultSet = " + resultSet);
  // Convert java.sql.ResultSet object to a
  // TabularResults.ResultSet object.
  try{
   tabularResultSet =
    com.sybase.CORBA.jdbc11.IDL.getResultSet(
    resultSet );
   System.err.println( "tabularResultSet = " + tabularResultSet);
  }
  catch ( java.sql.SQLException se )
  {
   System.err.println(
    "Error converting to tabular result set" );
    return null;
  }
  // Return the result set.
  return tabularResultSet;
  // TODO: implement
    }
    /****************************************
     * data members
     ****************************************/

    protected powersoft.powerj.db.java_sql.Transaction  transaction_1 = new powersoft.powerj.db.java_sql.Transaction();
    protected powersoft.powerj.db.java_sql.Query  query_1 = new powersoft.powerj.db.java_sql.Query();

    // add your data members here
}

Thanks,

Steven M. Fennessey
 


Steve Fennessey Posted on 2000-02-23 20:54:43.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 23 Feb 2000 14:54:43 -0600
From: Steve Fennessey <fennessm@maritz.com>
X-Mailer: Mozilla 4.61 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Sybase specific packages
Content-Type: multipart/alternative; boundary="------------9CA699DC9836FBC9B0D56BC1"
Lines: 448
NNTP-Posting-Host: maritzfw01.maritz.com 207.239.112.18
Message-ID: <347_38B44913.3685079C@maritz.com>
References: <347_38B44486.6538B5D7@maritz.com> <347_qlS4e5jf$GA.265@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28012
Article PK: 159915

Thanks Dave,
Do you have any idea when the next release is due out?

"Dave Wolf [Sybase]" wrote:

In the next release we will support JNDI lookups for connection caches which will mean you would need no Sybase specific code for an EJB.  However PowerJ does use Sybase classes.  If you want no Sybase classes, you should avoid any PowerJ objects.

Dave WolfInternet Applications Division 

"Steve Fennessey" <fennessm@maritz.com> wrote in message news:38B44486.6538B5D7@maritz.com...Hello,
 I was wondering if the Sybase specific packages used in the following
EJB (created using the PowerJ wizards) is needed for the bean to run in Jaguar
and if so is there another way to code it without being tied to Sybase specific
packages that will work with Jaguar?

If I requested a connection from a bean
on Jaguar will the container give me a connection
from the cache or will it serve up a new connection?

package com.tcfengrupjag1.mypackage;
 

// custom imports for MyBeanBean
// add your custom import statements here
 

public class MyBeanBean extends java.lang.Object implements javax.ejb.SessionBean
{
    protected boolean create() throws java.lang.Exception
    {
        // Connection source: Jaguar cache
        transaction_1.setTraceToLog( true );
        transaction_1.setRegisterName( true );
        transaction_1.setName( "MyBeanBean.transaction_1" );
        transaction_1.setConnectionSource( new powersoft.powerj.db.JaguarConnectionSource( "GupDev1_jConnect", com.sybase.jaguar.jcm.JCMCache.JCM_WAIT, false ) );
        transaction_1.setUseInitialSettings( true );
        transaction_1.setLoginTimeout( 10 );
        transaction_1.setOwner( this );
        transaction_1.setRestoreInitialSettings( false );
        query_1.setTraceToLog( false );
        query_1.setName( "MyBeanBean.query_1" );
        query_1.setTransactionObject( transaction_1 );
        query_1.setOwner( this );
 
 

        query_1.setAutoEdit(true);
        query_1.setAllowUpdates(true);
        query_1.setUpdateConnectionMode( powersoft.powerj.db.Query.NO_AUTOCONNECT );
        query_1.setUpdateMode( powersoft.powerj.db.Query.IMMEDIATE_UPDATES );
        query_1.setUpdateType( powersoft.powerj.db.Query.KEYS_ONLY );
        query_1.setKeyUpdate( powersoft.powerj.db.Query.USE_UPDATE );
        query_1.setBindUpdates(false);
        query_1.setQueryTimeout( 0 );
        query_1.setSQL( "exec dbo.WebCheckinLastNameSearch @LASTNAME='CO%', @PROGRAMID=15968" );
        query_1.setStatementReturns( powersoft.powerj.db.Query.STATEMENT_RETURNS_MIXED );

        return true;
    }

    public MyBeanBean()
    {   // EJB constructors don't have a server context.
    }
    private void unhandledEvent( String listenerName, String methodName, java.lang.Object event )
    {

    }
    // method for interface javax.ejb.SessionBean
    public void setSessionContext( javax.ejb.SessionContext parm0 ) throws java.rmi.RemoteException
    {
        this._sessionContext = parm0;  // generated helper code
        // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbRemove() throws java.rmi.RemoteException
    {
  transaction_1.disconnect();
        // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbActivate() throws java.rmi.RemoteException
    {
        transaction_1.connect();
  // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbPassivate() throws java.rmi.RemoteException
    {
        transaction_1.disconnect();
  // To Do
    }
    /**
     * Session Context of this EJB.
     * Set in 'setSessionContext()' before any 'ejbCreate()' is executed.
     */
    private javax.ejb.SessionContext _sessionContext;
    /**
     * ejbCreate Method
     */

    public void ejbCreate() throws java.rmi.RemoteException, javax.ejb.CreateException
    {
        // The following was generated when this method was created.
        // You can freely modify this.
        try {
            create();   // This 'create()' is used for internal initialization.
   transaction_1.connect();
        }
        catch( java.lang.Exception __e) {
            System.err.println( __e.toString() + " " + __e.getMessage() );
        }
        // TODO: implement
    }
    /**
     * retrieve Method
     */

    public TabularResults.ResultSet retrieve() throws java.rmi.RemoteException
    {
        System.err.println( "Entering Retrieve Method" );
  java.sql.ResultSet resultSet;
  TabularResults.ResultSet tabularResultSet;
  // Execute query
  if( !query_1.open() ) {
   System.err.println(
    "Unable to execute retrieve" );
   return null;
  }
  // Get resultset object from query
  // and cast to java.sql.ResultSet object
  resultSet = (java.sql.ResultSet)
   (query_1.getResultSetObject());
  System.err.println( "resultSet = " + resultSet);
  // Convert java.sql.ResultSet object to a
  // TabularResults.ResultSet object.
  try{
   tabularResultSet =
    com.sybase.CORBA.jdbc11.IDL.getResultSet(
    resultSet );
   System.err.println( "tabularResultSet = " + tabularResultSet);
  }
  catch ( java.sql.SQLException se )
  {
   System.err.println(
    "Error converting to tabular result set" );
    return null;
  }
  // Return the result set.
  return tabularResultSet;
  // TODO: implement
    }
    /****************************************
     * data members
     ****************************************/

    protected powersoft.powerj.db.java_sql.Transaction  transaction_1 = new powersoft.powerj.db.java_sql.Transaction();
    protected powersoft.powerj.db.java_sql.Query  query_1 = new powersoft.powerj.db.java_sql.Query();

    // add your data members here
}

Thanks,

Steven M. Fennessey
 


Dave Wolf [Sybase] Posted on 2000-02-23 20:58:23.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: Sybase specific packages
Date: Wed, 23 Feb 2000 15:58:23 -0500
Lines: 488
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_01C2_01BF7E16.CFFCBA50"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: dwolf-nt.sybase.com 157.133.41.127
Message-ID: <347_VgYJ8Ekf$GA.265@forums.sybase.com>
References: <347_38B44486.6538B5D7@maritz.com> <347_qlS4e5jf$GA.265@forums.sybase.com> <347_38B44913.3685079C@maritz.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28008
Article PK: 159910

Q2.

Dave Wolf
Internet Applications Division
 
"Steve Fennessey" <fennessm@maritz.com> wrote in message news:38B44913.3685079C@maritz.com...
Thanks Dave,
Do you have any idea when the next release is due out?

"Dave Wolf [Sybase]" wrote:

In the next release we will support JNDI lookups for connection caches which will mean you would need no Sybase specific code for an EJB.  However PowerJ does use Sybase classes.  If you want no Sybase classes, you should avoid any PowerJ objects.

Dave WolfInternet Applications Division 

"Steve Fennessey" <fennessm@maritz.com> wrote in message news:38B44486.6538B5D7@maritz.com...Hello,
 I was wondering if the Sybase specific packages used in the following
EJB (created using the PowerJ wizards) is needed for the bean to run in Jaguar
and if so is there another way to code it without being tied to Sybase specific
packages that will work with Jaguar?

If I requested a connection from a bean
on Jaguar will the container give me a connection
from the cache or will it serve up a new connection?

package com.tcfengrupjag1.mypackage;
 

// custom imports for MyBeanBean
// add your custom import statements here
 

public class MyBeanBean extends java.lang.Object implements javax.ejb.SessionBean
{
    protected boolean create() throws java.lang.Exception
    {
        // Connection source: Jaguar cache
        transaction_1.setTraceToLog( true );
        transaction_1.setRegisterName( true );
        transaction_1.setName( "MyBeanBean.transaction_1" );
        transaction_1.setConnectionSource( new powersoft.powerj.db.JaguarConnectionSource( "GupDev1_jConnect", com.sybase.jaguar.jcm.JCMCache.JCM_WAIT, false ) );
        transaction_1.setUseInitialSettings( true );
        transaction_1.setLoginTimeout( 10 );
        transaction_1.setOwner( this );
        transaction_1.setRestoreInitialSettings( false );
        query_1.setTraceToLog( false );
        query_1.setName( "MyBeanBean.query_1" );
        query_1.setTransactionObject( transaction_1 );
        query_1.setOwner( this );
 
 

        query_1.setAutoEdit(true);
        query_1.setAllowUpdates(true);
        query_1.setUpdateConnectionMode( powersoft.powerj.db.Query.NO_AUTOCONNECT );
        query_1.setUpdateMode( powersoft.powerj.db.Query.IMMEDIATE_UPDATES );
        query_1.setUpdateType( powersoft.powerj.db.Query.KEYS_ONLY );
        query_1.setKeyUpdate( powersoft.powerj.db.Query.USE_UPDATE );
        query_1.setBindUpdates(false);
        query_1.setQueryTimeout( 0 );
        query_1.setSQL( "exec dbo.WebCheckinLastNameSearch @LASTNAME='CO%', @PROGRAMID=15968" );
        query_1.setStatementReturns( powersoft.powerj.db.Query.STATEMENT_RETURNS_MIXED );

        return true;
    }

    public MyBeanBean()
    {   // EJB constructors don't have a server context.
    }
    private void unhandledEvent( String listenerName, String methodName, java.lang.Object event )
    {

    }
    // method for interface javax.ejb.SessionBean
    public void setSessionContext( javax.ejb.SessionContext parm0 ) throws java.rmi.RemoteException
    {
        this._sessionContext = parm0;  // generated helper code
        // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbRemove() throws java.rmi.RemoteException
    {
  transaction_1.disconnect();
        // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbActivate() throws java.rmi.RemoteException
    {
        transaction_1.connect();
  // To Do
    }
    // method for interface javax.ejb.SessionBean
    public void ejbPassivate() throws java.rmi.RemoteException
    {
        transaction_1.disconnect();
  // To Do
    }
    /**
     * Session Context of this EJB.
     * Set in 'setSessionContext()' before any 'ejbCreate()' is executed.
     */
    private javax.ejb.SessionContext _sessionContext;
    /**
     * ejbCreate Method
     */

    public void ejbCreate() throws java.rmi.RemoteException, javax.ejb.CreateException
    {
        // The following was generated when this method was created.
        // You can freely modify this.
        try {
            create();   // This 'create()' is used for internal initialization.
   transaction_1.connect();
        }
        catch( java.lang.Exception __e) {
            System.err.println( __e.toString() + " " + __e.getMessage() );
        }
        // TODO: implement
    }
    /**
     * retrieve Method
     */

    public TabularResults.ResultSet retrieve() throws java.rmi.RemoteException
    {
        System.err.println( "Entering Retrieve Method" );
  java.sql.ResultSet resultSet;
  TabularResults.ResultSet tabularResultSet;
  // Execute query
  if( !query_1.open() ) {
   System.err.println(
    "Unable to execute retrieve" );
   return null;
  }
  // Get resultset object from query
  // and cast to java.sql.ResultSet object
  resultSet = (java.sql.ResultSet)
   (query_1.getResultSetObject());
  System.err.println( "resultSet = " + resultSet);
  // Convert java.sql.ResultSet object to a
  // TabularResults.ResultSet object.
  try{
   tabularResultSet =
    com.sybase.CORBA.jdbc11.IDL.getResultSet(
    resultSet );
   System.err.println( "tabularResultSet = " + tabularResultSet);
  }
  catch ( java.sql.SQLException se )
  {
   System.err.println(
    "Error converting to tabular result set" );
    return null;
  }
  // Return the result set.
  return tabularResultSet;
  // TODO: implement
    }
    /****************************************
     * data members
     ****************************************/

    protected powersoft.powerj.db.java_sql.Transaction  transaction_1 = new powersoft.powerj.db.java_sql.Transaction();
    protected powersoft.powerj.db.java_sql.Query  query_1 = new powersoft.powerj.db.java_sql.Query();

    // add your data members here
}

Thanks,

Steven M. Fennessey