cherlapalli_jailer Posted June 20, 2013 Report Share Posted June 20, 2013 [quote name='Chinni_' timestamp='1371756813' post='1303874805'] just oral question adigadu anna anthe.. code akkarla [/quote] ayyo sarele take it easy.. previous page lo interview Question post vundi kasta choodu Link to comment Share on other sites More sharing options...
vijayjust4u Posted June 20, 2013 Report Share Posted June 20, 2013 Jailer bhayya... generic logic question... Database lo 100,000 records unnayi...and screen medha only 200 display cheyyali...with next, next to display next set of records... sorting functionality on records kooda unnayi... How to do it 1) Next click chesinappudu...DB nunchi 200 records techukovaalaaa OR 2) Data antha oke hit lo techukoni. Beans lo populate chesi...next click chesinappudu... action class call chesi...display cheyyalaa? 3) Or vere option emanna undhaaa? Ye approach better? Link to comment Share on other sites More sharing options...
rahularaveti27 Posted June 20, 2013 Report Share Posted June 20, 2013 Java Pagination Link to comment Share on other sites More sharing options...
vijayjust4u Posted June 20, 2013 Report Share Posted June 20, 2013 [quote name='rahularaveti27' timestamp='1371759249' post='1303874941'] Java Pagination [/quote] More Details please Link to comment Share on other sites More sharing options...
geeni83 Posted June 20, 2013 Report Share Posted June 20, 2013 [quote name='cherlapalli_jailer' timestamp='1371755340' post='1303874716'] oralce driver install cheyyali eclipse lo.. more over ..dont integrated oracle in eclipse...configure ur java application to connect to Oracle using JDBC Drivers downloaded class12.zip drivers [/quote] class12.zip file downloaded... how to connect to oracle... i am new to all this..help Link to comment Share on other sites More sharing options...
ZuniorVentiyar Posted June 20, 2013 Report Share Posted June 20, 2013 [url="http://lmgtfy.com/?q=Oracle+JDBC+example"]http://lmgtfy.com/?q=Oracle+JDBC+example[/url] this should give you link to this [url="http://www.mkyong.com/jdbc/connect-to-oracle-db-via-jdbc-driver-java/"]http://www.mkyong.com/jdbc/connect-to-oracle-db-via-jdbc-driver-java/[/url] [url="http://lmgtfy.com/?q=connecting+oracle+from+eclipse"]http://lmgtfy.com/?q=connecting+oracle+from+eclipse[/url] this should give you link to this [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html"]http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html[/url] [quote name='JAINTR' timestamp='1371760712' post='1303875072'] class12.zip file downloaded... how to connect to oracle... i am new to all this..help [/quote] 1 Link to comment Share on other sites More sharing options...
ChampakDas Posted June 20, 2013 Report Share Posted June 20, 2013 you should never use predefined methods CJ... [quote name='cherlapalli_jailer' timestamp='1371756251' post='1303874773'] StringTokenizer vaadu or do u need complete code? give the structured of the string [/quote] Link to comment Share on other sites More sharing options...
geeni83 Posted June 20, 2013 Report Share Posted June 20, 2013 cherlapalli maayya edina link unte seppu connect sesenduku.. Link to comment Share on other sites More sharing options...
ChampakDas Posted June 20, 2013 Report Share Posted June 20, 2013 I dont have a specific answer for your question but in general its not advisible to make multiple hits to the server again 100,000 records antunna issue of holding that data in cache...waiting to see replies like you [quote name='Sinnababu_Sillyfellow' timestamp='1371758655' post='1303874897'] Jailer bhayya... generic logic question... Database lo 100,000 records unnayi...and screen medha only 200 display cheyyali...with next, next to display next set of records... sorting functionality on records kooda unnayi... How to do it 1) Next click chesinappudu...DB nunchi 200 records techukovaalaaa OR 2) Data antha oke hit lo techukoni. Beans lo populate chesi...next click chesinappudu... action class call chesi...display cheyyalaa? 3) Or vere option emanna undhaaa? Ye approach better? [/quote] Link to comment Share on other sites More sharing options...
geeni83 Posted June 20, 2013 Report Share Posted June 20, 2013 [quote name='Java01' timestamp='1371761095' post='1303875111'] [url="http://lmgtfy.com/?q=Oracle+JDBC+example"]http://lmgtfy.com/?q...le JDBC example[/url] this should give you link to this [url="http://www.mkyong.com/jdbc/connect-to-oracle-db-via-jdbc-driver-java/"]http://www.mkyong.co...bc-driver-java/[/url] [url="http://lmgtfy.com/?q=connecting+oracle+from+eclipse"]http://lmgtfy.com/?q...le from eclipse[/url] this should give you link to this [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html"]http://docs.oracle.c...ingStarted.html[/url] [/quote] 'thanks baa Link to comment Share on other sites More sharing options...
geeni83 Posted June 20, 2013 Report Share Posted June 20, 2013 [quote name='Java01' timestamp='1371761095' post='1303875111'] [url="http://lmgtfy.com/?q=Oracle+JDBC+example"]http://lmgtfy.com/?q...le JDBC example[/url] this should give you link to this [url="http://www.mkyong.com/jdbc/connect-to-oracle-db-via-jdbc-driver-java/"]http://www.mkyong.co...bc-driver-java/[/url] [url="http://lmgtfy.com/?q=connecting+oracle+from+eclipse"]http://lmgtfy.com/?q...le from eclipse[/url] this should give you link to this [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html"]http://docs.oracle.c...ingStarted.html[/url] [/quote] [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html"]http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html[/url] indulo "new connection profile" daggara aagipoyanu vayya.. naku em cheyalo artham kaaledu [color=#000000][font=Arial, Helvetica, sans-serif][size=3] If "Oracle Database Connection" is not listed, [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html#"]restart[/url] Eclipse with[b] -clean[/b] command option. Provide a name for the connection and proceed to the next [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html#"]step[/url].[/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=3] [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html#"]Complete[/url] the rest of the dialog as follows:[/size][/font][/color][list] [*]Select [b]Oracle Database 10g Driver Default[/b] from the drop-down list of drivers. [*]Click [b]Edit Driver Definition[/b] triangular button on the right, select the [b]Jar List[/b] tab, then select the existing entry, and click [b]Edit JAR/Zip[/b]. Browse to your eclipse directory, open the plugins folder, and select the oracle.eclipse.tools.database.jdbc.driver*.jar file. Note that you need to do this only once. [*]If the defaults are not appropriate for your configuration, change the following information in the [b]URL[/b] field: [list] [*]replace [b]localhost[/b] with the hostname or IP address of the Oracle [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html#"]Database server[/url]. [*]replace [b]1521[/b] with the port number of the Oracle Database Listener service. [*]replace [b]xe[/b] with the Service Name (or SID) of the Database Service. [/list][*]Provide the database user name and password for the connection. [*]Use the following optional properties if required: [list=1] [*][b]autocommit=[/b]false By default, autocommit is set to true, which results in immediate commit of the operations from SQL Editor. When set to [b]false[/b], you need to execute the explicit COMMIT to commit the changes. See [url="http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4010.htm#i2060233"]Oracle Database SQL Reference[/url] for more information. [*][b]sysdba=[/b]true Use this property to login with SYSDBA account. [*][b]sysoper=[/b]true Use this property to login with SYSOPER account. [/list][*]Click [b]Test Connection[/b] to test the connectivity. [*]Select [b]Connect when the wizard completes[/b] checkbox to enable the database connection. [*]Select [b]Finish[/b] to complete the wizard. [/list] Link to comment Share on other sites More sharing options...
geeni83 Posted June 20, 2013 Report Share Posted June 20, 2013 [quote name='Java01' timestamp='1371761095' post='1303875111'] [url="http://lmgtfy.com/?q=Oracle+JDBC+example"]http://lmgtfy.com/?q...le JDBC example[/url] this should give you link to this [url="http://www.mkyong.com/jdbc/connect-to-oracle-db-via-jdbc-driver-java/"]http://www.mkyong.co...bc-driver-java/[/url] [url="http://lmgtfy.com/?q=connecting+oracle+from+eclipse"]http://lmgtfy.com/?q...le from eclipse[/url] this should give you link to this [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html"]http://docs.oracle.c...ingStarted.html[/url] [/quote] [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html"]http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html[/url] indulo "new connection profile" daggara aagipoyanu vayya.. naku em cheyalo artham kaaledu [color=#000000][font=Arial, Helvetica, sans-serif][size=3] If "Oracle Database Connection" is not listed, [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html#"]restart[/url] Eclipse with[b] -clean[/b] command option. Provide a name for the connection and proceed to the next [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html#"]step[/url].[/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=3] [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html#"]Complete[/url] the rest of the dialog as follows:[/size][/font][/color][list] [*]Select [b]Oracle Database 10g Driver Default[/b] from the drop-down list of drivers. [*]Click [b]Edit Driver Definition[/b] triangular button on the right, select the [b]Jar List[/b] tab, then select the existing entry, and click [b]Edit JAR/Zip[/b]. Browse to your eclipse directory, open the plugins folder, and select the oracle.eclipse.tools.database.jdbc.driver*.jar file. Note that you need to do this only once. [*]If the defaults are not appropriate for your configuration, change the following information in the [b]URL[/b] field: [list] [*]replace [b]localhost[/b] with the hostname or IP address of the Oracle [url="http://docs.oracle.com/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html#"]Database server[/url]. [*]replace [b]1521[/b] with the port number of the Oracle Database Listener service. [*]replace [b]xe[/b] with the Service Name (or SID) of the Database Service. [/list][*]Provide the database user name and password for the connection. [*]Use the following optional properties if required: [list=1] [*][b]autocommit=[/b]false By default, autocommit is set to true, which results in immediate commit of the operations from SQL Editor. When set to [b]false[/b], you need to execute the explicit COMMIT to commit the changes. See [url="http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4010.htm#i2060233"]Oracle Database SQL Reference[/url] for more information. [*][b]sysdba=[/b]true Use this property to login with SYSDBA account. [*][b]sysoper=[/b]true Use this property to login with SYSOPER account. [/list][*]Click [b]Test Connection[/b] to test the connectivity. [*]Select [b]Connect when the wizard completes[/b] checkbox to enable the database connection. [*]Select [b]Finish[/b] to complete the wizard. [/list] Link to comment Share on other sites More sharing options...
cherlapalli_jailer Posted June 20, 2013 Report Share Posted June 20, 2013 [quote name='Sinnababu_Sillyfellow' timestamp='1371758655' post='1303874897'] Jailer bhayya... generic logic question... Database lo 100,000 records unnayi...and screen medha only 200 display cheyyali...with next, next to display next set of records... sorting functionality on records kooda unnayi... How to do it 1) Next click chesinappudu...DB nunchi 200 records techukovaalaaa OR 2) Data antha oke hit lo techukoni. Beans lo populate chesi...next click chesinappudu... action class call chesi...display cheyyalaa? 3) Or vere option emanna undhaaa? Ye approach better? [/quote] normal huge data retrive chese tappudu definete ga slow avuthundi that iss the reason we have BI ,reporting tools, which we can integrate to our web application etc.. how we do in java.. say click on reports.. Step 1 goto Database get the total count and also say first 100 rec(this is parameter driven) display 100 and below tht display page indexes...like 1 2 3 .. so when ever user click on the number...u know the range of data to pull.. like say user click on page 4.. get data from 401 to 500.. in oracle we can do this easily i think same with SQLServer also The big problem is ...providing sorting option on the front end table fields.. for huge data it is a Challenge #2 option pull eniter data and store in XML @back end which is more efficient from xml u can dis play the data Link to comment Share on other sites More sharing options...
cherlapalli_jailer Posted June 20, 2013 Report Share Posted June 20, 2013 @JAINTR Bayya nuvvu wrong time entry ichhavu,,anduke neeku reply fast ga ivvaleka potunna. all of a sudden from y'day thread is very active...or else i would have helped you by now.. connecting Database is very very simple bayya ...just google it ...still in doubt i will definetely guide you Link to comment Share on other sites More sharing options...
geeni83 Posted June 20, 2013 Report Share Posted June 20, 2013 [quote name='cherlapalli_jailer' timestamp='1371762860' post='1303875293'] @JAINTR Bayya nuvvu wrong time entry ichhavu,,anduke neeku reply fast ga ivvaleka potunna. all of a sudden from y'day thread is very active...or else i would have helped you by now.. connecting Database is very very simple bayya ...just google it ...still in doubt i will definetely guide you [/quote] thanks mayya u r helping so much... Link to comment Share on other sites More sharing options...
Recommended Posts