jsp 1 « Database « JSP-Servlet Q&A

1. How to escape-html in JSP before saving to database?    stackoverflow.com

I am learning JSP and Java at the moment and wrote a (very) simple guestbook to get started with JSP. But i want to ensure that noone can use CSS, so ...

2. JSP website pre-database configuration    stackoverflow.com

I'm working on a website in JSP (in GWT really, but on the server side, it's really just JSP), and I need to configure my database. I know HOW to code in ...

3. What should be the best design approch    stackoverflow.com

We have a simple table with employee data containing a 100k records. We want to display them using pagination on a simple JSP page with helper class/bean. On one page we'll display ...

4. questions on database updation    stackoverflow.com

I have a web application that is implemented using java,jsp,servlets . whenever i have updates in the database table, the arraylist in my DAO should be updated. is there any better ...

5. How I link in Netbeans Access 2003 db to Java or JSP    forums.netbeans.org

How I link in Netbeans Access 2003 db to Java or JSP ? Also to do a JAVA Database-driven desktop App standalone/self-run (file.exe etc files + Access 2003 database) What to ...

6. Help regarding Database Explorer in jsp    forums.netbeans.org

Hi, I am developing a project regarding database.now i am searching for a database explorer component developed in javascript,that can be included in my jsp project. Any body having prior experience ...

7. Problem when Retreiving from DataBase    coderanch.com

Hi all, I am trying to retreive information based on certain condition. It is working fine if i use SELECT query excluding the WHERE part,But when i include WHERE part i am getting the following error. I am also enclosing my code after the errors. One more strange thing is that it is working for condition Gpa>=gpa but if i use ...

8. Interacting with database at client side through JSP    coderanch.com

i made one JSP Page . In that i made two textfields. In one field user enter some data and according to that in another field data from oracle's table should come. e.g In one field Itemcode is entered by user and in another field it's description should come as soon as he leaves the itemcode field. Both itemcode and itemdescription ...

9. Database copy to local machine    coderanch.com

10. how to access database using jsp    coderanch.com

11. display a picture stored in a DB with HTML    coderanch.com

Wow, Bill, that is an absolutely excellent solution. I never would have thought of just serving a gif as a byte array. Is it a major performance issue though? I mean, how much slower would it be than just having images in a directory? Would the app server cache the response? Thanks Adam

12. How to retrive img from database through jsp    coderanch.com

if you insist on doing it with a jsp, try this: byte[] image = // get yuor image as bytes. response.setContentType("image/gif"); out = response.getOutputStream(); out.write(image); etc. watch out not to accidentally send anything else out (like whitespace) into the response or it will fail. whitespace will by default go back as text/html and you cant change the content type after the ...

13. JSP to Access 2000 database    coderanch.com

Lets see if i can help a little. First i will point you to the resources that you will need to accomplish your endeavor. MVC == the following; M = model or the business logic (database access, typically Servlet) V = view represents what the client sees (JSP) C = Controller is a servlet that forwards requests to the View and ...

14. JSP and Databases    coderanch.com

15. jsp hosting with database problem please help    coderanch.com

So you are currently using the jdbc-odbc bridge right? You will have better performance if you use a driver that is specific for your db. Then you don't have to worry about creating DSNs (ODBC data sources) on the client/server. Once you have your driver, you have to register it just like you do with the jdbc-odbc bridge driver. For more ...

17. where does the database fit in    coderanch.com

Hi I hope this is the right forum for this post. When building applications which involve storing and updating information what is the best approach? How do you handle the updating and synchronization for objects whose fields are populated from the database? Do you update the database everytime you update a class member? WHat if the data is manipulated outside of ...

19. Database lookup at a particular time?    coderanch.com

20. jsp and databases    coderanch.com

22. Database Retriving In JSP    coderanch.com

23. database    coderanch.com

24. accesing a database    coderanch.com

25. Values not retrieved from the DB    coderanch.com

27. polling database from jsp    coderanch.com

Hi dudes, I am working on an application which list out entries from a database(MSSQL). These entries get updated by another application every second and i need to display the very latest info on my jsp page. This means that i need to update part of jsp page(I dont want to refresh the whole page as it increases the network traffic) ...

28. generate JSP from database    coderanch.com

29. Database and jsp    coderanch.com

31. How to go with database    coderanch.com

hi ppl, I have been told to use jndi for database related things. I know how to use jdbc driver in a single stand alone program. But how to go with tomcat server and database and my program. What i think is : 1. Create a table in ms-access database as usual. 2. open setting, admin tools, go to odbc sources ...

32. OS and database for jsp    coderanch.com

You can use any available combination. People use windows because it is the most popular OS, especially asia, middle east, asia pacific. Industries go for reliablity, security, performance, etc therefore they prefer linux/unix over windows. Linux is mostly used in production environment. But it doesn't mean that we cant develop on linux. We have a quite nice java development environment on ...

