Problems With JDBC

I downloaded the latest version on JDBC from Microsoft and I got problems.
Indeed, when fetching a smallint from SQL Server i got instead an Integer.
How can i do to avoid such a problem?
Some hints?


many tanks, gaetano



ADVERTISEMENT

Cannot Load JDBC Driver Class 'com.microsoft.jdbc.sqlserver.SQLServerDriver'

I have read similar posts to this, but I am still having problems.

I am trying to use connection pooling to connect to a local SQL Server 2005 database. I am running my application using
MyEclipse Enterprise Workbench. I have verified that sqljdbc.jar resides in "WebRoot/WEB-INF/lib/"

"WebRoot/WEB-INF/web.xml":
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsichemaLocation="http://java.sun.com/xml/ns/j2ee
    http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
    <resource-ref>
        <res-ref-name>jdbc/DefaultDS</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
</web-app>


"WebRoot/META-INFcontext.xml":

<?xml version="1.0" encoding="UTF-8"?>
<Context>
    <Resource name="jdbc/DefaultDS"
              auth="Container"
              type="javax.sql.DataSource"
              username="tec"
              password="tec"
              driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDrive"
              url="jdbcqlserver://localhost:1433/tec;databaseName=tec;user=tec;password=test;"
              validationQuery="select 1"
              maxActive="10"
              maxIdle="2"/>
</Context>

Classpath:
<?xml version="1.0" encoding="UTF-8"?>
<classpath>
    <classpathentry kind="src" path="src"/>
    <classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
    <classpathentry kind="con" path="com.genuitec.eclipse.j2eedt.core.J2EE14_CONTAINER"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/dom.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/jaxen-full.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/jaxp-api.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/jdbc2_0-stdext.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/sqljdbc.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/jstl.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/mail.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/sax.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/saxpath.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/standard.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/xalan.jar"/>
    <classpathentry kind="lib" path="WebRoot/WEB-INF/lib/xercesImpl.jar"/>
    <classpathentry kind="output" path="WebRoot/WEB-INF/classes"/>
</classpath>

Code to connect:

import java.io.Serializable;
import java.sql.*;

import javax.sql.*;
import javax.naming.*;
    public int testConnect(){
        Connection conn = null;
        InitialContext ctx = null;
        java.sql.Statement stmt = null;

        try {
            ctx = new InitialContext();
            Context envCtx = (Context) ctx.lookup("java:comp/env");
            DataSource ds = (DataSource) envCtx.lookup("jdbc/DefaultDS");/*This is generating the Cannot load JDBC driver class... error*/
            conn = ds.getConnection();
            stmt = conn.createStatement();
            return CONSTANT.SUCCESS;   

    } catch (Exception e) {
        return CONSTANT.FAILURE;
    }finally {
        try {
            if (stmt != null)
        stmt.close();
            if (conn != null)
        conn.close();
            if (ctx != null)
        ctx.close();
        } catch (Exception ex) {
            // do nothing
            return CONSTANT.FAILURE;
        }
    }
    }

Any ideas would be greatly appreciated.

View Replies View Related

MS JDBC Driver Incompatibility With JDBC 3.0 Specs

Hi all,





We've just stumbled on a 1.0 version incompatibility with the JDBC specs.





Problem: A table with SMALLINT column. According to JDBC specs version 3.0


(p.B-179) and 4.0 (p.221)), the value should be converted to Integer type.





