J javiers Active Member Licensed User Longtime User Aug 21, 2021 #1 Hi everyone, refers to the application: Ultimate Invoice System B4J Web App : Source Code I have managed to get the application to connect to the SQLEXPRESS instance on my computer, but when I press the Sign in button I get the following error: Code: Copy Waiting for value (2 ms) Waiting for value (0 ms) ago 21, 2021 7:12:52 PM com.mchange.v2.c3p0.stmt.GooGooStatementCache INFORMACIÓN: Multiply-cached PreparedStatement: select * from UsersInformation where UserEmailAddress=? and UserPassword=? (SQLException) java.sql.SQLException: El nombre de objeto 'UsersInformation' no es válido. Thanks for the help...
Hi everyone, refers to the application: Ultimate Invoice System B4J Web App : Source Code I have managed to get the application to connect to the SQLEXPRESS instance on my computer, but when I press the Sign in button I get the following error: Code: Copy Waiting for value (2 ms) Waiting for value (0 ms) ago 21, 2021 7:12:52 PM com.mchange.v2.c3p0.stmt.GooGooStatementCache INFORMACIÓN: Multiply-cached PreparedStatement: select * from UsersInformation where UserEmailAddress=? and UserPassword=? (SQLException) java.sql.SQLException: El nombre de objeto 'UsersInformation' no es válido. Thanks for the help...
EnriqueGonzalez Expert Licensed User Longtime User Aug 21, 2021 #2 javiers said: El nombre de objeto 'UsersInformation' no es válido. Click to expand... either you connected to the wrong database or the database is empty of tables Upvote 0
javiers said: El nombre de objeto 'UsersInformation' no es válido. Click to expand... either you connected to the wrong database or the database is empty of tables
J javiers Active Member Licensed User Longtime User Aug 22, 2021 #3 Thanks for the reply everyone. I did not know if I should put a new post or if I could send a PM ... I close the post, since I see that it is a personal problem. Upvote 0
Thanks for the reply everyone. I did not know if I should put a new post or if I could send a PM ... I close the post, since I see that it is a personal problem.
J javiers Active Member Licensed User Longtime User Aug 22, 2021 #4 javiers said: Thanks for the reply everyone. I did not know if I should put a new post or if I could send a PM ... I close the post, since I see that it is a personal problem. Click to expand... It is already solved. In case it helps: I am new to this environment of B4J Web application and MS SQL. The problem was in my connection string to the SQLEXPRESS database. This works correctly: Code: Copy pool.Initialize ("net.sourceforge.jtds.jdbc.Driver", "jdbc: jtds: sqlserver: // localhost: 1433 / B4JInvoices", "sa", "12345") It also started the connection with windows authentication, instead of SQL authentication. Note: Congratulations Saif. It is a great app! Upvote 0
javiers said: Thanks for the reply everyone. I did not know if I should put a new post or if I could send a PM ... I close the post, since I see that it is a personal problem. Click to expand... It is already solved. In case it helps: I am new to this environment of B4J Web application and MS SQL. The problem was in my connection string to the SQLEXPRESS database. This works correctly: Code: Copy pool.Initialize ("net.sourceforge.jtds.jdbc.Driver", "jdbc: jtds: sqlserver: // localhost: 1433 / B4JInvoices", "sa", "12345") It also started the connection with windows authentication, instead of SQL authentication. Note: Congratulations Saif. It is a great app!