33. Direct Database Access!    coderanch.com

I am sorry if I post this thread in the wrong forum, but i really dont know where to put it ! How can we build a direct link to the content of the database. For example,when i click a link on a HTML page, let's say a employee name, it goes to a page which displays the particular information stored ...

35. JSP and Database    coderanch.com

Hi, I am a newbie in doing jsp in doing a shopping website. Right now, I have an image which has a link to another page (e.g. search.jpg). What I want to implement is that when i click on the image(which is a category), it will link to search.jsp and display all the products in that category from my database. May ...

36. cannot display database    coderanch.com

37. JSP database issue    coderanch.com

38. Database replecation from Jsp    coderanch.com

hi all i am new member in this gerate site. can any body help me in this problem. i have project in jsp (dynamic creation for questions)which generate a web site and make rigisteration for user, which accepet his name, subject for the questions, number of questions that he want to cereate them and number of those questions. the problem when ...

39. How to make the values taken from the database as a link    coderanch.com

HI, Im doing a project in jsp.In that while downloading images, the image link will stored in the database and also frm one file im displaying all the links stored in the database.Now i want to make all those values as links i.e.,if anyone clicks on that link it has go to the respective page. I tried with the following code: ...

40. jsp and database    coderanch.com

42. recursion of database operation in jsp    coderanch.com

43. jsp and database    coderanch.com

44. Database Problem    coderanch.com

Hello Everybody !! I use NetBeansIDE4.1 for developing jsp and servlet applications. It comes with bundled in Tomcat-5.5.7. I wrote a simple code for database connectivity using MS-ACCESS and system-DSN Here is the piece of code: Connection con; Statement stat; String NewLanguage=new String("SPANISH"); String sql=new String("insert into languages values (1,'" + NewLanguage.toLowerCase() + "',1,null,null)"); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbcdbc:dsn_lang"); stat=con.createStatement(); stat.executeUpdate(sql); stat.close(); con.commit(); ...

45. how can i acces database using jsp?    coderanch.com

46. import db.*, import JSPCal.*;    coderanch.com

47. database access from JSP    coderanch.com

48. flow from JSP to DB    coderanch.com

49. Problem accessing Database from JSP    coderanch.com

It is inappropriate to do DB access from a JSP. You should be using the very non-UI classes that you've already set up in a reusable manner. But yes, once you find out what the correct drivers are, they will go in WEB-INF/lib. [ March 17, 2007: Message edited by: Bear Bibeault ]

50. jsp database    coderanch.com

Hi, I have this simple program to access a database in Microsoft SQL Server 2000, the database that i am trying to access is Northwind. But, when i execute the .jsp i get this error: java.sql.SQLException: [Microsoft] database not found and no driver was specified. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source) at ...

51. Database grid and detailed view    coderanch.com

52. how to display bar chart based on the database values using jsp    coderanch.com

I am working in the site statistics module. How to display bar chart, line chart based on the database values using jsp. If i click the bar chart icon i want to display the bar chart, If i click the line chart icon i want to display the line chart. This bar chart and line chart are the part of the ...

53. database with jsp    coderanch.com

here's some sample code from my application <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn= DriverManager.getConnection("jdbcdbc:meenal"); statement=conn.createStatement(); rs= rs = statement.executeQuery("SELECT * FROM emp"); %>

