
Новые сообщения [новые:0]
Дайджест
Горячие темы
Избранное [новые:0]
Форумы
Пользователи
Статистика
Статистика нагрузки
Мод. лог
Поиск
|
|
13.12.2005, 19:21
|
|||
|---|---|---|---|
|
|||
CachedRowSet |
|||
|
#18+
Pomogite c CachedRowSet and JNDI. Vot moya proga - import java.sql.*; import java.io.*; import java.util.*; import javax.sql.DataSource; import oracle.jdbc.pool.OracleDataSource; import javax.naming.Context; import javax.naming.NamingException; import javax.naming.InitialContext; import java.util.Hashtable; import javax.sql.*; import oracle.jdbc.driver.*; import oracle.jdbc.pool.*; import java.io.*; import java.sql.SQLException; import oracle.jdbc.rowset.OracleCachedRowSet; public class S120864 { private static Context ctx = null; //private DataSource ds = null; private Connection conn; private ResultSet rs; private Statement st; private OracleCachedRowSet crs; //????????????? ????????? void InitContext(){ // Initialize the Context String sp = "com.sun.jndi.fscontext.RefFSContextFactory"; String file = "file:JNDI"; try { //Create Hashtable to hold environment properties //then open InitialContext Hashtable env = new Hashtable(); env.put (Context.INITIAL_CONTEXT_FACTORY, sp); env.put (Context.PROVIDER_URL, file); ctx = new InitialContext(env); } catch (NamingException ne){ ne.printStackTrace(); } } //co???????? ???????????? ??????? ???? DataSource ? ?????? ???? ? ????????? void bindDataSource(Context ctx, String dsn){ try{ //???????? ??????? CachedRowSet OracleCachedRowSet crs = new OracleCachedRowSet(); //????????? ?????????? ?????????? crs.setUrl("jdbc:oracle:thin:@localhost:1521:orbis"); crs.setUsername("s120864"); crs.setPassword("xkx133"); String sql = "select '5120',???????,???,????????,????_????????,?????_???????? from ?_???? where ?? in (select ????_?? from ?_??????? where ??????=5120 and ?????? = '01.09.2005') order by ???????"; // ????????? sql-??????????? crs.setCommand(sql); //?????????? ??????? ???? CachedRowSet ??????????? ?????????? crs.execute(); //Create an OracleDataSource instance /*OracleDataSource ods = new OracleDataSource(); //????????? ?????????? ?????????? ods.setUser("s120864"); ods.setPassword("xkx133"); ods.setDriverType("thin"); ods.setDatabaseName("orbis"); ods.setServerName("localhost"); ods.setPortNumber(1521);*/ //?????????? ??????? ? ?????? ???? ? ????????? ctx.rebind (dsn,crs); } catch (NamingException ne){ ne.printStackTrace(); } catch (SQLException se){ se.printStackTrace(); } } // ?????????? ??????? ???? DataSource ? ?????? ???? ? ????????? void RetrieveDataSource(String dsn){ try { crs = (OracleCachedRowSet) ctx.lookup(dsn); } catch (NamingException ne){ ne.printStackTrace(); } } // ????? ????????? ??????? void PrintCrs() { try { System.out.println(" " + "????????? ??????? - ???????? ??.5120"); //?????????? ?????? ?????????? ??????? ?? ??????? ???? CachedRowSet while (crs.next()) { System.out.print(" " + crs.getString(1)); System.out.print(" " + crs.getString(2)); System.out.print(" " + crs.getString(3)); System.out.print(" " + crs.getString(4)); System.out.print(" " + crs.getDate(5)); System.out.print(" " + crs.getString(6)); System.out.println(""); } } catch (SQLException se) { se.printStackTrace(); } } // ???????????? ???????? void Destroy(){ try { if(ctx!=null) ctx.close(); } catch (NamingException ne){ ne.printStackTrace(); } /*try { if(rs!=null) rs.close(); if(st!=null) // st.close(); if(conn!=null) conn.close(); } catch (SQLException se) { se.printStackTrace(); } */ } public static void main(String[] args) { //???????? ?????????? ?????? s120864 S120864 obj = new S120864(); //----------------------------------------------- //????????????? ????????? obj.InitContext(); // ??????? ????? ??????? ???? DataSource,??? ??????? ????????? ? ?????? ???? ? ????????? String dataSourceName = "MyCachedRowSet"; //co???????? ???????????? ??????? ???? DataSource ? ?????? ???? ? ????????? obj.bindDataSource(ctx, dataSourceName); // ?????????? ??????? ???? DataSource ? ?????? ???? ? ????????? obj.RetrieveDataSource(dataSourceName); obj.PrintCrs(); obj.Destroy(); }//end main() }//end Class Voznikaet oshibka:Can only bind References or Referenceable objects Zdes' neobxodimo sozdat class References i chto-to s nim sdelat kak zdelat chtobi cse zarabotalo ! Ochen interesno kak eto sdelat. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
14.12.2005, 10:02
|
|||
|---|---|---|---|
|
|||
CachedRowSet |
|||
|
#18+
я ща застрелюсь... ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
15.12.2005, 17:13
|
|||
|---|---|---|---|
CachedRowSet |
|||
|
#18+
am_sasaя ща застрелюсь... подписался ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|

start [/forum/topic.php?fid=59&tablet=1&tid=2150671]: |
0ms |
get settings: |
5ms |
get forum list: |
9ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
139ms |
get topic data: |
7ms |
get forum data: |
1ms |
get page messages: |
23ms |
get tp. blocked users: |
1ms |
| others: | 202ms |
| total: | 391ms |

| 0 / 0 |
