Styjun

Sinning and G-d's will, what's wrong with this logic?

1kV DC Circuit - Insulation on ground wire?

Was the lunar landing site always in the same plane as the CM's orbit?

Round away from zero

Why is Sojdlg123aljg a common password?

In apex, how to replace the value in the string

What's in a druid's grove?

Looking for the comic book where Spider-Man was [mistakenly] addressed as Super-Man

What do English-speaking kids call ice-cream on a stick?

Connect the wires without setting off the bomb

What makes an ending "happy"?

Why are UK MPs allowed to not vote (but it counts as a no)?

Entering the US with dual citizenship but US passport is long expired?

What quests do you need to stop at before you make an enemy of a faction for each faction?

Can taking my 1-week-old on a 6-7 hours journey in the car lead to medical complications?

Is it right to use the ideas of non-winning designers in a design contest?

I won a car in a poker game. How is that taxed in Canada?

How does the UK House of Commons think they can prolong the deadline of Brexit?

Why did Boris Johnson call for new elections?

Supervisor wants me to support a diploma-thesis SW tool after I graduated

What is the justification for Dirac's large numbers hypothesis?

How can I hint that my character isn't real?

First Number to Contain Each Letter

Can you create water inside someone's mouth?

I am trying to execute a sql query using prepared statement but it is returning empty value

Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeCan I concatenate multiple MySQL rows into one field?Inserting multiple rows in a single SQL query?How do I limit the number of rows returned by an Oracle query after ordering?When should I use cross apply over inner join?How can I do an UPDATE statement with JOIN in SQL?Finding duplicate values in a SQL tableNested select statement in SQL ServerSQL select only rows with max value on a column

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

1

String sql = "select s_upload_file.NEXTVAL from dual" ;
PreparedStatement ps = con.preparedStatement(sql);
ResultSet rs = ps.executeQuery();

While execute this I get result set as empty. What is the issue with this..

java sql oracle

share|improve this question

edited Mar 28 at 5:19

Vignesh Murugesan

asked Mar 28 at 5:13

Vignesh MurugesanVignesh Murugesan

333 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what is s_upload_file.nextvalue ?
  
  – Akash Shah
  Mar 28 at 5:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Upload_file is a table name and it has a sequence number column here I am trying to access it by pseudocolumn .. sorry its Nextval I had edited
  
  – Vignesh Murugesan
  Mar 28 at 5:20
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Its running directly... Could you suggest a way to find the next value of the sequence number column in db?
  
  – Vignesh Murugesan
  Mar 28 at 5:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you go through rs.next()?
  
  – Hasitha M Jayawardana
  Mar 28 at 5:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks hasitha I got the value when iterate through RS.next()..
  
  – Vignesh Murugesan
  Mar 28 at 5:35
  

  
  
  
  

 | 
show 1 more comment

0

1

String sql = "select s_upload_file.NEXTVAL from dual" ;
PreparedStatement ps = con.preparedStatement(sql);
ResultSet rs = ps.executeQuery();

While execute this I get result set as empty. What is the issue with this..

java sql oracle

share|improve this question

edited Mar 28 at 5:19

Vignesh Murugesan

asked Mar 28 at 5:13

Vignesh MurugesanVignesh Murugesan

333 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what is s_upload_file.nextvalue ?
  
  – Akash Shah
  Mar 28 at 5:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Upload_file is a table name and it has a sequence number column here I am trying to access it by pseudocolumn .. sorry its Nextval I had edited
  
  – Vignesh Murugesan
  Mar 28 at 5:20
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Its running directly... Could you suggest a way to find the next value of the sequence number column in db?
  
  – Vignesh Murugesan
  Mar 28 at 5:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you go through rs.next()?
  
  – Hasitha M Jayawardana
  Mar 28 at 5:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks hasitha I got the value when iterate through RS.next()..
  
  – Vignesh Murugesan
  Mar 28 at 5:35
  

  
  
  
  

 | 
show 1 more comment

String sql = "select s_upload_file.NEXTVAL from dual" ;
PreparedStatement ps = con.preparedStatement(sql);
ResultSet rs = ps.executeQuery();

While execute this I get result set as empty. What is the issue with this..

java sql oracle

share|improve this question

edited Mar 28 at 5:19

Vignesh Murugesan

asked Mar 28 at 5:13

Vignesh MurugesanVignesh Murugesan

333 bronze badges

String sql = "select s_upload_file.NEXTVAL from dual" ;
PreparedStatement ps = con.preparedStatement(sql);
ResultSet rs = ps.executeQuery();

