connectivity « Database « Java Database Q&A





1. How to create a database connectivity sqlserver2000 through J2ME    stackoverflow.com

I want some helps from the professional people who know a lot in the J2Me. I work on a mobile application that the user will be stored and retreve the data ...

2. Java Database Connectivity (JDBC) session handling?    stackoverflow.com

I am using MySql 5 Hi I am using/start learing JDBC. Well I got stuck here: After an user authenticated, I would like to start/generate the session for the user. How do ...

3. Weblogic 10.0: advantages with database connectivity and gotchas?    stackoverflow.com

What advantages (if any) does Weblogic 10.0 provide in terms of database connectivity (to any database) over open source or commercial alternatives? Are there any Weblogic specific gotchas with using ...

4. database connectivity    stackoverflow.com

is database connectivity possible in applet???

5. database connectivity?    stackoverflow.com

How to establish SQL 2005 database connectivity with Java application. Actually I don't know how to set path for JDBC. Any help would be great.

6. About the connectivity to IBM database using JDBC in Java    stackoverflow.com

I have a problem connecting to IBM (universal) database using JDBC. I wrote the code in Notepad using Java and I loaded drivers of IBM database i.e(driver name and connection URl). ...

7. JDBC connectivity with open office database    stackoverflow.com

I am using openoffice database for my project....Please help me know how to connect to open office database using JDBC.

8. CDC database connectivity    forums.netbeans.org

Hello.Can anyone please help me in determining how to connect to a database using CDC. I just need a sample code because I already have all the needed tools. Any help ...

9. Database connectivity problem    forums.netbeans.org

hi.. I 'am trying to connect to oracle database using netbeans 6.5.1 I have added new driver from oracle and added the oracle database settings but the connection takes too long ...





10. Database Connectivity Popup    forums.netbeans.org

Is there someway to disable the database connector popup? What happens is that when I'm in a variable that holds a database query, every time I type a dollar sign the ...

11. database connectivity in web service    forums.netbeans.org

12. Database connectivity problem    forums.netbeans.org

hi.. I 'am trying to connect to oracle database using netbeans 6.5.1 I have added new driver from oracle and added the oracle database settings but the connection takes too long without any response!!! I have tried to delete my .netbeans folder then the connection works but after a while it doesn't ? any help is appreciated thanks

13. DataBase Connectivity problem with IE    coderanch.com

Huy JavaGuys I have a problem which I want to discuss with u people . I am doing a win 2000 web server installed . I have made an application in which I have connected an oracle connected an oracle database with the help of jdbc-odbc driver . The application runs well in netscape but in IE aws soon I click ...

14. database connectivity    coderanch.com

Hi Bosun, thanks a lot for ur reply... I have tried the code but have the following error: "Data source name not found and no default driver specified" this is may be becauae my connection url. I want to connect to an access database using jsp. servlet engine is tomcat. what to do then? Thanks in advance, mac.

15. Database Connectivity    coderanch.com

I have written a java Program that inserts data into a database. The program is compiling and is giving no run time errors.However the problem I am facing is that when I go to the database and try to retrieve the data that I inserted through the java applet there is nothing. I am using SQLServer 2000 as my database. Here ...

16. Class for database connectivity !    coderanch.com

Hi , Can I have a java class , which will accept one oracle connection and return an array of connections which will be used to do database transactions . All these connections , should use the main connection for querying. Can someone provide the class ? Your help will be highly appreciated . Also , is there any way to ...





18. Database Connectivity    coderanch.com

Hi, I am trying to get the connecitvity to the database using Oracle Thin driver. Few weeks back I was able to get the connectivity and I was able to get data from the database from my test program. Yesterday when i just tired to retest my program I am getting SQLException: IOException : Network could not establish the connection. When ...

19. db connectivity with out dsn& portable db    coderanch.com

Hello ranchers, I wanna know is there any db which doesnt need any dsn for connection.. with java swings.. and i also need database which is portable .. i mean when i convert my application to exe and setup file i want my data base to be with in that setup and when ever i install it in different system it ...

20. JDBC-Navision database connectivity    coderanch.com

21. Database connectivity problems    coderanch.com

I am using Visualge Java 4.0, using ConnectionPool class to create a set of connections. Watz happening is when my TOMCAT server goes down or for for that matter of fact some unknown reason how do I make sure to re-establish connectivity. Also when transaction fails or database goes down and bad connection exists in the pool what do I do ...

22. Database Connectivity issues    coderanch.com

23. about database connectivity    coderanch.com

24. java database connectivity...    coderanch.com

26. database connectivity    coderanch.com

27. Problem with java database connectivity ?? java expert help needed?    coderanch.com

my program have database connectivity,and i have used applet,which on click of button show the content of file(.mdb) so as to grant permission to my applet i have used the following method content of file: accs.txt --------------------------------------... grant { permission java.lang.RuntimePermission "accessClassInPackage.sun.jdbc.odbc"; permission java.util.PropertyPermission "file.encoding", "read"; }; --------------------------------------... and used this command: appletviewer -J-Djava.security.policy=accs.txt searchtm.java its working fine and showing output ...

