WebJan 26, 2013 · Although there are ways to configure it through deployment descriptor ( Stackoverflow link ), I would recommend using Web console. Log in, go to Resources and define Connection Pool and JDBC resource ( link for Glassfish 3.0.1 ). If you do it that way, you can test/ping your SQL connection and check whether all parameters are correct. WebNov 24, 2024 · Access the DataSource in Your Application From a Servlet Here's how you might access the data in a servlet: InitialContext ic = new InitialContext (); DataSource ds = (DataSource) ic.lookup ("java:comp/env/jdbc/WallyDB"); Connection c = ds.getConnection (); …
Datasource - Wikipedia
WebJun 18, 2024 · DataSource를 이용하려면 다음의 절차를 따릅니다. JNDI Server에서 lookup ( ) 메소드를 통해 DataSource 객체를 획득한다. DataSource 객체의 getConnection ( ) 메소드를 통해서 Connection Pool에서 Free 상태의 Connection 객체를 획득한다. Connection 객체를 통한 DBMS 작업을 수행한다. 모든 ... WebJan 3, 2016 · ic.bind ("jdbc/TestDS",testDS); The worker class is able to find the DataSource, but fails giving an error saying that "username failed to login to the server". If I pass the DataSource that I create in the JUnit method directly into the worker, it can connect and run queries. diamond sky holidays
jndi - Initialcontext in a standalone Java program - Stack …
WebJan 8, 2014 · // Setup the datasource DataSource ds = new OracleDataSource ();// There is other DataSource offered by Oracle , check the javadoc for more information ds.setDriverType ("thin"); ds.setServerName ("myServer"); ds.setPortNumber (1521); ds.setDatabaseName ("myDB"); ds.setUser ("SCOTT"); ds.setPassword ("TIGER"); // … WebThe DataSource interface is implemented by a driver vendor. There are three types of implementations: Basic implementation -- produces a standard Connection object. … WebJava code InitialContext ic = new InitialContext (); DataSource ds = (DataSource) ic.lookup ("java:comp/env/jdbc/charmDB"); Connection con = ds.getConnection (); Does anyone know what's wrong? Thanks! java oracle jdbc tomcat7 Share Improve this question Follow edited Feb 16, 2012 at 20:32 Olaf 6,213 1 18 37 asked Feb 16, 2012 at 18:16 … cisco syslink router