share|improve this question

edited Mar 28 at 5:19

Vignesh Murugesan

asked Mar 28 at 5:13

Vignesh MurugesanVignesh Murugesan

333 bronze badges

share|improve this question

edited Mar 28 at 5:19

Vignesh Murugesan

asked Mar 28 at 5:13

Vignesh MurugesanVignesh Murugesan

333 bronze badges

asked Mar 28 at 5:13

Vignesh MurugesanVignesh Murugesan

333 bronze badges

asked Mar 28 at 5:13

Vignesh MurugesanVignesh Murugesan

333 bronze badges

4 Answers
4

active

oldest

votes

0

you should try something like this,

 String sql = "select s_upload_file.NEXTVAL from dual" ;
 PreparedStatement ps = con.prepareStatement(sql);
 ResultSet rs = ps.executeQuery();
 if (rs.next())
 
 int var2= rs.getInt(1);
 

share|improve this answer

edited Mar 28 at 8:15

a_horse_with_no_name

331k5454 gold badges515515 silver badges609609 bronze badges

answered Mar 28 at 7:03

Ajith DeivamAjith Deivam

12244 silver badges1717 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Please post code that makes sense and compiles
  
  – Joakim Danielson
  Mar 28 at 7:07
  

  
  
  
  

add a comment | 

1

There are many answers already, but I will try to give you a full scope of the answer.

public static Connection getConnection_Test() throws Exception

 try

 String driver = "com.mysql.cj.jdbc.Driver";
 String url = "jdbc:mysql://localhost:3306/Database_Name";
 String username = "root";
 String pass = "";
 Class.forName(driver);

 Connection conn = DriverManager.getConnection(url, username, pass);
 System.out.println("Success!");

 String query = "SELECT S_UPLOAD_FILE.NEXTVAL from dual n ";

 PreparedStatement st = conn.prepareStatement(query);
 ResultSet rs = st.executeQuery();
 while(rs.next())
 int NEXTVALUE = rs.getInt(1);
 System.out.println(NEXTVALUE);

 
 rs.close();
 st.close(); 

 return conn;
 catch (Exception e)
 System.out.println(e);
 


 return null;

share|improve this answer

answered Mar 28 at 10:34

Aris MistAris Mist

7144 bronze badges

add a comment | 

0

You can get values through rs.next(),

String sql = "select s_upload_file.NEXTVAL from dual";
PreparedStatement pst = conn.prepareStatement(sql);
synchronized( this ) 
 ResultSet rs = pst.executeQuery();
 if(rs.next())
 long nxtVal = rs.getLong(1);

share|improve this answer

answered Mar 28 at 5:38

Hasitha M JayawardanaHasitha M Jayawardana

1,49222 gold badges99 silver badges2626 bronze badges

add a comment | 

0

Have you tried something like this?

/* not mandatory but give an alias to your column in select */
if(rs.next())
 int nextval = rs.getInt(1);
 System.out.println(nextval)

share|improve this answer

answered Mar 28 at 5:39

GroGro

82166 silver badges1313 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55390595%2fi-am-trying-to-execute-a-sql-query-using-prepared-statement-but-it-is-returning%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

you should try something like this,

 String sql = "select s_upload_file.NEXTVAL from dual" ;
 PreparedStatement ps = con.prepareStatement(sql);
 ResultSet rs = ps.executeQuery();
 if (rs.next())
 
 int var2= rs.getInt(1);
 

share|improve this answer

edited Mar 28 at 8:15

a_horse_with_no_name

331k5454 gold badges515515 silver badges609609 bronze badges

answered Mar 28 at 7:03

Ajith DeivamAjith Deivam

12244 silver badges1717 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Please post code that makes sense and compiles
  
  – Joakim Danielson
  Mar 28 at 7:07
  

  
  
  
  

add a comment | 

0

you should try something like this,

 String sql = "select s_upload_file.NEXTVAL from dual" ;
 PreparedStatement ps = con.prepareStatement(sql);
 ResultSet rs = ps.executeQuery();
 if (rs.next())
 
 int var2= rs.getInt(1);
 

share|improve this answer

edited Mar 28 at 8:15

a_horse_with_no_name

331k5454 gold badges515515 silver badges609609 bronze badges

answered Mar 28 at 7:03

Ajith DeivamAjith Deivam

12244 silver badges1717 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Please post code that makes sense and compiles
  
  – Joakim Danielson
  Mar 28 at 7:07
  

  
  
  
  

