Help Get Info From Database to Community

[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.

 

public String 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!!

[TGSLineage2]

1 hour ago, barao45 said:

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.

 

public String 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!!

First it is necessary to know if what you need is to recover one or several values, if you need several then you must add the values of the result in a list but the following form:
while(rs.next()){ list.add(rs.getString("name")); }
And if you only need to retrieve a single value which is what I assume you want to do, you should limit your result to a by placing at the end of your query Limit 1
And you could put your assignment like this:
x = (rs.getString("name") != null) ? rs.getString("name") : "None";

Edited December 25, 2021 by TGSLineage2

[barao45]

Thanks bro!! solved.

[Celestine]

Locked.