server « Connection « Java Database Q&A





1. SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 1...    stackoverflow.com

i'm using JDBC to connect to SQL Server 2005 locally using integrated security. it's getting failed with the following error code Error: 17806, Severity: 20, State: 2. Logon ...

2. Does killing a session at the database server side also closes the connection and makes the jdbc connection object null?    stackoverflow.com

Suppose there is a jdbc code running some CRUD operations. Now, in a particular scenario there happened to be a row lock and the session became blocking to other database sessions. In ...

3. Connecting to database without running server in Apache Xindice    stackoverflow.com

I am new to "Apache Xindice". I tried some examples from the internet and it worked, but I have to run the server before running my applications.This allows it to connect to ...

4. IBM infosphere discovery studio connection server error    stackoverflow.com

I connect using the default setting. Server : Localhost , ServerPort : 9090 , then i got the jdbc error. IBM Discovery Studio Operation Errors , i follow the instruction ...

5. J/Connector fails to connect to Sphinx server via SphinxQL    stackoverflow.com

I have a server running the latest version of Sphinx (2.0.1-id64-beta) and am trying to access its SphinxQL interface via a Java application using the latest J/Connector JDBC driver (5.1.18). Whenever ...

6. Java.sql Connection closed Exception when on a particular server    stackoverflow.com

I get Java.sql.Connection closed Exception whenever i upload my application on My production Server.The production server is Jboss . I have also tried on QA,DEV server where this problem does not occur. Ours ...

8. QuartzInitializer trying to read JNDI DB connection before server startup completes    forums.terracotta.org

SEVERE: ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'QuartzOracleDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'AlertsQuartzOracle' javax.naming.CommunicationException: null org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'QuartzOracleDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'AlertsQuartzOracle' javax.naming.CommunicationException: null [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'AlertsQuartzOracle' javax.naming.CommunicationException: null]

9. Database Connection Thro RMI Server    coderanch.com

Hello Friends, I want to Develop Distributed Application in JAVA using RMI . I want to use 3 tier Architecture for that. How to Build RMI Server Application with Proper DB Connections and How to Place Objects for proper modeling. How to Use Middle Tire in Java 1) Server Objects 2) Middle Tier Objects Please send me some detailed info about ...





11. jdbc connection to mssql2000 db server    coderanch.com