Unfortunatelly we get a Short object :(





Now, I remember, this case was also affecting old JSQLConnect driver from


DataDirect. Could that problem sneak to new MS driver too?





Please let me know any resolution to this problem if exists.


The issue has not been fixed in CTP 1.1 version. Any ideas if it can be fixed??




Cheers,


Piotr

View Replies View Related

2000 JDBC Vs 2005 JDBC

 

I've got an import app written in Java.  One table I'm importing from contains 22 million records.  When I run the app in a 2000 environment, I have my max heap set at 512, and the table gets imported.  When I run in a 2005 environment, I have to change the max heap to 1152 or it will error out with a similiar error:
 
com.microsoft.sqlserver.jdbc.SQLServerException: The system is out of memory. Use server side cursors for large result sets:Java heap space. Result set size:854,269,999. JVM total memory size:1,065,484,288. (<--this is with max heap at 1024)
 
what is the difference between the 2000 and 2005 JDBC that I have to set max heap in one and not the other?

View Replies View Related

Help With JDBC Driver

Hello all,I have a question about the SQL Server JDBC driver. I was wondering ifanyone knows what the default prefetch size is (in number of rows).Also, does anyone know if an entire packet is sent (i.e. padded withnull values) if there is not enough data to fill it?Thanks for your help!ty

View Replies View Related

JDBC With MSDE

I have a MSDE database that I am trying to connect to with JDBC. I don'thave SQL Server installed. Is this possible? When I try to connect I getthe error:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver forJDBC][SQLServer]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Serverconnection.From what I've read on the web it looks like I need to set the securitysettings to allowfor SQL authentication as well as NT authentication. Is that correct? Andcan thatbe done with just MSDE?I think that I have MSDE 2000 installed (it actually came with a differentapplication).I just downloaded the latest SQL Server JDBC driver.Thanks,Bruce

View Replies View Related

Need A JDBC Driver

I need a free, redistributable JDBC driverfrom MS SQL Server. (MSDE2000a)

View Replies View Related

JDBC For MS SQL Server

Dear all,Where can I find JDBC for MS SQL server?Thx for reply.Victoria

View Replies View Related

Please Help, Jdbc Error

I am trying to access ms sql server 2000 using jdbc, the code compiled but produce this kind of error:


java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establi
hing socket.
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Sourc
)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source