add a comment | 

you should try something like this,

 String sql = "select s_upload_file.NEXTVAL from dual" ;
 PreparedStatement ps = con.prepareStatement(sql);
 ResultSet rs = ps.executeQuery();
 if (rs.next())
 
 int var2= rs.getInt(1);
 

share|improve this answer

edited Mar 28 at 8:15

a_horse_with_no_name

331k5454 gold badges515515 silver badges609609 bronze badges

answered Mar 28 at 7:03

Ajith DeivamAjith Deivam

12244 silver badges1717 bronze badges

 String sql = "select s_upload_file.NEXTVAL from dual" ;
 PreparedStatement ps = con.prepareStatement(sql);
 ResultSet rs = ps.executeQuery();
 if (rs.next())
 
 int var2= rs.getInt(1);
 

share|improve this answer

edited Mar 28 at 8:15

a_horse_with_no_name

331k5454 gold badges515515 silver badges609609 bronze badges

answered Mar 28 at 7:03

Ajith DeivamAjith Deivam

12244 silver badges1717 bronze badges

edited Mar 28 at 8:15

a_horse_with_no_name

331k5454 gold badges515515 silver badges609609 bronze badges

edited Mar 28 at 8:15

a_horse_with_no_name

331k5454 gold badges515515 silver badges609609 bronze badges

answered Mar 28 at 7:03

Ajith DeivamAjith Deivam

12244 silver badges1717 bronze badges

answered Mar 28 at 7:03

Ajith DeivamAjith Deivam

12244 silver badges1717 bronze badges

1

There are many answers already, but I will try to give you a full scope of the answer.

public static Connection getConnection_Test() throws Exception

 try

 String driver = "com.mysql.cj.jdbc.Driver";
 String url = "jdbc:mysql://localhost:3306/Database_Name";
 String username = "root";
 String pass = "";
 Class.forName(driver);

 Connection conn = DriverManager.getConnection(url, username, pass);
 System.out.println("Success!");

 String query = "SELECT S_UPLOAD_FILE.NEXTVAL from dual n ";

 PreparedStatement st = conn.prepareStatement(query);
 ResultSet rs = st.executeQuery();
 while(rs.next())
 int NEXTVALUE = rs.getInt(1);
 System.out.println(NEXTVALUE);

 
 rs.close();
 st.close(); 

 return conn;
 catch (Exception e)
 System.out.println(e);
 


 return null;

share|improve this answer

answered Mar 28 at 10:34

Aris MistAris Mist

7144 bronze badges

add a comment | 

1

There are many answers already, but I will try to give you a full scope of the answer.

public static Connection getConnection_Test() throws Exception

 try

 String driver = "com.mysql.cj.jdbc.Driver";
 String url = "jdbc:mysql://localhost:3306/Database_Name";
 String username = "root";
 String pass = "";
 Class.forName(driver);

 Connection conn = DriverManager.getConnection(url, username, pass);
 System.out.println("Success!");

 String query = "SELECT S_UPLOAD_FILE.NEXTVAL from dual n ";

 PreparedStatement st = conn.prepareStatement(query);
 ResultSet rs = st.executeQuery();
 while(rs.next())
 int NEXTVALUE = rs.getInt(1);
 System.out.println(NEXTVALUE);

 
 rs.close();
 st.close(); 

 return conn;
 catch (Exception e)
 System.out.println(e);
 


 return null;

share|improve this answer

answered Mar 28 at 10:34

Aris MistAris Mist

7144 bronze badges

add a comment | 

There are many answers already, but I will try to give you a full scope of the answer.

public static Connection getConnection_Test() throws Exception

 try

 String driver = "com.mysql.cj.jdbc.Driver";
 String url = "jdbc:mysql://localhost:3306/Database_Name";
 String username = "root";
 String pass = "";
 Class.forName(driver);

 Connection conn = DriverManager.getConnection(url, username, pass);
 System.out.println("Success!");

 String query = "SELECT S_UPLOAD_FILE.NEXTVAL from dual n ";

 PreparedStatement st = conn.prepareStatement(query);
 ResultSet rs = st.executeQuery();
 while(rs.next())
 int NEXTVALUE = rs.getInt(1);
 System.out.println(NEXTVALUE);

 
 rs.close();
 st.close(); 

 return conn;
 catch (Exception e)
 System.out.println(e);
 


 return null;

share|improve this answer

answered Mar 28 at 10:34

Aris MistAris Mist

7144 bronze badges

