Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Unhandled token type: Unknown token: 0x27(again)

5 views
Skip to first unread message

wyou

unread,
May 30, 2003, 9:30:22 AM5/30/03
to
--I posted reply to the thread I posted before, and I
didn't see the reply, so I am bothering you guys here
again. Sorry.

__________________________________________________________

I tried to open a case in PSS. And I could not figure out
how to open a case there. So, I am going to give you some
more detailed discription.

I query to MSDE 2000 using JDBC Driver with SP1.
It is ok normally except that it has this error message
from time to time.
And, my application has several different environment.
this error occurred only with the environment where my
app and my coworker's app talks to same MSDE database.
His app is .Net application and he is using ODBC .Net
Data Provider. As you know, my java application uses JDBC
Driver.

Here is my program to get the connection.

try
{
System.out.println("Start !!!!!!!!!!!!!!");
Connection conn = null;
Properties props = new Properties();
String driver
= "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url
= "jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=
cursor;DatabaseName=1stAgAdapter";
props.put("user", "sa");
props.put("password", "");

Driver myDriver = (Driver) Class.forName
(driver).newInstance();
System.out.println("Just Before !!!!!!!!!!!!!!");
conn = myDriver.connect(url, props);
System.out.println("About to Query !!!!!!!!!!!!!!");
ResultSet rs = conn.createStatement().executeQuery
("select * from agx_event");
while(rs.next())
{
System.out.println(rs.getInt("agx_event_id"));
}
System.out.println("Done !!!!!!!!!!!!!!");
}
catch(Exception e)
{
e.printStackTrace();
}

And the error is

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver
for JDBC]Unhandled token type: Unknown token: 0x27
at
com.microsoft.jdbc.base.BaseExceptions.createException
(Unknown Source)
at
com.microsoft.jdbc.base.BaseExceptions.getException
(Unknown Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyTo
k
en(Unknown Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processRe
p
lyToken(Unknown Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply
(Unknown Source)
at
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open
(Unknown Source)
at
com.microsoft.jdbc.base.BaseConnection.getNewImplConnectio
n
(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open
(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect
(Unknown Source)

>-----Original Message-----
>Hello,
>
>This looks like a bug in the driver. Are you running
JDBC SP1? I would
>first ask that you install JDBC SP1 and retest to see if
the problem
>reproduces. If so, then you should probably open a case
with Product
>Support Services (PSS) and have us look into the matter
further. This
>would be free of charge since it is most likely bug.
>
>If this is not a possibility, please post your Java code
and the table
>structures that it uses, and I'll try to reproduce it
here on my machine.
>
>Carb Simien, MCSE MCDBA
>Visual C/C++/C# Web Data
>Microsoft Developer Support
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>Are you secure? For information about the Strategic
Technology Protection
>Program and to order your FREE Security Tool Kit, please
visit
>http://www.microsoft.com/security.
>
>--------------------
>| Content-Class: urn:content-classes:message
>| From: "wyou" <wy...@1stag.com>
>| Sender: "wyou" <wy...@1stag.com>
>| Subject: Unhandled token type: Unknown token: 0x27 ?
>| Date: Fri, 9 May 2003 06:42:56 -0700
>| Lines: 38
>| Message-ID: <074d01c31630$e5a0fc80$a301...@phx.gbl>
>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| X-MimeOLE: Produced By Microsoft MimeOLE
V5.50.4910.0300
>| Thread-Index: AcMWMOWgLqoyoaWURReiX2TrQdbmGw==
>| Newsgroups: microsoft.public.sqlserver.jdbcdriver
>| Path: cpmsftngxa06.phx.gbl
>| Xref: cpmsftngxa06.phx.gbl
microsoft.public.sqlserver.jdbcdriver:4591
>| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
>| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
>|
>| Hi.
>| My application uses JDBC driver from microsoft to get
a
>| connection to MSDE 2000. And I got this wierd
exception in
>| this morning.
>|
>| java.sql.SQLException: [Microsoft][SQLServer 2000
Driver
>| for JDBC]Unhandled token type: Unknown token: 0x27
>| at
>| com.microsoft.jdbc.base.BaseExceptions.createException
>| (Unknown Source)
>| at
>| com.microsoft.jdbc.base.BaseExceptions.getException
>| (Unknown Source)
>| at
>|
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyTo
k
>| en(Unknown Source)
>| at
>|
com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processRe
p
>| lyToken(Unknown Source)
>| at
>|
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply
>| (Unknown Source)
>| at
>|
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open
>| (Unknown Source)
>| at
>|
com.microsoft.jdbc.base.BaseConnection.getNewImplConnectio
n
>| (Unknown Source)
>| at com.microsoft.jdbc.base.BaseConnection.open
>| (Unknown Source)
>| at com.microsoft.jdbc.base.BaseDriver.connect
>| (Unknown Source)
>|
>|
>| Could you tell me what that means?
>| It is really urgent...
>|
>| Thank you. all.
>|
>
>.
>
.


Joseph Weinstein

unread,
May 30, 2003, 11:48:23 AM5/30/03
to wyou

wyou wrote:

> --I posted reply to the thread I posted before, and I
> didn't see the reply, so I am bothering you guys here
> again. Sorry.
>
> __________________________________________________________
>
> I tried to open a case in PSS. And I could not figure out
> how to open a case there. So, I am going to give you some
> more detailed discription.

The sad truth is that the JDBC driver is not completely fluent in the
wire-level protocol the DBMS uses to talk to it's clients. Some
legitimate messages/data the DBMS is sending the driver are simply
not understood by the driver. Unfortunately, because the complex
relationship of Java and this driver to Microsoft and thence to the
actual author of the driver, who has their own for-money version that
they need to keep superior to the free MS one, the speed at which
fixes arrive for this driver is glacial.
Is there anything out-of-the-ordinary about the table you're
querying? Are there any triggers on that table?
Joe Weinstein at BEA

wyou

unread,
May 30, 2003, 2:06:21 PM5/30/03
to
There is no special in the table.
What I feel is that the box my app runs must use ODBC .Net
Data Provider as well. So, maybe it is not compatible
each other.
Or, I query the table very open.

Other than that, I can't figure out what is different.

-_-;;;;;

If somebody have any idea what is the problem with this,
please send me some reponse !!!

Thank you.

>.
>

Joseph Weinstein

unread,
May 30, 2003, 2:22:31 PM5/30/03
to wyou

wyou wrote:

> There is no special in the table.
> What I feel is that the box my app runs must use ODBC .Net
> Data Provider as well. So, maybe it is not compatible
> each other.

There is no interaction betwen these. It's not a compatibility issue.

>
> Or, I query the table very open.

That shouldn't matter either. An MS engineer should be able to look up
that token and say what packet type it is being returned. Anyone that has
the MS client development environment for C/C++ could search the
include files MS provides for client code, and look up the TDS packet
definition for a packet type 39 (0x27). I suggest you try another jdbc
driver, such as the one from DataDirect, or www.inetsoftware.de.
Joe

Brian Gould

unread,
Jul 10, 2003, 11:40:57 AM7/10/03
to
OK, I've had it with the MS Driver and all of the bugs.
Where do I get the superior one? Who makes it?

>-----Original Message-----
...

0 new messages