<% while (rs.next()) { %>
Name Date Of Birth Gender Qualification Location Preference

54. Accessing database through JSP    coderanch.com

55. db to jsp    coderanch.com

56. Problem creating listbox from DB    coderanch.com

57. database interaction in jsps    coderanch.com

58. Databases and jsp    coderanch.com

Please carefully distinguish between Java code and JavaScript code. Java code executes in the server, as the HTML page is being generated. At this stage, the page has not even arrived at the browser yet. Your JavaScript is nothing but passive text in a buffer. JavaScript code executes in the browser, as the HTML page is being displayed. The Java servlet ...

59. JSP to Database linking    coderanch.com

Hi, Thanks for the reply. I had already checked out jive, it is very impressive. But it's tough to wade through all the source code and identifying what I'm looking for. My question is a lot simpler: How would I put a link on a jsp page that retrieves the contents from a record in a database?

60. Question about database access and JSP    coderanch.com

61. JSP and DB    coderanch.com

62. problem in database    coderanch.com

63. problem with JSP and database    coderanch.com

Hi All, I am doing project on intranet mailing system with JSP and servlet and Using MS-Acess as backend. once user is validated he is shown welcome screen and then he goes to inbox, read msg, and reply to it. in reply module proper values are inserted in DataBase. all goes well and reply is sent back to user that his ...

64. Database reconnecxion    coderanch.com

65. How to change the database in Java EE    coderanch.com

Hello, I have read the links and have learned more, but still not sure how to create an EntityManagerFactory from Java EE. I am using Glassfish, Toplink, and SQL server. The persistence.xml file contains the following: jdbc/eeee3 How can I dynamically set a new value for ...

66. can't access database    coderanch.com

i have developed jsp application using netbean with build-in glassfish v2. from other topic i have learn to deploy it without keeping netbeans running by creating war file and deploy it in java base web server. i have try it, it work but i can't connect to my database. i'm using Sun Java System Application Server to deploy it, and mySQL ...

68. How to migrate the database    coderanch.com

Suppose that I have an enterprise application hosted on a server (say evolutionhost). There, all the data records of my application, are being persisted to their (evolutionhost) own database server. Lately, I need to migrate my application to another new hosting provider (say webappcabaret). I can easily migrate my application by uploading it as an EAR file. But how can I ...

70. JSP and database    coderanch.com

Can any one help me out... I am working on a project where i have to fetch all the data from the database (for exp: employee_name) and display it on the jsp in such a way that there is a radio button in front of each employee_name also how can i send the data of one single radio button again to ...

71. JSP to database - best practice    coderanch.com

73. Refresher Database Value    coderanch.com

Actually i designed a page in jsp that show all the user that are registered but not activated by admin. This page show name of inactivated user & activate button with each user name . When i click on activate button a java script function call that execute another jsp page, in which write code for activate that user. when status ...

74. Populating Child Window(JSP) with values from the database    coderanch.com

Hello, The application which I am developing has a parent jsp with buttons on every row.These buttons,on being clicked,open up a child window.This child window is supposed to have rows retrieved from the database.One of these rows is to be selected and the relevant value is to be sent back to the parent window.Now how do I get the child window(jsp) ...

76. JSP-database problem    coderanch.com

type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: oracle/jdbc/driver/OracleDriver (wrong name: oracle/jdbc/OracleDriver) org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) root cause javax.servlet.ServletException: oracle/jdbc/driver/OracleDriver (wrong name: oracle/jdbc/OracleDriver) org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774) org.apache.jsp.recordings_jsp._jspService(recordings_jsp.java:145) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) root cause java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver (wrong name: oracle/jdbc/OracleDriver) java.lang.ClassLoader.defineClass1(Native Method) java.lang.ClassLoader.defineClassCond(Unknown Source) java.lang.ClassLoader.defineClass(Unknown Source) java.security.SecureClassLoader.defineClass(Unknown Source) ...

78. noob question about database settings    coderanch.com

Hi Folks I am trying to migrate and old .jsp site to a new server. I'm wondering if there is a usual of defaul place where databse user and passwords are kept when setting up a site in jsp. For example, one of the apps I am porting over has a .properties file, this has the user and pass for a ...

79. Checking for new messages in database    coderanch.com

82. Synchronizing Two Databases    coderanch.com

i have an application which maintains contacts. now contact management can be done through web which has a different database or can be done through a handheld device which again has a different database. now though semantically both DBs are same but they are different DB servers (and we cannot have one DB for both the interfaces for some reason). now ...

83. database languages    coderanch.com

84. treeview from database    coderanch.com

85. Database initialization and patches    coderanch.com

86. What is best way to display a results set from a database?    coderanch.com

What would be the best way to achieve a JSP which displays say 10-15 product listings from a database? For example if I wanted to pull (this is basic, reality would be more data, but it gets the point across) all of the "product names" from the database, then display them in a table on the site, one row after another. ...

87. Database output in JSP    coderanch.com

Hi I'm studying JSP on my own and I'm getting into lots of trouble! Here is what my small application does. index.jsp -> servlet -> result.jsp 1. I get values (say, no: of products) from index.jsp page. 2. The servlet creates a connection with a DB table to update the no: of products. Database is updated. 3. In result.jsp I would ...

88. database connectivitiy in jsp    go4expert.com

89. DataBase updation thru JSP    go4expert.com

90. database-html/jsp    java-forums.org

91. Please help : handle database to jsp    java-forums.org

94. JSP - ImageLoader from Database (BalusC code)    forums.oracle.com

Come on gtRpr, You are very lazy, the problem is not in your SQLImage I can guarantee that the problem lies inside the ImageServlet Take a look at its preceding code There you will find your problem gtRpr Wake up, your are great at finding solutions to your own problems, First look at BalusC's code and try find something you forgot. ...

95. JSP&Database connecion    forums.oracle.com

96. How to retrive country rates from database in JSP?    forums.oracle.com

Hi, I am giving more explanation to the above topic Country rates being stored in database and I want to retrive that rates from database when I am selecting particular country from country drop down. And results should be displayed on the same JSP page. How to do that in java. Thanks, Sunil

98. Displaying into JSP from database call    forums.oracle.com

99. database & JSP    forums.oracle.com

100. Converting from db to real in jsp    forums.oracle.com