Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Console X Main (15) [Java Application] C:Program FilesAdoptOpenJDKjdk-11.0.9.11-hotspotbinjavaw.exe (Oct 9, 2022, 8:36:25 PM - 8:36:26 PM) [pid: 8952] jdbc:sqlserver://csci2469-01.czlyasswa9el.us-east-2.rds.amazonaws.com: 1433; databaseName=PizzaStore; user=rdwr; password=violetApple782; java.sql.SQLException:
Console X Main (15) [Java Application] C:\Program Files\AdoptOpenJDK\jdk-11.0.9.11-hotspot\bin\javaw.exe (Oct 9, 2022, 8:36:25 PM - 8:36:26 PM) [pid: 8952] jdbc:sqlserver://csci2469-01.czlyasswa9el.us-east-2.rds.amazonaws.com: 1433; databaseName=PizzaStore; user=rdwr; password=violetApple782; java.sql.SQLException: No suitable driver found for jdbc: sqlserver://csci2469-01.czlyasswa9el.us-east-2.rds.amazonaws.com: 1433; databaseName=PizzaStore; user=rdwr; password=violetApple782; at java.sql/java.sql.DriverManager.getConnection (DriverManager.java:702) at java.sql/java.sql.DriverManager.getConnection (DriverManager.java:251) at edu.cscc.PizzaStore.createOrdersTable (PizzaStore.java:48) at edu.cscc.Main.main(Main.java:27) No suitable driver found for Cannot create orders table jdbc:sqlserver://csci2469-01.czlyasswa9e1.us-east-2.rds.amazonaws.com: 1433; databaseName=PizzaStore; user=rdwr; password=violetApple782; X SQLQuery1.sql-csc...zzaStore (rdwr (63)) X 100 % 1 2 3 4 5 6 /****** Script for SelectTopNRows command from SSMS SELECT TOP (1000) [id] [quantity] >[orderDate] [size] [type] 1 1 [toppings] FROM [PizzaStore]. [dbo] [batanglaot_Orders] Results Messages id quantity orderDate 1 2 3 1 4 1 5 5 6 1 11/04/2019 03:07:38 PM 11/04/2019 03:07:38 PM 11/04/2019 03:07:38 PM 11/04/2019 03:07:38 PM 11/04/2019 03:07:38 PM 11/04/2019 03:07:38 PM Example Output Screenshot of SQL Server Management Studio Query executed successfully. size MEDIUM LARGE SMALL MEDIUM LARGE MEDIUM ******/ type toppings REGULAR CHEESE DEEPDISH NOCRUST VEGGIE THIN REGULAR NOCRUST PEPPERONI PEPPERONI CARNIVORE VEGGIE csci2469-01.czlyasswa9el.us... rdwr (63) PizzaStore 00:00:00 6 rows
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started