B4J Question [SOLVED] Ultimate Invoice System B4J Web App...Error

J

javiers

Active Member
Licensed User
Longtime User
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:

Log...: 
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...
 
Sort by date Sort by votes
J

javiers

Active Member
Licensed User
Longtime User
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
J

javiers

Active Member
Licensed User
Longtime User
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:

Connection: 
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
You must log in or register to reply here.

Similar Threads

  • Question
B4J Question [ABMaterial] [Web] Inquiry About Developing a Web-Based ERP Application
Replies
5
Views
573
vecino
  • Article
Share My Creation [Web][SithasoDaisy] Revolutionize Your Ride: The Ultimate Vehicle Expense Tracker App using Api Key Secure MySQL REST API on top of HTTPS
Replies
9
Views
3K
Mashiane
  • Question
B4J Question [SOLVED] - Javaobject Problem - JWT with RSA256
Replies
1
Views
4K
hatzisn
  • Article
Share My Creation System of Returns or Surpluses in Administrative Systems Invoice Payments
Replies
1
Views
2K
juangtju
  • Article
Share My Creation [BANanoJsPDFAD] The Ultimate Drag n Drop jsPDF Document Creation Engine
Replies
4
Views
5K
Mashiane
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…