1. Database connection problem coderanch.comHello, guys i need help. I work on a website project and i decided to make the the database connection with web.xml and servlet database connectivity. I defined all database variables in web.xml and on load of servlet i open connection in servlets init method through JavaBean. This is the structure of the website project. website ---------html ---------jsp ---------img ---------WEB-INF -------------------web.xml ... |
2. connection can not be resolved coderanch.comi am trying to connect a jsp page to a postgress database i have created a jdbcconnects.java file and compiled it with jsp_api.jar from my apache..../lib directory i have placed the class file in root/WEB-INF/classes folder the code of my class file is import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Jdbcconnections { public Connection connect()throws Exception { Connection con = ... |
3. Question regarding use of StringBuilder in DataBase Connection coderanch.compackage kvdal; import java.sql.Connection; import java.sql.SQLException; import java.sql.Driver; import java.sql.DriverManager; public class Kvconnection { public Connection connectionopen() { Connection dbConn = null; try { System.out.println("db Connected....7\n"); String filename = "d:\\Ashish\\RT.mdb "; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; System.out.println("db Connected....8\n"); database = (new StringBuilder(String.valueOf(database))).append(filename.trim()).append(";DriverID=22;READONLY=true}").toString(); System.out.println("db Connected....9\n"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("db Connected....10\n"); dbConn = DriverManager.getConnection(database, "", ""); System.out.println("db Connected....11\n"); /* Driver d =(Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); String ... |
4. JDBC Connection to Unidata coderanch.comHi, I am trying to connect to Unidata using jdbc and after resolving the classpath issues, since a jar file "unijdbc.jar" & a zip "asjava.zip" were to be included for various jdbc classes to be available, am now stuck at a error code which suggest that i have an RPC issue. In short the error message says : "Middleware connect fail:UniRPCConnection ... |
5. data connection problem coderanch.comBefore you say it, I've searched all over for a solution to my problem and I cannot get it resolved. Platform: Windows 7 64 bit Problem: Cannot connect to sqlserver database Knowledge Level: Novice Background of problem: I'm writing an application that I want to connected to a sql server data source. I've created a DSN called "pawnDataSource" that uses Windows ... |
6. connection problem with webhosting database. coderanch.comI assume you mean that you are trying to make a remote connection. On my web host's control panel, there is an item called "Remote MySQL". To make remote connections to my database, it is necessary to use this utility to add permission to an IP address (or range of addresses). Check the FAQ and Knowledgebase for your host. That's where ... |
7. Is this possible to create more than one connection in a java application?define loss and benefit. coderanch.comHi , I have a question that Is it possible to create more than one database connection in one application if it is then what are loss and benefit of it? And in my opinion it is possible but there is no benefit instead it will allocate more memory.I want to exact answer. Thanks! |
8. Allocating The DB connection in Web App coderanch.comIm really confused about how to allocate DB connection to each user. One approach could be Giving it a DB connection in every servlet which is what i made for very simple logic testing purpose. a Sample code of it import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; public class Quiz extends HttpServlet { Connection con; Statement ps; ResultSet rs; @Override ... |
9. connection not possible, even after using the connector coderanch.com |
10. Mqsql DB connection Issue coderanch.comWhile accessing the Mqsql DB am facing this issue. Please help me to resolve this issue. I tried changing the my sql driver from 5.1 to 5.08. But same error. org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnection Factory (Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.ConnectException MESSAGE: Connection timed out: connect STACKTRACE: java.net.ConnectException: Connection timed out: connect at java.net.PlainSocketImpl.socketConnect(Native ... |
11. JAR file of JDBC connection coderanch.comI have created an J2SE application which retrieves data's from mysql via JDBC driver. then I export all of the table data's to DAT file. This project works very well in my development PC which has jre and jdk installed. I need to deploy this application to client pc. I have created a jar file with mysql-connector-java-bin.jar added. When i run ... |
12. Problem while getting the Connection coderanch.comDataSource Got :ClusterableRemoteRef(-634073511450917637S:127.0.0.1:[7001,7001,-1,-1,-1,-1,-1]:regulatory_domain:AdminServer [-634073511450917637S:127.0.0.1:[7001,7001,-1,-1,-1,-1,-1]:regulatory_domain:AdminServer/287])/287 |
13. Connection Problem coderanch.comHello, I'm trying to display a table from sql server with local connection(everything is in my computer). I'm using netbeans, apache tomcat as a service, sql server express 2008(using windows authentication) and I have the following code: <%@ page language="java" import="java.sql.*"%> |
14. JDBC Remote DB Connection coderanch.comHey All, Here is my situation. I am trying to use a JTDS Connector to connect my webapp on Server A to backup database on Server B using windows authentication. These Servers are both in the same domain and the user in Server A has been assigned to have administrative privliges to server B. If I manually set the JTDS Server ... |
15. How long time can I keep a database connection open? coderanch.comHello. I am wondering what is best practice when handling database connection in servlet. I am using a connection pool. Do we open one single database connection and use this single connection for all queries (see Case 1) or do we open and close a database connection for each query (Case 2)? Please see code example below: CASE 1 - Keep ... |
16. connection coderanch.comif you don't know how to create Database to access with jdbc.odbc then this is how we can create it in windows PC ODBC Settings ----------------------------------------------------------------------- step 1 : click control panel step 2 : click Administrative Tools step 3 : click Data Sources (ODBC) icon step 4 : click system DSN tab step 5 : click ADD Button , Select ... |
17. Test failed: The connection to the host localhost, named instance moeincom has failed coderanch.comsorry for the late reply ali but you should be able to find it here Start->Program Files-> Microsoft sql server 2005->Configuration Tools->sql server configuration manager. In configuration manager console, on the left hand panel, expand the sql server 2005 Network Configuration. Click on the Protocols for Named-Instance-Name. On the right hand panel we need to right click and go to properties ... |
18. Connection refused coderanch.com |
19. jdbc connection problem coderanch.com |
21. JDBC connection issue with RAC database coderanch.com |
22. Reducing the amounts of connections coderanch.comHi guys. I have this code that connects to a DB and either edits the data or retrieves data (the code works as intended). This code is used by aswing program. So my question is how can change the way it connects so that it only needs to connect once to the database (while my swing program is running) instead of ... |
23. Setting up a JDBC connection coderanch.comHello toda I received these instructions: See attached zip file. Expand, connect to VPN and test as follows: >javac -cp .;lib\ojdbc14 ATTTestDB.java >java -cp .;lib\ojdbc14 ATTTestDB I did execute: javac -cp .;lib\ojdbc14 ATTTestDB.java java -cp .;lib\ojdbc14 ATTTestDB and received these errors: Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Michele smith>java -cp .;lib\ojdbc14 ATTTestDB Exception in thread ... |
24. No of allowed connections coderanch.comRecently I hosted my web application in a tomcat server. They are providing Cpanel and mysql db with 25 max user connections. Once i deployed the application and once the cron jobs are running it gave me following exception Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User xxx_root already has more than 'max_user_connections' active connections After that i used both Apche DBCP connection pool and ... |
25. JDBC Connection Interface coderanch.com |
26. JDBC Connection in Java coderanch.com |
27. new to db connection help needed coderanch.com |
28. TCP/IP connection to the host has failed coderanch.comHi, I have read other threads but my problem is not solved yet. I want to understand whether this issue is because of TCP/IP settings or can also occur if too many DB calls are made? If it is because of settings then my application should not run at all. But I see this error only when data volume being processed ... |
29. TCP/IP Connection lost coderanch.com |
30. Best way to track down connection leak coderanch.comWe recently upgraded our connection pool manager to the version that is provided in Tomcat 6 (DBCP). However, we are plagued with an issue where the connection pool reaches its maxActive limit and then fails to release those connections back to the pool. (We do have removeAbandoned="true" and the removeAbandonedTimeout="30"). Eventually all of our web pages stall, and we have to ... |
31. What Does DataSorce Manage Connections coderanch.comHi All, How exactly does a datasorce manage connections. Suppose i have configured a datasource with max connections 50. What will happen if 51 users login concurrently? How do I handle a concurrent login of 100 users ? Do i have to set the maximum connections as 100? Will it be a performance hit. Please help me understand this? Thanks |
32. Unable to get a physical connection from the database coderanch.com |
33. Connection polling issue with MySQLNonTransientConnectionException and Java webapp? coderanch.comHello I have a Java, JSP and MySQL application running under Apache Tomcat 6.0.26 which I've been testing with JMeter. What I find is that for a simple test having 10 users logging in and displaying a JSP which is populated from several database reads is fine. But when I increase the number of users in JMeter to 20+, logging in ... |
34. Simple DB Connection Question dbforums.comGreetings everyone, I'm not an expert on DataBase programming/design/engineering/etc, so I've got a simple question regarding the correct way one should connect to a DataBase. I'm posting on the Java Sub-Forum because I'm using Java. I'm working on a Client UI that must check every two seconds for updates on a DB. The Client and the DB are located in different ... |
35. Help: JDBC Connection dbforums.comI had a jsp that connects to a DB2 using jdbc connection. It is something like: > <%@ page isThreadSafe="true" %> > ... > > Connection conn = null; > Statement stmt = null; > ResultSet rs = null; > ... > > try > { > synchronized(this) > { > conn = DriverManager.getConnection(URL, id, pwd); > } > > stmt ... |
36. Problem with database connection dbforums.com |
37. JDBC Connection (using JDeveloper) dbforums.comI'm working on a webapplication using Oracle9i and JAVA (J2EE). I use the Oracle IDE JDeveloper to write my code. When I try to make a connection with JDeveloper, this connection is successfull. When I try to connect in a class with the same specifications, there goes something wrong. My JDeveloper connection settings: connection name : TestDb connection type : Oracle ... |
38. jdbc connection problem java-forums.orgHi, I'm Using struts 2 framework. with JDK 1.6 and Oracle 9.0.1.4 DB. also i have spring + Hibernate so my connection configured in applicationContext.xml |
39. I need help with java-oracle connection java-forums.orgCan somebody help me with this? I want to establish connection to Oracle from java main in separate class EstablishOraDBConnection. And after connection I want to work in main with other method to do something in the database. How can I make that class and what is supposed to be in that class? Thanks, BTW, I am a new in JAVA ... |
40. JDBC Connection... java-forums.org |
41. connection to database java-forums.orghave you tryed adding the path where your datebase is to the environment variables P.S. i'm not sure how to do it i'm now on java but on my programes i use the acces date base and is quite easy and i'm useing Windows operation sistem so if you are useing something else read the instructions for your operation sistem |
42. Connection java-forums.org |
43. JDBC connection java-forums.org |
44. question about connection efficiency in database java-forums.orgHi I am developing an application that sends data to the database (MySQL) of a website each 5 minutes (i.e. I am updating the record each 5 minutes). the sent data has this form "10101010001000100010101010109922342123456" my question is: should I keep the connection open and update the data each five minutes and never close the connection; or should I close the ... |
45. Permanent reusable connection to DB java-forums.orgPHP Code: public class ConnectDB { private static String databaseurl = "jdbc:oracle:thin:@10.1.1.7:1521:orcl"; private static String user = "oracle"; private static String password = "1234"; private static String driverName = "oracle.jdbc.OracleDriver"; public Connection conn; public ResultSet rs; public Statement statement; public PreparedStatement ps; public final Connection init() throws SQLException { try { Class.forName(driverName); conn = (Connection) DriverManager.getConnection(databaseurl, user, password); System.out.println(conn + " ... |
46. How to create jdbc connections? java-forums.orgSorry for that poor reply I just made I was rushing coz i was having a limited time. I was refering to this code, on where will i put this one in my prgram to connect to my sql and java database. private static Connection getConnection() { Connection con = null; try { Class.forName(com.mysql.jdbc.Driver); String url = jdbc:mysql://localhost/Movies; String user = ... |
47. JDBC Connection object creation confusion java-forums.orgHi, I am confused with the URL we provide to create JDBC connection. Lets say there are 2 databases available i.e., DB1 (IP1), DB2 (IP2). Oracle Listener is configured to point to DB2 (lets say the SID is MYDB). [SID --> DB2] Now while creating connetion if I mention IP1 and MYDB as SID, I can still connect successfully but further ... |
48. Keep database connection alive java-forums.org |
49. no connection java-forums.org...no connection nothing to do,here's the whole code...it's about a small DB table to menage phone numbers...i've used "PreparedStatement" to implement the three op of the application... package accessidb; import java.lang.Exception; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class LoadDriver // this is an external class just to load the driver { public LoadDriver() { } public void load() { try ... |
50. Connection problem java-forums.org |
51. Connection to the datebase can't be established java-forums.org |
52. Newbie connection blues java-forums.orgCan someone point me to a simple complete working example of modern MYSQL / Java code ? Ive tried (no kidding) 10 tutorials/demos or so and Im ashamed to say Im almost ready to give up. Wasted 2 full days with this ! I have the Classpath to the MYSQL jar file OK. My code compiles OK MYSQL 5.1 on Win ... |
53. Ms Acces java connection problem java-forums.orghey guys im trying to learns database using java her is the simple code Java Code: import java.awt.BorderLayout; import java.awt.Dimension; import java.awt.GridBagConstraints; import java.awt.GridBagLayout; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.List; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; public class ClassGUIApplication extends JFrame{ private JPanel centerPnl = new JPanel(); private JPanel northPnl = ... |
54. Connection to data base java-forums.org |
55. connection problem java-forums.orgHi Friends this is my code to connect to database oracle10g but i am gettin error when java command the error is invalid oracle url specified can anybody solve this problem import java.sql.*; import java.lang.*; import java.io.*; public class condb { public static void main (String args[]) throws SQLException { try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin@//localhost:1521:XE","SYSTEM","tiger"); System.out.println("connected"); } catch(Exception e) { System.out.println(e); } ... |
56. Connections to data bases java-forums.orgWhen we work with connections to data bases and do operations like select, we must generate the following objects: A Connection, a Statement and a ResultSet. When finalizing the query one must close the connection and the other objects. My question is the following one: the ResultSet object, it is created through Statement object, and this through Connection object, is it ... |
57. Connection to Database using netbeans java-forums.org |
58. cant create database connection java-forums.orgi got this error whn i click on database. java.lang.IllegalArgumentException: Original Node from map {position=101, iconResource=org/netbeans/modules/db/resources/database.gif, name=Databases, original=null, displayName=Databases, instanceCreate=org.openide.nodes.LazyNode[name=null][Name=Databases, displayName=Databases]} is null at org.openide.nodes.LazyNode.switchToOriginal(LazyNo de.java:85) at org.openide.nodes.LazyNode.getActions(LazyNode.jav a:74) at org.openide.nodes.NodeOp.findActions(NodeOp.java:1 61) at org.openide.explorer.view.TreeView.createPopup(Tre eView.java:1016) at org.openide.explorer.view.TreeView$PopupAdapter.sh owPopup(TreeView.java:1500) at org.openide.awt.MouseUtils$PopupMouseAdapter.maybe Popup(MouseUtils.java:189) at org.openide.awt.MouseUtils$PopupMouseAdapter.mouse Released(MouseUtils.java:184) at java.awt.AWTEventMulticaster.mouseReleased(AWTEven tMulticaster.java:290) at java.awt.AWTEventMulticaster.mouseReleased(AWTEven tMulticaster.java:289) at java.awt.AWTEventMulticaster.mouseReleased(AWTEven tMulticaster.java:289) at java.awt.Component.processMouseEvent(Component.jav a:6504) at javax.swing.JComponent.processMouseEvent(JComponen t.java:3321) at java.awt.Component.processEvent(Component.java:626 ... |
59. [SOLVED] database connection java-forums.org |
60. Problem with database connection java-forums.orgimport com.mysql.jdbc.Statement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.Date; public class Try { public static void main (String[] args) { Connection conn = null; try { String userName = "root"; String password = "test"; String url = "jdbc:mysql://localhost:3307/Books"; Class.forName ("com.mysql.jdbc.Driver").newInstance (); conn = DriverManager.getConnection (url, userName, password); System.out.println ("Database connection established"); } catch (Exception e) { System.err.println ("Cannot connect to ... |
61. a connection from sql-table to a java class java-forums.orgHi. I have one sql-table and that table is not java class. I want to make a connection from that sql-table to a certain java class. I think I must write something in this java class and could it be like this; java.sql.Connection AND THE NAME OF THE TABLE ???? Please, how can I make this connection?, how should I write ... |
62. Java-mysql connection java-forums.orgHi, I'm reading a book about mysql and java atm. The book is a bit old (from 2003). Now when I want to try to execute an example, netbeans gives me 2 errors: Java Code: package mysql; import java.sql.*; public class Hello { Connection connection; private void displaySQLErrors(SQLException e) { System.out.println("SQLException: " + e.getMessage()); System.out.println("SQLState: " + e.getSQLState()); System.out.println("VendorError: " + ... |
63. JDBC DataBase Connection java-forums.orgHello What is the best way to manipulate a database connection? I have a .properties file with all necessary information to create a DataSource, after reading this file once, I have instance of SQLServerDataSource dataSource available. What I was doing was, for each method that interact with database , I create a Connection con = dataSource.getConnection() at start, and at the ... |
64. connection to database java-forums.org |
65. JDBC Connection java-forums.org |
66. JDBC Connection Creation Problem.Help needed? java-forums.orgHi to all, Currently i am using connections which are created during web application loading and each and every time when i use connection related methods i am closing the connections.What my problem is i read that it is not efficient to close connection objects.Some of them suggested to use object pool design pattern,some thing like to have a ConnectonPool Concept ... |
67. very new to jdbc connection.How to do it? forums.oracle.com |
68. database connection forums.oracle.com |
69. Database Connection for PSQL 8.3 forums.oracle.com |
70. How do I get a connection to a database? forums.oracle.comI want to use jdbc to get a connection to a data base. I am using netbeans as aathe ide to create my vanilla app. I have tried to understand jndi but it is too convoluted what with initialcontext etc. So I am now trying to use the driver manager like so ... Properties pr = new Properties(); pr.setProperty("user", "root"); pr.setProperty("password", ... |
71. Struggling with database connection forums.oracle.com |
72. How to make Database connection with Access forums.oracle.com/*first load the appropriate db driver into memory. - odbc is windows based db driver pool - jdbc is platform independent db interface, which make use of odbc assistance in windows!!! - JdbcOdbcDriver is a class available in package sun.jdbc.odbc - forName() is a static method found in java.lang.Class class, responsible for loading any given class in memory */ |
73. A problem about database connection forums.oracle.comYou can, normally, have multiple statements on the same connection, and since a JSP should only be reading (never updating) there won't be any (what I like to call) "commit cross-overs", so this is not "in principal" a problem. It would not, however, be ultimately practical. And the practice (a single connection per Servlet/Jsp) is still not one I would reccommend, ... |
74. DB connection not working... forums.oracle.comibanez270dx wrote: Hello, I have an applet I've been working on that I'm trying to connect to a DB. With test scripts I've got off the net, I can connect fine (I am using JDBC, MySQL, on Windows Server 2003). However, when I try to use similar code in my applet Yeah. There are security restrictions in Applets. You're mostly likely ... |
75. jdbc connection forums.oracle.comclass JdbcTest { public static void main (String args []) throws SQLException { // Create DataSource and connect to the local database OracleDataSource ods = new OracleDataSource(); ods.setURL("jdbc:oracle:thin:@//appshl.squarehospital.com:1521/shl"); ods.setUser("SHIS2"); ods.setPassword("ringtone"); Connection conn = ods.getConnection(); // Query the employee names Statement stmt = conn.createStatement (); ResultSet rset = stmt.executeQuery ("SELECT company_name FROM hpms_standard"); // Print the name out while (rset.next ()) System.out.println ... |
76. DB Connection forums.oracle.compublic class connect { try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //depends on the drive u are using Connection conn = DriverManager.getConnection("Jdbc:Odbc: source of ur data base"); preparedStatement stat = conn.prepareStatement("SQL statement goes here"); int reply = stat.executeQuery(); //returns 1 if data is written to the database successfully System.out.println(reply) // not very important but just helps to knoe if u have actually written to the datat ... |
77. Problem with database connection...Need help please forums.oracle.comHi all I am new to java, I am currently trying to develop web application using NetBeans IDE, I want to connect to an Access database. I have created the DSN connection properly and created the database connection using jdbc-odbc bridge but NetBeans established the connection with error message: "Unable to obtain schema. There is insufficient information to establish a connection ... |
78. JApplet + database connection forums.oracle.comhey all... i'm double posting here a little but i posted this in JApplet forum and i got no answer )): hey all!! i'm fairly new to java.... what i'm trying to do is a application build into a web page. java applet, i've been doing it for a while and everything is ok. have had some problems alogn the way ... |
79. can any body identify my problem with database connection? forums.oracle.comMy connection statement looks like this Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); DriverManager.getConnection("jdbc:odbc:ram"); Iam using jdk1.3 and oracle 9i client edition. The exception is ....... java.sql.sqlexception: No suitable driver. The interesting thing is, with the same above connection statement , i am able to connect my core java program with oracle. But not with J2ee application. Can anybody resolve my prob? |
80. can any body identify my problem with database connection? forums.oracle.comMy connection statement looks like this Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); DriverManager.getConnection("jdbc:odbc:ram"); Iam using jdk1.3 and oracle 9i client edition. The exception is ....... java.sql.sqlexception: No suitable driver. The interesting thing is, with the same above connection statement , i am able to connect my core java program with oracle. But not with J2ee application. Can anybody resolve my prob? |
81. Database Connection forums.oracle.comHello All, I am very new to Java. I have downloaded the NetBeans 5.5.1 and the Web Pack and have this setup with the Sun Java App server. I am running this on Windows XP and trying to connect to a MaxDB on a different server, with no luck. In the Run time tab I have setup the driver and made ... |
82. jdbc connection problem forums.oracle.com |
83. database connection forums.oracle.com |
84. Database Connection forums.oracle.com// JDBC|Test ? complete code public class JDBCTest { public static void main(String args[]){ RunDB runDB = new RunDB(); try{ runDB.loadDriver(); runDB.makeConnection(); runDB.buildStatement(); runDB.executeQuery(); }catch(Exception e){ e.printStackTrace(); } } } //RunDB import java.sql.*; public class RunDB { Connection connection; Statement statement; public void loadDriver() throws ClassNotFoundException{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } public void makeConnection() throws SQLException { connection= DriverManager.getConnection("jdbc:odbc:purchaseOrder") } public void buildStatement() throws ... |
85. Java Database Connection forums.oracle.com |
86. Access to class with connection to DB forums.oracle.comIf we talk about Connection to DB, it is very bad to keep many connections from one desktop application. I can easilly use one. If I will make new conection for every query, I will flood DB. imagine, there are 20 users and they work with DB tables. They will make hundreds connections in several minutes. But if every client will ... |
87. Connection To Database forums.oracle.comHi All, Can i join??? hehehe....i have some problems when attempting to connecting to database using bundle app. server (tomcat). I have already follow the tutorial, but it still didn,t work. can u do me a favour please.....what kind of e-books that can guide be to fully learning java. thanks for the attention. |
88. HOw to do a database connection forums.oracle.com |
89. Connection to JDBC forums.oracle.com |
90. database connection forums.oracle.com |
91. database connection forums.oracle.com |
92. Database connection terminated forums.oracle.com |
93. Alternitive Database connection methods forums.oracle.com |
94. Database Connection forums.oracle.com |
95. JDBC Connection with SQLServer2000 forums.oracle.comHi Im trying to test my database by establishing a JDBC Connection with SQLServer2000.. this is my code import java.*; import java.sql.Connection; import java.sql.DriverManager; import com.microsoft.jdbc.sqlserver.SQLServerDriver; public class SQLServerConnection{ public static void main(String[] args) { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433", "id","pwd"); System.out.println("con - " + con); } catch(Exception e) { e.printStackTrace(); } } } I added msbase.jar,mssqlserver.jar and msutil.jar ... |
96. Approach used to handle database connections forums.oracle.comI dont have a problem. The question here is approach. I put the java code in to only rid of confusion if someone didnt understand my question. My question is approach only. Not how to code it. For example, if you were writing your own classes to make a datasource connection, how many classes would someone else use. In my design ... |
97. Doubt Java Connection to database forums.oracle.comHi, I have a doubt. I have a stand alone java application, which connects to a database and fetches data, processes it and inserts it into different tables in database. When I am connecting to my local database the processing is fast. It takes fraction of seconds more while doing db operations, but java processing is very fast. The Java processing ... |
98. Database Connection ? forums.oracle.com |
99. DB connections limited to 2 per IP. what do you recommend? forums.oracle.comHi I am developing a java web application that runs on tomcat. It's publicly available on the Internet so all connections I receive are from external IP addresses (DMZ). This app opens connections to a couple of databases and extracts some information. One of these databases is limited to two connections per IP address per hour which is not enough for ... |
100. Where to create a JDBC Connection? forums.oracle.comI would like to know if this is a good design for placement of the connection creation? Should I be putting the connection creation code inside the while(true) loop? and close it before the loop terminates? At the moment, the connection is being closed after the method is invoked. But, I am not sure if this will is reachable because of ... |