I want to write a small application which uses a API (Java class, not JSP or servlet) for database connectivity. A JSP file acts as the client for the API. Since Iam new to weblogic 6.0, I don't know where to write the database info(like driver name, URL, username, pwd etc.,) and how to get those info from the Java API. Could anyone explain me about the process. Also, is there any website for the solution.
how's about xml (kind of config.xml) that will contains your properties, therfiore you can write an api that allows you to retrive these informations and pass them to your jsp.
you can use xerces api for the retrieval operations.
Config.xml is the place to do it
Setting up the JDBC Connection pool
DriverName="oracle.jdbc.driver.OracleDriver" InitialCapacity="1" LoginDelaySeconds="1" MaxCapacity="5" Name="pool/xxxx" Properties="user=USERNAME;password=PASSWORD;dll=ocijdbc8;server=172.16.xx.xx:1521:prodb;protocol=thin"
Setting up the JDBS Data Source.
When u have to get a access do a JNDO lookup on the datasource.
You will get some more information on weblogic edocs\