?
Solved

Oracle JDBC connection problem on tomcat

Posted on 2003-03-18
4
Medium Priority
?
1,768 Views
Last Modified: 2012-06-27
We are running Tomcat 4.1.18 with java 1.3.1
the database is Oracle 8.1.7 and I copied the thin client calsses (1.2) with the directory structure into WEB-INF/classes

When trying to connect to the database I need, I am getting the following error:

java.sql.SQLException
E/A-Exception: Size Data Unit (SDU) mismatch

the code I'm using is:

<HTML>
<HEAD>
<%@ page
     import = "java.sql.*"
     import = "java.lang.*"
%>
</HEAD>
<BODY>
<%
String err = "claudia";
String LastID = "";

Connection dbconn;
ResultSet rs;

try{
     DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
      Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@<server>:<port>:<db name>","***", "***");
} catch(Exception ex) {
     err += "<br>" + ex.getClass().getName();
     err += "<br>" + ex.getMessage();
}

%>
<%=err%>
</BODY>
</HTML>


This already produces the error.

Can anyone help?
0
Comment
Question by:cisense
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 4

Expert Comment

by:thanassis
ID: 8158272
The SDU is a buffer that Net8 uses to place data before transmitting across the
network. Net8 sends the data in the buffer either when requested or when it is full.

The SDU size should be set as a multiple of the normal transport frame size. Since
the normal Ethernet frame size is 1024, the most efficient SDU size over an
Ethernet protocol should be a multiple of 1024, but not more than four times the
amount of 1024.

try stripping the settings out all together first
0
 

Author Comment

by:cisense
ID: 8158462
I found the mistake.
I just used the wrong port, oops.
The other port obviously wasn't active or sth.
And for the posted comment, thanks I found that one before, and could not use it :-)
0
 
LVL 35

Expert Comment

by:girionis
ID: 10060120
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- To be PAQed and points refunded.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

girionis
EE Cleanup Volunteer
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 10125730
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

"Any files you do not have backed up in at least two [other] places are files you do not care about."
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question