My application generates table names based on a client identification. For instance, when I add a new client and assign a number, I generate tables basedo on the client ID. For instance, if I create a new client with ID=1234, then I will have a table "client123info".
Now if I want to use a PreparedStatement, I cannot do the following:
PreparedStatement ps = connection.prepareStatement( "select * from client?info");
because the SQL ends up looking like this:
select * from client'1234'info
So what can I do?
Thanks.