Sorry, but your mail is quite confusing. You don't use an application server but want to use JNDI? I don't quite understand what you are doing. JNDI is a service that is offered by an application server like a EJB or JSP Container to your application. You don't use it in a standalone program. Even if your code runs within such a server, the way you use the service (the code to get the connection) is different on different servers but normally very well documented.
I could not find a thing called DbConnectionBroker on sourceforge. Do you mean DBConnectionBroker from www.javaexchange.com? If so, there is some sourcecode available on the site showing you how to use the DbConnectionBroker, all you have to do is copy-paste, change Driverclass, URL, user and password to use it (the driver class and the url are documented on http://www.sapdb.org/7.4/sap_db_jdbc.htm). After reading your mail several times I still don't understand your architecture neiter your problem. In the top of the mail you say you don't use an application server. Later on you talk about "create the datasource on the server". What server, if not the application server? You don't want to create a connection pool on the database server, do you??????? cheers, Detlef ----- Original Message ----- From: "Vanita Shroff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 27, 2003 7:37 PM Subject: Re:JDBC Connection pooling - again > Hello: > > Would anyone have a code snippet on how to create connection pooling using > SAPDB (without using application server) for > (1) a client-server Swing-based GUI application. The client makes a database > connection to the server and fetches the row and displays it. > (2) Using JNDI. > > I am using the DbConnectionBroker.java available from sourceforge.net and > can > (1) Create the datasource on the server with > INITIAL_CONTEXT_FACTORY, "com.sun.jndi.fscontext.RefFSContextFactory") > > (2) create the connections on the server. > > But do not understand whether I can access the server pooled connections > using JNDI from the client? If yes, how? If no, is RMI the only option of > creating the pooled connections and accessing it from client. > > Thanks, > Vanita Shroff _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