29. Database Connectivity    coderanch.com

30. database connectivity    coderanch.com

31. Database connectivity problem    coderanch.com

I am having a problem connecting my servlet to the database. I am able to connect to the database using SQL Worksheet so it is a problem with the servlet. I using Jrun3 as webserver. This is the error I get. Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093632)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) I have verified the username, pwd and instance and they are correct. Please help me. I ...

32. java database connectivity    coderanch.com

hi there is a JDBC forum here. you will probably get more answers there. show us what you have got so far, what your ideas are and there is surely someone who will try and help you out. to begin with: there should not be a big difference whether you work with MS SQL server, MySQL or DB2 with JDBC. After ...

33. Database connectivity    coderanch.com

34. database connectivity with remote pc?    coderanch.com

35. database connectivity    coderanch.com

36. Database connectivity problem    coderanch.com

I am new user to thif forum, Actually i want to use MySql in my JSP program but while connecting the database I am confused with this part "tring url="jdbc:mysql://localhost/books?user=&password="; here user name and password is required but i dont know how to create user name in MySql, So can anyone tell me how to create a new user in MySql ...

37. procedure to establish database connectivity    coderanch.com

Actually I am developing some application on Linux machine and written following code where I need to establish database connection using mysql driver. My task is to fethch data from database and put in textarea. ------------PROGRAM-------------------------------------------------------------------------------------------------- <%@ page import="java.sql.*" %> <%@ page language="java" %> Doctor's Work Bench

Welcome to Immunization Page



<% try ...

38. automatic database connectivity    coderanch.com

39. Getting a problem while using database connectivity    coderanch.com

Hi, i am a newbie to java... i have just joined an institute for that and the tutor is teaching java on netbeans but i liked eclipse more. So i am doing on that. A few days ago my tutor taught us database connectivity without using DSN so that it could be deployed easily which i have implemented in the code ...

40. Problem with database connectivity    coderanch.com