Hi all I am using jdbc-odbc driver to connect to mssql2000 database. The code used is below public void connect() throws ClassNotFoundException, SQLException, Exception { try { // Load the Driver class file Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Make a connection to the ODBC datasource con = DriverManager.getConnection("jdbc:odbc:Dsnname","username","password"); } catch (ClassNotFoundException cnfe) { error = "Error No. 1 : ClassNotFoundException: Could not locate DB ...

12. JDBC oracle8i connection on the server    coderanch.com

14. NOt able to connect to actual database on the web server    coderanch.com

How to run MySql scripts to give priveliges for a pirticular Database. when i try to connect locally to my MySql database with the following syntax String url = "jdbc:mysql://10.15.0.2:3306/unistal?user=root&password="; connection = DriverManager.getConnection(url); it works fine but when i connect to the actual database on the web server with actual userID and Password , it fails to connect . I,am sure ...

15. Connection Pooling & Cycling DB Servers    coderanch.com

Hello, One aspect of connection pooling that still troubles me (with errors) is that when we cycle the backend Oracle database once a week for offline backup, the pooled connections go invalid (of course), but when the database is brought back online the pooled connections (in WebSphere AE) seem to all continue to be invalid returning oracle errors "No more data ...

16. Connection Pooling in Client Server application    coderanch.com

Hi, I have a client server application that connects directly to an Oracle database. The database connection opens when the application starts and closes when the application is closed. For the moment the number of users is limited (+- 200) but in a few months the number of users will be +-2000. For the moment the Oracle database has no problem ...





18. Switch gateway servers for connection    coderanch.com

I am using Tomcat connection Pooling to get the database connection. Before we used to use Single gateway servers to get the DB2 Connection. About few days back they changed to 3 gateway servers from 1 for back up purpose. Right now my code handles to get the connection from one gateway server through Connection Pooling. Can you please advise or ...

20. Connection to remote DB server to run JDBC application program    coderanch.com

Hi, When I run simple JDBC application program from Jbuilder it is running smoothly where the database is located on different machine. If I try to run (Compilation is fine) the same program on my command prompt, I'm getting exception "ClassNotFoundException". Should I need to configure DSN or any other on my computer to run the program? Please tell me the ...

21. J2EE server not connecting to database    coderanch.com

import java.io.*; import javax.servlet.*; import javax.servlet.http.*; //import javax.sql.*; import java.sql.*; public class Hello extends HttpServlet { Connection dbcon=null; int regno=0; public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); dbcon=DriverManager.getConnection("jdbc :-o dbc:nirmaldb", "Admin", ""); System.out.println("Connection established"); }catch(ClassNotFoundException e) { System.out.println("Database driver not found"); System.out.println(e.toString()); } catch(Exception e) { System.out.println(e.toString()); } res.setContentType("text/html"); PrintWriter out=res.getWriter(); String firstname=req.getParameter("firstname"); String lastname=req.getParameter("lastname"); ...

22. No of connections server can handle    coderanch.com

24. How to connect to Database Server on another machine ?    coderanch.com

Hi Guys, The Database server is on another PC (Linux is the OS installed on it) whose IP address is :- 10.0.2.21 and my machine's (Windows XP) IP address is :- 10.0.2.253 . So how do i connecet using JDBC? Now both these PCs ( ...i.e., my client PC and the PC on which the postgres Database Server 8.1 is hosted ...

27. Connection pooling without the server    coderanch.com

Hi guys, I've been reading (a little) about connection pooling and have a few questions. If I don't know the configuration of the connection ahead of time (i.e. because the user can configure it as part of the application) - how can I set up a pool? It seems that pools are really performant if you know the details and can ...

28. App Server Connection Pooling VS User defined Connection Pooling Mechanism    coderanch.com

Hello guys I am trying to provide a Study to the Technical Manger why to get rid of our Connection Pooling Mechanism (Developed by us) and use App. Server vendors Connection Pooling Mechanism? My question would be like this, where I can find a Spec., White papers or something like it that describes how to Design Connection Pools. This will help ...

29. getting I/O Error: DB server closed connection    coderanch.com

I am getting the Following exception while trying to connect to the SQLSErver DB I am using jtds-1.2.2.jar File. I am using Windows Authentication and i am able to connect though the SQL SErver Client Application I complete stack trace is pasted below org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (I/O Error: DB server closed connection.) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at sgstool.dbConnection.DBConnector.getSimpleConnection(DBConnector.java:43) Can anybody ...

31. java.sql.SQLException: I/O Error: DB server closed connection.    coderanch.com

Hi i am unable to connect to MSSQL 2000 database it gives me stack of errors, my code says a.java----------- import java.sql.*; public class a { public static void main(String[] args) { try { Class.forName("net.sourceforge.jtds.jdbc.Driver"); Connection conn = DriverManager.getConnection( "jdbc:jtds:sqlserver://localhost:8080/REGISTRATION_TEMP_LTR_PRINT","sa","water"); System.out.println("connected"); } catch (Exception e) { e.printStackTrace(); } } } and on execution the error i get is java.sql.SQLException: I/O Error: ...

32. Connecting to Database server    coderanch.com

34. is jdbc connection deadly for application servers ?    coderanch.com

I have a somewhat simular simular question. I am devloping a "small" web application, based on jsp, servlets, and a mySql database and my concerns is how to implement this application so that it will handle multiple users with good performance. My page is requested at about 3000 times a day, will I need to use a connection pool?, I develop ...

36. Getting an exception when tried to connect with the DB server    coderanch.com

HI we are getting the following exception when tried to connect with the DB server from Applcation Server at beginning after the restart of the App server it worked fine but again after one day duration we are again facing the same problem CAN ANYBODY SUGGEST ME THE WAY TO TRACE THE PROBLEM we have used EJB 3.0 Entity manager concept ...

37. Connection Problem in Linux Server    coderanch.com

I am working in webportal using Java,Mysql. I am facing below issue. I cant able to resolve the issue. Daily i am restart the server then this issue is not coming... how to resolve this issue. without restart the server.... Error ==== org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

38. Connect to server then create database?    coderanch.com

41. java code to connect to sql 2005 analytical server    dbforums.com

[Need help to connect to sql 2005 using java]Hi , I am new to sql 2005 analytic server. i need to retrive the multidimentional data from sql 2005 analytic server. Please let me know , how to connect to analytic server using java. Please provide me some sample codes Thanks, satya[/Need help to connect to sql 2005 using java]

43. [SOLVED] connecting two servers at atime    java-forums.org

45. Access to app server db connection pool    java-forums.org

Darryl -- Thanks for reminding me about my breach of protocol. I'll consider the content of your post and ensure compliance. Note that I'd suggest a different approach to providing this information. It's ok to be angry and express yourself but you might find it helpful to express it in a different way because, believe me, it goes a long way ...

46. Database connection for server    java-forums.org

yes i was adding the whole folder, but then i added the main Jar file, ok that issue is solved. Thankyou Tolls :) One more question, can i access the database on my website, from netbeans, because my website does not provide Java on their servers.And they said you can access it at localhost at the specified port. So Any suggestions ...

48. Cannot connect to database server:Cannot connect to database server    forums.oracle.com

Class.forName ("com.mysql.jdbc.Driver").newInstance (); conn = DriverManager.getConnection("jdbc:mysql://localhost/sampdb", "sampadm","secret"); System.out.println ("Database connection established"); } catch (Exception e) { System.err.println ("Cannot connect to database server"); System.err.println("Exception: " + e.getMessage()); } finally { if (conn != null) { try { conn.close (); System.out.println ("Database connection terminated"); } catch (Exception e) { /* ignore close errors */ } } } } }

49. Connecting to a database server    forums.oracle.com

51. How to connect several database server    forums.oracle.com

I want to build a web site using jsp servlet for my university course purpose. In the background i will have three servers one is database server like server A another is certificate authority server like server B and the other one is Bank server like server C. Next, user will input through login page(say for example user name & password ...