|
|
|
How to create datasource in RAD Websphere |
This example is for Oracle datasource but can be used for other datasources like MSSQL, DB2 or Sybase. Only change there
is no need for TNSORA file for datasources other than Oracle. Use JDBC connection URLs instead.
This Oracle datasource setup uses TNSNAMES.ORA file. To set up TNSNAMES.ORA file follow this link
1: Create Oracle JDBC provider
2: Create Oracle JDBC provider
3: Create Oracle Datasource.
JDBC driver connection URL OCI - jdbc:oracle:oci:@MYDB.COM
JDBC driver connection URL THIN - jdbc:oracle:thin:@MYDB.COM
Note: Set up MYDB.COM in TNSNAMES.ORA file. Another way is to use URL like jdbc:oracle:thin:@host:port:SID in case you do not have access
to TNSNAMES.ORA file.
4: Setup database userid under JAAS security
5: Select user id for datasource authentication in step3 screen
6: Test using test connection button
JDBC connection URLs are dependent on database. Following is the list of URLs for various databases
MySQL Connector/J JDBC jdbc:mysql://host_name:port/dbname
Oracle Thin JDBC Driver jdbc:oracle:thin:@host:port:SID
Postgresql JDBC Driver jdbc:postgresql://host:port/database
MS SQL Server JDBC
jdbc:microsoft:sqlserver://localhost:1433;
databaseName=dbname;selectMethod=cursor;
hsqldb JDBC jdbc:hsqldb:hsql://host:port/database
To create MS SQL datasource just create different JDBC provider
1: Create MS SQL Server JDBC provider
2: Create MS SQL Server JDBC provider
3: Create datasource.
|
|
|
| How to loop arraylist JAVA6 Syntax
|
| How to iterrate through ArrayList and display multiple rows using for loop JAVA6 syntax..
|
| Java JSP |
2010-Oct-12 |
| How to loop arraylist
|
| How to iterrate through ArrayList and display multiple rows using for loop, JSTL tags..
|
| Java JSP |
2010-Oct-12 |
| Consumer using JAX WS Dispatch API and DOM parser 1
|
| Access/Consume Webservice using Servlet, JAX-WS Dispatch API dynamic client and parsing SOAP response using DOM parser...
|
| Java Webservice |
2010-Sep-20 |
| Simple Java first CXF Webservice 4
|
| Building Simple Java first CXF webservice using CXFServlet, Spring, jaxws:endpoint, @WebService, @SOAPBinding, @WebResult
|
| Java Webservice |
2010-Sep-19 |
| Simple Java first CXF Webservice 3
|
| Building Simple Java first CXF webservice using CXFServlet, Spring, jaxws:endpoint, @WebService, @SOAPBinding, @WebResult
|
| Java Webservice |
2010-Sep-18 |
| Simple Java first CXF Webservice 1
|
| Building Simple Java first CXF webservice using CXFServlet, Spring, jaxws:endpoint, @WebService, @SOAPBinding, @WebResult
|
| Java Webservice |
2010-Sep-18 |
| Simple Java first CXF Webservice 2
|
| Building Simple Java first CXF webservice using CXFServlet, Spring, jaxws:endpoint, @WebService, @SOAPBinding, @WebResult
|
| Java Webservice |
2010-Sep-18 |
| Encoding special characters in userinput or on server
|
| Encoding can be done either in Javascript or JAVA encodeURIComponent, escape, java.net.URLEncoder..
|
| Java JSP |
2010-Aug-09 |
| Jstl fmt tag i18n formatdate formatcurrency
|
| fmt:setBundle, native2ascii.exe, fmt:message, fmt:setLocale, fmt:formatDate, fmt:formatNumber type=currency..
|
| Java JSP |
2010-Aug-05 |
| How to read and write a file
|
| How to read and write a file java.io.BufferedReader,java.io.FileReader, InputStreamReader ...
|
| Java J2SE |
2010-Aug-04 |
| jQuery validate form using ajax 2
|
| How to validate/submit form using ajax and jQuery input#, ($.ajax)..
|
| Javascript |
2010-Jul-23 |
| jQuery validate form using ajax 1
|
| How to validate/submit form using ajax and jQuery ($.ajax)..
|
| Javascript |
2010-Jul-23 |
| How to create datasource in RAD Websphere
|
| Create JDBC provider, datasource and JAAS security setup, JDBC connection URLs
|
| Servers Websphere |
2010-Jul-08 |
| Get Started 4
|
| Struts2 framework structure, how various components fit together
|
| Java Struts2 |
2010-Jul-07 |
| How to populate a form when JSP is called first time
|
| This is achieved throught setting bean in request, using frameworks like Struts2, Spring3..
|
| Java JSP |
2010-Jul-07 |
| Spring3 And Hibernate 4
|
| Spring3 and Hibernate 3.5.3 working together @Controller, @RequestMapping, @InitBinder, HibernateTransactionManager, LocalSessionFactoryBean, HibernateTemplate
|
| Java Spring |
2010-Jul-07 |
|
|