The following is my code to just enter values in Employees table. Please let me know how to find if i have oracle driver in my system and how to find the driver name. The problem with my code is, it displays org.apache.jasper.JasperException: An exception occurred processing JSP page /Testdb.jsp at line 14 error. <%@ page import="java.sql.*" %> Filling ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>41. <a href='http://www.coderanch.com/t/529268/JDBC/java/java-database-connectivity'>Doubt regarding java database connectivity.</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>42. <a href='http://www.coderanch.com/t/538785/JDBC/java/Database-connectivity-taking-too-much'>Database connectivity taking too much time</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Are you closing the connection in a finally block when done with it? Maybe there is a resource leak? Also, why are you checking if connection is null? If you are trying to reuse the connection try using an open source connection pooling library to do so more effectively. (And a datasource rather than driver manager) </p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>43. <a href='http://www.dbforums.com/java/1119498-database-connectivity-string.html'>Database connectivity string</a><span class='articleProductElementHost'>    dbforums.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>44. <a href='http://www.java-forums.org/eclipse/13538-database-connectivity.html'>database connectivity</a><span class='articleProductElementHost'>    java-forums.org</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>45. <a href='http://www.java-forums.org/jdbc/18032-database-connectivity.html'>Database connectivity</a><span class='articleProductElementHost'>    java-forums.org</span></h3><p class='articleProductElementParagraph'>Hi all, I have to run some queries in database which in a remote server. These are DB2 queries. We run this in putty using Vi editor. I want to create an user interface for all the database related activities like inserting, selecting from a table. To develop this, should I create a JSP page or it should be stand alone ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>46. <a href='http://www.java-forums.org/jdbc/22438-access-database-connectivity-outside-application.html'>access database connectivity from outside an application</a><span class='articleProductElementHost'>    java-forums.org</span></h3><p class='articleProductElementParagraph'>Hi, I am trying to look for a solution where i need to develop an application component which i need to pluggin to an exisitng application.But the thing is that application component needs to access database for fetching data.So the thing is how will that component access the database based on the type of database connectivity framework used in the existing ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>47. <a href='http://www.java-forums.org/jdbc/32007-database-connectivity.html'>database Connectivity</a><span class='articleProductElementHost'>    java-forums.org</span></h3><p class='articleProductElementParagraph'>hiii please help me out i am not able to connect to Data Base: i get an Exception like: ORA-12514:TNS:listner could not resolve SERVICE_NAME given in connect desriptor DataSourceName: Oracle Platform:Windows XP my code: public static void main(String[] args) { String driver="sun.jdbc.odbc.JdbcOdbcDriver"; String cs="jdbc:odbc:Oracle"; String user = "scott"; String pwd = "tiger"; String sqlstmt="INSERT INTO STUDENT VALUES(2,'Steve',50)"; Connection con = null; ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>48. <a href='http://www.java-forums.org/jdbc/38570-connectivity-database.html'>connectivity to database</a><span class='articleProductElementHost'>    java-forums.org</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>49. <a href='http://www.java-forums.org/new-java/45277-java-database-connectivity.html'>Java Database Connectivity</a><span class='articleProductElementHost'>    java-forums.org</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>50. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=1186236&tstart=44235'>Database connectivity</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3><p class='articleProductElementParagraph'>If your willing to use PostgreSQL there are allot of really good tutorials that walk your right through everything. For example: [http://www.faqs.org/docs/ppbook/book1.htm|http://www.faqs.org/docs/ppbook/book1.htm] and more specifically [http://www.faqs.org/docs/ppbook/x20856.htm] Though you probably could have found what you where looking for with either a forum search or a google query. Edited by: PCP on Jul 26, 2008 2:29 PM </p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>51. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=1204782&tstart=77025'>New to Java - problem with form with DB connectivity</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3><p class='articleProductElementParagraph'>Hi i'm new to java. And i have designed one HTML form which is having the following fields name,email, date(i used drop down box for this dd/mm/yy) and comments. Now i want to insert these data into Database. I'm using MS Access DB. I dont know how to connect and retrive data from DB. Any can help and guide me? Its ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>52. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=1212844&tstart=100455'>what have to do for database connectivity</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>53. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=1221526&tstart=123600'>Database Connectivity</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>54. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=1252522&tstart=18390'>database connectivity problem in netbeans</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>55. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=1259644&tstart=36915'>Database connectivity...</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3><p class='articleProductElementParagraph'>i have created a database in ms access, and now am trying to connect to it using the JDBC feature of java. Strange thing is, am only reading one record from the database and am unable to write to the database. the data ti be stored on the database will also have to be updated and reviewed via a web based ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>56. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=1261231&tstart=40410'>Urgently Required!! Please Help!! Connectivity with database of login page</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>57. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2045686&tstart=12420'>Database Connectivity Issue</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>58. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2069581&tstart=53310'>Database connectivity</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3><p class='articleProductElementParagraph'>There are also two things about your pseudo code that frighten me (and as an aside please don't post code that is sort of like your code but not really because it's not helpful in resolving problems and in fact tends to be highly misleading) 1) Why you create a statement that is never used. You don't have to create a ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>59. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2069637&tstart=53400'>Java Database Connectivity (JDBC)</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>60. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2071151&tstart=56040'>DB connectivity help</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3><p class='articleProductElementParagraph'>I tried to do that, but when i try to add the derby.jar file. it gives me an error . "Unable to add connection, cannot establish a connection to jdbc:derby://localhost:1527/sample using org.apache.derby.jdbc.EmbeddedDriver(Unable to find a suitable driver" Altough i can create a connection using Driver --> JAVA DB (Network), but still doesnt work in Runtime. Edited by: Aranel on Apr 9, ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>61. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2087956&tstart=83625'>Database Connectivity Issue</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>62. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2089211&tstart=85575'>database connectivity please help...</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3><p class='articleProductElementParagraph'>In future JDBC questions should be posted into the JDBC forum. You are looking to use a dynamic DSN which is not what you are using when you create a DSN through the ODBC data source widget. Search the JDBC forum for dynamic DSN. You will find many solutions to this question. </p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>63. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2095906&tstart=95760'>database connectivity</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3><p class='articleProductElementParagraph'>System.out.println("Table Creation Example!"); Connection con = null; String url = "jdbc:mysql://localhost:3306/"; String dbName = "test"; String driverName = "com.mysql.jdbc.Driver"; String userName = "ide"; String password = "NnEFchLb"; try{ Class.forName(driverName).newInstance(); con = DriverManager.getConnection(url+dbName, userName, password); try{ Statement st = con.createStatement(); String table = "CREATE TABLE Employee11(Emp_code integer, Emp_name varchar(10))"; st.executeUpdate(table); System.out.println("Table creation process successfully!"); } catch(SQLException s){ System.out.println("Table all ready exists!"); } ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>64. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2102253&tstart=106065'>Database connectivity</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>65. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2102469&tstart=106395'>database connectivity</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3><p class='articleProductElementParagraph'>Hi everyone, I have created the MS Access connectivity in Java, but I don't know how to display the "table names" and their "attribute names" in my program! I only need to display their names not their actual data. I'd be very grateful if anyone could help me or give me an idea of how to represent them. Thanks Eli </p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>66. <a href='https://forums.oracle.com/forums/thread.jspa?threadID=2104374&tstart=109485'>How to make one database connectivity and use it again and again</a><span class='articleProductElementHost'>    forums.oracle.com</span></h3><p class='articleProductElementParagraph'>You may create a class and implement this code and then use it in another class or servlet.By the way this code is written for mysql,you can modify it for another databases. public class DBConnection { public Connection con(){ Connection conTest=null ; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); conTest=DriverManager.getConnection("jdbc:mysql://localhost:3306/nameofthedatabase","username","password"); System.out.println("Connection established..."); } catch (Exception e) { System.out.println("Error..."); e.printStackTrace(); } return conTest; } public static ...</p></div></td></tr></table></div></div><footer><p class='pull-right'><a href='http://www.java2s.com/'>java2s.com</a>  | © Demo Source and Support. All rights reserved.</p></footer></div></body></html>