Zhang Alan

+ Follow
since Nov 09, 2005
Merit badge: grant badges
For More
Cows and Likes
Total received
In last 30 days
Total given
Total received
Received in last 30 days
Total given
Given in last 30 days
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Zhang Alan

Originally posted by Chetan Parekh:
Just close your eyes.

Concentrate on breathe and count 25-24-23-22-21-...1 in the mind.

Gooood idea.
18 years ago
Thanks for replies.

And,I'm sorry for that my English is not very well. I don't know the difference between "Hi,everyone" and "Hi everyone".

But,I think,we said something or write something,just for being understood,no any other purpose.

And a question to you(wish to be friends of mine),where are you?

I am in the east of the world. The age-old east.
18 years ago
Oooooh. And where is the server computer? US?
18 years ago
I am a new one here too.

And my time is different from yours.So every time I come back here ,you are always on bed.

But I saw someone not,Alin Sinpalean,Paul Sturrock.....
[ November 11, 2005: Message edited by: Zhang Alan ]
18 years ago
A o~

My computer(in campus LAN) can't open google unless I use a proxy.
18 years ago
A question has nothing to do with DB.

Is there any board we can talk about some thing else in this forum?(We call it a water board)

For example,"Where are you from ?"
Put it into your classpath. That's all.

"console application"? - not sure what you mean by that. Do you just mean a stand alone Java application?


No, you're not. You're not specifying a user name and password, neither in your URL nor in the getConnection() call. That's why jTDS is trying to use the native DLL to authenticate: by not specifying a user name and password you're asking it to use the current Windows user's credentials to log in.

I've know where I am wrong. It same to be this:

I wrote this when I use mysql as my database.

String url = jdbcURL ;
url += "?user=" + user;
url += "&password=" + password;

conn= DriverManager.getConnection(url);

And,now I'm using ms sqlserver. But I didn't edit this file. So,I got the error.

Now I edit the program:

String url = jdbcURL ;

conn= DriverManager.getConnection(url,user,password);

And,this time it works well!

By the way,I find that,when I use the driver of ms,my program run very,very slowly.

Now I change back to jtds,and this time it works well and much faster than it works on ms driver.

Hehe,so,use the jtds instead of ms jdbc driver!

[ November 10, 2005: Message edited by: Zhang Alan ]
18 years ago

Originally posted by Praveen palukuri:
I've a doubt that how can i assign a bean value to jsp variable. i'd tried the below code:

<% String status = "<bean:write name='usersearch' property='userStatus'/>"; %>

But it's giving an error. If any one knows please help me.



I think you can do it like this:

<bean: define id="status" name="usersearch" property="userStatus"/>

The space between "bean:" and "define" is written because ":" and "d" is change to when there isn't a space...
[ November 10, 2005: Message edited by: Zhang Alan ]
18 years ago

Originally posted by Maximilian Stocker:
When you come back see my previous post about SQL server authentication vs Windows authentication.

I have to applications used jtds.

One of them is a java web application.And it works well.

Another is a console application. This one cannot work.

If the error is caused by the difference of these two authentications, I can't have a application can work well because the database of these two application is same.

Originally posted by Maximilian Stocker:

Okay I did more research and found the error. You are attempting to use Windows authentication. Use SQL Server authentication instead.

I am useing the SQL Server authentication. I have read the topic of this problem which may be you read right now. And he(she) change to use ms driver at last. So.....

And I have heard that jtds is better than the ms driver.So at first I chose jtds.but..

And I cannot find the error in my program. So ...

Really,I must go to bed beacuse is too late for me and I have a lesson this morning.

Thank you and bye.

Originally posted by Maximilian Stocker:

The JTDS driver is FAR less buggy than the ms one. I have never seen that error before with JTDS and since there are no native components to the JTDS driver I would conclude that the error you posted has nothing to do with the driver. That error is something else wrong.

Please post the top part of your stack trace and the offending code. There is another bug in your program/setup which you currently have misidentified.

You are right. I did a small test of useing jtds to connect sqlserver,and successed.

So the error is not caused by the jtds.

But I set up a database in mysql and connected it with mysqldriver,and successed.

So I want try to use ms sqlserver driver instead of jtds. Just try.

This is the track trace following.

java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Ch
eck the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:611)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at bin.Dbo.<init>(Dbo.java:78)
at bin.FtpSearch.main(FtpSearch.java:30)
Caused by: java.io.IOException: SSO Failed: Native SSPI library not loaded. Chec
k the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:1894)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:584)
... 7 more

And,I have gotten a ms sqlserver driver from microsoft.Just not the last version.

And,now I must go to bed..The time of my area is 0:17 am.

Originally posted by Maximilian Stocker:

Also the MS link works fine for me. I can get to the page and download the setup file so if it doesn't work for you something is wrong with your internet connection or browser.

May be.

The protocal of the page is https.May be this is the point.