Hello! i'm trying to show info from database into CommunityBoard. I would like to show, if the clan has ClanHall or Fortress, etc. I write this but its getting an error and i dont know why.
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:781)
at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5239)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5162)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5201)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
at l2r.gameserver.model.L2Clan.getHideOutName(L2Clan.java:3014)
at l2r.gameserver.communitybbs.Managers.ClanBBSManager.clanhome(ClanBBSManager.java:253)
at l2r.gameserver.communitybbs.Managers.ClanBBSManager.clanhome(ClanBBSManager.java:234)
at l2r.gameserver.communitybbs.Managers.ClanBBSManager.cbByPass(ClanBBSManager.java:50)
at l2r.gameserver.communitybbs.BoardsManager.handleCommands(BoardsManager.java:80)
at l2r.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:251)
at l2r.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:71)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
This is the backEnd.
publicString getHideOutName(int ownerId){String x = null;try(Connection con = L2DatabaseFactory.getInstance().getConnection();PreparedStatement ps = con.prepareStatement("SELECT DISTINCT name FROM `clanhall` cl INNER JOIN `clan_data` c ON cl.ownerId = ?");){
ps.setInt(1, ownerId);ResultSet rs = ps.executeQuery();
x = rs.getString("name");}catch(SQLException e){// TODO Auto-generated catch block
e.printStackTrace();}if(x == null){return"None";}return x;}
Please, someone can give me a hand with this?.
Thanks!!
I already explain it to You - I can finish the job, send You the files, or if You don't like that, I can refund 50%, because I did start the work. The flood made it impossible for me to deliver on time, but I did start the work.
You asking me to send You 150% of Your payment. That's not possible. Flood wasn't by my doing, I'm not guilty here. I'm trying to be reasonable with You - deliverying the files (You are not willing to send me missing details for updater) or refunding 50%. Telling me to shup to, calling me an idiot and sending threats won't speed anything up.
GOT BACK TO WORK! Deliverying past commissions, taking new ones!
Question
barao45
Hello! i'm trying to show info from database into CommunityBoard. I would like to show, if the clan has ClanHall or Fortress, etc. I write this but its getting an error and i dont know why.
java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:781) at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5239) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5162) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5201) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) at l2r.gameserver.model.L2Clan.getHideOutName(L2Clan.java:3014) at l2r.gameserver.communitybbs.Managers.ClanBBSManager.clanhome(ClanBBSManager.java:253) at l2r.gameserver.communitybbs.Managers.ClanBBSManager.clanhome(ClanBBSManager.java:234) at l2r.gameserver.communitybbs.Managers.ClanBBSManager.cbByPass(ClanBBSManager.java:50) at l2r.gameserver.communitybbs.BoardsManager.handleCommands(BoardsManager.java:80) at l2r.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:251) at l2r.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:71) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
This is the backEnd.
Please, someone can give me a hand with this?.
Thanks!!
Link to comment
Share on other sites
3 answers to this question
Recommended Posts