at com.microsoft.jdbc.sqlserver.SQLServerImplConnecti on.open(Unknown So
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplC onnection(Unknown
ource)
at com.microsoft.jdbc.base.BaseConnection.open(Unknow n Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:193)
at org.apache.jsp.addvideo$jsp._jspService(addvideo$j sp.java:66)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWra pper.service(JspSe
vlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:
82)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(App
icationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(Application
ilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapper
alve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNe xt(StandardPipelin
.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.ja
a:472)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:943

at org.apache.catalina.core.StandardContextValve.invo ke(StandardContext
alve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNe xt(StandardPipelin
.java:566)
at org.apache.catalina.valves.CertificatesValve.invok e(CertificatesValv
.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNe xt(StandardPipelin
.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.ja
a:472)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:943

at org.apache.catalina.core.StandardContext.invoke(St andardContext.java
2344)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.
ava:164)
at org.apache.catalina.core.StandardPipeline.invokeNe xt(StandardPipelin
.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatch
rValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNe xt(StandardPipelin
.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.
ava:170)
at org.apache.catalina.core.StandardPipeline.invokeNe xt(StandardPipelin
.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java
462)
at org.apache.catalina.core.StandardPipeline.invokeNe xt(StandardPipelin
.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.ja
a:472)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:943

at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineVa
ve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNe xt(StandardPipelin
.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.ja
a:472)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:943

at org.apache.catalina.connector.http.HttpProcessor.p rocess(HttpProcess
r.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.r un(HttpProcessor.j
va:1106)
at java.lang.Thread.run(Thread.java:534)




Here is my full code I'm using jsp for accessing the database



<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!--
.style1{color: #FF0000}
-->
</style>
</head>

<body>
<%
String title = request.getParameter("Title");
String price = request.getParameter("Price");
ResultSet rs = null;
try{
DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
Connection connection =DriverManager.getConnection("jdbc:microsoft:sqlserver://WIN-WBL8VT0HEPJ:1433","sa","sa");
if (connection != null)
{
System.out.println("Succesfully connected");
Statement stmt = connection.createStatement();
String query = "Insert into Video (Title, Price) values('" + title + "','" +price+ "')";
stmt.executeUpdate(query);

query = "select * from Video";
rs = stmt.executeQuery(query);
%>
<h4 class="style1">.: A new video titled: <%= title %> has been added with a price of <%= price %> :.</h4>
<hr>
You currently have the following videos:
<table width="50%" border="1">
<tr>
<td><div align="center"><strong>Title</strong></div></td>
<td><div align="center"><strong>Price</strong></div></td>
</tr>
<%
while(rs.next()){
%>
<tr>
<td><%= rs.getString("Title") %></td>
<td><%= rs.getString("Price") %></td>
</tr>
<%
}
stmt.close();
connection.close();
}
}catch(Exception e)
{
System.err.println("Cannot connect to database server");
e.printStackTrace();
}
%>
</table>
<div align="center"><br>
<a href="video.html">back</a>
</div>
</body>
</html>


Anyone know what is wrong?

View Replies View Related

JDBC Driver

Is oracle and Microsoft JDBC drivers are same? Oracle 9i comes with JDBC, can I use the same driver to access the Microsoft SQL Server?

View Replies View Related

Need JDBC Driver For MS SQL 7.00.847

Hi
I just downloaded the Microsoft JDBC Driver for SQL Server 2000. Now it tells me SQL Server 7 is not supported. :o I already checked the JDBC Driver list on suns site. Its quite long and only states MS SQL Server without any version number. Can you recommend a particular driver? Preferrably without any cost. :D
Or am I better of with the jdbc/odbc bridge?

Thanks

Shabassa

View Replies View Related

JDBC Drivers

Is anyone out there using Unix/Java/Sun app server to connect to SQL Server via JDBC? If so, what drivers are you using? We are currently testing with WebLogic's BEA JDBC driver. Does anyone have any feedback on it?

View Replies View Related

Problems With JDBC

Hi,

Anyone here had difficulty logging in using JDBC to SQL Server 2000? I've an Java app that works perfectly with my test site and test database, but can't connect when I deploy at the customer location. I consistently get an error saying "Login failed for user 'foo'". Yet I can connect with the same user/password from an ASP page using ADO. This is with Microsoft's JDBC driver.

Tried a bunch of stuff
--> same thing happens with another type 4 driver (JTurbo)

--> Security permissions for user are fine (can read and write to database), and global settings are set to SQL Server authentication (not Win NT)

Anyone have any ideas for other things to check? My next step is to try the Sun JDBC-ODBC bridge.

Thanks, WILL

View Replies View Related

SQL Server And JDBC

Does anyone know of a good JDBC for SQL Server 2000?

View Replies View Related

Sql Server 7 And JDBC

Are there separate jdbc drivers for Sql Server 7 or should I use the 2000 drivers?

View Replies View Related

JDBC Connection

this url is having problem while making connection to SQL Server

jdbc:XXX:sqlserver://<host>:1433;DatabaseName=<name>
error:
"The requested instance is either invalid or not running."

View Replies View Related

JDBC Driver For MS SQL 7

Hi guys,

Where can I download the JDBC Driver for our MS SQL Server 7 ?

Thank you.

View Replies View Related

Jdbc Problem

Hi
I have a java program which uses sql.It supports sql 2000 and 2005.The user can enter a command from which he can choose to what server type he wants to connect.It is something like :

" c:connect [jdbc driver for 2005] [server] "

Now i have to do some different operations when user connects to 2000 and other operations when user connects to 2005.
The problem is that when using jdbc driver for 2005 he can also connect to mssql server 2000.
How can i find out to what server type he is connecting to?

i hope i explained it clearly enough
thanks

View Replies View Related

JDBC Driver?

Hi,

Does SQL Server Express ship with a JDBC driver? ... Hardly so, but is it available somewhere?

Rgds and thanks, PP

View Replies View Related

Jdbc Driver

we are currently using ms jdbc driver 2.2 to access our sql server 2000. we are upgrading to sql server 2005, is my current jdbc driver compatible with 2005, or do I have to use the new jdbc driver 1.1 for 2005.

Thanks

View Replies View Related

No Way To Do An Insert With JDBC?

I started with a simple insert on one of my tables.  It throws an exception for trying to place NULL in one of two calculated fields in the table.
I then tried setting up a simple stored procedure and calling it using:
 
CallableStatement statement = con.prepareCall("? = call dbo.AddSignedForms");
statement.registerOutParameter(1, java.sql.Types.INTEGER);
statement.execute();

 
Which generates this exception:
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.

of course there is no such expression in any of the code.
 
I then set up a simple two column table called tblTestJDBC.  now i'm getting this error:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'dbo.tblTestJDBC'.

Btw we DID manage to get a simple select statement to work from my applet.  Nothing else has.  Is this the MS JDBC driver?  Should I just avoid using it or are we missing something here?

View Replies View Related

Driver Jdbc

Hi Mixxo,
I also am having this problem! if you get an solution,    
send me an answer or add my msn: griciolli@hotmail.com

View Replies View Related

Driver JDBC

hi Mixxo,
I also am having this problem! if you get an solution,    
send me an answer or add my msn: griciolli@hotmail.com

View Replies View Related

Jdbc Driver

what is the jdbc driver for sql express? is it "sqljdbc"? then what is its "complete" name in the class path:"com.microsoft.sqlexpress.sqljdbc"? and for the conection url is it "jdbc:microsoft:sqlexpress://localhost/sqlexpress"?

View Replies View Related

Help: JDBC 1.22 And SQL 2000

HI, all

I need to write a program, which using VM 1.1.8.

So I need to find the JDBC driver version 1.22, Can anyone help me???

Please Reply, a link for download jdbc 1.22 or any other solutions .

Thank you!

View Replies View Related

JDBC With SQL Express

The java code :

  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

   String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
     "instance=SQLEXPRESS;databaseName=UPM;integratedSecurity=true;";
  Connection con = DriverManager.getConnection(connectionUrl);


returns "connection refused" no matter what I do.

 

I've used the surface config tool to enable TCP, I've added sqlsrvr.exe to the firewall exceptions, I've tried a dozen or so variations on the connection string.

I can connect to the database using the Management Studio.

 

Any ideas what I'm missing ????

Thanks.

View Replies View Related

JDBC Connectivity With SQL Server

How do I configure the MS-SQLSERVER to accept JDBC connections andprocess the sql?I'm using SQLSERVER 2000 on Windows NT.Thanks for your help

View Replies View Related

JDBC ResultSet And Cursors

Hi everyone-I'm using the Microsoft JDBC driver for SQL Server 2000 and I'm tryingto avoid using server cursors.Is there a way to guarantee that every query will not create aserver-side ResultSet with a cursor? In other words, I want everyResultSet to be loaded into the client's (the web server's) memory.Does setting the "selectMethod" connection property guarantee this?Does SQL Server automatically decide which method is best and if so,what is the default choice?I would appreciate any insight. Thanks in advance!

View Replies View Related

MS SQL Using TSQL Via JAVA Jdbc

Hello. I am having trouble finding a descent API for executing TSQLvia JDBC. I have tried the Microsoft driver AND the JDTS driver's butget the same syntax errors. I am hoping there is a good solution alsofor executing scripts using the same. Any help is MUCHappreciated.Thx.

View Replies View Related

JDBC Connections W/ AD Login?

I'm a newbie w/ SQL Server 2005.We will be connecting to SQL Server 2005 via JDBC. We have made thiswork by using an SQL Server account, rather than an Active Directory(AD) account, even though SQL Server IS in mixed authentication mode.Does mixed mode mean you can connect either way, but only using MS SQLServer interfaces (like Mgmt Studio), and not something like JDBC?Can we connect using JDBC w/ an AD login? If so, what form does thelogin take? Is the login not in 'DOMAIN/LOGIN' form?What is the best practice for this sort of thing? We would prefer touse AD logins (that a sysadmin creates) rather than having a separate(and probably equal) set of SQL Server logins.Any help appreciated.thanksaj

View Replies View Related

Secure Jdbc And Mssql

i have weblogic (7 and 8.1) installations that need to talk securelyvia JDBC to mssql database. preferrably using type4 (or at leasttype2) driver. is there anything out there that can be of any help?thank you.-anton

View Replies View Related

JDBC With Mulitple Databases

Dear all,Our application needs a bit of database redundancy.Our application only accesses database for reading purposes.We want to have two databases in separate machines. Incase one databaseserver dies the application should automatically extract data from theother server.Is there any JDBC driver available so that it can detect failure in themain database server and then tries to extract data from the standbydatabase server?Kind regards--Posted via http://dbforums.com

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved