614498.xml

论坛精华帖子

<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>三少爷的剑</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>110</credit>
<TopicId>614498</TopicId>
<TopicName>jsp&#32;如何连接oracle8.1.7数据库？？</TopicName>
<PostUserId>82141</PostUserId>
<PostUserName>zls0303</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>5</ReplyNum>
<PostDateTime>2002-4-1 15:30:37</PostDateTime>
<Point>60</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>oracle8.1.7中的　ORACLE&#32;ODBC&#32;Test接连正确，可是在JSP中就是不正确，如何连接，大家给予帮助！！！！！</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>三少爷的剑</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>110</credit>
<ReplyID>4063546</ReplyID>
<TopicID>614498</TopicID>
<PostUserId>82141</PostUserId>
<PostUserName>zls0303</PostUserName>
<Point>0</Point>
<Content>大家帮帮忙啊</Content>
<PostDateTime>2002-4-1 16:02:17</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>new</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>4063914</ReplyID>
<TopicID>614498</TopicID>
<PostUserId>115318</PostUserId>
<PostUserName>new678</PostUserName>
<Point>30</Point>
<Content>DriverManager.registerDriver&#32;(new&#32;oracle.jdbc.driver.OracleDriver());
&#32;String&#32;connstr&#32;=&#32;MOS17Web.ta_db_str;
&#32;String&#32;uname&#32;=&#32;"test";
&#32;String&#32;pword&#32;=&#32;"test";
&#32;Connection&#32;conn&#32;=&#32;DriverManager.getConnection(connstr,uname,pword);
&#32;String&#32;stmttext&#32;=&#32;"select&#32;ta_type,&#32;sys.dbms_lob.getlength&#32;&#32;(ta_content),&#32;ta_content&#32;from&#32;ta_content&#32;where&#32;ta_number&#32;=&#32;:1";
&#32;PreparedStatement&#32;pstmt&#32;=&#32;conn.prepareStatement(stmttext);
&#32;pstmt.setString(1,v_fn);
&#32;ResultSet&#32;rslt&#32;=&#32;pstmt.executeQuery();</Content>
<PostDateTime>2002-4-1 16:19:42</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>三少爷的剑</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>110</credit>
<ReplyID>4064798</ReplyID>
<TopicID>614498</TopicID>
<PostUserId>82141</PostUserId>
<PostUserName>zls0303</PostUserName>
<Point>0</Point>
<Content>这样子行吗，要不要在classpath&#32;中加下oralce啊</Content>
<PostDateTime>2002-4-1 17:03:33</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>微电</PostUserNickName>
<rank>一星(中级)</rank>
<ranknum>star1</ranknum>
<credit>100</credit>
<ReplyID>4064881</ReplyID>
<TopicID>614498</TopicID>
<PostUserId>109064</PostUserId>
<PostUserName>xmvigour</PostUserName>
<Point>30</Point>
<Content>如果使用Thin或OCI驱动程序：
URL中可以包括用户登录名和用户登录密码。例如：
jdbc:oracle:thin:guest/guest@Chicago:1521:chidb;
如果设定了url属性，tnsEntry,&#32;driverType,&#32;portNumber,&#32;networkProtocol,&#32;serverName，和databaseName属性将失效。
在没有设定url属性的情况下，如果设定了tnsEntry属性，portNumber,&#32;networkProtocol,&#32;serverName，和databaseName属性将失效。
如果使用OCI驱动程序，并且networkProtocol属性被设定为ipc，除user和password外的所有其他属性将失效。


要在ClassPath里加的是classes111.zip，呵呵，那是针对oracle8i的，加载了classes12.jar&#32;针对Oracle9

</Content>
<PostDateTime>2002-4-1 17:07:30</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>三少爷的剑</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>110</credit>
<ReplyID>4076944</ReplyID>
<TopicID>614498</TopicID>
<PostUserId>82141</PostUserId>
<PostUserName>zls0303</PostUserName>
<Point>0</Point>
<Content>看了ORACLE的帮助，搞定，谢谢大家</Content>
<PostDateTime>2002-4-2 14:05:20</PostDateTime>
</Reply>
</Replys>
</Topic>