public static Connection getConnection_Test() throws Exception

 try

 String driver = "com.mysql.cj.jdbc.Driver";
 String url = "jdbc:mysql://localhost:3306/Database_Name";
 String username = "root";
 String pass = "";
 Class.forName(driver);

 Connection conn = DriverManager.getConnection(url, username, pass);
 System.out.println("Success!");

 String query = "SELECT S_UPLOAD_FILE.NEXTVAL from dual n ";

 PreparedStatement st = conn.prepareStatement(query);
 ResultSet rs = st.executeQuery();
 while(rs.next())
 int NEXTVALUE = rs.getInt(1);
 System.out.println(NEXTVALUE);

 
 rs.close();
 st.close(); 

 return conn;
 catch (Exception e)
 System.out.println(e);
 


 return null;

share|improve this answer

answered Mar 28 at 10:34

Aris MistAris Mist

7144 bronze badges

answered Mar 28 at 10:34

Aris MistAris Mist

7144 bronze badges

answered Mar 28 at 10:34

Aris MistAris Mist

7144 bronze badges

0

You can get values through rs.next(),

String sql = "select s_upload_file.NEXTVAL from dual";
PreparedStatement pst = conn.prepareStatement(sql);
synchronized( this ) 
 ResultSet rs = pst.executeQuery();
 if(rs.next())
 long nxtVal = rs.getLong(1);

share|improve this answer

answered Mar 28 at 5:38

Hasitha M JayawardanaHasitha M Jayawardana

1,49222 gold badges99 silver badges2626 bronze badges

add a comment | 

0

You can get values through rs.next(),

String sql = "select s_upload_file.NEXTVAL from dual";
PreparedStatement pst = conn.prepareStatement(sql);
synchronized( this ) 
 ResultSet rs = pst.executeQuery();
 if(rs.next())
 long nxtVal = rs.getLong(1);

share|improve this answer

answered Mar 28 at 5:38

Hasitha M JayawardanaHasitha M Jayawardana

1,49222 gold badges99 silver badges2626 bronze badges

add a comment | 

You can get values through rs.next(),

String sql = "select s_upload_file.NEXTVAL from dual";
PreparedStatement pst = conn.prepareStatement(sql);
synchronized( this ) 
 ResultSet rs = pst.executeQuery();
 if(rs.next())
 long nxtVal = rs.getLong(1);

share|improve this answer

answered Mar 28 at 5:38

Hasitha M JayawardanaHasitha M Jayawardana

1,49222 gold badges99 silver badges2626 bronze badges

String sql = "select s_upload_file.NEXTVAL from dual";
PreparedStatement pst = conn.prepareStatement(sql);
synchronized( this ) 
 ResultSet rs = pst.executeQuery();
 if(rs.next())
 long nxtVal = rs.getLong(1);

share|improve this answer

answered Mar 28 at 5:38

Hasitha M JayawardanaHasitha M Jayawardana

1,49222 gold badges99 silver badges2626 bronze badges

answered Mar 28 at 5:38

Hasitha M JayawardanaHasitha M Jayawardana

1,49222 gold badges99 silver badges2626 bronze badges

answered Mar 28 at 5:38

Hasitha M JayawardanaHasitha M Jayawardana

1,49222 gold badges99 silver badges2626 bronze badges

0

Have you tried something like this?

/* not mandatory but give an alias to your column in select */
if(rs.next())
 int nextval = rs.getInt(1);
 System.out.println(nextval)

share|improve this answer

answered Mar 28 at 5:39

GroGro

82166 silver badges1313 bronze badges

add a comment | 

0

Have you tried something like this?

/* not mandatory but give an alias to your column in select */
if(rs.next())
 int nextval = rs.getInt(1);
 System.out.println(nextval)

share|improve this answer

answered Mar 28 at 5:39

GroGro

82166 silver badges1313 bronze badges

add a comment | 

Have you tried something like this?

/* not mandatory but give an alias to your column in select */
if(rs.next())
 int nextval = rs.getInt(1);
 System.out.println(nextval)

share|improve this answer

answered Mar 28 at 5:39

GroGro

82166 silver badges1313 bronze badges

/* not mandatory but give an alias to your column in select */
if(rs.next())
 int nextval = rs.getInt(1);
 System.out.println(nextval)

share|improve this answer

answered Mar 28 at 5:39

GroGro

82166 silver badges1313 bronze badges

answered Mar 28 at 5:39

GroGro

82166 silver badges1313 bronze badges

answered Mar 28 at 5:39

GroGro

82166 silver badges1313 bronze badges